Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Incorrect syntax near the keyword 'WHERE'.

Author  Topic 

chedderslam
Posting Yak Master

223 Posts

Posted - 2014-09-02 : 12:35:17
Written in ColdFusion, so please ignore the markup. Please help, thanks!

BEGIN

UPDATE #request.sqlObjectPrefix#tblOrderInfoBuffer
SET paypal_payer_id = <cfqueryparam value="#arguments.paypal_payer_id#" cfsqltype="CF_SQL_VARCHAR">
WHERE cfuserid = <cfqueryparam value="#session.cfid#0#session.CFToken#" cfsqltype="CF_SQL_BIGINT">

AND tblPeopleFK = <cfqueryparam value="#client.userid#" cfsqltype="CF_SQL_BIGINT">
END

chedderslam
Posting Yak Master

223 Posts

Posted - 2014-09-02 : 12:35:49
sorry, error message is:
Incorrect syntax near the keyword 'WHERE'.
Go to Top of Page
   

- Advertisement -