Application.cfm
Is there any way to tell a page in a directory or sub directory to not run/inlcude the application.cfm Christian ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208239 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Template Not Found
I am sending this one more time hoping for an answer Template Not found- Option 1: use IIS to redirect all 404 errors to a cf page. I can't do this because I am using URL rewriting for Search Engine friendly urls. http://somedomain.com/newsitepage.html/r/1/f/3 Option 2: use missing template handler in cf admin. This does not work because I am not using the .cfm extension on the current site, nor on the new site being developed. I can change this for the new site, but does not help with handling these errors for pages not found from the old site after this one goes live which is why I am here in the first place. http://somedomain.com/oldsitepage.html?r=1f=3 does not exist and will not execute the missing template handler http://somedomain.com/oldsitepage.cfm?r=1f=3 does not exist, but will pull the missing template handler Option 3: either some fix for Option 2 so that non .cfm pages will get processed by the missing template handler, or another option I am missing. Can anyone help Please Christian ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204821 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Missing template
I realize this and have done so. I can not use IIS and redirect the 404 template there because I am using url variable rewritting for search engine friendly urls. Basically, my front page will work, but everything after that is seen as a missing template, even though it really isn't. I have used the missing template successfully before. I can not get it to work now though and I have no explanation why. -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Monday, April 25, 2005 2:39 PM To: CF-Talk Subject: Re: Missing template The CF administrator setting for missing template handler is only for missing CF templates. Go to yoursite.com/abcdefg.cfm and you should see it. To get it to catch all missing files on your web site, you will have to find your web server's equivalent and point it to your 404 page. -nathan strutz Christian Watt wrote: CFMX Standard, I can not get the missing template handler to work. I have one on our current site which is CFMX Enterprise, but I can't find anything that this should matter. I have tried absolute paths, relative paths and everything in between. I can get it to work by using IIS to replace the 404 page, but CF does not execute when you do this. Has anyone run into this before??? I am going out of my mind, what little is left. Christian ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204543 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Missing template
Okay, I need some guru help here. I have figured out that this only works with .cfm files. I have set .html files to resolve cold fusion templates and updated the two jrun config files and everything works great, except the missing template handler. Does anyone have a clue one where or how I can make the missing template handler work with .html files that are handle through CF. I am getting a CF error back that the template is missing. Christian -Original Message- From: Christian Watt [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 26, 2005 3:32 PM To: CF-Talk Subject: RE: Missing template I realize this and have done so. I can not use IIS and redirect the 404 template there because I am using url variable rewritting for search engine friendly urls. Basically, my front page will work, but everything after that is seen as a missing template, even though it really isn't. I have used the missing template successfully before. I can not get it to work now though and I have no explanation why. -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Monday, April 25, 2005 2:39 PM To: CF-Talk Subject: Re: Missing template The CF administrator setting for missing template handler is only for missing CF templates. Go to yoursite.com/abcdefg.cfm and you should see it. To get it to catch all missing files on your web site, you will have to find your web server's equivalent and point it to your 404 page. -nathan strutz Christian Watt wrote: CFMX Standard, I can not get the missing template handler to work. I have one on our current site which is CFMX Enterprise, but I can't find anything that this should matter. I have tried absolute paths, relative paths and everything in between. I can get it to work by using IIS to replace the 404 page, but CF does not execute when you do this. Has anyone run into this before??? I am going out of my mind, what little is left. Christian ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204546 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Missing template
More Info... This seems to work if you are running cf on top of jrun, but it does not if you are running a CFMX standard install. Please...Anyone Christian -Original Message- From: Christian Watt [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 26, 2005 3:37 PM To: CF-Talk Subject: RE: Missing template Okay, I need some guru help here. I have figured out that this only works with .cfm files. I have set .html files to resolve cold fusion templates and updated the two jrun config files and everything works great, except the missing template handler. Does anyone have a clue one where or how I can make the missing template handler work with .html files that are handle through CF. I am getting a CF error back that the template is missing. Christian -Original Message- From: Christian Watt [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 26, 2005 3:32 PM To: CF-Talk Subject: RE: Missing template I realize this and have done so. I can not use IIS and redirect the 404 template there because I am using url variable rewritting for search engine friendly urls. Basically, my front page will work, but everything after that is seen as a missing template, even though it really isn't. I have used the missing template successfully before. I can not get it to work now though and I have no explanation why. -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Monday, April 25, 2005 2:39 PM To: CF-Talk Subject: Re: Missing template The CF administrator setting for missing template handler is only for missing CF templates. Go to yoursite.com/abcdefg.cfm and you should see it. To get it to catch all missing files on your web site, you will have to find your web server's equivalent and point it to your 404 page. -nathan strutz Christian Watt wrote: CFMX Standard, I can not get the missing template handler to work. I have one on our current site which is CFMX Enterprise, but I can't find anything that this should matter. I have tried absolute paths, relative paths and everything in between. I can get it to work by using IIS to replace the 404 page, but CF does not execute when you do this. Has anyone run into this before??? I am going out of my mind, what little is left. Christian ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204573 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Template Not Found
Template Not found- Option 1: use IIS to redirect all 404 errors to a cf page. I can't do this because I am using URL rewriting for Search Engine friendly urls. Option 2: use missing template handler in cf admin. This does not work because I am not using the .cfm extension on the current site, nor on the new site being developed. I can change this for the new site, but does not help with handling these errors for pages not found from the old site after this one goes live which is why I am here in the first place. Option 3: either some fix for Option 2 so that non .cfm pages will get processed by the missing template handler, or another option I am missing. Can anyone help Please Christian ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204605 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Template Not Found
This is not an include file. It is the original called page. http://somedomain.com/oldsitepage.html?r=1f=3 does not exist and will not execute the missing template handler http://somedomain.com/oldsitepage.cfm?r=1f=3 will pull the missing template handler Can't us IIS because this is my new link. http://somedomain.com/newsitepage.html/r/1/f/3 Christian -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 26, 2005 7:06 PM To: CF-Talk Subject: Re: Template Not Found If you're including content dynamically...just do the good old FileExists() before including the content file...if not found...re-direct to whatever page you like FYI I'm talking about your standard template file setup where the template includes header/footer/content (content determined by var(s) passed to the template file HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204608 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CrystalTech Users Beware
CFMX Standard, I can not get the missing template handler to work. I have one on our current site which is CFMX Enterprise, but I can't find anything that this should matter. I have tried absolute paths, relative paths and everything in between. I can get it to work by using IIS to replace the 404 page, but CF does not execute when you do this. Has anyone run into this before??? I am going out of my mind, what little is left. Christian ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204324 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Missing template
CFMX Standard, I can not get the missing template handler to work. I have one on our current site which is CFMX Enterprise, but I can't find anything that this should matter. I have tried absolute paths, relative paths and everything in between. I can get it to work by using IIS to replace the 404 page, but CF does not execute when you do this. Has anyone run into this before??? I am going out of my mind, what little is left. Christian ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204325 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF Server is only allowing 1 Connection
This is a production that got restarted last night and this morning it is only allowing one client to connect. If I restart the services, someone else can connect, but no others are allowed. I have tried a different serial number to no avail. Please, if anyone has run into this contact me. I am desperate here with this being an internal server that this companies internal application runs off with flash removing Christian Thank You, Christian Watt Webmaster SkillPath Seminars [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202590 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Server is only allowing 1 Connection
How could you do that. In MX 6.1 they removed that setting, right??? This is not a developers addition. I have a couple of valid MX 6.1 Standard serial Numbers, and none of them make a difference. Christian -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 13, 2005 11:21 AM To: CF-Talk Subject: RE: CF Server is only allowing 1 Connection Erm, should only happen if a) you are using a developers version or b) you have limited the number of connections to 1 in the CFIDE (not under J2EE) -Original Message- From: Christian Watt [mailto:[EMAIL PROTECTED] Sent: 13 April 2005 17:23 To: CF-Talk Subject: CF Server is only allowing 1 Connection This is a production that got restarted last night and this morning it is only allowing one client to connect. If I restart the services, someone else can connect, but no others are allowed. I have tried a different serial number to no avail. Please, if anyone has run into this contact me. I am desperate here with this being an internal server that this companies internal application runs off with flash removing Christian Thank You, Christian Watt Webmaster SkillPath Seminars [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202592 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Out of Memory
Andy, Check the number of records being returned by your queries. I had this problem and no matter what you turn the JVm Heap size up to, it will not fix it. There is no good way to track this down. What I ended up doing is after every query ran, I logged the number of records returned. I discovered that one query was returning over 90,000 records everytime and the more often it ran, the more outofmemory errors I was getting. Hope this helps. Christian -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Friday, October 22, 2004 10:43 AM To: CF-Talk Subject: Re: Out of Memory Check your logs under cfmx/runtime/logs as well .. what are they saying? Andy On Fri, 22 Oct 2004 16:38:02 +0100, Andrew Dixon [EMAIL PROTECTED] wrote: Hi Everyone. We noticed that our CF server service restarted itself twice today, and then after checking the cfserver.log file, just before the start up is logged it had the following: out of memory autorestart: Restarting process The server has 1Gb RAM and the JVM setting under CF Admin are set to: Minimum JVM Heap Size (MB): 512 Maximum JVM Heap Size (MB): 512 Does this error message mean that CF needed more than 512Mb, i.e. we need to increase the value? or is there something else wrong? Best Regards Andrew. ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182398 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFMAIL and mass mailings: problem?
Asim, 1) You do not need to worry about sending 25000 messages at once.I ship between 700,000-900,000 every month.The main thing is to not have cf spool the messages.As of 6.1 you can set cf to send the message directly to your mail server.I have quite a bit of logic and radius lookups, but we average around 1,000 email a min. 2) In order to see which ones fail, you have to choices, both of which should be used. A. make the reply address a mailbox nobody checks, then use cfpop to access that mail box and parse through the email, what you can not automate recording, have that forward to someone.You want to look for things like 'mail box full', undeliverable, on vacation, I can go on and on, but you can send it, start looking at the messages through a reader, then build your page as you go.Run the parser, then look to see what you didn't get.Personally, I use Perl for this.I get much better performance than using cfpop. B.Use a mail server that will log failed deliveries.I use Mail Engine from Lyris, but you are looking at between $7k-$8k.There are others out there, but they will record to a text file or db during the smtp communication that a message failed.You can set up some server that won't log to a db to send a message also, then you simply parse that box as above. The main thing to remember is that some mail will fail during the initial send, others you won't know until their mail server tries to process the message.This will happen if they have a gateway mail server that simply receives email for a particular domain, then tries to forward it on to mail server that actually knows who has a mail box and it's status. Hope this helps. Christian -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: Thursday, September 02, 2004 12:43 PM To: CF-Talk Subject: Re: CFMAIL and mass mailings: problem? cfquery name=getList datasource=mailing select name, email from table /cfquery cffile action="" file=#file# addnewline=yes My question is I am also getting involve in the same sort of project. How can I create the log file for the email which have been sent and the one which are refused/not send. Thanks, If you are hosted somewhere than your own server, then I would make sure your host doesn't have mails-per-hour-restrictions on your server.This is the case at our hosting company, and I would assume that it would be smart for other companies to do it too.I think ours is like 3000 per hour limit. Also, I may be wrong, but CFMX has the capability to send thousands of emails per second to the spool.At least that is how I remember it.So your seven hours may be a little long... Ray At 01:27 PM 9/2/2004, you wrote: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMAIL and mass mailings: problem?
I forgot that in my last message, Yes, use a regular _expression_, and you will get past cf just fine. If you are going to continue to ship messages, I suggest that you log the bad addresses so that you don't process them every month as well. If you remove, bad email address, hard undeliverables (mail box does not exist), and soft undeliverables (mail box full), you will probably drop between 5-10% of the emails you have to send next time.Those numbers are on the low side as well.As stated earlier, this depends on how clean your data is, but don't be surprised if you numbers of non-delivered mail are higher than that. Christian -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, September 02, 2004 2:51 PM To: CF-Talk Subject: RE: CFMAIL and mass mailings: problem? Invalid in format. As long as it's a properly formed email address, it will work.You just have to make sure your data is clean. John -Original Message- From: Cornillon, Matthieu (Consultant) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 02, 2004 2:53 PM To: CF-Talk Subject: RE: CFMAIL and mass mailings: problem? The big thing you need to look out for is invalid email addresses and such because that will kill the cfmail loop and thus kill all of the emails going out. John, Does invalid e-mail addresses mean e-mail addresses that simply are not e-mail addresses, or e-mail addresses that are valid in format, but do not actually exist at the other end? In other words, I would call [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]a valid address, even though there is most likely no such address on the yahoo server. Is this how you are defining valid? If so, it sounds like the solution is to check the e-mails using a regular _expression_ to be sure that they follow basic e-mail address format.Does this sound right to you? Thanks, Matthieu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfmail Part 2
Mark, I have tried most of these, and everyone one of them will fail on a particular mail server.I have looked, and can not find an RFC that stipulates a proper way.This is the only one that I have found to work about 98% of the time.I refrain from trying to use the proper name anymore though, because of the issues around it. my name [EMAIL PROTECTED] Christian -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Thursday, September 02, 2004 3:16 PM To: CF-Talk Subject: cfmail Part 2 John, While you are on the topic of email formatting, I have seen addresses formatted the following ways inside the cfmail tag: [EMAIL PROTECTED] [EMAIL PROTECTED] (my name) [EMAIL PROTECTED] my name my name [EMAIL PROTECTED] I think I even saw My name [EMAIL PROTECTED] These formats have varying degrees of success. I recently fixed a website where all the addresses where: my name [EMAIL PROTECTED] ...This would work sometimes and sometimes it would not. It turns out that the emails were being relayed through a load-balancer to more than one smtp relay server. Some of them could handle the format and some of them couldn't.The question is, was the email format screwy or where there just some misconfigured email relay servers? What is the proper standard for including the descriptive portion of the email address? Mark A. Kruger, CFG, MSCE www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, September 02, 2004 2:51 PM To: CF-Talk Subject: RE: CFMAIL and mass mailings: problem? Invalid in format. As long as it's a properly formed email address, it will work.You just have to make sure your data is clean. John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFQuery
I know you can return the execution time of a query, but how do you return what the query ran is?Just like they do when you turn on debugging. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
Reply, not quite, this only works when an error has occurred.I would like to do this even if an error has not occurred. cfquery name=somequery Select * from table /cfquery #Output Query Ran# Christian -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 10:37 AM To: CF-Talk Subject: Re: CFQuery I guess this is what you need http://cflib.org/udf.cfm?ID=686 - Original Message - From: Christian Watt [EMAIL PROTECTED] Date: Tue, 31 Aug 2004 10:21:43 -0500 Subject: CFQuery To: CF-Talk [EMAIL PROTECTED] I know you can return the execution time of a query, but how do you return what the query ran is?Just like they do when you turn on debugging. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
Yes, you are correct, but the requesting IPAddress has to be in the debugging IP Addresses.otherwise IsDebugMode returns false.This brings up an interesting question though, if my ip is not in the list then I don't get debug information and debug mode is turned off, so why is debugging being enabled on a production machine bad?This is near the top of my page also.I would also like to know of some way to return the query as well.And yes, I understand I can rewrite all of queries as strings, but was really hoping to not do that since most of them are going to become stored procs pretty soon anyway. Christian -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 12:11 PM To: CF-Talk Subject: Re: CFQuery As far as I can tell after looking at the UDF, it doesn't require an error to occur before it returns the sql statement. the only requirement I see is that debugging must be turned on on the server for this to work. since I am not the author of this udf, I might completely be wrong - Original Message - From: Christian Watt [EMAIL PROTECTED] Date: Tue, 31 Aug 2004 12:00:39 -0500 Subject: RE: CFQuery To: CF-Talk [EMAIL PROTECTED] Reply, not quite, this only works when an error has occurred.I would like to do this even if an error has not occurred. cfquery name=somequery Select * from table /cfquery #Output Query Ran# Christian -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 10:37 AM To: CF-Talk Subject: Re: CFQuery I guess this is what you need http://cflib.org/udf.cfm?ID=686 - Original Message - From: Christian Watt [EMAIL PROTECTED] Date: Tue, 31 Aug 2004 10:21:43 -0500 Subject: CFQuery To: CF-Talk [EMAIL PROTECTED] I know you can return the execution time of a query, but how do you return what the query ran is?Just like they do when you turn on debugging. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
The way that Forta wrote a UDF though implies that you have to have debugging enable to use the service.factory.If this is not true, let me know please. Christian -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 3:37 PM To: CF-Talk Subject: RE: CFQuery If you are using CFMX you can get at the query information using the service factory.I posted a function on my blog (http://blog.mxconsulting.com). I'm sorry if someone has already mentioned this - it's been around for a while and resurfaces every few months. I think I originally got it from one of you guys g ... or it might have been ben forta - can't remember. -Mark -Original Message- However that asside somehow the debugging information is pulling the SQL syntax form something, so it might be possible find it.I've been trying to figure this out for fun in my spare time but I haven't gotten anywhere with it. The only thing I have come up with,which is discourgaging,is in the java.sql.statement a method execute exists. I am figuring ColdFusion uses that and might be checking if debuging . [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
Thanks Ben, that is what I was afraid of. Christian -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 4:09 PM To: CF-Talk Subject: RE: CFQuery If you are trying to pull it the way I did in that UDF, then yes, debugging must be on. I have not yet found a way to get this without debugging enabled. --- Ben _ From: Christian Watt [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 4:55 PM To: CF-Talk Subject: RE: CFQuery The way that Forta wrote a UDF though implies that you have to have debugging enable to use the service.factory.If this is not true, let me know please. Christian -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 3:37 PM To: CF-Talk Subject: RE: CFQuery If you are using CFMX you can get at the query information using the service factory.I posted a function on my blog (http://blog.mxconsulting.com). I'm sorry if someone has already mentioned this - it's been around for a while and resurfaces every few months. I think I originally got it from one of you guys g ... or it might have been ben forta - can't remember. -Mark -Original Message- However that asside somehow the debugging information is pulling the SQL syntax form something, so it might be possible find it.I've been trying to figure this out for fun in my spare time but I haven't gotten anywhere with it. The only thing I have come up with,which is discourgaging,is in the java.sql.statement a method execute exists. I am figuring ColdFusion uses that and might be checking if debuging . _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
Let me add to this one and see if anyone knows how to output the parameters passed to a stored proc as well.Without having debuggin enabled also. Christian -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 3:50 PM To: CF-Talk Subject: Re: CFQuery so why is debugging being enabled on a production machine bad? it takes up valuable time slices:) Doug Personally I find time difficult to slice ... I can never seem to find a knife sharp enough to penetrate its fabric. :) s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Memory Issues
Has anybody out there used the Borland OptimizeIt???Macromedia support has me running this trying to figure out my memory issue, but they are not very familiar with it, and honestly, I don't have a clue.If someone out there does, please contact me off list. [EMAIL PROTECTED] Christian -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 10:53 AM To: CF-Talk Subject: Re: Memory Issues Christian Watt wrote: What is the default setting for the -XX:ParallelGCThreads and what increments should I try increasing these? Look at section 4.1 and 4.2 of http://www.petefreitag.com/articles/gctuning/ By default the throughput collector uses the number of CPU's as its value for number of GC threads. I would increment by 1's, keeping in mind that you may cause more overhead than your saving by increasing this value. I probably wouldn't go much past 2x number of CPU's __ Pete Freitag http://www.cfdev.com/ Author of the CFMX Developers Cookbook http://www.petefreitag.com/bookshelf/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Memory Issues
Pete, So far this is what I have come up with.Macromedia has had me running OptimizeIt from Borland.I do not see any classes increasing in there memory consumption.The only common thread I can see right now is that when the memory jump, Old Gen GC jumps as well.Once the Old Gen returns to a normal level, the memory does not. Example: Memory : 125mb Old Gen: 10MB Spike Memory: 806mb Old Gen: 231mb ---Old Gen Returns Memory: 620mb Old Gen: 8mb This is the only common thread.Could there be an issue with the garbage collector not actually releasing the memory??? -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 10:53 AM To: CF-Talk Subject: Re: Memory Issues Christian Watt wrote: What is the default setting for the -XX:ParallelGCThreads and what increments should I try increasing these? Look at section 4.1 and 4.2 of http://www.petefreitag.com/articles/gctuning/ By default the throughput collector uses the number of CPU's as its value for number of GC threads. I would increment by 1's, keeping in mind that you may cause more overhead than your saving by increasing this value. I probably wouldn't go much past 2x number of CPU's __ Pete Freitag http://www.cfdev.com/ Author of the CFMX Developers Cookbook http://www.petefreitag.com/bookshelf/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Memory Issues
What is the default setting for the -XX:ParallelGCThreads and what increments should I try increasing these? Christian -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 3:11 PM To: CF-Talk Subject: Re: Memory Issues Christian Watt wrote: Peter,the Old Generation garbage collection was over 500mb. I have a screen shot and logs with a stack trace dump, but I don't know what to do from here.Will you take a look or can you tell me who can help??? As soon as I restart the service, via command prompt right now so that I can watch gc, the memory immediately explodes again.But These logs and gc graph do show a complete lockup. Christian, It sounds like your young generation is too small then. You may want to play with increasing its size. Also if you have multiple CPU's and they are not too busy you might want to increase -XX:ParallelGCThreads You should also read these articles before playing so you understand what your doing: http://www.petefreitag.com/articles/gctuning/ http://www.petefreitag.com/item/139.cfm __ Pete Freitag http://www.cfdev.com/ Author of the CFMX Developers Cookbook http://www.petefreitag.com/bookshelf/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Memory Issues
Peter, No joy on increasing the young generation.I set it to -XX:NewRatio=3 and I added the -XX:+AggressiveHeap on the machine that has 2 procs with hyper-threading.No cpu issues until the memory exceeds the 750mb mark and the Old Gen in JVMSTAT explodes at the same time.I did a Load test against the machines last night after making these changes and adding the reconditions on the Forum article: http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid= 69threadid=856745 I ran the load test with 150 users over a 30 minute period and everything ran smooth.This morning I am only seeing around 10-15 simultaneous users and having issues.This is really getting frustrating! Christian -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 3:11 PM To: CF-Talk Subject: Re: Memory Issues Christian Watt wrote: Peter,the Old Generation garbage collection was over 500mb. I have a screen shot and logs with a stack trace dump, but I don't know what to do from here.Will you take a look or can you tell me who can help??? As soon as I restart the service, via command prompt right now so that I can watch gc, the memory immediately explodes again.But These logs and gc graph do show a complete lockup. Christian, It sounds like your young generation is too small then. You may want to play with increasing its size. Also if you have multiple CPU's and they are not too busy you might want to increase -XX:ParallelGCThreads You should also read these articles before playing so you understand what your doing: http://www.petefreitag.com/articles/gctuning/ http://www.petefreitag.com/item/139.cfm __ Pete Freitag http://www.cfdev.com/ Author of the CFMX Developers Cookbook http://www.petefreitag.com/bookshelf/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Memory Issues
Yes and Yes.Each user is creating individual client sessions, since I have session and application turned off, and it ramps up, sustains, and they have a varying time of 30 seconds-2 minutes on a page.I could go longer, but I really wanted to push the machine. Christian -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 11:16 AM To: CF-Talk Subject: RE: Memory Issues I ran the load test with 150 users over a 30 minute period and everything ran smooth. This morning I am only seeing around 10-15 simultaneous users and having issues. This is really getting frustrating! Are you allowing your load test virtual users to pause between requests? Are you running your load test along the same network path used by external application users? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Memory Issues
No, right now I have it set at 750mb.Although I have had it just over a gig, but it does not matter how high I set it, eventually it still surpasses that limit and locks up. Christian -Original Message- From: Peter Farrell [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 10:19 AM To: CF-Talk Subject: Re: Memory Issues Christian, What's your max memory heap size?Is it over 1.8 GB? .pjf maepub [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Memory Issues
I have read articles much like this before.With the other log I am currently outputting, I am using JVMSTAT right now to watch garbage collection and see if I see any similarities.Is there anything else you or someone else knows of that I should be looking for??? -Original Message- From: Peter Farrell [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 10:44 AM To: CF-Talk Subject: Re: Memory Issues Check this out: http://www-106.ibm.com/developerworks/java/library/j-garbage-collection. html Are you running JRUN with Updater 3? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Memory Issues
Peter,the Old Generation garbage collection was over 500mb.I have a screen shot and logs with a stack trace dump, but I don't know what to do from here.Will you take a look or can you tell me who can help??? As soon as I restart the service, via command prompt right now so that I can watch gc, the memory immediately explodes again.But These logs and gc graph do show a complete lockup. Christian -Original Message- From: Peter Farrell [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 10:44 AM To: CF-Talk Subject: Re: Memory Issues Check this out: http://www-106.ibm.com/developerworks/java/library/j-garbage-collection. html Are you running JRUN with Updater 3? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Memory Issues
Peter, thank you so much for that link.Although that does not seem to quite be my problem, it has pointed out some metrics that I have used, along with some others that I have found that have a direct correlation to my memory explosion.I am going to include an excerpt from my current post in the forums so that anybody here that may have seen this before, or have any idea where to go from here can help as well.Anyone that helps solve the issue, I'll have a beer, or stronger, waiting for you at DEVCON :-) [Metrics out below] As you can see, I am not getting the scheduler thread drop, but my memory jumps from @150mb to over 500mb within a few seconds and then if you look at the proxy output, the DelayHighCon (Requests delayed due to high concurrency, {delayRq}) jumps as well. I can not see any rhyme or reason to the numbers either. Sometimes I'll have 35 busy, and 12 delayed, sometimes 5 busy and 40 delayed, and sometimes 8 busy and 4 delayed. Is there somewhere else I should be looking???What in the world would cause activity like this to happen.We obviously are not looking at very many users here, although I will get well over 100 simultaneous users with no issue at all at times as well. -08/17 14:55:35 metrics Web threads (busy/total): 12/14 Sessions: 0 Total Memory=651968 Free=186794 scheduler.listen=3 delay=0 idle=0 busy=5 total=8 delayed=0 dropped=0 delayedMs=0 Proxy- Threads listening:1 Idle:1 Delayed:0 Busy:12 Total:14 DelayHighCon:0 Dropped:0 Handled:6 HandledMS:62080 DelayMS:0 -08/17 14:56:45 metrics Web threads (busy/total): 25/34 Sessions: 0 Total Memory=523840 Free=177783 scheduler.listen=6 delay=0 idle=0 busy=2 total=8 delayed=0 dropped=0 delayedMs=0 Proxy- Threads listening:1 Idle:1 Delayed:7 Busy:25 Total:34 DelayHighCon:5 Dropped:0 Handled:9 HandledMS:514610 DelayMS:845 -08/17 14:57:52 metrics Web threads (busy/total): 22/38 Sessions: 0 Total Memory=542016 Free=172856 scheduler.listen=5 delay=0 idle=0 busy=3 total=8 delayed=0 dropped=0 delayedMs=0 Proxy- Threads listening:1 Idle:15 Delayed:0 Busy:22 Total:38 DelayHighCon:35 Dropped:0 Handled:31 HandledMS:1728081 DelayMS:318266 -08/17 14:58:52 metrics Web threads (busy/total): 6/38 Sessions: 0 Total Memory=560512 Free=155782 scheduler.listen=2 delay=0 idle=0 busy=6 total=8 delayed=0 dropped=0 delayedMs=0 Proxy- Threads listening:1 Idle:31 Delayed:0 Busy:6 Total:38 DelayHighCon:21 Dropped:0 Handled:38 HandledMS:1571438 DelayMS:0 Christian From: Peter Farrell [mailto:[EMAIL PROTECTED] Sent: Monday, August 16, 2004 6:00 PM To: CF-Talk Subject: Re: Memory Issues Christian, Are you caching anything in cfquery?I'm thinking that maybe your max total cache for cfquery might be set too high... Also, are you using ODBC or JDBC drivers? I could be that the garbage collection for event scheduler isn't working here and it's piling up (as in the discussion on MM forums from my previous post)? .peter maepub [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Memory Issues
No.I am not using anything, as far as I can tell, that would cause memory to be held at all.Although some of the logic behind my pages is fairly extensive, there is nothing that is really that complex. CFquery, CFStoredProc, Client variables (Which I switch from session thinking that was the issue, unfortunately no change), arrays and structures.I so some WDDX wrapping now so that I can store Arrays and Structures in Client Variables, but this is after switching from session variables where the issue already existed.I don't have any queries that returns any more than maybe 50-100 records, and there really isn't a lot of information in those record sets.There can be a record set that has a bit of information in it, one row, but again we are only talking about a 2-3 page print out of text.Hopefully this gives a little more info. Peter, I appreciate the link, that does give me a way to see what is going on right now through CF, but I am using performance monitor to see this real time.I can watch it happen, but I have no explanation for why it is happening, which means I can't fix it. Christian -Original Message- From: Peter Farrell [mailto:[EMAIL PROTECTED] Sent: Saturday, August 14, 2004 5:15 PM To: CF-Talk Subject: Re: Memory Issues Check this out: http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid= 69threadid=806965 Looks to be something like yours.I noticed the person is using thread.sleep() which ties up a JRUN tread.Are you using that in your CF code? .peter maepub [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Memory Issues
I am having a huge issue with memory right now.I have turned off all session and application variables.If I get more than 50-75 simultaneous users, my memory starts to explode rather rapidly from around 150mb to over 750mb for the jrun service.Two problems here, 1) even though I have set up multiple instances, when the memory on one jrun service exceeds the assigned -Xmx value, all instances seize to work as well.2) I can not figure out for the life of me why this is happening.My Jrun servers are clustered and of course the memory influx does not create a fail over, and even it did, the other machine will react with the same effect.Someone please help me figure out how I can troubleshoot this. Thank You, Christian Watt Webmaster SkillPath Seminars [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT- sql format question
I don't know if you are dealing with degrees or radians, but here is my SQL code using radians. Of course this is a stored procedure where I pass the Lat and Lon. SELECT Zip FROM Zip WHERE((lat = (@TLat - (200 * 0.0005))) AND (lat = (@TLat + (200 * 0.0005 AND ((lon = (@TLon - (200 * 0.0005))) AND (lon = (@TLon + (200 * 0.0005 AND ((3963* (acos(sin(@TLat) * sin(ZIP.lat + 0.01) + cos(@TLat) *cos(ZIP.lat + 0.01) *cos((ZIP.lon+ 0.01) - @TLon = 201)) Christian -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 2:02 PM To: CF-Talk Subject: RE: OT- sql format question OOOPs it looks like I forgot to paste the rest: WHERE (((Square(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((69.1*(CDbl(zi pCodes.Longitude)-84.53822)*Cos(39.166759/57.3))^2)))50)); -Original Message- From: Phillip Beazley [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 1:58 PM To: CF-Talk Subject: Re: OT- sql format question At 02:38 PM 8/13/2004, you wrote: This was written in access, can anyone convert to T-SQL I keep doing it and keep missing something. SELECT zipCodes.*, Sqr(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((69.1*(CDbl(zipCode s.Longitude)-84.53822)*Cos(39.166759/57.3))^2)) AS DistanceInMiles Untested but looks good: SQRT(POWER((69.1*(zipCodes.latitude-39.166759)),2)+POWER((69.1*(zipCodes .longitude-84.53822)*COS(39.166759/57.3)),2) AS DistanceInMiles -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT- sql format question
My last post included a 200 mile radius.Just change the 200(s) to 50 for a 50 mile radius. Christian -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 2:02 PM To: CF-Talk Subject: RE: OT- sql format question OOOPs it looks like I forgot to paste the rest: WHERE (((Square(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((69.1*(CDbl(zi pCodes.Longitude)-84.53822)*Cos(39.166759/57.3))^2)))50)); -Original Message- From: Phillip Beazley [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 1:58 PM To: CF-Talk Subject: Re: OT- sql format question At 02:38 PM 8/13/2004, you wrote: This was written in access, can anyone convert to T-SQL I keep doing it and keep missing something. SELECT zipCodes.*, Sqr(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((69.1*(CDbl(zipCode s.Longitude)-84.53822)*Cos(39.166759/57.3))^2)) AS DistanceInMiles Untested but looks good: SQRT(POWER((69.1*(zipCodes.latitude-39.166759)),2)+POWER((69.1*(zipCodes .longitude-84.53822)*COS(39.166759/57.3)),2) AS DistanceInMiles -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Memory Issues
Yes, I have installed all of the hot fixes and latest drivers as of about 2 1/2 months ago.That is when I set everything up as a clustered environment.Hoping that both clustering and getting all of the updates/patches installed and a clean install would help correct this issue.Same problem still occurs :-( Christian -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 2:22 PM To: CF-Talk Subject: RE: Memory Issues I am having a huge issue with memory right now.I have turned off all session and application variables.If I get more than 50-75 simultaneous users, my memory starts to explode rather rapidly from around 150mb to over 750mb for the jrun service.Two problems here, 1) even though I have set up multiple instances, when the memory on one jrun service exceeds the assigned -Xmx value, all instances seize to work as well.2) I can not figure out for the life of me why this is happening.My Jrun servers are clustered and of course the memory influx does not create a fail over, and even it did, the other machine will react with the same effect.Someone please help me figure out how I can troubleshoot this. Have you installed the latest version of database drivers from the MM hotfix page? http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Memory Issues
I have not.I just downloaded the Microsoft JDBC Driver SQL 2000 and the SP1 for the driver.Is just an install enough, or do I need to do something in JRUN as well???Thank you for help Dave...I greatly appreciate it. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 2:33 PM To: CF-Talk Subject: RE: Memory Issues Yes, I have installed all of the hot fixes and latest drivers as of about 2 1/2 months ago.That is when I set everything up as a clustered environment.Hoping that both clustering and getting all of the updates/patches installed and a clean install would help correct this issue.Same problem still occurs :-( Have you tried using vendor-specific JDBC drivers? That's worked for me on occasion to fix hard-to-track memory problems. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Memory Issues
I just switched all of my data sources and NO CHANGE!!!I am getting peaks of over 500mb right now.Not that many users and I don't have any queries that return an extreme amount of data. arrrggg Christian Watt -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 3:09 PM To: CF-Talk Subject: RE: Memory Issues I have not.I just downloaded the Microsoft JDBC Driver SQL 2000 and the SP1 for the driver.Is just an install enough, or do I need to do something in JRUN as well???Thank you for help Dave...I greatly appreciate it. I thought the latest version of the MS SQL Server JDBC driver was SP3, so you might want to check that. As for using it, you'll have to install it and then either add the JAR files to JRun's classpath, or copy them to the appropriate lib directory (where macromedia_drivers.jar is now). You'll then have to select Other when setting up datasources, and construct the appropriate JDBC URL for MS SQL Server. I don't have any links handy to describe this in more detail, but it was pretty easy to figure out. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Memory Issues
Let me add to my last post.When the memory jumps, it stays up for 2-3 minutes, sometimes longer.It will usually drop back down to around 175mb -225mb after that period, and then take another jump down a few minutes later.This wouldn't be so bad if it never jumped over 750mb, but I can not figure out why it jumping that high in the first place. Hopefully this helps. I am now running CFMX 6.1 with all of the latest hot fixes (Multiple Instances, Jrun Cluster of 2) Microsoft SQL 2000 JDBC Drivers SP3 All data sources are using the MS JDBC driver Windows 2003 IIS 6.0 MS SQL 2000 (Two of them on separate machines than the web servers) If anyone needs additional info, please let me know.I am getting quite frustrated here as I am sure you all can understand!!! Christian -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 3:09 PM To: CF-Talk Subject: RE: Memory Issues I have not.I just downloaded the Microsoft JDBC Driver SQL 2000 and the SP1 for the driver.Is just an install enough, or do I need to do something in JRUN as well???Thank you for help Dave...I greatly appreciate it. I thought the latest version of the MS SQL Server JDBC driver was SP3, so you might want to check that. As for using it, you'll have to install it and then either add the JAR files to JRun's classpath, or copy them to the appropriate lib directory (where macromedia_drivers.jar is now). You'll then have to select Other when setting up datasources, and construct the appropriate JDBC URL for MS SQL Server. I don't have any links handy to describe this in more detail, but it was pretty easy to figure out. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL Query
You need to take your Where clause out and include it on the join. I believe that since you are including the outer joined table in the where, you are not going to return any records that don't match the Where statement. FROM #request.levelTable# l RIGHT OUTER JOIN #request.levelPricingTable# p ON l.levelID = p.levelID and (p.productID = #url.productID# OR p.productID IS NULL) -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 4:50 PM To: CF-Talk Subject: OT: SQL Query I tried to ask this on Experts Exchange without any luck ... maybe one of you guys may be able to help out. I am trying to build some pricing levels into our application and having a hard time with SQL query, here is an explination. I have 2 tables: LEVELS levelID, code, description, status LEVELPRICING levelPriceID, levelID, productID, Price I am running the following query: = SELECT l.levelID, l.code, l.description, p.price FROM #request.levelTable# l RIGHT OUTER JOIN #request.levelPricingTable# p ON l.levelID = p.levelID WHERE (p.productID = #url.productID# OR p.productID IS NULL) AND l.status = 1 = Basically I have the tables above (let me populate some data: Levels levelID, code, description, status 1555Wholesale 1 2444Gold Member 1 3222Silver Member 0 LevelPricing levelPriceID, levelID, productID, Price 1118 30.00 2129 25.00 3218 25.00 42 4227.00 I want to pull out WHOLESALE AND GOLD MEMBER (Silver is status 0 so it is turned off). I should be pulling out 2 recordsIF I am passing URL.PRODUCTID = 18, I should have 30.00 and 25.00 for wholesale and gold. IF my url.productID is 0 (a new product page).Then I STILL want to pull out the two rows for WHOLESALE and GOLD MEMBER, but the price should be NULL (since there is not a record for productID 0 in the levelPricing table. SO for productID= 18 l.levelID, l.code, l.description, p.price 1 555 Wholesale 30.00 2444Gold Member 25.00 For ProductID = 0 l.levelID, l.code, l.description, p.price 1 555Wholesale NULL 2444Gold Member NULL On the product building page I would like to list out all the various descriptions of level pricings from the levels table.IF the productID matches up, I would like to output the associated price with the level.IF productID is 0 (or a new record), I would like it to list out the levels.description with a NULL price. This query is not working, if there are prices associated with the productID it shows the levels, but if there are not pricing associated with the productID it doesn't show the various levels. Any suggestions? I have tried multiple variations without avail. (Needs to work in MS Access and MS SQL) Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Memory Issues
Oops, I didn't include that piece, but Yes, I am running the latest JAVA version. Christian -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 5:21 PM To: CF-Talk Subject: RE: Memory Issues Let me add to my last post.When the memory jumps, it stays up for 2-3 minutes, sometimes longer.It will usually drop back down to around 175mb -225mb after that period, and then take another jump down a few minutes later.This wouldn't be so bad if it never jumped over 750mb, but I can not figure out why it jumping that high in the first place. Hopefully this helps. I am now running CFMX 6.1 with all of the latest hot fixes (Multiple Instances, Jrun Cluster of 2) Microsoft SQL 2000 JDBC Drivers SP3 All data sources are using the MS JDBC driver Windows 2003 IIS 6.0 MS SQL 2000 (Two of them on separate machines than the web servers) If anyone needs additional info, please let me know. I am getting quite frustrated here as I am sure you all can understand!!! This is just a shot in the dark, but you might also try upgrading your JVM to the latest stable release from Sun (1.4.2_05, I think). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL Query
Paul, I just test this code in MSSQL.Access my not like the or, but this one works for ProductID of 0 or 18 and works the way you want.I am not sure if access will like it.You don't have to stipulate the ProductID as null since you are doing an outer join, also, sorry I didn't catch this last time, but you want a left outer join, not right. SELECTl.LevelID, l.Code, l.description, p.Price FROMLevels l LEFT OUTER JOIN LevelPricing p ON l.LevelID = p.LevelID AND p.ProductID = #url.ProductID# WHERE(l.Status = 1) Christian -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 5:13 PM To: CF-Talk Subject: Re: SQL Query I tried your example query, and recieved a join _expression_ not supported error.I assume that is an MS Access error .. I am trying to make this work with both MS SQL Server and MS Access (I can use two queries if necessary).Currently I am working in Access for this application. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: Christian Watt To: CF-Talk Sent: Friday, August 13, 2004 5:02 PM Subject: RE: SQL Query You need to take your Where clause out and include it on the join. I believe that since you are including the outer joined table in the where, you are not going to return any records that don't match the Where statement. FROM #request.levelTable# l RIGHT OUTER JOIN #request.levelPricingTable# p ON l.levelID = p.levelID and (p.productID = #url.productID# OR p.productID IS NULL) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT- sql format question
Eric, I am going to guess that there is a flaw with the other formula you have.I did a lot of searching on the best formula to use, and that is what I came up with.But if you think about it, 324 zip codes in a 50 mile radius, that means that every 2.7 miles you are in a new zipcode. The only thing that you have to watch out for though is around Lake Michigan and the Florida panhandle.form places in Wisconsin to Illinois or NY, or Michigan my come back within 50 miles, of course they are, if you have a boat, otherwise it is a couple of hundred miles. -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 5:14 PM To: CF-Talk Subject: RE: OT- sql format question Thanks again for the help Question though. When i run your sp I get 26 zipcodes for the cincinnatti surrounding area of 50 miles. When I run the other code in access i get 324 zipcodes? Here is that ACCESS code again SELECT zipCodes.*, Sqr(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((69.1*(CDbl(zipCodes .Longitude)-84.53822)*Cos(39.166759/57.3))^2)) AS DistanceInMiles FROM zipCodes WHERE (((Sqr(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((69.1*(CDbl(zipCo des.Longitude)-84.53822)*Cos(39.166759/57.3))^2)))50)); -Original Message- From: Christian Watt [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 2:14 PM To: CF-Talk Subject: RE: OT- sql format question I don't know if you are dealing with degrees or radians, but here is my SQL code using radians. Of course this is a stored procedure where I pass the Lat and Lon. SELECT Zip FROM Zip WHERE((lat = (@TLat - (200 * 0.0005))) AND (lat = (@TLat + (200 * 0.0005 AND ((lon = (@TLon - (200 * 0.0005))) AND (lon = (@TLon + (200 * 0.0005 AND ((3963* (acos(sin(@TLat) * sin(ZIP.lat + 0.01) + cos(@TLat) *cos(ZIP.lat + 0.01) *cos((ZIP.lon+ 0.01) - @TLon = 201)) Christian -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 2:02 PM To: CF-Talk Subject: RE: OT- sql format question OOOPs it looks like I forgot to paste the rest: WHERE (((Square(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((69.1*(CDbl(zi pCodes.Longitude)-84.53822)*Cos(39.166759/57.3))^2)))50)); -Original Message- From: Phillip Beazley [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 1:58 PM To: CF-Talk Subject: Re: OT- sql format question At 02:38 PM 8/13/2004, you wrote: This was written in access, can anyone convert to T-SQL I keep doing it and keep missing something. SELECT zipCodes.*, Sqr(((69.1*(CDbl(zipCodes.Latitude)-39.166759))^2)+((69.1*(CDbl(zipCode s.Longitude)-84.53822)*Cos(39.166759/57.3))^2)) AS DistanceInMiles Untested but looks good: SQRT(POWER((69.1*(zipCodes.latitude-39.166759)),2)+POWER((69.1*(zipCodes .longitude-84.53822)*COS(39.166759/57.3)),2) AS DistanceInMiles -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Memory Issues
Honestly I have not idea what to look for in the stack traces, do you, or anyone else have any idea where I can find some info on what to look for and how to read the stack traces? Christian -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 5:35 PM To: CF-Talk Subject: RE: Memory Issues Oops, I didn't include that piece, but Yes, I am running the latest JAVA version. In that case, I'm out of easy answers. You'll have to start looking at log files and/or running stack traces. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF Flash Connector Urrrr!
Has anyone been successful in writing there own code with the connector yet??? On other forums, have heard of a couple situations, and one I am up against the wall with myself. I have a page set up quite similar to the employee directory example, the on(release) code set is almost identical, the problem is that the flash function to be called once the dispatcher has returned data, is run at the same time that the dispatcher send parameters to the server. Therefore, when the data is returned and the onSuccess call is made, nothing happens. Please, if anyone can offer any assistance, I would greatly appreciative. You can contact me either on or off list. Code example below! Christian Watt Webmaster SkillPath Seminars [EMAIL PROTECTED] In the following example, the message never shows Searching... as soon as the search button is pressed, you see Got Data - Now populating. You can connect to 63.117.129.245 to see the code work. on (release) { // Create a server dispatcher if (typeof(serverDispatcher) == undefined) { serverDispatcher = new Object.F2S.Dispatcher(http://63.117.129.245/flashConnector/invoke.cfm;); } //resetSearch(); message = Searching...; // A. Define a result object with success and error callbacks function SearchResults(){ } function SearchResult(){ message = Got Data - Now populating; this.onSuccess = function (result) { message = Done Searching!; //numSearchResults = resultSet.seminfoid.length; // Loop thru results and show them in the searchResults movie //for (var i=0; i numSearchResults; i++) { // _root.SemList.addSemTitle(resultSet.seminfoid[i], resultSet.Title[i], i); //} /* Dynamically determine the scrollrate of the scrollWindow based upon the number of results returned */ //this.resultViewer.calculateScrollRate(numSearchResults); // Show the results //_root.gotoAndPlay(showResults); } this.onError = function (msg){ // If an error occurs show it. message = msg; } } // B. Construct a data packet var data = new Object(); data.zipcode = zipcode; data.company = SP; // C. Invoke the service. serverDispatcher.call(SemListZip, data, new SearchResult()); ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Javascript Anyone?
I know this is a little off topic, but does anyone know how to disable CTRL+N and F11 in IE??? I have the right click disabled, but would like to get rid of these abilities as well. Using it on an internal app only, so I don't have to worry about Netscape, but if the script someone has includes that...GREAT!!! Any help or pointers in the right direction would be wonderful. Thanks, ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CGLOBAL CDATA-SQL
Does anyone know what pages process the CDATA and CGLOBAL queries when you have these values stored in a DB. None of the select statments have NOLOCK's on them after sending out around 450,000 email this week, those tables are invoking an awful lot of lock:aquires and lock:release on my SQL server. It isn't killing it, but there is definatley a performance hit there. They are not SP's already looked there, they must be hardcoded queries, that at least utilize the sp_executesql (thankgod). Any help or further info would be great. Thank you, Christian Watt Webmaster SkillPath Seminars ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CGLOBAL CDATA-SQL
Yes, I realize that, that is why I see a performance hit, what I want to know is what CF Server page is called to invoke the query so that I can update it and include no locks on them. -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 12:45 PM To: CF-Talk Subject: RE: CGLOBAL CDATA-SQL AFIAK all pages will access CDATA and CGLOBAL as these are the client varibles data tables... So if you have client variables turned on and the datasource going to that database then all page requests will update them... HTH Mike -Original Message- From: Christian Watt [mailto:[EMAIL PROTECTED]] Sent: 14 November 2001 18:52 To: CF-Talk Subject: CGLOBAL CDATA-SQL Does anyone know what pages process the CDATA and CGLOBAL queries when you have these values stored in a DB. None of the select statments have NOLOCK's on them after sending out around 450,000 email this week, those tables are invoking an awful lot of lock:aquires and lock:release on my SQL server. It isn't killing it, but there is definatley a performance hit there. They are not SP's already looked there, they must be hardcoded queries, that at least utilize the sp_executesql (thankgod). Any help or further info would be great. Thank you, Christian Watt Webmaster SkillPath Seminars ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CGLOBAL CDATA-SQL
Sure you can...It is quite simple to decrypt the server pages and update them, as long as the query is in fact called from a server cfm page (which I am willing to bet that it is). I just would like to know if anyone has any idea which page, or at least which directory it is in so that I can do so. Will save a lot of time searching for it. Christian -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 1:17 PM To: CF-Talk Subject: RE: CGLOBAL CDATA-SQL AFAIK the query is made by the server itself and so you cannot change the query that it calls... -Original Message- From: Christian Watt [mailto:[EMAIL PROTECTED]] Sent: 14 November 2001 19:04 To: CF-Talk Subject: RE: CGLOBAL CDATA-SQL Yes, I realize that, that is why I see a performance hit, what I want to know is what CF Server page is called to invoke the query so that I can update it and include no locks on them. -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 12:45 PM To: CF-Talk Subject: RE: CGLOBAL CDATA-SQL AFIAK all pages will access CDATA and CGLOBAL as these are the client varibles data tables... So if you have client variables turned on and the datasource going to that database then all page requests will update them... HTH Mike -Original Message- From: Christian Watt [mailto:[EMAIL PROTECTED]] Sent: 14 November 2001 18:52 To: CF-Talk Subject: CGLOBAL CDATA-SQL Does anyone know what pages process the CDATA and CGLOBAL queries when you have these values stored in a DB. None of the select statments have NOLOCK's on them after sending out around 450,000 email this week, those tables are invoking an awful lot of lock:aquires and lock:release on my SQL server. It isn't killing it, but there is definatley a performance hit there. They are not SP's already looked there, they must be hardcoded queries, that at least utilize the sp_executesql (thankgod). Any help or further info would be great. Thank you, Christian Watt Webmaster SkillPath Seminars ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CGLOBAL CDATA-SQL
Very good point with about the CFIDE. Considering that, there is a very good chance that it is a dll. Then I maybe unable to change this at the query level, unless there is someone out there that knows of a way to turn this off the the SQL Server level, I have yet to find one. As for reverse engineering??? Call it as you may. I see it as improving the performance, something that Macromedia may like. Of course I am sure that I am truely suppose to create my own app, but then why reinvent the wheel, isn't that what CF is all about anyway, not doubling up the work. Of course in no way would I try to profit from this and any warranty would be voided if it was discovered that I did change something like this, but then what happens to people that can not remember the Admin password and change the login checking page to not check so they can get in and reset it??? Is that considered reverse engineering as well, or that acceptable? Christian -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 1:59 PM To: CF-Talk Subject: RE: CGLOBAL CDATA-SQL I also doubt that its an encrypted page as you can remove the CFIDE files... Thus it must be called from the bin directory which means the server itself -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: 14 November 2001 19:54 To: CF-Talk Subject: RE: CGLOBAL CDATA-SQL But doesn't that fall under reverse engineering? ;) -Original Message- From: Christian Watt [mailto:[EMAIL PROTECTED]] Sent: 14 November 2001 19:59 To: CF-Talk Subject: RE: CGLOBAL CDATA-SQL Sure you can...It is quite simple to decrypt the server pages and update them, as long as the query is in fact called from a server cfm page (which I am willing to bet that it is). I just would like to know if anyone has any idea which page, or at least which directory it is in so that I can do so. Will save a lot of time searching for it. Christian -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 1:17 PM To: CF-Talk Subject: RE: CGLOBAL CDATA-SQL AFAIK the query is made by the server itself and so you cannot change the query that it calls... -Original Message- From: Christian Watt [mailto:[EMAIL PROTECTED]] Sent: 14 November 2001 19:04 To: CF-Talk Subject: RE: CGLOBAL CDATA-SQL Yes, I realize that, that is why I see a performance hit, what I want to know is what CF Server page is called to invoke the query so that I can update it and include no locks on them. -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 12:45 PM To: CF-Talk Subject: RE: CGLOBAL CDATA-SQL AFIAK all pages will access CDATA and CGLOBAL as these are the client varibles data tables... So if you have client variables turned on and the datasource going to that database then all page requests will update them... HTH Mike -Original Message- From: Christian Watt [mailto:[EMAIL PROTECTED]] Sent: 14 November 2001 18:52 To: CF-Talk Subject: CGLOBAL CDATA-SQL Does anyone know what pages process the CDATA and CGLOBAL queries when you have these values stored in a DB. None of the select statments have NOLOCK's on them after sending out around 450,000 email this week, those tables are invoking an awful lot of lock:aquires and lock:release on my SQL server. It isn't killing it, but there is definatley a performance hit there. They are not SP's already looked there, they must be hardcoded queries, that at least utilize the sp_executesql (thankgod). Any help or further info would be great. Thank you, Christian Watt Webmaster SkillPath Seminars ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FW: Deleting a Query???
-Original Message- From: Christian Watt Sent: Thursday, November 01, 2001 2:08 PM To: '[EMAIL PROTECTED]' Subject: Deleting a Query??? Does anyone know if there is a way to delete query results, before the page is done processing??? I have a couple of pages that compile info and send mass emails, but some of the queries are only needed for a short period, but (correct me if I am wrong) the results of those queries will stay in memory until the page is done. Well, when one of the results can easily have over 50,000 rows, that is a lot of memory that could be freed up and either speed up the other processes running, or allow more to be run simultaniously. Any answer or push in the right direction would be VERY much appreciated. Thank You, Christian Watt SkillPath Seminars ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Email Question HELP! FOR BRUCE
It has to do with the SMTP relaying options on you mail server. Usually you do not want to relay mail at all, that way your machine can not be used for spaming. So to protect against that, you mail server probably has to verify the email address in the from field actually has an account on that machine. Depending on the type of mail server you have, you may be able to set it up to only recieve mail from certain IP addresses, that way an outside machine can not use your machine as a mail server for spam (for the most part, but we will not get into that) and you can have your CF server send mail that does not have an account on that machine. Christian Watt Webmaster SkillPath Seminars [EMAIL PROTECTED] -Original Message- From: Koo Pai Lao [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 1:58 PM To: CF-Talk Subject: RE: Email Question HELP! FOR BRUCE then how is this problem solved? i mean, how does this list make it look like it was sent from you. or hw about numerous other sites that do the same thing? From: Bruce, Rodney [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Email Question HELP! Date: Thu, 1 Nov 2001 12:54:22 -0700 I had a similar problem It was the email server. The email server would not forward any email if it did not recognize the from address. The from address had to be from an account on that server. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 12:49 PM To: CF-Talk Subject: Re: Email Question HELP! Most likely it is your mail server that is rejecting the mail if it is not from your account. You can get more information in the cfmail logs. You may want to check with your email server administrator. HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Vote for iMS as the CFDJ Reader's Choice Awards Most Innovative Product http://www.sys-con.com/coldfusion/readerschoice2001/nominationformbpa.cfm Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Koo Pai Lao [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 2:45 PM Subject: Email Question HELP! hey guys, when an order is made, 2 emails are sent out. the first email goes to the customer, so [EMAIL PROTECTED] and [EMAIL PROTECTED] The second email goes to me to notify me that an order has been made. However, it only works when my email is on the from attribute. But i would like to know the customer's email immediately. it seems that if the FROM email doesn't exist in my account, then it wont send. But then how are other people able to do this? u know, practically make up any email address and make it send out??? is there some setting i overlooked? please hlep as this is urgent! ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists