Coldfusion database error resolutions log

“Unable to invoke CFC – [Macromedia][SQLServer JDBC Driver][SQLServer]The multi-part identifier “yourvariable” could not be bound.”
Your not putting pound signs around a variable name

<!--- WRONG --->
SET @newOtherID = arguments.newUserID;
<!--- RIGHT--->
SET @newOtherID = #arguments.newUserID#;

faultString “Unable to invoke CFC – [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ‘yourfirstfewcharactersofaguid’.
Your not putting your GUID in quotes

<!--- WRONG --->
SET @userguid = #arguments.newUserID#;
<!--- RIGHT--->
SET @userguid = '#arguments.newUserID#';

Leave a Reply

Your email address will not be published. Required fields are marked *