I know that Q of Q do not support the full SQL syntax...I would check this link in the docs:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/using_39.htm#wp117563 6 > -----Original Message----- > From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 17, 2003 1:46 PM > 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] > > -- ** 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]
