RE: CF Studio autocomplete
just curious, have you used the tag updater for CFMX yet? -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:47 PM To: CF-Talk Subject: CF Studio autocomplete Does anyone know which file dictates which tags have closing tags, and which tags display in the autocomplete dropdown as you are typing in Studio 5? I want the MX tags to autocomplete as well... -- Jon mailto:[EMAIL PROTECTED] __ 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: OT: pass a variable to a perl script using CF?
Use CFexecute and call... perl script.pl #username# On Wed, 31 Jul 2002, FlashGuy wrote: Hello, Is there a way to pass a variable to a perl script using CF? I need to pass the username which I dump into a variable when the user logs in via NT authentication to my perl script. This script is being run via a web interface which executes a bat file on the server. I the batch file I change directories and execute my perl script. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: CF and passing SQL commands through a form
In my oppinion this is the way to go: http://www.sys-con.com/coldfusion/article.cfm?id=398 -Original Message- From: Ryan Kime [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wednesday, July 31, 2002 3:22 PM Subject: RE: CF and passing SQL commands through a form Use cfqueryparam for validation purposes. I've seen docs on this, but can't remember where off the top of my head. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:07 PM To: CF-Talk Subject: CF and passing SQL commands through a form Do we have anything to worry about if someone enters a SQL command into a form field or URL? Like the form is collecting a users ID and passing the users ID to this action page: SELECT * FROM users WHERE user = #FORM.user# Can someone enter into the form field: 9; DROP TABLE users; Thus creating on the action side: SELECT * FROM users WHERE user = 9; DROP TABLE users; Has MM protected us from this kind of attack or do we have to protect ourselves with val().. etc...? __ 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: CF Studio autocomplete
Took the words right out of my mouth! In case you haven't found it yet... http://www.macromedia.com/software/coldfusionstudio/productinfo/resources/ta g_updaters/ -Cameron - Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 3:23 PM To: CF-Talk Subject: RE: CF Studio autocomplete just curious, have you used the tag updater for CFMX yet? -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:47 PM To: CF-Talk Subject: CF Studio autocomplete Does anyone know which file dictates which tags have closing tags, and which tags display in the autocomplete dropdown as you are typing in Studio 5? I want the MX tags to autocomplete as well... -- Jon mailto:[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
Re: CF and passing SQL commands through a form
Protect yourself. Depending on someone else will get you in trouble. On Wed, 31 Jul 2002, Chad Gray wrote: Do we have anything to worry about if someone enters a SQL command into a form field or URL? Like the form is collecting a users ID and passing the users ID to this action page: SELECT * FROM users WHERE user = #FORM.user# Can someone enter into the form field: 9; DROP TABLE users; Thus creating on the action side: SELECT * FROM users WHERE user = 9; DROP TABLE users; Has MM protected us from this kind of attack or do we have to protect ourselves with val().. etc...? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: CF and passing SQL commands through a form
At 02:11 PM 7/31/02 -0500, Ryan Kime wrote: Use cfqueryparam for validation purposes. I've seen docs on this, but can't remember where off the top of my head. Here's some: http://www.macromedia.com/desdev/articles/ben_forta_faster.htmlhttp://www.macromedia.com/desdev/articles/ben_forta_faster.html T __ 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: CF and passing SQL commands through a form
That's it, thanks Bryan. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:16 PM To: CF-Talk Subject: Re: CF and passing SQL commands through a form In my oppinion this is the way to go: http://www.sys-con.com/coldfusion/article.cfm?id=398 -Original Message- From: Ryan Kime [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wednesday, July 31, 2002 3:22 PM Subject: RE: CF and passing SQL commands through a form Use cfqueryparam for validation purposes. I've seen docs on this, but can't remember where off the top of my head. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:07 PM To: CF-Talk Subject: CF and passing SQL commands through a form Do we have anything to worry about if someone enters a SQL command into a form field or URL? Like the form is collecting a users ID and passing the users ID to this action page: SELECT * FROM users WHERE user = #FORM.user# Can someone enter into the form field: 9; DROP TABLE users; Thus creating on the action side: SELECT * FROM users WHERE user = 9; DROP TABLE users; Has MM protected us from this kind of attack or do we have to protect ourselves with val().. etc...? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: CF and passing SQL commands through a form
Your welcome -Original Message- From: Ryan Kime [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wednesday, July 31, 2002 3:35 PM Subject: RE: CF and passing SQL commands through a form That's it, thanks Bryan. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:16 PM To: CF-Talk Subject: Re: CF and passing SQL commands through a form In my oppinion this is the way to go: http://www.sys-con.com/coldfusion/article.cfm?id=398 -Original Message- From: Ryan Kime [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wednesday, July 31, 2002 3:22 PM Subject: RE: CF and passing SQL commands through a form Use cfqueryparam for validation purposes. I've seen docs on this, but can't remember where off the top of my head. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:07 PM To: CF-Talk Subject: CF and passing SQL commands through a form Do we have anything to worry about if someone enters a SQL command into a form field or URL? Like the form is collecting a users ID and passing the users ID to this action page: SELECT * FROM users WHERE user = #FORM.user# Can someone enter into the form field: 9; DROP TABLE users; Thus creating on the action side: SELECT * FROM users WHERE user = 9; DROP TABLE users; Has MM protected us from this kind of attack or do we have to protect ourselves with val().. etc...? __ 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
treating query/form as a structure/array
Seems like everytime I try to do this, I muck the syntax or can't quite find the exact documentation. How do you treat a query as a structure: cfquery ... name=test SELECT field1, field2 FROM myTable WHERE 0 = 0 /cfquery !--- these all return false --- cfoutput #isStruct(test)#br #isArray(test)#br brbr #isStruct(test['field1'])#br #isArray(test['field1'])#br /cfoutput Help much appreciated. Adam. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
CFMX, Access DSN and JDBCPool errors! Help!
Hello all! Here's the problem. Installed CFMX on a dev machine that runs CF5. All datasources were preserved but only the DSNs that point to our SQL Server verify correctly. All Access DSNs throw an error: []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Has anyone had a similar problem? Any help will be appreciated! Thanks- Dimo __ 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: CF Studio autocomplete
Doh, nevermind. What I was looking for was the tag completion and tag insight panels under settings. I never really looked at them :) Thanks though. -- Jon mailto:[EMAIL PROTECTED] Wednesday, July 31, 2002, 3:22:33 PM, you wrote: CT just curious, have you used the tag updater for CFMX yet? -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:47 PM To: CF-Talk Subject: CF Studio autocomplete Does anyone know which file dictates which tags have closing tags, and which tags display in the autocomplete dropdown as you are typing in Studio 5? I want the MX tags to autocomplete as well... -- Jon mailto:[EMAIL PROTECTED] CT __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: CFMX, Access DSN and JDBCPool errors! Help!
I have had the same problem but the other way around. All of the SQL dsn's failed. Still have yet to find out why. -Original Message- From: Dimo Michailov [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wednesday, July 31, 2002 3:42 PM Subject: CFMX, Access DSN and JDBCPool errors! Help! Hello all! Here's the problem. Installed CFMX on a dev machine that runs CF5. All datasources were preserved but only the DSNs that point to our SQL Server verify correctly. All Access DSNs throw an error: []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Has anyone had a similar problem? Any help will be appreciated! Thanks- Dimo __ 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 occasionally dropping emails - alternative
Hello all, CFMAIL after 3 years has finally showed that it occasionally drops emails. On an ordering system - even 1 email is not acceptable. What is the absolute simplest and fastest way to address this with an alternative? I am pretty busy and have no real time to invest in it at the moment and have to update a dozen or so sites. I appreciate any thoughts. Thanks, Jason __ 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: CfMail occasionally dropping emails - alternative
You might want to take a look at our CFMAIL replacement product, iMS-SE. You can install iMS-SE on the server for 60 days prior to purchase by installing with a serial number of DEMO. You can get additional information here: http://www.coolfusion.com/WhyiMS.cfm http://www.coolfusion.com/imssecomparison.cfm Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Jason Miller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 30, 2002 6:37 PM Subject: CfMail occasionally dropping emails - alternative Hello all, CFMAIL after 3 years has finally showed that it occasionally drops emails. On an ordering system - even 1 email is not acceptable. What is the absolute simplest and fastest way to address this with an alternative? I am pretty busy and have no real time to invest in it at the moment and have to update a dozen or so sites. I appreciate any thoughts. Thanks, Jason __ 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: CFMX, Access DSN and JDBCPool errors! Help!
It's funny that you ask that now, I just got off of the phone with a client asking her to verify that she got a test email that I sent her through a form on her dev site. And she did not get it, I checked the logs and the undeliverables and it was not in there also. I was wondering if this could be something like the problem Dimo is happening and if a product like cfdev.com's ActivMail could be an answer to Dimo and my problems. -Original Message- From: Dimo Michailov [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wednesday, July 31, 2002 3:42 PM Subject: CFMX, Access DSN and JDBCPool errors! Help! Hello all! Here's the problem. Installed CFMX on a dev machine that runs CF5. All datasources were preserved but only the DSNs that point to our SQL Server verify correctly. All Access DSNs throw an error: []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Has anyone had a similar problem? Any help will be appreciated! Thanks- Dimo __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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: CF 5 App crashing every 5 minutes...
Thanks all...It seems to work perfectly nowI will keep an eye out on it for a few hours. Again thanks for all the help. I love this list! == Joel Blanchette IT and System Specialist Point of Impact Technologies Inc. Tel: (204) 989-0013 Email: [EMAIL PROTECTED] == -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:13 PM To: CF-Talk Subject: Re: CF 5 App crashing every 5 minutes... What version of CF are you using? If you are using 5 then it will be under settings. As far as the time-out is concerned, I would set it to 30 and then in the templates that you are talking about, you can use requesttimeout= in your url variable. IE: http://www.yourserver.com?requesttimeout= Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Joel Blanchette [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 31, 2002 11:40 AM Subject: RE: CF 5 App crashing every 5 minutes... I have 1 cpu intel 850mhz I need the timeout high before some of our stats that go off at the middle of the night takes a while to finish. We are re-vamping the stats system right now. Hopefully this will be better in a couple of weeks. I will change it to 5... How to I enable strict attribute validation? == Joel Blanchette IT and System Specialist Point of Impact Technologies Inc. Tel: (204) 989-0013 Email: [EMAIL PROTECTED] == -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 1:20 PM To: CF-Talk Subject: Re: CF 5 App crashing every 5 minutes... Limit simultaneous requests to : 10 how many cpu's? Timeout requests after : 900 s Kinda high dont ya think? 30 - 60 maybe Restart at 10 unresponsive requests - I would make this like 5 Restart when requests terminate abnormally : on Suppress whitespace by default: on I would also enforce strict attribute validation. Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Joel Blanchette [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 31, 2002 11:07 AM Subject: RE: CF 5 App crashing every 5 minutes... Limit simultaneous requests to : 10 Timeout requests after : 900 s Restart at 10 unresponsive requests Restart when requests terminate abnormally : on Suppress whitespace by default: on Template cache size: 1024 kilobytes Anything else? Let me know where it would be in the menu and I will get it.. Thanks for the help == Joel Blanchette IT and System Specialist Point of Impact Technologies Inc. Tel: (204) 989-0013 Email: [EMAIL PROTECTED] == -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 12:17 PM To: CF-Talk Subject: Re: CF 5 App crashing every 5 minutes... What settings do you have in Admin? Max number of threads etc...Template caching? Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Joel Blanchette [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 31, 2002 10:07 AM Subject: CF 5 App crashing every 5 minutes... Hello All, I need big help.Last night, I saw that our server was going down, then I noticed that it was not the server but more that the cfserver.exe in the task manager was just stopping. If I restart the serveice it is all good. But I need to do this every 5 minutes...Which is not good...So I wrote a batch file that does it for me. I need to know why this error is happening. It seems like when the cfserver.exe gets around 25 megs or memory use it just stops responding. The task is still there but it will not respond. I'm using CF Server 5 on a Windows server 2000 SP2. Is there something in the threads that I should change? I can post the lines of the error logs of CF here but I need to know which ones u would need. I will need help. I did nothing to the server that would just start doing this. We are getting more traffic then before. Would that be the cause? If yes, there must be a way to fix this. == Joel Blanchette IT and System Specialist Point of Impact Technologies Inc. Tel: (204) 989-0013 Email: [EMAIL PROTECTED] == __ 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: Good CFCatch code
Assuming you're on CFMX? cfdump var=#cfcatch#/ will get you started... That'll work fine on CF 4.5.x on up. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: Good CFCatch code
cfdump isn't available on CF 4.5.x. -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 1:40 PM To: CF-Talk Subject: RE: Good CFCatch code Assuming you're on CFMX? cfdump var=#cfcatch#/ will get you started... That'll work fine on CF 4.5.x on up. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: OS X Web Services was Re: X-server?
On Wednesday, July 31, 2002, at 12:16 , Dick Applebaum wrote: Can anyone tell me/ point me to what is supposed to happen when you invove a web service. CFMX parses the WSDL and generates Java stub files. These are then compiled. The result allows CFMX to execute the Web Service (subsequent calls use the precompiled stubs). the Java files generated are in /opt/coldfusionmx/stubs/WS330149168/Net/xmethods/www are: BabelFishBindingStub.java BabelFishPortType.java BabelFishService.java BabelFishServiceLocator.java AFAIK, the only file missing is: BabelFishService.class However, I can't figure out who is responsible for generating the missing file -- or where to start looking. CFMX tries to compile these files but they don't compile. My sense is that the environment that CFMX uses to compile the stubs doesn't have the org.apache.* classes in it (I tried to javac the files by hand and it couldn't resolve those items). It *may* be as simple as changing some configuration file somewhere or it may require adding the appropriate .jar file to the classpath or something else. It's on my list of things to figure out... but it's down the list a page or two! Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ 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: Good CFCatch code
cfdump isn't available on CF 4.5.x. D'oh! But of course. I'd forgotten about using the cf_dump custom tag back then. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: CF 5 App crashing every 5 minutes...
Glad to be of service!! Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Joel Blanchette [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 31, 2002 1:32 PM Subject: RE: CF 5 App crashing every 5 minutes... Thanks all...It seems to work perfectly nowI will keep an eye out on it for a few hours. Again thanks for all the help. I love this list! == Joel Blanchette IT and System Specialist Point of Impact Technologies Inc. Tel: (204) 989-0013 Email: [EMAIL PROTECTED] == -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:13 PM To: CF-Talk Subject: Re: CF 5 App crashing every 5 minutes... What version of CF are you using? If you are using 5 then it will be under settings. As far as the time-out is concerned, I would set it to 30 and then in the templates that you are talking about, you can use requesttimeout= in your url variable. IE: http://www.yourserver.com?requesttimeout= Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Joel Blanchette [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 31, 2002 11:40 AM Subject: RE: CF 5 App crashing every 5 minutes... I have 1 cpu intel 850mhz I need the timeout high before some of our stats that go off at the middle of the night takes a while to finish. We are re-vamping the stats system right now. Hopefully this will be better in a couple of weeks. I will change it to 5... How to I enable strict attribute validation? == Joel Blanchette IT and System Specialist Point of Impact Technologies Inc. Tel: (204) 989-0013 Email: [EMAIL PROTECTED] == -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 1:20 PM To: CF-Talk Subject: Re: CF 5 App crashing every 5 minutes... Limit simultaneous requests to : 10 how many cpu's? Timeout requests after : 900 s Kinda high dont ya think? 30 - 60 maybe Restart at 10 unresponsive requests - I would make this like 5 Restart when requests terminate abnormally : on Suppress whitespace by default: on I would also enforce strict attribute validation. Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Joel Blanchette [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 31, 2002 11:07 AM Subject: RE: CF 5 App crashing every 5 minutes... Limit simultaneous requests to : 10 Timeout requests after : 900 s Restart at 10 unresponsive requests Restart when requests terminate abnormally : on Suppress whitespace by default: on Template cache size: 1024 kilobytes Anything else? Let me know where it would be in the menu and I will get it.. Thanks for the help == Joel Blanchette IT and System Specialist Point of Impact Technologies Inc. Tel: (204) 989-0013 Email: [EMAIL PROTECTED] == -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 12:17 PM To: CF-Talk Subject: Re: CF 5 App crashing every 5 minutes... What settings do you have in Admin? Max number of threads etc...Template caching? Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Joel Blanchette [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 31, 2002 10:07 AM Subject: CF 5 App crashing every 5 minutes... Hello All, I need big help.Last night, I saw that our server was going down, then I noticed that it was not the server but more that the cfserver.exe in the task manager was just stopping. If I restart the serveice it is all good. But I need to do this every 5 minutes...Which is not good...So I wrote a batch file that does it for me. I need to know why this error is happening. It seems like when the cfserver.exe gets around 25 megs or memory use it just stops responding. The task is still there but it will not respond. I'm using CF Server 5 on a Windows server 2000 SP2. Is there something in the threads that I should change? I can post the lines of the error logs of CF here but I need to know which ones u would need. I will need help. I did nothing to the server that would just start doing this. We are getting more traffic then before. Would that be the cause? If yes, there must be a way to fix this. == Joel Blanchette IT and System Specialist Point of Impact Technologies Inc.
Structure OR Array?
I have a large ugly query listing the threads in a message board. (each thread can have multiple articles) I have a separate function that stores a user profile for a member based on their username. In each article (post) the username defaults to their real username, but they can edit it and perhaps put someone else's username. I have the queries to find out the poster's real username, and then I can compare it to the main query's username to see if it's a fake. Of course these quries right now are in the output loop of the big ugly query. I'd like to loop over them and create a structure, or array to store the threadid and the REAL username of the poster BEFORE the main output. This way I could test for the real username of the poster while in the output loop without hitting the db. I'm using CF4.5 so I can't query a query. :-( And I think building a list would be rather crude. Could someone help get me started? Which is proper to use for this an array or structure? __ 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
Can you use cfqueryparam with an insert?
I try to use cfqueryparam for a little better performance(I'll be converting
to a stored proc in a bit).
I've used it with no prob for selects, but can you use it for an INSERT or
UPDATE statement?
After running the query below, the DB is storing an actual ? for the
values, rather than the actual values sent. The debug info shows the
correct values being sent.
cfquery name=qry_insertNew datasource=deersData dbtype=ODBC
INSERT INTO loginInfo (ssn, lastName, birthDate,
lastVerified)
Values ('cfqueryparam value=#attributes.SSN#
cfsqltype=CF_SQL_VARCHAR maxlength=50', 'cfqueryparam
value=#attributes.lastName# cfsqltype=CF_SQL_VARCHAR maxlength=50',
'cfqueryparam value=#attributes.birthdate# cfsqltype=CF_SQL_VARCHAR
maxlength=50', #CreateODBCDateTime(now())#)
/cfquery
DEBUG INFO:
qry_insertNew (Records=0, Time=16ms)
SQL =
INSERT INTO loginInfo (ssn, lastName, birthDate, lastVerified, hits)
Values ('?', '?', '?', {ts '2002-07-31 16:00:41'},
?)
Query Parameter Value(s) -
Parameter #1 = 123456789
Parameter #2 = Davis
Parameter #3 = 19430214
Parameter #4 = 1
__
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
cfargument and dot notaion
When calling a cfc method using the dot notation, the order of the arguments given to the method must match the order of the cfargument tags in the body of the method, unlike cfinvoke, where you have name value pairs. Example: cfset objEmailMan = createObject(component, emailman) cfset isDupe = objEmailMan.isDupe(trim(singleAddress),emailCategoryID) -- emailman.cfc -- cffunction name=isDupe returntype=boolean cfargument name=emailAddress required=Yes type=string cfargument name=emailCategoryID required=Yes type=numeric snip... Is this correct? It seems to be so, but I can't find anything anywhere that comes out and says it is the order that matters. -- Jon mailto:[EMAIL PROTECTED] __ 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: Can you use cfqueryparam with an insert?
Remove the quotes
- Original Message -
From: Smith, Matthew P -CONT(DYN) [EMAIL PROTECTED]
Date: Wednesday, July 31, 2002 3:03 pm
Subject: Can you use cfqueryparam with an insert?
I try to use cfqueryparam for a little better performance(I'll be
convertingto a stored proc in a bit).
I've used it with no prob for selects, but can you use it for an
INSERT or
UPDATE statement?
After running the query below, the DB is storing an actual ? for the
values, rather than the actual values sent. The debug info shows the
correct values being sent.
cfquery name=qry_insertNew datasource=deersData dbtype=ODBC
INSERT INTO loginInfo (ssn, lastName, birthDate,
lastVerified)
Values ('cfqueryparam value=#attributes.SSN#
cfsqltype=CF_SQL_VARCHAR maxlength=50', 'cfqueryparam
value=#attributes.lastName# cfsqltype=CF_SQL_VARCHAR
maxlength=50','cfqueryparam value=#attributes.birthdate#
cfsqltype=CF_SQL_VARCHARmaxlength=50',
#CreateODBCDateTime(now())#)/cfquery
DEBUG INFO:
qry_insertNew (Records=0, Time=16ms)
SQL =
INSERT INTO loginInfo (ssn, lastName, birthDate, lastVerified, hits)
Values ('?', '?', '?', {ts '2002-07-31
16:00:41'},
?)
Query Parameter Value(s) -
Parameter #1 = 123456789
Parameter #2 = Davis
Parameter #3 = 19430214
Parameter #4 = 1
__
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: Can you use cfqueryparam with an insert?
Thanks, worked like a charm.
Been using nothing but stored procs for awhile; forgot about that gotcha.
Matthew P. Smith
Web Developer, Object Oriented
Naval Education Training Professional
Development Technology Center
(NETPDTC)
(850)452-1001 ext. 1245
[EMAIL PROTECTED]
-Original Message-
From: Kelly Tetterton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 4:05 PM
To: [EMAIL PROTECTED]
Subject: RE: Can you use cfqueryparam with an insert?
Don't quote the cfqueryparam; ie do
Values(cfqueryparam value=#attributes.SSN#
cfsqltype=CF_SQL_VARCHAR maxlength=50,
rather than
Values('cfqueryparam value=#attributes.SSN#
cfsqltype=CF_SQL_VARCHAR maxlength=50',
-Original Message-
From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 4:03 PM
To: CF-Talk
Subject: Can you use cfqueryparam with an insert?
I try to use cfqueryparam for a little better performance(I'll be
converting
to a stored proc in a bit).
I've used it with no prob for selects, but can you use it for an INSERT or
UPDATE statement?
After running the query below, the DB is storing an actual ? for the
values, rather than the actual values sent. The debug info shows the
correct values being sent.
cfquery name=qry_insertNew datasource=deersData dbtype=ODBC
INSERT INTO loginInfo (ssn, lastName, birthDate,
lastVerified)
Values ('cfqueryparam value=#attributes.SSN#
cfsqltype=CF_SQL_VARCHAR maxlength=50', 'cfqueryparam
value=#attributes.lastName# cfsqltype=CF_SQL_VARCHAR maxlength=50',
'cfqueryparam value=#attributes.birthdate# cfsqltype=CF_SQL_VARCHAR
maxlength=50', #CreateODBCDateTime(now())#)
/cfquery
DEBUG INFO:
qry_insertNew (Records=0, Time=16ms)
SQL =
INSERT INTO loginInfo (ssn, lastName, birthDate, lastVerified, hits)
Values ('?', '?', '?', {ts '2002-07-31 16:00:41'},
?)
Query Parameter Value(s) -
Parameter #1 = 123456789
Parameter #2 = Davis
Parameter #3 = 19430214
Parameter #4 = 1
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.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
CFMX distributed mode and local Jrun conflict?
I've been developing on CFMX in distributed mode for a few weeks now, and haven't had any problems at all. I had CFMX on a development app server, with the built-in web server turned off, and was using a development IIS server as the web server, configured with the CFMX connector. Everything was working great. The problem is that the web server that I was using is the development web server for our entire organization. Our admins had a need to install some other software for another team. They installed Brio on this web server, which actually has an embedded version of JRun (version 2.2.3) that installs with it. Well, as you might imagine, when they got that software installed, my CFMX app stopped working. I'm now getting a 404 error - The page cannot be found. For some reason or other, I have no idea why, the connector doesn't seem to be working at all now. I'm fairly certain it has something to do with the fact that there is now a conflicting version of JRun on the web that is causing the problems that we're having with the connector, but I have absolutely no idea how to fix it. What we've done so far was to completely shut down the new JRun service that's running. We re-ran the connector script (executed the wsconfig.jar file) and it told us that the server was already configured. So, we uninstalled it successfully, and then ran it again, to get a fresh installation of it. That ran successfully. Still no go. We checked the settings in the wsconfig.properties file, and those all seemed to be correct. Still nothing. I'm kind of stuck. I really don't feel like an uninstall and reinstall of CFMX would do any good, since it's running on a totally different server and everything. It would appear that it's simply a problem with the connector, or some sort of conflict with this new (old version) JRun server that's on this web server.! Has anyone else run into this yet? Does anyone have any ideas of how we could get this fixed and up and running again? Thanks in advance. ::YEX:: /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf __ 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: SSL on form submission
Chad, In a previous thread in a different mailing list Lynn Taylor concisely described the SLL process as it relates to IP and IP-less domains. It so accurately described the process I saved it for posterity. [From a discussion with Lynn W. Taylor [EMAIL PROTECTED]]= Certificates are bound to domain names, no question. SSL connections are negotiated by IP address, before the domain name is passed. So, the TCP SYN packet comes in, the SYN+ACK goes back, the ACK comes in, and then SSL encryption starts. After the encryption is started, it checks the domain name on the certificate. So it stands to reason that you can put a certificate on any IP, and you can change the IP -- you just can't have more than one certificate on a single IP address+Port number. Note that this is true on any OS and any web server. ==[ end discussion ]== So in your example (http://www/form.cfm) the data passed from the server to the browser is NOT encrypted since you did not negotiate for a secure connection and the browser will not indicate that it is secure. If there is nothing in the data used to display the form that needs to be secure then it is technically OK, however, the user cannot tell if the data he is entering will be sent back via a secure connection unless he looks at the form code. Best regards, Dennis Powers UXB Internet - A Web Design and Hosting Company tel: (203)879-2844 fax: (203)879-6254 http://www.uxbinternet.com/ http://dennis.uxb.net/ -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 10:56 AM To: CF-Talk Subject: SSL on form submission Im wondering if when a form is submitted at what point do you request SSL? Do you want the form to be covered under SSL as the user is filling it out? https://www/form.cfm Or do you leave the form http://www/form.cfm and use form action=https://www/action.cfm; method=POST enough to encrypt the data being passed to the action page? Just curious __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: cfargument and dot notaion
Yes, the order of args must match the order of cfarg tags. Unless... You use the new name/value pair notation, which works w/ UDFs as well: cfset x = myUDForCFCMethod(arg=1,arg2=2,arg4=4,arg3=3) === Raymond Camden, ColdFusion Jedi Master for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 5:07 PM To: CF-Talk Subject: cfargument and dot notaion When calling a cfc method using the dot notation, the order of the arguments given to the method must match the order of the cfargument tags in the body of the method, unlike cfinvoke, where you have name value pairs. Example: cfset objEmailMan = createObject(component, emailman) cfset isDupe = objEmailMan.isDupe(trim(singleAddress),emailCategoryID) -- emailman.cfc -- cffunction name=isDupe returntype=boolean cfargument name=emailAddress required=Yes type=string cfargument name=emailCategoryID required=Yes type=numeric snip... Is this correct? It seems to be so, but I can't find anything anywhere that comes out and says it is the order that matters. -- Jon mailto:[EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: OS X Web Services was Re: X-server?
On Wednesday, July 31, 2002, at 01:38 PM, Sean A Corfield wrote: CFMX tries to compile these files but they don't compile. My sense is that the environment that CFMX uses to compile the stubs doesn't have the org.apache.* classes in it (I tried to javac the files by hand and it couldn't resolve those items). I searched the Linux install for org.apache and found nothing. Could it be that CFMX assumes that Apache, and the required classes, are pre-installed (not part of the CFMX install)? Would that also mean that consuming web services is *Not* supported with the CFMX Default web server? Do you know what ckasses are required and where I can get them? Aren't I persistent? TIA Dick It *may* be as simple as changing some configuration file somewhere or it may require adding the appropriate .jar file to the classpath or something else. It's on my list of things to figure out... but it's down the list a page or two! Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ 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: CF and SQL
If you DB supports it, use if exists [query] the presence of the exists directive will cause the query to stop processing as soon as it has a match. This can save time if you are querying an unindexed table or there are multiple results. Justin -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:23 PM To: CF-Talk Subject: CF and SQL Ok, I am interested in peoples opinions on the following: Is it best practice to check for a records existence before attempting to update it? And what would the best way to go about that be? Michael Tangorre __ 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: OS X Web Services was Re: X-server?
On Wednesday, July 31, 2002, at 02:14 , Dick Applebaum wrote: Could it be that CFMX assumes that Apache, and the required classes, are pre-installed (not part of the CFMX install)? No, it's the Axis code and it's buried somewhere in one of the .jar files installed with CFMX. Would that also mean that consuming web services is *Not* supported with the CFMX Default web server? Huh? The web server has nothing to do with consuming web services. Do you know what ckasses are required and where I can get them? See above. I'm off to the doctor but I'll make a concerted effort to figure this out when I get back OK? Aren't I persistent? It's part of your charm... Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ 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: CFMX, Access DSN and JDBCPool errors! Help!
I have had the same problem but the other way around. All of the SQL dsn's failed. Still have yet to find out why. If you have access to the sql server admin features, I'd your using to connect to sql server. I'm wondering too if you used the cf migration wizard after co-exist install? -Craig __ 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: OS X Web Services was Re: X-server?
All of the Web services stuff is in webservices.jar. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:14 PM To: CF-Talk Subject: Re: OS X Web Services was Re: X-server? On Wednesday, July 31, 2002, at 01:38 PM, Sean A Corfield wrote: CFMX tries to compile these files but they don't compile. My sense is that the environment that CFMX uses to compile the stubs doesn't have the org.apache.* classes in it (I tried to javac the files by hand and it couldn't resolve those items). I searched the Linux install for org.apache and found nothing. Could it be that CFMX assumes that Apache, and the required classes, are pre-installed (not part of the CFMX install)? Would that also mean that consuming web services is *Not* supported with the CFMX Default web server? Do you know what ckasses are required and where I can get them? Aren't I persistent? TIA Dick It *may* be as simple as changing some configuration file somewhere or it may require adding the appropriate .jar file to the classpath or something else. It's on my list of things to figure out... but it's down the list a page or two! Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ 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
CFMX - Linux - DB2 AS/400
Has anyone had any luck connecting MX/Linux to a AS/400 running DB2 without DB2Connect? If so, please elighten :) Thanks Paul Giesenhagen QuillDesign __ 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: CFMX, Access DSN and JDBCPool errors! Help!
I did -Original Message- From: Craig Thomas [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wednesday, July 31, 2002 5:32 PM Subject: RE: CFMX, Access DSN and JDBCPool errors! Help! I have had the same problem but the other way around. All of the SQL dsn's failed. Still have yet to find out why. If you have access to the sql server admin features, I'd your using to connect to sql server. I'm wondering too if you used the cf migration wizard after co-exist install? -Craig __ 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: CFMX, Access DSN and JDBCPool errors! Help!
Did you try this, from the release notes: (Windows only) You must provide a username for Microsoft Access and ODBC Socket Data Source Names (DSNs), even if the data sources do not require any user authentication. Provide a username as follows: Access DSN-Select the Use Default Username option; OR show the Advanced Settings section and enter a username in the ColdFusion Username field. ODBC Socket DSN-Select the Use Trusted Connection option; OR show the Advanced Settings section and, in the Username field, accept the default username (system) or enter a username. Deb -Original Message- From: Dimo Michailov [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 3:33 PM To: CF-Talk Subject: CFMX, Access DSN and JDBCPool errors! Help! Hello all! Here's the problem. Installed CFMX on a dev machine that runs CF5. All datasources were preserved but only the DSNs that point to our SQL Server verify correctly. All Access DSNs throw an error: []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Has anyone had a similar problem? Any help will be appreciated! Thanks- Dimo __ 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
cfmx client vars as cookies do not persist.
We're not happy about this one. heres a thread as a heads up to anyone thinking about migrating. http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=7threadid= 384991highlight_key=ykeyword1=cfmxkeyword2=client%20variables Any ideas to circumvent this? Move to db storage of client vars I guess.. __ 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
Proper way to catch a connection failure for cfhttp
A couple of questions... There is a url I am calling, which allows us to validate a user against the DEERS db(military thing). I am sending it a few url params through cfhttp. Does this classify it as a web service? It returns a string, not an XML document, does that matter? Also, what is the proper way to trap (ie cftry/cfcatch style) a failed cfhttp call? The service tends to be iffy, so: If the user is verified, I return a 1 If the user verification fails, I return 0 If the cfhttp call fails, I want to return -1 Currently, I am doing this: cfhttp url=https://foo.com; cfhttpparam type=URL name=RULE value=foo /cfhttp cfif cfhttp.fileContent eq Connection Failure cfoutput-1/cfoutput cfabort /cfif Is this the correct way to trap it? Or is there a cfcatch type=something that would be better? Thanks for the help. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [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
Re: Good CFCatch code
On Wednesday, July 31, 2002, at 11:03 , Neil H. wrote: Anyone have a snippet of code that would show all the information available when an error occurs? I am looking for something like what CF displays if I wasn't using the catch but I will email it to me when it does :) Assuming you're on CFMX? cfdump var=#cfcatch#/ will get you started... .. you left out a on the end of the attribute, but ... why assuming CFMX? This works beautifully on CF 5 -- minus the trailing / since CF 5 and before weren't technically xml languages. Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ 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: HELP!!
If this is in an onChange you use this.options[this.selectedIndex].text otherwise document.forms[yourformname].yourselectbox.options[document.fo rms[yourformname].yourselectbox.selectedIndex].text Yea, that's always seemed like a lot of typing to me... which was why I tended to do something like this: var s = document.myform.myselectbox; s.options[s.selectedIndex].text; Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ 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: CF and SQL
I am interested in peoples opinions on the following: Is it best practice to check for a records existence before attempting to update it? And what would the best way to go about that be? Depends heavily on the application ... The database as a general rule doesn't care if a given record doesn't exist when you execute an update statement, so if the record doesn't exist, the worst that will happen is nothing -- which may be worse than an error. :) Though I can't think of a single occasion on which I actually manually verified that the row existed prior to updating it... though if you use a stored procedure, you could simply use a select statement following the update statement which would retrieve all the data from the updated row using the same identifying input variable, that way if the result set returned to CF has a recordcount of 0 you know that nothing was updated and maybe you've got a problem. Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Good CFCatch code
This works beautifully on CF 5 -- minus the trailing / since CF 5 and before weren't technically xml languages. Actually, though, you can still use the trailing slash with many tags (perhaps all, for all I know) in CF 4.x and higher. This is actually done quite a bit, when calling nested custom tag sets using CFMODULE, and with nested CFTRANSACTION tags for partial commits and rollbacks. Also, I don't think that CFML is an XML language even in CF MX in any meaningful sense, although I guess you can generally follow XML syntactical rules when writing tags. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: CFMX, Access DSN and JDBCPool errors! Help!
I did What does the error message /log file say? -Craig __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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: cfmx client vars as cookies do not persist.
And it appears they aren't persisting even when set to store in the db. This totally sucks. I'm really really really really really disappointed with mm. -Original Message- From: Brian J. LeRoux [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:39 PM To: CF-Talk Subject: cfmx client vars as cookies do not persist. We're not happy about this one. heres a thread as a heads up to anyone thinking about migrating. http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=7 threadid= 384991highlight_key=ykeyword1=cfmxkeyword2=client%20variables Any ideas to circumvent this? Move to db storage of client vars I guess.. __ 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: treating query/form as a structure/array
Seems like everytime I try to do this, I muck the syntax or can't quite find the exact documentation. How do you treat a query as a structure: cfquery ... name=test SELECT field1, field2 FROM myTable WHERE 0 = 0 /cfquery !--- these all return false --- cfoutput #isStruct(test)#br #isArray(test)#br brbr #isStruct(test['field1'])#br #isArray(test['field1'])#br /cfoutput Hmm... Well... The array functions can be used on query columns, although I don't think IsArray() would work, or for that matter isStruct()... If you declare isStruct(queryname) or isArray(queryname) they're going to be false because you're passing them a query. If you delcare isArray(queryname['columnname']) it's going to return false because it's going to evaluate the _value_ contained in the first row of that column of that query, which is going to be a string rather than an array... Is there a particular reason you need to get the isarray information from a query column? or can you just use the other array functions to get what you need? The easiest way to actually create an array is to use ListToArray(ValueList(myquery.mycolumn)) if necessary... I wouldn't expect there to be much in the way of documentation on this issue specifically ... There's documentation on each of the functions and on queries of course, but I wouldn't expect any of that documentation to cover this explicitely... Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Good CFCatch code
Aside from the more obscure aspects of XML, it would be difficult to write cfifcfelseifcfelse/cfif and make it look like XML I should think -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 August 2002 10:03 a.m. To: CF-Talk Subject: RE: Good CFCatch code This works beautifully on CF 5 -- minus the trailing / since CF 5 and before weren't technically xml languages. Actually, though, you can still use the trailing slash with many tags (perhaps all, for all I know) in CF 4.x and higher. This is actually done quite a bit, when calling nested custom tag sets using CFMODULE, and with nested CFTRANSACTION tags for partial commits and rollbacks. Also, I don't think that CFML is an XML language even in CF MX in any meaningful sense, although I guess you can generally follow XML syntactical rules when writing tags. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: Good CFCatch code
-- Jon mailto:[EMAIL PROTECTED] Wednesday, July 31, 2002, 6:24:24 PM, you wrote: MW Aside from the more obscure aspects of XML, it would be difficult to MW write cfifcfelseifcfelse/cfif and make it look like XML I should MW think -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 August 2002 10:03 a.m. To: CF-Talk Subject: RE: Good CFCatch code This works beautifully on CF 5 -- minus the trailing / since CF 5 and before weren't technically xml languages. Actually, though, you can still use the trailing slash with many tags (perhaps all, for all I know) in CF 4.x and higher. This is actually done quite a bit, when calling nested custom tag sets using CFMODULE, and with nested CFTRANSACTION tags for partial commits and rollbacks. Also, I don't think that CFML is an XML language even in CF MX in any meaningful sense, although I guess you can generally follow XML syntactical rules when writing tags. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 MW __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
SQL GetDate()
Okay, the default value field in SQL 7 for date/time is what? I put GetDate() in there to save CF processing and query time...so when I submit a form the data gets inserted, I just want SQL to put in the current date by default. I get an error using GetDate() though. Any quick duh help? Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Good CFCatch code
cfif block's looks a lot like xslt...I imagine it wouldn't be hard to rewrite quite a bit of the CF engine on top of an xml/xslt parser. xsl:if test=2 gt; 1 tdduh! :)/td /xsl:if Sorry for the blank message...damn buttons. -- Jon mailto:[EMAIL PROTECTED] Wednesday, July 31, 2002, 6:24:24 PM, you wrote: MW Aside from the more obscure aspects of XML, it would be difficult to MW write cfifcfelseifcfelse/cfif and make it look like XML I should MW think -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 August 2002 10:03 a.m. To: CF-Talk Subject: RE: Good CFCatch code This works beautifully on CF 5 -- minus the trailing / since CF 5 and before weren't technically xml languages. Actually, though, you can still use the trailing slash with many tags (perhaps all, for all I know) in CF 4.x and higher. This is actually done quite a bit, when calling nested custom tag sets using CFMODULE, and with nested CFTRANSACTION tags for partial commits and rollbacks. Also, I don't think that CFML is an XML language even in CF MX in any meaningful sense, although I guess you can generally follow XML syntactical rules when writing tags. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 MW __ 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: SQL GetDate()
Either define the default value for the field as getDate(), or use
getDate() in your insert query.
ex:
cfquery ...
INSERT INTO Table (Foo, Bar, DateField)
VALUES ('somedata', 42, getDate())
/cfquery
If you defined getDate() as the field default in ent manager, then
just leave the datefield stuff out of the query. SQL will fill in the
field with it's default value.
ex:
cfquery ...
INSERT INTO Table (Foo, Bar)
VALUES ('somedata', 42)
/cfquery
--
Jon
mailto:[EMAIL PROTECTED]
Wednesday, July 31, 2002, 6:35:31 PM, you wrote:
EH Okay, the default value field in SQL 7 for date/time is what? I put
EH GetDate() in there to save CF processing and query time...so when I
EH submit a form the data gets inserted, I just want SQL to put in the
EH current date by default. I get an error using GetDate() though.
EH Any quick duh help?
EH Regards,
__
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: SQL GetDate()
I did exactly that...defined in Ent Man as GetDate(), left it blank in
the insert statement, but get this error:
DIAGNOSTIC:
ODBC Error Code = 22008 (Datetime field overflow)
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting
datetime from character string.
Regards,
Eric J Hoffman
DataStream Connexion
www.datastreamconnexion.com
Delivering Creative Data Solutions
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 5:53 PM
To: CF-Talk
Subject: Re: SQL GetDate()
Either define the default value for the field as getDate(), or use
getDate() in your insert query.
ex:
cfquery ...
INSERT INTO Table (Foo, Bar, DateField)
VALUES ('somedata', 42, getDate())
/cfquery
If you defined getDate() as the field default in ent manager, then just
leave the datefield stuff out of the query. SQL will fill in the field
with it's default value.
ex:
cfquery ...
INSERT INTO Table (Foo, Bar)
VALUES ('somedata', 42)
/cfquery
--
Jon
mailto:[EMAIL PROTECTED]
Wednesday, July 31, 2002, 6:35:31 PM, you wrote:
EH Okay, the default value field in SQL 7 for date/time is what? I put
EH GetDate() in there to save CF processing and query time...so when I
EH submit a form the data gets inserted, I just want SQL to put in the
EH current date by default. I get an error using GetDate() though.
EH Any quick duh help?
EH Regards,
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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 GetDate()
If the field is a datetime field, then either the data is out of
range, or it is invalid. The clock on the server isn't off is it? :)
Try doing the query in query analyzer and see what happens.
--
Jon
mailto:[EMAIL PROTECTED]
Wednesday, July 31, 2002, 6:58:38 PM, you wrote:
EH I did exactly that...defined in Ent Man as GetDate(), left it blank in
EH the insert statement, but get this error:
EH DIAGNOSTIC:
EH ODBC Error Code = 22008 (Datetime field overflow)
EH [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting
EH datetime from character string.
EH Regards,
EH Eric J Hoffman
EH DataStream Connexion
EH www.datastreamconnexion.com
EH Delivering Creative Data Solutions
EH -Original Message-
EH From: Jon Hall [mailto:[EMAIL PROTECTED]]
EH Sent: Wednesday, July 31, 2002 5:53 PM
EH To: CF-Talk
EH Subject: Re: SQL GetDate()
EH Either define the default value for the field as getDate(), or use
EH getDate() in your insert query.
EH ex:
EH cfquery ...
EH INSERT INTO Table (Foo, Bar, DateField)
EH VALUES ('somedata', 42, getDate())
EH /cfquery
EH If you defined getDate() as the field default in ent manager, then just
EH leave the datefield stuff out of the query. SQL will fill in the field
EH with it's default value.
EH ex:
EH cfquery ...
EH INSERT INTO Table (Foo, Bar)
EH VALUES ('somedata', 42)
EH /cfquery
__
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: OS X Web Services was Re: X-server?
On Wednesday, July 31, 2002, at 02:20 PM, Matt Liotta wrote:
All of the Web services stuff is in webservices.jar.
OK, I made webservices.jar accessable to Mac OS X JVM with a quick fix
that works for the jdbc drivers-- putting a copy in
/Library/Java/Extensions *
I also put a copy of java2wsdl.jar and wsdl2java.jar in the same folder.
This still fails, but the nature of the error has changed (below)
* when I first started porting CFMX to OS X, Jesse Noller said I should
look in /runtime/bin/jvm.config
for clue to how the java classpath parameters should be changed to
reflect that we were using the Mac OSX JVM not the one installed by
CFMX. This was pretty hard from my perspective -- I didn't have the
java source, so I was reverse engineering (in a foreign language). I
changed the parameters as best I could determine (not being a Java
person) to no avail -- these didn't solve the problem I was having at
the tine (not finding the pointbase jdbc driver)
By accident, I stumbled on another driver (not CFMX) in the
/Library/Java/Extensions folder -- I copied the pointbase driver there,
and Voila!, it worked (CFMX forund it).
One thing always bothered me about the jvm.config file -- the
# JVM classpath
java.class.path={application.home}/runtime/../../src,{application.home}/lib/
cfusion.jar,{application.home}/runtime/pointbase/lib/pbclient42RE.jar,
{application.home}/runtime/pointbase/lib/pbembedded42RE.jar,{application.home}
/runtime/pointbase/lib/pbserver42RE.jar,{application.home}/runtime/pointbase/
lib/pbtools42RE.jar,{application.home}/runtime/lib/webservices.jar
As near as I could figure {application.home} should be /opt/coldfusionmx
But, the first path didn't make any sense
{application.home}/runtime/../../src as there was no src folder 2
levels above /runtime/ in the Linux install
When I started having problems with WS compilation, I remembered this --
don't know if it is related or not!
Sure is tedious doing this with a blindfold -- seems as though the right
person, with knowledge of what is supposed to happen and how all the
pieces fit together, would have the necessary info at his fingertips.
As-Is, I've been fiddling with this for about a week.
Anyway here is the failure with the repositioned jar files:
Dick
P.S. I also found some Axis docs among the CFMX docs am reviewing them
now!
Error Occurred While Processing Request
com/techtrader/modules/tools/bytecode/BCEntity
Â
The Error Occurred in /opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm: line
10
8 : cfinvokeargument
9 : name=sourcedata value=Hello world, friend
10 : /cfinvoke
11 : cfoutput#varName#/cfoutput
12 :
Please Try The Following:
* Check the CFML Reference Manual to verify that you are using the
correct syntax.
* Search the Knowledge Base to find a solution to your problem.
Browser  Mozilla/4.0 (compatible; MSIE 5.14; Mac_PowerPC)
Remote Address  127.0.0.1
Referer  http://127.0.0.1:8500/mycfmxapps/
Date/Time  31-Jul-02 02:59 PM
Stack Trace (click to expand)
at
cfWS12ecfm1726113412.runPage(/opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm:
10) at
cfWS12ecfm1726113412.runPage(/opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm:
10)
java.lang.NoClassDefFoundError:
com/techtrader/modules/tools/bytecode/BCEntity
at org.apache.axis.wsdl.toJava.Emitter.(Emitter.java:533)
at coldfusion.xml.rpc.XmlRpcServiceImpl.registerWebService(Unknown
Source)
at coldfusion.xml.rpc.XmlRpcServiceImpl.registerWebService(Unknown
Source)
at coldfusion.xml.rpc.XmlRpcServiceImpl.getWebService(Unknown Source)
at coldfusion.xml.rpc.XmlRpcServiceImpl.getWebServiceProxy(Unknown
Source)
at coldfusion.tagext.lang.InvokeTag.doEndTag(Unknown Source)
at
cfWS12ecfm1726113412.runPage(/opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm:
10)
at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
at coldfusion.filter.ApplicationFilter.invoke(Unknown Source)
at coldfusion.filter.PathFilter.invoke(Unknown Source)
at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown
Source)
at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
at coldfusion.CfmServlet.service(Unknown Source)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)
at
what scope are the variables in when a template is called via cfh ttp?
I have a template that I am calling via cfhttp. How do I access the variables being passed to it? I am passing them via cfhttpparam type=URL name=foo valuefoo. In the called template, though, referencing url.foo throws an error. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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: OS X Web Services was Re: X-server?
java.lang.NoClassDefFoundError: com/techtrader/modules/tools/bytecode/BCEntity Looks like your classpath is still wrong as the above error means that the JVM can't find the class com.techtrader.modules.tools.bytecode.BCEntity. You should verify that that class is in the classpath and/or even exists. -Matt __ 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: what scope are the variables in when a template is called via cfh ttp?
Local - to within the page request. The requested page is then returned via the CFHTTP.FileContent (hope I got that right) variable. This variable is then local to your calling page. The Called page, is fully rendered at this time, and you are dealing with the resulting HTML. Shawn Grover -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 5:38 PM To: CF-Talk Subject: what scope are the variables in when a template is called via cfh ttp? I have a template that I am calling via cfhttp. How do I access the variables being passed to it? I am passing them via cfhttpparam type=URL name=foo valuefoo. In the called template, though, referencing url.foo throws an error. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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 GetDate()
I did exactly that...defined in Ent Man as GetDate(), left it blank in the insert statement, but get this error: DIAGNOSTIC: ODBC Error Code = 22008 (Datetime field overflow) [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from character string. My first guess would be that there is a space-character at the beginning of your default definition, i.e. GETDATE() ... Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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: CF MX performance issue
CF 5MX JRE 1.3MX JRE 1.4 9 KB405060 24 KB 240 3300 7000 84 KB 670013174000 ah that would explain my sucky numbers for cfmx. ah, let them eat i18n cake ;-) --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.380 / Virus Database: 213 - Release Date: 24/7/2545 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: what scope are the variables in when a template is called via cfh ttp?
Thanks, Shawn. Been working this all day, and my brain is starting to get a bit foggy. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 6:46 PM To: CF-Talk Subject: RE: what scope are the variables in when a template is called via cfh ttp? Local - to within the page request. The requested page is then returned via the CFHTTP.FileContent (hope I got that right) variable. This variable is then local to your calling page. The Called page, is fully rendered at this time, and you are dealing with the resulting HTML. Shawn Grover -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 5:38 PM To: CF-Talk Subject: what scope are the variables in when a template is called via cfh ttp? I have a template that I am calling via cfhttp. How do I access the variables being passed to it? I am passing them via cfhttpparam type=URL name=foo valuefoo. In the called template, though, referencing url.foo throws an error. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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: OS X Web Services was Re: X-server?
Thanks Matt There is no com nor techtrader nor BCEntity anywhere within the Linux install (either as a filename or in the content of any file) -- I ported everything across as installed. Is the above part of the CFMX Linux install? If not where do I get it? TIA Dick On Wednesday, July 31, 2002, at 04:37 PM, Matt Liotta wrote: java.lang.NoClassDefFoundError: com/techtrader/modules/tools/bytecode/BCEntity Looks like your classpath is still wrong as the above error means that the JVM can't find the class com.techtrader.modules.tools.bytecode.BCEntity. You should verify that that class is in the classpath and/or even exists. -Matt __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
creating tables on the fly? Should I or Shouldn't I?
I posted this before, but got no response. Does any one know if this is sound/standard practice and if it makes any sense in this context? Just a nudge in the right direction in all I need. Thanks! - I am designing an email application that will be used by multiple (100's - 1000's) of users. Each user will have their own account. When they send mail, the recipients are recorded to a table. this table is basically just a reference to the full recipient record and the email campaign id. If each user is sending email campaigns of 25,000 recipients + what is the best way to record and later generate reports on this data. Would it make sense to generate a campaign recipient table on the fly for each user of the system upon registration or first use? This way the total records per table would be a bit more manageable for report generation later. Is this sound practice? Or should I just have one huge table shared by all the systems users. I could see this table growing to 20,000,000 records within time. Would select statements and report generation on subsets of data from this monster table be slow? (SQL7) Are there benefits to leaving all of the data in one big table as opposed to generating this table on the fly for each user, therefor keeping the total size down? The table which holds the email campaigns recipients will need to be used in a number of joins to include additional email delivery stats. What do you think? Brook Davies maracasmedia inc. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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: OS X Web Services was Re: X-server?
I found the class in tt-bytecode.jar, which was part of the Axis distribution. Not sure where the class is supposed to be. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 5:04 PM To: CF-Talk Subject: Re: OS X Web Services was Re: X-server? Thanks Matt There is no com nor techtrader nor BCEntity anywhere within the Linux install (either as a filename or in the content of any file) -- I ported everything across as installed. Is the above part of the CFMX Linux install? If not where do I get it? TIA Dick On Wednesday, July 31, 2002, at 04:37 PM, Matt Liotta wrote: java.lang.NoClassDefFoundError: com/techtrader/modules/tools/bytecode/BCEntity Looks like your classpath is still wrong as the above error means that the JVM can't find the class com.techtrader.modules.tools.bytecode.BCEntity. You should verify that that class is in the classpath and/or even exists. -Matt __ 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: creating tables on the fly? Should I or Shouldn't I?
Generating tables for users on the fly is liable to be a lot more work both in the short term and especially in the long run. My general feeling is that if you think having separate tables to limit the number of records per would be a significant advantage ( if not necessary for performance purposes, after having exhausted the use of indexes and locking hints ) that you should probably be replicating and load-balancing your database accross multiple servers. I don't have any personal experience with systems which create tables on the fly, however, so I can't say from experience that it was a disaster ... it is a semi-unknown -- I know how it can be accomplished with SQL Server using the sp_execsql stored procedure primarily ( that is internally, as opposed to using ColdFusion dynamic queries ) but I haven't actually done it. The fact that there are very few people who have worked with similar systems is another reason for hesitation, since it limits your ability to get help if something goes wrong. Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 I posted this before, but got no response. Does any one know if this is sound/standard practice and if it makes any sense in this context? Just a nudge in the right direction in all I need. Thanks! -- --- I am designing an email application that will be used by multiple (100's - 1000's) of users. Each user will have their own account. When they send mail, the recipients are recorded to a table. this table is basically just a reference to the full recipient record and the email campaign id. If each user is sending email campaigns of 25,000 recipients + what is the best way to record and later generate reports on this data. Would it make sense to generate a campaign recipient table on the fly for each user of the system upon registration or first use? This way the total records per table would be a bit more manageable for report generation later. Is this sound practice? Or should I just have one huge table shared by all the systems users. I could see this table growing to 20,000,000 records within time. Would select statements and report generation on subsets of data from this monster table be slow? (SQL7) Are there benefits to leaving all of the data in one big table as opposed to generating this table on the fly for each user, therefor keeping the total size down? The table which holds the email campaigns recipients will need to be used in a number of joins to include additional email delivery stats. What do you think? Brook Davies maracasmedia inc. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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 __ 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: creating tables on the fly? Should I or Shouldn't I?
I think the question that needs to be answered is do the account holders really want to know exactly when a particular email address was mailed, and what they were mailed, and if so do they really need to do the queries on the fly? Those are the only benfits I can see of keeping track of exactly which emailing a particular email address received. I do see how valuable that kind of info could be in trying to track response though. Maybe if you only stored the complete record of who got emailed what for a certain amount of time? That might make the hardware requirements managable. How about logging the mailing info to a log file, and developing a process to parse the files and generate fancy reports? They couldn't be done on the fly, but there might be an oppurtunity to charge for the reports that way :) As to the question of creating tables on the fly, I don't think it's a good idea...data must be normalized, resistance is futile :) That's my opinion anyway. -- Jon mailto:[EMAIL PROTECTED] Wednesday, July 31, 2002, 8:20:48 PM, you wrote: BD I posted this before, but got no response. Does any one know if this is BD sound/standard practice and if it makes any sense in this context? Just a BD nudge in the right direction in all I need. Thanks! BD - BD I am designing an email application that will be used by multiple (100's - BD 1000's) of users. Each user will have their own account. When they send BD mail, the recipients are recorded to a table. this table is basically just BD a reference to the full recipient record and the email campaign id. If each BD user is sending email campaigns of 25,000 recipients + what is the best way BD to record and later generate reports on this data. BD Would it make sense to generate a campaign recipient table on the fly for BD each user of the system upon registration or first use? This way the total BD records per table would be a bit more manageable for report generation BD later. Is this sound practice? Or should I just have one huge table shared BD by all the systems users. I could see this table growing to 20,000,000 BD records within time. Would select statements and report generation on BD subsets of data from this monster table be slow? (SQL7) Are there benefits BD to leaving all of the data in one big table as opposed to generating this BD table on the fly for each user, therefor keeping the total size down? The BD table which holds the email campaigns recipients will need to be used in a BD number of joins to include additional email delivery stats. __ 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: OS X Web Services was Re: X-server?
I found it in DWMX, not in CFMX That changed the error now it can't find: java.lang.NoClassDefFoundError: org/w3c/dom/Node But, I do have that in several places WebObjects and several others. The most promising looks to be /System/Library/Frameworks/JavaXML.framework/WebServerResources/Java/orgw3c/ dom/Node.class I'll put that in my classpath and see what happens Thanks Dick On Wednesday, July 31, 2002, at 05:19 PM, Matt Liotta wrote: I found the class in tt-bytecode.jar, which was part of the Axis distribution. Not sure where the class is supposed to be. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [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
RE: creating tables on the fly? Should I or Shouldn't I?
I would say providing such granularity gets expensive... Not that should or shouldn't do it... from my take you have a database that looks like: ID (autonumber) email_address (text) email_campaign (numerical) subscriber_identifier (numerical) - relates to the particular user generating the email If you have 25,000 as a hard max on per mail mailings, then worst case is 25,000 x users x duration of logging... Every 40 power users per day adds a million rows of data... 400 power users equals 10 million rows Growth is exponential. Manageability of the data is paramount to making the system work in my opinion So historical data should be 'warehoused' after so many days and made available in less than live time web response atmosphere... Multiple tables won't work in this scenario... due to volume and limits on indexes, overhead, etc I am sure someone will say otherwise... it's just an expensive road to travel... The one table approach is wonderful, because you can bulk remove old data from it in one big query... the other route would mean multiple efforts to trim each set of data... more operations, more likelihood for error... I run queries against a several million column access database with success... SQL varieties (MSSQL and MySQL) should fair well for multiple user environments. You should attempt to precompile things on schedule to another table with stats, long and large term stuff... The only thing people should live time be requesting is active campaign data... Noted, that this is a logging application... This is the type of stuff that normally breaks things... -paris Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com (p) 1-212-655-4477 [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 8:21 PM To: CF-Talk Subject: creating tables on the fly? Should I or Shouldn't I? I posted this before, but got no response. Does any one know if this is sound/standard practice and if it makes any sense in this context? Just a nudge in the right direction in all I need. Thanks! - I am designing an email application that will be used by multiple (100's - 1000's) of users. Each user will have their own account. When they send mail, the recipients are recorded to a table. this table is basically just a reference to the full recipient record and the email campaign id. If each user is sending email campaigns of 25,000 recipients + what is the best way to record and later generate reports on this data. Would it make sense to generate a campaign recipient table on the fly for each user of the system upon registration or first use? This way the total records per table would be a bit more manageable for report generation later. Is this sound practice? Or should I just have one huge table shared by all the systems users. I could see this table growing to 20,000,000 records within time. Would select statements and report generation on subsets of data from this monster table be slow? (SQL7) Are there benefits to leaving all of the data in one big table as opposed to generating this table on the fly for each user, therefor keeping the total size down? The table which holds the email campaigns recipients will need to be used in a number of joins to include additional email delivery stats. What do you think? Brook Davies maracasmedia inc. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Good CFCatch code
On Wednesday, July 31, 2002, at 02:39 , S. Isaac Dealey wrote: cfdump var=#cfcatch#/ will get you started... .. you left out a on the end of the attribute, I've been doing that a lot recently... :| but ... why assuming CFMX? This works beautifully on CF 5 -- minus the trailing / since CF 5 and before weren't technically xml languages. I don't have CF5 here to check whether cfdump was available - I knew it wasn't in some earlier release but wasn't sure when it actually appeared (I used CF5 for only about a month before I changed to CFMX, back in September/October last year!). Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
reg ex again
hi there
cfset thisRightSide=newLength -
#reFindNoCase('/CREDITDATA','#Chop1#')#
do i need to do something special to the characters that
might be special character, (i suck at RegExp's)
thanks.
tony
-Original Message-
From: Sean A Corfield [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 9:04 PM
To: CF-Talk
Subject: Re: Good CFCatch code
On Wednesday, July 31, 2002, at 02:39 , S. Isaac Dealey wrote:
cfdump var=#cfcatch#/ will get you started...
.. you left out a on the end of the attribute,
I've been doing that a lot recently... :|
but ... why assuming CFMX?
This works beautifully on CF 5 -- minus the trailing / since CF 5 and
before
weren't technically xml languages.
I don't have CF5 here to check whether cfdump was available - I knew it
wasn't in some earlier release but wasn't sure when it actually appeared
(I used CF5 for only about a month before I changed to CFMX, back in
September/October last year!).
Sean A Corfield -- http://www.corfield.org/blog/
If you're not annoying somebody, you're not really alive.
-- Margaret Atwood
__
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: reg ex again
HI, My name is now
mr. hits send to early
again, thanks anyway, but i just
figgered it out :)
trust thyself, and thee shall succeed
young gwasshoppa.
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 9:07 PM
To: CF-Talk
Subject: reg ex again
hi there
cfset thisRightSide=newLength -
#reFindNoCase('/CREDITDATA','#Chop1#')#
do i need to do something special to the characters that
might be special character, (i suck at RegExp's)
thanks.
tony
-Original Message-
From: Sean A Corfield [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 9:04 PM
To: CF-Talk
Subject: Re: Good CFCatch code
On Wednesday, July 31, 2002, at 02:39 , S. Isaac Dealey wrote:
cfdump var=#cfcatch#/ will get you started...
.. you left out a on the end of the attribute,
I've been doing that a lot recently... :|
but ... why assuming CFMX?
This works beautifully on CF 5 -- minus the trailing / since CF 5 and
before
weren't technically xml languages.
I don't have CF5 here to check whether cfdump was available - I knew it
wasn't in some earlier release but wasn't sure when it actually appeared
(I used CF5 for only about a month before I changed to CFMX, back in
September/October last year!).
Sean A Corfield -- http://www.corfield.org/blog/
If you're not annoying somebody, you're not really alive.
-- Margaret Atwood
__
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: OS X Web Services was Re: X-server?
I have had no luck getting CFMX to recognize the class path for org/w3c/dom/Node either in the startup shell script or the CFMX administrator JVM settings. No doubt, my lack of Java expertise ... I'll do some reading and see if I can make it worh I think that it is close, thanks to Matt Liotta Dick current error Error Occurred While Processing Request org/w3c/dom/Node  The Error Occurred in /opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm: line 10 8 : cfinvokeargument 9 : name=sourcedata value=Hello world, friend 10 : /cfinvoke 11 : cfoutput#varName#/cfoutput 12 : Please Try The Following: * Check the CFML Reference Manual to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser  Mozilla/4.0 (compatible; MSIE 5.14; Mac_PowerPC) Remote Address  127.0.0.1 Referer  http://127.0.0.1:8500/mycfmxapps/ Date/Time  31-Jul-02 06:29 PM Stack Trace (click to expand) at cfWS12ecfm1726113412.runPage(/opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm: 10) at cfWS12ecfm1726113412.runPage(/opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm: 10) java.lang.NoClassDefFoundError: org/w3c/dom/Node at coldfusion.xml.rpc.XmlRpcServiceImpl$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at coldfusion.xml.rpc.XmlRpcServiceImpl.registerWebService(Unknown Source) at coldfusion.xml.rpc.XmlRpcServiceImpl.registerWebService(Unknown Source) at coldfusion.xml.rpc.XmlRpcServiceImpl.getWebService(Unknown Source) at coldfusion.xml.rpc.XmlRpcServiceImpl.getWebServiceProxy(Unknown Source) at coldfusion.tagext.lang.InvokeTag.doEndTag(Unknown Source) at cfWS12ecfm1726113412.runPage(/opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm: 10) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source) at coldfusion.filter.CfincludeFilter.invoke(Unknown Source) at coldfusion.filter.ApplicationFilter.invoke(Unknown Source) at coldfusion.filter.PathFilter.invoke(Unknown Source) at coldfusion.filter.ExceptionFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java: 294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) On Wednesday, July 31, 2002, at 05:45 PM, Dick Applebaum wrote: I found it in DWMX, not in CFMX That changed the error now it can't find: java.lang.NoClassDefFoundError: org/w3c/dom/Node But, I do have that in several places WebObjects and several others. The most promising looks to be /System/Library/Frameworks/JavaXML.framework/WebServerResources/Java/orgw3c/ dom/Node.class I'll put that in my classpath and see what happens Thanks Dick On Wednesday, July 31, 2002, at 05:19 PM, Matt Liotta wrote: I found the class in tt-bytecode.jar, which was part of the Axis distribution. Not sure where the class is supposed to be. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [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
One Last Duh: CFSET getting variable value
Been awhile since the brain has not overloaded. What have I missed here to get the value, I don't have sites that cfloop like this often...what I need to do in each of these is somehow plop the value of the form variable...in this instance, product1 in the first loop, product2 in the second loop...what have I missed making this fly besides forgetting how to set dynamic column names??? cfset i = 1 cfloop Index=i From=1 to=6 cfset productnew = form.product#i# cfset qtynew = form.qty#i# cfquery datasource=#heinz.dsn# Insert into customer_orders_prod (order_id, product_id, qty) VALUES (#getnewordernum.newestid#, #productnew#, #qtynew#) /cfquery cfset i = i + 1 /cfloop Quick refresher much appreciated. Thanks to all for the help I've needed on this meltdown week. Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions __ 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: One Last Duh: CFSET getting variable value (cancel)
DUH. Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 8:58 PM To: CF-Talk Subject: One Last Duh: CFSET getting variable value Been awhile since the brain has not overloaded. What have I missed here to get the value, I don't have sites that cfloop like this often...what I need to do in each of these is somehow plop the value of the form variable...in this instance, product1 in the first loop, product2 in the second loop...what have I missed making this fly besides forgetting how to set dynamic column names??? cfset i = 1 cfloop Index=i From=1 to=6 cfset productnew = form.product#i# cfset qtynew = form.qty#i# cfquery datasource=#heinz.dsn# Insert into customer_orders_prod (order_id, product_id, qty) VALUES (#getnewordernum.newestid#, #productnew#, #qtynew#) /cfquery cfset i = i + 1 /cfloop Quick refresher much appreciated. Thanks to all for the help I've needed on this meltdown week. Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions __ 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
cfsavecontent
hi. is there a way to parse cfoutput#mtVar#/cfoutput inside the cfsavecontent/cfsavecontent tag? like this cfsavecontent xml some_xml cfoutput#mtVar#/cfoutput /some_xml /xml /cfsavecontent if so, how? HELP :) ...tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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 GetDate()
Have you tried this in Query Analyser? SQL 7? like insert into table values(field1,.,GetDate()) Check to see whether your Field of DateTime Type? Joe -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 7:56 PM To: CF-Talk Subject: RE: SQL GetDate() I did exactly that...defined in Ent Man as GetDate(), left it blank in the insert statement, but get this error: DIAGNOSTIC: ODBC Error Code = 22008 (Datetime field overflow) [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from character string. My first guess would be that there is a space-character at the beginning of your default definition, i.e. GETDATE() ... Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ 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: cfsavecontent
What do you mean? This is exactly what cfsavecontent does. The outputted variable WILL contain the code executed between the start and end tag. csfet myvar=Hello World cfsavecontent variable=str xml some_xml cfoutput#mtVar#/cfoutput /some_xml /xml /cfsavecontent cfoutput#str#/cfoutput At 10:31 PM 31/07/02 -0400, you wrote: hi. is there a way to parse cfoutput#mtVar#/cfoutput inside the cfsavecontent/cfsavecontent tag? like this cfsavecontent xml some_xml cfoutput#mtVar#/cfoutput /some_xml /xml /cfsavecontent if so, how? HELP :) ...tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 __ 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: cfsavecontent
ok, well, for some reason, it doesnt seem to be working? let me try again tw -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 10:57 PM To: CF-Talk Subject: Re: cfsavecontent What do you mean? This is exactly what cfsavecontent does. The outputted variable WILL contain the code executed between the start and end tag. csfet myvar=Hello World cfsavecontent variable=str xml some_xml cfoutput#mtVar#/cfoutput /some_xml /xml /cfsavecontent cfoutput#str#/cfoutput At 10:31 PM 31/07/02 -0400, you wrote: hi. is there a way to parse cfoutput#mtVar#/cfoutput inside the cfsavecontent/cfsavecontent tag? like this cfsavecontent xml some_xml cfoutput#mtVar#/cfoutput /some_xml /xml /cfsavecontent if so, how? HELP :) ...tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: reg ex again
but ... why assuming CFMX? This works beautifully on CF 5 -- minus the trailing / since CF 5 and before weren't technically xml languages. I don't have CF5 here to check whether cfdump was available - I knew it wasn't in some earlier release but wasn't sure when it actually appeared (I used CF5 for only about a month before I changed to CFMX, back in September/October last year!). You lucky bastard. :) It's actually a real advantage (or it will be if it's not already) that most of your experience is after the migration to J2EE, since that means your head hasn't been pre-filled with issues which only existed in older versions of the server. This is true of any newer version, but much more so with MX because of the move from C++ to Java -- full-scale core-system changes carry so many more differences than new versions on the same basic platform. Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ 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: cfsavecontent
hi. is there a way to parse cfoutput#mtVar#/cfoutput inside the cfsavecontent/cfsavecontent tag? like this cfsavecontent xml some_xml cfoutput#mtVar#/cfoutput /some_xml /xml /cfsavecontent if so, how? HELP :) Yep, that's the purpose of cfsavecontent ... I would put the cfoutput tags outside the cfsavecontent tag ... This then is a very fast and easy way to generate xml packets for whatever your purposes happen to be... As a matter of fact, if it weren't for the fact that there's already a native parser to create WDDX packets, I'd probably be creating them this way. :) Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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: cfsavecontent
heres whats not parsing
cfsavecontent variable=tony
![CDATA[cfoutput#xmlFormat('#FinalChop#')#/cfoutput]]
/cfsavecontent
its returning this:
![CDATA[;CREDITDATAamp;]]
and thats not correct.
tony
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 10:44 PM
To: CF-Talk
Subject: RE: cfsavecontent
ok, well, for some reason, it doesnt seem to be working?
let me try again
tw
-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 10:57 PM
To: CF-Talk
Subject: Re: cfsavecontent
What do you mean? This is exactly what cfsavecontent does. The
outputted
variable WILL contain the code executed between the start and end tag.
csfet myvar=Hello World
cfsavecontent variable=str
xml
some_xml
cfoutput#mtVar#/cfoutput
/some_xml
/xml
/cfsavecontent
cfoutput#str#/cfoutput
At 10:31 PM 31/07/02 -0400, you wrote:
hi.
is there a way to parse cfoutput#mtVar#/cfoutput
inside the cfsavecontent/cfsavecontent tag?
like this
cfsavecontent
xml
some_xml
cfoutput#mtVar#/cfoutput
/some_xml
/xml
/cfsavecontent
if so, how? HELP :)
...tony
tony weeg
[EMAIL PROTECTED]
www.revolutionwebdesign.com
rEvOlUtIoN wEb DeSiGn
410.334.6331
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.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: cfsavecontent
and even putting the cfoutput tags
around that, cfsavecontent tag, it still doesnt work?
tw
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 10:57 PM
To: CF-Talk
Subject: RE: cfsavecontent
heres whats not parsing
cfsavecontent variable=tony
![CDATA[cfoutput#xmlFormat('#FinalChop#')#/cfoutput]]
/cfsavecontent
its returning this:
![CDATA[;CREDITDATAamp;]]
and thats not correct.
tony
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 10:44 PM
To: CF-Talk
Subject: RE: cfsavecontent
ok, well, for some reason, it doesnt seem to be working?
let me try again
tw
-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 10:57 PM
To: CF-Talk
Subject: Re: cfsavecontent
What do you mean? This is exactly what cfsavecontent does. The
outputted
variable WILL contain the code executed between the start and end tag.
csfet myvar=Hello World
cfsavecontent variable=str
xml
some_xml
cfoutput#mtVar#/cfoutput
/some_xml
/xml
/cfsavecontent
cfoutput#str#/cfoutput
At 10:31 PM 31/07/02 -0400, you wrote:
hi.
is there a way to parse cfoutput#mtVar#/cfoutput
inside the cfsavecontent/cfsavecontent tag?
like this
cfsavecontent
xml
some_xml
cfoutput#mtVar#/cfoutput
/some_xml
/xml
/cfsavecontent
if so, how? HELP :)
...tony
tony weeg
[EMAIL PROTECTED]
www.revolutionwebdesign.com
rEvOlUtIoN wEb DeSiGn
410.334.6331
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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: cfsavecontent
heres whats not parsing
cfsavecontent variable=tony
![CDATA[cfoutput#xmlFormat('#FinalChop#')#/cfoutput]]
/cfsavecontent
its returning this:
![CDATA[;CREDITDATAamp;]]
and thats not correct.
That's a problem with the xmlFormat() function -- or the way it's being used
-- I'm not familiar with the function, so I don't know what it's supposed to
do, although my _guess_ ( if I had to guess ) would be that it's intended to
make a string xml-safe like jsstringformat() does for javascript or the
way that htmleditformat() makes a string html-safe ...
What is the value of FinalChop prior to using the xmlFormat() function on
it? And what is the expected output?
Incidentally, you don't need the single-quotes or the pound-symbols
surrounding FinalChop ... #xmlFormat(finalChop)# should do the same thing,
and with less typing, is easier to read and slightly more efficient for the
parser.
Final thing -- I would still recommend putting the cfoutput tags outside
the cfsavecontent tags if for no other reason than legibility ... that
way, they're not muddling up the xml packet in your code, and the xml packet
should be easier to read.
Isaac Dealey
Certified Advanced ColdFusion Developer
www.turnkey.to
954-776-0046
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.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: cfsavecontent
so, do you think this should work?
cfoutput
cfsavecontent variable=tony
![CDATA[#FinalChop#]]
/cfsavecontent
/cfoutput
btw, the value of final chop, is about 1900 characters of xml code, a
response
from an asp web service, that has been len()'d then lefted and righted
to get a middle
section, the only section i need, then parse in this new variable called
tony
to then write to a cffile xml file.
tony
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 11:00 PM
To: CF-Talk
Subject: RE: cfsavecontent
heres whats not parsing
cfsavecontent variable=tony
![CDATA[cfoutput#xmlFormat('#FinalChop#')#/cfoutput]]
/cfsavecontent
its returning this:
![CDATA[;CREDITDATAamp;]]
and thats not correct.
That's a problem with the xmlFormat() function -- or the way it's being
used
-- I'm not familiar with the function, so I don't know what it's
supposed to
do, although my _guess_ ( if I had to guess ) would be that it's
intended to
make a string xml-safe like jsstringformat() does for javascript or
the
way that htmleditformat() makes a string html-safe ...
What is the value of FinalChop prior to using the xmlFormat() function
on
it? And what is the expected output?
Incidentally, you don't need the single-quotes or the pound-symbols
surrounding FinalChop ... #xmlFormat(finalChop)# should do the same
thing,
and with less typing, is easier to read and slightly more efficient for
the
parser.
Final thing -- I would still recommend putting the cfoutput tags
outside
the cfsavecontent tags if for no other reason than legibility ... that
way, they're not muddling up the xml packet in your code, and the xml
packet
should be easier to read.
Isaac Dealey
Certified Advanced ColdFusion Developer
www.turnkey.to
954-776-0046
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.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
CFSERVLET Could not connect to JRun Connector Proxy error
Can't connect to a servlet using cfservlet tag in CF 4.5 sp2 JRun default server is definitely running as well as the external connector. The local.properties file reveals its using port 51000 ,which is the default port. Since everything else seems to be working like it should with jrun, i don't see this being a jrun issue. Anybody had this before ? -- Visit The Most Powerful Tool on the Farm at http://www.ifarm.com Get the latest on Ag News, Market Reports, FREE email, and much more. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: cfsavecontent
so, do you think this should work? cfoutput cfsavecontent variable=tony ![CDATA[#FinalChop#]] /cfsavecontent /cfoutput btw, the value of final chop, is about 1900 characters of xml code, a response from an asp web service, that has been len()'d then lefted and righted to get a middle section, the only section i need, then parse in this new variable called tony to then write to a cffile xml file. Yep, that should work... The problem you're having really isn't with the cfsavecontent tho, it's with the xml parsing ... which is probably significantly more complex than the savecontent tag... I'd need ( or anyone on the list would need ) a lot more information about where this xml packet is coming from and where it's going and what its format is in order to provide any really helpful advice... Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ 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: creating tables on the fly? Should I or Shouldn't I?
Personally... I would create a good relational tables structure without any data replication... this should be fairly sufficient. Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 8:21 PM To: CF-Talk Subject: creating tables on the fly? Should I or Shouldn't I? I posted this before, but got no response. Does any one know if this is sound/standard practice and if it makes any sense in this context? Just a nudge in the right direction in all I need. Thanks! - I am designing an email application that will be used by multiple (100's - 1000's) of users. Each user will have their own account. When they send mail, the recipients are recorded to a table. this table is basically just a reference to the full recipient record and the email campaign id. If each user is sending email campaigns of 25,000 recipients + what is the best way to record and later generate reports on this data. Would it make sense to generate a campaign recipient table on the fly for each user of the system upon registration or first use? This way the total records per table would be a bit more manageable for report generation later. Is this sound practice? Or should I just have one huge table shared by all the systems users. I could see this table growing to 20,000,000 records within time. Would select statements and report generation on subsets of data from this monster table be slow? (SQL7) Are there benefits to leaving all of the data in one big table as opposed to generating this table on the fly for each user, therefor keeping the total size down? The table which holds the email campaigns recipients will need to be used in a number of joins to include additional email delivery stats. What do you think? Brook Davies maracasmedia 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
ColdFusion Scheduler creates hung process
I saw a post on this forum regarding a cfexecute problem where if you: (1) Don't specify an output file (2) Get a long output from your executable then you get a hung process on your server. Has anybody experienced a similar problem with the ColdFusion Scheduler ? I am not using cfschedule, just have created the schedule to run daily in ColdFusion Administrator. It's a highly database-intensive process, which dynamically generates and sends out emails. 9 times out of 10, it runs fine, requiring anything from 12-20 minutes for execution. However, in about 1 of 10 cases, the schedule executes completely but doesn't exit. It continues to run and eventually times out, at the RequestTimeout interval specified in CF Administrator. It also pushes up CPU utilisation to 99%, and virtually hangs the machine, requiring a restart of the CF Application Server service. Has anyone experienced a similar problem or have any suggestions on troubleshooting it ? My scheduler refresh interval is 15 minutes, lower than the usual time of execution of this schedule. The requesttimeout period is set to a very high value, nearly 80 minutes. The template executed in the schedule contains some cfoutput tags, used for debugging purposes. However, the output from this template is not being logged. Could any of these be causing this hung process ? I am running CF 4.5 on Win 2K, IIS5, and SQL 2000 DB. Vishal. __ 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
ColdFusion Scheduler creates hung process
I saw a post on this forum regarding a cfexecute problem where if you: (1) Don't specify an output file (2) Get a long output from your executable then you get a hung process on your server. Has anybody experienced a similar problem with the ColdFusion Scheduler ? I am not using cfschedule, just have created the schedule to run daily in ColdFusion Administrator. It's a highly database-intensive process, which dynamically generates and sends out emails. 9 times out of 10, it runs fine, requiring anything from 12-20 minutes for execution. However, in about 1 of 10 cases, the schedule executes completely but doesn't exit. It continues to run and eventually times out, at the RequestTimeout interval specified in CF Administrator. It also pushes up CPU utilisation to 99%, and virtually hangs the machine, requiring a restart of the CF Application Server service. Has anyone experienced a similar problem or have any suggestions on troubleshooting it ? My scheduler refresh interval is 15 minutes, lower than the usual time of execution of this schedule. The requesttimeout period is set to a very high value, nearly 80 minutes. The template executed in the schedule contains some cfoutput tags, used for debugging purposes. However, the output from this template is not being logged. Could any of these be causing this hung process ? I am running CF 4.5 on Win 2K, IIS5, and SQL 2000 DB. Vishal. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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: OS X Web Services Running! was Re: X-server?
On Wednesday, July 31, 2002, at 04:23 , Dick Applebaum wrote: I also put a copy of java2wsdl.jar and wsdl2java.jar in the same folder. Don't need 'em. You need tt-bytecode.jar which is part of the axis-1_0 distribution. Download the Beta 3 .tar.gz from http://xml.apache.org/axis/index.html - inside axis-1_0/lib you'll find tt-bytecode.jar - cp it to /Library/Java/Extensions/ You also need xmlParserAPIs.jar which is part of the Xerces Java 2 distribution which you can download from http://gump.covalent.net/jars/latest/xml-xerces2/ - cp that to /Library/Java/Extensions/ I also cp webservices.jar from the CF runtime/lib to there but I haven't verified whether it's actually necessary. Access a web service (e.g., the Amazon one) and lo and behold!! If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ 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: reg ex again
On Wednesday, July 31, 2002, at 07:45 , S. Isaac Dealey wrote: You lucky bastard. :) It's actually a real advantage (or it will be if it' s not already) that most of your experience is after the migration to J2EE, since that means your head hasn't been pre-filled with issues which only existed in older versions of the server. This is true of any newer version, but much more so with MX because of the move from C++ to Java -- full-scale core-system changes carry so many more differences than new versions on the same basic platform. I guess so. But my background is compiler theory and language design with eight years of C++ development and five years of Java so I would probably be approaching even CF5 with a very different viewpoint to most CFers. I actually feel a bit embarrassed that I don't know more about CF5 and can only really talk knowledgeably about CFMX... I think CF rocks tho'! Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
Statistics for dynamic data websites
Hi All, I *know* this has been said before, but can't find it anywhere ( yes, I have searched the archives, and used google). Can anyone give me a good statistics package for use with a dynamic website. Something that can handle query strings indicating what the content is. I've looked at Urchin, WebTrends (any ideas on the price? can't find it on the website), LiveStats (can it handle dynamic data?), NetTracker Enterprise, and Summary. Any other ideas? Any recomendations? Please reply directly as well as to the list as I am on digest. Thanks, Cameron 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: OS X Web Services Running! was Re: X-server?
On Wednesday, July 31, 2002, at 10:06 , Sean A Corfield wrote: Access a web service (e.g., the Amazon one) and lo and behold!! Here's a simple example (you'll need to sign up for the Amazon developer program and get your own developer tag to go in this code!): html head titleAmazon Keyword Search/title /head cfparam name=URL.kw type=string default=ColdFusion/ cfoutput cfset kwReq = structNew() / cfset kwReq.keyword=URL.kw / cfset kwReq.page=1 / cfset kwReq.mode=books / cfset kwReq.tag=webservices-20 / cfset kwReq.type=lite / cfset kwReq.devtag=XXX your developer tag goes here XXX / cfset kwReq.version=1.0 / cfinvoke webservice=http://soap.amazon.com/schemas/AmazonWebServices.wsdl; method= KeywordSearchRequest KeywordSearchRequest=#kwReq# returnvariable=amazon/ cfset details = amazon.getDetails()/ pBooks matching #kwReq.keyword#:/p cfloop index=i from=1 to=#arrayLen(details)# !--- cfdump label=details[#i#] var=#details[i]#/ --- cfset authList = details[i].getAuthors()/ cfset authors = arrayToList(authList,, )/ p#details[i].getProductName()# by #authors# sfont color=red#details[i].getListPrice()#/font/s #details[i].getOurPrice()#/p /cfloop /cfoutput body /body /html __ 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: X-server?
Dick Applebaum wrote: You can get most of the function of Verity with a open source package called Glimpse -- I think the latest version is available at: http://webglimpse.org/ It is Perl-based only (AFAIK), but that's no problem as Mac OS X includes Perl with every installation I used glimpse quite a bit in the 1997 time frame, when I was programming Perl sites Pretty good package, fast, complete - no stemming, though Anyway, there are other excellent packages such as imageMagik, that probably could be interfaced through Perl. There is even a Coldfusion custom tag set that works with imagemagick Jesse __ 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: House of Fusion Architecture Revealed at August 13 NYCFUG Meeting
Thanks Michael, always a pleasure... -paris Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com (p) 1-212-655-4477 [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:25 AM To: CF-Talk Subject: Re: House of Fusion Architecture Revealed at August 13 NYCFUG Meeting After the meeting. I'll be releasing all of the code at that point. As for slides, I don't have any. It'll be an examination of the issues surrounding a mailing list and site followed by some specific problems (like speed, caching, etc) followed by code to solve each problem. I'll be sure to have a write-up afterwards. any plans for releasing the UDF's to the rest of us that aren't local :) I surely am interested in your presentation and materials... Any plans to get the slides or presentation online as well :)? -paris Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com (p) 1-212-655-4477 [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:03 AM To: CF-Talk Subject: Re: House of Fusion Architecture Revealed at August 13 NYCFUG Meeting At the meeting I'll be releasing a number of UDFs that I use for email parsing, validation, etc. Code will be had for all. If you have a chance of coming, I highly suggest it. For the first time, Michael Dinowitz is going to reveal some of the hidden gems, best practices and the approaches that make the new House of Fusion archives function quickly and efficiently. This presentation will cover the issues, architecture and code necessary for the House of Fusion lists to operate. Michael will address such topics as weeding out spammers, parsing through email, and handling a high-volume content site, as well as the front end of the House of Fusion archives (http://www.houseoffusion.com/cf_lists ). HOF (House of Fusion), http://www.houseoffusion.com , is a high volume ColdFusion online resource, hosting CF-Talk, Fusion Authority and other community services. On a tight budget and with his innovative approach, Michael Dinowitz has used his coding techniques to build a vibrant community center. When? Tuesday, August 13, 6:30 PM Where? NYU Medical Center, 550 1st Avenue, Coles 109 Please RSVP on our site (http://www.nycfug.org ) for a chance to win a copy of the new Fusebox book, Discovering Fusebox 3 by Hal Helms and John Quarto Von-Tivadar, and other goodies. Only those who RSVP and attend the meeting will be part of our raffle. __ 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: CF MX performance issue
Joe Eugene wrote: I noticed on my Dev box... when you open server docs... http://127.0.0.1/cfdocs/dochome.htm Does this have anything to do with the JRE... Docs say Note: The search dialog works with the J2SE 1.4.0 JRE, J2SE 1.3.1_02 JRE, and J2SE1.3.1_03 JRE, and with the corresponding SDKs When i installed the latest J2SE...docs ran faster.. but system slowed.. Any Ideas? I replaced search.cfm with an empty page. This is the only page that uses java, and it downloads a whopping 3 Mb file each time you access the darn thing. Jesse __ 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
Dreamweaver MX and #URLSessionFormat()#
I'm using URLSessionFormat on all my internal links (even wrote a cf_a
custom tag for it)... but I didn't have the need for a cf_frame tag just
yet. I found out that the following code
frame src=#URLSessionFormat('sidebar_top.cfm')# name=top
frameborder=0 border=0 framespacing=0 scrolling=no /
Makes Dreamweaver MX alert me of the fact that a page named
#URLSessionFormat('sidebar_top.cfm')# not exixts. Well I know that :)
And the same again when you save. The page in question has 3 frames, so
that's 3 pop-ups every time I hit ctrl-s... And that is quite annoying
as you can imagine.
Does anyone know how I can by-pass this page exists check? Or how I can
get Dreamweaver to check if the pages exist in the compiled cfm? Or just
skip any urls that contain #-signs?
Jesse
My code is as follows:
?xml version=1.0 encoding=utf-8?
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Frameset//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd;
html
head
titleTweakers.net Sidebar/title
meta http-equiv=Content-Type content=text/html; charset=utf-8 /
script src=autoinstall.js type=text/javascript charset=UTF-8
/script
script language=javascript1.2 type=text/javascript
cfoutputAutoinstall(Tweakers.net Advanced,
#URLSessionFormat('http://toaom.student.utwente.nl/mozilla/sidebar/tweakersnetadv/sidebar.cfm')#,
);/cfoutput
/script
/head
frameset rows=43,*,35,35,45 id=TSBframe frameborder=0 border=0
framespacing=0
cfoutput
frame src=#URLSessionFormat('sidebar_top.cfm')# name=top
frameborder=0 border=0 framespacing=0 scrolling=no /
frame src=#URLSessionFormat('dataviewer.cfm')#
name=dataviewer
frameborder=0 border=0 framespacing=0 scrolling=no/
frame src=#URLSessionFormat('settings_panel.cfm')#
name=settings
frameborder=0 border=0 framespacing=0 scrolling=no /
frame src=search_panel.html name=search frameborder=0
border=0 framespacing=0 scrolling=no /
frame src=sidebar_bottom.html name=bottom frameborder=0
border=0 framespacing=0 scrolling=no /
/cfoutput
/frameset
noframes
This is a Mozilla Sidebar. You need Mozilla or Netscape 6 or higher to
view it.
/noframes
/html
__
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: CFMX Taking all CPU Resources? (CODE)
Joe Eugene wrote: Noticed the evaluate as well but thats very minor.. right? 10ms maybe? Yeah, but it may be yet another 10 ms. If you have a lot of traffic and there need to be a lot of evaluates it should introduce extra CPU load. Jesse __ 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: Dreamweaver MX and #URLSessionFormat()#
Jesse Houwing wrote: I'm using URLSessionFormat on all my internal links (even wrote a cf_a custom tag for it)... but I didn't have the need for a cf_frame tag just yet. I found out that the following code frame src=#URLSessionFormat(sidebar_top.cfm)# name=top frameborder=0 border=0 framespacing=0 scrolling=no / Even hitting CRTL-F5 and then closing that window really messes up my frame tag. This is becomming more and more irritating Jesse __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
Session Managment- across application servers
I have my site developed in ColdFusion. I need to integrate this with a message forum application written entirely in ASP. I need to pass session information from my .cfm templates to the message forum. Essentially, if a person is logged in on the site, they should be logged in on the forum as well. What is the best way to do this ? Can session variables created in my application.cfm file be accessed by the ASP application as well ? Vishal __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
ColdFusion based message Forum ?
Can anybody recommend a good freeware message forum written purely in ColdFusion ? It should be possible to integrate it with a SQL 2000 DB. Has anyone evaluated or is using FuseTalk (http://www.e-zonemedia.com/) ? Any comments ? Vishal __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
