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]
