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:370737 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
