I'm sorry, but have you said yet wasn't isn't working? Are you only getting the original query back for example?
On a quick look, the only thing I see wrong below is the utter lack of var scoping. ======================================================================== === 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 Tony Weeg > Sent: Monday, November 03, 2003 2: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]
