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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218102 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
