Re: Microsoft update breaks ACF10 admin?

2015-04-11 Thread M.A. Kruger

john. my ops team says to be sure you have upgraded your connectors after 
patching your cf 10 server to the latest patch level. 

Sent from my iPhone

> On Apr 11, 2015, at 2:09 PM, John M Bliss  wrote:
> 
> 
> Hello. Yesterday, I installed Microsoft Updates for Windows Server 2012 and
> today, from Internet Explorer on server, I can no longer surf to:
> 
> http://127.0.0.1/CFIDE/administrator/
> 
> It just spins and spins. Any ideas?
> 
> -- 
> John Bliss - http://www.linkedin.com/in/jbliss
> 
> 
> 

~|
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:360460
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF Builder 3

2015-01-14 Thread M.A. Kruger

Andrew, 

I seem to remember that topstyle shipped "with" cf studio and with homesite. 
how could homesite be a later version of topstyle?

Sent from my iPhone

> On Jan 14, 2015, at 7:16 PM, Andrew Scott  wrote:
> 
> 
> And for fuck sake my name is not Scott, but then if you can get that wrong
> you can get your facts wrong about Studio as well.
> 
> Regards,
> Andrew Scott
> WebSite: http://www.andyscott.id.au/
> Google+:  http://plus.google.com/113032480415921517411
> 
> 
> On Thu, Jan 15, 2015 at 12:15 PM, Andrew Scott 
> wrote:
> 
>> Wil,
>> 
>> I am not sadly misinformed at all.
>> 
>> Nick Bradley created a product called Top Style, which I used extensively
>> in those days. Allaire then purchased that program from Nick and rebadged
>> it as Homesite, Homesite Studio was the first version which followed by the
>> free version called Homesite. Studio did things that Homesite could not do.
>> 
>> Studio was then let go in favor of making Homesite more powerful, hence
>> HomeSite+, problem was that the best features of Studio where lost forever.
>> 
>> So how is that misinformed?
>> 
>> 
>> 
>> 
>> 
>> Regards,
>> Andrew Scott
>> WebSite: http://www.andyscott.id.au/
>> Google+:  http://plus.google.com/113032480415921517411
>> 
>> 
>> On Thu, Jan 15, 2015 at 11:24 AM, Wil Genovese 
>> wrote:
>> 
>>> 
>>> Scott,
>>> 
>>> You are sadly misinformed.  Nick Bradbury created Homesite and then sold
>>> it to Allaire. Later Nick also created Top Style as a stand alone CSS
>>> Editor.
>>> 
>>> Homesite was originally developed in Borland Delphi in 1995 by Nick
>>> Bradbury. Bradbury wrote HomeSite after using HotDogand being frustrated
>>> with it. In March 1997 Allaire Corporation from Cambridge, Massachusetts
>>> (founded by brothers Jeremy and J.J. Allaire) acquired HomeSite and Nick
>>> Bradbury joined Allaire. After leaving Allaire in 1998, Bradbury went on to
>>> work on the CSS/xHTML editor TopStyle and the RSS reader FeedDemon.
>>> Macromedia acquired Allaire in 2001 and was in turn acquired by Adobe in
>>> 2005.
>>> 
>>> Even Wikipedia has it right
>>> http://en.wikipedia.org/wiki/Macromedia_HomeSite
>>> 
>>> 
>>> 
>>> 
>>> Wil Genovese
>>> 
>>> One man with courage makes a majority.
>>> -Andrew Jackson
>>> 
>>> A fine is a tax for doing wrong. A tax is a fine for doing well.
>>> 
 On Jan 14, 2015, at 6:18 PM, Andrew Scott 
>>> wrote:
 
 
 And it was called Top Style before Allaire bought it and rebranded it as
 Homesite Studio in 1996.
 
 Regards,
 Andrew Scott
 WebSite: http://www.andyscott.id.au/
 Google+:  http://plus.google.com/113032480415921517411
 
 
 On Thu, Jan 15, 2015 at 11:16 AM, Andrew Scott >>> 
 wrote:
 
