Re: Diagnosing DB / CF problem

2010-11-29 Thread Charlie Stell
I ran into a problem in the past where queries were getting hung - queries that usually executed all the time without issue (and queries that I could copy and paste into analyzer and run just fine). It turned out to be SQL running out of memory and not being able to compile an execution plan. The

RE: Diagnosing DB / CF problem

2010-11-29 Thread Mark A. Kruger
Rick, There's one possibility that comes to mind dealing with networking. See this post. http://www.coldfusionmuse.com/index.cfm/2006/5/25/hanging.threads.network.ca pacity.2 It's a fairly rare error dealing with renegotiation of port speeds/duplexing - but it could mimic the sudden failure

Re: Diagnosing DB / CF problem

2010-11-29 Thread Rick Root
On Sun, Nov 28, 2010 at 9:12 PM, Russ Michaels r...@michaels.me.uk wrote: well I can tell you one of the causes for hung requests, it is visitors closing your page before the request is complete which leaves it in a hung state as there is no where to send the response back to. Not sure if

CF9 Service Randomly Restarting

2010-11-29 Thread Dave Sueltenfuss
We have a CF 9.0.1 server 32 bit, in production that randomly restarts the CF service. From what we can tell, this has been happening since we upgraded from CF7 back in April. There is no pattern that we can see to the restarts either, and the logs don't show us any errors either. It seems to

Re: Diagnosing DB / CF problem

2010-11-29 Thread Rick Root
This might come in handy thanks Dan! On Sun, Nov 28, 2010 at 8:42 PM, Dan Crouch stario...@yahoo.com wrote: I see similar things like that happen sometimes and SeeFusion won't kill them either. In those cases, many times what I can do is run an sp_who on the database and look for the

RE: CF9 Service Randomly Restarting

2010-11-29 Thread Russ Michaels
Dave, CF can't usually restart itself, if it dies then it dies, so you must have something else in the mix. If this is a windows box then check the service properties and see if it is set to restart if unresponsive. Also if you use FusionReactor, the latest version includes options to auto

Re: CF9 Service Randomly Restarting

2010-11-29 Thread Dave Sueltenfuss
Russ, We don't have FusionReactor installed in production, and the service is set to take no action if it fails for any reason -Dave On Mon, Nov 29, 2010 at 10:17 AM, Russ Michaels r...@michaels.me.uk wrote: Dave, CF can't usually restart itself, if it dies then it dies, so you must have

RE: CF9 Service Randomly Restarting

2010-11-29 Thread Russ Michaels
Are you sure CF has actually restarted or is it just your application restarting ? Russ -Original Message- From: Dave Sueltenfuss [mailto:dsueltenf...@gmail.com] Sent: 29 November 2010 15:50 To: cf-talk Subject: Re: CF9 Service Randomly Restarting Russ, We don't have FusionReactor

Re: CF9 Service Randomly Restarting

2010-11-29 Thread Dave Sueltenfuss
Yes, we are recieveing the following error in the Windows Application log 'The ColdFusion 9 Application Server service for the coldfusion server is restarting.' Also, in CF server log, we are seeing the server come back up. -Dave On Mon, Nov 29, 2010 at 10:53 AM, Russ Michaels

Re: CF9 Service Randomly Restarting

2010-11-29 Thread Jason Fisher
Do you have any developers with CF Builder who might be restarting services on the server from Builder's Server tab? From: Dave Sueltenfuss dsueltenf...@gmail.com Sent: Monday, November 29, 2010 11:01 AM To: cf-talk cf-talk@houseoffusion.com Subject:

Re: Diagnosing DB / CF problem

2010-11-29 Thread Cameron Childress
I can second this and have seen it myself in the past. For more supporting opinion, check out Joel Spolky's post about an outage caused by this: http://joelonsoftware.com/items/2008/01/22.html Also, this old post from ye ole (now dead) Guru Blog, based on the same incident from Mark's blog

Re: CF9 Service Randomly Restarting

2010-11-29 Thread Jochem van Dieten
On Mon, Nov 29, 2010 at 4:15 PM, Dave Sueltenfuss wrote: We have a CF 9.0.1 server 32 bit, in production that randomly restarts the CF service. Does it restart the CF service wrapper (jrunsvc.exe) or the CF process (jrun.exe)? If the service wrapper restarts, look outside CF for the cause. If

