CORRECTION I left one of the # out of the statement in the previous email.
Or even better, with cfqueryparms
<cffunction access="public" name="f_peopleGet" output="false"
returntype="query">
<cfargument name="personKeyList" type="string" required="no" default="">
<cfargument name="emailAddress" type="string" required="no" default="">
<cfquery name="qry_peopleGet" datasource ="theartof_theartoflovingmoney">
SELECT *
FROM #request.sqlObjectPrefix#tblPeople
WHERE tablePK = <cfqueryparam
cfsqltype="cf_sql_varchar" value="#arguments.personKeyList#">
AND emailAddress = <cfqueryparam
cfsqltype="cf_sql_varchar" value="#arguments.emailAddress#">
</cfquery>
<cfreturn qry_peopleGet>
</cffunction>
On Sat, Jun 7, 2014 at 3:07 AM, Maureen <[email protected]> wrote:
> Or even better, with cfqueryparms
>
> <cffunction access="public" name="f_peopleGet" output="false"
> returntype="query">
> <cfargument name="personKeyList" type="string" required="no" default="">
> <cfargument name="emailAddress" type="string" required="no" default="">
>
> <cfquery name="qry_peopleGet" datasource ="theartof_theartoflovingmoney">
> SELECT *
> FROM #request.sqlObjectPrefix#tblPeople
> WHERE tablePK = <cfqueryparam
> cfsqltype="cf_sql_varchar" value="#arguments.personKeyList#">
> AND emailAddress = <cfqueryparam
> cfsqltype="cf_sql_varchar" value="#arguments.emailAddress">
> </cfquery>
> <cfreturn qry_peopleGet>
> </cffunction>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:370789
Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
