ok :) no problem, doing that.......done ... although I know that wouldn't matter, its still not working...i get Vehicle report undefined or something like that....this is nuts!!!!!!!
...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 Raymond Camden Sent: Monday, November 03, 2003 3:38 PM To: [EMAIL PROTECTED] Subject: RE: [CFCDev] query in cfc --> queryObject out of cfc (version 2 - scoped) Ack! Request scope? No, no, no. What you need to do is use the var scope. Here is an example: <cffunction .....> <cfargument ....> <cfset var x = 0> <cfset var vehicleReport = 0> <cfset var i = 0> etc ======================================================================== === Raymond Camden, ColdFusion Jedi Master 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: Monday, November 03, 2003 2:35 PM > To: [EMAIL PROTECTED] > Subject: RE: [CFCDev] query in cfc --> queryObject out of cfc (version > 2 - scoped) > > > scoped and all :) > > still no go... > > <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 = "vehicleReport" 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> > > <cfset request.usedArray = arrayNew(1)> > <cfset request.arrayValues = > arraySet(request.usedArray,1,vehicleReport.recordCount,0)> > <cfset request.addColumn = > queryAddColumn(vehicleReport,'used',request.usedArray)> > > <cfset request.stopTimeArray = arrayNew(1)> > <cfset request.arrayValues = > arraySet(request.stopTimeArray,1,vehicleReport.recordCount,0)> > <cfset request.addColumn = > queryAddColumn(vehicleReport,'stopTime',request.stopTimeArray)> > > <cfloop from = 1 to = > #vehicleReport.recordCount# > index = i> > > > Do stuff in here, this code > works fine... > > > </cfloop> > > <cfreturn vehicleReport> > > </cffunction> > > </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]
