<cffunction access="public" name="qry_paypal_refresh_lock_time" output="no"
returntype="void" hint="Resets the lock time for paypal items.">
<cfargument name="app_user_id" type="numeric" required="yes">
<cfquery
name="qry_paypal_refresh_lock_time" datasource =
"theartof_theartoflovingmoney">
update #request.sqlobjectprefix#tblpaypallock
set timestamp = <cfqueryparam
value="#createodbcdatetime(now())#" cfsqltype="CF_SQL_TIMESTAMP">
where app_user_id = <cfqueryparam
cfsqltype="CF_SQL_INTEGER" value="#arguments.app_user_id#">
</cfquery>
</cffunction>
<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_mypersongetting" datasource =
"theartof_theartoflovingmoney">
SELECT *
FROM #request.sqlObjectPrefix#tblPeople
where
1 = 1 and
tablePK = <cfqueryparam
cfsqltype="cf_sql_varchar" value="#arguments.personKeyList#">
AND emailaddress = <cfqueryparam
cfsqltype="cf_sql_varchar" value="#arguments.emailAddress#">
</cfquery>
<cfreturn qry_myperson>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:370796
Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
