ok, another stored proc question
my stored proc has this:
WHERE ARCHIVE_ID = @ARCHIVE_ID
My param passed to it is:
<cfprocparam type="INOUT"
cfsqltype="CF_SQL_INTEGER"
dbvarname="ARCHIVE_ID"
variable="ARCHIVE_ID"
value="#URL.SID#"
null="NO">
The URL param IS being passed.
But the query is running as if there is no archive_id value being passed to
it.
No error message, just no results. No content passed out, debugging shows
the query returning zero records.
Also the query is running at 10032 milliseconds or so ... that seems like a
hell of a long time ...
H.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