> Sorry that should be 1996 not 1995
> 
> Regards,
> Andrew Scott
> WebSite: http://www.andyscott.id.au/
> Google+:  http://plus.google.com/113032480415921517411
> 
> 
> On Thu, Jan 15, 2015 at 11:14 AM, Andrew Scott <
>>> andr...@andyscott.id.au>
> wrote:
> 
>> I don't know about pre dating it, I have been using Studio since 1995,
>> when Allaire purchased it. They then decided to release Homesite and
>>> then
>> Homesite+
>> 
>> The only difference between the two, was that Studio had far more
>> features. When Studio was discontinued, they then decided to release
>> homesite+
>> 
>> I still have the Homesite Studio Disc with the copyright of 1994 on
>>> it.
>> 
>> 
>> Regards,
>> Andrew Scott
>> WebSite: http://www.andyscott.id.au/
>> Google+:  http://plus.google.com/113032480415921517411
>> 
>> 
>> On Thu, Jan 15, 2015 at 4:51 AM, Dave Watts 
>>> wrote:
>> 
>>> 
 I can never understand why Homesite was so popular, it's bigger
>>> brother was
 the better of the two. Which was Studio.
>>> 
>>> My memory here is a little hazy, as I haven't used either one for a
>>> long time, but I recall it being a little more complicated than that.
>>> 
>>> As Wil mentioned, Homesite predated CF Studio. Allaire purchased it
>>> and kept Nick on to make future versions. The next version was CF
>>> Studio, which was basically Homesite with RDS functionality and
>>> CF-specific code generators and wizards. But after a while, the
>>> product was renamed Homesite+, and still had the RDS functionality
>>> and
>>> CF-specific stuff. So for me at least, I think of all three as
>>> "Homesite", because they're all basically the same thing. Homesite+
>>> was the final version released by Macromedia, and I think it was
>>> still
>>> supported for a while after the Adobe acquisition.
>>> https://www.adobe.com/support/homesite/releasenotes/plus/releasenotes_plus.html
>>> 
>>> Dave Watts, CTO, Fig Leaf Software
>>> 1-202-527-9569
>>> http://www.figleaf.com/
>>> http://training.figleaf.com/
>>> 
>>> Fig Leaf Software is a Service-Disable

Re: Having trouble with cfcI have removed all references to site_theartoflovingcatsanddogs_com and deleted the template cache. No luck. Any help?

2014-07-21 Thread M.A. Kruger

maybe he's a bot? he has no follow through. 

Sent from my iPhone

