Did you recently migrate from CF 4.x to CF 5? I've noticed that the CF 5 implementation of <cfprocparam> is more stringent.
Mark -----Original Message----- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 7:58 AM To: CF-Talk Subject: CFStored Procedure question OK, I have been using SP's for quite some time with great success and I love them. However, I have one that is giving me some troubles. Here is the CFStoredprocedure tag: <cfstoredproc datasource="#DataSource#" procedure="sp_GetInformation" returncode="Yes"> <cfprocparam cfsqltype="CF_SQL_VARCHAR" dbvarname="@USerType" type ="In" value="#Session.UserType#"> <cfprocparam cfsqltype="CF_SQL_INTEGER" dbvarname="@EntityID" type ="In" value="#Session.EntityID#"> <cfprocresult name="qGetInformation"> </cfstoredproc> The cfprocparam tags are sending in the correct information, and when I run an SQL trace I see the values are being passed. the problem is the cfprocresult. When I do a cfoutput, I am not getting the information passed from the query at all. When I run the SP in the Query analyzer, all works well and I see all the information that I need to see. Has anyone else seen this issue before? Thanks, _________________________ _________________________ ____________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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 ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
