The LIKE conditional has various improvements dig out the old mx docs for that
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/using_re.htm#wp11 81595 Examples are - where sub_info like '[Off]%' - where lower(sub_info) like 'Off%' Im not sure if it will help with out seen'ng the data set But handy to know when using Qoq's -----Original Message----- From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] Sent: 17 September 2003 13:46 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Queries of queries problem Thanks for the links guys...i have another problem with this... does the SQL have more limitations on Q of Qs: I use the following code on the DB and works fine: ----------------------------------------- <cfquery datasource="fclounge" name="subs"> select player_surname, sub_info from Match_Player_Details where sub_info like 'Off%' </cfquery> ---------------------------------------- but if I use the following query on a query it doesn't work: --------------------------------------- <cfquery dbtype="query" name="subs"> select surname, sub_info from MatchDetails where sub_info like 'Off%' </cfquery> -------------------------------------- and gives the following error: "The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. " but if I change the last line to ( where sub_info = 'Off 1' ) it accepts it ok (but thats not the line I want!) _______________________________________________________ * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst & Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 _______________________________________________________ -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 17 September 2003 13:26 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Queries of queries problem Wouldn't it be CF specific SQL words? I had a look in the live docs for the list of Q of Q words but couldn't find any, anyone else found them? -----Original Message----- From: Paul Fennell [mailto:[EMAIL PROTECTED] Sent: 17 September 2003 13:24 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Queries of queries problem Heh he will want the sql ones not cf ones neil http://www.jsoftware.com/books/help/user/sql_reserved_words.htm -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 September 2003 13:03 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Queries of queries problem FYI : here is a link to the ColdFusion reserved words: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/expressi.htm -----Original Message----- From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] Sent: 17 September 2003 12:58 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Queries of queries problem It certainly is!! thank you _______________________________________________________ * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst & Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 _______________________________________________________ -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 September 2003 12:26 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Queries of queries problem MATCH *is* a reserved word as Matt suggested -----Original Message----- From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] Sent: 17 September 2003 12:08 To: 'cflist' Subject: [ cf-dev ] Queries of queries problem i am tying to do a query of a query on the same page. original query is called 'match' my subsequent query is as follows: ----------------------------------------------- <cfquery dbtype="query" NAME="subs"> SELECT surname FROM match </cfquery> ----------------------------------------------- but I am getting the following error when executing: Query Of Queries syntax error. Encountered "match" at line 0, column 0. help me please _______________________________________________________<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst & Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 _______________________________________________________ ************************************************************************ **** **************** " This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst & Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message ". ************************************************************************ **** **************** -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.518 / Virus Database: 316 - Release Date: 11/09/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.518 / Virus Database: 316 - Release Date: 11/09/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.518 / Virus Database: 316 - Release Date: 11/09/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.518 / Virus Database: 316 - Release Date: 11/09/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
