I believe 'get' is a reserved word in the QofQ lexicon, and therefore needs to be escaped with brackets:
SELECT * FROM [get] WHERE ... I ran into that or something like that a couple weeks ago, and escaping was the solution cheers, barneyb On Fri, 10 Sep 2004 14:06:28 -0400, Tony Weeg <[EMAIL PROTECTED]> wrote: > hi there. > > i have this code @ the top of my cfc > where i initialize the variable to be used in the cfc > > <cfset var get = 0> > > and then later on down i have a query that is of the same name > that is also the query i return back to the calling cfm page. > > problem... > i cannot do a query of queries on the query called get, > > i get this error: > > Diagnostics: > Error Executing Database Query. > Query Of Queries syntax error. > Encountered "get" at line 0, column 0. > The error occurred on line 430. > > ? any ideas? > > -- > tony > > Tony Weeg > > human. > macromedia certified cold fusion developer > email: tonyweeg [at] gmail [dot] com > blog: http://www.revolutionwebdesign.com/blog/ > cool tool: http://www.antiwrap.com > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email > to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' > in the message of the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported > by Mindtool, Corporation (www.mindtool.com). > > An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED] > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
