<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