Re: CFImage Error... Unsupported Image Type??
I've just finished working on a photo gallery and now that the client is using it she has an image that is coming up Unsupported Image Type Funny thing is that it's a JPEG that she cropped in Photoshop. Any ideas? Hatton The first thing that came to mind when I read this was progressive JPEG's. They always screwed me if I didn't accomodate them in cffile. Maybe cfimage has a hard time with'em? Then I ran across this blog. http://www.oscararevalo.com/index.cfm/2008/1/26/CFImage-and-PJPEG-Images hth, Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299770 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The unofficial ahphosting status thread
The biggest issue I have now is that CF 8 is going down at least once per day and I have to logon via RDC and restart it. Anyone else with site running seeing this behavior? Yeh, I've been seeing that intermitantly. I have everything up and running tho http went down for about an hour or so yesterday. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299771 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: The unofficial ahphosting status thread
I was referring to CF 8 specifically. I could get http access, but when I couldn't get my sites, I would RDC into the server just to find out that CF had gone offline. I would restart it and all was well. If that happens, I might as well not have http period. It's been running without problem for the last 24 hours, so I hope that tells me most of the problems are being solved. Rick -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Saturday, February 23, 2008 9:55 AM To: CF-Talk Subject: Re: The unofficial ahphosting status thread The biggest issue I have now is that CF 8 is going down at least once per day and I have to logon via RDC and restart it. Anyone else with site running seeing this behavior? Yeh, I've been seeing that intermitantly. I have everything up and running tho http went down for about an hour or so yesterday. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299772 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The unofficial ahphosting status thread
I was referring to CF 8 specifically. I could get http access, but when I couldn't get my sites, I would RDC into the server just to find out that CF had gone offline. I would restart it and all was well. If that happens, I might as well not have http period. It's been running without problem for the last 24 hours, so I hope that tells me most of the problems are being solved. Rick Yes, I have been seeing exactly the same. Http was on top of that. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299773 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Google Map API
Got the following working nicely, thanks to sources for code. Just one thing not happening, no marker is showing ... any ideas please? TIA for any help, Jenny Can be seen working at : http://84.43.72.133/ftol/ftol-devel/Maps-API/untitled.cfm cfset session.GoogleKey = ABQIQWU08SSpxE_NHRopjjFIaRT77izB2FjZNNGJnuNuoc8rFYTfeBSB_tuGNK7BO6Mdxnm e9fXR4yn-_Q cfif isdefined(form.address) cfset session.Address = #form.address# cfset session.Gaddress = replace(session.Address, , +, ALL) cfoutput cfhttp url=http://maps.google.com/maps/geo?q=#session.Gaddress#output=xmlkey=#se ssion.googleKey# method=get resolveurl=yes redirect=yes charset=utf-8 /cfhttp /cfoutput cfscript xml = XMLParse(CFHTTP.FileContent); /cfscript CFOUTPUT cfset dLatitude = #ListGetAt(xml.kml.Response.Placemark.Point.coordinates.XmlText, 1)# cfset dLongitude = #ListGetAt(xml.kml.Response.Placemark.Point.coordinates.XmlText, 2)# /CFOUTPUT cfoutput script src=http://maps.google.com/maps?file=apiamp;v=2amp;key=ABQIQWU08SSpxE _NHRopjjFIaRT77izB2FjZNNGJnuNuoc8rFYTfeBSB_tuGNK7BO6Mdxnme9fXR4yn-_Q type=text/javascript/script script type=text/javascript //![CDATA[ function load() { if (GBrowserIsCompatible()) { var map = new GMap2(document.getElementById(map)); map.setCenter(new GLatLng(#dLongitude#, #dLatitude#), 13); map.addControl(new GLargeMapControl()); map.centerAndZoom(new GPoint(#dLongitude#, #dLatitude#), 3); var point = new GPoint(#dLongitude#, #dLatitude#); var marker = new GMarker(point); map.addOverlay(marker); } } //]] /script /cfoutput cfelse cfset session.address = /cfif !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; html xmlns=http://www.w3.org/1999/xhtml; head meta http-equiv=content-type content=text/html; charset=utf-8/ titleGoogle Maps JavaScript API Example/title /head body onload=load() onunload=GUnload() table width=900 border=0 cellspacing=0 cellpadding=5 tr td table width=100% border=0 cellspacing=0 cellpadding=5 form action= method=post name=address tr tdAddress/td tdinput name=Address type=text id=Address size=30 //td /tr tr tdnbsp;/td tdinput name=Submit type=submit id=Submit value=Submit //td /tr /form /table /td td width=500div id=map style=width: 500px; height: 300px/div/td /tr tr tdnbsp;/td tddiv align=center cfif isdefined(session.address) and session.address neq cfoutputLaditude is #dLatitude#, Longitude is #dLongitude#/cfoutput /cfif /div/td /tr /table /body /html ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299774 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: FckEditor kills FF2's built-in speller
Good thought, cleared FF2 cache still to no avail. Will find another box that has FF2 to try again. Thanks. Have you cleared your browsers cache? Any changes to the FCKEditor config file require browswer cache flush to take effect... Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299775 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Free MS Software for Students - when will Adobe step up?
http://www.adobe.com/products/flex/productinfo/faq/#item-45 There ya go. 2 seconds on google. ;) On Fri, Feb 22, 2008 at 7:28 PM, Russ [EMAIL PROTECTED] wrote: Do we have more information on this free licensing for students? Russ -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Friday, February 22, 2008 8:12 PM To: CF-Talk Subject: Re: Free MS Software for Students - when will Adobe step up? Hi Russ, CF is free to use for up to 2 IP's. Adobe also has free licensing for people working in education as well as students I believe. -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299776 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: The unofficial ahphosting status thread
Rick (and Dominic), On Sat, Feb 23, 2008 at 10:58 AM, Rick Faircloth [EMAIL PROTECTED] wrote: I was referring to CF 8 specifically. I had this problem at the beginning of the week. Greg suggested that, in my case, it had occurred following a reboot he had done. I don't know if he was correct, or if the situation applies in your case, of course. But he suggested that I set a small delay on the CF service start following a boot. He didn't explain why it might make a difference, and it didn't seem like the right time to ask for a lengthy explanation. But here's his suggestion: If the ColdFusion Application Server Service does not start on system reboot the following workaround can be used to modify the time allowed for service startup: 1. Shut down the ColdFusion 8 Application Server service. 2. Open a DOS command window. 3. Run the following command to change directories: cd \cf_root\runtime\bin 4. Run the following command to change the timeout value: jrunsvc.exe -starttimeout 2000 ColdFusion 8 Application Server ___ I haven't actually tried it. And fortunately, I haven't had problems since then. But it's something you might try. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299777 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The unofficial ahphosting status thread
I haven't actually tried it. And fortunately, I haven't had problems since then. But it's something you might try. Thank you Tom :) Dom -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299778 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: The unofficial ahphosting status thread
Thanks for that tip, Tom. Rick -Original Message- From: Tom McNeer [mailto:[EMAIL PROTECTED] Sent: Saturday, February 23, 2008 2:20 PM To: CF-Talk Subject: Re: The unofficial ahphosting status thread Rick (and Dominic), On Sat, Feb 23, 2008 at 10:58 AM, Rick Faircloth [EMAIL PROTECTED] wrote: I was referring to CF 8 specifically. I had this problem at the beginning of the week. Greg suggested that, in my case, it had occurred following a reboot he had done. I don't know if he was correct, or if the situation applies in your case, of course. But he suggested that I set a small delay on the CF service start following a boot. He didn't explain why it might make a difference, and it didn't seem like the right time to ask for a lengthy explanation. But here's his suggestion: If the ColdFusion Application Server Service does not start on system reboot the following workaround can be used to modify the time allowed for service startup: 1. Shut down the ColdFusion 8 Application Server service. 2. Open a DOS command window. 3. Run the following command to change directories: cd \cf_root\runtime\bin 4. Run the following command to change the timeout value: jrunsvc.exe -starttimeout 2000 ColdFusion 8 Application Server ___ I haven't actually tried it. And fortunately, I haven't had problems since then. But it's something you might try. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299779 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFImage Error... Unsupported Image Type??
I've just finished working on a photo gallery and now that the client is using it she has an image that is coming up Unsupported Image Type Funny thing is that it's a JPEG that she cropped in Photoshop. Any ideas? Hatton I replied first thing this morn but it still hasn't come through. It could possibly be a progressive jpeg problem. http://www.oscararevalo.com/index.cfm/2008/1/26/CFImage-and-PJPEG-Images Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299780 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The unofficial ahphosting status thread
I haven't even bothered trying my site (or remote desktop or control panel) figuring work was still being done. just logged into remote desktop successfully. cf 8 app service wasn't started, so i fired it up and things seem to be ok. like most of you, i haven't wanted to contact Greg, figuring he was busy enough dealing with the situation. however, i do hope that we get some sort of all done indication. at this point, if any problems occur, i'm not sure if it's because work is still being done. if it is, i don't want to bug him and i'll just wait it out. but if work is done, and there is still a problem, well, then i figure i'd shoot him an e-mail. so... any word as to whether or not things are (supposed to be) complete? On Sat, Feb 23, 2008 at 1:16 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks for that tip, Tom. Rick -Original Message- From: Tom McNeer [mailto:[EMAIL PROTECTED] Sent: Saturday, February 23, 2008 2:20 PM To: CF-Talk Subject: Re: The unofficial ahphosting status thread Rick (and Dominic), On Sat, Feb 23, 2008 at 10:58 AM, Rick Faircloth [EMAIL PROTECTED] wrote: I was referring to CF 8 specifically. I had this problem at the beginning of the week. Greg suggested that, in my case, it had occurred following a reboot he had done. I don't know if he was correct, or if the situation applies in your case, of course. But he suggested that I set a small delay on the CF service start following a boot. He didn't explain why it might make a difference, and it didn't seem like the right time to ask for a lengthy explanation. But here's his suggestion: If the ColdFusion Application Server Service does not start on system reboot the following workaround can be used to modify the time allowed for service startup: 1. Shut down the ColdFusion 8 Application Server service. 2. Open a DOS command window. 3. Run the following command to change directories: cd \cf_root\runtime\bin 4. Run the following command to change the timeout value: jrunsvc.exe -starttimeout 2000 ColdFusion 8 Application Server ___ I haven't actually tried it. And fortunately, I haven't had problems since then. But it's something you might try. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299781 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: The unofficial ahphosting status thread
No problems here except for access to the VCP. However, I had problems accessing it before the upgrade. Hopefully, that will be available soon, but it's not a big concern for me. Rick -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Saturday, February 23, 2008 5:27 PM To: CF-Talk Subject: Re: The unofficial ahphosting status thread I haven't even bothered trying my site (or remote desktop or control panel) figuring work was still being done. just logged into remote desktop successfully. cf 8 app service wasn't started, so i fired it up and things seem to be ok. like most of you, i haven't wanted to contact Greg, figuring he was busy enough dealing with the situation. however, i do hope that we get some sort of all done indication. at this point, if any problems occur, i'm not sure if it's because work is still being done. if it is, i don't want to bug him and i'll just wait it out. but if work is done, and there is still a problem, well, then i figure i'd shoot him an e-mail. so... any word as to whether or not things are (supposed to be) complete? On Sat, Feb 23, 2008 at 1:16 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks for that tip, Tom. Rick -Original Message- From: Tom McNeer [mailto:[EMAIL PROTECTED] Sent: Saturday, February 23, 2008 2:20 PM To: CF-Talk Subject: Re: The unofficial ahphosting status thread Rick (and Dominic), On Sat, Feb 23, 2008 at 10:58 AM, Rick Faircloth [EMAIL PROTECTED] wrote: I was referring to CF 8 specifically. I had this problem at the beginning of the week. Greg suggested that, in my case, it had occurred following a reboot he had done. I don't know if he was correct, or if the situation applies in your case, of course. But he suggested that I set a small delay on the CF service start following a boot. He didn't explain why it might make a difference, and it didn't seem like the right time to ask for a lengthy explanation. But here's his suggestion: If the ColdFusion Application Server Service does not start on system reboot the following workaround can be used to modify the time allowed for service startup: 1. Shut down the ColdFusion 8 Application Server service. 2. Open a DOS command window. 3. Run the following command to change directories: cd \cf_root\runtime\bin 4. Run the following command to change the timeout value: jrunsvc.exe -starttimeout 2000 ColdFusion 8 Application Server ___ I haven't actually tried it. And fortunately, I haven't had problems since then. But it's something you might try. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299782 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FckEditor kills FF2's built-in speller
Don: Just a suggestion... instead of hunting around for another box, just unzip Portable Firefox into a folder on your desktop and use that. -- Roger Benningfield ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299783 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: The unofficial ahphosting status thread
I understand that answering emails is a time consumming process, but you would think he would at least BLOG his status so that his customers would know what is happening. William William Seiter (mobile) Have you ever read a book that changed your life? go to: http://www.winninginthemargins.com and use passcod: GoldenGrove -Original Message- From: Charlie Griefer [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: 2/23/2008 2:27 PM Subject: Re: The unofficial ahphosting status thread I haven't even bothered trying my site (or remote desktop or control panel) figuring work was still being done. just logged into remote desktop successfully. cf 8 app service wasn't started, so i fired it up and things seem to be ok. like most of you, i haven't wanted to contact Greg, figuring he was busy enough dealing with the situation. however, i do hope that we get some sort of all done indication. at this point, if any problems occur, i'm not sure if it's because work is still being done. if it is, i don't want to bug him and i'll just wait it out. but if work is done, and there is still a problem, well, then i figure i'd shoot him an e-mail. so... any word as to whether or not things are (supposed to be) complete? On Sat, Feb 23, 2008 at 1:16 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks for that tip, Tom. Rick -Original Message- From: Tom McNeer [mailto:[EMAIL PROTECTED] Sent: Saturday, February 23, 2008 2:20 PM To: CF-Talk Subject: Re: The unofficial ahphosting status thread Rick (and Dominic), On Sat, Feb 23, 2008 at 10:58 AM, Rick Faircloth [EMAIL PROTECTED] wrote: I was referring to CF 8 specifically. I had this problem at the beginning of the week. Greg suggested that, in my case, it had occurred following a reboot he had done. I don't know if he was correct, or if the situation applies in your case, of course. But he suggested that I set a small delay on the CF service start following a boot. He didn't explain why it might make a difference, and it didn't seem like the right time to ask for a lengthy explanation. But here's his suggestion: If the ColdFusion Application Server Service does not start on system reboot the following workaround can be used to modify the time allowed for service startup: 1. Shut down the ColdFusion 8 Application Server service. 2. Open a DOS command window. 3. Run the following command to change directories: cd \cf_root\runtime\bin 4. Run the following command to change the timeout value: jrunsvc.exe -starttimeout 2000 ColdFusion 8 Application Server ___ I haven't actually tried it. And fortunately, I haven't had problems since then. But it's something you might try. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299784 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The unofficial ahphosting status thread
The biggest issue I have now is that CF 8 is going down at least once per day and I have to logon via RDC and restart it. Anyone else with site running seeing this behavior? The box I was on never did come back up at all, as Greg put it, it's toast. I'm very glad I didn't wait it out and am running elsewhere nowI really felt I didn't have much choice to at least temporarily move but I've definitely decided it's a permanent move at this point. I realize that the problems were caused by the bad install from his vendor, but this is just the kind of thing that there is always more risk with when using smaller hosts. So I just feel move comfortable being with a larger host that even in the event of something like this happening, has more wherewithal to get people onto other boxes and not just leave them dead in the water for days on end. I'm still waiting for him to zip up and email me some stuff that I had someone else working on and unfortunately hadn't thought to set up a backup for, but I did tell him there's no rush as long as he can get it to me sometime this weekend. Hopefully he'll come through on that. I sure hope your issues are corrected soon. I wouldn't be surprised if there's some legal action against SWSoft after this, I'm sure his financial loses have been pretty bad. I had my share of loses this week too, not the least of which was a contract for a customer that refused to wait while I took care of all the sites and email accounts that were down. This is the 3rd time I've had to switch hosts in the last 4 or 5 months...I really hope I don't have to do this again anytime soon! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299785 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Reporting system too heavy
Hi... I have reporting system that is causing big problems. This is a e-commerce website that runs heavy database transactions every day. We have a web-based (coldfusion) system that displays daily/monthly/yearly sales reports. It runs heavy queries on a single page that do hundreds of complex queries running multiple Select Count(), Select Sum() queries. Some reports take as long as 10 minutes to load just plain text. I want to build a new reporting system that stores the cumulative results of the historical reports in a table, and then whenever a new transaction comes in, I want to simply increment the previously stored results by one. In that sense I am always keeping a running count of the report results. I want to build a cfc/custom tag that keeps a track of new transactions at all times. That is just an overview of what I want to do. I want to invite ideas and experiences about such or similar problems that any of you may have come across and shed some light on some specifics of how you dealt with the issue. Please help. Thanks, Ken ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299786 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reporting system too heavy
What database are you running? Things like this are much better left to the database than the web server. For example, on Oracle I'd write a stored procedure to calculate and return each report's data, then use CF/Flex to show the resulting data. Or I'd make an Oracle view, depending on how complex the query is. It's is amazing what you can do with good query optimization and use of the inherent features found in the database. I do things in Oracle I would never attempt with CF and do them efficiently and fast. I can't remember the last time I wrote an actual query in CF -- almost everything is stored procedures. You can also set up the database to do an increment like you want using triggers, etc. My caution there is that an e-commerce site often needs blazing speed and you'll want to do a lot of testing to be sure you don't slow it down. If you have the knowledge and access to the database, I strongly recommend you let the db handle the data crunching and CF handle the output of the data. Warren Koch ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299787 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: The unofficial ahphosting status thread
I'm sorry for your losses, Mary Jo. For now, I'm staying put with AHP. I just hope this is a once-in-a-decade freak problem. Even though I'm sticking with AHP, I still want some kind of failover, or at least an alternate host I can turn to quickly. I'm going to ask Greg about some kind of failover setup, where, when he installs updates of any kind, if something goes wrong, that backup system can be brought online quickly, with just the change of an IP for the DNS. I want a duplicate setup, up-to-date and ready-to-go at a moment's notice. I'd be willing to pay another 50% of my regular cost for another Virtual Server acting as failover. I may never use it, but with problems like these, I need it. If I have to, I could create a duplicate setup with another host if Greg can't completely isolate the live systems from the backups. I guess I could always get a cheap shared solution to turn to in case of an emergency. I could run MySQL SQL scripts to setup and populate the db's, change the DNS IP, and upload my sites in short order. Then once the VPS is back online, I can just pull everything from the shared host and push it back to the VPS to bring it up-to-date. Using the shared host as a backup for a VPS may be problematic. What solutions for this problem are others of you using? And, btw, Mary Jo, would you mind telling us what host you decided to move to? Rick -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: Saturday, February 23, 2008 6:42 PM To: CF-Talk Subject: Re: The unofficial ahphosting status thread The biggest issue I have now is that CF 8 is going down at least once per day and I have to logon via RDC and restart it. Anyone else with site running seeing this behavior? The box I was on never did come back up at all, as Greg put it, it's toast. I'm very glad I didn't wait it out and am running elsewhere nowI really felt I didn't have much choice to at least temporarily move but I've definitely decided it's a permanent move at this point. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299788 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The unofficial ahphosting status thread
I talked to Greg right before Shabbos and he gave me a breakdown of what happened: --- 1. I requested support on an swsoft product. 2. I was instructed to upgrade as that issue I had was addressed in the upgrade to 4.0 3. I have been around long enough to know that you never load the first release of a new product with out testing. 4. I installed VZ on three servers at my home. I tested all aspects of the software creating migration clone etc. I had no problems outside of path issues on the virtuozzo back up - I use network drives and they want it on the same server 5. I tested a single production server before running the network install that same Firday. 6. Everything seemed fine so we proceeded, (we being myself and SWSoft technician) to upgrade the rest of the server. THE FALL OUT It took about 6 hours before I noticed that things wee starting to bounce on my monitor page. But noting made sense, stuff was all over the place. I first assumed denial of service attack but was wrong. It was simply the VZCORE.SYS drivers becoming more an more corrupted. As this took place the server got more un-stable and then the first BSOD. Next thing I know I am dancing in a sea of blue screens. --- So do I plan to stay with AHPHosting? Yes. Do I blame them for what happened? No. Could this have happened to anyone? Yes. Are SWSoft in trouble? Most probably. Greg isn't the only one bitten by this, just the one we see. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299789 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Reporting system too heavy
I am using MS SQL Server 2005. On Sat, Feb 23, 2008 at 10:08 PM, Craigsell [EMAIL PROTECTED] wrote: What database are you running? Things like this are much better left to the database than the web server. For example, on Oracle I'd write a stored procedure to calculate and return each report's data, then use CF/Flex to show the resulting data. Or I'd make an Oracle view, depending on how complex the query is. It's is amazing what you can do with good query optimization and use of the inherent features found in the database. I do things in Oracle I would never attempt with CF and do them efficiently and fast. I can't remember the last time I wrote an actual query in CF -- almost everything is stored procedures. You can also set up the database to do an increment like you want using triggers, etc. My caution there is that an e-commerce site often needs blazing speed and you'll want to do a lot of testing to be sure you don't slow it down. If you have the knowledge and access to the database, I strongly recommend you let the db handle the data crunching and CF handle the output of the data. Warren Koch ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299790 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Reporting system too heavy
Hi... I have reporting system that is causing big problems. This is a e-commerce website that runs heavy database transactions every day. We have a web-based (coldfusion) system that displays daily/monthly/yearly sales reports. It runs heavy queries on a single page that do hundreds of complex queries running multiple Select Count(), Select Sum() queries. Some reports take as long as 10 minutes to load just plain text. I want to build a new reporting system that stores the cumulative results of the historical reports in a table, and then whenever a new transaction comes in, I want to simply increment the previously stored results by one. In that sense I am always keeping a running count of the report results. I want to build a cfc/custom tag that keeps a track of new transactions at all times. That is just an overview of what I want to do. I want to invite ideas and experiences about such or similar problems that any of you may have come across and shed some light on some specifics of how you dealt with the issue. Running reports against transactional (OLTP) databases often causes this problem, as transactional databases are designed and optimized for adding and changing records, not for reading large numbers of records, aggregating values, etc. You might want to consider using an OLAP database for reporting. OLAP databases are optimized for reporting, instead of processing transactions. To oversimplify a bit, OLAP databases are denormalized, and therefore much faster for reporting. Typically, for this you'd periodically migrate data from your OLTP database to OLAP. Here's an article about using SQL Server's OLAP functionality with CF: http://cfdj.sys-con.com/read/46790.htm Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299791 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8 server - IIS restart when using Web Server Config tool
We've been having some major problems with this Web Server Config tool. Not only is it buggy and seems to kill some of our important clients, but every time a website is added to IIS and it needs assigned to a CF instance, this tool asks to restart the web services for the entire server. Why not just have it configure all virtual servers, instead of rerunning it for each virtual server? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299792 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF generated WSDL (from SSL-requested CFC) does not have HTTP S endpoint.
The webserver the CFC's exist on is SSL enabled, but the WSDL's being generated (when calling the CFC with ?wsdl) have an endpoint that is non-ssl. ... Is this a known issue with 6.1 or CF in general (I don't have any newer versions on SSL to test), or is there something else going on that I'm not grokking? I don't know if it's been resolved in CF 8, but you can work around this by saving the WSDL, editing the endpoint, and using the static WSDL URL for your clients. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299793 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Client Storage
Is there any reason not to share the same client storage database between multiple ColdFusion servers? We have 9 servers which all store their client variables in the same database. This is common for clustered servers. You'll probably want to enable domain-specific cookies with the SETDOMAINCOOKIES attribute of CFAPPLICATION, or its Application.cfc equivalent, if the servers are clustered. If the servers aren't clustered, you might run into a collision between the cookies set by two different cookies, so it might not be a good idea to use a shared database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299794 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Report Builder
First time using this tool and I struggle with something easy. I have added a field to the report. Based on the content of the field, it should show different text. Here's the expression: iif([query.feedesc] = COMMERCIAL, COMMERCIAL BEACH,iif([query.feedesc]=GOVERNMENT,GOVERNMENT OWNED BEACH,),) I keep getting an error: If the expression is a string, ensure that it is within quotes. Error: iif([query.feedesc] = COMMERCIAL, COMMERCIAL BEACH,iif([query.feedesc]=GOVERNMENT,GOVERNMENT OWNED BEACH,),) is not a valid ColdFusion expression. The 2nd and 3rd arguments for Iif are treated as executable CF expressions, not literal strings. If you want literal strings, you'll need to wrap them in the DE function. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299795 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF Report Builder
Yep use DE No different to doing it in ColdFusion. Regards Dale Fraser -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, 24 February 2008 5:42 PM To: CF-Talk Subject: RE: CF Report Builder First time using this tool and I struggle with something easy. I have added a field to the report. Based on the content of the field, it should show different text. Here's the expression: iif([query.feedesc] = COMMERCIAL, COMMERCIAL BEACH,iif([query.feedesc]=GOVERNMENT,GOVERNMENT OWNED BEACH,),) I keep getting an error: If the expression is a string, ensure that it is within quotes. Error: iif([query.feedesc] = COMMERCIAL, COMMERCIAL BEACH,iif([query.feedesc]=GOVERNMENT,GOVERNMENT OWNED BEACH,),) is not a valid ColdFusion expression. The 2nd and 3rd arguments for Iif are treated as executable CF expressions, not literal strings. If you want literal strings, you'll need to wrap them in the DE function. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299796 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
FW: Job opportunity: Senior ColdFusion Developer, Washington D.C.
For database/system administration and development, this position requires proficiency with Oracle 8i or 9i or 10g and/or Microsoft Access database development and administration... Now, talk about polar opposites. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX7 Developer http://blog.cutterscrossing.com The best way to predict the future is to help create it _ Shed those extra pounds with MSN and The Biggest Loser! http://biggestloser.msn.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3655 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11