Cant you use upper and ucase <cfquery name="test" dbtype="query"> SELECT * FROM INTERNAL where upper(firstname) = '#ucase(variables.name)#' </cfquery>
Brian -----Original Message----- From: Tom MacKean [mailto:[EMAIL PROTECTED] Sent: Tuesday, 7 June 2005 4:10 PM To: CFAussie Mailing List Subject: [cfaussie] RE: QoQ woes 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/ ----------------------------------------------------------------------------------- This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities "Suncorp". Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. --- 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/
