Brilliant, that will work just fine! Thanks,
Pete On 9/13/05, Qasim Rasheed <[EMAIL PROTECTED]> wrote: > If you are running CFMX7 there is a new attribute to cfquery tag > called "result" which can give you some useful information about the > query which include execution time and SQL statement. > > HTH > > > On 9/13/05, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > > I need to display query executiontime to my result sets. I had > > forgotten that this isn't a value that is available at the query level > > (i.e. myquery.executiontime) but is tag-level and only applies to the > > most recent query run in-code. > > > > I can certainly set a number of temp variables to grab those > > executiontime values, but I would prefer to add it to the query > > resultset. I am trying this: > > > > <cfset temp = queryAddColumn(getallrecords, "executiontime", > > "integer", cfquery.executiontime)> > > > > but it returns a "Object of type class java.lang.Long cannot be used > > as an array" error. Is there any way to accomplish what I am trying > > to do? Does SQL Server make any execution time values available that > > I can pull back in my query? > > > > Thanks > > > > Pete > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218142 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