> On Jul 21, 2014, at 7:37 PM, Russ Michaels  wrote:
> 
> 
> I think I would have to agree.
> He is just posting every single error here and expecting everyone to just
> fix his code for him
> 
> 
>> On Tue, Jul 22, 2014 at 1:32 AM, M.A. Kruger  wrote:
>> 
>> 
>> Matt Q and everyone. I think it might be time to cut matt loose I think
>> he's mostly pulling our chain. he certainly doesn't engage with the list in
>> any way that makes me think he's trying. I'm perfectly fine helping
>> beginners but this is a bit much. perhaps we should ask Mike D to
>> remove him?
>> 
>> Sent from my iPhone
>> 
>>>> On Jul 21, 2014, at 6:53 PM, Matt Quackenbush 
>>> wrote:
>>> 
>>> 
>>> I am trying really, really, really, really hard to not be rude here, but
>>> there's no way you can have 15 years of CF experience as you've claimed
>> in
>>> other threads. Each thread you've posted recently has displayed an
>> absolute
>>> dearth of information with which we can even attempt to help you, but
>>> they've also displayed an absolute clear lack of any troubleshooting
>> effort
>>> of your own. We **WANT** to help people; it's why we are on these mailing
>>> lists. However, you ___must___ be willing to help yourself, first. We are
>>> not your own personal help desk.
>>> 
>>> Please review the following links and then report back.
>>> 
>>> http://www.catb.org/esr/faqs/smart-questions.html
>>> http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/index.html
>>> 
>>> My apologies if I've incorrectly remembered the CF version you're using;
>> I
>>> believe you previously said CF9, so that's the link I provided. If it's
>>> another version, links to the documentation are readily available by
>>> Googling "CF {version number} documentation".
>>> 
>>> Thanks.
>>> 
>>> 
>>> 
>>> On Mon, Jul 21, 2014 at 6:44 PM, Matthew Smith 
>>> wrote:
>>> 
>>>> 
>>>> Could not find the ColdFusion component or interface
>>>> site_theartoflovingcatsanddogs_com.cfcs.qrystodatabase. Ensure that the
>>>> name is correct and that the component or interface exists.  The error
>>>> occurred in *D:/home/fatcate-juice.com/wwwroot/cfcs/paypal.cfc
>>>> <http://fatcate-juice.com/wwwroot/cfcs/paypal.cfc>: line 164*
>>>> *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_settings.cfm: line
>> 48
>>>> *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
>>>> line 191
>>>> *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
>>>> line 33
>>>> *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
>>>> line 1
>>>> *Called from* D:/home/fatcate-juice.com/wwwroot/index.cfm: line 9
>>>> *Called from* D:/home/fatcate-juice.com/wwwroot/Application.cfc: line
>> 61
>>>> 
>>>> 162 :   >>> default="0">
>>>> 163 :   >>> default="">*164 :   >>> component="#request.cfcpath#qrystodatabase" name="qry" />*
>>>> 165 :   >>> qry.qry_unlock_items_for_paypal(
>>>> app_user_id="#arguments.app_user_id#", cfuserid="#arguments.cfuserid#"
>>>> ) />
>>>> 166 : 
>>>> 
>>>> 
>>>> 
>>>> 
>>>> 
>>>> --
>>>> Regards,
>>>> chedder is bedder
> 
> 

~|
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:358948
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Having trouble with cfcI have removed all references to site_theartoflovingcatsanddogs_com and deleted the template cache. No luck. Any help?

2014-07-21 Thread M.A. Kruger

Matt Q and everyone. I think it might be time to cut matt loose I think he's 
mostly pulling our chain. he certainly doesn't engage with the list in any way 
that makes me think he's trying. I'm perfectly fine helping beginners but 
this is a bit much. perhaps we should ask Mike D to remove him?

Sent from my iPhone

> On Jul 21, 2014, at 6:53 PM, Matt Quackenbush  wrote:
> 
> 
> I am trying really, really, really, really hard to not be rude here, but
> there's no way you can have 15 years of CF experience as you've claimed in
> other threads. Each thread you've posted recently has displayed an absolute
> dearth of information with which we can even attempt to help you, but
> they've also displayed an absolute clear lack of any troubleshooting effort
> of your own. We **WANT** to help people; it's why we are on these mailing
> lists. However, you ___must___ be willing to help yourself, first. We are
> not your own personal help desk.
> 
> Please review the following links and then report back.
> 
> http://www.catb.org/esr/faqs/smart-questions.html
> http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/index.html
> 
> My apologies if I've incorrectly remembered the CF version you're using; I
> believe you previously said CF9, so that's the link I provided. If it's
> another version, links to the documentation are readily available by
> Googling "CF {version number} documentation".
> 
> Thanks.
> 
> 
> 
> On Mon, Jul 21, 2014 at 6:44 PM, Matthew Smith 
> wrote:
> 
>> 
>> Could not find the ColdFusion component or interface
>> site_theartoflovingcatsanddogs_com.cfcs.qrystodatabase. Ensure that the
>> name is correct and that the component or interface exists.  The error
>> occurred in *D:/home/fatcate-juice.com/wwwroot/cfcs/paypal.cfc
>> : line 164*
>> *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_settings.cfm: line 48
>> *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
>> line 191
>> *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
>> line 33
>> *Called from* D:/home/fatcate-juice.com/wwwroot/fbx_fusebox30_CF50.cfm:
>> line 1
>> *Called from* D:/home/fatcate-juice.com/wwwroot/index.cfm: line 9
>> *Called from* D:/home/fatcate-juice.com/wwwroot/Application.cfc: line 61
>> 
>> 162 :   > default="0">
>> 163 :   > default="">*164 :   > component="#request.cfcpath#qrystodatabase" name="qry" />*
>> 165 :   > qry.qry_unlock_items_for_paypal(
>> app_user_id="#arguments.app_user_id#", cfuserid="#arguments.cfuserid#"
>> ) />
>> 166 : 
>> 
>> 
>> 
>> 
>> 
>> --
>> Regards,
>> chedder is bedder
> 
> 

