Sorry for not seeing this thread earlier. CFPROCPARAM, as with most ColdFusion tags that have a name/value pair, needs pound signs to delimit what is a variable vs. what is text. The ONLY tags that do not need pound signs to delimit what a variable is are: CFSET CFIF CFELSEIF CFLOOP with the condition attribute CFRETURN inside a CFSCRIPT block
> Anthony, > Ok, here's a learning number for those of you out there who want to > use Stored Procedures and session variables for insert. I have listed > below the combinations that work and don't work for a line in a > cfstoredproc/cfprocparam Here are the different value examples for > the cfprocparam: > 1) value="#SESSION.tester.ClsFltID#" ---> WORKS! > 2) value=#SESSION.tester.ClsFltID# ---> WORKS! > 3) value="SESSION.tester.ClsFltID" ---> BAD! > 4) value=SESSION.tester.ClsFltID ---> BAD! > 5) value='SESSION.tester.ClsFltID' ---> BAD! > I decided to keep banging it out until I got the right one correct in > the cfprocparam. The first two options work and will pass the SESSION > variables in. Surprisingly, you do need the ## around the whole > variable string in order for it to take. > > I have to say that this is one of the more vexing problems I have had > since Coldfusion is so unfriendly in the error department. Anyway, > hope this helps someone else out in the difficult problem category > when working with stored procedures using a Microsoft SQL Server 2000. > This was also done Coldfusion Server MX 7. > Thanks, Tom ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2379 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
