Re: CF4K was Re: Macromedia listening? is RE: ColdFusion for kids

2002-12-07 Thread Jochem van Dieten
Stacy Young wrote: > I think it's cool...schools here teach office starting in grade 7 or less... Q: Can you spell? A: F7 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.ho

Re: CF4K was Re: Macromedia listening? is RE: ColdFusion for kids

2002-12-08 Thread Jochem van Dieten
Dick Applebaum wrote: > > Are you saying that while the CFMX approach is good enough for you and > I to use,it is not good enough for our kids? I am saying that the HTML approach is a necessary evil nowadays. But we are supposed to be educating these kids for the future, so we might just as we

Re: Request for testing a possible bug

2002-12-08 Thread Jochem van Dieten
Jim Davis wrote: > > http://www.depressedpress.com/test/threadidbug/ Telnet shows the response to both is equal. I think you need to file a bug with Microsoft. Good luck. Jochem GET /test/threadidbug/WithoutThreadID.cfm HTTP/1.1 Host: www.depressedpress.com HTTP/1.1 302 Moved Temporarily Ser

Re: Default CF page loading error! HELP!

2002-12-08 Thread Jochem van Dieten
Josh Ford wrote: > This is a multi-part message in MIME format. > > --=_NextPart_000_0033_01C29E9D.43879BD0 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable Please, plain text. > ISSUE: since last week, we now have 3 sites that have inde

Re: Updating two fields

2002-12-09 Thread Jochem van Dieten
Quoting FlashGuy <[EMAIL PROTECTED]>: > > I need to update two fields in my database. For example, I have two > fields called "data1" and "data2". THe below code updates only > "data1" field. > Whats the correct syntax to also update "data2" field at the same > time? http://livedocs.macromedia.co

Re: Character Encoding Problem in CFMX

2002-12-10 Thread Jochem van Dieten
Farkhad Mousaev wrote: > > I'm just curious to know if anybody experiencing character encoding problems with >CFMX? Depends on what you call a problem. I never had anything that wasn't correctable by adding the right tags. But not using Access and using unicode for everything goes a long way.

Re: CFC output

2002-12-10 Thread Jochem van Dieten
Matt Liotta wrote: > > Certainly HTML can be useful inside of Flash for rich formatted text. > However, it seems to make more sense to create this HTML inside of a > Flash component then a CFC. Depends. If you are building a BBML-based forum that is supposed to work with both Flash and browsers.

Re: Character Encoding Problem in CFMX

2002-12-10 Thread Jochem van Dieten
[resending, haven't received it in over 3 hours, sorry if double] Farkhad Mousaev wrote: > > Well, thank you for sounding optimistic, but believe me it is a real headache for >people who use Russian charset on CFMX. > CFMX doesn't recognize the following Cyrillic encodings 1251, ISO 8859-5,iso

RE: Another Newbie Problem

2002-12-11 Thread Jochem van Dieten
Quoting [EMAIL PROTECTED]: > > We have several thousand records in a db with a standard odbc > datetime stamp column. We want to be able to filter out end of month > statistics (all trouble calls in November, 2002, for instance) by > using a set of drop down menus (month, year, type of call).

Re: Another Newbie Problem

2002-12-11 Thread Jochem van Dieten
Dina Hess wrote: > Well, Jochem, has already given you some valuable information but since > Month() and Year() are standard SQL functions Maybe they work in some non-standard implementation, but that does not make them standard functions. There is no reference to a Month() or a Year() function

Re: Component Conceptual Conundrum - Continued

2002-12-11 Thread Jochem van Dieten
Raymond Camden wrote: > Isn't that IE only? (Not that it's a big deal - but just checking.) No, Mozilla has it as well: http://www.mozilla.org/xmlextras/ Mozilla is even going one step further and is including native database capabilities: http://bugzilla.mozilla.org/show_bug.cgi?id=81653 Joche

Re: How to change this query from MS Access to MySQL Query

2002-12-11 Thread Jochem van Dieten
Rick Faircloth wrote: > > How should I change this to make it work? > Is it a subquery problem? > This is MySQL version 4.0.5 beta... > > > Select * from Units U where U.UnitID > in (Select UnitID from Clients where Clients.ClientID > = #App_ClientID#) >

Re: Another Newbie Problem

2002-12-12 Thread Jochem van Dieten
Dina Hess wrote: > > Actually, any attempt to apply the word "standard" to the many flavors of SQL >probably *is* questionable. :) Not at all. There have been official SQL standards since 1987. You seem to confuse the lack of conforming implementations with the absence of a standard. > But I

