Please help...
The web site you are accessing has experienced an unexpected error. Please contact the website administrator. The following information is meant for the website developer for debugging purposes. Error Occurred While Processing Request 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"> 749 : END 750 : </cfif> VENDORERRORCODE 156 SQLSTATE HY000 SQL SET NOCOUNT ON DECLARE @returnKey INT IF NOT EXISTS ( SELECT tablePK FROM rhkProd_tblOrderInfoBuffer WHERE cfuserid = (param 1) AND tblPeopleFK = (param 2) ) BEGIN INSERT INTO rhkProd_tblOrderInfoBuffer ( cfuserid ) VALUES ( (param 3) ) SELECT @returnKey = SCOPE_IDENTITY() END ELSE BEGIN SELECT @returnKey = tablePK FROM rhkProd_tblOrderInfoBuffer WHERE cfuserid = (param 4) END BEGIN UPDATE rhkProd_tblOrderInfoBuffer SET tbl_shippingAddressFK = (param 5) , WHERE cfuserid = (param 6) AND tblPeopleFK = (param 7) END BEGIN UPDATE rhkProd_tblOrderInfoBuffer SET tblBillingMethodFK = (param 8) WHERE cfuserid = (param 9) AND tblPeopleFK = (param 10) END BEGIN UPDATE rhkProd_tblOrderInfoBuffer SET insuranceamount = (param 11) WHERE cfuserid = (param 12) AND tblPeopleFK = (param 13) END BEGIN UPDATE rhkProd_tblOrderInfoBuffer SET paypal_token = (param 14) WHERE cfuserid = (param 15) AND tblPeopleFK = (param 16) END BEGIN UPDATE rhkProd_tblOrderInfoBuffer SET paypal_paye r_id = (param 17) WHERE cfuserid = (param 18) AND tblPeopleFK = (param 19) END SET NOCOUNT OFF SELECT @returnKey AS returnKey DATASOURCE theartof_theartoflovingmoney Resources: Check the ColdFusion documentation to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (iPhone; CPU iPhone OS 7_1_1 like Mac OS X) AppleWebKit/537.51.2 (KHTML, like Gecko) Version/7.0 Mobile/11D201 Safari/9537.53 Remote Address 72.78.78.2 Referrer https://www.paypal.com/webscr?cmd=_express-checkout&token=EC-90S14022H8256822E&amt=$16.98&CURRENCYCODE=USD&RETURNURL=https://www.theartoflovingcatsanddogs.com/index.cfm/fuseaction/SECUREPaypalCheckout.return/cfid/41243128/cftoken/16642976/index.cfm&CANCELURL=https://www.theartoflovingcatsanddogs.com/index.cfm/fuseaction/SECUREPaypalCheckout.cancel/cfid/41243128/cftoken/16642976/index.cfm Date/Time 06-Jun-14 11:50 PM Stack Trace at cfqrystodatabase2ecfc2024530309$funcQRY_ORDERINFOBUFFEREDIT.runFunction(D:/Inetpub/redhotkitties/cfcs/qrystodatabase.cfc:748) at cffbx_switch2ecfm52088287.runPage(D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/orderApp/paypalcheckout/fbx_switch.cfm:40) at cffbx_fusebox30_CF502ecfm956482919._factor4(D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm:273) at cffbx_fusebox30_CF502ecfm956482919._factor6(D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm:33) at cffbx_fusebox30_CF502ecfm956482919.runPage(D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm:1) at cfindex2ecfm569803139.runPage(D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/index.cfm:9) at cfApplication2ecfc149795760$funcONREQUEST.runFunction(D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/Application.cfc:62) at cfqrystodatabase2ecfc2024530309$funcQRY_ORDERINFOBUFFEREDIT.runFunction(D:/Inetpub /redhotkitties/cfcs/qrystodatabase.cfc:748) at cffbx_switch2ecfm52088287.runPage(D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/orderApp/paypalcheckout/fbx_switch.cfm:40) at cffbx_fusebox30_CF502ecfm956482919._factor4(D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm:273) at cffbx_fusebox30_CF502ecfm956482919._factor6(D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm:33) at cffbx_fusebox30_CF502ecfm956482919.runPage(D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm:1) at cfindex2ecfm569803139.runPage(D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/index.cfm:9) at cfApplication2ecfc149795760$funcONREQUEST.runFunction(D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/Application.cfc:62) > On Jun 6, 2014, at 11:02, GMoney <[email protected]> wrote: > > > Maybe it's just the weird format of your pasted message but, i don't see > the "where" clause anywhere.......? > > >> On Fri, Jun 6, 2014 at 9:59 AM, Matthew Smith <[email protected]> wrote: >> >> >> <cffunction access="public" name="qry_peopleGet" output="false" >> returntype="query"> >> <cfargument name="personKeyList" type="string" required="no" default=""> >> <cfargument name="emailAddress" type="string" required="no" default=""> >> <cfargument name="returnvariable" type="string" required="no" >> default="qry_peopleGet"> >> <cfquery >> name="qry_peopleGet" datasource = >> "theartof_theartoflovingmoney"> >> SELECT * >> FROM #request.sqlObjectPrefix#tblPeople >> >> tablePK = '#arguments.personKeyList#' >> >> >> AND emailAddress = '#arguments.emailAddress#' >> >> </cfquery> >> <cfreturn qry_peopleGet> >> </cffunction> >> >> >> >> The web site you are accessing has experienced an unexpected error. >> Please contact the website administrator. >> >> The following information is meant for the website developer for >> debugging purposes. Error Occurred While Processing Request 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">* >> 749 : END >> 750 : </cfif> >> >> >> >> -- >> Regards, >> chedder is bedder > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:370784 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
