and I get that error from a simple <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 Tony Weeg Sent: Monday, November 03, 2003 3:00 PM To: [EMAIL PROTECTED] Subject: RE: [CFCDev] query in cfc --> queryObject out of cfc 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] ---------------------------------------------------------- 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]
