thanks for that link
the 'LIKE' expression is on there so should be supported by QoQ but is
certainly isn't working
if I use ( where sub_info IN ('Off 1','Off 2','Off 3') ) then that works but
the LIKE condition won't work :o/
_______________________________________________________
* 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: Niklas Richardson [mailto:[EMAIL PROTECTED]
Sent: 17 September 2003 14:24
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Queries of queries problem
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]
--
** 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]