Re: IIS on WinXP Pro

2002-12-12 Thread Jochem van Dieten
Quoting Steven Wojciechowski <[EMAIL PROTECTED]>: > > I came across the same problem > I just change the directory that IIS points to depending on which > site I am working on. I don't have much need to work on more than one > site at a time so this works for me. http://pub9.ezboard.com/fcoolpcfr

Re: IIS on WinXP Pro

2002-12-12 Thread Jochem van Dieten
Quoting James Smith <[EMAIL PROTECTED]>: > > Slightly off topic, but what do people use Cygwin for? It is all good > fun as a toy but what practical applications does it have? I have used it for: - OpenSSH - PostgreSQL - lynx And various small command line tools like tail, bzip2 etc. Don't know h

Re: OT-Another quick question- float datatype

2002-12-12 Thread Jochem van Dieten
Quoting Janine Jakim <[EMAIL PROTECTED]>: > > I'm pulling from a DB4 db and dumping into a SQL db > Most of their numbers from the DB2 are formatted as float. > i remember being told to stay away from "float" as a datatype.Should > I make the datatype in the sql an integer instead? What does the

Re: IIS on WinXP Pro

2002-12-12 Thread Jochem van Dieten
Quoting James Smith <[EMAIL PROTECTED]>: > >>> Slightly off topic, but what do people use Cygwin for? It is all >>> good fun as a toy but what practical applications does it have? >> >> I have used it for: >> - OpenSSH >> - PostgreSQL >> - lynx > > All of those are available for Win32 anyway thou

RE: OT-Another quick question- float datatype

2002-12-12 Thread Jochem van Dieten
Quoting Janine Jakim <[EMAIL PROTECTED]>: > > The data is generally an id of some sort- teacherid/etc. An integer (or at least an exact numeric) should be fine. Frankly, I am a bit surprised that they used an approximate numeric for an ID, which typically is something you use as PK/FK. Jochem ~~

Re: CFPOP and undeliverable mail

2002-12-12 Thread Jochem van Dieten
Quoting Luis Lebron <[EMAIL PROTECTED]>: > > From: System Administrator - To: Luis Lebron Subject: Undeliverable: > Test > message -Date Thu, 12 Dec 2002 07:44:24 -0600 Body: Your message > To: > '[EMAIL PROTECTED]' Subject: Test message Sent: Thu, 12 Dec 2002 > 07:44:12 > -0600 did not reach the

Re: SQLException occurred in JDBCPool

2002-12-12 Thread Jochem van Dieten
Quoting Joshua Miller <[EMAIL PROTECTED]>: > > Anyone know what may have caused these errors? I've got a few > scheduled tasks that run at 2:00am, 2:15am and 2:30am and they all > threw this same exception: SQLException occurred in JDBCPool > > When I went to the server today and ran the tasks t

Re: CFC's in the application Scope

2002-12-12 Thread Jochem van Dieten
Quoting [EMAIL PROTECTED]: > > If I stored a component instance in the application scope: > > "application.ComponentInstance.lfInsertData"> > > Would I need to lock each usage of it, when used like this component="#application.ComponentInstance.lfInsertData#"> Only against race conditions

Updater 2 & coldfusion.server.ServiceFactory.SecurityService

2002-12-12 Thread Jochem van Dieten
One of the changes in Updater 2 is: The ColdFusion Service Factory class could be instantiated in CFML and used to get to a Security service. 47545 Is there any way I can get the old behaviour back? I don't think this change is particularly usefull anyway, and I am not happy having to recode

Re: CFMX in shared hosting environment

2002-12-12 Thread Jochem van Dieten
Bryan Stevenson wrote: > > A local ISP has just sent this to all it's customers after an upgrade from > CF 4.5 to CFMX. Can anybody confirm that CFMX is not to be used in a shared > hosting environment? Mike C. and other MM folks on list?? They might comment, but I doubt it will be in an officia

Re: CFMX in shared hosting environment

2002-12-12 Thread Jochem van Dieten
Craig Thomas wrote: > > This is not directly related to stability, but I am wondering if you, or > anyone, knows if enabling objects ( or createObject) in a hosted > CFMX environment is safe. NO!!! The cfobject, createobject(), cfexecute and cfregistry (windows only) provided with CF MX are not

