I doubt your using the old eight digit cftoken meaning it's not a bigint. . .
On Sat, Jun 7, 2014 at 3:54 AM, Matthew Smith <[email protected]> wrote: > >> Still erroring out. I bring shame to my people. >> > > Error Executing Database Query. > > [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the > keyword 'WHERE'. > > The error occurred in D:/Inetpub/redhotkitties/cfcs/qrystodatabase.cfc: line > 748 > Called from > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/orderApp/paypalcheckout/fbx_switch.cfm: > line 40 > Called from > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: > line 273 > Called from > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: > line 33 > Called from > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: > line 1 > Called from > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/index.cfm: line 9 > Called from > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/Application.cfc: > line 62 > Called from D:/Inetpub/redhotkitties/cfcs/qrystodatabase.cfc: line 748 > Called from > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/orderApp/paypalcheckout/fbx_switch.cfm: > line 40 > Called from > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: > line 273 > Called from > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: > line 33 > Called from > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: > line 1 > Called from > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/index.cfm: line 9 > Called from > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/Application.cfc: > line 62 > 746 : WHERE cfuserid = <cfqueryparam > value="#session.cfid#0#session.CFToken#" cfsqltype="CF_SQL_BIGINT"> 747 : 748 > : AND tblPeopleFK = <cfqueryparam value="#client.userid#" > cfsqltype="CF_SQL_BIGINT"> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:370803 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
