What's the whole query? Sometimes that error happens because something is wrong before the "WHERE"
-----Original Message----- From: Matthew Smith [mailto:[email protected]] Sent: Saturday, June 7, 2014 10:32 AM To: cf-community Subject: Re: error with query, can't figure it out...? Free cat print if someone can figure this out. I got nothing. Please help!?!?!? > On Jun 7, 2014, at 3:54, 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/p > aypalcheckout/fbx_switch.cfm: line 40 Called from > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebo > x30_CF50.cfm: line 273 Called from > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebo > x30_CF50.cfm: line 33 Called from > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebo > x30_CF50.cfm: line 1 Called from > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/index.cfm: > line 9 Called from > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/Applicatio > n.cfc: line 62 Called from D:/Inetpub/redhotkitties/cfcs/qrystodatabase.cfc: line 748 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/orderApp/paypalc heckout/fbx_switch.cfm: line 40 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF 50.cfm: line 273 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF 50.cfm: line 33 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF 50.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:370804 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