Re: Naming Help tblShoutOuts ?

2002-12-12 Thread Jochem van Dieten
Luce, Greg wrote: > What's another word for "contact". http://thesaurus.reference.com/search?q=contact Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_

Re: Updater 2 woes

2002-12-12 Thread Jochem van Dieten
Rob Rohan wrote: > Has anyone seen this error after installing updater 2? > > JRun Servlet Error > 500 coldfusion.tagext.lang.SettingTag.setRequestTimeout(J)V > coldfusion.tagext.lang.SettingTag.setRequestTimeout(J)V > > Any suggestions as to what could cause this error? Using cfsetting to set a

Re: cf5 and mx both on iis

2002-12-12 Thread Jochem van Dieten
Matt Bathje wrote: > > I just today figured out how to run CF5 and CFMX both on the same W2K > machine both using IIS (but on different ports). Right now I have CF5 > running on IIS port 80, and CFMX running on IIS port 90 (it is not > running on the CFMX standalone webserver) > > Is anybody inte

Re: SOT: Found Some Code which Will Kill CF (Was: Pure Virtual Functi on Call)

2002-12-12 Thread Jochem van Dieten
Haggerty, Mike wrote: > > The solution was a ultimately a tricky one; I ended up upgrading the CF4.5.0 > box to CF5 and found I was able to eliminate 99% of the problems. But > performance was still sub-optimal, and there was one page that was popping > up on my error logs intermittently. > > >

Re: which cf-templates runs too long ??

2002-12-12 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote: > > "Warning","1836","11/09/02","03:15:25",,"Template: , Ran: xx seconds." > > Unfortunately CF doesn't show in the log which template ran xx seconds. > Ideas how to find that out ? In the debug options, enable displaying the template name. Jochem ~~

Re: CFMX and page encoding

2002-12-13 Thread Jochem van Dieten
Fuzion - CFTalk wrote: > No matter what I do, I cannot seem to get a page running under CFMX to > encode other than UTF.. Anyone else had this problem? Not with the correct setup. Please provide the relevant information: http://www.houseoffusion.com/lists.cfm?link=m:4:16383:84497 Jochem ~~~

Re: Login/Password screen

2002-12-13 Thread Jochem van Dieten
Quoting FlashGuy <[EMAIL PROTECTED]>: > > I know there are alot of custom tags out there that will do what I'm > looking for but I want the best one. So this is why I'm asking all of > you hoping you've had some experience with some of them. I'd like > everything stored in a database. I know some

Re: Login/Password screen

2002-12-13 Thread Jochem van Dieten
Quoting FlashGuy <[EMAIL PROTECTED]>: > On Fri, 13 Dec 2002 13:48:25 +0100, Jochem van Dieten wrote: > > > Can you post a full list of requirements? > > - validate users > - database for authenitcation > - redirection to different URLS on server based on authentic

Re: Happy story with updater2?

2002-12-13 Thread Jochem van Dieten
Quoting "Earl, George" <[EMAIL PROTECTED]>: > > Do we have any happy stories from people who have installed updater2 > for CFMX? What would you consider a happy story? For me, it does what the release notes say it will do. But that doesn't make me very excited about it. Jochem ~

RE: Login/Password screen

2002-12-13 Thread Jochem van Dieten
Quoting Steve Reich <[EMAIL PROTECTED]>: > Here's the basic concept... > > You have a login page. The user puts their username and password in > and it submits to an action page that checks to see if they are a > user. Why a login page? Why an action page? You can also make every page a login p

RE: Login/Password screen

2002-12-13 Thread Jochem van Dieten
Quoting Craig Dudley <[EMAIL PROTECTED]>: > > Create a session variable, set it to 0, and after every failed > login attempt increment it by 1, if it reaches 3, don't show the login > screen but a locked out screen instead. After their session times out, > they will be able to try again however.

Re: Session Variables (was Login/Password screen)

2002-12-13 Thread Jochem van Dieten
Quoting Andy Ousterhout <[EMAIL PROTECTED]>: > > What do you mean, maintained on the client? The client has to send the CFID and CFToken. If the client doesn't do that, the server will not be able to associate the appropriate session variables with the client request. That is not a problem when

Re: What does U2 actually update?

