ok, here it is, modified a bit..but the gist is here...
<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 = "get" datasource = "dpv1">
select *
from reportsView r
inner join vehicleTable v
on v.ipAddressNumber = r.ipAddressNum
where r.ipAddressNum = #form.ipAddressNumber#
and r.currentDate between '#form.date1#' and
'#form.date2#'
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>
this should work?
...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 2:54 PM
To: [EMAIL PROTECTED]
Subject: RE: [CFCDev] query in cfc --> queryObject out of cfc
Just to be anal, why didn't you do <cfset var doStuff>? Thats the variable
you are creating, not theQueryReturn. (Ok, you make both, but you only need
one.)
========================================================================
===
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 Bryan F. Hogan
> Sent: Monday, November 03, 2003 1:48 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [CFCDev] query in cfc --> queryObject out of cfc
>
>
> <cffunction name="returnTheQuery" returntype="query" output="false">
>
> <cfset var returnTheQueryReturn=''>
> <cfquery name="doStuff">
>
> <cfset returnTheQueryReturn=doStuff>
>
> <cfreturn returnTheQueryReturn>
> </cffunction>
>
> ??
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Behalf Of Tony Weeg
> Sent: Monday, November 03, 2003 2:46 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [CFCDev] query in cfc --> queryObject out of cfc
>
>
> to preface this like I should have, I have this working fine in cfml
> code, I just want to make the processing happen in a cfc, then have
> that cfc return the newly modified query object back to the calling
> page....
>
> ...tony
>
> tony weeg
> senior web applications architect
> navtrak, inc.
> www.navtrak.net
> [EMAIL PROTECTED]
> 410.548.2337
>
>
> ----------------------------------------------------------
> 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]
