<cffunction access="public" name="qry_unlock_items_for_paypal" output="no"
returntype="void" hint="Unlocks items for paypal.">
<cfargument name="app_user_id" type="numeric" required="no" default="0">
<cfargument name="cfuserid" type="string" required="no" default="">
<cfif arguments.app_user_id neq 0>
<cfquery
name="qry_unlock_items_for_paypal"
datasource="#variables.datasource#">
exec [proc_rhkprod_unlock_items_for_paypal] @app_user_id =
<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.app_user_id#">;
</cfquery>
<cfelseif len(arguments.cfuserid)>
<cfquery
name="qry_unlock_items_for_paypal"
datasource="#variables.datasource#">
exec [proc_rhkprod_unlock_items_for_paypal] @cfuserid =
<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#arguments.cfuserid#">;
</cfquery>
</cfif>
</cffunction>
<cffunction access="public" name="qry_unlock_items_for_paypal_15_minutes"
output="no" returntype="void" hint="Unlocks items for paypal that have been
locked for 15 minutes or more.">
<cfquery
name="qry_unlock_items_for_paypal_15_minutes"
datasource="#variables.datasource#">
exec [proc_rhkprod_unlock_items_for_paypal_15_minutes];
</cfquery>
</cffunction>
</cfcomponent>
USE [redhotkitties2005db]
GO
/****** Object: StoredProcedure
[dbo].[proc_rhkprod_unlock_items_for_paypal_15_minutes] Script Date:
06/13/2014 20:41:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[proc_rhkprod_unlock_items_for_paypal_15_minutes]
AS
BEGIN
SET NOCOUNT ON;
declare @tablePK int
,@tblproductsfk int
,@quantity int
declare c777 cursor forward_only for
select tablepk
,tblProductsFK
,quantity
from rhkprod_tblpaypallock
WHERE (timestamp <= DATEADD(mi, - 15, GETDATE()))
open c777
fetch next
from c777
into @tablepk
,@tblproductsfk
,@quantity
while @@fetch_status = 0
begin
update rhkprod_tblproducts
set quantity = quantity + @quantity
where productid = @tblproductsfk
and UorLorUL in ('U','L')
delete from rhkprod_tblpaypallock
where tablepk = @tablepk
fetch next
from c777
into @tablepk
,@tblproductsfk
,@quantity
end
close c777
deallocate c777
END
On Fri, Jun 13, 2014 at 8:40 PM, Matthew Smith <chedders...@gmail.com>
wrote:
> <cffunction name="unlock_items" access="public" returntype="void">
> <cfargument name="app_user_id" type="numeric" required="no" default="0">
> <cfargument name="cfuserid" type="string" required="no" default="">
> <cfobject component="#request.cfcpath#qrystodatabase" name="qry" />
> <cfset qry_unlock_items_for_paypal = qry.qry_unlock_items_for_paypal(
> app_user_id="#arguments.app_user_id#", cfuserid="#arguments.cfuserid#" ) />
> </cffunction>
> <cffunction name="f_unlock_items_15_minutes" access="public"
> returntype="void">
> <cfobject component="#request.cfcpath#qrystodatabase" name="qry" />
> <cfset qry_unlock_items_for_paypal_15_minutes =
> qry.qry_unlock_items_for_paypal_15_minutes() />
> </cffunction>
> <cffunction name="refresh_lock_time" access="public" returntype="void"
> output="no">
> <cfargument name="app_user_id" required="yes" type="numeric">
> <cfobject component="#request.cfcpath#qrystodatabase" name="qry" />
> <cfset variables.temp = qry.qry_paypal_refresh_lock_time (
>
> app_user_id = "#arguments.app_user_id#"
> ) />
> </cffunction>
>
>
> On Fri, Jun 13, 2014 at 8:35 PM, Bryan Stevenson <
> br...@electricedgesystems.com> wrote:
>
>>
>> Matt...post all code from the opening CFCOMPONENT tag to the closing
>> CFCOMPONENT tag
>>
>> All the stuff you have posted so far should be BETWEEN those tags
>>
>> *Bryan Stevenson*B.Comm.
>> President & CEO
>> Electric Edge Systems Group Inc. - makers of FACTS^(TM)
>> phone: 250.480.0642
>> cell: 250.920.8830
>> e-mail: br...@electricedgesystems.com <mailto:
>> br...@electricedgesystems.com>
>> web: www.electricedgesystems.com <http://www.electricedgesystems.com>
>> and www.fisheryfacts.com <http://www.fisheryfacts.com>
>>
>> ------------------------------------------------------------------------
>>
>> Please consider the environment before printing this e-mail
>>
>> -----CONFIDENTIALITY------
>> This message, including any attachments, is confidential and may contain
>> information that is privileged or exempt from disclosure. It is intended
>> only for the person to whom it is addressed unless expressly authorized
>> otherwise by the sender. If you are not an authorized recipient, please
>> notify the sender immediately and permanently destroy all copies of this
>> message and attachments.
>>
>>
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358729
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
