The variable "get" sounds funny to me...I dunno if CF is choking of that? Can you change that's name and does that make any difference?
You could always use something like if you have a local variables for your CFC (some peope use local or my):
<cfquery name="get" ....... > YOUR QUERY HERE </cfquery>
<cfset local.qryGet = Get />
<cfquery dbtype="query" name="StopCount">
select count(stopTime) as numberOfStops from local.qryGet where stopTime >= 1 </cfquery>
HTH, .Peter MaePub
Tony Weeg wrote:
thanks for the input :) however, that has no bearing on the question.
thats not the ACTUAL code, the ACTUAL code is much longer, i shortened it just to show what was/wasnt working and only showed the code that is involved...
but thanks anyway ;)
tw
On Fri, 10 Sep 2004 13:20:08 -0500, Tim Sons <[EMAIL PROTECTED]> wrote:
Your missing the datasouce of the 'get' query <cfquery name="get" datasource=""> select * reports where ipAddressNumber = 123456654 </cfquery>
Tim Sons
"Living life would be a lot easier if someone would give me the source code"
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tony Weeg Sent: Friday, September 10, 2004 12:17 PM To: [EMAIL PROTECTED] Subject: Re: [CFCDev] var variables
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] ---------------------------------------------------------- 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]
