Luvverly. Thanks Barry. Tom
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Tuesday, 7 June 2005 4:20 PM To: CFAussie Mailing List Subject: [cfaussie] RE: QoQ woes yes you can <cfquery name="q1" datasource="twdjdbc"> select surname from parent where cmpy_code = "10" </cfquery> <cfdump var="#q1#"> <cfquery name="q2" dbtype="query"> select surname from q1 where upper(surname) = upper('addams') </cfquery> <cfdump var="#q2#"> returns "Addams" > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Chad > Renando > Sent: Tuesday, 7 June 2005 4:17 PM > To: CFAussie Mailing List > Subject: [cfaussie] RE: QoQ woes > > > I think I've run into it myself. Not sure that you can. > > Chad > who can be insensitive > > On 6/7/05, Tom MacKean <[EMAIL PROTECTED]> wrote: > > Found it. The search is case sensitive. > > > > How do I make it case insensitive? > > > > Tom > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Tom > > MacKean > > Sent: Tuesday, 7 June 2005 4:06 PM > > To: CFAussie Mailing List > > Subject: [cfaussie] QoQ woes > > > > Hi, > > > > Why doesn't this work? > > > > If I dump the first query I get a big table of data - > including a record > > where the firstname is julian. But I can't get a query of > that query to > > work. Can anyone spot where I've gone wrong? > > > > Thanks, > > > > Tom > > > > > > <cfquery name="internal" datasource="#request.dsn#" > > cachedwithin="#createtimespan(0,1,0,0)#"> > > SELECT > > extension.firstname as firstname, > > extension.lastname as lastname, > > extension.position as position, > > extension.email as email, > > department.description as department > > > > FROM extension, department > > WHERE extension.department = department.id > > AND extension.id BETWEEN 400 AND 599 > > </cfquery> > > > > <cfquery name="test" dbtype="query"> > > SELECT * FROM INTERNAL > > where firstname = 'julian' > > </cfquery> > > > > <cfdump var="#test#"> > > > > > > ________________________________________ > > > > Tom MacKean > > > > > > NOTICE: Medical and scientific information provided in print and > > electronically by Sydney IVF might not be relevant to your own > > circumstances and should always be discussed with your own > doctor before > > you act on it. This communication is confidential and may contain > > copyright or otherwise protected information of Sydney IVF > Limited or a > > third party. If you are not the intended recipient of this > communication > > please immediately let us know by reply email or telephone > us on +61 2 > > 9221 5964, delete the communication and destroy all copies. > > > > > > --- > > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] > > To unsubscribe send a blank email to > > [EMAIL PROTECTED] > > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > > --- > > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
