RE: cfsqltype=cf_sql_timestamp
Your ms sql server column RequestsDate is of type date/time - right? In my database it's of type timestamp - totally different data type. -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 10:08 PM To: CF-Talk Subject: RE: cfsqltype=cf_sql_timestamp This code is working in my application. CFPROCPARAM type=IN cfsqltype=CF_SQL_TIMESTAMP dbvarname=RequestsDate value='#NOW()#' HTH -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 3:00 PM To: CF-Talk Subject: RE: cfsqltype=cf_sql_timestamp unfortunately mssql timestamp has nothing to do with time/date - this is the problem. i need a cfsqltype that supports mssql timestamp. -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 9:03 PM To: CF-Talk Subject: RE: cfsqltype=cf_sql_timestamp Try Using: #createodbcdate(attributes.contentTimeStamp)# CF function You may want to consider switching to datetime or smalldatetime... Check the MDAC documentation on what that supports. Everything supported in MDAC *should* be supported in cf... -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 7:42 AM To: CF-Talk Subject: cfsqltype=cf_sql_timestamp hi I'm trying to pass a mssql server 7 timestamp variable into a sql 7 database using a stored proc (cf 4.51) using : cfprocparam type=in cfsqltype=cf_sql_timestamp value=#attributes.contentTimestamp# It gives an error. I've subsequently learned that CF does not support ms sql 7 timestamp data types, which are actually of bin(8) data types. CF thinks they're date/time, which in my case it certainly isn't. Has anyone successfully managed to pass this varibale type into SQL? Thanks Steve Vosloo Vardus (Pty) Ltd ASKA House Fedsure on Main Main Road Newlands 7700 Cape Town Tel: +27 (0)21 670 9880 Fax: +27 (0)21 674 4549 www.vardus.co.za The information contained in this communication is confidential, may be privileged and is intended for the above named addressee(s). If you are not the intended recipient(s), and have received this communication in error, please contact the sender by replying to this email or by telephoning +27 (0)21 670 9880. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Vardus (Pty) Ltd. ~~ 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 Windows Resolution Detection
Is there any other way in CF to detect the windows resolution other than using JS? Since everything CF does is build information and send it to the recipient, whether it's a browser or a robot, it CAN'T know what resolution the screen is Java, JavaScript, JScript and VBScript are the only tools that run in the browser that can interact with the user's machine - this information would then have to be sent back to the server where CF would interact with it That is unless you can develop ESP for your web server g Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: WDDX Error
It appears you are trying to serialise HTML content, have you tried to delimit the content before seriliazing? Neil Team Macromedia ~~ 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: WAAAAHHHHH
THis really sucks. Went to DevCon - Took the certification test (which I passed as an advanced developer). Came home all excited about the goodies I was going to get from Macromedia as a Certified Developer. Saw Erika's cool pocketwatch. Waiting to get it. The box came today. Opened it up with bated breath. Small blue box Took a while to figure out how to open it. When I finally got it open there was .. .. .. A cropped message? Actually, I know the answer as one came to Adam here They're definitely getting cheaper! Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED]] Sent: 21 November 2001 01:45 To: CF-Talk Subject: WH ~~ 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: cfsqltype=cf_sql_timestamp
Your ms sql server column RequestsDate is of type date/time - right? In my database it's of type timestamp - totally different data type. just to really rub it in: timestamp in sql server (as opposed to cf dealing with sql server's datetimes) is a binary(8) or varbinary(8) equivalent. Steve, after looking at this last night, your request is kinda tougher than it 1st looks. if you've returned a TS value as part of some previous resultset, i guess the best bet is that you'll have to go back and CAST it as an integer on the way out--i just tried various varchar combos *after* pulling it from the db none returned the timestamp correctly. the global var @@dbTS returns the db's current timestamp value. its value in my db is 0x00011307 (int equivalent to 70407). this is the t-sql code i used to test: declare @x varchar(50) set @x='00011307' select @@dbts, cast(@x as binary(8)), cast(@@dbts as int), cast(70407 as timestamp) which returns: real dbTS:=0x00011307, cast from varchar:=0x3030303030303030, (wrong) cast as int:=70407, cast int back to TS:=0x00011307 (right) this db system is relatively quite lately, so i have no idea if you'll overflow an int datatype if you really pound tables with TS columns... is this what you're after? ~~ 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 Windows Resolution Detection
Yeah, you'd want to look into using JS to pass that info back to ColdFusion. If you have a budjet to work with, also take a look at www.browserhawk.com -Cameron Cameron Childress elliptIQ Inc. p.770.460.7277.232 f.770.460.0963 -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 9:03 PM To: CF-Talk Subject: Re: CF And Windows Resolution Detection Is there any other way in CF to detect the windows resolution other than using JS? Not 100% sure about this, but suspect not. I think the only client-side info CF has direct access to (i.e. without some sort of JS involvement) is the CGI vars. - Gyrus ~~ 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: WAAAAHHHHH
And I wouldnt mind getting a Leatherman :) -Gel -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 9:45 PM To: CF-Talk Subject: WH THis really sucks. Went to DevCon - Took the certification test (which I passed as an advanced developer). Came home all excited about the goodies I was going to get from Macromedia as a Certified Developer. Saw Erika's cool pocketwatch. Waiting to get it. The box came today. Opened it up with bated breath. Small blue box Took a while to figure out how to open it. When I finally got it open there was .. .. .. ~~ 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: WAAAAHHHHH
I got a travel bag... But it was that Allaire brand. ;) EC -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 7:28 AM To: CF-Talk Subject: RE: WH And I wouldn't mind getting a Leatherman :) -Gel -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 9:45 PM To: CF-Talk Subject: WH THis really sucks. Went to DevCon - Took the certification test (which I passed as an advanced developer). Came home all excited about the goodies I was going to get from Macromedia as a Certified Developer. Saw Erika's cool pocketwatch. Waiting to get it. The box came today. Opened it up with bated breath. Small blue box Took a while to figure out how to open it. When I finally got it open there was .. .. .. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Is CF 5 ready for production?
Hi all. Other than a few Hot Fixes, I don't see any service packs available for CF 5.0. Are there any issues I should be aware of before upgrading from 4.51 on a production server? Would anyone suggest waiting for a SP if there is one forthcoming? Other than the extra features available, is there enough of a performance enhancement to justify upgrading (Pro, so it's only 650.00)? Has anyone hit any snags during the upgrade process that has caused downtime? Thanks for your time. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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
Help for //
Hi, We are using Fusebox in a large site and when we are navigating from a fuse to another one we are getting this url http://x.x.x.x/portal//institucional/index.cfm or http://x.x.x.x/portal/institucional//index.cfm?fuseaction=institucional with double slashes. Why does it happen? How can we prevent this to happen? Any clue? Thanks in advance. Antonio Mokarzel ~~ 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
OT: Clustering
I am curious if anyone has any notes and suggestions from the field regarding load balancing and most importantly fail over. I am not so interested in it from a CF perspective but moreso from a hardware / OS view. If anyone has any suggestions and comments I would appreciate it. Thanks, Neil ~~ 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: Help for //
Check to make sure you are not setting a variable /blah blah after having something that was set as http://www.blah.com/;.. -Original Message- From: Antonio Mokarzel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 8:17 AM To: CF-Talk Subject: Help for // Hi, We are using Fusebox in a large site and when we are navigating from a fuse to another one we are getting this url http://x.x.x.x/portal//institucional/index.cfm or http://x.x.x.x/portal/institucional//index.cfm?fuseaction=institucional with double slashes. Why does it happen? How can we prevent this to happen? Any clue? Thanks in advance. Antonio Mokarzel ~~ 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: Clustering
give me a better idea of what your question is and I will take a stab at it... worked on several load balanced systems... -p -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 08:17 To: CF-Talk Subject: OT: Clustering I am curious if anyone has any notes and suggestions from the field regarding load balancing and most importantly fail over. I am not so interested in it from a CF perspective but moreso from a hardware / OS view. If anyone has any suggestions and comments I would appreciate it. Thanks, Neil ~~ 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: WAAAAHHHHH
remember, the pocketwatches were leftover Allaire-branded items. There will only be so many cool leftovers until they're gone. Sounds like they're gone. Macromedia isn't as free with the T-shirts as Allaire was either. Don -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 8:45 PM To: CF-Talk Subject: WH THis really sucks. Went to DevCon - Took the certification test (which I passed as an advanced developer). Came home all excited about the goodies I was going to get from Macromedia as a Certified Developer. Saw Erika's cool pocketwatch. Waiting to get it. The box came today. Opened it up with bated breath. Small blue box Took a while to figure out how to open it. When I finally got it open there was . . . ~~ 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: Is CF 5 ready for production?
Our server didn't like it, pages took forever to load on occaissions, recieved a http 404 eventually. we had to upgrade servers. In saying that our server was ! The things were fine. You will need more space to install though, If I remember correctly it takes an extra 90Mb or so. Performance, I find it better. jmc .. -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 1:06 PM To: CF-Talk Subject: Is CF 5 ready for production? Hi all. Other than a few Hot Fixes, I don't see any service packs available for CF 5.0. Are there any issues I should be aware of before upgrading from 4.51 on a production server? Would anyone suggest waiting for a SP if there is one forthcoming? Other than the extra features available, is there enough of a performance enhancement to justify upgrading (Pro, so it's only 650.00)? Has anyone hit any snags during the upgrade process that has caused downtime? Thanks for your time. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is CF 5 ready for production?
So far the only problem I have no found a workaround for is CFexecute. I use it quite extensively here, and it does not work at all on CF 5. No one from Macromedia responds to my questions on it and I have yet to hear back from them when I reported it. If you don't use cfexecute I don't see there being an issue. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 8:06 AM To: CF-Talk Subject: Is CF 5 ready for production? Hi all. Other than a few Hot Fixes, I don't see any service packs available for CF 5.0. Are there any issues I should be aware of before upgrading from 4.51 on a production server? Would anyone suggest waiting for a SP if there is one forthcoming? Other than the extra features available, is there enough of a performance enhancement to justify upgrading (Pro, so it's only 650.00)? Has anyone hit any snags during the upgrade process that has caused downtime? Thanks for your time. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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: WAAAAHHHHH
This is way OT, but I'm dying to know what they delivered!! Please tell. Nate -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 8:45 PM To: CF-Talk Subject: WH THis really sucks. Went to DevCon - Took the certification test (which I passed as an advanced developer). Came home all excited about the goodies I was going to get from Macromedia as a Certified Developer. Saw Erika's cool pocketwatch. Waiting to get it. The box came today. Opened it up with bated breath. Small blue box Took a while to figure out how to open it. When I finally got it open there was . . . ~~ 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: Is CF 5 ready for production?
On 11/21/01, John McCosker penned: Our server didn't like it, pages took forever to load on occaissions, recieved a http 404 eventually. we had to upgrade servers. In saying that our server was ! The space shouldn't be a problem. I'm running dual PIII 533 Mz with 1 GB RAM. The server is a Dell 2400 less than 2 years old. That should be OK? The things were fine. You will need more space to install though, If I remember correctly it takes an extra 90Mb or so. Performance, I find it better. Thanks, -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is CF 5 ready for production?
hmm, well not much I can really say except adsvise not to upgrade, re-install if possible. Neil Team Macromedia ~~ 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: Clustering
I would like to know what experiences you had with clustering and what you found to be most cost effective, in terms of price for the solution and TCO. Thanks, Neil - Original Message - From: Paris Lundis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 8:12 AM Subject: RE: Clustering give me a better idea of what your question is and I will take a stab at it... worked on several load balanced systems... -p -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 08:17 To: CF-Talk Subject: OT: Clustering I am curious if anyone has any notes and suggestions from the field regarding load balancing and most importantly fail over. I am not so interested in it from a CF perspective but moreso from a hardware / OS view. If anyone has any suggestions and comments I would appreciate it. Thanks, Neil ~~ 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: Is CF 5 ready for production?
I agree. I always prefer a fresh install over an upgrade. For something as major as installing a new application server package, I'd rebuild. :/ -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 8:52 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? hmm, well not much I can really say except adsvise not to upgrade, re-install if possible. Neil Team Macromedia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is CF 5 ready for production?
We were on a Dual 200 processer 400 Mz 0.5 GB Compaq proaliant We are now on a Dual p4 850 Mz 0.5 GB -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 1:50 PM To: CF-Talk Subject: RE: Is CF 5 ready for production? On 11/21/01, John McCosker penned: Our server didn't like it, pages took forever to load on occaissions, recieved a http 404 eventually. we had to upgrade servers. In saying that our server was ! The space shouldn't be a problem. I'm running dual PIII 533 Mz with 1 GB RAM. The server is a Dell 2400 less than 2 years old. That should be OK? The things were fine. You will need more space to install though, If I remember correctly it takes an extra 90Mb or so. Performance, I find it better. Thanks, -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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: Clustering
ok... we have done a Sun implementation using Cisco Local Director Product... using JSP/Java.. works fairly easily and has some stateful data exchange... all home rolled... the Cisco products are dated and expensive.. interface doesn't leave you warm and friendly feeling the cost is quite high... and support can be lacking... good if you want to be geeky and waste lots of time... too much of what we asked for was a let me check sort of workaround... We have two Hypeflow load balancing switches we utilize on occasion which are nice.. 15k per unit original price point... they never let us down... Experimenting with an appliance from Phobos... nice looking unit with 4 ports... and cross connect for interconnecting several of them... about a $3500 price point... KISS interface looks promising for small client work... I did a bunch of comparison shopping about 14 months ago of products... Like the looks of the F5 devices... they aren't cheap either...Foundry makes some nice gear and are originally switching people so they get the throughput and multiple interface and backplane piece real good... Cost is high like the rest... We checked out a piece of software from resonate... like a peer to peer distributed sort of system to control traffic redirection... was per server cost and there were some voids in places... seemed interesting enough... Me personally, I use a series of monitors internal and external to monitor things and send off notices if something goes offline... We have had 3 or front ends for a project running... nothing too big... when a bug or problem is/was detected we pull the DNS entry for the server from the available pool... if you are creative you can script things to edit the DNS entries in this case... of course our DNS servers have a 1 minute max lag time... which might not cut it for your product needs... Overall, the DNS solution I think is by far the best... unless you have a compelling story and a nice bankroll to throw at things... The Phobos unit is quit nice and performs well... its issue from my end is port density... Port density is big on my end as I typically wire boxes with quad cards to multiple switches.. lots of redundancy in the paths to avoid traffic or outage... -paris -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 08:58 To: CF-Talk Subject: Re: Clustering I would like to know what experiences you had with clustering and what you found to be most cost effective, in terms of price for the solution and TCO. Thanks, Neil - Original Message - From: Paris Lundis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 8:12 AM Subject: RE: Clustering give me a better idea of what your question is and I will take a stab at it... worked on several load balanced systems... -p -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 08:17 To: CF-Talk Subject: OT: Clustering I am curious if anyone has any notes and suggestions from the field regarding load balancing and most importantly fail over. I am not so interested in it from a CF perspective but moreso from a hardware / OS view. If anyone has any suggestions and comments I would appreciate it. Thanks, Neil ~~ 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: Is CF 5 ready for production?
We've had a very pleasant experience with CF 5 and currently have it installed on most of our production boxes. Make sure you download and install the various patches, however, that are available through the Allaire website. -S -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 9:08 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? We were on a Dual 200 processer 400 Mz 0.5 GB Compaq proaliant We are now on a Dual p4 850 Mz 0.5 GB -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 1:50 PM To: CF-Talk Subject: RE: Is CF 5 ready for production? On 11/21/01, John McCosker penned: Our server didn't like it, pages took forever to load on occaissions, recieved a http 404 eventually. we had to upgrade servers. In saying that our server was ! The space shouldn't be a problem. I'm running dual PIII 533 Mz with 1 GB RAM. The server is a Dell 2400 less than 2 years old. That should be OK? The things were fine. You will need more space to install though, If I remember correctly it takes an extra 90Mb or so. Performance, I find it better. Thanks, -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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
Any Oracle Experts on the List ???? Errors
Hi I am getting the following Oracle error message when trying to run the query below, any ideas on the possible cause would be most appreciated -- cfset MonthsToDisplay = 2 cfset BeginDate = #Month(now())#/1/#Year(now())# cfset EndDate = #Month(DateAdd(m, MonthsToDisplay,now()))#/#DaysInMonth(DateAdd(m, MonthsToDisplay,now()))#/#Year(DateAdd(m, MonthsToDisplay, now()))# cfquery name=getupcomingevents datasource=events SELECT eventid, eventdate, to_char(eventdate,'') AS eventYear, to_char(eventdate,'MM') AS eventMonth, longtitle, location FROM whatson WHERE eventdate BETWEEN trunc(#CreateODBCDate(BeginDate)#) AND trunc(#CreateODBCDate(EndDate)#) ORDER BY eventdate asc /cfquery - Error Occurred While Processing Request Error Diagnostic Information Oracle Error Code = 911 ORA-00911: invalid character The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (12:1) to (12:54). ~~ 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
Need a good next/previous tag
Trying to search through the allaire exchange (way too slow). Anyone have a link to an excellent and easy to implement next/previous tag for database records. thanks. daniel ~~ 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
Link to good Next/Previous Tag
http://www.johnstons.org/wdc/pub/cfusion/customtags/CF_PageThru/CF_PageT hru.html This is one I've used before, and it is pretty spiffy :) Try it out. -Gel ~~ 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: Need a good next/previous tag
this might work for you http://www.johnstons.org/wdc/pub/cfusion/customtags/CF_PageThru/CF_PageThru. html - Original Message - From: Daniel [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 8:26 AM Subject: Need a good next/previous tag Trying to search through the allaire exchange (way too slow). Anyone have a link to an excellent and easy to implement next/previous tag for database records. thanks. daniel ~~ 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
Table incrementally showing up
Well i've given up :) I have come to a determination that WHile the TABLE-layout w/COLGROUP etc etc works to incremently display tables on the fly I dont think it will work in a CFOUTPUT / cfloop with CF. And i dont see why it should nto since all data is put to the browser as HTML so who knows But i am going to use style sheets :) If i never look at another TRTD again it will be too soon lol Bill Wheatley Director of Development Certified Advanced ColdFusion 5 Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684 X303 ICQ: 417645 ~~ 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: Sorting Errors
I wrote a CFX a couple of years ago to solve this very problem (mixed alpha-numeric data that people want sorted in quasi-numeric order). C++, Windows only. Works in 4.5 but not tested in 5. Not appropriate for huge result sets. http://devex.allaire.com/developer/gallery/info.cfm?ID=44C48F77-35E9-11D4-83 D700508B94F85Amethod=Full -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 8:47 PM To: CF-Talk Subject: RE: Sorting Errors Opps, my mistake in explaining. ahh... some of the Lot#'s are... alphanumeric for example: 1 10-A 1000 101-B1C2a 201 21 and this should sort as... hummm... I'm not sure what I'm doing anymore... I have to give this more thought 1 10-A 21 101-B1C2a 201 1000 At 02:10 PM 11/21/01 +1300, you wrote: wouldn't it be better to have the LOT# field as int? -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 21 November 2001 2:02 p.m. To: CF-Talk Subject: Sorting Errors I have a problem that I have a solution to but would like to query the group to see if there is some more elegant solution. Simply Put, When using varchar(10) as a datatype, (for a LOT# field used in manufacturing), the typical number sequence sorts with values like 1000 above something like 101. Example: 1 10 1000 101 201 21 I just pad the left with blanks in the database so that it sorts like this. 1 10 21 101 201 1000 Is there some more elegant or more standard way that I should be using? Thanks to anyone who chimes in. ~~ 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: Any Oracle Experts on the List ???? Errors
Instead of building a string for your date and applying CreateODBCDate() to it, try building a CF Date object using CreateDate() and applying CreateODBCDate() to it. If I recall correctly, CreateODBCDate() works on a date object, not a string. --- [EMAIL PROTECTED] wrote: Hi I am getting the following Oracle error message when trying to run the query below, any ideas on the possible cause would be most appreciated -- cfset MonthsToDisplay = 2 cfset BeginDate = #Month(now())#/1/#Year(now())# cfset EndDate = #Month(DateAdd(m, MonthsToDisplay,now()))#/#DaysInMonth(DateAdd(m, MonthsToDisplay,now()))#/#Year(DateAdd(m, MonthsToDisplay, now()))# cfquery name=getupcomingevents datasource=events SELECT eventid, eventdate, to_char(eventdate,'') AS eventYear, to_char(eventdate,'MM') AS eventMonth, longtitle, location FROM whatson WHERE eventdate BETWEEN trunc(#CreateODBCDate(BeginDate)#) AND trunc(#CreateODBCDate(EndDate)#) ORDER BY eventdate asc /cfquery - Error Occurred While Processing Request Error Diagnostic Information Oracle Error Code = 911 ORA-00911: invalid character The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (12:1) to (12:54). = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is CF 5 ready for production?
What exactly is your problem with cfexecute? When I build internal programs, I use cfexecute pretty heavily, so I'm wondering what's going on. Jesse Noller Linux Fiend Macromedia Server Development [EMAIL PROTECTED] Give a man a fish, and he'll pester you to keep giving him fish. Teach a man to fish, and he'll pester you for better fishing theory. --Me, 2001 -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 8:37 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? So far the only problem I have no found a workaround for is CFexecute. I use it quite extensively here, and it does not work at all on CF 5. No one from Macromedia responds to my questions on it and I have yet to hear back from them when I reported it. If you don't use cfexecute I don't see there being an issue. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 8:06 AM To: CF-Talk Subject: Is CF 5 ready for production? Hi all. Other than a few Hot Fixes, I don't see any service packs available for CF 5.0. Are there any issues I should be aware of before upgrading from 4.51 on a production server? Would anyone suggest waiting for a SP if there is one forthcoming? Other than the extra features available, is there enough of a performance enhancement to justify upgrading (Pro, so it's only 650.00)? Has anyone hit any snags during the upgrade process that has caused downtime? Thanks for your time. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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: Is CF 5 ready for production?
Could you give me a sample of your systax, I use it here to send remote commands to my as/400, I don't change the syntax and it all just freezes. no error message, no timeout, it just sits there, there are a couple instances on the support forums of others having the exact same problem, http://forums.allaire.com/coldfusion/messageview.cfm?catid=15threadid=22542 7 http://forums.allaire.com/coldfusion/messageview.cfm?catid=7threadid=212367 highlight_key=ykeyword1=cfexecute Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 9:49 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? What exactly is your problem with cfexecute? When I build internal programs, I use cfexecute pretty heavily, so I'm wondering what's going on. Jesse Noller Linux Fiend Macromedia Server Development [EMAIL PROTECTED] Give a man a fish, and he'll pester you to keep giving him fish. Teach a man to fish, and he'll pester you for better fishing theory. --Me, 2001 -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 8:37 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? So far the only problem I have no found a workaround for is CFexecute. I use it quite extensively here, and it does not work at all on CF 5. No one from Macromedia responds to my questions on it and I have yet to hear back from them when I reported it. If you don't use cfexecute I don't see there being an issue. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 8:06 AM To: CF-Talk Subject: Is CF 5 ready for production? Hi all. Other than a few Hot Fixes, I don't see any service packs available for CF 5.0. Are there any issues I should be aware of before upgrading from 4.51 on a production server? Would anyone suggest waiting for a SP if there is one forthcoming? Other than the extra features available, is there enough of a performance enhancement to justify upgrading (Pro, so it's only 650.00)? Has anyone hit any snags during the upgrade process that has caused downtime? Thanks for your time. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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
OT - maximum files/folders in NTFS (Windows)
regarding Windows/NTFS: I know there is a maximum number of files that can exist within a single directory, but is there a maximum number of directories that can exist within a parent directory? -mike ~~ 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
Mulitple cookie domains and sessions
The previous developer coded our site around mydomain.com. The problem is is when people come to the site via www.mydomain.com. CF issues one set of cookies for www.mydomain.com, and then, as the system is processing their login, it sets cookies for mydomain.com. CF sees this as a new session, issuing a new CFID, and dropping all of the session variables that were created by their login. Is there a simple solution to force the two to be treated as the same cookie source? Or to force the www. appenders to go to the mydomain.com domain without a cookie being issued for the www. site? Lon Lentz Applications Developer and CyberEntomolgist http://ProofitOnline.Com - Free 15 Day Trial ~~ 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: Any Oracle Experts on the List ???? Errors
Do you have a code example of the process you have just specified? Would be appreciated, as my deadline is approaching fast!!! ~~ 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: Is CF 5 ready for production?
On 11/21/01, Neil Clark penned: hmm, well not much I can really say except adsvise not to upgrade, re-install if possible. Neil Team Macromedia Thanks Neil. Big help THAT was! LOL Is there some good documentation somewhere on the proper way to do that without destroying everything in the process? :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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: Need a good next/previous tag
On 11/21/01, Daniel penned: Trying to search through the allaire exchange (way too slow). Anyone have a link to an excellent and easy to implement next/previous tag for database records. Try my free cf_recordcount. Works on grouped output also. :) http://www.twcreations.com/cf.html -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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: Clustering
I have had success using Microsofts NLB. Now its not the greatest, but it works Its free and very easy to set up. This is of couse if you are using Microsoft. [EMAIL PROTECTED] 11/21/01 08:58AM I would like to know what experiences you had with clustering and what you found to be most cost effective, in terms of price for the solution and TCO. Thanks, Neil - Original Message - From: Paris Lundis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 8:12 AM Subject: RE: Clustering give me a better idea of what your question is and I will take a stab at it... worked on several load balanced systems... -p -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 08:17 To: CF-Talk Subject: OT: Clustering I am curious if anyone has any notes and suggestions from the field regarding load balancing and most importantly fail over. I am not so interested in it from a CF perspective but moreso from a hardware / OS view. If anyone has any suggestions and comments I would appreciate it. Thanks, Neil ~~ 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: Is CF 5 ready for production?
My understanding from our CFUG meeting last week is that there will be no service packs for CF 5. However, hotfixes will be released as necessary. Macromedia's logic behind this is that they feel CF 5 is a stable enough product that they'd rather have all of their developers focusing on Neo, rather than service packs for a code base that they are effectively abandoning. I should note that I wasn't at DevCon and I'm not in cahoots with anybody at Macromedia, so my info is strictly from my CFUG meeting. Performance-wise, I tend to be skeptical about white papers that claim my product is the fastest, especially when it's the product manufacturer's. However, I have seen several independent white papers around the net on CF 5 performance, and the conclusion has always been that there is a significant performance improvement. Apparently, when Win2K was released, the good folks at Microsoft didn't bother to tell their vendors that certain under the hood features were changed. This caused problems with CF on a Win2K platform. (If you've been using CF long enough, you might remember the endless threads about the nightmares of upgrading to CF on Win2K when Win2K was first released.) This has been resolved in CF 5. There were also some tweaks made to code that's been around since the first release of CF. Put those two fixes together, and you have most of your explanation as to why Macromedia is claiming to be upwards of 40% faster with CF 5 as opposed to 4. (The rest of the explanation, I'm sure, is to help market a product that most people aren't really sure they want with Neo on the horizon) One last thing to note while considering the upgrade. Another note that came out of the conference was that Macromedia will guarantee that any app running in CF 5 will work when Neo is released. While I don't understand why they wouldn't guarantee 4.5 as well (seeing as there hasn't been any significant changes in syntax, just added functionality), at least you'll be assured that your apps in 5 will smoothly upgrade when the time comes. Again, as a disclaimer, I was not at the conference and did not hear this directly from the horse's mouth. However, our last CFUG meeting here in New York was effectively a brain dump of DevCon, and these were the facts that I gathered. If anybody knows that anything I've written above might be misleading or just plain wrong, by all means please let me know. Hope this helps in your decision! Dave. ~~ 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: Need a good next/previous tag
On 11/21/01, Troy Montour penned: this might work for you http://www.johnstons.org/wdc/pub/cfusion/customtags/CF_PageThru/CF_PageThru. html The demo's broken: http://www.johnstons.org/products/search/search-t.cfm?CurrentPage=6 HTTP/1.0 404 Object Not Found -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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
Query Help
Ok.. why does it say this: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'Tickets' does not match with a table name or alias name used in the query. Query: SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered, Tickets.TicketStatus, Tickets.Priority, Users.FirstName, Users.LastName, Users.UserID, Techs.FirstName AS tfname, Techs.LastName AS tlname, Types.TypeValue FROM Tickets T, Users, Techs INNER JOIN Types ON TicketStatus = Types.TypeID WHERE Tickets.UserID = Users.UserID Thanks in advance... ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query Help
You gave table Tickets an alias of T, so you must use T as the table name. Either use T, or drop the alias (which you seem not to be using anyway). --- Ben -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:37 AM To: CF-Talk Subject: Query Help Ok.. why does it say this: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'Tickets' does not match with a table name or alias name used in the query. Query: SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered, Tickets.TicketStatus, Tickets.Priority, Users.FirstName, Users.LastName, Users.UserID, Techs.FirstName AS tfname, Techs.LastName AS tlname, Types.TypeValue FROM Tickets T, Users, Techs INNER JOIN Types ON TicketStatus = Types.TypeID WHERE Tickets.UserID = Users.UserID Thanks in advance... ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is CF 5 ready for production?
I use it by the book: cfset arguments=-c#concurrent# -u #site# -t#transactions# -d#delay# -l -m#CHR(34)##label##CHR(34)# CFEXECUTE NAME=/usr/local/bin/siege ARGUMENTS=#arguments# OUTPUTFILE=/var/www/html/siege/siege.foo TIMEOUT=999 /CFEXECUTE The same 'command' would be ran by calling it like: cfset arguments=-c#concurrent# -u #site# -t#transactions# -d#delay# -l -m#CHR(34)##label##CHR(34)# CFEXECUTE NAME=C:\siege\siege.exe ARGUMENTS=#arguments# OUTPUTFILE=C:\temp\siege.txt TIMEOUT=999 /CFEXECUTE It depends on the specific code being used. Jesse Noller Linux Fiend Macromedia Server Development [EMAIL PROTECTED] Give a man a fish, and he'll pester you to keep giving him fish. Teach a man to fish, and he'll pester you for better fishing theory. --Me, 2001 -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 9:52 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? Could you give me a sample of your systax, I use it here to send remote commands to my as/400, I don't change the syntax and it all just freezes. no error message, no timeout, it just sits there, there are a couple instances on the support forums of others having the exact same problem, http://forums.allaire.com/coldfusion/messageview.cfm?catid=15; threadid=22542 7 http://forums.allaire.com/coldfusion/messageview.cfm?catid=7t hreadid=212367 highlight_key=ykeyword1=cfexecute Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 9:49 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? What exactly is your problem with cfexecute? When I build internal programs, I use cfexecute pretty heavily, so I'm wondering what's going on. Jesse Noller Linux Fiend Macromedia Server Development [EMAIL PROTECTED] Give a man a fish, and he'll pester you to keep giving him fish. Teach a man to fish, and he'll pester you for better fishing theory. --Me, 2001 -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 8:37 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? So far the only problem I have no found a workaround for is CFexecute. I use it quite extensively here, and it does not work at all on CF 5. No one from Macromedia responds to my questions on it and I have yet to hear back from them when I reported it. If you don't use cfexecute I don't see there being an issue. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 8:06 AM To: CF-Talk Subject: Is CF 5 ready for production? Hi all. Other than a few Hot Fixes, I don't see any service packs available for CF 5.0. Are there any issues I should be aware of before upgrading from 4.51 on a production server? Would anyone suggest waiting for a SP if there is one forthcoming? Other than the extra features available, is there enough of a performance enhancement to justify upgrading (Pro, so it's only 650.00)? Has anyone hit any snags during the upgrade process that has caused downtime? Thanks for your time. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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: Query Help
Clint, Instead of Tickets.TicketID use T.TicketID or just get rid of the alias alltogether. It doesn't look like you really need it. Brian Ferrigno -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:37 AM To: CF-Talk Subject: Query Help Ok.. why does it say this: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'Tickets' does not match with a table name or alias name used in the query. Query: SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered, Tickets.TicketStatus, Tickets.Priority, Users.FirstName, Users.LastName, Users.UserID, Techs.FirstName AS tfname, Techs.LastName AS tlname, Types.TypeValue FROM Tickets T, Users, Techs INNER JOIN Types ON TicketStatus = Types.TypeID WHERE Tickets.UserID = Users.UserID Thanks in advance... ~~ 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: Query Help
Clint, In your FROM clause, you aliased the table to be T instead of Tickets. Therefore in your SELECT clause it should now read: SELECT T.TicketID, T.Problem, T.DateEntered, T.TicketStatus, T.Priority... And the WHERE clause should be: WHERE T.UserID = Users.UserID Good luck, Beau -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:37 AM To: CF-Talk Subject: Query Help Ok.. why does it say this: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'Tickets' does not match with a table name or alias name used in the query. Query: SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered, Tickets.TicketStatus, Tickets.Priority, Users.FirstName, Users.LastName, Users.UserID, Techs.FirstName AS tfname, Techs.LastName AS tlname, Types.TypeValue FROM Tickets T, Users, Techs INNER JOIN Types ON TicketStatus = Types.TypeID WHERE Tickets.UserID = Users.UserID Thanks in advance... ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query Help
Try this, SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered, Tickets.TicketStatus, Tickets.Priority, Users.FirstName, Users.LastName, Users.UserID, Techs.FirstName AS tfname, Techs.LastName AS tlname, Types.TypeValue FROM Tickets T, Users, Techs INNER JOIN Types ON (T.TicketStatus = Types.TypeID) WHERE T.UserID = Users.UserID I am assuming TicketStauts and TypeID are the same datatype. Mike -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:37 AM To: CF-Talk Subject: Query Help Ok.. why does it say this: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'Tickets' does not match with a table name or alias name used in the query. Query: SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered, Tickets.TicketStatus, Tickets.Priority, Users.FirstName, Users.LastName, Users.UserID, Techs.FirstName AS tfname, Techs.LastName AS tlname, Types.TypeValue FROM Tickets T, Users, Techs INNER JOIN Types ON TicketStatus = Types.TypeID WHERE Tickets.UserID = Users.UserID Thanks in advance... ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query Help
Ok.. why does it say this: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'Tickets' does not match with a table name or alias name used in the query. Query: SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered, Tickets.TicketStatus, Tickets.Priority, Users.FirstName, Users.LastName, Users.UserID, Techs.FirstName AS tfname, Techs.LastName AS tlname, Types.TypeValue !-check this line. looks like a comma missing between tickets and T --- FROM Tickets T, Users, Techs INNER JOIN Types ON TicketStatus = Types.TypeID WHERE Tickets.UserID = Users.UserID Regards, Dave ~~ 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: Query Help
Try this. SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered, Tickets.TicketStatus, Tickets.Priority, Users.FirstName, Users.LastName, Users.UserID, Techs.FirstName AS tfname, Techs.LastName AS tlname, Types.TypeValue FROM Tickets, Users, Techs INNER JOIN Types ON TicketStatus = Types.TypeID WHERE Tickets.UserID = Users.UserID -- Original Message -- From: Clint Tredway [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 21 Nov 2001 10:37:06 -0500 Ok.. why does it say this: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'Tickets' does not match with a table name or alias name used in the query. Query: SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered, Tickets.TicketStatus, Tickets.Priority, Users.FirstName, Users.LastName, Users.UserID, Techs.FirstName AS tfname, Techs.LastName AS tlname, Types.TypeValue FROM Tickets T, Users, Techs INNER JOIN Types ON TicketStatus = Types.TypeID WHERE Tickets.UserID = Users.UserID Thanks in advance... ~~ 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: Query Help
Doesn't this FROM Tickets T, Mean that in your SQL it should be reffered to as T ? -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: 21 November 2001 15:37 To: CF-Talk Subject: Query Help Ok.. why does it say this: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'Tickets' does not match with a table name or alias name used in the query. Query: SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered, Tickets.TicketStatus, Tickets.Priority, Users.FirstName, Users.LastName, Users.UserID, Techs.FirstName AS tfname, Techs.LastName AS tlname, Types.TypeValue FROM Tickets T, Users, Techs INNER JOIN Types ON TicketStatus = Types.TypeID WHERE Tickets.UserID = Users.UserID Thanks in advance... ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query Help
I must have overlooked that many times... Thanks Ben... -- Original Message -- from: Ben Forta [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Wed, 21 Nov 2001 10:34:54 -0500 You gave table Tickets an alias of T, so you must use T as the table name. Either use T, or drop the alias (which you seem not to be using anyway). --- Ben -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:37 AM To: CF-Talk Subject: Query Help Ok.. why does it say this: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'Tickets' does not match with a table name or alias name used in the query. Query: SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered, Tickets.TicketStatus, Tickets.Priority, Users.FirstName, Users.LastName, Users.UserID, Techs.FirstName AS tfname, Techs.LastName AS tlname, Types.TypeValue FROM Tickets T, Users, Techs INNER JOIN Types ON TicketStatus = Types.TypeID WHERE Tickets.UserID = Users.UserID Thanks in advance... ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is CF 5 ready for production?
Macromedia's logic behind this is that they feel CF 5 is a stable enough product that they'd rather have all of their developers focusing on Neo, rather than service packs for a code base that they are effectively abandoning. Sorry for this but, What exactly is Neo? Why is it called Neo? Who is behind Neo? (i.e. is it the same people behind CF) What happen's after CF5 (..gone forever..?) Could you define? code base that they are effectively abandoning jmc .. ~~ 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: Alter statement
Can anybody help me with an Alter statement in Access. I am trying to put a default date of 01/01/2000 in the database and anything I have tried has failed. Heres the code I've tried ALTER TABLE implementation ADD COLUMN #form.target_date# date default 01/01/2000 But it fails. Thanks in advance, Declan -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: 21 November 2001 15:38 To: CF-Talk Subject: Re: Query Help Try this. SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered, Tickets.TicketStatus, Tickets.Priority, Users.FirstName, Users.LastName, Users.UserID, Techs.FirstName AS tfname, Techs.LastName AS tlname, Types.TypeValue FROM Tickets, Users, Techs INNER JOIN Types ON TicketStatus = Types.TypeID WHERE Tickets.UserID = Users.UserID -- Original Message -- From: Clint Tredway [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 21 Nov 2001 10:37:06 -0500 Ok.. why does it say this: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'Tickets' does not match with a table name or alias name used in the query. Query: SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered, Tickets.TicketStatus, Tickets.Priority, Users.FirstName, Users.LastName, Users.UserID, Techs.FirstName AS tfname, Techs.LastName AS tlname, Types.TypeValue FROM Tickets T, Users, Techs INNER JOIN Types ON TicketStatus = Types.TypeID WHERE Tickets.UserID = Users.UserID Thanks in advance... ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query Help - Aliasing question
Hi all, Is it better to alias in SQL using the 'AS' operator, or simply by writing the alias name after the original table/field name? I have always aliased like this SELECT fieldname AS myfield, anotherfield whereas, I've noticed from this thread that I could use SELECT fieldname myfield, anotherfield to the same effect. Any comments? Dave -Original Message- From: Brian Ferrigno [mailto:[EMAIL PROTECTED]] Sent: 21 November 2001 15:38 To: CF-Talk Subject: RE: Query Help Clint, Instead of Tickets.TicketID use T.TicketID or just get rid of the alias alltogether. It doesn't look like you really need it. Brian Ferrigno -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:37 AM To: CF-Talk Subject: Query Help Ok.. why does it say this: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'Tickets' does not match with a table name or alias name used in the query. Query: SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered, Tickets.TicketStatus, Tickets.Priority, Users.FirstName, Users.LastName, Users.UserID, Techs.FirstName AS tfname, Techs.LastName AS tlname, Types.TypeValue FROM Tickets T, Users, Techs INNER JOIN Types ON TicketStatus = Types.TypeID WHERE Tickets.UserID = Users.UserID Thanks in advance... ~~ 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: Is CF 5 ready for production?
My understanding from our CFUG meeting last week is that there will be no service packs for CF 5. However, hotfixes will be released as necessary. Can't a service pack be viewed as a consolidated package of hotfixes? Sounds like buying eggs one by one IMHO. ~~ 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: Is CF 5 ready for production?
Afaik, neo is the code name for cf6. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 21 November 2001 15:35 To: CF-Talk Subject: RE: Is CF 5 ready for production? Macromedia's logic behind this is that they feel CF 5 is a stable enough product that they'd rather have all of their developers focusing on Neo, rather than service packs for a code base that they are effectively abandoning. Sorry for this but, What exactly is Neo? Why is it called Neo? Who is behind Neo? (i.e. is it the same people behind CF) What happen's after CF5 (..gone forever..?) Could you define? code base that they are effectively abandoning jmc . ~~ 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: Is CF 5 ready for production?
Check out macromedia.com they have a faq and mailing list on Neo. It the next CF release. J2EE compliant. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:35 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? Macromedia's logic behind this is that they feel CF 5 is a stable enough product that they'd rather have all of their developers focusing on Neo, rather than service packs for a code base that they are effectively abandoning. Sorry for this but, What exactly is Neo? Why is it called Neo? Who is behind Neo? (i.e. is it the same people behind CF) What happen's after CF5 (..gone forever..?) Could you define? code base that they are effectively abandoning jmc . ~~ 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: Is CF 5 ready for production?
Neo questions (most of them) can be answered by reading the neo pages on macromedia.com: http://www.macromedia.com/software/coldfusion/resources/neo/ Jesse Noller Linux Fiend Macromedia Server Development [EMAIL PROTECTED] Give a man a fish, and he'll pester you to keep giving him fish. Teach a man to fish, and he'll pester you for better fishing theory. --Me, 2001 -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:35 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? Macromedia's logic behind this is that they feel CF 5 is a stable enough product that they'd rather have all of their developers focusing on Neo, rather than service packs for a code base that they are effectively abandoning. Sorry for this but, What exactly is Neo? Why is it called Neo? Who is behind Neo? (i.e. is it the same people behind CF) What happen's after CF5 (..gone forever..?) Could you define? code base that they are effectively abandoning jmc .. ~~ 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: Is CF 5 ready for production?
I am trying to get this to work cfexecute name = C:\WinNT\System32\ipconfig.exe arguments = /all outputFile = C:\output.txt timeout = 1 /cfexecute Example from cfdocs, sometimes I can get it to work, then the other times I keep getting this messge Error Occurred While Processing Request Error Diagnostic Information unknown exception condition unknown error while executing a tag. Date/Time: 11/21/01 10:52:44 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) Remote Address: 127.0.0.1 Can anyone else run this test, I am running on a fresh install of CF 5 and IIS 5 on windows 2000 Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:36 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? I use it by the book: cfset arguments=-c#concurrent# -u #site# -t#transactions# -d#delay# -l -m#CHR(34)##label##CHR(34)# CFEXECUTE NAME=/usr/local/bin/siege ARGUMENTS=#arguments# OUTPUTFILE=/var/www/html/siege/siege.foo TIMEOUT=999 /CFEXECUTE The same 'command' would be ran by calling it like: cfset arguments=-c#concurrent# -u #site# -t#transactions# -d#delay# -l -m#CHR(34)##label##CHR(34)# CFEXECUTE NAME=C:\siege\siege.exe ARGUMENTS=#arguments# OUTPUTFILE=C:\temp\siege.txt TIMEOUT=999 /CFEXECUTE It depends on the specific code being used. Jesse Noller Linux Fiend Macromedia Server Development [EMAIL PROTECTED] Give a man a fish, and he'll pester you to keep giving him fish. Teach a man to fish, and he'll pester you for better fishing theory. --Me, 2001 -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 9:52 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? Could you give me a sample of your systax, I use it here to send remote commands to my as/400, I don't change the syntax and it all just freezes. no error message, no timeout, it just sits there, there are a couple instances on the support forums of others having the exact same problem, http://forums.allaire.com/coldfusion/messageview.cfm?catid=15; threadid=22542 7 http://forums.allaire.com/coldfusion/messageview.cfm?catid=7t hreadid=212367 highlight_key=ykeyword1=cfexecute Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 9:49 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? What exactly is your problem with cfexecute? When I build internal programs, I use cfexecute pretty heavily, so I'm wondering what's going on. Jesse Noller Linux Fiend Macromedia Server Development [EMAIL PROTECTED] Give a man a fish, and he'll pester you to keep giving him fish. Teach a man to fish, and he'll pester you for better fishing theory. --Me, 2001 -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 8:37 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? So far the only problem I have no found a workaround for is CFexecute. I use it quite extensively here, and it does not work at all on CF 5. No one from Macromedia responds to my questions on it and I have yet to hear back from them when I reported it. If you don't use cfexecute I don't see there being an issue. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 8:06 AM To: CF-Talk Subject: Is CF 5 ready for production? Hi all. Other than a few Hot Fixes, I don't see any service packs available for CF 5.0. Are there any issues I should be aware of before upgrading from 4.51 on a production server? Would anyone suggest waiting for a SP if there is one forthcoming? Other than the extra features available, is there enough of a performance enhancement to justify upgrading (Pro, so it's only 650.00)? Has anyone hit any snags during the upgrade process that has caused downtime? Thanks for your time. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is CF 5 ready for production?
Here's Macromedia's scoop on Neo. http://www.macromedia.com/software/coldfusion/resources/neo/ EC -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:35 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? Macromedia's logic behind this is that they feel CF 5 is a stable enough product that they'd rather have all of their developers focusing on Neo, rather than service packs for a code base that they are effectively abandoning. Sorry for this but, What exactly is Neo? Why is it called Neo? Who is behind Neo? (i.e. is it the same people behind CF) What happen's after CF5 (..gone forever..?) Could you define? code base that they are effectively abandoning jmc . ~~ 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: Is CF 5 ready for production?
Thanks everyone. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is CF 5 ready for production?
1. Neo is the next release of ColdFusion, where Macromedia will be re-writing the CF engine from C++ to Java. To save you the question, you will not have to learn Java to use Neo. It will still be the same tag-based language you use today. However, to extend CF (i.e., custom tags, etc.), a knowledge of Java would benefit. 2. Why is it called Neo? I would guess two reasons. First, because neo means new and this product will be a new direction, even though it's still CF. Second, I also think it's because someone at Macromedia has a fetish with The Matrix. Just to clarify that point, their next suite of tools is called Trinity, so put that with Neo and you have somebody who needs to get out more. 3. Macromedia (who bought Allaire) is behind the product. 4. As you can tell by the previous answers, CF isn't going anywhere. In fact, I firmly believe it's going to be a viable alternative to .NET and other platforms, assuming Macromedia delivers on the features it's been touting for the last year or so. Hope this helps, Dave. Original Message Follows From: John McCosker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Is CF 5 ready for production? Date: Wed, 21 Nov 2001 15:34:45 - Macromedia's logic behind this is that they feel CF 5 is a stable enough product that they'd rather have all of their developers focusing on Neo, rather than service packs for a code base that they are effectively abandoning. Sorry for this but, What exactly is Neo? Why is it called Neo? Who is behind Neo? (i.e. is it the same people behind CF) What happen's after CF5 (..gone forever..?) Could you define? code base that they are effectively abandoning jmc . ~~ 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: Is CF 5 ready for production?
Hey! I like our codenames... (Except I'm not allowed to name things after anime characters...) Jesse Noller Linux Fiend Macromedia Server Development [EMAIL PROTECTED] Give a man a fish, and he'll pester you to keep giving him fish. Teach a man to fish, and he'll pester you for better fishing theory. --Me, 2001 -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:55 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? 1. Neo is the next release of ColdFusion, where Macromedia will be re-writing the CF engine from C++ to Java. To save you the question, you will not have to learn Java to use Neo. It will still be the same tag-based language you use today. However, to extend CF (i.e., custom tags, etc.), a knowledge of Java would benefit. 2. Why is it called Neo? I would guess two reasons. First, because neo means new and this product will be a new direction, even though it's still CF. Second, I also think it's because someone at Macromedia has a fetish with The Matrix. Just to clarify that point, their next suite of tools is called Trinity, so put that with Neo and you have somebody who needs to get out more. 3. Macromedia (who bought Allaire) is behind the product. 4. As you can tell by the previous answers, CF isn't going anywhere. In fact, I firmly believe it's going to be a viable alternative to .NET and other platforms, assuming Macromedia delivers on the features it's been touting for the last year or so. Hope this helps, Dave. Original Message Follows From: John McCosker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Is CF 5 ready for production? Date: Wed, 21 Nov 2001 15:34:45 - Macromedia's logic behind this is that they feel CF 5 is a stable enough product that they'd rather have all of their developers focusing on Neo, rather than service packs for a code base that they are effectively abandoning. Sorry for this but, What exactly is Neo? Why is it called Neo? Who is behind Neo? (i.e. is it the same people behind CF) What happen's after CF5 (..gone forever..?) Could you define? code base that they are effectively abandoning jmc . ~~ 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: Is CF 5 ready for production?
I figured this one out, it was the arguments variable, it messed it up, how did you get it to work Jesse? Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:47 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? I am trying to get this to work cfexecute name = C:\WinNT\System32\ipconfig.exe arguments = /all outputFile = C:\output.txt timeout = 1 /cfexecute Example from cfdocs, sometimes I can get it to work, then the other times I keep getting this messge Error Occurred While Processing Request Error Diagnostic Information unknown exception condition unknown error while executing a tag. Date/Time: 11/21/01 10:52:44 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) Remote Address: 127.0.0.1 Can anyone else run this test, I am running on a fresh install of CF 5 and IIS 5 on windows 2000 Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:36 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? I use it by the book: cfset arguments=-c#concurrent# -u #site# -t#transactions# -d#delay# -l -m#CHR(34)##label##CHR(34)# CFEXECUTE NAME=/usr/local/bin/siege ARGUMENTS=#arguments# OUTPUTFILE=/var/www/html/siege/siege.foo TIMEOUT=999 /CFEXECUTE The same 'command' would be ran by calling it like: cfset arguments=-c#concurrent# -u #site# -t#transactions# -d#delay# -l -m#CHR(34)##label##CHR(34)# CFEXECUTE NAME=C:\siege\siege.exe ARGUMENTS=#arguments# OUTPUTFILE=C:\temp\siege.txt TIMEOUT=999 /CFEXECUTE It depends on the specific code being used. Jesse Noller Linux Fiend Macromedia Server Development [EMAIL PROTECTED] Give a man a fish, and he'll pester you to keep giving him fish. Teach a man to fish, and he'll pester you for better fishing theory. --Me, 2001 -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 9:52 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? Could you give me a sample of your systax, I use it here to send remote commands to my as/400, I don't change the syntax and it all just freezes. no error message, no timeout, it just sits there, there are a couple instances on the support forums of others having the exact same problem, http://forums.allaire.com/coldfusion/messageview.cfm?catid=15; threadid=22542 7 http://forums.allaire.com/coldfusion/messageview.cfm?catid=7t hreadid=212367 highlight_key=ykeyword1=cfexecute Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 9:49 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? What exactly is your problem with cfexecute? When I build internal programs, I use cfexecute pretty heavily, so I'm wondering what's going on. Jesse Noller Linux Fiend Macromedia Server Development [EMAIL PROTECTED] Give a man a fish, and he'll pester you to keep giving him fish. Teach a man to fish, and he'll pester you for better fishing theory. --Me, 2001 -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 8:37 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? So far the only problem I have no found a workaround for is CFexecute. I use it quite extensively here, and it does not work at all on CF 5. No one from Macromedia responds to my questions on it and I have yet to hear back from them when I reported it. If you don't use cfexecute I don't see there being an issue. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 8:06 AM To: CF-Talk Subject: Is CF 5 ready for production? Hi all. Other than a few Hot Fixes, I don't see any service packs available for CF 5.0. Are there any issues I should be aware of before upgrading from 4.51 on a production server? Would anyone suggest waiting for a SP if there is one forthcoming? Other than the extra features available, is there enough of a performance enhancement to justify upgrading (Pro, so it's only 650.00)? Has anyone hit any snags during the upgrade process that has caused downtime? Thanks for your time. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ Structure your ColdFusion code
Re: Clustering
I am using Microsoft and it looks like I am going to give that a shot. I think the question I have now is there is something referred to as a cluster adapter. I have two Nics in the machine, an Internal and an External so I don't think it is clear which NIC would be designated as that cluster adapter. Thanks, Neil - Original Message - From: Michael Ross [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 10:19 AM Subject: Re: Clustering I have had success using Microsofts NLB. Now its not the greatest, but it works Its free and very easy to set up. This is of couse if you are using Microsoft. [EMAIL PROTECTED] 11/21/01 08:58AM I would like to know what experiences you had with clustering and what you found to be most cost effective, in terms of price for the solution and TCO. Thanks, Neil - Original Message - From: Paris Lundis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 8:12 AM Subject: RE: Clustering give me a better idea of what your question is and I will take a stab at it... worked on several load balanced systems... -p -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 08:17 To: CF-Talk Subject: OT: Clustering I am curious if anyone has any notes and suggestions from the field regarding load balancing and most importantly fail over. I am not so interested in it from a CF perspective but moreso from a hardware / OS view. If anyone has any suggestions and comments I would appreciate it. Thanks, Neil ~~ 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: WDDX Error
You could try using the XMLFormat() function on whatever it is you are trying to serialize. It appears you are trying to serialise HTML content, have you tried to delimit the content before seriliazing? Neil Team Macromedia ~~ 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: Is CF 5 ready for production?
I found that the code worked fine when I increased the timeout value. Kristine C. Hege [EMAIL PROTECTED] Database Applications SpecialistPhone: (802) 463-2111 SoVerNet Inc. Ext: 105 5 Rockingham St. Bellows Falls, VT 05101 -- _ .. . - . PROGRAM (PRO'-gram') [n] A magic spell cast over a |C_.|.:' .:. . computer allowing it to turn one's input into error __||__ `:. O_/ messages.[vi] To engage in a pastime similar to | __--| \/M banging one's head against a wall, but, with fewer `-/..\-' _/ \_ opportunities for reward. `' On Wed, 21 Nov 2001, Robert Everland wrote: I figured this one out, it was the arguments variable, it messed it up, how did you get it to work Jesse? Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:47 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? I am trying to get this to work cfexecute name = C:\WinNT\System32\ipconfig.exe arguments = /all outputFile = C:\output.txt timeout = 1 /cfexecute Example from cfdocs, sometimes I can get it to work, then the other times I keep getting this messge Error Occurred While Processing Request Error Diagnostic Information unknown exception condition unknown error while executing a tag. Date/Time: 11/21/01 10:52:44 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) Remote Address: 127.0.0.1 Can anyone else run this test, I am running on a fresh install of CF 5 and IIS 5 on windows 2000 Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:36 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? I use it by the book: cfset arguments=-c#concurrent# -u #site# -t#transactions# -d#delay# -l -m#CHR(34)##label##CHR(34)# CFEXECUTE NAME=/usr/local/bin/siege ARGUMENTS=#arguments# OUTPUTFILE=/var/www/html/siege/siege.foo TIMEOUT=999 /CFEXECUTE The same 'command' would be ran by calling it like: cfset arguments=-c#concurrent# -u #site# -t#transactions# -d#delay# -l -m#CHR(34)##label##CHR(34)# CFEXECUTE NAME=C:\siege\siege.exe ARGUMENTS=#arguments# OUTPUTFILE=C:\temp\siege.txt TIMEOUT=999 /CFEXECUTE It depends on the specific code being used. Jesse Noller Linux Fiend Macromedia Server Development [EMAIL PROTECTED] Give a man a fish, and he'll pester you to keep giving him fish. Teach a man to fish, and he'll pester you for better fishing theory. --Me, 2001 -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 9:52 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? Could you give me a sample of your systax, I use it here to send remote commands to my as/400, I don't change the syntax and it all just freezes. no error message, no timeout, it just sits there, there are a couple instances on the support forums of others having the exact same problem, http://forums.allaire.com/coldfusion/messageview.cfm?catid=15; threadid=22542 7 http://forums.allaire.com/coldfusion/messageview.cfm?catid=7t hreadid=212367 highlight_key=ykeyword1=cfexecute Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 9:49 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? What exactly is your problem with cfexecute? When I build internal programs, I use cfexecute pretty heavily, so I'm wondering what's going on. Jesse Noller Linux Fiend Macromedia Server Development [EMAIL PROTECTED] Give a man a fish, and he'll pester you to keep giving him fish. Teach a man to fish, and he'll pester you for better fishing theory. --Me, 2001 -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 8:37 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? So far the only problem I have no found a workaround for is CFexecute. I use it quite extensively here, and it does not work at all on CF 5. No one from Macromedia responds to my questions on it and I have yet to hear back from them when I reported it. If you don't use cfexecute I don't see there being an issue. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original
RE: Is CF 5 ready for production?
Sorry I forgot, you have to add this to the top of the code, I was using arguments variable like Jesse suggested, and it didn't work. cfset arguments = /all cfexecute name = C:\WinNT\System32\ipconfig.exe arguments = #arguments# outputFile = C:\output.txt timeout = 1 /cfexecute Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 11:23 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? I found that the code worked fine when I increased the timeout value. Kristine C. Hege [EMAIL PROTECTED] Database Applications SpecialistPhone: (802) 463-2111 SoVerNet Inc. Ext: 105 5 Rockingham St. Bellows Falls, VT 05101 -- _ .. . - . PROGRAM (PRO'-gram') [n] A magic spell cast over a |C_.|.:' .:. . computer allowing it to turn one's input into error __||__ `:. O_/ messages.[vi] To engage in a pastime similar to | __--| \/M banging one's head against a wall, but, with fewer `-/..\-' _/ \_ opportunities for reward. `' On Wed, 21 Nov 2001, Robert Everland wrote: I figured this one out, it was the arguments variable, it messed it up, how did you get it to work Jesse? Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:47 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? I am trying to get this to work cfexecute name = C:\WinNT\System32\ipconfig.exe arguments = /all outputFile = C:\output.txt timeout = 1 /cfexecute Example from cfdocs, sometimes I can get it to work, then the other times I keep getting this messge Error Occurred While Processing Request Error Diagnostic Information unknown exception condition unknown error while executing a tag. Date/Time: 11/21/01 10:52:44 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) Remote Address: 127.0.0.1 Can anyone else run this test, I am running on a fresh install of CF 5 and IIS 5 on windows 2000 Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:36 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? I use it by the book: cfset arguments=-c#concurrent# -u #site# -t#transactions# -d#delay# -l -m#CHR(34)##label##CHR(34)# CFEXECUTE NAME=/usr/local/bin/siege ARGUMENTS=#arguments# OUTPUTFILE=/var/www/html/siege/siege.foo TIMEOUT=999 /CFEXECUTE The same 'command' would be ran by calling it like: cfset arguments=-c#concurrent# -u #site# -t#transactions# -d#delay# -l -m#CHR(34)##label##CHR(34)# CFEXECUTE NAME=C:\siege\siege.exe ARGUMENTS=#arguments# OUTPUTFILE=C:\temp\siege.txt TIMEOUT=999 /CFEXECUTE It depends on the specific code being used. Jesse Noller Linux Fiend Macromedia Server Development [EMAIL PROTECTED] Give a man a fish, and he'll pester you to keep giving him fish. Teach a man to fish, and he'll pester you for better fishing theory. --Me, 2001 -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 9:52 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? Could you give me a sample of your systax, I use it here to send remote commands to my as/400, I don't change the syntax and it all just freezes. no error message, no timeout, it just sits there, there are a couple instances on the support forums of others having the exact same problem, http://forums.allaire.com/coldfusion/messageview.cfm?catid=15; threadid=22542 7 http://forums.allaire.com/coldfusion/messageview.cfm?catid=7t hreadid=212367 highlight_key=ykeyword1=cfexecute Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 9:49 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? What exactly is your problem with cfexecute? When I build internal programs, I use cfexecute pretty heavily, so I'm wondering what's going on. Jesse Noller Linux Fiend Macromedia Server Development [EMAIL PROTECTED] Give a man a fish, and he'll pester you to keep giving him fish. Teach a man to fish, and he'll pester you for better fishing theory. --Me, 2001 -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday,
RE: Is CF 5 ready for production?
Sorry I forgot, you have to add this to the top of the code, I was using arguments variable like Jesse suggested, and it didn't work. cfset arguments = /all cfexecute name = C:\WinNT\System32\ipconfig.exe arguments = #arguments# outputFile = C:\output.txt timeout = 1 /cfexecute Should look like: cfset arguments=/all CFEXECUTE NAME=C:\WinNT\System32\ipconfig.exe ARGUMENTS=#arguments# OUTPUTFILE=C:\output.txt TIMEOUT=10 ~~ 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: Is CF 5 ready for production?
Er... Dangit forgot the closing /cfexecute Jesse Noller Linux Fiend Macromedia Server Development [EMAIL PROTECTED] Give a man a fish, and he'll pester you to keep giving him fish. Teach a man to fish, and he'll pester you for better fishing theory. --Me, 2001 -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 11:36 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? Sorry I forgot, you have to add this to the top of the code, I was using arguments variable like Jesse suggested, and it didn't work. cfset arguments = /all cfexecute name = C:\WinNT\System32\ipconfig.exe arguments = #arguments# outputFile = C:\output.txt timeout = 1 /cfexecute Should look like: cfset arguments=/all CFEXECUTE NAME=C:\WinNT\System32\ipconfig.exe ARGUMENTS=#arguments# OUTPUTFILE=C:\output.txt TIMEOUT=10 ~~ 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: Is CF 5 ready for production?
That didn't matter, I think there is a problem when using a variable called arguments, it didn't matter if I had quotes or no quotes it gave that error, but no less it worked, I will be trying my remote command when the AS/400 guy gets back here. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 11:38 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? Er... Dangit forgot the closing /cfexecute Jesse Noller Linux Fiend Macromedia Server Development [EMAIL PROTECTED] Give a man a fish, and he'll pester you to keep giving him fish. Teach a man to fish, and he'll pester you for better fishing theory. --Me, 2001 -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 11:36 AM To: CF-Talk Subject: RE: Is CF 5 ready for production? Sorry I forgot, you have to add this to the top of the code, I was using arguments variable like Jesse suggested, and it didn't work. cfset arguments = /all cfexecute name = C:\WinNT\System32\ipconfig.exe arguments = #arguments# outputFile = C:\output.txt timeout = 1 /cfexecute Should look like: cfset arguments=/all CFEXECUTE NAME=C:\WinNT\System32\ipconfig.exe ARGUMENTS=#arguments# OUTPUTFILE=C:\output.txt TIMEOUT=10 ~~ 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: Is CF 5 ready for production?
One note of which to be aware, there was a change in the way that cf_execute handles standard output and error redirection. I seem to recall the change was that it now matches the way the tag was documented for the past year. -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. ~~ 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
Netscape Object Moved problem
Hey all, I have a site that's using a bastardized version of Fusebox, but follows the general method of having a central fusebox page and multiple fuseactions in a switch statement. Everything works fine in IE, but when I bring up index.cfm?fuseaction=display more than once in Netscape (versions 4.73 and 4.76) I consistently get an Object Moved, This document may be found here error for every page I try to bring up. When I click on the link to where the object has moved to, it works fine. Any ideas? I've tried putting in meta content-type, expires, and pragma no-cache tags and still no dice. I have a sneaking suspicion that this has to do with CFLOCATION and am going to play around with headers now... ~~ 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: Any Oracle Experts on the List ???? Errors
TRY: WHERE trunc(eventdate) BETWEEN TO_DATE('#DateFormat(variables.Begindate,dd/mm/)#','DD/MM/') AND TO_DATE('#DateFormat(variables.Enddate,dd/mm/)#','DD/MM/') OR you can use 'MM/DD/' as formatting mask if you prefer Pascal -Original Message- From: [EMAIL PROTECTED] Sent: wo 21-11-2001 15:29 To: CF-Talk Cc: Subject: Any Oracle Experts on the List Errors Hi I am getting the following Oracle error message when trying to run the query below, any ideas on the possible cause would be most appreciated -- cfset MonthsToDisplay = 2 cfset BeginDate = #Month(now())#/1/#Year(now())# cfset EndDate = #Month(DateAdd(m, MonthsToDisplay,now()))#/#DaysInMonth(DateAdd(m, MonthsToDisplay,now()))#/#Year(DateAdd(m, MonthsToDisplay, now()))# cfquery name=getupcomingevents datasource=events SELECT eventid, eventdate, to_char(eventdate,'') AS eventYear, to_char(eventdate,'MM') AS eventMonth, longtitle, location FROM whatson WHERE eventdate BETWEEN trunc(#CreateODBCDate(BeginDate)#) AND trunc(#CreateODBCDate(EndDate)#) ORDER BY eventdate asc /cfquery - Error Occurred While Processing Request Error Diagnostic Information Oracle Error Code = 911 ORA-00911: invalid character The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (12:1) to (12:54). ~~ 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: Netscape Object Moved problem
It is because of what CFLocation does. Netscape follows the standard to a T and IE does not. CFLocation issues a response code of 403 Object Moved. The browser is supposed to resend the original request to the new page. Netscape resends all of you form data to the new page. IE Does not do this. In all actuality Netscape is working correctly IE is not. At 11:47 AM 11/21/2001 -0500, you wrote: Hey all, I have a site that's using a bastardized version of Fusebox, but follows the general method of having a central fusebox page and multiple fuseactions in a switch statement. Everything works fine in IE, but when I bring up index.cfm?fuseaction=display more than once in Netscape (versions 4.73 and 4.76) I consistently get an Object Moved, This document may be found here error for every page I try to bring up. When I click on the link to where the object has moved to, it works fine. Any ideas? I've tried putting in meta content-type, expires, and pragma no-cache tags and still no dice. I have a sneaking suspicion that this has to do with CFLOCATION and am going to play around with headers now... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is CF 5 ready for production?
2. Why is it called Neo? I would guess two reasons. First, because neo means new and this product will be a new direction, even though it's still CF. Second, I also think it's because someone at Macromedia has a fetish with The Matrix. Just to clarify that point, their next suite of tools is called Trinity, so put that with Neo and you have somebody who needs to get out more. Frankly, for something as big CF 6, I'd rather have people in charge who ~~ 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
CF 5 Upgrade Logistics
Hi All, We are planning to upgrade our server (hardware, software, the works) and had a question about the CF 5 Upgrade (from 4.01). To eliminate down time on the domains we planned to build a new box, install Win2K server, install all purchased upgraded software using fresh installs and over a period of a week or so run both boxes as we move each domain to the new box. This will reduce downtime and allow us the ability to correct some configuration issues. My question is this: If we purchase the CF 5 upgrade version do we actually have to first install 4.01 on the new box before we can upgrade CF. Or will the installation request the 4.01 CD to verify that the installation is legitimate? What exactly is the process the upgrade takes? On any rebuild we always prefer to install fresh and didn't know if we needed to purchase a new copy or the upgrade version. Best regards, Dennis Powers UXB Internet (203)879-2844 http://www.uxbinfo.com/ ~~ 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: Netscape Object Moved problem
So is the only way around this to do a CFHEADER instead of a CFLOCATION? The solution I ended up going with was replacing my CFLocation with CFHEADER Name=Refresh Value=0; URL=Index.cfm?FuseAction=Display -Original Message- From: Nick McClure [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 11:54 AM To: CF-Talk Subject: Re: Netscape Object Moved problem It is because of what CFLocation does. Netscape follows the standard to a T and IE does not. CFLocation issues a response code of 403 Object Moved. The browser is supposed to resend the original request to the new page. Netscape resends all of you form data to the new page. IE Does not do this. In all actuality Netscape is working correctly IE is not. At 11:47 AM 11/21/2001 -0500, you wrote: Hey all, I have a site that's using a bastardized version of Fusebox, but follows the general method of having a central fusebox page and multiple fuseactions in a switch statement. Everything works fine in IE, but when I bring up index.cfm?fuseaction=display more than once in Netscape (versions 4.73 and 4.76) I consistently get an Object Moved, This document may be found here error for every page I try to bring up. When I click on the link to where the object has moved to, it works fine. Any ideas? I've tried putting in meta content-type, expires, and pragma no-cache tags and still no dice. I have a sneaking suspicion that this has to do with CFLOCATION and am going to play around with headers now... ~~ 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
CF_Forum Source
I thought that I had seen a thread quite a while ago about an Open Source CF Forum Can anyone tell me where I can get this code or was I seeing things? Thanks In Advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [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_Forum Source
www.cfcode.com - forum is great and you can buy the open source. Tony Gruen www.globalassault.com -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 9:09 AM To: CF-Talk Subject: CF_Forum Source I thought that I had seen a thread quite a while ago about an Open Source CF Forum Can anyone tell me where I can get this code or was I seeing things? Thanks In Advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF_Forum Source
that sounds like an oxymoron'you can BUY the open source' happy thanksgiving. Timothy Stadinski Senior Software Engineer Afternic.com -Original Message- From: Tony Gruen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 12:15 PM To: CF-Talk Subject: RE: CF_Forum Source www.cfcode.com - forum is great and you can buy the open source. Tony Gruen www.globalassault.com -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 9:09 AM To: CF-Talk Subject: CF_Forum Source I thought that I had seen a thread quite a while ago about an Open Source CF Forum Can anyone tell me where I can get this code or was I seeing things? Thanks In Advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [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: Netscape Object Moved problem
You could do this. The way I got around it was by using includes instead of locations. The reason CFHEADER might not work for you, is because it is not immediate. It will not take effect until the page is completed. CFLocation stops the page where it is at. If you do the CFHeader and then do a cfabort it would work. At 12:02 PM 11/21/2001 -0500, you wrote: So is the only way around this to do a CFHEADER instead of a CFLOCATION? The solution I ended up going with was replacing my CFLocation with CFHEADER Name=Refresh Value=0; URL=Index.cfm?FuseAction=Display -Original Message- From: Nick McClure [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 11:54 AM To: CF-Talk Subject: Re: Netscape Object Moved problem It is because of what CFLocation does. Netscape follows the standard to a T and IE does not. CFLocation issues a response code of 403 Object Moved. The browser is supposed to resend the original request to the new page. Netscape resends all of you form data to the new page. IE Does not do this. In all actuality Netscape is working correctly IE is not. At 11:47 AM 11/21/2001 -0500, you wrote: Hey all, I have a site that's using a bastardized version of Fusebox, but follows the general method of having a central fusebox page and multiple fuseactions in a switch statement. Everything works fine in IE, but when I bring up index.cfm?fuseaction=display more than once in Netscape (versions 4.73 and 4.76) I consistently get an Object Moved, This document may be found here error for every page I try to bring up. When I click on the link to where the object has moved to, it works fine. Any ideas? I've tried putting in meta content-type, expires, and pragma no-cache tags and still no dice. I have a sneaking suspicion that this has to do with CFLOCATION and am going to play around with headers now... ~~ 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: Netscape Object Moved problem
Because of this problem and the fact that you cant set cookies with cflocation there are a numbser of replacements available in the tag gallery: http://devex.allaire.com/developer/gallery/SearchResults.cfm?keywords=cf_loc ation HTH Kola Oyedeji |Web Developer |ekeda elthorne gate |64 high street |pinner |middx |ha55qa t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk -Original Message- From: Robyn Follen [mailto:[EMAIL PROTECTED]] Sent: 21 November 2001 16:47 To: CF-Talk Subject: Netscape Object Moved problem Hey all, I have a site that's using a bastardized version of Fusebox, but follows the general method of having a central fusebox page and multiple fuseactions in a switch statement. Everything works fine in IE, but when I bring up index.cfm?fuseaction=display more than once in Netscape (versions 4.73 and 4.76) I consistently get an Object Moved, This document may be found here error for every page I try to bring up. When I click on the link to where the object has moved to, it works fine. Any ideas? I've tried putting in meta content-type, expires, and pragma no-cache tags and still no dice. I have a sneaking suspicion that this has to do with CFLOCATION and am going to play around with headers now... ~~ 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: CF_Forum Source
Simple Message Board is open source. The original Allaire forum is open source also (forumspot.org methinks). simplemessageboard.com is down right but if anyone needs a release, just send me an email. I thought that I had seen a thread quite a while ago about an Open Source CF Forum Can anyone tell me where I can get this code or was I seeing things? Thanks In Advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [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: CF_Forum Source
your right - that is dOH!, cfreplace'open source','un-encrypted'/cfreplace :-) -Original Message- From: Tim Stadinski [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 9:15 AM To: CF-Talk Subject: RE: CF_Forum Source that sounds like an oxymoron'you can BUY the open source' happy thanksgiving. Timothy Stadinski Senior Software Engineer Afternic.com -Original Message- From: Tony Gruen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 12:15 PM To: CF-Talk Subject: RE: CF_Forum Source www.cfcode.com - forum is great and you can buy the open source. Tony Gruen www.globalassault.com -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 9:09 AM To: CF-Talk Subject: CF_Forum Source I thought that I had seen a thread quite a while ago about an Open Source CF Forum Can anyone tell me where I can get this code or was I seeing things? Thanks In Advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [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: CF_Forum Source
that sounds like an oxymoron'you can BUY the open source' Open Source != Free :) -Ron Ron Hornbaker President/CTO . . . . . . . . . . . . http://humankindsystems.com . . . . . . . . . . . . w e c o d e. w e c a r e. . http://AnswerTrack.com - eCRM email tracking solution ~~ 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 Upgrade Logistics
You can do a new install with an upgrade registration key. As soon as you've entered the key, the installer recognizes it as an upgrade license and asks for a key from CF4.x. Just enter the old key and you're off. On a related note... I wanted to upgrade a CF4.01 server directly to CF5, but the install wouldn't let me. The only way to do it, without -un-installing CF4 first, was to do a quick upgrade to CF4.5 (first time I'd even broken the shrink-wrap on the 4.5 package), then to CF5. Kind of a pain in the ass, but at least it carried over all the settings. The only thing that didn't quite transfer right were the CFX tags. They all transfered and functioned as expected, but we lost the ability to edit them in the CF Administrator (it doesn't create a link to the tag). So one-by-one I deleted and reinstalled each CFX. Not too big a deal. The upgraded server has been running beautifully ever since. Jim - Original Message - From: Dennis Powers [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 10:02 AM Subject: CF 5 Upgrade Logistics Hi All, We are planning to upgrade our server (hardware, software, the works) and had a question about the CF 5 Upgrade (from 4.01). To eliminate down time on the domains we planned to build a new box, install Win2K server, install all purchased upgraded software using fresh installs and over a period of a week or so run both boxes as we move each domain to the new box. This will reduce downtime and allow us the ability to correct some configuration issues. My question is this: If we purchase the CF 5 upgrade version do we actually have to first install 4.01 on the new box before we can upgrade CF. Or will the installation request the 4.01 CD to verify that the installation is legitimate? What exactly is the process the upgrade takes? On any rebuild we always prefer to install fresh and didn't know if we needed to purchase a new copy or the upgrade version. Best regards, Dennis Powers UXB Internet (203)879-2844 http://www.uxbinfo.com/ ~~ 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: Datediff
sorry, pet peeve: too many pounds, hashes, wahtever you want to call them. without thinking about whether the function is correct or not, not one of those #s is necessary: cfset compare = ABS(DateDiff('d',DayofYear(targ),DayofYear(implm))) This article (by Ben Forta) is a little old, but the principles still apply: http://www.defusion.com/articles/index.cfm?ArticleID=26 Fiona -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: 20 November 2001 16:21 To: CF-Talk Subject: RE: Datediff Sorry, I meant: cfset compare = ABS(#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)#) Mike -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 11:16 AM To: CF-Talk Subject: RE: Datediff Use the ABS funcitons, which will return the positive value. The number is correct, Try this: ABS(cfset compare=#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)#) Im not sure on the pounds, but play with it. Lemme know if this helps. Mike -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 11:11 AM To: CF-Talk Subject: RE: Datediff I am having problems comparing two dates. My question is how to compare two dates that come from different years. For example if I use the code below to compare a date of 12 Nov 2001 and 28 Feb 2002 to get the date difference I get -257 days. cfset compare=#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)# cfset comparison_list=#ListAppend(comparison_list,#compare#)# I have tried other means of doing this but with no success. Can somebody suggest the correct code to use to compare dates that overlap years? Thanks in advance, Declan maher -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: 20 November 2001 16:03 To: CF-Talk Subject: RE: AUTO TABLE WIDTH table width=xxx ??? EC -Original Message- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 10:51 AM To: CF-Talk Subject: Re: AUTO TABLE WIDTH :) not enough coffee A TABLE will now SHOW on the browser screen until it reaches the /table Because it has to read through the whole table to generate Widths and such but on large tables that can slow down the display of tables by a few seconds. Now there is a CODE you put into the page or the table tag that lets the Browser know this is a PREDEFINED size and to display it on the fly I forget what that code is any idea? Thanks all, Bill Wheatley Director of Development Certified Advanced ColdFusion 5 Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684 X303 ICQ: 417645 - Original Message - From: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 10:35 AM Subject: Re: AUTO TABLE WIDTH On 11/20/01, William J Wheatley penned: Whats the Code to AUTOSET the table size of a table so that the table does not have to get to the /table before the table can be displayed? What? LOL -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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: Page creation interfaces
DirectLoad is a system for creating editing website pages from MS Word http://www.flymicro.com/cf/directload Steven Katz wrote: Are there any existing systems out there that allow people who no nothing about html to create and maintain their own pages, such as with a forms-based administrative interface? Steven ~~ 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: WAAAAHHHHH
I pass the exam several months ago and have never heard from themdespite repeated emails. -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 2:38 AM To: CF-Talk Subject: RE: WH THis really sucks. Went to DevCon - Took the certification test (which I passed as an advanced developer). Came home all excited about the goodies I was going to get from Macromedia as a Certified Developer. Saw Erika's cool pocketwatch. Waiting to get it. The box came today. Opened it up with bated breath. Small blue box Took a while to figure out how to open it. When I finally got it open there was .. .. .. A cropped message? Actually, I know the answer as one came to Adam here They're definitely getting cheaper! Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED]] Sent: 21 November 2001 01:45 To: CF-Talk Subject: WH ~~ 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: Sorting Errors
Three questions here actually, 1. I've been CASTING about for a few hours now... and reading the docs everywhere I can find them can't seem to figure CASTING out. Looking for a bit of help. This sort of syntax lotnum::integer lotnum::int8 lotnum::int4 Gives this sort of error: 'Cannot cast type varchar to int4' error 2. Once I get the cast syntax figured out I was wondering??? Will cast fail when it runs across an alphanumeric lotnum? or will it truncate? 3. Is it possible to query the same field twice in one query? for example: -- select *, lotnum as lotnum1 from lotnumtable cast lotnum1::integer orderby lotnum1 - this technique could work if cast accepts an alphanumeric to integer and if I can figure out how to cast inside the query. At 08:06 PM 11/20/01 -0500, you wrote: You should cast to an integer within your SQL query and then sort by that. -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] I have a problem that I have a solution to but would like to query the group to see if there is some more elegant solution. Simply Put, When using varchar(10) as a datatype, (for a LOT# field used in manufacturing), the typical number sequence sorts with values like 1000 above something like 101. Example: 1 10 1000 101 201 21 I just pad the left with blanks in the database so that it sorts like this. 1 10 21 101 201 1000 Is there some more elegant or more standard way that I should be using? ~~ 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: Sorting Errors
Running on top of linux here but Yeah!! Sounds like a great thing you did... I am always seeing numerically sorted lists of alphanumeric text. Just can't figure out how to do it myself yet. ;-) At 09:53 AM 11/21/01 -0500, you wrote: I wrote a CFX a couple of years ago to solve this very problem (mixed alpha-numeric data that people want sorted in quasi-numeric order). C++, Windows only. Works in 4.5 but not tested in 5. Not appropriate for huge result sets. http://devex.allaire.com/developer/gallery/info.cfm?ID=44C48F77-35E9-11D4-83 D700508B94F85Amethod=Full -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 8:47 PM To: CF-Talk Subject: RE: Sorting Errors Opps, my mistake in explaining. ahh... some of the Lot#'s are... alphanumeric for example: 1 10-A 1000 101-B1C2a 201 21 and this should sort as... hummm... I'm not sure what I'm doing anymore... I have to give this more thought 1 10-A 21 101-B1C2a 201 1000 At 02:10 PM 11/21/01 +1300, you wrote: wouldn't it be better to have the LOT# field as int? -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 21 November 2001 2:02 p.m. To: CF-Talk Subject: Sorting Errors I have a problem that I have a solution to but would like to query the group to see if there is some more elegant solution. Simply Put, When using varchar(10) as a datatype, (for a LOT# field used in manufacturing), the typical number sequence sorts with values like 1000 above something like 101. Example: 1 10 1000 101 201 21 I just pad the left with blanks in the database so that it sorts like this. 1 10 21 101 201 1000 Is there some more elegant or more standard way that I should be using? Thanks to anyone who chimes in. ~~ 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: Page creation interfaces
I happened across this onehttp://www.idomainsolutions.com/ -Original Message- From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 12:32 PM To: CF-Talk Subject: Re: Page creation interfaces DirectLoad is a system for creating editing website pages from MS Word http://www.flymicro.com/cf/directload Steven Katz wrote: Are there any existing systems out there that allow people who no nothing about html to create and maintain their own pages, such as with a forms-based administrative interface? Steven ~~ 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_Forum Source - SOLUTION - THANKS
Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: Tony Gruen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 11:15 AM To: CF-Talk Subject: RE: CF_Forum Source www.cfcode.com - forum is great and you can buy the open source. Tony Gruen www.globalassault.com -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 9:09 AM To: CF-Talk Subject: CF_Forum Source I thought that I had seen a thread quite a while ago about an Open Source CF Forum Can anyone tell me where I can get this code or was I seeing things? Thanks In Advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [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: Any Oracle Experts on the List ???? Errors
Sorry for the late reply. Just got back from lunch. I've made the change to BeginDate in your code as an example. You'll have to do the same thing to your other dates cfset MonthsToDisplay = 2 cfset BeginDate = #Month(now())#/1/#Year(now())# cfset BeginDate = CreateDate(Year(now()),Month(now()),1) cfset EndDate = #Month(DateAdd(m, MonthsToDisplay,now()))#/#DaysInMonth(DateAdd(m, MonthsToDisplay,now()))#/#Year(DateAdd(m, MonthsToDisplay, now()))# cfquery name=getupcomingevents datasource=events SELECT eventid, eventdate, to_char(eventdate,'') AS eventYear, to_char(eventdate,'MM') AS eventMonth, longtitle, location FROM whatson WHERE eventdate BETWEEN #CreateODBCDate(BeginDate)# AND trunc(#CreateODBCDate(EndDate)#) ORDER BY eventdate asc /cfquery --- [EMAIL PROTECTED] wrote: Do you have a code example of the process you have just specified? = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer ~~ 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_Forum Source
Indeed.. open source just means you can see the source. Heck, even the GNU liscense allows for selling source code. - Original Message - From: Ron Hornbaker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 11:20 AM Subject: RE: CF_Forum Source that sounds like an oxymoron'you can BUY the open source' Open Source != Free :) -Ron Ron Hornbaker President/CTO . . . . . . . . . . . . http://humankindsystems.com . . . . . . . . . . . . w e c o d e. w e c a r e. . http://AnswerTrack.com - eCRM email tracking solution ~~ 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
Looping through list of variables
Hey all. I have a form with variables nammed chooseequip1, chooseequip2,chooseequip3...5 Now I want to check if each of these is empty, and if not then insert data. Of course I need to reference them. I tried using a CFLOOP but I am running into problems with referenceing the fields with evaluate. cfloop index=counter from=1 to=5 step=1 cfif len(evaluate('EquipmentForm.chooseequip#counter#')) cfquery name=InsertEquipment dbtype=Oracle80 INSERT INTO tblEquipEntry VALUES (tblequipentry_seq.nextval,1000,#Evaluate('#EquipmentForm.chooseequip##c ounter#')#,#Evaluate ('#EquipmentForm.hours##counter#')#) /cfquery /cfquery /CFLOOP Any ideas on the correct way to reference those fieldvalues? -Gel ~~ 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
CF Server Crash After Java Imp
Hi, We are running CF4.5.1 on Solaris. We are going to start expanding the functionality of CF with Java. When I went into the CF Admin and setup Java with the necessary information I still was having a hard time getting it to work. I kept getting errors that CF was not able to attach to JavaVM. Upon checking the logs, it indicated that I had the Memory Heap Size set to 1024 and 2048 was required. I changed the setting to 2048 and stopped and started CF. When I did this, the CFServer will now not come back up. I get this error in the server.log: Unknown exception occurred while trying initialize the service. The only thing that changed was the Memory Heap Size. I am not sure if the reason CF won't start back up is because it is trying to start the JVM and can't now that it has the correct minmum setting for the Memory Heap Size or what is keeping the server from coming back up. Has anyone seen anything like this before and have any suggestions? Does anyone know of a way to edit the Memory Heap setting to set it back to its original setting without being able to get to the CF Admin? Thank you in advance for any help/advice. Kevin Cundick Webmaster Flying J Inc ~~ 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
RESOLVED: Looping through list of variables
The correct Code is : cfloop index=counter from=1 to=5 step=1 !--- CHeck if Select Box is empty. If not then insert values, otherwise loop again --- cfif len(evaluate('EquipmentForm.chooseequip#counter#')) cfquery name=InsertEquipment datasource=relora dbtype=Oracle80 INSERT INTO tblEquipEntry VALUES (tblequipentry_seq.nextval,1000,'#Evaluate('EquipmentForm.chooseequip#co unter#')#',#Evaluate('EquipmentForm.hours#counter#')#) /cfquery /cfif /CFLOOP --- Thanks all. -Gel -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 3:06 PM To: CF-Talk Subject: Looping through list of variables Hey all. I have a form with variables nammed chooseequip1, chooseequip2,chooseequip3...5 Now I want to check if each of these is empty, and if not then insert data. Of course I need to reference them. I tried using a CFLOOP but I am running into problems with referenceing the fields with evaluate. cfloop index=counter from=1 to=5 step=1 cfif len(evaluate('EquipmentForm.chooseequip#counter#')) cfquery name=InsertEquipment dbtype=Oracle80 INSERT INTO tblEquipEntry VALUES (tblequipentry_seq.nextval,1000,#Evaluate('#EquipmentForm.chooseequip##c ounter#')#,#Evaluate ('#EquipmentForm.hours##counter#')#) /cfquery /cfquery /CFLOOP Any ideas on the correct way to reference those fieldvalues? -Gel ~~ 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 Server Crash After Java Imp
We had some problems setting up JVM with CF5 on Solaris. We ran into the same problem with the JVM trying to start when CF does and fails - crashing CF. You can edit the Coldfusion start file with a text editor, I think that's found in installdir/coldfusion/bin. There is a setting to load the JVM when CF starts. Change that setting and you should be able to load the administrator once CF starts. -seth - Original Message - From: Kevin Cundick [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 2:00 PM Subject: CF Server Crash After Java Imp Hi, We are running CF4.5.1 on Solaris. We are going to start expanding the functionality of CF with Java. When I went into the CF Admin and setup Java with the necessary information I still was having a hard time getting it to work. I kept getting errors that CF was not able to attach to JavaVM. Upon checking the logs, it indicated that I had the Memory Heap Size set to 1024 and 2048 was required. I changed the setting to 2048 and stopped and started CF. When I did this, the CFServer will now not come back up. I get this error in the server.log: Unknown exception occurred while trying initialize the service. The only thing that changed was the Memory Heap Size. I am not sure if the reason CF won't start back up is because it is trying to start the JVM and can't now that it has the correct minmum setting for the Memory Heap Size or what is keeping the server from coming back up. Has anyone seen anything like this before and have any suggestions? Does anyone know of a way to edit the Memory Heap setting to set it back to its original setting without being able to get to the CF Admin? Thank you in advance for any help/advice. Kevin Cundick Webmaster Flying J Inc ~~ 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