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/
