here is part of what I get.... Complex object types cannot be converted to simple values. The expression has requested a variable or an intermediate expression result as a simple value, however, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. The most likely cause of the error is that you are trying to use a complex value as a simple one. For example, you might be trying to use a query variable in a <CFIF> tag. This was possible in ColdFusion 2.0 but creates an error in later versions.
error.GeneratedContent: error.Mailto:[EMAIL PROTECTED] error.RootCause:coldfusion.runtime.UndefinedVariableException: Variable GET is undefined. error.RemoteAddress:10.10.11.186 where GET is the query object that I have :) ...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]
