I am an update query jn a stored proc but am receiving an error before it even reaches the proc.
<cfprocparam type="In" cfsqltype="CF_SQL_CHAR" dbvarname="@con_eml_adr_te" value="#con_eml_adr_te#" null="No"> con_eml_adr_te is an email address like [EMAIL PROTECTED] I receive an error saying that the con_eml_adr_te is not supplied. I know that it is because if I output it on the page it is there. I put evaluate around the value and it says there is an error near the @ symbol. This works fine on my insert but fails on the update. Please Help Joshua Tipton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
