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

Reply via email to