Remote COM+
Hi All, Does anyone have some example code to call and instantiate a COM+ component residing on a different Win 2k3 machine? I've made several attempts but just get an exception saying An exception occurred when instantiating a Com object. Any help would be much appreciated. Thanks, Gavin __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244087 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: Anybody expierence in medical stuff e.g. DICOM, HL7
My company is working on HL7 interfaces with NHS UK. What did u want to know?? Gavin -Original Message- From: Daniel Hikel [mailto:[EMAIL PROTECTED] Sent: 12 October 2005 12:06 To: CF-Talk Subject: Anybody expierence in medical stuff e.g. DICOM, HL7 Hello !!! I am new here and working with since years. For a new job i am looking for any modules, help, infos, ... about Coldfusion and working with standard medical date like HL7, Dicom, ... Does anybody have some expierence and can report? Thanks Daniel ~| 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:220796 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
Flash Error Handling
All, I'm just implementing a Flash Remoting system and I'm encountering a strange problem with exception handling. Basically, I want to be able to cfthrow and error and the flash application to pick that up and handle it. I have a fault handler in Flash which successfully detects there is an exception and calls the code within. The problem is the error that is detected is not the message I have thrown, its an exception cannot convert the value of type class coldfusion.runtime.TemplateProxy to a Boolean Here is my flash handler code: function gotCategories_Fault(fault:FaultEvent):Void { trace(Categories Fault: + fault.fault.faultstring); } Anyone else experienced this or am I just doing something wrong? Thanks in advance. Gavin ~| 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:220639 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
Weird Flash Remoting Problem and Solution
All, I experienced a strange issue with Flash MX 2004 Pro and CFMX7. When calling functions through the gateway with flash, it appeared that the gateway was being cached. This meant that function names could not change and new functions added would not be available to Flash. A Service Invocation error was experienced on the CF server when calling them. I tried restarting both the CF server and flash, hotfixes, updater, etc and still the problem was there. Eventually I investigated the gateway configuration on the CF server. This is a standard install, with everything at default (except caching CFC's). The solution was to change the \WEB-INF\gateway-config.xml file on the CF server. Near the top there is a section called Service-Adapters. I simply uncommented all relating to Flash there and restarted CF. The Flash SWF is now calling them correctly. As how this fixed, I'm not sure. Maybe someone has an idea out there??? Just thought I'd post this info in case anyone else experienced this strange problem. Gavin ~| 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:219575 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
Flash Remoting Framework
Hi All, I'm just about to embark on a large Flash Remoting project and I was wondering what people's thoughts and advice would be for a suitable framework? The key features would need to be performance, scalability and maintainability. Any ideas?? Thanks in advance, Gavin ~| 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:219319 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
Securing Flash Gateways
Hi All, I'm currently designing an application that will utilise a Flash frontend and talk to a CFMX7 Flash gateway for performing business logic. This connection needs to be secure and the users authenticated via the business objects. I am familiar with how to perform the authentication and I've read a few articles on security. I was wondering if anyone has any suggestions or experiences with securing this process both at the application and request levels. Any tips will be greatly appreciated. Thanks, Gavin ~| 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:213837 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
Ideas - Your Help Needed
Hi All, I've got a little bit of a problem and I hope that you guys would be able to give me advice or shed a little light on a situation I have The Setup 1xApplication Server - Windows 2003 Web Edition - CFMX 6.1 Standard, all patches 1xDatabase Server - Windows 2003 Standard Edition - SQL Server 2000 SP3a This setup is running an application that our company wrote to store data relating people. This information is entered through a dynamic form which is configured through an admin interface. The whole application has been developed using Mach-II. The system has been live for a year now and was thouroughly tested by all parties before go live. There have been a couple of bugs since, but the code has been unchanged and stable for at 8months now. The problem is this. We have been getting reports of data corruption on a very small number of forms. I have investigated this corruption. The system logs who made what changes to the system to provide an audit trail for each form. The audit trail shows users have made the corrupt changes to the form and I presented this to the client. They will not accept this response. I'll give you an example, a name had been changed from one to another. I checked the live database and a backup and they both show that a user changed the name. The user insists that he did not change the name. I cannot see in light of this evidence and problem with my code or the system. My question to the forum is basically, is there anything I'm missing? Sorry for the longwinded explanation, but I feel like I'm banging my head against a wall! Any ideas you might will be greatly appreciated. Thanks in advance, Gavin ~| 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:199305 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: Ideas - Your Help Needed
I've shown them the audit logs for each bit, but I will arrange to go through the process step-by-step. That's a good idea. Thanks -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: 18 March 2005 12:52 To: CF-Talk Subject: Re: Ideas - Your Help Needed If your client contact is non technical, you may just need to talk them through the evidence very carefully so they can understand the sequence of events as you do. Maybe you could should them as example of entering data and changing data and then show them the log records that are created from the example. Mike On Fri, 18 Mar 2005 12:42:01 -, Gavin Brook [EMAIL PROTECTED] wrote: Hi All, I've got a little bit of a problem and I hope that you guys would be able to give me advice or shed a little light on a situation I have The Setup 1xApplication Server - Windows 2003 Web Edition - CFMX 6.1 Standard, all patches 1xDatabase Server - Windows 2003 Standard Edition - SQL Server 2000 SP3a This setup is running an application that our company wrote to store data relating people. This information is entered through a dynamic form which is configured through an admin interface. The whole application has been developed using Mach-II. The system has been live for a year now and was thouroughly tested by all parties before go live. There have been a couple of bugs since, but the code has been unchanged and stable for at 8months now. The problem is this. We have been getting reports of data corruption on a very small number of forms. I have investigated this corruption. The system logs who made what changes to the system to provide an audit trail for each form. The audit trail shows users have made the corrupt changes to the form and I presented this to the client. They will not accept this response. I'll give you an example, a name had been changed from one to another. I checked the live database and a backup and they both show that a user changed the name. The user insists that he did not change the name. I cannot see in light of this evidence and problem with my code or the system. My question to the forum is basically, is there anything I'm missing? Sorry for the longwinded explanation, but I feel like I'm banging my head against a wall! Any ideas you might will be greatly appreciated. Thanks in advance, Gavin ~| 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:199312 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: Ideas - Your Help Needed
Definitely. I have reviewed my code and had other developers review it too, just to be sure. Is there any possibility of CFMX or SQL doing this?? I've searched and cannot find anything. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 18 March 2005 13:03 To: CF-Talk Subject: RE: Ideas - Your Help Needed Stay away from accusations, say that all the evidence points to a mistake on their part.This way they may be less defensive. Also double check that your code is solid. Ade -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: 18 March 2005 12:52 To: CF-Talk Subject: Re: Ideas - Your Help Needed If your client contact is non technical, you may just need to talk them through the evidence very carefully so they can understand the sequence of events as you do. Maybe you could should them as example of entering data and changing data and then show them the log records that are created from the example. Mike On Fri, 18 Mar 2005 12:42:01 -, Gavin Brook [EMAIL PROTECTED] wrote: Hi All, I've got a little bit of a problem and I hope that you guys would be able to give me advice or shed a little light on a situation I have The Setup 1xApplication Server - Windows 2003 Web Edition - CFMX 6.1 Standard, all patches 1xDatabase Server - Windows 2003 Standard Edition - SQL Server 2000 SP3a This setup is running an application that our company wrote to store data relating people. This information is entered through a dynamic form which is configured through an admin interface. The whole application has been developed using Mach-II. The system has been live for a year now and was thouroughly tested by all parties before go live. There have been a couple of bugs since, but the code has been unchanged and stable for at 8months now. The problem is this. We have been getting reports of data corruption on a very small number of forms. I have investigated this corruption. The system logs who made what changes to the system to provide an audit trail for each form. The audit trail shows users have made the corrupt changes to the form and I presented this to the client. They will not accept this response. I'll give you an example, a name had been changed from one to another. I checked the live database and a backup and they both show that a user changed the name. The user insists that he did not change the name. I cannot see in light of this evidence and problem with my code or the system. My question to the forum is basically, is there anything I'm missing? Sorry for the longwinded explanation, but I feel like I'm banging my head against a wall! Any ideas you might will be greatly appreciated. Thanks in advance, Gavin ~| 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:199313 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: Ideas - Your Help Needed
No, the key is unique and not editable. The transactions are all complete. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 18 March 2005 15:37 To: CF-Talk Subject: RE: Ideas - Your Help Needed Just as a check I may have misunderstood but are you allowing end users to update the key in the database? Also is everything that needs to be in a transaction definitely in a transaction? Kola -Original Message- From: Gavin Brook [mailto:[EMAIL PROTECTED] Sent: 18 March 2005 13:08 To: CF-Talk Subject: RE: Ideas - Your Help Needed Definitely. I have reviewed my code and had other developers review it too, just to be sure. Is there any possibility of CFMX or SQL doing this?? I've searched and cannot find anything. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 18 March 2005 13:03 To: CF-Talk Subject: RE: Ideas - Your Help Needed Stay away from accusations, say that all the evidence points to a mistake on their part.This way they may be less defensive. Also double check that your code is solid. Ade -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: 18 March 2005 12:52 To: CF-Talk Subject: Re: Ideas - Your Help Needed If your client contact is non technical, you may just need to talk them through the evidence very carefully so they can understand the sequence of events as you do. Maybe you could should them as example of entering data and changing data and then show them the log records that are created from the example. Mike On Fri, 18 Mar 2005 12:42:01 -, Gavin Brook [EMAIL PROTECTED] wrote: Hi All, I've got a little bit of a problem and I hope that you guys would be able to give me advice or shed a little light on a situation I have The Setup 1xApplication Server - Windows 2003 Web Edition - CFMX 6.1 Standard, all patches 1xDatabase Server - Windows 2003 Standard Edition - SQL Server 2000 SP3a This setup is running an application that our company wrote to store data relating people. This information is entered through a dynamic form which is configured through an admin interface. The whole application has been developed using Mach-II. The system has been live for a year now and was thouroughly tested by all parties before go live. There have been a couple of bugs since, but the code has been unchanged and stable for at 8months now. The problem is this. We have been getting reports of data corruption on a very small number of forms. I have investigated this corruption. The system logs who made what changes to the system to provide an audit trail for each form. The audit trail shows users have made the corrupt changes to the form and I presented this to the client. They will not accept this response. I'll give you an example, a name had been changed from one to another. I checked the live database and a backup and they both show that a user changed the name. The user insists that he did not change the name. I cannot see in light of this evidence and problem with my code or the system. My question to the forum is basically, is there anything I'm missing? Sorry for the longwinded explanation, but I feel like I'm banging my head against a wall! Any ideas you might will be greatly appreciated. Thanks in advance, Gavin ~| 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:199353 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: Ideas - Your Help Needed
The session is only used to store the details of the user who has logged in. Everything is through the forms. Even manipulating the form would show up in the audit log. As an update, I've now added logging to log everything being sent to the server, so we can effectively track every mouse click. All the evidence points to user error, so hopefully when confronted with the extensive logs, it will carry more weight. Thanks, Gavin -Original Message- From: Casey C Cook [mailto:[EMAIL PROTECTED] Sent: 18 March 2005 16:24 To: CF-Talk Subject: RE: Ideas - Your Help Needed We had a situation where a manager would enter a pay increase for employee A but it would save the record into employee B record. Basically what was happening is they would enter employee B make some changes to the form, change their mind, click the back button a couple times to employee A record and hit submit. Well, the session information from employee B was still hanging around and was insert into employee A record. Maybe something like this could have occurred, he entered a different name, changed his mind went to a different screen and saved some form contents and it saved the bogus name. Thanks, CC ~| 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:199363 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: Installing CFMX 6.1 via Terminal Services
Yes, I've done this many times in both server and Jrun configurations, and not experience any problems. I was logged in with administrator privileges, so ensure you have the same. Gavin -Original Message- From: Sung Woo [mailto:[EMAIL PROTECTED] Sent: 28 February 2005 14:21 To: CF-Talk Subject: Installing CFMX 6.1 via Terminal Services Has anyone installed CFMX 6.1 via Terminal Services successfully? ~| 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:196776 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
Sharing Application Sessions
Hi All, I'm trying to create a single sign on system for several of my CFMX apps. They all utilise the same security model and security objects, so I figure there must be a way to allow me to log into 1 app, and switch to the others without being prompted to login. This isn't currently a clustered environment, but will move to that at some point. Has anybody implemented anything similar to this? The login details are held in the users session, so I guess there must be an easy way to tell CF to use an alternate session, or transfer it, to the other app. Any ideas?? Thanks, Gavin ~| 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:194966 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: Sharing Application Sessions
Thanks everyone, this works a treat. Gavin -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: 16 February 2005 16:38 To: CF-Talk Subject: RE: Sharing Application Sessions I do this with SSL pages. My general app is CFApplication name=MySite .. Then in my SSL pages, They all have CFApplication name=MySite . Cfset mySession=session CFApplication name=MySSLSite . !--- user mySession variable as needed -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 16, 2005 11:27 AM To: CF-Talk Subject: RE: Sharing Application Sessions You can use multiple CFAPPLICATION tags in a single template, therefore, switching applications in the process. Call the first CFAPPLICATION and store its application-scope variables in a different scope. Then, call the second CFAPPLICATION and load its application-scope variables from the different scope. I'm not sure if this behavior is the same in CF7. M!ke -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 16, 2005 10:20 AM To: CF-Talk Subject: RE: Sharing Application Sessions They will all need to use the same application name (and therefore actually be the same app). ~| 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:195023 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 and SQL Server Reporting Services
Hi All, Does anyone have any experience of integrating CFMX and SQL Server Reporting services. I've managed to cobble something together, but I not happy with the lack of security (from the reporting services front) Has anyone managed to achieve a happy medium or have any advice? Many thanks, Gavin ~| 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:194060 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 5 and CFMX together on the same files?
There is an article on how to do this in Coldfusion Developers Journal, vol 5(2003), issue 9. http://sys-con.com/coldfusion/article.cfm?id=647 It allows you to set-up everything through IIS and have virtual directories like mx, cf5 and bd which route the request through the appropriate CF version. These all point to the same set of files. I've set this up on a development server and it works extremely well. Gavin -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: 25 January 2005 11:33 To: CF-Talk Subject: RE: CF 5 and CFMX together on the same files? Effectively have two sites that point at the same directory, one site uses CF 5, and one site uses CFMX. - Calvin -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 8:18 PM To: CF-Talk Subject: CF 5 and CFMX together on the same files? Hi, It is possible to install CFMX and have it work together with CF 5. But is it possible to have them share the same Web space (server directory) and call either one or the other one on the same files? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:191679 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
SOT: Garbage Data Detection/Prevention
Hi All, I've got a CF/SQL Server 2k application that serves several hundred users and is designed to store large amounts of data. I have built in many checks and restrictions into the application to prevent incorrect data being inserted. But there is a proportion of users who are circumventing these restrictions by entering garbage data. For instance, where a name is required, they would enter jdsl. There is only so far I can go to do checks as data is input, so I need to concentrate on user education by finding the culprits. There is full auditing of the data and to this end, I was wondering if anyone had any thoughts on ways to find garbage data, or other steps I could take to prevent it. Most of the data in the system is fine, so I was thinking maybe somehow comparing data with other examples of correct info to root out the garbage. I'm just not sure how! Any thoughts or suggestions would be greatly appreciated. Thanks, Gavin ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185788 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: SOT: Garbage Data Detection/Prevention
Yeah, I agree. I only really want to find out who's doing it so they can be better trained. The spelling check is a good idea. It will at least cut the list down. At the minute I've basically got the system to checking user data on the fly to check for duplicates, required fields and validation of phone numbers, etc. -Original Message- From: Ryan Emerle [mailto:[EMAIL PROTECTED] Sent: 01 December 2004 14:17 To: CF-Talk Subject: Re: SOT: Garbage Data Detection/Prevention The only thing i would suggest is that you don't alienate your users by implmenting some flawed garbage detection scheme. There will be some users whose name really is Sadf Dsij (even if it's not an international site). If you do anything, i would run your algorithm in the background and simply flag the accounts for human review if they seem off. One method would be to run a spelling-type check and based on the number of possible errors, you can flag the entry. The last thing you want to do is piss of your users so that you have less work to do :) -R ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185792 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: Write large amount of data to text..
Just a suggestion, but could you not just use Oracle to write the text file out? As you already format the text with SQL, this would bypass going to ColdFusion altogether and streamline the process. Gavin -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: 22 November 2004 17:56 To: CF-Talk Subject: Write large amount of data to text.. I have a application that writes loads of data to a text file. I use SQL to format the text as I pull the data from the DB. But my problem is that this is loading 11,000+ rows into a text file. I believe this is timing out. I was wondering if there is a better way of putting this into a file than cfsavecontent variable=ecount_file cfloop query=fetchReferrals cfoutput#record_data#/cfoutput /cfloop /cfsavecontent cffile action=WRITE file=#g_EcountFileDirectory#\#eCountFilename# output=#ecount_header##ecount_file##ecount_footer# addnewline=Yes The query takes only around 20 seconds to process but the page is still loading after 15 minutes. So I'm guessing it's timed out already. If I put endrow=5000 in the cfloop tag it completes in a few minutes. Any ideas? -- Auxilium meum a Domino ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185111 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
ClusterCats Monitoring
Hi All, Does anyone here know if/the best way to monitor/control ClusterCats systems? I'd like to be able to write a small CF app to monitor each server in the cluster and control it. Any advice would be greatly appreciated. Thanks, Gavin ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185173 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: Primary Key Justification
Personally I use an individual primary key myself. In the past I have seen oracle databases with two fields as the primary key, but never a whole record. The only justification I can see for having the whole record as the primary key is to save space. Adding an extra column to store a primary key requires the space to store it and the storage for the sequence. On modern servers storage is not usually a problem, particularly with such a small field. On older mainframes, it was. One major justification for a single primary key is replication. If you have multiple fields as a primary key, on a replicated system, there is a higher chance that the same values will appear. It will at least cause more headaches and more setting up initially. Gavin -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 14:01 To: CF-Talk Subject: Primary Key Justification I'm well aware of the need for a primary key, in addition to a sound table design, however, I'd like someone else to word a response for me. A co-worker built a data file (a data table on an AS400) with six fields. The only unique key of the record is the entire record, itself. The combination of all six fields must be used to identify the exact record. This is how it's done, is the reply I get. (I've been building web-based apps using relational DBs for 8 years. I have never used an entire record as the primary key.) I'm not passing an entire record through a URL or in hidden form fields. Imagine the nightmare of maintaining this application... A discussion of the existence of Oracle's sequences and SQL's identity fields did little to sway this person's opinion. This person's entire development background is AS400 with a history of bad database design. Now, I'm creating the table myself to do it right. ;-) Any thoughts? Thanks M!ke ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183712 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: Using Like Keyword for searching
This should work... -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 15:48 To: CF-Talk Subject: Using Like Keyword for searching I'm building in somewhat of a keyword search into a site I'm working on. The search basically looks at what was typed into the search field, does a query on a particular field in the database using the like keyword and then returns a code or codes that is associated with that particular field in the database. The issue I'm having is if the value that is sotred in the db is something like Cases: 24 - 30 and a person types in 24 cases in the search field the query doesn't find anything. My query looks like: cfquery name=search datasource=ds Select someFields from someTable where searchField Like '%#form.search#%' /cfquery Now if you type 24 or 24 for example it will return the Cases: 24 - 30. I wanted to do either a verity or Full text search but the client doesn't want me to. Does anyone have any ideas on what I can do to get the query to find anything that matches what is typed in? Thanks, Ben ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183737 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: Using Like Keyword for searching
Ok, actual code on this one! cfquery name=search datasource=ds select someFields from someTable where 1=1 cfloop index=currKeyword list=#form.search# delimiters= AND searchField Like '%#currKeyword#%' /cfloop /cfquery -Original Message- From: Gavin Brook [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 16:05 To: '[EMAIL PROTECTED]' Subject: RE: Using Like Keyword for searching This should work... -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 15:48 To: CF-Talk Subject: Using Like Keyword for searching I'm building in somewhat of a keyword search into a site I'm working on. The search basically looks at what was typed into the search field, does a query on a particular field in the database using the like keyword and then returns a code or codes that is associated with that particular field in the database. The issue I'm having is if the value that is sotred in the db is something like Cases: 24 - 30 and a person types in 24 cases in the search field the query doesn't find anything. My query looks like: cfquery name=search datasource=ds Select someFields from someTable where searchField Like '%#form.search#%' /cfquery Now if you type 24 or 24 for example it will return the Cases: 24 - 30. I wanted to do either a verity or Full text search but the client doesn't want me to. Does anyone have any ideas on what I can do to get the query to find anything that matches what is typed in? Thanks, Ben ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183738 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: Regular Expression Help
Pascal, Would it be possible for you to explain a bit more about what each part of the RegEx is doing? I'm trying to do something similar and I'm having no end of trouble getting the RegEx right. MM documentation is pretty thin on more advanced matching. Thanks, Gavin -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: 05 November 2004 10:43 To: CF-Talk Subject: RE: Regular Expression Help REReplaceNoCase(text,'^.*input type=hidden name=BV_SessionID value=([^]*).*$',\1) Pascal -Original Message- From: Daniel Farmer [mailto:[EMAIL PROTECTED] Sent: 05 November 2004 10:24 To: CF-Talk Subject: Regular Expression Help I'm searching a long string and looking for the value input type=hidden name=BV_SessionID value=any value here what kind of syntax would I use to grab the value of the above tag. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183461 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: getting CF version, other details
cfoutput Level: #Server.ColdFusion.ProductLevel#br Name #Server.ColdFusion.ProductName#br Version #Server.ColdFusion.ProductVersion# /cfoutput Gives the following in CF5 for me: Level: Enterprise Name ColdFusion Server Version 5, 0, 0, 0 This definitely works for CF5 and up. Gavin -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: 03 November 2004 18:35 To: CF-Talk Subject: getting CF version, other details Isn't there a script that one can run to find this out when you don't have access to the administrator? I know that you can do this in other languages, but not sure for CF. I am working on a potential client, and would like to find this stuff out without having to ask. Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183342 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: MS SQL problem
The following will do what you need, although it is a little long-winded. -- Prepare blank list declare @list varchar(4000) set @list = '' -- Get SOFTWARE list for COMPANY select @list = @list + ',' + SOFTWARE.SOFTWARE_NAME fromSOFTWARE inner join COMPANY_SOFTWARES ON COMPANY_SOFTWARES.SOFTWARE_ID = SOFTWARE.SOFTWARE_ID where COMPANY_SOFTWARES.COMPANY_ID = 10 -- Removes Extraneous , at beginning select @list = substring( @list , 2, len( @list ) ) -- Final Returned Query select COMPANY.COMPANY_ID, COMPANY.COMPANY_name, @list as SOFTWARES fromCOMPANY where COMPANY_ID = 10 The other option is do it through ColdFusion as suggested, which may be a tidier way. Gavin -Original Message- From: Nurettin Omer Hamzaoglu [mailto:[EMAIL PROTECTED] Sent: 03 November 2004 10:29 To: CF-Talk Subject: MS SQL problem Hi all, I've 3 tables COMPANY, COMPANY_SOFTWARES, SOFWARES. COMPANY_SOFTWARES table holds the data of the softwares used in the companies like; ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183245 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: OT- SQL copy over
There is a couple of tools by Redgate Software that will do what you need. They are SQL Compare and SQL Data Compare. They will compare two SQL Server database and display a list of differences. You can then choose which items to synchronise. It even generates a script which you can archive. I've been using these tools for a nearly a year now and they are easy to use and save time. Gavin ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182906 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: asp 2 cfm help pleazzzzzzzzzzzz
Have you got any sample data? The lt makes me think less than symbol, maybe there is something in your data that is causing invalid XML?? Gav -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: 28 October 2004 10:11 To: CF-Talk Subject: asp 2 cfm help plea working on converting this page here is the asp code, mostly interested in the paging part %@ Language=VBScript % % Response.Buffer=True % % Dim GuestBookName dim GuestbookUrl Dim MailBox Dim Password1 Dim AllowUbbcode Dim ConnectionString Dim PageSize Dim AdminLogFlag IF Session(AdminLogged)1 THEN AdminLogFlag=0 ELSE AdminLogFlag=1 END IF 'default Ado Connection Object dim conn 'default ado recordset object dim rs PageSize=15 GuestBookName= BlueIdea.com AllowUbbCode=False ConnectionString=Driver=Microsoft Access Driver (*.mdb);dbq= Server.MapPath(Database/GuestBook.mdb) Dim i Dim intPageCount Dim intRecordCount Dim page if isempty(Request(Page)) then Page=1 else if isnumeric(request(page)) then on error resume next Page=clng(abs(Request(Page))) if err.number0 then Page=1 err.clear end if on error goto 0 else Page=1 end if end if Response.ContentType = text/xml Response.Expires = -1 Response.Write ?xml version='1.0' encoding='GB2312'? Response.Write threads Set con=Server.CreateObject(ADODB.Connection) con.Open ConnectionString Set rs=Server.CreateObject(ADODB.RecordSet) rs.Open select * from GuestBook order by postdatetime desc,con,3 intRecordCount=rs.RecordCount if not (rs.EOF and rs.BOF) then rs.PageSize=PageSize intPageCount=rs.PageCount if pageintPageCount then page=intPageCount end if rs.AbsolutePage=Page Response.Write PageCount=intPageCount RecordCount=intRecordCount AdminLog=AdminLogFlag for i=1 to pagesize if rs.EOF then exit for end if Response.Write message Response.Write subject Response.Write rs(subject) Response.Write /subject Response.Write number Response.Write rs(number) Response.Write /number Response.Write email Response.Write rs(email) Response.Write /email Response.Write url Response.Write rs(url) Response.Write /url Response.Write body![CDATA[ Response.Write rs(message) Response.Write ]]/body Response.Write sex Response.Write rs(sex) Response.Write /sex Response.Write reply![CDATA[ Response.Write rs(reply) Response.Write ]]/reply Response.Write icon Response.Write rs(icon) Response.Write /icon Response.Write posted Response.Write rs(postdatetime) Response.Write /posted Response.Write face Response.Write rs(face) Response.Write /face Response.Write username Response.Write rs(username) Response.Write /username Response.Write icq Response.Write rs(icq) Response.Write /icq Response.Write /message rs.MoveNext NEXT END IF rs.Close Set rs=nothing con.Close Set con=nothing Response.Write /threads % i have this so far, however i get this error and have no idea on it yet [quote] An error occured while Parsing an XML document. The reference to entity lt... must end with the ';' delimiter.[/quote] !--- get message list --- cfquery name=qGetXMLlist datasource=#dsn# username=#un# password=#pw# SELECT * FROM guestbook ORDER BY postdatetime desc /cfquery CFXML variable=messagesXML message cfoutput query=qGetXMLlist subject#subject#/subject number#number#/number email#email#/email url#url#/url body![CDATA[#message#]]/body sex#sex#/sex reply![CDATA[#reply#]]/reply icon#icon#/icon posted#postdatetime#/posted face#face#/face username#username#/username icq#icq#/icq br / /cfoutput /message /CFXML cffile action=write file=messages.xml output=#ToString(messagesXML)# ---
RE: AOL and spam filtering
I've recently had to go through the whole AOL white listing process. Our mail server was experiencing a temporary block at AOL's mail servers. I phoned AOL and they explained that this temporary block was due to the fact that a certain percentage of the mail we were sending was being reported as spam. They weren't sure of the exact threshold to trigger this block, and were cagey as to the reporting spam process. I went through the white list application, which was relatively painless. Your emails must conform to their standards, which basically means putting contact details on them, and clear instructions on how to be remove from the list. There also needs to be a reverse DNS entry for the mail server. To be sure of acceptance we made our newsletter conform to all of the requirements exactly and we were added to the white list. Part of this process is being added to a list which returns emails that have been reported as spam. Even with the white list status, I get around 5-10% reported as spam. We've even had end users complain that they've signed up for the email and haven't received it. I'm not sure how exactly the default spam setup on AOL works as these bounced emails seem to be random, as opposed to the same user bouncing the email back. We've got a list of around 50,000 subscribers to our newsletter, and the only trouble we have is with AOL. Our newsletter is written exactly as AOL requires, yet still some are being bounced back as spam from users, and they complain about not receiving them. You would think conforming to their standards meant that their default spam settings wouldn't reject your emails! Gavin ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182479 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: CFMX 6.1 Bug? WEB-INF directory showing up in my CF site.
I have seen the same thing on a windows installation. I ran the latest updater and it now places the cached class files into a web-inf directory in the webroot of my application. Mine root isn't called www either. Very weird. Gav -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: 05 October 2004 15:42 To: CF-Talk Subject: CFMX 6.1 Bug? WEB-INF directory showing up in my CF site. Looks like JRun dumps a WEB-INF directory (full of generated classes) inside www roots that happen to be named www. (Linux box.) Seems that this has been happening since the JRun CFMX updater that we ran on Aug 30. Can anyone shed light on this? Thanks, Jamie _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX 6.1 Bug? WEB-INF directory showing up in my CF site.
My setup seems to have permanently changed. Do you know where the configuration is to cause the CFC's to generate into the previous folder? -Original Message- From: Greg Stewart [mailto:[EMAIL PROTECTED] Sent: 05 October 2004 17:01 To: CF-Talk Subject: Re: CFMX 6.1 Bug? WEB-INF directory showing up in my CF site. Same problem at our end on Solaris. It looks like the updater has to re-compile all CFCs but somehow gets the location wrong and dumps them into the web root. We backed them up (just in case) and deleted them and they haven't come back since. On Tue, 5 Oct 2004 16:16:24 +0100, Gavin Brook [EMAIL PROTECTED] wrote: I have seen the same thing on a windows installation. I ran the latest updater and it now places the cached class files into a web-inf directory in the webroot of my application. Mine root isn't called www either. Very weird. Gav -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: 05 October 2004 15:42 To: CF-Talk Subject: CFMX 6.1 Bug? WEB-INF directory showing up in my CF site. Looks like JRun dumps a WEB-INF directory (full of generated classes) inside www roots that happen to be named www. (Linux box.) Seems that this has been happening since the JRun CFMX updater that we ran on Aug 30. Can anyone shed light on this? Thanks, Jamie _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Naïve Dual Processor Question
One thing to bear in mind is that upgrading to dual processors may affect software licences. For instance, SQL Server 2000 can be licensed on a per processor basis. It might be worth checking licences for software on the box prior to adding a second processor. With regards to that, if licences are fine, I'd recommend it. I added a second processor cheaply and I ended up with a dual P3 933 setup for a while, and it was pretty fast for all the applications I was building. Adding a second processor will improve performance, particularly if you've got a DB on there that makes use of them both, like SQL server. I was running Win2k, CFMX, SQL Server 2k on the one machine and I found a significant improvement across the board. Gav -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: 05 October 2004 16:50 To: CF-Talk Subject: Nave Dual Processor Question Our test server is a lowly Compaq ProLiant 1600 single processor 450 MHZ machine with 512 mb of RAM, which will soon be upgraded to it's max of 1 GB of RAM. The mobo is upgradable to dual processors, and the processors are pretty cheap for such a vintage machine. What kind of performance benefit can I expect from this upgrade in a typical intranet CF project with LOTS of queries? It is likely as simple as more is better, but I would like to understand the relationship if possible! OS is Win2k3 Server. Thanks Tim _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: application testing
I've recently evaluated the following packages to load test our application. Our main objectives were to choose something that allowed us to load and functionally test our CF, and Java, apps with an emphasis on low cost. Segue SilkPerformer Empirix E-Test OpenSTA Here's a very brief summary of what I found: SilkPerformer - very flexible package that requires some programming knowledge to alter the generated scripts. The main drawback for us was the cost, as it can run into several thousand pounds. This does have excellent analysis routines which makes getting some sense out of the resulting data very easy. I've used this at other companies in the past. E-Test Suite - this was my favourite. Very quick and easy to use. Setting up dynamic elements in the scripts could be easily accomplished. We had to create thousands of unique data elements to fully test our application and this allowed us to query an existing database and re-use those elements in the load testing. The cost can be less than SilkPerformer. OpenSTA - This is an open source package and consequently free. It did the job although the interface was a little rough around the edges. The results were also very rough. By rough I mean it was very difficult to actually interpret what they mean. There was only a few set graphs and these didn't make much sense on their own. On the plus side it did have a good concept whereby reusable objects are defined. For instance, you have to create probes to monitor certain elements and then create scripts. These were then combined to create test suites. I know this is only very brief and biased towards cost, but hopefully you'll find it useful. Incidentally, Empirix offered me an online session with one of their representatives to demonstrate the product. This proved very useful as I had some experience of testing with SilkPerformer. Gavin -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 31 August 2004 18:34 To: CF-Talk Subject: application testing Hello, It's been awhile since I've posted but this seems like a good time to = get some expert opinions.=20 I have been tasked with evaluating application testing software and = would like to get an idea what other CF developer's use. I'm primarily = interested in static, functional and regression testing, and some load = analysis would be helpful but not necessary. I'm looking at: Seapine's QA Wizard Parasoft's WebKing Empirix's E-Test Suite OpenDemand's OpenLoad We do a lot of extranet sites with multiple users and entitlements. Not = much in the way of public or high demand enterprise e-commerce sites. Any experiences, insights, or thread references are greatly appreciated. Thanks in advance, John Chase [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Second Pair Of Eyes
It also works fine on MX. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 31 August 2004 16:46 To: CF-Talk Subject: RE: Second Pair Of Eyes This works on CF5 cfset form.test = david cfscript function formValue(formName, defaultValue) { if (structKeyExists(FORM, formName) ) { return HTMLEditFormat(FORM[formName]); } else { return HTMLEditFormat(defaultValue); } } /cfscript cfdump var=#formValue(test,jimmy)#br / cfdump var=#formValue(test2,jimmy)# Arguments is an array rather than a structure -- dc _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: BLACKSTONE: Software Development Times Article
I've been following this thread and I wanted to share my thoughts... I've been developing for many years now and I'm a firm believer in using the right technology for the right job. Arguing about whether to use a Macromedia supplied tag or to write something in Java is a personal choice. If the Macromedia supplied tags will do the job and do it well, then that maybe that's the best route. If more advanced functionality is needed then then maybe Java, or other appropriate technology. Choosing the right technology depends on a number of factors, including available resources, money, time, skills,etc. Macromedia, New Atlanta, etc are in business to make money. The best way to do that is to sell products to as many people as possible. To do that these products have to appeal to as many people as possible. I agree with Doug. Macromedia, by building in higher level, easier to use features, they appeal to more high-end users. It should also be bore in mind that one of the key features of Blackstone is that there will be something for everyone. From the advanced developer who's been using ColdFusion or Java for years, down to the beginner who's just started writing applications. Personally I'm looking forward to trying Blackstone out. There's so many things I'd like to try, and from the very brief details around I can think of several uses for the features that have been mentioned. As to whether they will fit in with my applications, that will be seen when the full documentation or product is ready for testing. Gavin -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: 18 August 2004 15:49 To: CF-Talk Subject: Re: BLACKSTONE: Software Development Times Article I particularly like the feature in Blackstone of being able to incorporate PGP encryption for better security of personal information collected on e-commerce applications, but the document and reporting functionality is awesome as well. Event management is probably a feature set that I would rarely use, but I guess it does not hurt anything that it is available if wanted or needed. As for BD, I think the perception is that MM is mainly targeting the high end user, while the low end and middle is where most of us operate.For this area BD fills a vacant spot.. It does have most of the functionality we use from day to day, but it is not the end-all Of course, we all realize that not all web sites are requiring rich media, flash glitz, etc, and, in fact are much simpler in concept and layout.Of course, CSS is being more widely used, and that alone helps a lot with load times, and site appearance without having to copy and pase duplicate code all over the place. CSS makes it easier to completely change the appearance of a site making it very useful in development of multiople sites whose layout may be similar but still have an individually desinged look and feel. Many of the higher priority items which are so often overlooked is the ease of use, user friendly navigation throughout the site.When every site you visit have a different concept of navigation, use of popups, popunders, etc, seems to turn a lot of visitors off and shortens both their visit time but their visit frequency. I personally have much admiraton for the develoeprs who do the sites for music and artistic sites, because just like with their live performances flashy and glitzy is what it is all about.On the other hand, many web sites, just by their nature can be actually harmed by the addition of complicated flash, and weird navigation schemes, and even more admiration must be given tothe developer who can tell the difference and use it in theor approach to marketing their skills. == Our Anti-spam solution works!! http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com http://www.forta.com/cf/isp/isp.cfm?isp_id=1069 == - Original Message - From: Micha Schopman To: CF-Talk Sent: Wednesday, August 18, 2004 8:10 AM Subject: RE: BLACKSTONE: Software Development Times Article Personally, the moment BlueDragon came out I thought.. those guys actually give us what the community always wanted. BlueDragon just filled up that spot which has always been on the request list of many developers. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL Server admin/tuning
A free eBook I found quite useful can be found at http://www.realtimepublishers.com/ It's called The Definitive Guide to SQL Server Performance and Optimisation. It covers a lot of tuning aspects, including monitoring the server itself. Very useful stuff. -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: 16 August 2004 13:32 To: CF-Talk Subject: OT: SQL Server admin/tuning I was looking for a recommendation on a book that would give one a basis or better understanding of SQL server admin/performance tuning. I'm looking for a book that would be useful to someone with a working knowledge of SQL server from the queries/stored procedures/DTS package/table/db design standpoint, but looking to gain some more knowledge on the maintenance and admin of the server itself.Only admin type functions I have done are some scripts to truncate logs. Any recommendations? Thanks, Scott --- [This E-mail scanned for viruses by Declude Virus] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT: Win2k3 SP2 - Any Issues?
Hi All, Has anyone upgraded their CF servers to Win 2k3 SP2 yet? I've been tempted to install it but I thought I'd ask to see if anyone experienced any issues? Thanks Gavin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Win2k3 SP2 - Any Issues?
Thanks. Just had a quick look for a release date and late 2004 is all i could find. -Original Message- From: Gavin Brook [mailto:[EMAIL PROTECTED] Sent: 16 August 2004 18:10 To: CF-Talk Subject: SOT: Win2k3 SP2 - Any Issues? Hi All, Has anyone upgraded their CF servers to Win 2k3 SP2 yet? I've been tempted to install it but I thought I'd ask to see if anyone experienced any issues? Thanks Gavin _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
MX Performance Data
Hi All, Does anyone know if there is a way I can reset the performance data for ColdFusion MX 6.1? Not sure if there is an internal mechanism or it or if I need to call an external object. Any ideas?? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Quick Address/Postcode Lookup
I've integrated Allies PostCoder pro into our application. For this there was a COM object supplied with the package which I wrote a CFC wrapper for. This was then integrated into my Mach-II application. It took a few phone calls to the developers at Allies to get the relevant methods for the object. I also added a couple of my own functions to calculate distances, etc. I've not used QAS, but I guess there must be a COM object or something that could be leveraged. Gavin -Original Message- From: Dan Pacitti - ASP [mailto:[EMAIL PROTECTED] Sent: 05 August 2004 14:23 To: CF-Talk Subject: Quick Address/Postcode Lookup We are looking to intergrate some address lookup software (Quick address Pro http://www.qas.co.uk) into our application.Has anybody done this already? How easily can it be done?Could you please point me in the right direction for some help. Thanks DanP _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: trim numbers
If you know roughly the maximum price to be displayed you could use: NumberFormat(number,999,999,999) for 1 million dollars -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED] Sent: 05 August 2004 17:25 To: CF-Talk Subject: RE: trim numbers I usually use the following: replace(dollarformat(number), .00, , All) hope this helps Duane _ From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Thursday, August 05, 2004 12:14 PM To: CF-Talk Subject: trim numbers I need to trim numbers from a price. For example, I want the price displayed as $120 not $120.00 as it is now. Is the code for this using LTRIM? I need it to count how many characters then trim the last three so that $50.00 would look like $50 the same as $120.00 would look like $120. Robert O. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]