Matthew, the </cfcomponent> tag at the end of the code should be removed OR a <cfcomponent> tag should be added to the top of the file. the two tags serve as bookends and work together. one cannot exist without the other.
Sent from my iPhone > On Jun 14, 2014, at 8:14 AM, Matthew Smith <[email protected]> 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<[email protected]>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 <[email protected]> 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 <[email protected]> >>> 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 >>>> <[email protected]> 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: [email protected] >>>> <mailto:[email protected]> >>>> 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:358734 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
