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.
| 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'. |
 |
|
|
|
|
|
Incorrect syntax near the keyword 'WHERE'.