Re: Error please site is down for a month now moms site
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
declarec777 cursor forward_only for
selecttablepk
,tblProductsFK
,quantity
fromrhkprod_tblpaypallock
WHERE (timestamp = DATEADD(mi, - 15, GETDATE()))
open c777
fetch next
fromc777
into@tablepk
,@tblproductsfk
,@quantity
while @@fetch_status = 0
begin
updaterhkprod_tblproducts
setquantity = quantity + @quantity
whereproductid = @tblproductsfk
andUorLorUL in ('U','L')
delete fromrhkprod_tblpaypallock
wheretablepk = @tablepk
fetch next
fromc777
into@tablepk
,@tblproductsfk
,@quantity
end
close c777
deallocate c777
END
On Fri, Jun 13, 2014 at 8:40 PM, Matthew Smithchedders...@gmail.comwrote:
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
Re: Error please site is down for a month now moms site
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 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
declarec777 cursor forward_only for
selecttablepk
,tblProductsFK
,quantity
fromrhkprod_tblpaypallock
WHERE (timestamp = DATEADD(mi, - 15, GETDATE()))
open c777
fetch next
fromc777
into@tablepk
,@tblproductsfk
,@quantity
while @@fetch_status = 0
begin
updaterhkprod_tblproducts
setquantity = quantity + @quantity
whereproductid = @tblproductsfk
andUorLorUL in ('U','L')
delete fromrhkprod_tblpaypallock
wheretablepk = @tablepk
fetch next
fromc777
into@tablepk
,@tblproductsfk
,@quantity
end
close c777
deallocate c777
END
On Fri, Jun 13, 2014 at 8:40 PM, Matthew Smithchedders...@gmail.comwrote:
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
Re: Error please site is down for a month now moms site
This seems pretty clear... The end tag /cfcomponent encountered on line 1380 at column 3 requires a matching start tag. On Fri, Jun 13, 2014 at 4:11 PM, Matthew Smith chedders...@gmail.com wrote: The web site you are accessing has experienced an unexpected error. Please contact the website administrator. The following information is meant for the website developer for debugging purposes. Error Occurred While Processing Request Context validation error for tag cfcomponent. The end tag /cfcomponent encountered on line 1380 at column 3 requires a matching start tag. The error occurred in D:/Inetpub/redhotkitties/cfcs/paypal.cfc: line 242 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_settings.cfm: line 13 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: line 191 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: line 33 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: line 1 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/index.cfm: line 9 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/Application.cfc: line 62 240 : /cffunction 241 : cffunction name=f_unlock_items_15_minutes access=public returntype=void 242 : cfobject component= /cfcs/qry-todatabase name=qry / 243 : cfset qry_unlock_items_for_paypal_15_minutes = qry.qry_unlock_items_for_paypal_15_minutes() / 244 : /cffunction ~| 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:358716 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Error please site is down for a month now moms site
are you a ColdFusion programmer? this is a syntax error. it's fixable and it is probably NOT mysterious :) Sent from my iPhone On Jun 13, 2014, at 6:11 PM, Matthew Smith chedders...@gmail.com wrote: The web site you are accessing has experienced an unexpected error. Please contact the website administrator. The following information is meant for the website developer for debugging purposes. Error Occurred While Processing Request Context validation error for tag cfcomponent. The end tag /cfcomponent encountered on line 1380 at column 3 requires a matching start tag. The error occurred in D:/Inetpub/redhotkitties/cfcs/paypal.cfc: line 242 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_settings.cfm: line 13 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: line 191 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: line 33 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: line 1 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/index.cfm: line 9 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/Application.cfc: line 62 240 : /cffunction 241 : cffunction name=f_unlock_items_15_minutes access=public returntype=void 242 : cfobject component= /cfcs/qry-todatabase name=qry / 243 : cfset qry_unlock_items_for_paypal_15_minutes = qry.qry_unlock_items_for_paypal_15_minutes() / 244 : /cffunction ~| 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:358717 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Error please site is down for a month now moms site
As a side note, you should probably turn off verbose debugging as well on a live site. :) On Fri, Jun 13, 2014 at 4:19 PM, M.A. Kruger mkru...@cfwebtools.com wrote: are you a ColdFusion programmer? this is a syntax error. it's fixable and it is probably NOT mysterious :) Sent from my iPhone ~| 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:358718 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Error please site is down for a month now moms site
Or at least limit it to your IP On Fri, Jun 13, 2014 at 4:24 PM, Phillip Vector vec...@mostdeadlygame.com wrote: As a side note, you should probably turn off verbose debugging as well on a live site. :) ~| 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:358719 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Error please site is down for a month now moms site
It has it though. On Jun 13, 2014, at 19:13, Phillip Vector vec...@mostdeadlygame.com wrote: This seems pretty clear... The end tag /cfcomponent encountered on line 1380 at column 3 requires a matching start tag. On Fri, Jun 13, 2014 at 4:11 PM, Matthew Smith chedders...@gmail.com wrote: The web site you are accessing has experienced an unexpected error. Please contact the website administrator. The following information is meant for the website developer for debugging purposes. Error Occurred While Processing Request Context validation error for tag cfcomponent. The end tag /cfcomponent encountered on line 1380 at column 3 requires a matching start tag. The error occurred in D:/Inetpub/redhotkitties/cfcs/paypal.cfc: line 242 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_settings.cfm: line 13 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: line 191 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: line 33 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: line 1 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/index.cfm: line 9 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/Application.cfc: line 62 240 : /cffunction 241 : cffunction name=f_unlock_items_15_minutes access=public returntype=void 242 : cfobject component= /cfcs/qry-todatabase name=qry / 243 : cfset qry_unlock_items_for_paypal_15_minutes = qry.qry_unlock_items_for_paypal_15_minutes() / 244 : /cffunction ~| 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:358720 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Error please site is down for a month now moms site
It has it. Been doing this 15 years. On Jun 13, 2014, at 19:19, M.A. Kruger mkru...@cfwebtools.com wrote: are you a ColdFusion programmer? this is a syntax error. it's fixable and it is probably NOT mysterious :) Sent from my iPhone On Jun 13, 2014, at 6:11 PM, Matthew Smith chedders...@gmail.com wrote: The web site you are accessing has experienced an unexpected error. Please contact the website administrator. The following information is meant for the website developer for debugging purposes. Error Occurred While Processing Request Context validation error for tag cfcomponent. The end tag /cfcomponent encountered on line 1380 at column 3 requires a matching start tag. The error occurred in D:/Inetpub/redhotkitties/cfcs/paypal.cfc: line 242 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_settings.cfm: line 13 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: line 191 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: line 33 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: line 1 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/index.cfm: line 9 Called from D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/Application.cfc: line 62 240 : /cffunction 241 : cffunction name=f_unlock_items_15_minutes access=public returntype=void 242 : cfobject component= /cfcs/qry-todatabase name=qry / 243 : cfset qry_unlock_items_for_paypal_15_minutes = qry.qry_unlock_items_for_paypal_15_minutes() / 244 : /cffunction ~| 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:358721 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Error please site is down for a month now moms site
I highly doubt that. But you should know then that we need to see the whole code in order to see if what you are saying is correct. So copy the full file code here and let's take a look. On Fri, Jun 13, 2014 at 4:48 PM, Matthew Smith chedders...@gmail.com wrote: It has it. Been doing this 15 years. ~| 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:358722 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Error please site is down for a month now moms site
cffunction access=public name=f_qry_ordersGet output=no returntype=query cfargument name=orderKeyList type=string required=no default= cfargument name=personKeyList type=string required=no default= cftry cfquery name=f_qry_ordersGet datasource=#variables.datasource# SELECT o.tablePK ,o.tblPeopleFK ,o.createdOn ,o.shippingMethod ,o.itemSubTotal ,o.totalBeforeTax ,o.tax ,o.shippingCost ,o.total ,p.firstName + ' ' + p.lastName AS name FROM #request.sqlObjectPrefix#tblOrders o INNER JOIN #request.sqlObjectPrefix#tblPeople p ON o.tblPeopleFK = p.tablePK WHERE 1 = 1 cfif len(arguments.orderKeyList) AND o.tablePK = cfqueryparam value=#arguments.orderKeyList# cfsqltype=CF_SQL_INTEGER list=Yes /cfif cfif len(arguments.personKeyList) AND o.tblPeopleFK = cfqueryparam value=#arguments.personKeyList# cfsqltype=CF_SQL_INTEGER list=Yes /cfif /cfquery cfcatch cfdump var=#arguments# / cfdump var=#cfcatch.sql# abort=true / /cfcatch /cftry cfreturn f_qry_ordersGet / /cffunction On Fri, Jun 13, 2014 at 7:51 PM, Phillip Vector vec...@mostdeadlygame.com wrote: I highly doubt that. But you should know then that we need to see the whole code in order to see if what you are saying is correct. So copy the full file code here and let's take a look. On Fri, Jun 13, 2014 at 4:48 PM, Matthew Smith chedders...@gmail.com wrote: It has it. Been doing this 15 years. ~| 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:358723 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Error please site is down for a month now moms site
*sigh* This is the code for the function. Please show the full code including the following lines.. 240 : /cffunction 241 : cffunction name=f_unlock_items_15_ minutes access=public returntype=void 242 : cfobject component= /cfcs/qry-todatabase name=qry / 243 : cfset qry_unlock_items_for_paypal_15_minutes = qry.qry_unlock_items_for_paypal_15_minutes() / 244 : /cffunction I want to see if cfcomponent is there. Since these tend to be at the start and end of a file, I would like the full file please. Also, I only have 14 years of experience, so I'm not up there with you at 15, but you shouldn't use cfcatch to display the SQL that was put in. It gives a bad vector for a hacker to put in sql and see what kind of stuff got generated that produced the error. On Fri, Jun 13, 2014 at 4:57 PM, Matthew Smith chedders...@gmail.com wrote: cffunction access=public name=f_qry_ordersGet output=no returntype=query cfargument name=orderKeyList type=string required=no default= cfargument name=personKeyList type=string required=no default= cftry cfquery name=f_qry_ordersGet datasource=#variables.datasource# SELECT o.tablePK ,o.tblPeopleFK ,o.createdOn ,o.shippingMethod ,o.itemSubTotal ,o.totalBeforeTax ,o.tax ,o.shippingCost ,o.total ,p.firstName + ' ' + p.lastName AS name FROM #request.sqlObjectPrefix#tblOrders o INNER JOIN #request.sqlObjectPrefix#tblPeople p ON o.tblPeopleFK = p.tablePK WHERE 1 = 1 cfif len(arguments.orderKeyList) AND o.tablePK = cfqueryparam value=#arguments.orderKeyList# cfsqltype=CF_SQL_INTEGER list=Yes /cfif cfif len(arguments.personKeyList) AND o.tblPeopleFK = cfqueryparam value=#arguments.personKeyList# cfsqltype=CF_SQL_INTEGER list=Yes /cfif /cfquery cfcatch cfdump var=#arguments# / cfdump var=#cfcatch.sql# abort=true / /cfcatch /cftry cfreturn f_qry_ordersGet / /cffunction On Fri, Jun 13, 2014 at 7:51 PM, Phillip Vector vec...@mostdeadlygame.com wrote: I highly doubt that. But you should know then that we need to see the whole code in order to see if what you are saying is correct. So copy the full file code here and let's take a look. On Fri, Jun 13, 2014 at 4:48 PM, Matthew Smith chedders...@gmail.com wrote: It has it. Been doing this 15 years. ~| 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:358724 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Error please site is down for a month now moms site
/cffunction 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 cffunction access=public name=save_express_checkout output=no returntype=struct cfargument name=api_response type=string required=yes cfset variables.response_struct = structnew() cfset variables.response_struct.raw_response = arguments.api_response cfset variables.response_struct.decoded_response = urldecode(arguments.api_response) cfloop list=#arguments.api_response# index=i delimiters= cfset variables.key = urldecode(listgetat( i, 1, = )) cfset variables.value = urldecode(listgetat( i, 2, = )) cfset structinsert(variables.response_struct, variables.key, variables.value) /cfloop cfif not StructKeyExists(variables.response_struct, token) cfset structinsert(variables.response_struct, token,) /cfif cfobject component=#request.cfcpath#qrystodatabase name=qry / On Fri, Jun 13, 2014 at 8:03 PM, Phillip Vector vec...@mostdeadlygame.com wrote: *sigh* This is the code for the function. Please show the full code including the following lines.. 240 : /cffunction 241 : cffunction name=f_unlock_items_15_ minutes access=public returntype=void 242 : cfobject component= /cfcs/qry-todatabase name=qry / 243 : cfset qry_unlock_items_for_paypal_15_minutes = qry.qry_unlock_items_for_paypal_15_minutes() / 244 : /cffunction I want to see if cfcomponent is there. Since these tend to be at the start and end of a file, I would like the full file please. Also, I only have 14 years of experience, so I'm not up there with you at 15, but you shouldn't use cfcatch to display the SQL that was put in. It gives a bad vector for a hacker to put in sql and see what kind of stuff got generated that produced the error. On Fri, Jun 13, 2014 at 4:57 PM, Matthew Smith chedders...@gmail.com wrote: cffunction access=public name=f_qry_ordersGet output=no returntype=query cfargument name=orderKeyList type=string required=no default= cfargument name=personKeyList type=string required=no default= cftry cfquery name=f_qry_ordersGet datasource=#variables.datasource# SELECT o.tablePK ,o.tblPeopleFK ,o.createdOn ,o.shippingMethod ,o.itemSubTotal ,o.totalBeforeTax ,o.tax ,o.shippingCost ,o.total ,p.firstName + ' ' + p.lastName AS name FROM #request.sqlObjectPrefix#tblOrders o INNER JOIN #request.sqlObjectPrefix#tblPeople p ON o.tblPeopleFK = p.tablePK WHERE 1 = 1 cfif len(arguments.orderKeyList) AND o.tablePK = cfqueryparam value=#arguments.orderKeyList# cfsqltype=CF_SQL_INTEGER list=Yes /cfif cfif len(arguments.personKeyList) AND o.tblPeopleFK = cfqueryparam value=#arguments.personKeyList# cfsqltype=CF_SQL_INTEGER list=Yes /cfif /cfquery cfcatch cfdump var=#arguments# / cfdump var=#cfcatch.sql# abort=true / /cfcatch /cftry cfreturn f_qry_ordersGet / /cffunction On Fri, Jun 13, 2014 at 7:51 PM, Phillip Vector vec...@mostdeadlygame.com wrote: I highly doubt that. But you should know then that we need to see the whole code in order to see if what you are saying is correct. So copy the full file code here and let's take a look. On Fri, Jun 13, 2014 at 4:48 PM, Matthew Smith chedders...@gmail.com wrote: It has it. Been doing this 15 years. ~| 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:358725 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Error please site is down for a month now moms site
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:358726 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Error please site is down for a month now moms site
That is some of it.. Not all of it. If you aren't willing to help us, then I don't see any way to help you. On Fri, Jun 13, 2014 at 5:23 PM, Matthew Smith chedders...@gmail.com wrote: /cffunction 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 cffunction access=public name=save_express_checkout output=no returntype=struct cfargument name=api_response type=string required=yes cfset variables.response_struct = structnew() cfset variables.response_struct.raw_response = arguments.api_response cfset variables.response_struct.decoded_response = urldecode(arguments.api_response) cfloop list=#arguments.api_response# index=i delimiters= cfset variables.key = urldecode(listgetat( i, 1, = )) cfset variables.value = urldecode(listgetat( i, 2, = )) cfset structinsert(variables.response_struct, variables.key, variables.value) /cfloop cfif not StructKeyExists(variables.response_struct, token) cfset structinsert(variables.response_struct, token,) /cfif cfobject component=#request.cfcpath#qrystodatabase name=qry / On Fri, Jun 13, 2014 at 8:03 PM, Phillip Vector vec...@mostdeadlygame.com wrote: *sigh* This is the code for the function. Please show the full code including the following lines.. 240 : /cffunction 241 : cffunction name=f_unlock_items_15_ minutes access=public returntype=void 242 : cfobject component= /cfcs/qry-todatabase name=qry / 243 : cfset qry_unlock_items_for_paypal_15_minutes = qry.qry_unlock_items_for_paypal_15_minutes() / 244 : /cffunction I want to see if cfcomponent is there. Since these tend to be at the start and end of a file, I would like the full file please. Also, I only have 14 years of experience, so I'm not up there with you at 15, but you shouldn't use cfcatch to display the SQL that was put in. It gives a bad vector for a hacker to put in sql and see what kind of stuff got generated that produced the error. On Fri, Jun 13, 2014 at 4:57 PM, Matthew Smith chedders...@gmail.com wrote: cffunction access=public name=f_qry_ordersGet output=no returntype=query cfargument name=orderKeyList type=string required=no default= cfargument name=personKeyList type=string required=no default= cftry cfquery name=f_qry_ordersGet datasource=#variables.datasource# SELECT o.tablePK ,o.tblPeopleFK ,o.createdOn ,o.shippingMethod ,o.itemSubTotal ,o.totalBeforeTax ,o.tax ,o.shippingCost ,o.total ,p.firstName + ' ' + p.lastName AS name FROM #request.sqlObjectPrefix#tblOrders o INNER JOIN #request.sqlObjectPrefix#tblPeople p ON o.tblPeopleFK = p.tablePK WHERE 1 = 1 cfif len(arguments.orderKeyList) AND o.tablePK = cfqueryparam value=#arguments.orderKeyList# cfsqltype=CF_SQL_INTEGER list=Yes /cfif cfif len(arguments.personKeyList) AND o.tblPeopleFK = cfqueryparam value=#arguments.personKeyList# cfsqltype=CF_SQL_INTEGER list=Yes /cfif /cfquery cfcatch cfdump var=#arguments# / cfdump var=#cfcatch.sql# abort=true / /cfcatch /cftry cfreturn f_qry_ordersGet / /cffunction On Fri, Jun 13, 2014 at 7:51 PM, Phillip Vector vec...@mostdeadlygame.com wrote: I highly doubt that. But you should know then that we need to see the whole code in order to see if what you are saying is correct. So copy the full file code here and let's take a look. On Fri, Jun 13, 2014 at 4:48 PM, Matthew Smith chedders...@gmail.com wrote: It has it. Been doing this 15 years. ~| 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:358727 Subscription:
Re: Error please site is down for a month now moms site
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:358728 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Error please site is down for a month now moms site
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
declarec777 cursor forward_only for
selecttablepk
,tblProductsFK
,quantity
fromrhkprod_tblpaypallock
WHERE (timestamp = DATEADD(mi, - 15, GETDATE()))
open c777
fetch next
fromc777
into@tablepk
,@tblproductsfk
,@quantity
while @@fetch_status = 0
begin
updaterhkprod_tblproducts
setquantity = quantity + @quantity
whereproductid = @tblproductsfk
andUorLorUL in ('U','L')
delete fromrhkprod_tblpaypallock
wheretablepk = @tablepk
fetch next
fromc777
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:
Re: Error please site is down for a month now moms site
I see the problem.. You don't have a cfcomponent... You want to put one in. :) On Fri, Jun 13, 2014 at 5: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 ~| 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:358730 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Error please site is down for a month now moms site
Matthew, cfcomponent came along with CF6. that was more like 12 or 13 years ago. Sent from my iPhone On Jun 13, 2014, at 6:51 PM, Phillip Vector vec...@mostdeadlygame.com wrote: I highly doubt that. But you should know then that we need to see the whole code in order to see if what you are saying is correct. So copy the full file code here and let's take a look. On Fri, Jun 13, 2014 at 4:48 PM, Matthew Smith chedders...@gmail.com wrote: It has it. Been doing this 15 years. ~| 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:358731 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
