You need a where clause in your query and you need to change the name
of either the function or the query, as having them both the same is
confusing.
<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 = '#arguments.personKeyList#'
AND emailAddress = '#arguments.emailAddress#'
</cfquery>
<cfreturn qry_peopleGet>
</cffunction>
On Sat, Jun 7, 2014 at 2:52 AM, Matthew Smith <[email protected]> wrote:
>
> Please help...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:370787
Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
