RE: Verisign/Paypal Down
Eric, We are also a Payflow Pro customer and received much the same treatment. I tried all the numbers I could find on their web site but no one answered or knew what they were talking about. This was a very bad experience for us. I believe we might soon switch away from them as our vendor. Leon -Original Message- From: Eric Haskins [mailto:[EMAIL PROTECTED] Sent: Monday, February 19, 2007 1:03 PM To: CF-Talk Subject: OT: Verisign/Paypal Down Paypal Payflow Pro went down today at 9:20AM est. We couldnt reach anyone on the phone due to the stupid holiday. So I created a post on the Paypal dev site to see if it was just us and boom a bunch of folks with the same problem. We were literally watching fly away lol. Finally at 1:34pm we get a response from Paypal on the forum acknowledging there was a Database problem. Thats a quick way to drive off customers. -- ~Eric ~| 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:270182 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFMX7 Java version compatibility
Kevin, I believe flash remoting doesn't work with JVM 1.5. We just had to downgrade because of this. Leon -Original Message- From: Kevin Kreuter [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 24, 2007 7:06 AM To: CF-Talk Subject: CFMX7 Java version compatibility I posted a more specific problem on the CF-Flex list, but can anyone provide specifics on which components of CFMX702 are incompatible with JDK1.5 or JDK1.6? I know Macromedia/Adobe doesn't officially support anything higher that 1.4.2, and I know Verity doesn't work, nor the web server config tool. I also seem to be having a problem with Flash remoting with Flex. We use the mult-server install, and have JRun updator 6 installed. Thanks. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267476 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Anyone using scan alert (Hacker safe) services?
All, I have used ScanAlert Hackersafe for several months this summer. I found their scanning was much more in-depth than Nessus. They seem to do a lot more, some of it even seemed like there was a human on the other end (for some of the things). Their web-interface is a mess though. It's horrible to navigate through. We quit using the service because we didn't see a significant increase in sales. Leon -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 08, 2006 3:27 AM To: CF-Talk Subject: Re: OT: Anyone using scan alert (Hacker safe) services? On Tuesday 07 November 2006 18:07, Jordan Michaels wrote: Hacker Defended, etc etc etc tools all basically do the same thing - and almost all of them are based on Nessus. (http://nessus.org/) Indeed. If you want an assesment, download Nessus to a laptop and park yourself in a nice coffee shop for the afternoon :-) -- Tom Chiverton Helping to paradigmatically orchestrate value-added bandwidth ~| 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:259794 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion and Maven
All, We are interested in formalizing our deployment process from development/staging/(pre-release)/production. I know Maven is really popular for this in the Java world and was wondering if anyone had experience using Maven to deploy ColdFusion applications. We have a lot of ColdFusion and a good deal of Java library dependencies. I'd love to hear from someone who has deployed a Maven implementation for ColdFusion. Thanks, Leon ~| 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:258472 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Can a Java program use a CF data source?
I've done this. It is pretty easy. Here is the code: import coldfusion.server.*; coldfusion.server.ServiceFactory.getDataSourceService().getDatasource(da tasourcename).getConnection(); Just remember to close up the connection when you're done. :) Leon -Original Message- From: Dan Parker [mailto:[EMAIL PROTECTED] Sent: Friday, September 22, 2006 10:00 AM To: CF-Talk Subject: Can a Java program use a CF data source? We'd like for our Java developers to be able to use our ColdFusion data sources. This would eliminate the need for them to have separate config files for database connections. An alternate question would be Can CF and Java developers use the same data sources? I'd like to know our options. Many thanks! ~| 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:254375 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: upgradeing jar file in coldfusion server
I guess it depends on your situation. This is not a definitive list, but these are the things I found were completely or somewhat broken with 1.5: - ldap over ssl - web services - verity admin To us that loss of functionality was better than Coldfusion randomly crashing with the 1.4 jvm. (documented linux jvm specific bug) Leon -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 12, 2006 8:08 PM To: CF-Talk Subject: Re: upgradeing jar file in coldfusion server Leon Oosterwijk wrote: Eventhough Adobe doesn't support CFMX on 1.5 it does work, with some minor inconveniences. i don't know if i'd call croaking that server's webservices a minor inconvenience. ~| 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:252994 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: upgradeing jar file in coldfusion server
Eventhough Adobe doesn't support CFMX on 1.5 it does work, with some minor inconveniences. Leon -Original Message- From: krish P [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 12, 2006 9:08 AM To: CF-Talk Subject: Re: upgradeing jar file in coldfusion server Dave Watts wrote: I have java 1.4.2 and i want to update for 1.5.0. Does any one know full instrunction step by step for updating java lib? 1. Don't. CF doesn't support 1.5. QFT. (Quoted For Truth) What he said ditto i want to use the java classes in coldfusion but there is slight problem here. In order to use the java classes i have to upgrade the java lib to 1.5.0 because the class i am looking for its not supported by java lib 1.4.2.So let me know if you have any solution to this problem. ~| 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:252872 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Selenium Testing with CF (?)
Michael, We use Selenium in-house for our testing. It has saved us a lot of time and is a great tool. Highly Reccomended. We plan to wire up a bunch of selenium test cases to run at night on our HEAD code branch. Leon -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Saturday, September 02, 2006 10:55 PM To: CF-Talk Subject: Selenium Testing with CF (?) Has anyone used Selenium ( http://www.openqa.org/selenium/ ) to test any scripts, if not CF apps itself. I just came across it earlier and have been curious. ~| 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:252214 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problems with float
Are you storing the data in a float field in the db? Floats are inherently inaccurate. You should probably use the decimal(x,y) data type (if you're using SQL server). Leon -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Monday, August 14, 2006 7:11 AM To: CF-Talk Subject: RE: Problems with float No calculations are being done, I am simply grabing the value from an XML feed and then doing an SQL insert into the DB. -- Jay -Original Message- From: Martin Thorpe [mailto:[EMAIL PROTECTED] Sent: 14 August 2006 12:45 To: CF-Talk Subject: Re: Problems with float I have had problems with floats before, where the calculations were incorrect. Wrapping everything with val(number) or evaluate(number) sorted it all out for me. It was all with calculations that the problems were caused though, returning incorrect numbers. cheers Martin Interesting issue... I am extracting a price from an XML feed for insertion into our local data. The price is returned as a simple float value which I can output to screen just fine. Unfortunately when I insert the info into the database it gets a little messed up. Here are 5 inserted values from a small test run... 19.988 15.99 9.9902 14.99 39.992 As you can see, 2 of them inserted fine but 3 of them got inserted with a 0.002 margin of error. Does anyone know why this is happening? FYI: This is going into MSSQL but I get the same problems with MySQL so I don't think it is a DB issue. -- Jay -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.10.9/417 - Release Date: 11/08/2006 ~| 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:249713 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 and Google Checkout
We'be been running ColdFusion CFMX 7 with Java 1.5 for over a year now. It runs very stable and the only issue I've found is the verity admin doesn't work. Leon -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 11, 2006 11:40 PM To: CF-Talk Subject: Re: ColdFusion and Google Checkout On 7/11/06, Pete Ruckelshaus [EMAIL PROTECTED] wrote: Google has a Java example on their site http://code.google.com/apis/checkout/samples/Google_Checkout_Sample_Co de_Java.html The problem is that it requires Java 1.5 and ColdFusion is not supported on that platform. If you *really* want to use it and you're using the J2EE edition of ColdFusion (where you can have multiple instances), I suppose you could create a new JRun instance via the JRun Admin console and set the jvm.config file to use the 1.5 JDK. (JRun with Updater 6 *does* properly support 1.5...it's ColdFusion that can't 100% handle it.) Though I'm not really sure what that's going to get you. Regards, Dave. ~| 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/cf_lists/message.cfm/forumid:4/messageid:246280 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Select * in SQL
All, Let me be the devil's advocate and say that I prefer * despite all the arguments made against it. To me, hand-coding the column names before it becomes evident that this is needed for performance reasons amounts to premature optimization. Most of the time, especially early on in development, using the * prevents annoying code errors where a data model change requires you to go back through a bunch of cfquery's and add a new column that is now needed. Leon -Original Message- From: Crow T. Robot [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 11, 2006 3:40 PM To: CF-Talk Subject: Re: Select * in SQL Heh - I was referencing that same preso. Even looked it up to make sure I had the right example. Will Tomlinson wrote: Selene Bainum did a SQL preso at CFUNITED and demo'd the asterisk VS. listing each column. Then she showed the performance differences. The asterisk was WAY slower than listing each column. Will ~| 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/cf_lists/message.cfm/forumid:4/messageid:246190 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Capturing executed SQL in CF
Have you tried using profiler? That way you don't need to change a line of code. Leon -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 11:13 AM To: CF-Talk Subject: RE: Capturing executed SQL in CF cfquery ... result=BoyGeorge ... /cfquery cfoutput#BoyGeorge.sql#/cfoutput cfdump var=#BoyGeorge# -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242917 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: accessing cfmail functionality from java
Dave, CFMAIL uses JavaMail but it spools requests, causing the calling thread to not block. This is important because a transient mail delivery failure/delay will not impact the performance of the calling page. I managed to access the cfmail functionality using the coldfusion.server.ServiceFactory. It seems to work pretty well. Nathan, We're using POJO, no JSP. A webservice call seems like a good solution as well. Leon -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 16, 2006 5:37 PM To: CF-Talk Subject: RE: accessing cfmail functionality from java I have come across the need to do a cfmail from a java class. We have some thirdparty software that runs on our ColdFusion server that uses the JavaMail system. It turns out JavaMail does a blocking call to send out mail. Does anyone know of an easy way to access the cfmail functionality from java? The CFMAIL tag uses JavaMail as well. 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! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240766 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
accessing cfmail functionality from java
All, I have come across the need to do a cfmail from a java class. We have some thirdparty software that runs on our ColdFusion server that uses the JavaMail system. It turns out JavaMail does a blocking call to send out mail. Does anyone know of an easy way to access the cfmail functionality from java? Leon ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240701 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
Does coldFusion just need a servlet engine
All, I came across this article the other day ( http://www.adobe.com/support/coldfusion/j2ee/phase2-tomcat-deploy.html ) which talks about deploying the coldFusion server on Tomcat. It was my understanding that Tomcat is just a servlet/jsp processor and is not a full j2ee server. (ejb's etc.) If coldFusion can run on just Tomcat, does this mean it doesn't rely on ejb's or other fancy j2ee features or am i mistaken altogether? Leon ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239163 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: Does coldFusion just need a servlet engine
Mark, Ah that makes a lot of sense. Thanks for the info. Leon -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Monday, May 01, 2006 9:16 AM To: CF-Talk Subject: RE: Does coldFusion just need a servlet engine Tomcat J2ee server is indeed a true j2ee server and not just a servlet container. To run CF you need the J2EE version. -Original Message- From: Leon Oosterwijk [mailto:[EMAIL PROTECTED] Sent: Monday, May 01, 2006 9:06 AM To: CF-Talk Subject: Does coldFusion just need a servlet engine All, I came across this article the other day ( http://www.adobe.com/support/coldfusion/j2ee/phase2-tomcat-deploy.html ) which talks about deploying the coldFusion server on Tomcat. It was my understanding that Tomcat is just a servlet/jsp processor and is not a full j2ee server. (ejb's etc.) If coldFusion can run on just Tomcat, does this mean it doesn't rely on ejb's or other fancy j2ee features or am i mistaken altogether? Leon ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239169 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: Get String Byte Size
I thought java stored all strings as double-byte unicode. Is this incorrect? That would make it len(string) * 16 Leon -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 9:13 AM To: CF-Talk Subject: RE: Get String Byte Size Oops yes, / 8 The OS and cluster sizes may also make a difference ;-) ...:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Loathe [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 10:05 AM To: CF-Talk Subject: RE: Get String Byte Size Or len(string) * 8? Isn't each ascii character one byte? Or is it one bit? And it it is wouldn't just be len(string) / 8? -- Timothy Heald Analyst, Architect, Developer [EMAIL PROTECTED] W: 202-228-8372 C: 703-300-3911 -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 10:00 AM To: CF-Talk Subject: RE: Get String Byte Size Wouldn't that just be len(string) ? .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Rob Wilkerson [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 9:28 AM To: CF-Talk Subject: Get String Byte Size Anyone have any quick code to retrieve the number of bytes in a string /without/ writing the string to a file first? I'm trying to do a little debugging and I'd like to know the size of a string that is being returned to the browser. Thanks. -- Rob Wilkerson ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238352 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 and 64 Bit Windows 2K3
I currently run jRun4 with the latest updater and java 1.5 on Linux. All the articles out there talk about a windows based setup. Will I be able to run in full 64-bit mode under linux? Leon -Original Message- From: J W [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 12, 2006 3:55 PM To: CF-Talk Subject: Re: CF and 64 Bit Windows 2K3 I have two servers I just setup running windows x64 and coldfusion. I am running them this way... http://www.forta.com/blog/index.cfm/2006/2/6/Connecting-ColdFusion-MX-7- To-64bit-IIS-6 Read the blog comments at the end for the proper execution code. Microsofts workaround logic is flawed a bit.. (they put the true statement in quotes where it shouldn't be) Hope that helps. Jeff On 4/12/06, Nat Papovich [EMAIL PROTECTED] wrote: You can install Windows Server 2003 64-bit edition on your AMD machine, and install ColdFusion by default, which will run in 32-bit mode. We are running that setup here. The problem with a full 64-bit environment comes down to the need to run on 64-bit JVM, which is only available from Sun and only for 1.5. Java 1.5 won't run on Jrun 4 in 64-bit mode on AMD. Summaries here: http://developer.fusium.com/FUblog/index.cfm?mode=entryentry=C41FC689 -AF6C- E817-54B71445686F5645 And here: http://developer.fusium.com/FUblog/index.cfm?mode=entryentry=D9131167 -B2BE- 5564-6E639919E70ED1B5 Good luck, and please add a comment to FUlog if you find anything different. NAT ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237672 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: CF and 64 Bit Windows 2K3
OK so let me get this right. CFMX7 doesn't run on 64-bit in 64-bit mode? I would assume this would be a function of the JVM, not of coldFusion. That's a real bummer. I was thinking about upgrading to 64-bit soon. =Leon -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 12, 2006 10:27 AM To: CF-Talk Subject: RE: CF and 64 Bit Windows 2K3 -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 12, 2006 11:22 AM You'd need to do some research to see if 64 bit Windows will run 32bit apps (like CF). My guess is it will, but I've never looked into it. Yes, it will, but there *are* compatibility problems. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237539 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: Upgrading JVM to 1.4.2_09
Scott, I'm not nathan, but we did upgrade to 1.5 and have been running that in production for a while now. It's very stable and after the latest jrun updates there aren't any issues that we have experienced. We do use xml functionality, but not really any web services so I can't tell you about that. Leon -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 05, 2006 11:37 AM To: CF-Talk Subject: RE: Upgrading JVM to 1.4.2_09 Nathan, When you upgraded to 1.5, what errors did you see? Thanks Scott Scott A. Stewart Webmaster/ Developer GlobalNet Services, Inc http://www.gnsi.com 11820 Parklawn Dr Rockville, MD 20852 Voice: (301) 770-9610 x 335 Fax: (301) 770-9611 The information contained in this message may be privileged, confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or any employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 05, 2006 12:10 PM To: CF-Talk Subject: Re: Upgrading JVM to 1.4.2_09 I've upgraded my JVM a number of times, had no problems, ever. As long as you stay in the 1.4.2 space, the _#s are just bugfixes mostly, and you can safely upgrade on CFMX 6 or 7 (just watch out for 1.5 if you like web services and XML). I won't say that upgrading my JVM solved every one of my problems with servers crashing, but it did help. Really, the way to go is to see about re-architecting your applications, upgrading your servers (Java can use almost 2GB of RAM on a 32bit server), or considering network load balancing. -nathan strutz http://www.dopefly.com/ On 4/5/06, powell @ nauticom. net powell @ nauticom. net [EMAIL PROTECTED] wrote: We've been having a rash of JVM crashes (1 per day usually) for the past 7-10 days. That's better than what it was before then (4-5 per day). We opened a ticket with Adobe/MM and made some jvm.config changes they suggested for heap memory handling (and also moved the client var database from Access to SQL Server), and that changed the frequency and nature of the crashes. The JVM crashes we're seeing now have the JVM apparently running out of memory (NT memory, not heap memory) and stopping in it's tracks. The latest suggestion from Adobe/MM is to upgrade to version 1.4.2_09 of the JVM, since this could in fact be a JVM bug. Anyone out there done this and know of any gotchas before I do this? TIA, Reed ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237084 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: Fusion Reactor Question
Rick, I believe, depending on the garbage collector you are using, that the JVM might not actually free the memory those threads used up untill it needs it. You could force a garbage collection and see if it clears up. to force GC: cfset runtime = CreateObject(java,java.lang.Runtime).getRuntime() cfset runtime.gc()/ Leon -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 29, 2006 2:41 PM To: CF-Talk Subject: Fusion Reactor Question We're trying to use FusionReactor to kill off long running requests that cause memory issues. I have it set to abort at 600 seconds. So we ran a request that we knew would take a long time, and over the course of 10 minutes, it slowly sucked up most of the memory allocated to coldfusion. At 600 seconds, FusionReactory dutifully killed the thread. However, 8 minutes have now gone by, and none of the memory has been released. There are currently NO running requests, and coldfusion is sitting there at 428MB used. Normally, it sits happily down around 70MB used. Any suggestions? Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236545 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: JRun High Memory Usage on CFMX 7
Ming Lu, I don't think there is an easy way to determine what application/site those session belong to. There are some things you can do to get a better idea of the memory load of a particular session. Here's a code snippet of something we've done on different sites to determine how much a certain page request increases our memory footprint. Make sure you don't use this on a production server, since the force garbage collection really slows down your application. cfset runtime = CreateObject(java,java.lang.Runtime).getRuntime() cfset freeMemory = runtime.freeMemory() / 1024 / 1024 cfset totalMemory = runtime.totalMemory() / 1024 / 1024 cfset maxMemory = runtime.maxMemory() / 1024 / 1024 cfoutput Free Allocated Memory: #Round(freeMemory)#mbbr Total Memory Allocated: #Round(totalMemory)#mbbr Max Memory Available to JVM: #Round(maxMemory)#mbbr Memory In Use: #Round(totalMemory-freeMemory)#mbbr /cfoutput NOW DO PAGE PROCESSING. cfset runtime.gc() / !--- now do garbage collection. To make sure numbers are accurate --- cfset freeMemory = runtime.freeMemory() / 1024 / 1024 cfset totalMemory = runtime.totalMemory() / 1024 / 1024 cfset maxMemory = runtime.maxMemory() / 1024 / 1024 cfoutput Free Allocated Memory: #Round(freeMemory)#mbbr Total Memory Allocated: #Round(totalMemory)#mbbr Max Memory Available to JVM: #Round(maxMemory)#mbbr Memory In Use: #Round(totalMemory-freeMemory)#mbbr /cfoutput Leon -Original Message- From: Ming Lu [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 07, 2006 1:54 PM To: CF-Talk Subject: Re: JRun High Memory Usage on CFMX 7 Hi Leon, Thank you so much for your input. [1]. I checked our Windows Server 2003 for Available Bytes counter, Handle Count, Pool Nonpaged Bytes, Pool Paged Bytes, and Private Bytes counters. None of these has a consistently increasing curve, so it does not look like it has memory leak. [2]. For The jvm.config file in the bin directory in JRun, the -Xmx setting has been setup at -Xmx512m, but the problem is still there. [3]. According to our programmer, we have already used the application variables where we could. Do you know if there is a way to find out which site(s) those opened sessions belong to and are from which page? Thank you very much for your help! Ming Lu ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234632 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: JRun High Memory Usage on CFMX 7
Ming Lu, If you find jrun running out of memory you have several options. A) Increase the maximum memory B) determine what is using so much memory and try to minimize it C) check if you have a memory leak and try to fix it The easiest is option A). You just have to edit your jvm.config file in the bin directory in your jrun install. And change the -Xmx setting. For B), you mention you have a log of session variables which could also be application variables. The application scope is a shared scope, which means all your sessions could share the same variable. This would cut down on your memory usage in a big way, but only if the variables are the same for all users. A Session.userID would not work as Application.userID because it is unique for each session. Leon -Original Message- From: Ming Lu [mailto:[EMAIL PROTECTED] Sent: Monday, March 06, 2006 9:39 AM To: CF-Talk Subject: JRun High Memory Usage on CFMX 7 Hi, Our sites running on Windows Server 2003 with CFMX 7 use session variables (Maximum Timeout has been setup as 40 minutes). Recently we noticed that the high memory usage for JRun is always associated with high numbers of openned sessions. Metrics logging showed that sometimes sessions reached more than 40 and at the same time the JRun used about 400 MB memory, which caused the JRun to a halt and the sites couldn't be displayed. It happens almost once a day recently. Does anyone know a solution to this problem? Should we replace all the session variables with application variables? If so what is the best Maximum Timeout for application variables? Thank you very much in advance! Ming Lu ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234430 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: JRUN and CF7 Enterprise
Chad,
My response to you would be similar to my response to Ming Lu. What I've
found helpful is graphing my memory usage in mrtg or cacti. This way you
can see when/if it crests and if this causes your jrun to die. If the
session number is accurate that means you're using about 10 meg /
session. That seems exorbitant. You might want to re-evaluate your
application to see if there is some optimizations you can perform.
Leon
-Original Message-
From: Chad McCue [mailto:[EMAIL PROTECTED]
Sent: Monday, March 06, 2006 2:45 PM
To: CF-Talk
Subject: JRUN and CF7 Enterprise
I am running ColdFusion 7 enterprise on a windows2003 server. I am
having serious JRUN memory problems. My server guy is viewing the
coldfusion-event.log and sees this line.
03/06 15:38:52 metrics Web Trends (busy/total)
{jrpp.busyTh}/{jrpp.totalTh} Sessions: 21 Total Memory=247616 Free=22786
He is telling me that the Sessions: 21 is causing the JRUN memory to
sky rocket and cause the CF server to be unresponsive.
Is that Sessions: 21 equal to the total number of session variables
set on the server?
And if so, why would 21 sessions cause JRUNs memory to increase to a
point where CF Server is unresponsive?
Thanks very much in advance.
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234458
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
Cold Fusion and Dynamic PDF Files
All, I'm going to be working on a dynamic PDF File generator. Has anyone on the list had any experience with generating dynamic PDF files based on some user variables? Based on some user input I need to fill in the blanks in a PDF document and present this to the user. Sincerely, Leon Oosterwijk ~~ 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
CFMAIL and Inline images
All, I want to send an Email using Cfmail that has images inline. That means, I want someone to get an Email with an HTML format that has images in it that will be view-able in this E-mail even if the user if offline. I used to have this solution working in PERL. In which case I merely send a flat-text file that had the MIME-encoded graphics in the bottom of the E-mail. I'm wondering if it is possible to do the same on Cold Fusion. ~~ 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
Getting Information from a RecordSet
All, I'm trying to find a way to get certain information from a recordset. I need to get a certain field from the last row of the result of a query. I know I can use #RecordCount# to get the number of rows, and I know the field name. So now I need a way to get to that information. I assume if would be something like: Recordset[#recordset.RecordCount#].fieldname but this does not work. Leon ~~ 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: Strangest Problem in a long time
Howard and everyone else that responded,
Thanks for all your feedback. I will change my variable naming to sometime
more like _dateX and then take off the X on the response page. This seems
rather cludgy but I guess it will have to do. I feel rather peeved that
there is no way in cold fusion to turn off this check feature. I'm sure lots
of people have had problems with this!
Leon
-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 6:24 PM
To: CF-Talk
Subject: RE: Strangest Problem in a long time
On your response page, try something like this:
cfset form.this_date=#form.thisdate#
In other words, convert the safe form field names into what your SQL needs
to read.
H.
Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
-Original Message-
From: Leon Oosterwijk [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 3:08 PM
To: CF-Talk
Subject: RE: Strangest Problem in a long time
Dave,
I'm using this in a large site where the SQL is generated based on the
fieldname.
fieldnameXXcolumnname is translated into:
Insert into fieldname (columname) values ('#fieldnameXXcolumname#');
I will have to come up with an extra conversion step to change the name of
these fields and then change them back. What a bummer.
Leon
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 4:57 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: Strangest Problem in a long time
Because of the database_design I cannot change the name of my
fields. Is there any way I can turn this feature off?
No, you can't turn the feature off, but you can certainly change the names
of your form fields - there's no reason that they have to be identical in
name to the database fields.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
~~
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: Strangest Problem in a long time
For those interested I used the following code snippet which I added to FormUrl2Attributes.cfm !--- Check wether this string has a _string_ end. if so, remove the trailing _ --- !--- This _ was placed so cold fusion's server side validation doesn't break my form value --- CFIF NOT REFindNoCase([[:alnum:]]+_[[:alpha:]]+_$, strFieldName ) IS 0 !--- Do the replace --- CFSET strStructFieldName = REReplaceNoCase(strFieldName, _$, ) CFELSE !--- No replace required, so just copy field --- CFSET strStructFieldName = strFieldName /CFIF Replace the strStructFieldName with your own variable names if you wish to adopt this code. Leon ~~ 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: SQL quicky
I wrote a function once that does this. Please make changes accordingly,
it's not rocket science.
//
// Formats a string of 10 digits to look like a
// phone number with dashes (-) in the right
// places
//
function strFormatPhoneNumber(str)
{
strReturn = ;
if (len(str) IS 10 OR len(str) IS 11)
{
strReturn = left(str, 3) - mid(str,4,3) - right
(str, 4);
}
if (len(str) IS 7 )
{
strReturn = left(str, 3) - right (str, 4);
}
return strReturn;
}
-Original Message-
From: Stephen Hait [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 1:14 PM
To: CF-Talk
Subject: RE: SQL quicky
This is not exactly within a cf sql statement, but...
If you can be sure that your phone numbers are 10 digit strings
you can format your output like this:
cfset tel=8005551212
cfoutputtel=(#left(tel,3)#) #mid(tel,4,3)#-#right(tel,4)#/cfoutput
The output would look like this:
tel=(800) 555-1212
How do I format a phone number (###) ###- within my cf sql
statement? My backend is sql 2000. Thanks in advance.
~~
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
Strangest Problem in a long time
People, I've encountered the strangest problem in a long time using Cold Fusion. I've got a form which posts to a Cold fusion page. One of the form elements is: INPUT SIZE=25 NAME=ticketXXdue_date TYPE=text MAXLENGTH=50 SIZE=25 VALUE= MAXLENGTH=50 When I look at my Cold Fusion Debugging information on the page that is supposed to use this form: FIELDNAMES=TICKETXXTYPE_ID,TICKETXXCATEGORY_ID,TICKETXXDESCRIPTION,TICKET_AC TIONXXTICKET_OWNER_ID,TICKET_ACTIONXXTECHGROUP_ID TICKET_ACTIONXXTECHGROUP_ID=0 TICKET_ACTIONXXTICKET_OWNER_ID=1 TICKETXXCATEGORY_ID=4 TICKETXXDESCRIPTION=dink TICKETXXDUE_DATE=10-26-01 TICKETXXREMIND_DATE= TICKETXXTYPE_ID=2 When I go through the output from the form.fieldnames: TICKETXXTYPE_ID,TICKETXXCATEGORY_ID,TICKETXXDESCRIPTION,TICKET_ACTIONXXTICKE T_OWNER_ID,TICKET_ACTIONXXTECHGROUP_ID As you can see, the due_date (along with the remind_date) are not showing up! Consequently my Database is not inserting this field and my application is not behaving the way I want it. When I change the fieldname to anything but due_date (say TICKETXXDUE_DODO) It will show up. It seems to me like there is something that the Cold fusion server does to form entries that contain a _date in their name. But I cannot verify this. Has anyone else had experience with this? ~~ 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: Strangest Problem in a long time
Hmm, Now that you mention it I do remember cold fusion having some kind of checking ability like this. It seems that if the field is called due, it would still show up on my list of fieldnames. This is not happening. Because of the database_design I cannot change the name of my fields. Is there any way I can turn this feature off? Leon -Original Message- From: Darryl Lyons [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 4:30 PM To: CF-Talk Subject: RE: Strangest Problem in a long time If you use _date appended to your field names CF will try to validate the field. Therefore the form field is in fact called ticketXXdue rather than ticketXXdue_date. Just change the name of the field to not end with _date (_required or a few other reserved names). Darryl -Original Message- From: Leon Oosterwijk [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 7:36 AM To: CF-Talk Subject: Strangest Problem in a long time People, I've encountered the strangest problem in a long time using Cold Fusion. I've got a form which posts to a Cold fusion page. One of the form elements is: INPUT SIZE=25 NAME=ticketXXdue_date TYPE=text MAXLENGTH=50 SIZE=25 VALUE= MAXLENGTH=50 When I look at my Cold Fusion Debugging information on the page that is supposed to use this form: FIELDNAMES=TICKETXXTYPE_ID,TICKETXXCATEGORY_ID,TICKETXXDESCRIPTION,TICKET_AC TIONXXTICKET_OWNER_ID,TICKET_ACTIONXXTECHGROUP_ID TICKET_ACTIONXXTECHGROUP_ID=0 TICKET_ACTIONXXTICKET_OWNER_ID=1 TICKETXXCATEGORY_ID=4 TICKETXXDESCRIPTION=dink TICKETXXDUE_DATE=10-26-01 TICKETXXREMIND_DATE= TICKETXXTYPE_ID=2 When I go through the output from the form.fieldnames: TICKETXXTYPE_ID,TICKETXXCATEGORY_ID,TICKETXXDESCRIPTION,TICKET_ACTIONXXTICKE T_OWNER_ID,TICKET_ACTIONXXTECHGROUP_ID As you can see, the due_date (along with the remind_date) are not showing up! Consequently my Database is not inserting this field and my application is not behaving the way I want it. When I change the fieldname to anything but due_date (say TICKETXXDUE_DODO) It will show up. It seems to me like there is something that the Cold fusion server does to form entries that contain a _date in their name. But I cannot verify this. Has anyone else had experience with this? ~~ 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: Strangest Problem in a long time
Dave,
I'm using this in a large site where the SQL is generated based on the
fieldname.
fieldnameXXcolumnname is translated into:
Insert into fieldname (columname) values ('#fieldnameXXcolumname#');
I will have to come up with an extra conversion step to change the name of
these fields and then change them back. What a bummer.
Leon
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 4:57 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: Strangest Problem in a long time
Because of the database_design I cannot change the name of my
fields. Is there any way I can turn this feature off?
No, you can't turn the feature off, but you can certainly change the names
of your form fields - there's no reason that they have to be identical in
name to the database fields.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
~~
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: Code Red backdoor triggered?
Does anyone know what the Log signature for Apache is for this new virus/worm? Leon -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 10:54 AM To: CF-Talk Subject: RE: Code Red backdoor triggered? I use black ice on my server. THe code red used to come in as IIS system32 command course since i was patched it did nothing, well today i have a PLETHORA of attacks all labeled EITHER HTTP UTF8 backlick and HTTP URL with double-encoded .. My guess is it's a new worm we are getting SLAMMED but it's not shutting down services like before the firewall is currently blocking it but not sure exactly what its trying to do. KElly -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 11:26 AM To: CF-Talk Subject: FW: Code Red backdoor triggered? More on the .eml files. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -Original Message- From: Dave Watts Sent: Tuesday, 18 September, 2001 11:25 To: '[EMAIL PROTECTED]' Subject: RE: Code Red backdoor triggered? It looks like when you surf to an infected site, it opens IE with a file named readme.eml which appears to contain a readme.exe. I don't have an email client on the server so I dont know what would happen if I did and I am not going to test it out. I also see a number (at least 10 - haven't counted yet) of different sites sending out requests, and interestingly they are all in the same subnet: my ip is 209.186.186.37 and they are all from 209.x.x.x I just checked the logfile for one virtual server here, and I'm getting lots of attacks from similar network addresses. I used a command-line HTTP browser to connect to one of the attacking IPs, and saw the same readme.eml thing, at the bottom of what appeared to be a regular page. Based on my reading of the logfile, I think this is some Code Red variant or followup; it's using the Code Red-specific backdoors mentioned in the incidents.org URL Cameron posted. The only thing that doesn't sound right to me is that I thought the Code Red trojan payload only worked with Win2K (simply crashing IIS on NT 4), but several of the attacking servers are identifying themselves as IIS 4. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ 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: Left Outer Join Question
Kamie, If you do have to break this out, you might want to concider using UNION ALL This was you could encapsulate your (big) query in either a view or a single Cold Fusion query. It works like this: SELECT count(*) AS num FROM a WHERE a.id = x UNION ALL Select count(*) AS num FROM b WHERE b.id = x -Original Message- From: Kamie Curfman [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 9:55 AM To: CF-Talk Subject: Re: Left Outer Join Question Thank you very much for the code, Glenn, and the thought that went behind it. Unfortunately, the SUM approach is returning the exact same multiplier effect as COUNT was. Looks like I will have to break this out into individual queries. At least I learned something from your code (I had never used SUM before in the way you have below). Thanks! Kamie Glenn Olsen wrote: Kamie, The results you are getting make perfect sense. The LEFT JOINS return NULL values where there is no match in the right-side table. COUNT is treating NULL as a value and incrementing your output column for each and every row. Instead of using COUNT, redo this using SUM with CASE statements, as below. (I haven't actually run this, so let me know if it's not exactly right.) SELECT c.company, SUM(CASE WHEN srl.company_id IS NOT NULL THEN 1 ELSE 0 END) AS search_count, SUM(CASE WHEN el.company_id IS NOT NULL THEN 1 ELSE 0 END) AS enhanced_count, SUM(CASE WHEN ctl.company_id IS NOT NULL THEN 1 ELSE 0 END) AS click_through_count, SUM(CASE WHEN cfl.company_id IS NOT NULL THEN 1 ELSE 0 END) AS contact_me_count FROM dbo.Companies c LEFT OUTER JOIN dbo.Search_Results_Log srl ON c.company_id=srl.company_id LEFT OUTER JOIN dbo.Enhanced_Log el ON c.company_id=el.company_id LEFT OUTER JOIN dbo.Click_Through_Log ctl ON c.company_id=ctl.company_id LEFT OUTER JOIN dbo.Contact_Form_Log cfl ON c.company_id=cfl.company_id WHERE c.company_id= #attributes.report_company# GROUP BY company -Original Message- From: Kamie Curfman [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 13, 2001 5:15 PM To: CF-Talk Subject: Re: Left Outer Join Question The LEFT JOIN didn't change anything. Thanks for the help, though. And thanks to cfrefactoring. I was hoping to not have to break it up into individual queries, but if that's what I have to do, that's what I have to do. Thank you! Kamie Mark Stewart wrote: Have you tried just a LEFT JOIN? -Original Message- From: Kamie Curfman [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 13, 2001 2:19 PM To: CF-Talk Subject: Left Outer Join Question I know this is more SQL than CF, but this list is so responsive... I'm trying to do a query that counts how many times a particular company showed up in the search results log table, how many times its URL was clicked on, etc. So, I'm left outer joining all the log tables, on the chance that the company wasn't returned in any of the searches, its URL was never clicked on, etc. I thought the below logic was sound, but instead of getting 14 for search_count, 4 for enhanced_count, 1 for click_through_count, and 1 for contact_me_count, I'm getting 56 for all. In other words, 14*4*1*1. Why is this happening? Why aren't I getting separate counts for each? Here is the query. Thank you so much in advance. cfquery datasource=#request.datasource# name=get_company SELECT c.company, COUNT(srl.company_id) AS search_count, COUNT(el.company_id) AS enhanced_count, COUNT(ctl.company_id) AS click_through_count, COUNT(cfl.company_id) AS contact_me_count FROM dbo.Companies c LEFT OUTER JOIN dbo.Search_Results_Log srl ON (c.company_id=srl.company_id) LEFT OUTER JOIN dbo.Enhanced_Log el ON (c.company_id=el.company_id) LEFT OUTER JOIN dbo.Click_Through_Log ctl ON (c.company_id=ctl.company_id) LEFT OUTER JOIN dbo.Contact_Form_Log cfl ON (c.company_id=cfl.company_id) WHERE c.company_id=cfqueryparam value=#attributes.report_company# cfsqltype=cf_sql_integer GROUP BY company /cfquery Kamie -- Kamie B. Curfman Matrix Group International, Inc. 801 N. Fairfax Street, Suite 205 Alexandria, VA 22314 Phone: (703) 838-9777 x3014 Fax: (703) 838-9799 [EMAIL PROTECTED] ~~ 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
Attributes Scope Variable List
All, Is it possible to find out all the variables that are declared in a certain scope? I'm trying to loop over all the variables in the Attributes Scope and insert their contents in hidden form fields. I was wondering if anyone has accomplished something like this. Leon Oosterwijk ISDN-NET Inc. ~~ 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: Access memo fields truncated in GROUP BY?
Joseph, The problem here lies in Access/SQl Server not with Cold Fusion. If you wish to retrieve a big field with more than 255 chars you need to either specify this in at the end of your sql query or, if you are using complex query clauses as a separate query. I ran into this problem developing an ASP site once. I ended up using a separate SQL statement to get the memo fields like so: query: a Select ID,stuff,stuff FROM foo,bar WHERE complex query clauses Query: b Select longfield FROM foo WHERE ID = b.ID There is more information about this on the net if you search for the ODBC Error message you get back. Leon -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 5:41 PM To: CF-Talk Subject: Re: Access memo fields truncated in GROUP BY? Yes, Thank you for looking. Changing the order didn't work. Neither did checking the long text field in the CF administrator. Heck, in the ODBC control panel I tried adjusting the buffer and the MaxAcanRows values (I believe they let the driver determine what the data types are?) I feel better know that I have found other people with the same unresolved problem: I have a workaround in mind but this evening I will continue to poke around. I take it that the 'Message' field is the Memo field? If so, try selecting that one last in the query... SELECT Max(Messages.TimeStamp) As NewMessage, Topics.Topic, Messages.Message FROM Messages INNER JOIN Topics ON Messages.TopicID=Topics.ID GROUP BY Topics.Topic, Messages.Message Other than that??? HTH, Jeff -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 10:18 PM To: CF-Talk Subject: Access memo fields truncated in GROUP BY? Something I hadn't noticed before. What's up with Access, Memo fields, and joins? If you include a memo field in a GROUP BY it gets truncated to 255 chars... not the desired effect here. If I remove the MAX() ..and then don't require the GROUP BY then the field is not truncated... If there is a solution I would love to hear it. (feeling perplexed) (the simplified non-working query) cfquery datasource=forum name=GetForumInfo debug SELECT Messages.Message, Max(Messages.TimeStamp) As NewMessage, Topics.Topic FROM Messages INNER JOIN Topics ON Messages.TopicID=Topics.ID GROUP BY Topics.Topic, Messages.Message /cfquery ~~ 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: Remove spaces
I know that both English and Dutch Zip codes are alpha-numeric and 6 characters long (minus spaces). -Original Message- From: Rich Tretola [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 14, 2001 4:22 PM To: CF-Talk Subject: RE: Remove spaces Can't do that because the US zips are 5 digits and international are 6. Rich -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 14, 2001 5:11 PM To: CF-Talk Subject: RE: Remove spaces You could do a Replace(zipcode, ,,all) but I would suggest doing client-side as well as server-side validation, and make it more robust than just checking for spaces. Check for length, all numbers, etc. --- Billy Cravens HR Systems, EDS [EMAIL PROTECTED] -Original Message- From: Rich Tretola [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 14, 2001 3:59 PM To: CF-Talk Subject: Remove spaces What function do I use to remove spaces in the middle of a string? I have a zipcode field where international users are leaving spaces in the zipcode which is causing errors in the shipping calculator. Thanks, Rich ~~ 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
Is CFLOCK Really Locking?
All, I've written a CFX Tag which implements some code that can only be execute once per Virtual Machine. Since Cold Fusion uses only one Virtual Machine per server only one person can execute this tag at a time. To facilitate this I've wrappen the CustomTag in a CFLOCK. This Should keep this customer tag single-threaded. However, on execution when i submit two reqwuests for the same page at the same time one screen gets a result and the other screen doesn't get anything. When i go through the logs it appears that only one request gets adhered, the other one crashes the server. This seems strange to me when the CFLOCK should single-thread the execution. please note that i've tried both SCOPE and NAME attributes on the CFLOCK tag. CFTRY CFLOCK TIMEOUT=90 SCOPE=Application THROWONTIMEOUT=Yes TYPE= Exclusive CFX_Qualify_DSLv2 NUMBER=#lqs_number# USERNAME=username PASSWORD=password NAME=Qualify /CFLOCK CFCATCH Could Not Execute This page, Sorry /CFCATCH /CFTRY Leon Oosterwijk ~~ 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
Client Variables Storage Woes
All, Our Cold fusion 5 server has been experiencing significant problems with our client variables storage. We used a SQL Server datasource to store our Client Variables. Before we took our database offline we changed the administrator setting to store the client variables in the registry. However our cold fusion server has been displaying erradic behaviour since then. Random server crashes and no errors in the log files. I was finally able to reinstate the client variables data source. this has resolved the problem for now. This does however raise some concerns with me. Cold fusion is not smart enough to detect that the client db is offline and just blows up. This does not seem very robust. On top of this. When we had migrated away from the db client variables cold fusion was still trying to terminate stale variables in the db after the db had been removed from the list of client var storage. Leon ~~ 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: Client Variables Storage Woes
Bryan, I failed to mention the fact that this runs on a linux system. I understand the fragility of the registry no matter what platform however. My discussion was merely to highlight the erradic problems that Cold Fusion seems to experience when removing the access to the client variables data store. this is to me more worriying than the performance/scalbility issues related to registry-stored client vars. Leon Oosterwijk -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 1:34 PM To: CF-Talk Subject: RE: Client Variables Storage Woes The registry is a sort of database itself, but it is fragile and is ONLY meant to store information required by the operating system. When you start dumping hundreds of (long?) variables into the registry it hampers the operating system's ability to retrieve the crucial information it requires. Use cookies if you can't use a db, but remember that cookie size is limited to 4000 characters. Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] ~~ 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: Client Variables Storage Woes
Cameron, I do not use client variables on this particular system. I was merely playing with the option. Understand that this is a Linux Server. I understand that the registry is a text file and means a performance hit as well as a security risk. however given the development state this server is in, and the lack of a stable SQL server at that point in time I did not see any problem with changing over to registry. I would prefer messages like Could not open Client Variables Datastore over the random crashes of my server, yes. I noticed errors in the logs (which have since been cleared) that were indicating CF was trying to clean up client variables and errored. Leon -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 11:58 AM To: CF-Talk Subject: RE: Client Variables Storage Woes Random server crashes and no errors in the log files. I was finally able to reinstate the client variables data source. this has resolved the problem Yes, because you were storing client variables in the registry. NEVER EVER do this. On a production machine. for now. This does however raise some concerns with me. Cold fusion is not smart enough to detect that the client db is offline and just blows up. This does not seem very robust. You would prefer client.thisvar cannot be found errors all over your app to errors informing you of the true problem? That your datastore is missing? On top of this. When we had migrated away from the db client variables cold fusion was still trying to terminate stale variables in the db after the db had been removed from the list of client var storage. What behavior/error etc led you to this conclusion? -Cameron Cameron Childress elliptIQ Inc. p.770.460.1035.232 f.770.460.0963 -- http://www.neighborware.com America's Leading Community Network Software ~~ 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: MS SQL DB to MS Access
Jeff, I remember struggling with this. The only way I was able to export tables AND relationships was by exporting the database into SQL script. Then, to upload this into Access. I've since forgotten how to execute SQL directely into Access, but setting up an ODBC and executing from a some SQL-capable client should work. Leon Oosterwijk ISDN-NET -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 3:09 PM To: CF-Talk Subject: RE: MS SQL DB to MS Access Well I have successfully downsized my SQL DB to Access. But none of the relationships were exported, is it possible to do this? TIA, Jeff -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 12:12 PM To: CF-Talk Subject: OT: MS SQL DB to MS Access Hi all, I have a DB in MS SQL and want to export it to MS Access to make some modifications, then I plan to upsize it again. I am familar with upsizing Access to SQL but not the other way, from SQL to Access. Thanks for any help, Jeff ~~ 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: selecting top n records
SELECT * FROm Table LIMIT 10; -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 3:23 PM To: CF-Talk Subject: RE: selecting top n records First thought would be something like: SELECT TOP 10 COUNT(PRODUCTID) AS COUNTER, PRODUCTID FROMORDERDETAIL GROUP BYPRODUCTID ORDER BYCOUNTER DESC There may be something faster, but this works... - BILL - -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 2:07 PM To: CF-Talk Subject: selecting top n records I need to select the top selling products from a table of lineitems. Top selling products would be those whose ID_PRODUCT shows up the most in the ORDERS_LINEITEMS table. Any clues from the SQL gurus out there? ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = ~~ 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
Calling Template File name lookup
All, I'm trying to find a way to find the name of a calling template. say, for instance I've got the following page structure: index.cfm ---include-- somefile.cfm ---include-- anotherfile.cfm When I'm executing in the anotherfile.cfm is there a way to get the filename of the calling page? (somefile.cfm) When cold fusion generates an error it shows you a stack trace of customtags, and a list of include files. this leads me to believe that it is storing this information somewhere. it needs to be possible somehow to find the filename of the file calling the include. I'd appreciate some help on this issue. Leon ~~ 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
Client Variables Datasource
All, This morning my Cold Fusion server started acting very strange. I noticed that any page with a query that I pulled up was taking extremely long to load. most of the pages timed out or display a SQL Error. After some serious digging around it turned out that the problem was our Client Variables Datasource. Due to a server move the MS SQL7 server that stores the client variables became unavailable. This apparently caused the Cold Fusion templates to time out on database connects. The strange thing here is that our primary datasource is a Postgres Database on a Linux system. None of the Cold Fusion templates use client variables. The main concern for me was the lack of informative messages concerning the absence of the session database. Cold Fusion just gave SQL Query errors on my application database. not in the screen errors or in the log files was there any mention of the client variables datasource. Does anyone know if this is the desired behaviour of Cold Fusion? It seems that this might be an area for improvement. Specs: Linux Redhat Cold Fusion 4.5 Postgres DB (application) ODBC MS SQL 7 DB (Client Varsa) MERANT (different machine) Leon ~~ 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: Is this list monitored?
All, It seems that the volume and the nature of the messages is making it very hard to pick out the good stuff. Perhaps it would be a good to start moderating this list. It is a valuable resource but could be more valuable if it was easier to asses if something is worth reading. Sincerely, Leon Oosterwijk -Original Message- From: Matt Brown [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 8:48 AM To: CF-Talk Subject: Re: Is this list monitored? It is monitored but not moderated. The owner reads the posts or at least is aware of them all, but doesn't check before the post goes live. The thread you are referring to has been stopped and you cannot post or respond to it. IMO, it was off topic, but the content of the post was NOT what the title read. The title was an example of very bad judgment, not actually a call to any action. I would not unsubscribe if I were you. I think this is rare. Debbie McDaniel wrote: Hi All, Recently there was a political thread on this list which made mention of our President. I need to know if this list is monitored? If so, how did this get through? I would hate to have my company inform me that I need to unsubscribe because of issues like this. I have subscribed to this list for some time, and I've seen some stuff really off base, but this one took the cake. I would hate to lose a valuable resource. TIA, Debbie Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