Re: Excel File Parser for ColdFusion

2010-11-29 Thread Joel Rivera
I have a function that will do just that, its only like 22 lines of code. You have to be careful because if you don't close the resource and the connection you have to restart your coldfusion services... so you may want to throw in a try/catch that does that. With this code you

Re: Excel File Parser for ColdFusion

2010-11-29 Thread Joel Rivera
I have a function that will do just that, its only like 22 lines of code. You have to be careful because if you don't close the resource and the connection you have to restart your coldfusion services... so you may want to throw in a try/catch that does that. With this code you

ProFlashUpload

2010-11-29 Thread M P
Anyone familiar with ProFlashUpload? I downloaded it and got it working yesterday and it was working fine. Today, it only works in IE. Yesterday I know it was working in Firefox, but today, it no longer does. It appears to work (no visible errors), but it doesn't actually upload the file.

Re: Excel File Parser for ColdFusion

2010-11-29 Thread Joel Rivera
Hi Dan, We are just converting our cf4.5 code to cf8 and are having issues with closing an excel file. Since cfusion_disable_dbconnections is function is obsolete from cf 8, do you have a code that closes the excel connection? Joel jriv...@volt.com

Re: Excel File Parser for ColdFusion

2010-11-29 Thread Joel Rivera
:):):) ~| 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:339581

Re: CF9 Service Randomly Restarting

2010-11-29 Thread Dave Sueltenfuss
None of our developers use CF Builder (or have access to the code on the production machine) -Dave On Mon, Nov 29, 2010 at 11:04 AM, Jason Fisher ja...@wanax.com wrote: Do you have any developers with CF Builder who might be restarting services on the server from Builder's Server tab?

Re: CF9 Service Randomly Restarting

2010-11-29 Thread Dave Sueltenfuss
It appears to be the Service Wrapper thats restarting, based on the Windows Application log On Mon, Nov 29, 2010 at 11:20 AM, Jochem van Dieten joch...@gmail.comwrote: On Mon, Nov 29, 2010 at 4:15 PM, Dave Sueltenfuss wrote: We have a CF 9.0.1 server 32 bit, in production that randomly

Re: Free ColdFusion Hosting

2010-11-29 Thread Matthew Lowrey
Thank you everyone! I'm happy to have so many responses (and the humor to boot!) I'm okay with doing business outside my country, but I wanted to first see if there was other places before I went out of my area so to speak. I also do hesitate to jump into something over seas because I've had

Re: COMODO Wiper - Currupt Files - Anybody Know How To Get Them Back?

2010-11-29 Thread Matthew Lowrey
Thanks Mike Dave: I haven't called COMODO on it just yet, but all their forums on this discussion set by other's having the same or similar problems with the program have come back with restore from backup or there's no revert back after wiping files The program seems to work very well! ha!

Re: COMODO Wiper - Currupt Files - Anybody Know How To Get Them Back?

2010-11-29 Thread Dave Watts
The program seems to work very well! ha!  Just a little un-user friendly for newbies using the service.  It also points out that I should have read a little more about this program before using it.  Painful mistake and reminder to back up my files not only on board, but in other locations

CF8: Scheduled Jobs Not Running

2010-11-29 Thread Robert Nurse
Hi All, We're running CF8 on a Solaris box and none of our scheduled apps are running. Even when we run them from the Administrator. Each job has it's own log file and the logs show that the app isn't running. The CF files are owned by the same user that CF runs under and the template

RE: br instead of br /

2010-11-29 Thread Terry Troxel
I was having a bad day the other day for various reasons. But today is much better. Here's a little something I found, that BTW works flawlessly. Hopefully it just might help someone else, because it sure helped me. Terry

Re: br instead of br /

2010-11-29 Thread Matt Quackenbush
Cool beans, Terry. Glad you found what you needed. And thanks for posting back. I'm sure someone else will indeed find it useful. ~| Order the Adobe Coldfusion Anthology now!

Re: CF8: Scheduled Jobs Not Running

