Post the whole cfc method. On Jun 7, 2014 3:42 AM, "Matthew Smith" <[email protected]> wrote:
> > > > > 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:370794 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
