Ben, How are they displayed on the debug output? How are they derived?
Thanks, Robert -----Original Message----- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 11:33 AM To: CF-Talk Subject: RE: Query Name to variable Can't be done in CF5, can be done in CFMX. --- Ben -----Original Message----- From: Dave Livingston [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 11:23 AM To: CF-Talk Subject: Query Name to variable This is a multi-part message in MIME format. ------=_NextPart_000_0024_01C25A46.52EB0620 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Does any one know how to get the names of all of the queries that have run on a particular page? I want to store them in a structure or a variable. Just like CF displays on debugging output. I asked my local CFUG and didn't get any good answers. So I'll try a (hopefully) wider audience and see if you guys can answer it. Thanks in advance! Dave P.S. I am running CF5. David Livingston Network Admin 214-871-9117 [EMAIL PROTECTED] David Livingston Network Admin 214-871-9117 [EMAIL PROTECTED] ------=_NextPart_000_0024_01C25A46.52EB0620 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" = xmlns=3D"http://www.w3.org/TR/REC-html40";> <head> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <meta name=3DProgId content=3DWord.Document> <meta name=3DGenerator content=3D"Microsoft Word 10"> <meta name=3DOriginator content=3D"Microsoft Word 10"> <link rel=3DFile-List href=3D"cid:[EMAIL PROTECTED]";> <o:SmartTagType = namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"PersonName"/> <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:DoNotRelyOnCSS/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:SpellingState>Clean</w:SpellingState> <w:GrammarState>Clean</w:GrammarState> <w:DocumentKind>DocumentEmail</w:DocumentKind> <w:EnvelopeVis/> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if !mso]> <style> st1\:*{behavior:url(#default#ieooui) } </style> <![endif]--> <style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline; text-underline:single;} p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig {margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} span.EmailStyle17 {mso-style-type:personal-compose; mso-style-noshow:yes; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; font-family:Arial; mso-ascii-font-family:Arial; mso-hansi-font-family:Arial; mso-bidi-font-family:Arial; color:windowtext;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style> <!--[if gte mso 10]> <style> /* Style Definitions */=20 table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} </style> <![endif]--> </head> <body lang=3DEN-US link=3Dblue vlink=3Dpurple = style=3D'tab-interval:.5in'> <div class=3DSection1> <p class=3DMsoNormal = style=3D'mso-layout-grid-align:none;text-autospace:none'><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>Does </span></font><st1:PersonName><font size=3D2 face=3D"Courier New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>ny one know how to get the n</span></font><st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>mes of </span></font><st1:PersonName><font size=3D2 face=3D"Courier = New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>ll of the queries th</span></font><st1:PersonName><font size=3D2 = face=3D"Courier New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>t h</span></font><st1:PersonName><font size=3D2 face=3D"Courier New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>ve run on </span></font><st1:PersonName><font size=3D2 face=3D"Courier = New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'> p</span></font><st1:PersonName><font size=3D2 face=3D"Courier New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier = New"'>rticul</span></font><st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>r p</span></font><st1:PersonName><font size=3D2 face=3D"Courier New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>ge? I w</span></font><st1:PersonName><font size=3D2 face=3D"Courier = New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>nt to store them in </span></font><st1:PersonName><font size=3D2 = face=3D"Courier New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'> structure or </span></font><st1:PersonName><font size=3D2 = face=3D"Courier New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'> v</span></font><st1:PersonName><font size=3D2 face=3D"Courier New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier = New"'>ri</span></font><st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>ble. Just like CF displ</span></font><st1:PersonName><font size=3D2 = face=3D"Courier New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>ys on debugging output. I </span></font><st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>sked my loc</span></font><st1:PersonName><font size=3D2 face=3D"Courier = New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>l CFUG </span></font><st1:PersonName><font size=3D2 face=3D"Courier = New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>nd didn’t get </span></font><st1:PersonName><font size=3D2 = face=3D"Courier New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>ny good </span></font><st1:PersonName><font size=3D2 face=3D"Courier = New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>nswers. So I’ll try </span></font><st1:PersonName><font size=3D2 = face=3D"Courier New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'> (hopefully) wider </span></font><st1:PersonName><font size=3D2 = face=3D"Courier New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>udience </span></font><st1:PersonName><font size=3D2 face=3D"Courier New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>nd see if you guys c</span></font><st1:PersonName><font size=3D2 = face=3D"Courier New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>n </span></font><st1:PersonName><font size=3D2 face=3D"Courier New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>nswer it. Th</span></font><st1:PersonName><font size=3D2 face=3D"Courier = New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>nks in </span></font><st1:PersonName><font size=3D2 face=3D"Courier = New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier = New"'>dv</span></font><st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>nce! <o:p></o:p></span></font></p> <p class=3DMsoNormal = style=3D'mso-layout-grid-align:none;text-autospace:none'><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier = New"'>D</span></font><st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier = New"'>ve<o:p></o:p></span></font></p> <p class=3DMsoNormal = style=3D'mso-layout-grid-align:none;text-autospace:none'><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier = New"'><o:p> </o:p></span></font></p> <p class=3DMsoNormal = style=3D'mso-layout-grid-align:none;text-autospace:none'><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>P.S. I </span></font><st1:PersonName><font size=3D2 face=3D"Courier = New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>m running CF5.<o:p></o:p></span></font></p> <p class=3DMsoNormal = style=3D'mso-layout-grid-align:none;text-autospace:none'><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier = New"'><o:p> </o:p></span></font></p> <p class=3DMsoNormal = style=3D'mso-layout-grid-align:none;text-autospace:none'><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier = New"'>D</span></font><st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>vid Livingston<o:p></o:p></span></font></p> <p class=3DMsoNormal = style=3D'mso-layout-grid-align:none;text-autospace:none'><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier New"'>Network Admin<o:p></o:p></span></font></p> <p class=3DMsoNormal = style=3D'mso-layout-grid-align:none;text-autospace:none'><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier = New"'>214-871-9117<o:p></o:p></span></font></p> <p class=3DMsoNormal><st1:PersonName><font size=3D2 face=3D"Courier = New"><span style=3D'font-size:10.0pt;font-family:"Courier = New"'>dlivingston@multim</span></font><st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier = New"'>a</span></font></st1:PersonName><font size=3D2 face=3D"Courier New"><span = style=3D'font-size:10.0pt;font-family:"Courier = New"'>rk.com</span></font></st1:PersonName><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></ p= > <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p> </o:p></span></font></p> <p class=3DMsoAutoSig><b style=3D'mso-bidi-font-weight:normal'><font = size=3D4 face=3D"Times New Roman"><span = style=3D'font-size:14.0pt;font-weight:bold; mso-bidi-font-weight:normal;mso-no-proof:yes'>D</span></font></b><st1:Pe r= sonName><b style=3D'mso-bidi-font-weight:normal'><font size=3D4><span = style=3D'font-size:14.0pt; = font-weight:bold;mso-bidi-font-weight:normal;mso-no-proof:yes'>a</span>< /= font></b></st1:PersonName><b style=3D'mso-bidi-font-weight:normal'><font size=3D4><span = style=3D'font-size:14.0pt; font-weight:bold;mso-bidi-font-weight:normal;mso-no-proof:yes'>vid = Livingston<o:p></o:p></span></font></b></p> <p class=3DMsoAutoSig><font size=3D2 face=3D"Times New Roman"><span = style=3D'font-size: 10.0pt;mso-no-proof:yes'>Network Admin<o:p></o:p></span></font></p> <p class=3DMsoAutoSig><font size=3D2 face=3D"Times New Roman"><span = style=3D'font-size: 10.0pt;mso-no-proof:yes'>214-871-9117<o:p></o:p></span></font></p> <p class=3DMsoAutoSig><st1:PersonName><font size=3D2 face=3D"Times New = Roman"><span = style=3D'font-size:10.0pt;mso-no-proof:yes'>dlivingston@multim</span></f o= nt><st1:PersonName><font size=3D2><span = style=3D'font-size:10.0pt;mso-no-proof:yes'>a</span></font></st1:PersonN a= me><font size=3D2><span = style=3D'font-size:10.0pt;mso-no-proof:yes'>rk.com</span></font></st1:Pe r= sonName><font size=3D2><span = style=3D'font-size:10.0pt;mso-no-proof:yes'><o:p></o:p></span></font></p >= <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'><o:p> </o:p></span></font></p> </div> </body> </html> ------=_NextPart_000_0024_01C25A46.52EB0620-- FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
