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:246808
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