~|
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:358945
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: element undefined

2014-07-20 Thread M.A. Kruger

now you simply aren't even trying. 

Sent from my iPhone

> On Jul 20, 2014, at 8:34 AM, Matthew Smith  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 Element CURRENTSITENAME
> is undefined in REQUEST.
> 
> 
> I have this in application.cfc.  What gives?
> Regards,
> chedder is bedder
> 
> 
> 

~|
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:358920
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: help

2014-07-18 Thread M.A. Kruger

wow I never would have guessed. maybe just a bad communicator - trouble really 
describing his problem?

Sent from my iPhone

> On Jul 18, 2014, at 8:30 AM, Matt Quackenbush  wrote:
> 
> 
> Defies logic, especially given certain claims.
> http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358850
> 
> 
> 
>> On Fri, Jul 18, 2014 at 8:26 AM, mac jordan  wrote:
>> 
>> 
>> On Fri, Jul 18, 2014 at 2:21 PM, Dave Watts  wrote:
>> 
 Still doesn't work...?
>>> 
>>> That's still not a URL, is it?
>> 
>> ​It's like pulling teeth …​
>> 
>> 
>> 
>> --
>> mac jordan
>> www.kestrel.org | www.reactivecooking.com |  www.jordan-cats.org
>> twitter: @ramtops
> 
> 

~|
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:358908
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: help

2014-07-18 Thread M.A. Kruger

Matt, 

you need to make a stromger effort to understand what you are being told. we 
can't solve your
problem. we can only help point you in the right direction. 

Sent from my iPhone

> On Jul 18, 2014, at 6:35 AM, Matthew Smith  wrote:
> 
> 
> \taolcad_images\products\resize\qry_latest24items.largepic1
> 
> Still doesn't work...?
>> On Jul 17, 2014, at 23:09, Maureen  wrote:
>> 
>> 
>> As I told you four days ago:
>> Instead of a physical path like C:\magedirector\imagename.ext  you
>> need a url like http://domainname.com/imagedirectory/imagename.ext
>> 
>> You use the physical path to determine if the file exists, but you
>> need the url to display it.
>> 
>>> On Thu, Jul 17, 2014 at 10:37 PM, Matthew Smith  
>>> wrote:
>>> 
>>> Anyone?
>>> 
 On Jul 15, 2014, at 1:59, Matthew Smith  wrote:
 
 Does anyone know what path I should use?  Stuck...
 
> On Jul 13, 2014, at 10:40, Matthew Smith  wrote:
> 
> what path should i use?
> 
> 
>>> On Sun, Jul 13, 2014 at 10:11 AM, Dave Watts  wrote:
>>> 
>>> Yes, this code is broken. You have a logic error.  The code inside the
>>> CFCATCH will only execute of the code in the CFTRY fails.  The syntax
>>> on the CFCATCH tag is wrong as you have no type declared, and the code
>>> on the first line inside the CFCATCH is the same as what you just
>>> tried.  So if it fails on the TRY it will fail inside the CFCATCH.
>> 
>> This is all very accurate except for one portion. CFCATCH doesn't
>> require a type. It's generally recommended that you specify a type,
>> but in the absence of that attribute it'll simply catch any exception
>> thrown by the CFTRY.
>> 
>> Dave Watts, CTO, Fig Leaf Software
>> 1-202-527-9569
>> http://www.figleaf.com/
>> http://training.figleaf.com/
>> 
>> Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
>> GSA Schedule, and provides the highest caliber vendor-authorized
>> instruction at our training centers, online, or onsite.
> 
> 

~|
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:358905
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Restrict the user from editing the excel sheet exported using cfcontent tag.

2014-06-15 Thread M.A. Kruger

