YAAAAAAAAAHOOOOOOOOOOOOOOOOOOOOOO thanks all :)
a mixture of nate and jay's answers works!!!! later alls. ray and whomever else ... cy'alls @ cfcbof ...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 4:03 PM To: [EMAIL PROTECTED] Subject: RE: [CFCDev] query in cfc --> queryObject out of cfc (version 2 - scoped) Not in the CFc per se, but the method. If method FOO() uses variables, x, y, and z, and those are NOT arguments that are passed in, and are NOT (intentionally) global CFC vars, then yes, you MUST var scope them. (And when I say MUST, I mean, you should, unless you want to risk life and limb, the end of the world, etc.) By the way - did you see Nathans post? I'm pretty sure he has the main answer to your problem. ======================================================================== === 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:58 PM > To: [EMAIL PROTECTED] > Subject: RE: [CFCDev] query in cfc --> queryObject out of cfc (version > 2 - scoped) > > > I thought I understood. > > ray, are you saying I need to declare all the variables that I plan to > use/create in the cfc at the top of the function as a value of 0 ? > > ...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] > ---------------------------------------------------------- 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]
