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