Re: 404's
I can been caught by this too when setting up a new windows server. Very frustrating, especially after you find out it is a double extension issue. Randy On Wed, Feb 19, 2014 at 12:56 PM, Russ Michaels r...@michaels.me.uk wrote: Well if other files wotk fine then it is not going to be a web server issur. How about just deleting and recreating the file. Make sure you have not doubled up the extension, which I have seen done many times with extensions hidden. Russ Michaels www.michaels.me.uk cfmldeveloper.com cflive.net cfsearch.com On 19 Feb 2014 15:28, John M Bliss bliss.j...@gmail.com wrote: I'm not sure. Site has hundreds of .cfm files. index.cfm works fine, some .htm and image files work fine, http://my.domain.com/formhandler.cfm is 404. On Wed, Feb 19, 2014 at 10:23 AM, Russ Michaels r...@michaels.me.uk wrote: yes I noted you said it was IIS, thus why I asked about the web.config, which of course only applies to IIS is that any other files have this issue ? On Wed, Feb 19, 2014 at 2:33 PM, John M Bliss bliss.j...@gmail.com wrote: I don't have a web.config. Also, this is IIS. On Wed, Feb 19, 2014 at 9:29 AM, Russ Michaels r...@michaels.me.uk wrote: you don;t have any rewrite rules in your web.config do you which may be causing this On Tue, Feb 18, 2014 at 8:44 PM, John M Bliss bliss.j...@gmail.com wrote: Just installed a legacy CF app under IIS, got index.cfm to run fine with a form submitting to another .cfm file. Upon submitting form, location bar changes to http://my.domain.com/formhandler.cfm and that file is definitely in the webroot with the same permissions as index.cfm...but IIS returns a 404 error. Any ideas about what to look for next? -- 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:357707 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Application Log Not Archiving from CF Administrator
Does anyone have any suggestions with this? I still have not figured this out yet, even changing permissions. Randy On Mon, Apr 2, 2012 at 12:19 PM, Randy Johnson ra...@randy.cc wrote: I have a weird issue going on with a CF9 install on windows server 2008. The application log file will not archive when clicking the icon. I have tried this from the server and my local machine. I do not see any error messages being generated. Think it could be a permissions issue? Any other ideas? Thanks! Randy ~| 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:351374 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
404 errors in the application log
Hello, Is there a way to prevent 404 error messages from showing up in the application log? Thanks! Randy ~| 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:350608 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: 404 errors in the application log
You could also implement an onMissingTemplate() method in your Application.cfc, which I think is a CF9 feature. Thanks, I will go this route. Randy ~| 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:350611 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: 404 errors in the application log
You could also implement an onMissingTemplate() method in your Application.cfc, which I think is a CF9 feature. This is the suggestion I'd recommend, and it's available in CF 8 as well. Thanks, this is what I will do. Randy ~| 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:350612 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Application Log Not Archiving from CF Administrator
I have a weird issue going on with a CF9 install on windows server 2008. The application log file will not archive when clicking the icon. I have tried this from the server and my local machine. I do not see any error messages being generated. Think it could be a permissions issue? Any other ideas? Thanks! Randy ~| 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:350614 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Setting Static Image Expire
Hello, I do not see any image flickering going on with IE. I do see that your background image is a little over 1MB in size. You should really work on optimizing that. A google search provides a lot of info: http://www.google.com/search?hl=ensource=hpq=add+expires+header+to+imagesaq=1oq=add+expiraqi=g10 http://www.google.com/search?hl=ensource=hpq=add+expires+header+to+imagesaq=1oq=add+expiraqi=g10if that link doesn't work search for: add expires header to images Randy On Sat, Dec 5, 2009 at 1:14 PM, Jessica Kennedy police_kidnapped_your_child...@yahoo.com wrote: nothing... really? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328892 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
URL Scope and Form Scope
Hello, I was surprised today that the following code actually displayed a value: http://www.cftools.test/formtest.cfm?form.test=test Here is the code: cfoutput #form.test# /cfoutput Why does this work? Is it considered a bug? I did find that if I referenced the form variable like this #form[test]#, it doesn't work as above. -Randy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313359 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: URL Scope and Form Scope
Up until know I thought that scoping variables with form. that you were guaranteed those variables were coming from a form post. So now my question is how do you guarantee that the variable came from the form scope? is using form[firstname] sufficient? What about checking cgi.REQUEST_METHOD for post? Can that variable be spoofed? Thanks! Randy Dave Watts wrote: I was surprised today that the following code actually displayed a value: http://www.cftools.test/formtest.cfm?form.test=test Here is the code: cfoutput #form.test# /cfoutput Why does this work? Is it considered a bug? I did find that if I referenced the form variable like this #form[test]#, it doesn't work as above. You're creating a variable named URL.form.test, and CF 8 is relaxed enough to not give you a hard time about it. However, there's no form scope there really, just the URL scope, which is why the second reference doesn't work. My guess is that if you referenced URL.form[test], it would work fine. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313362 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Weird Time Issue Between Linux and Windows Server
Paul, The one linux server Is on Central Time Zone, The other linux server is on pacific time zone. The windows server is on Eastern Time Zone. -Randy Paul Hastings wrote: Randy Johnson - CFConcepts wrote: Any ideas on what is going on? I cannot seem to find anything that indicates what is going on. are both boxes in the same timezone (tz)? what tz is the linux box in? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311675 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Weird Time Issue Between Linux and Windows Server
Hello, The following code displays different dates whether it is ran on a windows machine or a linux machine. form.thedates are javascript times that get passed in. cfset form.thedates=122050080|122110560|122171040|122231520| cfloop list=#form.theDates# index=i DELIMITERS=| cfset theDate = DateAdd(s,i/1000,DateConvert(utc2Local, January 1 1970 00:00)) cfoutput #thedate# br /cfoutput /cfloop On linux here is what it displays: {ts '2008-09-03 23:00:00'} {ts '2008-09-10 23:00:00'} {ts '2008-09-17 23:00:00'} {ts '2008-09-24 23:00:00'} On windows here is what it displays (Which is correct) {ts '2008-09-04 00:00:00'} {ts '2008-09-11 00:00:00'} {ts '2008-09-18 00:00:00'} {ts '2008-09-25 00:00:00'} Any ideas on what is going on? I cannot seem to find anything that indicates what is going on. I have tested this on Coldfusion 8 on Windows / Linux BD 7 on Linux and on both linux tests the dates are off by 1 day, well actually it looks like 1 hour. -Randy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311645 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Weird Time Issue Between Linux and Windows Server
Here is the out of a command I found to show you the DST dates: zdump -v /etc/localtime | grep 2008 /etc/localtime Sun Mar 9 06:59:59 2008 UTC = Sun Mar 9 01:59:59 2008 EST isdst=0 gmtoff=-18000 /etc/localtime Sun Mar 9 07:00:00 2008 UTC = Sun Mar 9 03:00:00 2008 EDT isdst=1 gmtoff=-14400 /etc/localtime Sun Nov 2 05:59:59 2008 UTC = Sun Nov 2 01:59:59 2008 EDT isdst=1 gmtoff=-14400 /etc/localtime Sun Nov 2 06:00:00 2008 UTC = Sun Nov 2 01:00:00 2008 EST isdst=0 gmtoff=-18000 zdump -v /etc/localtime | grep 2007 /etc/localtime Sun Mar 11 06:59:59 2007 UTC = Sun Mar 11 01:59:59 2007 EST isdst=0 gmtoff=-18000 /etc/localtime Sun Mar 11 07:00:00 2007 UTC = Sun Mar 11 03:00:00 2007 EDT isdst=1 gmtoff=-14400 /etc/localtime Sun Nov 4 05:59:59 2007 UTC = Sun Nov 4 01:59:59 2007 EDT isdst=1 gmtoff=-14400 /etc/localtime Sun Nov 4 06:00:00 2007 UTC = Sun Nov 4 01:00:00 2007 EST isdst=0 gmtoff=-18000 -Randy Carl Von Stetten wrote: Randy, Looks like a DST issue on Linux. Carl Randy Johnson - CFConcepts wrote: Hello, The following code displays different dates whether it is ran on a windows machine or a linux machine. form.thedates are javascript times that get passed in. cfset form.thedates=122050080|122110560|122171040|122231520| cfloop list=#form.theDates# index=i DELIMITERS=| cfset theDate = DateAdd(s,i/1000,DateConvert(utc2Local, January 1 1970 00:00)) cfoutput #thedate# br /cfoutput /cfloop On linux here is what it displays: {ts '2008-09-03 23:00:00'} {ts '2008-09-10 23:00:00'} {ts '2008-09-17 23:00:00'} {ts '2008-09-24 23:00:00'} On windows here is what it displays (Which is correct) {ts '2008-09-04 00:00:00'} {ts '2008-09-11 00:00:00'} {ts '2008-09-18 00:00:00'} {ts '2008-09-25 00:00:00'} Any ideas on what is going on? I cannot seem to find anything that indicates what is going on. I have tested this on Coldfusion 8 on Windows / Linux BD 7 on Linux and on both linux tests the dates are off by 1 day, well actually it looks like 1 hour. -Randy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311647 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HELP! SQL Injection Attack!
No, that's exactly what he described. The attack appends JavaScript to character fields. And, unfortunately, blocking specific IP addresses won't get you very far here, because it's a random, automated attack run from compromised hosts in a botnet, I think. Yea I think it is too. I started tracking ip's on a page that I saw always showing up in FusionReactor. This morning I am up to 378 ipaddresses blocked within the last three days. I started out by emailing myself the ip address thinking it would only be a few ips. I cannot believe how bad the issue is... -Randy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310358 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Result in cfquery
Hello, Would putting result=qryResults in my CFQUERY tags cause any performance hits or excess memory usage? I was thinking of creating a script that could be used on our production server to show some debugging information since we do not have debugging turned on. I was thinking it would work something like this: cfquery name=getContacts datasource=#application.dsn# result=qryresults.getContactsResults Select fname,lname,email from contacts; /cfquery And then in the Application.cfc using onRequestEnd to check to see if the debug flag was checked cfif dev.debug is true cfdump var=#qryresults# /cfif Any thoughts? -Randy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307733 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How do you create a scalable solution?
Hello, I have been reading about Twitter having scalability issues lately. This morning I was thinking to myself: If I had to make a site like Twitter that was scalable, how would I do that? Then it hit me, I don't really know how to make a site scalable. I have read and heard about things like: Load Balancers, Server Clusters etc... My answer has always been I would work with my hosting company if I ever needed to start dealing with that stuff. They are professionals, they will be able to set that up for me. That may or may not be a good answer for the hardware part of scalability. But really that's only part of it. My coldfusion site needs to be coded to be scalable too.. So I decided to do some research. I googled Scalable Coldfusion: http://articles.techrepublic.com.com/5100-10878_11-1045128.html talks about coldfusion being scalable, but is a little outdated. It was published in 2002. http://livedocs.adobe.com/coldfusion/6/Using_ClusterCATS/overview.htm talks about Scalability and Availability. It's a good read about the different hardware and software options. I read some other articles about making sure that you cache queries at all costs, make sure not to use Select *, being cautious of links etc, making sure code is organized and modular as possible. This was a good overview: http://www.adobepress.com/articles/article.asp?p=31089seqNum=1 It is one of Ben Forta's books. It had a lot of cool basics in there. So writing code to be scalable doesn't seem to be all that difficult, writing good efficient code in a modular way seems to be a good start. I am sure there is more to it. The next component is databases. I have read with Mysql that replication is how you can use multiple databases. I haven't done to much research on this, my initial questions would you use a db server for users, a db server for messages, db for each component?? If one DB server goes down, how would CF Server know to switch to another one. I need to do more research. I also have read about geocoded servers. Not sure what the proper term is, but from what I understand it is where you have servers around the country or globe and based on the user's ip address the user would download graphics and other site items from those servers making things quicker. I know a few people on this list have setup Scalable websites, clusters, load balancing etc. Where did you all learn how to do such things? Did you learn based on trial and error? Is there 1 or 2 comprehensive resources that have all this information or did you have to research each piece separately? Thank you to anyone who would like to provide their feedback. I am not asking you to do my research, I am curious to learn how you got started, and any other helpful feedback you may have and any resources that were crucial in helping you create a scalable website solution. Thanks! Randy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306603 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
How do you create a scalable solution?
Hello, I sent this yesterday around 2PM EDT and it did not seem to go through so I am sending again. Sorry if they both come through. I have been reading about Twitter having scalability issues lately. This morning I was thinking to myself: If I had to make a site like Twitter that was scalable, how would I do that? Then it hit me, I don't really know how to make a site scalable. I have read and heard about things like: Load Balancers, Server Clusters etc... My answer has always been I would work with my hosting company if I ever needed to start dealing with that stuff. They are professionals, they will be able to set that up for me. That may or may not be a good answer for the hardware part of scalability. But really that's only part of it. My coldfusion site needs to be coded to be scalable too.. So I decided to do some research. I googled Scalable Coldfusion: http://articles.techrepublic.com.com/5100-10878_11-1045128.html talks about coldfusion being scalable, but is a little outdated. It was published in 2002. http://livedocs.adobe.com/coldfusion/6/Using_ClusterCATS/overview.htm talks about Scalability and Availability. It's a good read about the different hardware and software options. I read some other articles about making sure that you cache queries at all costs, make sure not to use Select *, being cautious of links etc, making sure code is organized and modular as possible. This was a good overview: http://www.adobepress.com/articles/article.asp?p=31089seqNum=1 It is one of Ben Forta's books. It had a lot of cool basics in there. So writing code to be scalable doesn't seem to be all that difficult, writing good efficient code in a modular way seems to be a good start. I am sure there is more to it. The next component is databases. I have read with Mysql that replication is how you can use multiple databases. I haven't done to much research on this, my initial questions would you use a db server for users, a db server for messages, db for each component?? If one DB server goes down, how would CF Server know to switch to another one. I need to do more research. I also have read about geocoded servers. Not sure what the proper term is, but from what I understand it is where you have servers around the country or globe and based on the user's ip address the user would download graphics and other site items from those servers making things quicker. I know a few people on this list have setup Scalable websites, clusters, load balancing etc. Where did you all learn how to do such things? Did you learn based on trial and error? Is there 1 or 2 comprehensive resources that have all this information or did you have to research each piece separately? Thank you to anyone who would like to provide their feedback. I am not asking you to do my research, I am curious to learn how you got started, and any other helpful feedback you may have and any resources that were crucial in helping you create a scalable website solution. Thanks! Randy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306606 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: weird issue in browser with cf8 and long execution times
I actually had this same thing happen with a long running PHP script. That being said it seems to be a browser issue because the PHP page was on a different machine. I will have to do some testing in a different browser and see what happens. Right now I am using the latest version of Firefox 2.x -Randy On Mon, Apr 14, 2008 at 3:10 AM, rex [EMAIL PROTECTED] wrote: Yes, Ravi is correct. If CF is not connected to your webserver, the CFML will not run at all, and data will not be inserted. Are you doing some kind of cfheader/cfcontent, or javascript relocate somewhere? I'm thinking if your code does something like this: 1. get the XML 2. parse through it 3. do your cfcontent, or serve up another page that results in the blank file 4. loop through your data and insert into DB 1 and 2 is why it takes a while to have that dialog box to save index.cfm come up. 3 is what makes that dialog box come up 4 keeps on going because the request has been made. You've confirmed this in MySQL. It's like a user going to long_running_page.cfm, and then not waiting for the page to load and navigate to any_other_page.cfm. long_running_page.cfm is still executing on the server, even though the user is totally unaware of it (most users anyway). If it was the web connector, then the cfm file would never execute, and just get served up like ordinary html, by either displaying the unparsed cfml, or asking the file to be saved. [STS] Ravi Gehlot wrote: It is weird that it asks you to save the index.cfm file. The only time I had that problem was when IIS was not configured to open CFM files. Same had happened with Apache. But since you are saying that the process are running on the background with data being inserted into the database it makes me think that this is not a problem of adding CFM to IIS/Apache Index Directory. Ravi. On Sun, Apr 13, 2008 at 7:30 AM, Rick Faircloth [EMAIL PROTECTED] wrote: I remember getting that error when trying to complete a long-running cfftp request. It's been awhile, and I'm not sure what actually solved the issue, but I did look back at the file and remember adding cfsetting requesttimeout=6 to the code at the top of the page. Perhaps setting a high requesttimeout will help. If I think of something else, I'll pass it on to you. Rick -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED] Sent: Sunday, April 13, 2008 12:15 AM To: CF-Talk Subject: weird issue in browser with cf8 and long execution times Hello, I am running CF8 Standard. I am running a page that takes a few minutes to run. After a certain amount of time a gray box will popup and ask me to save the index.cfm file or open it. When I open it or save it the file is always blank. When this happens it looks like the page is done executing in the browser but if you look in the task manager you see that JRUN is still using the CPU. I have also confirmed that the page is still running by doing a refresh in Navicat which shows that more rows are being added to the database table. The page is reading an XML file, parsing it and then looping over to insert data into the database. Has anyone seen this before or know what I need to do to stop it from happening? Thanks! Randy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303331 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
weird issue in browser with cf8 and long execution times
Hello, I am running CF8 Standard. I am running a page that takes a few minutes to run. After a certain amount of time a gray box will popup and ask me to save the index.cfm file or open it. When I open it or save it the file is always blank. When this happens it looks like the page is done executing in the browser but if you look in the task manager you see that JRUN is still using the CPU. I have also confirmed that the page is still running by doing a refresh in Navicat which shows that more rows are being added to the database table. The page is reading an XML file, parsing it and then looping over to insert data into the database. Has anyone seen this before or know what I need to do to stop it from happening? Thanks! Randy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303244 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Detableize
Hello, I am having trouble getting this udf to handle the opening table line http://cflib.org/udf.cfm?ID=1293 For Example: table border=0 cellpadding=8 the udf can handle table but it doesn't seem to handle the above one. Thanks! Randy ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290027 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: PHP or .Net?
I don't think he was saying it wouldn't work with other DB's. I think he might have been implying that a lot of asp.net programming uses MSSQL databases which makes sense considering it is a windows based programming language. -Randy ---Original Message--- From: Bruce Sorge Date: 09/05/07 12:53:52 To: CF-Talk Subject: RE: PHP or .Net? This is not true. .NET can work with Oracle, MySql, Access, SQL Server and DB2. Bruce -Original Message- From: David Morgan Sent: Wednesday, September 05, 2007 8:51 AM To: CF-Talk Subject: re: PHP or .Net? With all of that said, I am a Mac guy...Visual Studio is a Windows app and even with an intel mac - I hate working in winndows unless I HAVE to and have only been workng with MySQL in my limited CF time. Creating ASP.Net apps, you can expect to have to become confortable working with the MS SQL DBs. David ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287869 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Is cfqueryparam worth it?
Should I really switch my queries over to something like this: SELECT username FROM user where userID = cfqueryparam CFSQLType=CF_SQL_INTEGER value=#int(URL.user_id)# I would do without the Int part, myself, and just catch the appropriate Exception. That's what exceptions are for! Wouldn't it be better to validate the URL.user_id before getting to the query? -Randy ---Original Message--- From: Dave Watts Date: 08/10/07 12:28:08 To: CF-Talk Subject: RE: Is cfqueryparam worth it? the nice thing about this is that if URL.userID isn't an integer, int() returns 0, and the query executes and simply returns no records. For us, this is a far preferable method than what cfqueryparam would do, which is to bomb before executing the query. You'd rather run a query unnecessarily than avoid running the query? Why not just catch the exception? Then today I discovered that cfqueryparam supports bind variables, which theoretically will improve database performance. So now the question is: how much does it improve performance? Am I really going to notice it? In some cases, you'll see significant performance increases. In other cases, you won't. In still other cases, you may see performance degradation. All that said, I'd recommend that you use it in every case, because it will generally provide better performance in most cases. Should I really switch my queries over to something like this: SELECT username FROM user where userID = cfqueryparam CFSQLType=CF_SQL_INTEGER value=#int(URL.user_id)# I would do without the Int part, myself, and just catch the appropriate exception. That's what exceptions are for! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287155 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfbooks.cfm for CF 8
Does anyone know where an updated cfbooks.chm file would be for CF8 if one has been done yet? -Randy ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284801 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfbooks.cfm for CF 8
Sean Corfield wrote: On 7/30/07, Randy Johnson [EMAIL PROTECTED] wrote: Does anyone know where an updated cfbooks.chm file would be for CF8 if one has been done yet? What's cfbooks.chm? It is the the coldfusion documentation CHM file that is found in the dreamweaver help folder. I really like it because it makes searching the CF docs really quick and easy. -Randy ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284869 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Stopping a Screen Scrape
MS Excel will allow you to copy and paste a table into it and it will magically convert it, so it will take more than a hidden div with funky characters to stop them from scraping it. If the data is in table format, unless you some how managed to randomize the columns and keep the formatting straight I don't see how you could stop them. -Randy Alan Rother wrote: I think as an intellectual challenge it would be fun to try to thwart the screen scraper, but how much does the upgrade cost? I don't really personally care or want to know what you charge for the upgrade, but think of it in terms of, We charge $xx.xx for the upgrade, the fix is going to take me x hours to do and they might find a way around it once I'm done. Is it worth my time to make this change If you still want to do it, I would recommend adding a hidden div with a big ole chunk of random chars in it. It won't show up to the user, but the scraper will choke on it. =] On 7/18/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: You charge people to export content from a web app?!? It would seem these users are wise enough to realise that no matter what approach you take, they will get the content from the page. Print Screen, CTRL-V etc etc etc. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Jason Liebgott To: CF-Talk Sent: Wed Jul 18 17:59:23 2007 Subject: Stopping a Screen Scrape Just started working on a legacy application built in CF5. It appears that one of the users is screen scraping printer friendly HTML output and moving the data into quick books in order to avoid paying for the export upgrade. Ideas I've had to muck up the data to stop the scraper: 1. random white chars that wouldn't be visible to the user in Printer Friendly, but would alter the values enough to make it a pain in quick books. Might have issues w/ printing. 2. random # of empty TD cells 3. convert text to .gif Has anybody dealt w/ this issue? What did you do? Thanks, Jason ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Stopping a Screen Scrape
we know that they are downloading it for quickbooks import to the easiest way to stop that would be to save it as a graphic. You may be able to import the graphic into quickbooks but it is not going to import the information line by line. They would have to manually enter the data. -Randy Robertson-Ravo, Neil (RX) wrote: Regardless I think there is no way you can stop anyone from taking content be it via scraping automaticall or by pressing print screen. You can no doubt make it harder but I doubt you will be able to prevent it. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Jason Liebgott To: CF-Talk Sent: Wed Jul 18 18:53:19 2007 Subject: Re: Stopping a Screen Scrape I don't charge anybody anything. I'm a programmer. I don't make up the sales rules or talk to clients. This company has offered clients a Lite version for a reduced price and one of the features is a print friendly of a report. I have no idea how much the upgrade costs - but it comes with export functionality - ports it into flat file or whatever you want. Again, I didn't make this decision... I'm just the guy trying to make it work. Good or bad business? I'm like switzerland on this stuff. You charge people to export content from a web app?!? It would seem these users are wise enough to realise that no matter what approach you take, they will get the content from the page. Print Screen, CTRL-V etc etc etc. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284045 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Stopping a Screen Scrape
I am not sure I agree with your statement. If I choose to make my printer friendly page a graphic instead of a standard html table as long as it still prints fine you would have no recourse. About the only thing you could do is take your business elsewhere. Right? -Randy Cameron Childress wrote: Does this application contain financial data for the company? Are they attempting to get access to their own financial information in order to put it into QB and run their business? Your employer wants to prevent them from doing this? This raises a ton of ethical and moral questions. I know you are not the one making the call here, but seriously, if a company I was doing business with was ACTIVELY preventing me from gaining access to my own financial data things could escalate very quickly. Having said that - if this company is actually doing something that violates a legal agreement you have with them somehow, simply shutting off access to the site should fix the problem. If this is data going into QB, they much be authenticating to get to it (unless the financial data is out in the open for all to see). Just shut them off and resolve it. -Cameron Jason Liebgott wrote: Just started working on a legacy application built in CF5. It appears that one of the users is screen scraping printer friendly HTML output and moving the data into quick books in order to avoid paying for the export upgrade. Ideas I've had to muck up the data to stop the scraper: 1. random white chars that wouldn't be visible to the user in Printer Friendly, but would alter the values enough to make it a pain in quick books. Might have issues w/ printing. 2. random # of empty TD cells 3. convert text to .gif Has anybody dealt w/ this issue? What did you do? Thanks, Jason ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284046 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfheader filename problem
Dave, I am not totally sure here but I think replacing it with %20 would be the only way to keep it from truncating. I think the truncating is happening on the browser side. -Randy Dave Francis wrote: Hi, I'm trying to download files with this: cfheader name=Content-Disposition value=attachment;filename=#fileName# cfcontent FILE=#file# TYPE=#MimeType# Whenever the filename contains spaces, the What do you want to do with this file prompt truncates the filename. I can obviously replace the spaces with underscore, %20 or something, but wondered if there was a way to preserve the filename as is, and get the full name in the prompt? ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284047 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfhttp and cfx_http
Hello, I have been using the cfx_http tag doing some web service calls. If the webservice is slow in responding while the site is busy it will lock up the 8 available threads available. Would cfhttp do the same thing? I know I should be using timeouts to help with this issue, but what else can I do? I find it weird that 8 simultaneous cfx_http tags can tie up the whole server. Thanks! Randy ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281529 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT: How do you stay up on blogs?
I have tried a few different ones. I like great news the best. http://www.curiostudio.com/ It's free and can handle tons of feeds without maxing out the PC -Randy Johnson Aaron Roberson wrote: After a conversation I had with Sean Corfield the other day and being asked me, Don't you read my blog? and I had to admit that I hadn't in a long while, I starting thinking about how much I am missing by not having a good system in place for reading RSS feeds. I have tried using the built in readers in FF and IE7, but they don't really cater to my madness (mainly because I have to manually check the live bookmarks for new feeds). I also tried some online readers but I have to log in and manually check the feeds. The closest thing to working for me was the RSS reader built into Thunderbird, but it cluttered my folder pain (I have too many folders cluttering it as it is). I guess I'm looking for a desktop client dedicated to RSS feeds that will behave like Thunderbird but would play a sound in Windows and in Mac animate the icon (and play a sound, optionally) when a feed is updated. In order to be effective for my lack of aggressiveness, it would be nice if the client started on boot. What do you use that works for you? ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279173 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can this be done?
What about using the same application name for the whole app so when you receive the message back save it to the application scope and the users response page can check the application scope for the response. maybe an array treated as a queue or something -Randy Erik-Jan Jaquet wrote: Hi all, I am breaking my head over something, and I hope someone can tell me if, and how, this van be done. A client wants some sort of 'Live helper' functionality on the website, where a web visitor fills in a form with a questions, that question is then delivered to an MSN account within the company. The company responds via MSN, and the response must then be shown to the user. I have set up an MSN Gateway, I can send messages to the MSN account and receive messages from that MSN account. But I am not able to figure out how to show the user the response, other then letting the gateway add it to the DB, and let the app pull it from the DB. But I don't want to do that, because it is a lot of data to put in the DB. Is there any other way? Hope you can help! Kind regards, Erik-Jan ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278615 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can this be done?
A database solution would not be bad either because you could delete conversations that have not had any messages added within a certain time frame -Randy Erik-Jan Jaquet wrote: Hi all, I am breaking my head over something, and I hope someone can tell me if, and how, this van be done. A client wants some sort of 'Live helper' functionality on the website, where a web visitor fills in a form with a questions, that question is then delivered to an MSN account within the company. The company responds via MSN, and the response must then be shown to the user. I have set up an MSN Gateway, I can send messages to the MSN account and receive messages from that MSN account. But I am not able to figure out how to show the user the response, other then letting the gateway add it to the DB, and let the app pull it from the DB. But I don't want to do that, because it is a lot of data to put in the DB. Is there any other way? Hope you can help! Kind regards, Erik-Jan ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278616 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP weirdness - Connection Timeout
Hi Jared, Have you tried setting the timeout to a higher number? -Randy Jared Smith wrote: I'm trying to use CFHTTP to capture a simple XML file from a remote server - cfhttp url=http://64.119.37.62/xml; method=GET timeout=10 When I try to access the #cfhttp.filecontent# is shows only Connection Timeout. However, I can access the file from a browser on the server, the cfhttp.errorDetail is empty, the cfhttp.statusCode is 200, the mimeType is being picked up correctly, and if I sniff the packets I see the entire file is send to CF. And if I set the path and file attributes of CFHTTP, the XML file is saved successfully to my server. So why is #cfhttp.filecontent# broken? It only does this for some sites. With most of them, everything works fine, but with this site and others like it, CF is choking on the content somewhere. I have tried setting the character set, setting user-agent, setting the Accept-Encoding and TE headers to deflate;q=0 to solve any compression issues, and about everything else I can think of. Can anyone else try to CFHTTP that file (http://64.119.37.62/xml) and see if it works? This is a FRESH install of MX 7. Frustrated! Jared ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278617 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Scorpio to help with CFMyAdmin
Does anyone know what happened to cfmyadmin.com? I get No web site is configured at this address. when I go there. -Randy Rick Root wrote: The new feature mentioned at the TACFUG/RDAUG user group meeting last night involved updated database drivers across the board, and a new tag called CFDBINFO which will provide all kinds of database introspection stuff. So whoever was planning to write a CFMyAdmin type utility... it might be a whole lot easier in CF8! Rick ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278162 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Eclipse/CF Eclipse environment questions
The group of developers could combine their left over lunch monies and make a donation to MD... I bet that would persuade him to help out.. -Randy - Original Message - From: Heald, Timothy J [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, March 21, 2007 1:02 PM Subject: RE: Eclipse/CF Eclipse environment questions My company wouldn't be interested, and the gov't client wouldn't either. You could do it out of the goodness of your heart, to save the hair of a group of developers :) Thanks for the pointer. -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 21, 2007 12:50 PM To: CF-Talk Subject: Re: Eclipse/CF Eclipse environment questions What I actually *SHOULD* have said, is that for a fee I could do this for your company :D heheh... he.. he.. MD On 21 Mar 2007, at 16:46, Mark Drew wrote: 1. Can you disable the user's ability to download and install plug-ins outside of the baseline that we install and approve? Yes, you can build your own version of CFEclipse/Aptana etc, and include only what you want (and remove the software update features) It isn't actually that difficult, but then that would be *YOUR* build of Eclipse. Here is an article for you: http://www.eclipse.org/articles/product-guide/guide.html ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273305 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: downloading large files via cfhttp
You could use cfexecute to launch a wget at the command line. I have did this before. Make sure that you use the time out options in the wget statement so you do not get caught with hung wget threads cfexecute allows you to launch the command and return to the page. The above method is not full proof because you do not know if the wget is successful or not. The cfexecute could call a script file that would do the wget, check to see the wget was successful and then issue another wget to call the cf page to do the call back and the rest of the processing -Randy - Original Message - From: Andy Matthews [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 19, 2007 9:33 AM Subject: RE: downloading large files via cfhttp I think you're probably asking for trouble. I tried using Coldfusion to download a 7meg SQL file once and it crashed out every time. -Original Message- From: Dov Katz [mailto:[EMAIL PROTECTED] Sent: Saturday, March 17, 2007 7:46 PM To: CF-Talk Subject: downloading large files via cfhttp If I need to cfschedule a 10-40 mb download, is cfhttp going to buffer the entire input to memory if I specify a file to write it to? Also concerned about losing an available thread. I'm trying to basically do a wget in coldfusion and don't want to lose an available thread while I do it. Here's my planned. Is something like this available somewhere? What do you think? Cfx_wget url= destinationFile=. Callbackurl=localhost/callback.cfm Calling this gets a uuid Then I write a java class to kick off a thread (thread name is the uuid the cfx returned) to write a url input stream to the specified file and then hit the callback url when done, with all the params of the tag call and the http status code of the get operation. I can also ask this thread what its status is and/or cancel it by looking for the thread by its uuid name. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272982 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Calling a function based on variable name
Hello, Here is what I am trying to accomplish. I cannot seem to remember or find a way to do this: cfset myfunction=AddMe cfset AddMe() Thanks! Randy ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion / Open Source CRM
Well, its not CF-based, but sugarcrm (www.sugarcrm.com) has an open source version and is pretty sweet. lol that only makes sense for a sugarcrm package to be pretty sweet ;-) -Randy - Original Message - From: Max Hamby [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, March 18, 2007 2:10 PM Subject: Re: Coldfusion / Open Source CRM Well, its not CF-based, but sugarcrm (www.sugarcrm.com) has an open source version and is pretty sweet. ~Max On 3/17/07, Jake Pilgrim [EMAIL PROTECTED] wrote: Does anyone know of a coldfusion CRM out there? Ideally I would like a open source, Coldfusion CRM. It doesn't have to be all that fancy (I'm not looking for a SalesForce replacement) - even if it was just a contacts database it would be better than what I have now :). Thanks for your feedback in advance! Jake ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272939 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Syntax (4.1)
Try WHERE t1.myOtherCol in ( - Original Message - From: Matt Quackenbush [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, March 18, 2007 8:17 PM Subject: MySQL Syntax (4.1) Hello, I am receiving a syntax error on this query, and I cannot for the life of me figure out why. SELECT t1.myCol FROM myTbl t1 WHERE t1.myOtherCol = ( SELECT t2.myOtherCol FROM myTbl t2 WHERE t2.myCol = '#myVar#' ); According to the MySQL docs (referenced below) it appears that I have the syntax correct, but I am obviously missing something here. Any help would be much appreciated. http://dev.mysql.com/doc/refman/4.1/en/comparisons-using-subqueries.html Thanks in advance, Matt ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272958 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Application.cfc and Client Variables
Hello, Here is the code I have at the top of my Application.cfc file: cfcomponent output=false cfset this.Name=Threader1 cfset this.sessionManagement = true cfset this.clientManagement = true In my Queue.cfc file I am getting this error when trying to use a client variable: The requested CLIENT scope is not enabled. The Application.cfc file and the Queue.cfc file are in the same directory. In my ViewVariables.cfm page I can do a cfdump var=#CLIENT# label=Client Scope and it will show client variables I am not sure what is going on here, It looks pretty straight forward. Any ideas? Thanks! Randy ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272910 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfhttp/xml help
Hi Bob, I had this happen with a couple rss feeds. I tried trimming the feed in case of any white space. That did not help it so I finally gave up. The weird thing is, the feeds worked fine if I put them in the RSS Reader. I currently use GreatNews for My RSS reader. I did some testing with online rss validators on the url in your example, it was to big for the online validators to check but It did pass the xml validator test (Well Formed), so I assume it is a valid rss feed too. Not really much help I know :-) -Randy - Original Message - From: Bob Imperial [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Saturday, March 17, 2007 4:13 PM Subject: cfhttp/xml help Hi Folks, I'm just getting started with learning the basics on pulling xml feeds with cfhttp and am in need of some help with an error I get with some feeds I'm playing with. Here's the code block I'm working with and I get the following error on this feed and a couple of others... Content is not allowed in prolog. The error occurred in C:\Inetpub\wwwroot\testing\rss.cfm: line 10 8 : body 9 : cfhttp url=http://www.nranews.com/rss/rss.xml; method=GET resolveurl=No /cfhttp 10 : cfset MyXML=XMLParse(cfhttp.FileContent)--- doesn't seem to like this cfhttp url=http://www.nranews.com/rss/rss.xml; method=GET resolveurl=No /cfhttp cfset MyXML=XMLParse(cfhttp.FileContent) !---cfdump var =#MyXML#--- !-- cfoutput cfloop index=x from=1 to=#ArrayLen(MyXML.rss.channel.item)# Title: #MyXML.rss.channel.item[x].title.xmlText# a href=#MyXML.rss.channel.item[x].link.xmlText#click here/a #MyXML.rss.channel.item[x].description.xmlText# /cfloop /cfoutput While this same block of code works fine using the feed from http://www.tfc.edu/radio/podcasting/music.xml I'm confused here, any help in understanding this is appreciated! Bob ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272915 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using the API to schedule tasks in a CF cluster
If the scheduled job is calling a script on a server, I would have the script that it calls, delete the scheduled task when it is done, or it errors for any reason. -Randy - Original Message - From: James Holmes [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, March 13, 2007 8:45 AM Subject: Re: Using the API to schedule tasks in a CF cluster Can you have the scheduled job delete itself? On 3/13/07, Peterson, Chris [EMAIL PROTECTED] wrote: I have a mass emailer application in CF that schedules sendouts using the CF scheduler and the Admin Api to add scheduled tasks. This application is running on a round-robin cluster between 2 instances, which is paired with an identical server behind a cisco content switch for load balancing and fault tolerance. My question is this: The mass emailer adds a scheduled task to whichever instance the request happens to get directed too, on whichever server is least busy at the time. This application also has code to remove a scheduled task. Now, that removal task is never guaranteed to hit the same server / instance that the task was scheduled on, so most often it fails to remove the task. Should I: a) change this particular site to use one single instance of CF and have the load balancer direct all traffic to a single server b) write some kind of code to have it check each instance when deleting to verify it finds and deletes the correct scheduled job c) do something I don't know about? =) -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272506 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: weather module
weather.gov has an rss feed and a xml feed. -Randy - Original Message - From: Les Irvin [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 12, 2007 5:14 PM Subject: OT: weather module I'm looking for a weather module to display on a real estate website. Must be compatible with CF query data such as a zip code. Weather.com's module is not flexible enough. Has any one found any such animal? Thanks in advance, Les ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272417 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: GotCFM.com - Need Opinion on Whether to Approve a Site
I agree with Bruce and Liz below. I vote NO -Randy - Original Message - From: Bruce Sorge [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 05, 2007 3:18 PM Subject: Re: GotCFM.com - Need Opinion on Whether to Approve a Site Hmm. That is a good point that I obviously missed. Now that I think about it, no matter how you spin it, you are going to be guilty of promoting porn regardless of your intentions. I change my vote to no. Thanks Liz. On 3/5/07, Les Mizzell [EMAIL PROTECTED] wrote: Yes or no to adult themed sites? I'm going to say No. Not for moral issues, but because I'd have reservations about sending some of the businesses I develop for to go look at a list that included such sites. You suddenly end up with sleazy by association. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271600 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfinvoke and threads
Hello Everyone, I am a newbie at cfobjects. I was wondering if there would be a reason why this bit of code would not be running the method every 5 seconds: cfif not isDefined(Application.QueueCFC) cfobject component=Queue Name=Application.QueueCFC cfthread name=ThreadListener cfinvoke component=#Application.QueueCFC# method=Threader cfpause interval=5 /cfthread /cfif If I put the cfinvoke in a separate page and run it, it actually takes does what it is supposed to do, but it doesn't do anything when the above code is executed. I restart my BD 7 Server so the application variables do not exist, I go to a cf page so the application gets started. I can run the GetALLThreads() function to see the ThreadListener Thread. It is there, but it doesn't seem to be invoking the Threader method at all, not even 1 time from what I can see Thanks for your help. -Randy ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271435 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: php equivalent of application.cfc
Tom, Use cfdirectory to read in all the PHP pages, do a cffile=read on the php page, do a cffile action=write to put the ?php include_once(config.php);? at the top, then do a cffile action=append to put the rest of the PHP script to it. There you go :-) You still get to use CF during the project :-) -Randy - Original Message - From: Tom King [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, March 02, 2007 6:35 AM Subject: OT: php equivalent of application.cfc Hi All, Sorry for the OT: I'm new to PHP, and am trying to find out if there is the equivalent of application.cfc onrequest() function: I.e, I want to be able to do this, without having to put the includes in every file: cffunction name=onrequest cfargument name=targetpage'' required=yes cfinclude template=header.html cfinclude template=#targetpage# cfinclude template=footer.html /cffunction Help? Many thanks T ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271278 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Queue Manager
Hello everyone, I have looked over the POC cfthread and Damon Cooper's Blog. After reading the following: ...This POC works with CF 7.0.2 (Standard or Enterprise). While you can do multi-threading and asynchronous CFML with these POC tags, they don't provide any of the fine-grained threading control you have with ColdFusion Event Gateways and the Asynchronous Gateway, for example. So you don't get thread pooling, control over how many worker threads can be active or pooled, metering on Gateway messages In/Out, or any of the other advanced capabilities of the Event Gateway architecture on CF7, but they do the basics: run stuff asynchronously in separate threads and allow for the use of local (thread-local) variables, allow access to shared scopes, etc It would seem to me that the best way to go about this would be to use the Coldfusion Event Gateways or the Asynchronous Gateways because they would have better control the amount of threads that are running at one time. The way I understand it is, I would have scheduled tasks run at timed intervals sending the requests to the gateway, and the gateway would process the requests ensuring it didn't go over the thread limit. I have just read over the event gateway chapter in my Advanced Macromedia Coldfusion MX7 Application Development Book and it would seem like the event gateway would be the way to go. -Randy - Original Message - From: Richard Kroll [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, February 27, 2007 2:52 PM Subject: RE: Queue Manager I need some advice. I am working on a project. The cfm page in my project I call TheBrain.cfm this is the page that gets called by my task scheduler every 4 hours. TheBrain.cfm script then makes calls to a web service. I am allowed to have 15 simultaneous connections to the web service at any one given point. To clarify, In TheBrain.cfm are you looping over something when calling the web service? From what I understand of your problem, I would second Chris suggestion of looking at Ray's cfthread / cfjoin proof of concept Rich Kroll ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Queue Manager
Hello Everyone, I need some advice. I am working on a project. The cfm page in my project I call TheBrain.cfm this is the page that gets called by my task scheduler every 4 hours. TheBrain.cfm script then makes calls to a web service. I am allowed to have 15 simultaneous connections to the web service at any one given point. This means I will have to create a thread manager or if you want to call it a queue manager since I am not really using threads. Currently TheBrain.cfm page uses cfexecute to launch curl commands at the command line to launch the simultaneous calls. Right now it launches 4 separate processes which means I have 4 simultaneous calls going on. My first thought was to have a call variable in the database which would be incremented when the execute calls the script and decremented when the called script is done making the call. This seems to be a little clunky and unreliable. The first thought is: What happens if for some reason the script does not decrement the call count... or if the call count doesn't get incremented then I could have more than 15 calls going on at once. I thought that an event gateway might be a way to handle this, but I do not know enough yet about those. I am not sure if I am going the right way about this or not that is why I am emailing a group. The main thing I need to accomplish is to make sure I do not have more than 15 simultaneous requests at 1 time. I think I need a queue manager of some sort. If you have any advice on how I should tackle this I would greatly appreciate it. Thanks! Randy ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270840 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Queue Manager
Hi Rich, Yes I am querying the database and looping through the query. I will take a look at that this evening, and respond with any questions I may have. -Randy - Original Message - From: Richard Kroll [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, February 27, 2007 2:52 PM Subject: RE: Queue Manager I need some advice. I am working on a project. The cfm page in my project I call TheBrain.cfm this is the page that gets called by my task scheduler every 4 hours. TheBrain.cfm script then makes calls to a web service. I am allowed to have 15 simultaneous connections to the web service at any one given point. To clarify, In TheBrain.cfm are you looping over something when calling the web service? From what I understand of your problem, I would second Chris suggestion of looking at Ray's cfthread / cfjoin proof of concept. Rich Kroll ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270853 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Weird Error when viewing datasources in CFAdmin 7.02
Sorry I forgot to put my name. My Name is Randy. Thank you for your help. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250727 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Weird Error when viewing datasources in CFAdmin 7.02
Here is the errors that show up when I go to the datasource page in cf administrator: This just started happening recently. Any ideas what is happening? Aug 22, 2006 2:52 PM Error 0 Exception thrown by error-handling template: Aug 22, 20062:52 PM Error 0 Element FUNCNAME is undefined in ERROR. The specific sequence of files included or processed is: C:\CFusionMX7\wwwroot\WEB-INF\exception\coldfusion\runtime\IllegalStructAccessException.cfm, line: 5 Aug 22, 20062:52 PM Error 0 cfadmin Cannot find key name in struct.The specified key, name, does not exist in the structure. The specific sequence of files included or processed is: C:\inetpub\wwwroot\CFIDE\administrator\datasources\index.cfm, line: 363 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250639 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4