On Monday, Nov 3, 2003, at 12:00 US/Pacific, Tony Weeg wrote:
<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"/>
<cfset var get = 0 /> <cfset var usedArray = arrayNew(1) /> <cfset var arrayValues = 0 /> <cfset var stopTimeArray = arrayNew(1) />
<cfquery name = "get" datasource = "dpv1">
select *
from reportsView r
inner join vehicleTable v
on v.ipAddressNumber = r.ipAddressNum
where r.ipAddressNum = #form.ipAddressNumber#
Should this be #arguments.ipAddressNumber# ??
and r.currentDate between '#form.date1#' and '#form.date2#'
And #arguments.beginDateTime# and #arguments.endDateTime# ??
order by currentDate asc
</cfquery>
<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 in here, modify column values etc...
</cfloop>
<cfreturn get>
</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]