Keep in mind that setting a file level password is going to be the lowest form 
of security. it will be easy for even a casually determined user to crack. 

Sent from my iPhone

> On Jun 15, 2014, at 8:03 AM, "C. Hatton Humphrey"  wrote:
> 
> 
> Sathya -
> 
> I'm no expert on CFContent but you might be able to extend the concept
> presented in
> http://www.bennadel.com/blog/461-creating-microsoft-excel-documents-with-coldfusion-and-xml.htm
> which uses a CFSaveContent to create an XML definition of a spreadsheet and
> then CFContent to save the file.
> 
> Digging further, there is also CFSpreadSheet and in
> http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec17cba-7f87.html
> there is a password parameter.which, "Set a password for modifying the
> sheet."
> 
> Hope this helps.
> 
> Until Later!
> C. Hatton Humphrey
> 
> Every cloud does have a silver lining.  Sometimes you just have to do some
> smelting to find it.
> 
> 
> On Sun, Jun 15, 2014 at 2:42 AM, Sathyanarayanan Ramanathan <
> sathya0...@gmail.com> wrote:
> 
>> 
>> Dear Friends,
>> 
>> Is there anyway we can restrict the user from editing the excel sheet
>> exported using cfcontent tag.
> 
> 
> 

~|
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:358742
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

2014-06-14 Thread M.A. Kruger

Matthew, 

the  tag at the end of the code should be removed OR a 
 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  wrote:
> 
> 
>  returntype="void" hint="Unlocks items for paypal.">
>  
>  
>  
>name="qry_unlock_items_for_paypal"
>datasource="#variables.datasource#">
>exec [proc_rhkprod_unlock_items_for_paypal] @app_user_id = 
> ;
>
>
>name="qry_unlock_items_for_paypal"
>datasource="#variables.datasource#">
>exec [proc_rhkprod_unlock_items_for_paypal] @cfuserid = 
> ;
>
>  
> 
>  output="no" returntype="void" hint="Unlocks items for paypal that have been 
> locked for 15 minutes or more.">
>  name="qry_unlock_items_for_paypal_15_minutes"
>datasource="#variables.datasource#">
>exec [proc_rhkprod_unlock_items_for_paypal_15_minutes];
>
> 
> 
> 
> 
> 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 Smithwrote:
>> 
>>  
>>  
>>  
>>  > app_user_id="#arguments.app_user_id#", cfuserid="#arguments.cfuserid#" ) />
>> 
>> > returntype="void">
>>  
>>  > qry.qry_unlock_items_for_paypal_15_minutes() />
>> 
>> > output="no">
>>  
>>  
>>  >
>> app_user_id = "#arguments.app_user_id#"
>>  ) />
>> 
> 
> 
>> On Jun 13, 2014, at 20:42, Matthew Smith  wrote:
>> 
>> > returntype="void" hint="Unlocks items for paypal.">
>>  
>>  
>>  
>>>name="qry_unlock_items_for_paypal"
>>datasource="#variables.datasource#">
>>exec [proc_rhkprod_unlock_items_for_paypal] @app_user_id = 
>> ;
>>
>>
>>>name="qry_unlock_items_for_paypal"
>>datasource="#variables.datasource#">
>>exec [proc_rhkprod_unlock_items_for_paypal] @cfuserid = 
>> ;
>>
>>  
>> 
>> > output="no" returntype="void" hint="Unlocks items for paypal that have been 
>> locked for 15 minutes or more.">
>>  >name="qry_unlock_items_for_paypal_15_minutes"
>>datasource="#variables.datasource#">
>>exec [proc_rhkprod_unlock_items_for_paypal_15_minutes];
>>
>> 
>> 
>> 
>> 
>> 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
>>

Re: Error please site is down for a month now moms site

2014-06-13 Thread M.A. Kruger

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  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 
> 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


Re: Error please site is down for a month now moms site

2014-06-13 Thread M.A. Kruger

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  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  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 : 
> 241 :  returntype="void">
> 242 :   
> 243 :qry.qry_unlock_items_for_paypal_15_minutes() />
> 244 : 
> 
> 
> 

~|
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