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]
