Diagnostics:
Error Executing Database Query.
Query Of Queries syntax error.
Encountered "local" at line 0, column 0.
The error occurred on line 432.
with this in place....
<cfset local.qryGet = Get />
<cfquery dbtype="query" name="stopsCount">
select count(stopTime) as numberOfStops
from local.qryGet
where stopTime >= 1
</cfquery>
<cfset request.numberOfStops = stopsCount.numberOfStops>
tw
On Fri, 10 Sep 2004 14:34:25 -0400, Peter J. Farrell
<[EMAIL PROTECTED]> wrote:
> Is all the code you showed in the "pseudo" constructor or maybe the
> init() method?
>
> 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]
>
--
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]