2010-11-29 Thread Russ Michaels
have you tried just creating a really simple hello world page and see if that runs as a scheduled task. On Mon, Nov 29, 2010 at 9:00 PM, Robert Nurse rnu...@gmail.com wrote: Hi All, We're running CF8 on a Solaris box and none of our scheduled apps are running. Even when we run them from

Re: br instead of br /

2010-11-29 Thread Aaron M Renfroe
Can't you do a simple search and replace after your done editing? I'm not familiar with fckeditor but it should have some type of replace feature. On Mon, Nov 29, 2010 at 4:35 PM, Matt Quackenbush quackfu...@gmail.comwrote: Cool beans, Terry. Glad you found what you needed. And thanks for

Re: CF8: Scheduled Jobs Not Running

2010-11-29 Thread Russ Michaels
I also discovered just the other day that if you have any kind of url redirection (redirecting www.domain.com to domain.com for example) then scheduled tasks do not work. Russ On Mon, Nov 29, 2010 at 10:18 PM, Russ Michaels r...@michaels.me.uk wrote: have you tried just creating a really

Re: br instead of br /

2010-11-29 Thread Matt Robertson
It doesn't. CF can do it of course as the OP said he was already doing. The solution I have used is to change the doctype but this was already mentioned above. -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com

Get day of week of fourth Thursday of month.

2010-11-29 Thread Ian Skinner
I know I've done this in the past, but for the life of me, my mind is not coming up with any ideas at the moment. I'm looking for an algorithm to to find the calendar date for the x-th day of the n-th week of a month. TIA

Re: Get day of week of fourth Thursday of month.

2010-11-29 Thread Matt Quackenbush
http://www.cflib.org/udf/GetNthOccOfDayInMonth ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: CF9 Service Randomly Restarting

2010-11-29 Thread Jochem van Dieten
On Mon, Nov 29, 2010 at 7:01 PM, Dave Sueltenfuss wrote: It appears to be the Service Wrapper thats restarting, based on the Windows Application log Don't trust the application log, look at the PIDs. Jochem -- Jochem van Dieten http://jochem.vandieten.net/

Re: CF8: Scheduled Jobs Not Running

2010-11-29 Thread Robert Nurse
I also discovered just the other day that if you have any kind of url redirection (redirecting www.domain.com to domain.com for example) then scheduled tasks do not work. Russ Russ, The scheduled templates retrieve an RSS file via cfhttp ... tag. The versions of the templates in

Re: CF8: Scheduled Jobs Not Running

2010-11-29 Thread Russ Michaels
does the scheduler log show any attempt to run them ? On Mon, Nov 29, 2010 at 11:02 PM, Robert Nurse rnu...@gmail.com wrote: I also discovered just the other day that if you have any kind of url redirection (redirecting www.domain.com to domain.com for example) then scheduled tasks do not

Re: Get day of week of fourth Thursday of month.

2010-11-29 Thread Ian Skinner
On 11/29/2010 2:56 PM, Matt Quackenbush wrote: http://www.cflib.org/udf/GetNthOccOfDayInMonth Thanks no thinking involved. Though I was half way there on my own. ~| Order the Adobe Coldfusion Anthology now!

Re: Excel File Parser for ColdFusion

2010-11-29 Thread Dan Baughman
Not off the top of my head, but I recall that you have to close both the resource and the queryobject using a .close function, or the resource handle stays open and you end up having to restart coldfusion every so often. On Mon, Nov 29, 2010 at 10:02 AM, Joel Rivera jriv...@volt.com wrote:

Re: CF8: Scheduled Jobs Not Running

2010-11-29 Thread Robert Nurse
does the scheduler log show any attempt to run them ? Nope. The only log entries that exist are from when I ran the template from my browser manually. Creating a simple Hello World template and scheduling it worked however. I'm not sure why though.

Re: Get day of week of fourth Thursday of month.

2010-11-29 Thread Matt Quackenbush
Heh. Sometimes, like when your brain feels like mush, no thinking involved is a good thing. ;-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion

Re: Get day of week of fourth Thursday of month.

2010-11-29 Thread Ian Skinner
On 11/29/2010 4:18 PM, Matt Quackenbush wrote: Heh. Sometimes, like when your brain feels like mush, no thinking involved is a good thing. ;-) IT SURE i...@#! +infinity ~| Order the Adobe Coldfusion Anthology now!

