House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists
Home /  Groups /  ColdFusion Talk (CF-Talk)

Can I tell ColdFusion to dump me all run query names?

  << Previous Post |  RSS |  Sort Oldest First |  Sort Latest First |  Subscribe to this Group Next >> 
Top  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Author:
Stephen Cassady
09/07/2010 05:57 AM

Is there a way to ask ColdFusion to dump the names of all the CFQuery resultsets? For example, I have some code that runs several cfqueries - the specific ones change based on circumstance - at the request of a page. What I would like to do is dump some sort of variable created by CF that lists me all the names of the CFquery resultsets. It's late - I've likely not enunciated my problem well. Stephen.

Top  |   Parent  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Author:
Peter Boughton
09/07/2010 06:09 AM

Depends how you've scoped them. Here's a quick example if they're unscoped: <cfloop item="CurVar" collection="#Variables#">   <cfif isQuery(Variables[CurVar])>     <cfdump var=#Variables[CurVar]# label=#CurVar# />   </cfif> </cfloop> If you've got multiple scopes used, and/or function local ones, then use a debugging template instead.

Top  |   Parent  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Author:
Ketan Jetty
09/11/2010 08:02 PM

I have written a stack trace tool that will dump all function calls and QUERIES of REQUEST call. This uses the coldfusion service factory. You can get the complete code at http://ketanjetty.com/coldfusion/monitor/stack-trace/ Ketan Jetty http://KetanJetty.com


<< Previous Thread Today's Threads Next Thread >>

Search cf-talk

May 24, 2012

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
     1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31     

Designer, Developer and mobile workflow conference