<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 Jun 13, 2014, at 20:42, Matthew Smith <chedders...@gmail.com> wrote:
>
> <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:358733
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
