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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2378 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=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
