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_thepeopleGet">
<cfquery
name="qry_mypersongetting" datasource =
"theartof_theartoflovingmoney">
SELECT *
FROM #request.sqlObjectPrefix#tblPeople
where
tablePK = '#arguments.personKeyList#'
AND emailAddress =
'#arguments.emailAddress#'
</cfquery>
<cfreturn qry_mypersongetting>
</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.
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 <chedders...@gmail.com> 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:370785
Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