2002-12-13 Thread Jochem van Dieten
Quoting Matthew Small <[EMAIL PROTECTED]>: > > So what problems is U2 reported to fix? COM Release notes. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion

RE: What does U2 actually update?

2002-12-13 Thread Jochem van Dieten
Quoting "Robertson-Ravo, Neil (RX)" : > someones in a grumpy mood :-) Apart from the obviousness, the answer had been sent less than an hour before: - Original message - Date: Fri, 13 Dec 2002 14:36:07 +0100 Subject: Re: Happy story with updater2? For me, it does what the release notes

Re: Session Variables (was Login/Password screen)

2002-12-13 Thread Jochem van Dieten
Andy Ousterhout wrote: > Ok, let me restate to be sure that I understand... > > The security issue for counting login attempts is that a User can continue > attempts so long as they remove CFID & Token from the URL and turning off / > deleting cookies. This can be countered by: > > 1. Tracking

Re: Session Variables (was Login/Password screen)

2002-12-13 Thread Jochem van Dieten
Kola Oyedeji wrote: > I think I've been down this path before. I'm not sure if this is still > the case but in some instances such as AOL browsers, user's can actually > have a different IP address per request. As I said that was a while ago > so I'm not sure if that still stands. Can anyone confir

Re: CFFILE error:formfield File does not contain a file

2002-12-13 Thread Jochem van Dieten
Angel Stewart wrote: > > The form field "FILE" did not contain a file. > > The Error Occurred in E:\webs\theenergyguide\postresume.cfm: line 9 > > 7 : > 8 : > 9 :filefield="form.fuckingfile" > 10 : destination="e:\webs\energyguide

Re: What does U2 actually update?

2002-12-13 Thread Jochem van Dieten
Matthew Small wrote: > If you don't want to answer a question - then don't. No reason to be a > jerk about it. RTFM, RTFRN, STFW and STFA is being a jerk. Copy-pasting the entire list of fixes so the archives get screwed up is being a jerk. Pointing you to the release notes is not. Jochem ~~

Re: Can't Reach the Updater 2

2002-12-13 Thread Jochem van Dieten
Ryan Kime wrote: > OKgot sick of the cookie bull. Here's the address of the actual > download (I think)...can someone verify that this is the U2? Our http usage > is monitored here and I don't want to waste 17 MB of my quota if it's not > the right one. :P Crazy place :-) > http://downlo

Re: CFFILE error:formfield File does not contain a file

2002-12-13 Thread Jochem van Dieten
Angel Stewart wrote: > > The processing Code: > > > > > > destination="e:\webs\theenergyguide\resumes\" > nameconflict="makeunique"> Change form.rfile to rfile? Jochem ~

Re: Running CF as a specific user

2002-12-13 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote: > > (R)read > (C)hange > (Write) > E(X)ecute > > What does Add translate to? Write on directories and nothing on files. Dont forget to set the Creator/Owner to at least Change in that case. Jochem ~|

Re: Page is Loading message...

