What filters are you using? What us your trace file setup?
"This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Billy Jamme <[EMAIL PROTECTED]> To: CF-Talk <[email protected]> Sent: Mon Jul 17 21:46:36 2006 Subject: Re: Using SQL profiler with cfqueryparam Thanks. But how do you track by this dynamic SQL string to the orignal parent query? >This is not an SP per se, it is just how SQL handles these dynamic SQL >strings. > >-----Original Message----- >From: Billy Jamme <[EMAIL PROTECTED]> >To: CF-Talk <[email protected]> >Sent: Mon Jul 17 20:44:40 2006 >Subject: Using SQL profiler with cfqueryparam > >Hello All, > >I'm trying to track some slow running queries with MS SQL profiler. If I >use cfqueryparam Coldfusion will automatically convert the query to a stored >procedure. > >For example: > ><cfquery name="test" datasource="MSSQL"> > SELECT > id, user > FROM > userTable > WHERE > id = #form.id# AND > user = #form.user# ></cfquery> > >In MS SQL profiler you will actually see this query in the TextData field; >returning: > > SELECT > id, user > FROM > userTable > WHERE > id = #form.id# AND > user = #form.user# > >However, if you add cfqueryparams to variables in the query, you'll see: > >exec sp_execute 27, '12', '941' > >Where 27 is the stored procedure handler, '12' is the form.id variable and >'941' is the form.user variable. My question is, where does ColdFusion >store the handler information? In other words, how would I track "exec >sp_execute 27, '12', '941'" to the actual query being called. > >Thanks in advance, > >Jim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246825 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
