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]
