outside the component...
on the calling page, after the cfinvoke...
<cfinvoke
component="dpv1_reports"
method="dpv1_get">
<cfinvokeargument
name="ipAddressNumber"
value="#form.ipAddressNumber#">
<cfinvokeargument
name="beginDateTime"
value="#form.date1#">
<cfinvokeargument
name="endDateTime"
value="#form.date2#">
</cfinvoke>
<cfdump var="#get#">
...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 Mike Townend
Sent: Monday, November 03, 2003 3:26 PM
To: [EMAIL PROTECTED]
Subject: RE: [CFCDev] query in cfc --> queryObject out of cfc
Where are you placing your CFDUMP, in the component or outside?
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Tony Weeg
Sent: Monday, November 3, 2003 20:12
To: [EMAIL PROTECTED]
Subject: RE: [CFCDev] query in cfc --> queryObject out of cfc
sorry ray :)
and to answer the question, I get the error that says, GET is undefined....
<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 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>
<cfif not get.recordCount>
<cflocation url="new_vehicleReport.cfm">
</cfif>
<cfset newGet = queryNew(get.columnList)>
<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, modify columns etc....
</cfloop>
<cfreturn get>
</cfunction>
</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]
