Given the flurry of activity on this thread this note will likely be late, but just in case...
Tony: You are referencing the variable "get" outside of the CFC, but it exists inside the CFC. You need to set the name of the returnVariable in your CFINVOKE tag and use that to refer to the query. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of Tony Weeg > Sent: Monday, November 03, 2003 12:29 PM > To: [EMAIL PROTECTED] > Subject: RE: [CFCDev] query in cfc --> queryObject out of cfc > > > outside the component... > on the calling page, after the cfinvoke... > > <cfinvoke > component="dpv1_reports" > method="dpv1_get"> > > <cfinvokeargument > name="ipAddressNumber" > value="#form.ipAddressNumber#"> > > <cfinvokeargument > name="beginDateTime" > value="#form.date1#"> > > <cfinvokeargument > name="endDateTime" > value="#form.date2#"> > > </cfinvoke> > > <cfdump var="#get#"> > > > ...tony > > tony weeg > senior web applications architect > navtrak, inc. > www.navtrak.net > [EMAIL PROTECTED] > 410.548.2337 > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Mike Townend > Sent: Monday, November 03, 2003 3:26 PM > To: [EMAIL PROTECTED] > Subject: RE: [CFCDev] query in cfc --> queryObject out of cfc > > > Where are you placing your CFDUMP, in the component or outside? > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Tony Weeg > Sent: Monday, November 3, 2003 20:12 > To: [EMAIL PROTECTED] > Subject: RE: [CFCDev] query in cfc --> queryObject out of cfc > > > sorry ray :) > > and to answer the question, I get the error that says, GET is > undefined.... > > > <cfcomponent displayName="dpv1WebReports" hint="DPV1 Raw Data Web > Reports"> > > <cffunction name="dpv1_get" access="public" output="1" > returntype="query"> > > <cfargument name="ipAddressNumber" type="numeric" > required="Yes"/> > <cfargument name="beginDateTime" type="date" > required="Yes"/> > <cfargument name="endDateTime" type="date" required="Yes"/> > > > <cfquery name = "get" datasource = "dpv1"> > select * > from reportsView r > inner join navtrak525.users.dbo.vehicleTable v > on v.ipAddressNumber = r.ipAddressNum > where r.ipAddressNum = #arguments.ipAddressNumber# > and r.currentDate between > '#arguments.beginDateTime#' and '#arguments.endDateTime#' > order by currentDate asc > </cfquery> > > <cfif not get.recordCount> > <cflocation url="new_vehicleReport.cfm"> > </cfif> > > <cfset newGet = queryNew(get.columnList)> > > <cfset usedArray = arrayNew(1)> > <cfset arrayValues = > arraySet(usedArray,1,get.recordCount,0)> > <cfset addColumn = queryAddColumn(get,'used',usedArray)> > > <cfset stopTimeArray = arrayNew(1)> > <cfset arrayValues = > arraySet(stopTimeArray,1,get.recordCount,0)> > <cfset addColumn = > queryAddColumn(get,'stopTime',stopTimeArray)> > > <cfloop from = 1 to = #get.recordCount# index = i> > Do stuff, modify columns etc.... > </cfloop> > > <cfreturn get> > > </cfunction> > </cfcomponent> > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email to > [EMAIL PROTECTED] with the word '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 word '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 word '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 word '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]