2002-12-14 Thread Jochem van Dieten
Dave Babbitt wrote: > > > > document.all.PleaseWaitMessage.style.display='none'; > That is a MS'ism that won't work in other browsers, the standard way is to use getElementById(). If you must support non-conforming browsers (e.g

Re: Login/Password screen

2002-12-15 Thread Jochem van Dieten
Jann VanOver wrote: > Cross platform/cross browser. No problem. > If you have people using non-microsoft browsers, server authentication can > be problematic. Just stick to Basic HTTP authentication (RFC 2617), I have yet to see the browser that doesn't support it. But if you use NTLM, you a

Re: Login/Password screen

2002-12-16 Thread Jochem van Dieten
Kola Oyedeji wrote: > Does this send the user name and or password in plain text. Yes, if sent over a non-HTTPS connection. If you want to have the password encrypted use Digest Authentication (RFC 2617). Supported by most major browsers (IE, Mozilla, Opera but not NN 4.x). Jochem

Re: Login/Password screen

2002-12-16 Thread Jochem van Dieten
Kola Oyedeji wrote: > > Does that mean it's possible to do this over SSL and the user still be > able to authenticate against the server Yes, it works over SSL. RFC 2617 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists

Re: CFFILE error:formfield File does not contain a file

2002-12-16 Thread Jochem van Dieten
Angel Stewart wrote: > > The code works just fine in CF5...it fails under CFMX. > > I tried remiving the form from the Filefield attribute, making it rfile > instead of form.rfile with no success. > > I even tried to dump the Form scope for debugging..and I even get the > same damned error there

Re: Is ColdFusion the best answer

2002-12-17 Thread Jochem van Dieten
Costas Piliotis wrote: > > mySQL doesn't use MDAC does it? I believe macromedia claims the trouble is > with MDAC, not ColdFusion... MyODBC on the other hand uses a little bit of MDAC. The driver manager is used by all ODBC drivers, but I am not sure if that runs all the time or only when setti

Re: update form

2002-12-17 Thread Jochem van Dieten
Quoting Dave Lyons <[EMAIL PROTECTED]>: > > the MM update behavior was throwing a ton of errors so i wrote one > out but its not working. Define "not working". > > UPDATE user (firstName, lastName, username, password, email, city, > state, country, zip, sex, sexPref, BDmonth, BDDay, BDYear, he

RE: mySQL equivalent of MS Access "Money" fieldtype?

2002-12-17 Thread Jochem van Dieten
Quoting Rick Faircloth <[EMAIL PROTECTED]>: > > I'll go with INT...what does the "unsigned" part mean > and what are the implications of "signed" or "unsigned"? http://www.mysql.com/doc/en/Numeric_types.html BTW, your original question is answered there as well. Jochem ~

Re: mySQL equivalent of MS Access "Money" fieldtype?

2002-12-17 Thread Jochem van Dieten
Sean A Corfield wrote: > > Integer is the safer way to represent money - as pennies - because that > way you avoid rounding errors. Financial applications should never use > floating point to represent dollars (or whatever). If you take 0.00 and > add 0.01 a hundred times, you're quite likely t

Re: CreateDateTime function??

2002-12-17 Thread Jochem van Dieten
Lisa Donnelly wrote: > I'm new to CF and I have hit a wall. > I have 4 select lists (numeric); > Weeks > Days > Minutes > Hours > and I need the user to select a value from each of these lists. The problem > is, how to store the selected values into one field of my database? In an interval field,

Re: CreateDateTime function??

2002-12-17 Thread Jochem van Dieten
Joe Eugene wrote: > All you need is create a default date and use function DateAdd("",defaultDate) > and create whatever..date you want. Check previous post for code. Why add a date if you want to store an interval? I mean, if you want to calculate a new date it is the obvious route, but the requ

Re: Counting Records - Worse Than I thought

2002-12-17 Thread Jochem van Dieten
Les Mizzell wrote: > > Tables as follows: > > Table of Branches > - > Branch_Name > Branch_ID > > Table of Employees > - > Employee Name > Employee_ID > Branch_ID - (to tie the employees to their branch) > > Table of Contracts > -- > Contract_Name

Re: CreateDateTime function??

2002-12-18 Thread Jochem van Dieten
Lisa Donnelly wrote: > > My intention is to allow a user to select 'how long' eg, months, weeks, > days, hours, minutes, it took to solve a problem, this information will then > be stored as one field in the database. It is the intention that searches > etc can be carried out on this information f

Re: CreateDateTime function??

2002-12-18 Thread Jochem van Dieten
John Morgan wrote: > In light of this new information my original suggestion still stands. If > you format your data as a string (EX: ww:dd:hh:mm) then it will sort > correctly (assuming you zero pad 3 = 03) and pure string comparison will > yield correct results. ( "00:03:11:15" GT "00:03:11:25

Re: CreateDateTime function??

2002-12-18 Thread Jochem van Dieten
John Morgan wrote: > Good point. My method would make the data more readable in the database but > your method would be more flexible. More readable? The copy-pasted example below uses some non-standard extensions like week and century, but you will get the point: test=# create table ivtest (te

Re: Issue: Change row color on mouse over in Netscape 4.7

2002-12-18 Thread Jochem van Dieten
Costas Piliotis wrote: > I actually think it's getting to be a good time to force them to upgrade. > There was a time where websites started coming along that had a minimum > Nutscrape 4/IE 4 requirement. Why not take a moment and raise the bar to IE > 5 / Nutscrape 6 /Opera 6 / Mozilla 1.0... Ma

Re: Ditching CFMAIL/writing out text files

2002-12-18 Thread Jochem van Dieten
Mosh Teitelbaum wrote: > Jochem has an AdvancedEmail tag that, IIRC, can write straight to the SMTP > spool. It's offline now, but maybe if you ask him real nice...? http://jochem.vandieten.net/coldfusion/customtags/advancedemail/advancedemail_2_1_rc.zip Jochem ~

Re: Dynamic CFPOP issue

2002-12-18 Thread Jochem van Dieten
Joseph Thompson wrote: > Has anyone running CFMX had a problem with CFPOP ignoring variables? > > A hard coded CFPOP tag works as expected. If those attributes are set > to the Request scope and added to the CFPOP tag the pop fails. http://www.macromedia.com/support/coldfusion/releasenotes/mx/re

Re: Page Breaks for Printing

2002-12-19 Thread Jochem van Dieten
Quoting Chad <[EMAIL PROTECTED]>: > > Has anyone figured out how to make page breaks for printing? http://www.w3.org/TR/REC-CSS2/page.html Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscriptio

RE: How to do this without the subselect?

2002-12-19 Thread Jochem van Dieten
Quoting Rick Faircloth <[EMAIL PROTECTED]>: > > Since the where statement is taken by the "#MultipleWaivers..." line, > it doesn't leave room for another where statement such as > where UW.ClientID is NULL... Shouldn't it be RW.ClientID IS NULL. Jochem ~~~

Re: Updaters...Culmulitive?

2002-12-19 Thread Jochem van Dieten
Quoting "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]>: > > Are they? Release notes :-) Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm

RE: How to do this without the subselect?

2002-12-19 Thread Jochem van Dieten
Quoting Rick Faircloth <[EMAIL PROTECTED]>: > > Now, that's a good question. I've always used subselects to get > around having to spend time with those unfriendly (at least to me!) > joins. Then maybe MySQL isn't the database for you :) > Select UW.UtilityWaiverID > from utilit

Re: How can I modify this query so mySQL will be happy?

2002-12-19 Thread Jochem van Dieten
S. Isaac Dealey wrote: > There's also DateFormat(mydate,"d") which returns the same value, but > DayOfMonth() makes a lot more sense when you're reading someone else's code. There is also an SQL standard EXTRACT function, that will work in other SQL compliant databases. Unless of course you prefe

Re: How to do this without the subselect?

2002-12-19 Thread Jochem van Dieten
Rick Faircloth wrote: > > You may be right...perhaps I should got back to Access... > at least it was *advanced* enough to handle sub-selects... :o) There are other very nice free databases that have a HISTORY that reads like MySQL's TODO :-) Jochem ~~~

Re: How to do this without the subselect?

2002-12-19 Thread Jochem van Dieten
Rick Faircloth wrote: > > I've just always found the joins, especially left, outer, inner, etc., to be > unintuitive when looking at the code. I guess I just haven't worked with > them enough. > I've always worked around them with subselects, which mySQL won't do. (Until > 4.2) Some first form o

Re: Self Join Question

2002-12-19 Thread Jochem van Dieten
Les Mizzell wrote: > > I've got a table of Office Branches. Some of them are MAIN BRANCHES (value > "main" under "sub_branch" in table). > Others are SUB BRANCHES and would have the branch_ID of the main branch > listed in the "sub_branch" cell. > > So, I need a self join to get this to work, cor

Re: How to do this without the subselect?

2002-12-19 Thread Jochem van Dieten
Rick Faircloth wrote: > > Notes: > > This query works to select UtilityWaivers that were issued within a given > month and which were issued without an accompanying RentalWaiver. > > The part of the query before the "where" clause selects all UtilityWaivers > which were issued within the specifi

Re: Self Join Question

2002-12-19 Thread Jochem van Dieten
Les Mizzell wrote: > Thanks... Don't forget to mark post Samual's answer (it is better than mine) in the thread you opened on the CF Forums. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscrip

Re: Web Based CD key

2002-12-19 Thread Jochem van Dieten
Luis Lebron wrote: > We have a customer that has asked us to create a CD that would only "unlock" > if a person was logged in to a particular web site. Any ideas on how this > could be done. I'm thinking that the CD could check for the existence of a > particular cookie. Anyone have any ideas? Wha

Re: Netscape 4.7 squares galore

2002-12-19 Thread Jochem van Dieten
Rob Rohan wrote: > We just moved from 5 to MX and are cleaning up some final odds and ends. One > of the last things we are checking is to see if the site is at least usable > in 4.7 (I hate 4.7 I wish it would've been time bombed). > > When I hit any page on the site, the text turns to squares.

Re: Web Based CD key

2002-12-19 Thread Jochem van Dieten
Luis Lebron wrote: > A PowerPoint Presentation done with Microsoft Presenter? Convert it to Flash (IIRC converters are commercialy available) and set up something with Flash Remoting. Jochem ~| Archives: http://www.houseoffusio

Re: Usage of Variables Scope

2002-12-20 Thread Jochem van Dieten
Quoting "Bosky, Dave" <[EMAIL PROTECTED]>: > > Is there any benefit or performance difference when scoping local > variables or is it mainly used for readability? > #Variables.myLocalVariable# > #myLocalVariable# There might be a minute performance increase, but the main reason is that it avoids

Re: MAIL SERVER

2002-12-20 Thread Jochem van Dieten
Rebecca Joy Sherman wrote: > Anyone know of a good MAIL server for cheap? I would like a Cold Fusion one > but right now I just need one for my family email. http://www.houseoffusion.com/cf_lists/index.cfm?method=results&forumid=4&Search=mail+server&maxrows=20 Jochem ~~~

Re: Easy CFFILE ?

2002-12-20 Thread Jochem van Dieten
Eric Hoffman wrote: > Error processing CFFILE > > Error attempting to write data to target file > 'D:\Inetpub\wwwroot\Sma...' > > Error: There was a hardware error. > > > How does one fix this? Permissions on the server? Buy new hardware? Jochem ~

Re: ColdFusion and Interbase?

2002-12-21 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote: > Does anyone here have any experience with ColdFusion MX and Interbase > databases? From what I can see, there's no native driver in the CF > Administrator and there's no ODBC in the Microsoft ODBC manager... at least > not on the server I'm looking at. > > Anyone here k

Re: ColdFusion and Interbase?

2002-12-21 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote: > > Actually I believe the database *is* FireBird. And believe me, I'd LOVE to > drop it completely since the data I'm trying to get is nothing more than a > log (basically like a weblog) that really should have been saved as flat > text to begin with. My goal here is to

Re: CFQUERYPARAM and Lists

2002-12-22 Thread Jochem van Dieten
Quoting Cedric Villat <[EMAIL PROTECTED]>: > > username="#request.dbuser#" password="#request.dbpass#"> > UPDATE Tickets > SET folder = value="#getEscalationInfo.eFolder#">, > dateUpdated = value="#CreateODBCDateTime(Now())#"> > WHERE ticketID = value="#tickList#" list="Yes"> Chang

Re: QUERY IN performance hit

2002-12-23 Thread Jochem van Dieten
Cedric Villat wrote: > I'm doing a query like this: > > username="#request.dbuser#" password="#request.dbpass#"> > UPDATE Tickets > SET folder = value="#getEscalationInfo.eFolder#">, > dateUpdated = value="#CreateODBCDateTime(Now())#"> > WHERE ticketID IN ( value="#tickList#" list="Y

Re: Page Breaks for Printing

2002-12-23 Thread Jochem van Dieten
Quoting James Smith <[EMAIL PROTECTED]>: > > If the document is say 2 pages long and the first page (before the CSS > page break) is short, say 50% page height, it prints alligned to the > BOTTOM of the page, page 2 then prints top alligned. Anyone know how > to fix this? Show the stylesheet. An

Re: MS CF?

2002-12-23 Thread Jochem van Dieten
Quoting Len Conrad <[EMAIL PROTECTED]>: > > http://theregister.co.uk/content/4/28667.html Last month it was Apple, next month it probably is Adobe (unless everybody will be busy reporting real news). Jochem -- Friends don't let friends use table-based layouts.

Re: Architecture advice please ...

2002-12-23 Thread Jochem van Dieten
Quoting Michael Kear <[EMAIL PROTECTED]>: > > We have one main site, (I'll call it MAINSITE) which consists of a > shop and lots of .asp and html pages, and a couple of cold-fusion > based separate smaller sites. NO problem so far, but the MAINSITE has > lots of interactive ColdFusion pages, whic

Re: MS CF?

2002-12-23 Thread Jochem van Dieten
Adrocknaphobia Jones wrote: > You can sit here and complain that MS is the bad guy, but they are not > the company you have put your faith in. I know I have the unpopular view > on this list as anti-MM, but I can tell you that if MS owned Flash, you > wouldn't have to worry about it being sold agai

Re: Application Advice Needed

2002-12-23 Thread Jochem van Dieten
Joshua Miller wrote: > > The XML file will contain at least 5,000 entries and each > entry has multiple entries from another table related to it. So, I'm > looking at a gigantic XML file (5-15mb easilly). I just used CF to > generate a page for me and it took well over 5 minutes to run the > rout

Re: Linking CF and Flash

2002-12-24 Thread Jochem van Dieten
Christian Cantrell wrote: > I like the idea, too. Anyone want to add anything? How many people > use the cfform tag now, and how many more people would use it if it > worked in the manner described below? And how else would you want it > to behave? I never use cfform, and I doubt I would

Re: Date Compare in SQL?

2002-12-24 Thread Jochem van Dieten
Cedric Villat wrote: > > username="#request.dbuser#" password="#request.dbpass#"> > SELECT T.ticketID > FROM Tickets T > AND month(dateCreated) >= value="#DatePart("m", f_date)#"> > AND year(dateCreated) >= value="#DatePart("", f_date)#"> > ORDER BY T.ticketID > SELECTT.

Re: Linking CF and Flash

2002-12-24 Thread Jochem van Dieten
Matt Robertson wrote: > > I think that its time for CF developers to start looking at using Flash > for components in sites. Due to bandwidth and other considerations > we're not ready for entirely Flash-driven sites for the general > marketplace, but in my opinion developers should begin explori

Re: Linking CF and Flash

2002-12-24 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote: > Jochem, are there any browsers out there that understand XHTML2? No, the standard is only just shaping up. But with XHTML 1 browsers understood it way before editors such as CF Studio understood it, and I would prefer not to have that happen again. Jochem ~~~

Linking CF and Flash

2002-12-25 Thread Jochem van Dieten
Jochem van Dieten wrote: > >And let me give a syntax suggestion: > > > Character Options > Stay > > Leave > Job transfer > Divorce > Fatal disease > > Back Burner > > This should be object

Re: Need some server help

2002-12-27 Thread Jochem van Dieten
Quoting Phillip B <[EMAIL PROTECTED]>: > > My websites seems to dog down to the point that it takes for ever for > a page to load. This can happen any time of the day with out any > rhyme our reason and can last for about 30-60 minutes. I can't tell > if it's ColdFusion server, CF code, the email s

Re: PostgreSQL / MX datasource questions

2002-12-27 Thread Jochem van Dieten
Quoting Josh <[EMAIL PROTECTED]>: > > I can't figure out what to do to get the PostgreSQL JDBC datasources > to work with CFMX... > > what is an example of the JDBC URL, driver name, and driver class? http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=15 > These don't seem to be adequately

Re: ODBC Date Question

2002-12-30 Thread Jochem van Dieten
Julia Green wrote: > > Now the problem, my client wants me to do a form where you put a Beginning and >Ending Date, > Beginning Date: > > Ending Date: > > > Type the dates in the following format: 10/13/2001. Be sure to type a >beginning and ending date. > > and to find the files that go

Re: NEED HELP: Single quotes not escaping

2002-12-30 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote: > > Basically what's happening is that someone enters an apostrophe (aka single > quote) into the form field and ColdFusion is not automatically escaping it. > > For example... O'Neil for a last name produces an error because the single > quote causes the SQL UPDATE state

Re: war Againest Loneliness

2002-12-30 Thread Jochem van Dieten
Kathy Wargo wrote: > --#r0xx# > Content-Type: text/html > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable Would be nice if the full headers (email addresses can be faked, no way of knowing who sent this) were available (maybe just in the archive) so we would know who to info

Re: war Againest Loneliness

2002-12-30 Thread Jochem van Dieten
Rafael Alan Bleiweiss wrote: > That post is exactly why everyone should run Norton Antivirus Corporate > edition real-time including email sweeps... and have it update > automatically How about not double clicking on attachments and making sure your email client doesn't execute them for you

Re: CFMX Server, MySQL woes

2002-12-30 Thread Jochem van Dieten
Russ wrote: > I'm receiving the following error: > > Connection verification failed for data source: FasterDesigns > []java.sql.SQLException: SQLException occurred in JDBCPool while > attempting to connect, please check your username, password, URL, and > other connectivity info. > The root cause

<    1   2   3   4   5   6   7   8   9   10   >