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