hey ray... sure....
<....some code above and below....> <cfset var get = 0> <....some code above and below....> <cfquery name="get" datasource=""> select * reports where ipAddressNumber = 123456654 </cfquery> <....some code above and below....> <cfquery dbtype="query" name="stopsCount"> select count(stopTime) as numberOfStops from get where stopTime >= 1 </cfquery> <....doesnt make it past the above code, i get the error i mentioned....> <cfset request.numberOfStops = stopsCount.numberOfStops> On Fri, 10 Sep 2004 13:11:53 -0500, Raymond Camden <[EMAIL PROTECTED]> wrote: > Can you show the code? I'm not aware of a bug involving what you are doing > so it may be a simple typo. > > =========================================================================== > Raymond Camden, Director of Development for Mindseye, Inc (www.mindseye.com) > Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) > > Email : [EMAIL PROTECTED] > Blog : www.camdenfamily.com/morpheus/blog > Yahoo IM : morpheus > > "My ally is the Force, and a powerful ally it is." - Yoda > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Tony Weeg > > Sent: Friday, September 10, 2004 1:06 PM > > To: [EMAIL PROTECTED] > > Subject: [CFCDev] var variables > > > > 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] > > > > ---------------------------------------------------------- > 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] > -- tony Tony Weeg 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]
