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]
