Make sure that you are passing your variables in the same order that they are in the sproc.
Plus, the dbvarname is not necessary. Clint -----Original Message----- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 8:30 PM To: CF-Talk Subject: RE: StoredProc Error Num 3 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