RE: br instead of br /

2010-11-29 Thread Terry Troxel
Guys, This is the Approved method by Fckeditor FOR Fckeditor. I WAS using search replace but with this method I just edit the Fckeditor JS config file and I am done and can go onto more pressing matters. And if I want it to render proper xhtml, I change it to that Doctype. Why make our

Dreamweaver Templates for us programmer types

2010-11-29 Thread Terry Troxel
This is OT, but maybe some in our community have conquered this. I tried to find a legitimate site to enable me to put Dreamweaver/CSS templates On a website I am putting together to sell my programming skills and let potential Clients pick a graphic design and add the template price to my

lost cf server mx disc

2010-11-29 Thread M S
Hello, I purchased a CF MX server upgrade on ebay. The person that shipped the item put a shipping label on the outside of the CF MX box and didn't tape the box closed well enough. When the item arrived I could tell the box wasn't closed well and apparently the disc fell out of the box along

Re: lost cf server mx disc

2010-11-29 Thread M S
Sorry for posting this in the wrong forum. Moderator please move to the correct forum or delete this post. Thank you, ~| Order the Adobe Coldfusion Anthology now!

Re: lost cf server mx disc

2010-11-29 Thread Dave Watts
Hello, I purchased a CF MX server upgrade on ebay. The person that shipped the item put a shipping label on the outside of the CF MX box and didn't tape the box closed well enough. When the item arrived I could tell the box wasn't closed well and apparently the disc fell out of the box

How to make a CFSELECT Required

2010-11-29 Thread Rick Colman
I want to force the user to select a country code when submitting a form. The select box looks like: cfselect name=countrycode required=Yes size=5 message=Please select a country code. option value= CFIF get04.CountryCode IS ''selected/cfifPlease select/option option value=AU CFIF

Re: How to make a CFSELECT Required

2010-11-29 Thread Dave Watts
I want to force the user to select a country code when submitting a form. The select box looks like: cfselect name=countrycode required=Yes size=5 message=Please select a country code. option value= CFIF get04.CountryCode IS ''selected/cfifPlease select/option option value=AU CFIF

Re: lost cf server mx disc

2010-11-29 Thread M S
Hello Dave, The version is part number CPD060D100 CF MX PRO MP UPG PRO ENGLISH Will I still be able to download this older MX version from the adobe site? Thank you for your reply, Martin Hello, I purchased a CF MX server upgrade on ebay. The person that shipped the item put a shipping

Re: CF9 Service Randomly Restarting

2010-11-29 Thread Carl Meyer
Hi Dave, Are there any HS_ERR_PID.* files in CF\runtime\bin ? What about OUT log any details for the time CF\runtime\logs ? HTH, Carl. None of our developers use CF Builder (or have access to the code on the production machine) -Dave

Re: CF9 Service Randomly Restarting

2010-11-29 Thread Carl Meyer
Hi Dave, Are there any HS_ERR_PID.* files in CF\runtime\bin ? What about OUT log any details for the time CF\runtime\logs ? HTH, Carl. None of our developers use CF Builder (or have access to the code on the production machine) -Dave

RE: lost cf server mx disc

2010-11-29 Thread Andrew Scott
Dave, you can't download CF MX anymore. You can only download the current support versions which as of this email is ColdFusion 9 and 8. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Tuesday, 30 November 2010

RE: CF9 Service Randomly Restarting

2010-11-29 Thread Mark A. Kruger
That's the right track for this look for log files in the /bin directory... my guess is you have hot spot errors that are killing the server. Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original

RE: lost cf server mx disc

2010-11-29 Thread Andrew Scott
My first thought would be to contact the person you bought it from (Ebay seller), but unless you paid something like $200 or less you should have bought ColdFusion 8 or 9. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: M S [mailto:rrock...@aol.com] Sent:

Re: How to make a CFSELECT Required

2010-11-29 Thread Azadi Saryev
as per cfml documentation, to make cfselecta required field you have to set the value of the default option (the pre-selected option which user has to change) to a signe space string option value= CFIF get04.CountryCode IS ''selected/cfifPlease select/option Azadi On 30/11/2010 12:23 ,