match may be a reserved word? ----- Original Message ----- From: "Lovelock, Richard J" <[EMAIL PROTECTED]> To: "'cflist'" <[EMAIL PROTECTED]> Sent: Wednesday, September 17, 2003 1:08 PM 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]
