Using # signs on URL to go to a name=.... on .cfm pages
Seems like a no brainer question on .htm pages, but how about on .cfm pages? How to you dynamically create URLs with # signs to link to a name=... tags? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Using # signs on URL to go to a name=.... on .cfm pages
It's the same for html and cfml. If you need to do it in a CFOUTPUT, just double the # sign -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED]] Sent: donderdag 3 oktober 2002 8:52 To: CF-Talk Subject: Using # signs on URL to go to a name= on .cfm pages Seems like a no brainer question on .htm pages, but how about on .cfm pages? How to you dynamically create URLs with # signs to link to a name=... tags? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: Cfmail performance comparisons
Stacy Young [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] merce.com... Are u processing anything else besides outputting a query into cfmail? Yes. I'll probably loop over the cfmail, and run a query each time. I'm coming round to thinking the best, most reliable way to do it would be to create a scheduled task which would: A) grab 100 records at a time, store the range (0-100, 2300-2400 etc) in another table B) Loop over this and process the mail C) Run this every 5/x minutes, taking the last biggest range (i.e. 100-200, 200-300). I can't see how else to do it really. Will ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Using # signs on URL to go to a name=.... on .cfm pages
Pascal, I'm probably missing something from your solution. Here is we I wantnted to use it: cfoutput td align=center a href=view_overview.cfm?expand=#project_idproject_name# img src=../lib_images/triangle.gif alt=View All Projects border=0 /a /td /cfoutput I wanted the URL link to be: view_overview.cfm?expand=9#Cost Based on your suggestion, it seems like its escaping the double #. So its showing as view_overview.cfm?expand=9Cost ... with no # reference Thanks for your response, btw. Michael At 09:06 AM 10/3/2002 +0200, Pascal Peters wrote: It's the same for html and cfml. If you need to do it in a CFOUTPUT, just double the # sign -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED]] Sent: donderdag 3 oktober 2002 8:52 To: CF-Talk Subject: Using # signs on URL to go to a name= on .cfm pages Seems like a no brainer question on .htm pages, but how about on .cfm pages? How to you dynamically create URLs with # signs to link to a name=... tags? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Using # signs on URL to go to a name=.... on .cfm pages
I pasted your code on a test page and it works as intended. Here is the generated content: td align=center a href=view_overview.cfm?expand=9#cost img src=../lib_images/triangle.gif alt=View All Projects border=0 /a /td If you have a different result, I don't know what's going on. I tested on CF5. -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED]] Sent: donderdag 3 oktober 2002 9:38 To: CF-Talk Subject: RE: Using # signs on URL to go to a name= on .cfm pages Pascal, I'm probably missing something from your solution. Here is we I wantnted to use it: cfoutput td align=center a href=view_overview.cfm?expand=#project_idproject_name# img src=../lib_images/triangle.gif alt=View All Projects border=0 /a /td /cfoutput I wanted the URL link to be: view_overview.cfm?expand=9#Cost Based on your suggestion, it seems like its escaping the double #. So its showing as view_overview.cfm?expand=9Cost ... with no # reference Thanks for your response, btw. Michael At 09:06 AM 10/3/2002 +0200, Pascal Peters wrote: It's the same for html and cfml. If you need to do it in a CFOUTPUT, just double the # sign -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED]] Sent: donderdag 3 oktober 2002 8:52 To: CF-Talk Subject: Using # signs on URL to go to a name= on .cfm pages Seems like a no brainer question on .htm pages, but how about on .cfm pages? How to you dynamically create URLs with # signs to link to a name=... tags? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Using # signs on URL to go to a name=.... on .cfm pages
Hey Michael, I just cut and paste your code out and when I click on the link it took me to: http://localhost:8500/testsvr/view_overview.cfm?expand=9#cost as expected. The double # is definitely the right syntax since the second # escapes the first, John. -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 08:38 To: CF-Talk Subject: RE: Using # signs on URL to go to a name= on .cfm pages Pascal, I'm probably missing something from your solution. Here is we I wantnted to use it: cfoutput td align=center a href=view_overview.cfm?expand=#project_idproject_name# img src=../lib_images/triangle.gif alt=View All Projects border=0 /a /td /cfoutput I wanted the URL link to be: view_overview.cfm?expand=9#Cost Based on your suggestion, it seems like its escaping the double #. So its showing as view_overview.cfm?expand=9Cost ... with no # reference Thanks for your response, btw. Michael At 09:06 AM 10/3/2002 +0200, Pascal Peters wrote: It's the same for html and cfml. If you need to do it in a CFOUTPUT, just double the # sign -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED]] Sent: donderdag 3 oktober 2002 8:52 To: CF-Talk Subject: Using # signs on URL to go to a name= on .cfm pages Seems like a no brainer question on .htm pages, but how about on .cfm pages? How to you dynamically create URLs with # signs to link to a name=... tags? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Using # signs on URL to go to a name=.... on .cfm pages
Ugh! John, Pascal... you're right... I think I had one too many #'s the last time. Work this time. I appreciate both of your help. At 08:54 AM 10/3/2002 +0100, John Beynon wrote: Hey Michael, I just cut and paste your code out and when I click on the link it took me to: http://localhost:8500/testsvr/view_overview.cfm?expand=9#cost as expected. The double # is definitely the right syntax since the second # escapes the first, John. -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 08:38 To: CF-Talk Subject: RE: Using # signs on URL to go to a name= on .cfm pages Pascal, I'm probably missing something from your solution. Here is we I wantnted to use it: cfoutput td align=center a href=view_overview.cfm?expand=#project_idproject_name# img src=../lib_images/triangle.gif alt=View All Projects border=0 /a /td /cfoutput I wanted the URL link to be: view_overview.cfm?expand=9#Cost Based on your suggestion, it seems like its escaping the double #. So its showing as view_overview.cfm?expand=9Cost ... with no # reference Thanks for your response, btw. Michael At 09:06 AM 10/3/2002 +0200, Pascal Peters wrote: It's the same for html and cfml. If you need to do it in a CFOUTPUT, just double the # sign -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED]] Sent: donderdag 3 oktober 2002 8:52 To: CF-Talk Subject: Using # signs on URL to go to a name= on .cfm pages Seems like a no brainer question on .htm pages, but how about on .cfm pages? How to you dynamically create URLs with # signs to link to a name=... tags? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Printing Crystal Report from web page?
You can also get crystal to output to PDF, if like us you think the report viewers are a bit clunky. -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 02:38 To: CF-Talk Subject: Re: Printing Crystal Report from web page? The best method I've found is to install Crystal Reports Developers Edition on your web server and use their ActiveX or Java viewers. This way you get perfect reports as they we designed to look and print. However there is a learning curve to integrate them with CF. All of the knowledge available to do this from the Crystal site involves ASP. In order to be as productive as possible, we purchased a product called ReCrystallize which generates the ASP pages for us. Both the input forms and the processing page to open the viewer and send in your report parameters. We basically discard the input form and create our own to suit our needs with CF. Of course we need to match the field names the generated processing page is expecting. Hope this helps, Frank Mamone - Original Message - From: Shawn Grover [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 02, 2002 4:37 PM Subject: OT: Printing Crystal Report from web page? We have a number of crystal reports which get rendered to a web page. The developer that set this stuff up has left us, leaving me to fix some minor issues. For the most part, I don't have a problem working with the reports themselves. However, using a Crystal report in a web page leaves me with a few questions. The biggest of which is printing. The problem I'm seeing right now is that when we print a report (from the web page), it will occasionally print half a line on one page, and the other half on the next page. I modified the reports to leave some space in the page footer, and to reserve space for the page footer, but I still see the splitting of lines. Further digging shows that the print function is doing a javascript window.print(); - so it's printing the web page, not the report itself. Any suggestions how to deal with this issue? Thanks in advance. Shawn Grover ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: HomeSite+
meanwhile...back at the Batcave... -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 05:50 To: CF-Talk Subject: HomeSite+ I thought we'd lost ColdFusion Studio for good with the release of the pretty good Studio MX. Thankfully MM have added a product called HomeSite + - which appears to be ColdFusion Studio 5/HomeSite 5 with additional feature supporting the new MX suite (including of course ColdFusion MX). Thank you MM. Cheers! ** The information contained in this e-mail, and any attachments to it, is intended for the use of addressee and is confidential. If you are not the intended recipient, you must not use, disclose, read, forward, copy or retain any of the information. If you have received this e-mail in error, please delete it and notify the sender by return e-mail or telephone. The Commonwealth does not warrant that any attachments are free from viruses or any other defects. You assume all liability for any loss, damage, or other consequences which may arise from opening or using the attachments. ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: COM Object Instantiation Problem
It was for CFMX (not J2EE), not just standalone though, the whole shebang., -Original Message- From: Dale Coyner [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 04:53 To: CF-Talk Subject: RE: COM Object Instantiation Problem Bryan, Is the update for CF4J2EE also? I had read that the most recently released updater was for standalone CFMX and to wait for an updater for CF4J2EE. Regards, Dale Coyner Communicast, Inc. From: Bryan F. Hogan [EMAIL PROTECTED] Subject: RE: COM Object Instantiation Problem There are problems with COM with MX. Download and install the updater for MX, they have corrected some of the problems with COM. See if that works for you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Any Christian ColdFusion developers out there?
no religion here thank you (wel, certainly none for me), as the list master stated : cf-community. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 04:46 To: CF-Talk Subject: Re: Any Christian ColdFusion developers out there? Whoa - I saw your initials at the end of your email and did a double-take g - Original Message - From: John Cummings [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 02, 2002 11:32 PM Subject: Any Christian ColdFusion developers out there? Hi, I've often given thought to trying to organize the Christian ColdFusion community in some way (I know you're out there, because I've met a lot of you). If you're interested in connecting in some formal way, please contact me off list and I'll see if we can get some ideas organized. (I'm thinking along the lines of hooking up and conferences, DevCon, volunteering services where we can, etc.) JC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Footer at Bottom
How can I always display my footer page (consist of one Table), always at bottom of Browser Window. No matter its being included in page with two lines still its at bottom of page and even if page has got scrollable thingy still footer is at end (bottom) of page. Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ** 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. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Footer at Bottom
place the table within the OnRequestEnd.cfm page. That is always the last page parsed and will ensure your table is at the bottom of the page. -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 10:41 To: CF-Talk Subject: Footer at Bottom How can I always display my footer page (consist of one Table), always at bottom of Browser Window. No matter its being included in page with two lines still its at bottom of page and even if page has got scrollable thingy still footer is at end (bottom) of page. Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ** 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. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Passing URL.variable to an iFrame
All, I'm passing a URL.variable through to my page, and my page loads an iFrame. Whenever the iFrame is grabbing a query and I'm hoping it will grab based upon the URL.variable, it doesn't do that. Instead, it grabs the value based upon the default in my cfparam tag. Is there anything I'm failing to send to an iFrame or to an external page, so to speak? Thanks, Russ Unger Managing Partner Blue Chrome Design www.bluechromedesign.com http://www.bluechromedesign.com/ 312.593.4260 :office 877.433.8427 :pager ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Footer at Bottom
Displaying page at end of each request is not a problem, its already doing that. But what I want is display at bottom of screen. Currently what it is doing is something like that CONTENTS OF PAGE CONSIST OF SAY 4 LINES --- Footer at 6th LINE What I want is CONTENTS OF PAGE CONSIST OF 4 LINE FOOTER (at bottom of screen say 29th LINE) -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 10:44 To: CF-Talk Subject: RE: Footer at Bottom place the table within the OnRequestEnd.cfm page. That is always the last page parsed and will ensure your table is at the bottom of the page. -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 10:41 To: CF-Talk Subject: Footer at Bottom How can I always display my footer page (consist of one Table), always at bottom of Browser Window. No matter its being included in page with two lines still its at bottom of page and even if page has got scrollable thingy still footer is at end (bottom) of page. Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ** 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. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Footer at Bottom
why dont you place it in within a table and valign='bottom'. You could always use a Custom Tag to perform the operation also... N -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 10:55 To: CF-Talk Subject: RE: Footer at Bottom Displaying page at end of each request is not a problem, its already doing that. But what I want is display at bottom of screen. Currently what it is doing is something like that CONTENTS OF PAGE CONSIST OF SAY 4 LINES --- Footer at 6th LINE What I want is CONTENTS OF PAGE CONSIST OF 4 LINE FOOTER (at bottom of screen say 29th LINE) -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 10:44 To: CF-Talk Subject: RE: Footer at Bottom place the table within the OnRequestEnd.cfm page. That is always the last page parsed and will ensure your table is at the bottom of the page. -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 10:41 To: CF-Talk Subject: Footer at Bottom How can I always display my footer page (consist of one Table), always at bottom of Browser Window. No matter its being included in page with two lines still its at bottom of page and even if page has got scrollable thingy still footer is at end (bottom) of page. Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ** 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. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Footer at Bottom
Try placing your entire page in a 100% x 100% table. 2 rows. Bottom row valign=bottom Include footer. See if that works. Russ -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 4:55 AM To: CF-Talk Subject: RE: Footer at Bottom Displaying page at end of each request is not a problem, its already doing that. But what I want is display at bottom of screen. Currently what it is doing is something like that CONTENTS OF PAGE CONSIST OF SAY 4 LINES --- Footer at 6th LINE What I want is CONTENTS OF PAGE CONSIST OF 4 LINE FOOTER (at bottom of screen say 29th LINE) -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 10:44 To: CF-Talk Subject: RE: Footer at Bottom place the table within the OnRequestEnd.cfm page. That is always the last page parsed and will ensure your table is at the bottom of the page. -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 10:41 To: CF-Talk Subject: Footer at Bottom How can I always display my footer page (consist of one Table), always at bottom of Browser Window. No matter its being included in page with two lines still its at bottom of page and even if page has got scrollable thingy still footer is at end (bottom) of page. Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ** 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. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
CF5 Problem
Any idea why CF 5 would server CFM files up as TXT files? I do have the index.cfm in the IIS settings for default documents. TIA! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Footer at Bottom
If you had a layout table sized 100% vertical and a row a the bottom you could shove it in there - that should work. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 10:57 To: CF-Talk Subject: RE: Footer at Bottom why dont you place it in within a table and valign='bottom'. You could always use a Custom Tag to perform the operation also... N -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 10:55 To: CF-Talk Subject: RE: Footer at Bottom Displaying page at end of each request is not a problem, its already doing that. But what I want is display at bottom of screen. Currently what it is doing is something like that CONTENTS OF PAGE CONSIST OF SAY 4 LINES --- Footer at 6th LINE What I want is CONTENTS OF PAGE CONSIST OF 4 LINE FOOTER (at bottom of screen say 29th LINE) -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 10:44 To: CF-Talk Subject: RE: Footer at Bottom place the table within the OnRequestEnd.cfm page. That is always the last page parsed and will ensure your table is at the bottom of the page. -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 10:41 To: CF-Talk Subject: Footer at Bottom How can I always display my footer page (consist of one Table), always at bottom of Browser Window. No matter its being included in page with two lines still its at bottom of page and even if page has got scrollable thingy still footer is at end (bottom) of page. Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ** 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. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Footer at Bottom
I'm not 100% sure, but I think you can place everything in a table with width and haight set to 100%. You create a top cell for the content and a bottom cell with valign=bottom for the footer. You should probably test this for cross-browser compatibility -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: donderdag 3 oktober 2002 11:55 To: CF-Talk Subject: RE: Footer at Bottom Displaying page at end of each request is not a problem, its already doing that. But what I want is display at bottom of screen. Currently what it is doing is something like that CONTENTS OF PAGE CONSIST OF SAY 4 LINES --- Footer at 6th LINE What I want is CONTENTS OF PAGE CONSIST OF 4 LINE FOOTER (at bottom of screen say 29th LINE) -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 10:44 To: CF-Talk Subject: RE: Footer at Bottom place the table within the OnRequestEnd.cfm page. That is always the last page parsed and will ensure your table is at the bottom of the page. -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 10:41 To: CF-Talk Subject: Footer at Bottom How can I always display my footer page (consist of one Table), always at bottom of Browser Window. No matter its being included in page with two lines still its at bottom of page and even if page has got scrollable thingy still footer is at end (bottom) of page. Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ** 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. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Passing URL.variable to an iFrame
Ignore this request. Stupid syntax errors at 5am CST. Apologies for the extra noise on my part. Russ -Original Message- From: Russ [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 4:50 AM To: CF-Talk Subject: Passing URL.variable to an iFrame All, I'm passing a URL.variable through to my page, and my page loads an iFrame. Whenever the iFrame is grabbing a query and I'm hoping it will grab based upon the URL.variable, it doesn't do that. Instead, it grabs the value based upon the default in my cfparam tag. Is there anything I'm failing to send to an iFrame or to an external page, so to speak? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: cfmail: attachment + multipart?
Samuel Farmer wrote: I am trying to send out a cfmail in multipart format and (sometimes) send an attachment as well. Got the first part to work, but if I add a file to the mimeAttach attribute I get the file but the email formating is lost. Any ideas/solutions? Headers mix-up. Attachments require multipart/mixed, HTML + text requires multipart/alternative. So if you need them both, you got to nest one inside the other. For an implementation that can do that, see http://jochem.vandieten.net/coldfusion/customtags/advancedemail/ Requires cffile, CF MX not supported. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Verity with Coldfusion MX
What are your experiences with verity that comes with Coldfusion MX, I believe that it is an updated version of the verity version that cam with Coldfsuion 4.5?? Is it more accurate, faster and more powerfulll than the previous version? If not what other options/software are there for having a search on your site to search for word, pdf docs, .cfm and html pages and data from database tables? Would be interesting to hear exactly what search facility people are implementing with their Coldfusion apps. Ian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: CF Mail Problem..
On 10/1/02, Ryan Sabir penned: Thats how CFMAIL is supposed to work when you pass a query to it. What you should do is use a CFLOOP query=queryname inside your CFMAIL content section to output the data you need in the table. bye! That depends. If you have a cfouput nested in the cfmail, it shouldn't. Or at least it never has in the past. CFQUERY DATASOURCE=ezcart_v8_SQL NAME=getcats SELECT category_name FROM categories order by category_id /CFQUERY The cfmail below will send an e-mail for each category. cfmail query=getcats to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=test query #category_name# /cfmail In CF 4.0, 4.5 and 5, the cfmail below will send a single e-mail containing all categories. cfmail query=getcats to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=test queryCFOUTPUT #category_name#/CFOUTPUT /cfmail I'm having a similar problem and found the thread started by Srimanta while looking to see if anyone else had similar problems. My shopping cart sends out an e-mail confirmation based on the shopper's cart after an order is placed. The code below (simplified) has worked fine for 3 years since version 4.0. cfmail query=variables.basket to=#customeremail# from=#merchantemail# subject=#storename# Order Number #Order_ID# Thank you for your purchase, order number #Order_ID#. CFOUTPUTProduct Name: #Item_Name# Product ID: #Item_ID# Item Price: #dollarformat(Item_Price)# Qty Purchased: #Quantity# Item Total: #dollarformat(Quantity * Item_Price)# ___ /CFOUTPUT Total: #dollarformat(Order_Total)# /cfmail Now, with CFMX, if the shopper has 4 items in their basket it sends out 4 e-mails. 1st mail contains 1st item 2nd mail contains 1st 2 items 3rd mail contains 1st 3 items 4th mail contains all 4 items correctly. RANT Now, I love CF, but I'm really getting sick of going back to every application I've built to fix things every time a new version of CF comes out, and having to write the same code 3 and 4 different ways with a version switch so the proper code loads depending upon the version of CF that's running when building a new app. One of the advantages of using CF has always been quicker development time. That advantage is quickly defeated when I have to write the same code 3 times so my program will run on 4.0, 4.5, 5 and MX. Examples: 1) cflock. Have to place a version switch in every application, then cfinclude 2 different sets of files for every session, server and application variable written and read. One using name for 4.0, one using scope for 4.5 and higher. How I would have done it? Write 4.5 and higher so if name and scope were both included, name would be ignored. Issue a patch for 4.0 so including scope wouldn't throw an error. 2) cfmail. Have to place a version switch in every application, then cfinclude 2 different sets of files for every cfmail containing cfoutput. One with cfprocessingdirective suppresswhitespace=no for 4.5 and higher, one without for 4.0. I NEVER had a problem with excess white space in cfmail using 4.0. How I would have done it? The automatic white space cleanup would have been written to leave cfmail alone. Then we would could add suppresswhitespace=yes if need be. Either that or issue a patch for 4.0 where using cfprocessingdirective wouldn't throw an error. 3) cfhttp POST. Have to place a version switch every time I use cfhttp, then manually URLEncode any variables that should be encoded in 4.5 and earlier, which is fine and the way it should be. But now I have to go back and set all URLEncoded variables outside of the chfhttp tag, and either encode them for version 4.5 and earlier, or pass them as they are form 5 and later. Still haven't figured out what to do in 5 and higher when you don't WANT to send the value encoded. How I would have done it? Just leave the darned thing the way it was. That's why they made URLEncodedFormat() in the first place. Let they developers decide if we want to encode the values. 4) Grouped queries. They totally changed the way currentrow is calculated on grouped queries. I wrote a little tag that let's you do Next'n records on a grouped cfoutput. CFMX totally broke it and I had to put a version switch in it. Again, I would have left this alone. 5) Now this new one. I'll have to go back and add a THIRD cfinclude just to use cfmail with a query and nested cfoutput. And I'm just beginning to test things with CFMX. I can only imagine what other problems I'll run into. Utterly ridiculous! /RANT Sorry about the rant. It's early and I hate finding new bugs first thing in the morning. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:
Non-Windows CFMX interfacing emulated MS-Access db. was: SOT How to set up win XP network to be recognized by OS X
Success! It is possible to interface ColdFusion MX (CFMX) running on OS X 10.2.1 (Jaguar) to a MS-Access database running under VirtualPC emulated WinXP on the same machine. This should also be possible on a Linux Box using VMWare. Everything seems to work well (limited testing, so far). A similar setup could be used for SQL-Server or any other db which runs on Windows. MS-Acces is particularly important because: It is so ubiquitous the cost of ownership is low What this (potentially) means is that CFMX developers, using a non-Windows platform, for the first time can directly interface MS-Access databases. As a Mac user this means that for the first time I can run CFMX native and manipulate MS-Access database -- not for production, but as a means to capture information from an existing MS-Access db. I am pretty excited about this! Dick Scenario 1: 1) You walk into a client's office, connect your laptop to the client's network and copy his .mdb database to your * non-Windows* laptop. 2) Ad Hoc, you specify a few datasources, and a simple CF Template. cfquery name=getMSAccessDB Datasource=MSAccessDB SELECT * FROM MSAccessTable /cfquery cfdump var=#getMSAccessDB# 3) You demonstrate a prototype of the client's Intranet/Internet application using his data on your * non-Windows* laptop. Scenario 2 : 1) You FTP download the MS-Access db in advance 2) You setup a more elaborate demo still using the emulated MS-Access db 3) You demonstrate a prototype of the client's Intranet/Internet application using his data on your * non-Windows* laptop. Scenario 3 : 1) You FTP download the MS-Access db in advance 2) You use the emulated MS-Access DB to create and populate an more robust RDBMS that runs native. 3) You setup a more elaborate demo using the native RDBMS 4) You demonstrate a prototype of the client's Intranet/Internet application using his data on your *non-Windows* laptop. On Tuesday, October 1, 2002, at 05:32 AM, Dick Applebaum wrote: Objective: Connect a windows machine (emulated with VirtualPC) to a network on the host Mac OS X machine. The CF tie-in is that I want to Use CFMX on OS X to manipulate MS-Access databases on the Emulated windows machine. The MS-Access databases will not be used in production, rather, the CF programs will extract the MS-Access data and put it into a more-robust RDBMS (usually validating data, changing the schema, normalizing, etc.). CFML is an excellent language for doing this, This is not just an Mac OS X issue -- A Linux or Unix-based CFMX system often needs to get data from MS-Access databases. Sure there other ways to do this, but they all involve extra steps and/or extra hardware fiddling around -- the elegant way is to write a CF program to directly manipulate the MS-Access tables and create and populate the real RDBMS tables (normalizing and creating relationships in the process). ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Any Christian ColdFusion developers out there?
I think he addressed his remarks to Christians, Neil... He did not address his remarks to those who were not interested. As for community, are Christians, who define a subgroup of CF developers, welcome inside the larger community of CF, or are those who are religious, particularly Christians, not welcome to communicate (note the root word, commune, in community and communicate) with each other? Rick -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 4:59 AM To: CF-Talk Subject: RE: Any Christian ColdFusion developers out there? no religion here thank you (wel, certainly none for me), as the list master stated : cf-community. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 04:46 To: CF-Talk Subject: Re: Any Christian ColdFusion developers out there? Whoa - I saw your initials at the end of your email and did a double-take g - Original Message - From: John Cummings [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 02, 2002 11:32 PM Subject: Any Christian ColdFusion developers out there? Hi, I've often given thought to trying to organize the Christian ColdFusion community in some way (I know you're out there, because I've met a lot of you). If you're interested in connecting in some formal way, please contact me off list and I'll see if we can get some ideas organized. (I'm thinking along the lines of hooking up and conferences, DevCon, volunteering services where we can, etc.) JC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: Footer at Bottom
Displaying page at end of each request is not a problem, its already doing that. But what I want is display at bottom of screen. Currently what it is doing is something like that You're talking about something like the nasty floating thing that you get when you go a geocities website, except instead of displaying it on the right, you want it at the bottom of the browser window, right?? Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Cfmail performance comparisons
Is it possible to just run the one query then output using cfmail? cfmail query=myQuery to= from= subject= -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 3:18 AM To: CF-Talk Subject: Re: Cfmail performance comparisons Stacy Young [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] merce.com... Are u processing anything else besides outputting a query into cfmail? Yes. I'll probably loop over the cfmail, and run a query each time. I'm coming round to thinking the best, most reliable way to do it would be to create a scheduled task which would: A) grab 100 records at a time, store the range (0-100, 2300-2400 etc) in another table B) Loop over this and process the mail C) Run this every 5/x minutes, taking the last biggest range (i.e. 100-200, 200-300). I can't see how else to do it really. Will fusionauthority.com/bkinfo.cfm AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Converting new lines to br
If you only need it for display purposes, ParagraphFormat() should be what you need. If you actually need to change the string, then the other suggestions given should be fine. I'm new to Cold Fusion so bear with me. Is there a way of converting new lines in a string to html line breaks br. If you are familiar with PHP I'm looking for something like the nl2br function. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Any Christian ColdFusion developers out there?
cf-community... -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 13:15 To: CF-Talk Subject: RE: Any Christian ColdFusion developers out there? I think he addressed his remarks to Christians, Neil... He did not address his remarks to those who were not interested. As for community, are Christians, who define a subgroup of CF developers, welcome inside the larger community of CF, or are those who are religious, particularly Christians, not welcome to communicate (note the root word, commune, in community and communicate) with each other? Rick -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 4:59 AM To: CF-Talk Subject: RE: Any Christian ColdFusion developers out there? no religion here thank you (wel, certainly none for me), as the list master stated : cf-community. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 04:46 To: CF-Talk Subject: Re: Any Christian ColdFusion developers out there? Whoa - I saw your initials at the end of your email and did a double-take g - Original Message - From: John Cummings [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 02, 2002 11:32 PM Subject: Any Christian ColdFusion developers out there? Hi, I've often given thought to trying to organize the Christian ColdFusion community in some way (I know you're out there, because I've met a lot of you). If you're interested in connecting in some formal way, please contact me off list and I'll see if we can get some ideas organized. (I'm thinking along the lines of hooking up and conferences, DevCon, volunteering services where we can, etc.) JC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Footer at Bottom
This won't work. The table height attribute doesn't work consistently and has been deprecated by the W3C in HTML 4.01. The only way I can think of to do it is with floating layers and DHTML. Set the footer content into a layer and continually check the browser window to see what its dimensions are and set the layer to the bottom of those dimensions. Of course, DHTML isn't always supported either. Bottom line: There's no good way to do this. Kevin Graeme -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 5:04 AM To: CF-Talk Subject: RE: Footer at Bottom I'm not 100% sure, but I think you can place everything in a table with width and haight set to 100%. You create a top cell for the content and a bottom cell with valign=bottom for the footer. You should probably test this for cross-browser compatibility -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: donderdag 3 oktober 2002 11:55 To: CF-Talk Subject: RE: Footer at Bottom Displaying page at end of each request is not a problem, its already doing that. But what I want is display at bottom of screen. Currently what it is doing is something like that CONTENTS OF PAGE CONSIST OF SAY 4 LINES --- Footer at 6th LINE What I want is CONTENTS OF PAGE CONSIST OF 4 LINE FOOTER (at bottom of screen say 29th LINE) -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 10:44 To: CF-Talk Subject: RE: Footer at Bottom place the table within the OnRequestEnd.cfm page. That is always the last page parsed and will ensure your table is at the bottom of the page. -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 10:41 To: CF-Talk Subject: Footer at Bottom How can I always display my footer page (consist of one Table), always at bottom of Browser Window. No matter its being included in page with two lines still its at bottom of page and even if page has got scrollable thingy still footer is at end (bottom) of page. Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ** 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. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Installing Tomcat 4
I know this is not CF related, but we are using Tomcat for one of our application features; thing is, do any of you guys know the process of installing it? I have Tomcat 4.x binary files which have been delivered to me as a .zip archive. I extracted these and I have the Tomcat.exe etc and whole host of .bat files.. Anyone got any pointers. Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Installing Tomcat 4
Double click the .exe :O) Sorry :OP Ade -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 13:45 To: CF-Talk Subject: Installing Tomcat 4 I know this is not CF related, but we are using Tomcat for one of our application features; thing is, do any of you guys know the process of installing it? I have Tomcat 4.x binary files which have been delivered to me as a .zip archive. I extracted these and I have the Tomcat.exe etc and whole host of .bat files.. Anyone got any pointers. Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Date Comparison
Short answer: You can't. CF needs to run under a user account in order to access drives on the network. (I still have a flat spot on my head from banging it against my desk over this.) -Original Message- From: Brook [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 6:56 PM To: CF-Talk Subject: Re: Date Comparison When running under the SYSTEM account, and trying to connect to a remote drive via a UNC path, what permissions do you need on the shared folder? I can connect running under a user account by having an account by the same name on the remote machine and giving that account privileges to the folder. But I can't seem to do the same thing with the System account. I've tried adding SYSTEM and even EVERYONE and I still get an access denied error when running CF under the default SYSTEM Account. But I can open the shared drive through the network neighborhood and read/write a file ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Installing Tomcat 4
http://jakarta.apache.org/tomcat/ There's a pointer for you ;o) - Original Message - From: Robertson-Ravo, Neil (REC) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 1:44 PM Subject: Installing Tomcat 4 I know this is not CF related, but we are using Tomcat for one of our application features; thing is, do any of you guys know the process of installing it? I have Tomcat 4.x binary files which have been delivered to me as a .zip archive. I extracted these and I have the Tomcat.exe etc and whole host of .bat files.. Anyone got any pointers. Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Installing Tomcat 4
luck I have this tight belt on -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 13:59 To: CF-Talk Subject: Re: Installing Tomcat 4 http://jakarta.apache.org/tomcat/ There's a pointer for you ;o) - Original Message - From: Robertson-Ravo, Neil (REC) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 1:44 PM Subject: Installing Tomcat 4 I know this is not CF related, but we are using Tomcat for one of our application features; thing is, do any of you guys know the process of installing it? I have Tomcat 4.x binary files which have been delivered to me as a .zip archive. I extracted these and I have the Tomcat.exe etc and whole host of .bat files.. Anyone got any pointers. Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Installing Tomcat 4
run the exe and once done check the tomcat service is running (if you're opn windows) then you should be able to browse http://localhost:8080 which will provide the local tomcat docs hth mark -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 13:59 To: CF-Talk Subject: Re: Installing Tomcat 4 http://jakarta.apache.org/tomcat/ There's a pointer for you ;o) - Original Message - From: Robertson-Ravo, Neil (REC) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 1:44 PM Subject: Installing Tomcat 4 I know this is not CF related, but we are using Tomcat for one of our application features; thing is, do any of you guys know the process of installing it? I have Tomcat 4.x binary files which have been delivered to me as a .zip archive. I extracted these and I have the Tomcat.exe etc and whole host of .bat files.. Anyone got any pointers. Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: How to delete a session variable
You can use structDelete: cfset structDelete(session,name of var to kill, ie, foo) Be sure to use locks if you are MX. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 8:22 PM To: CF-Talk Subject: How to delete a session variable We are moving offices and all my ref books are packed away. Just wondering how I go about deleting a Session variable. Cheers! ** The information contained in this e-mail, and any attachments to it, is intended for the use of addressee and is confidential. If you are not the intended recipient, you must not use, disclose, read, forward, copy or retain any of the information. If you have received this e-mail in error, please delete it and notify the sender by return e-mail or telephone. The Commonwealth does not warrant that any attachments are free from viruses or any other defects. You assume all liability for any loss, damage, or other consequences which may arise from opening or using the attachments. ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Installing Tomcat 4
there isnt an .exe installer, only binaries -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 14:01 To: CF-Talk Subject: RE: Installing Tomcat 4 run the exe and once done check the tomcat service is running (if you're opn windows) then you should be able to browse http://localhost:8080 which will provide the local tomcat docs hth mark -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 13:59 To: CF-Talk Subject: Re: Installing Tomcat 4 http://jakarta.apache.org/tomcat/ There's a pointer for you ;o) - Original Message - From: Robertson-Ravo, Neil (REC) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 1:44 PM Subject: Installing Tomcat 4 I know this is not CF related, but we are using Tomcat for one of our application features; thing is, do any of you guys know the process of installing it? I have Tomcat 4.x binary files which have been delivered to me as a .zip archive. I extracted these and I have the Tomcat.exe etc and whole host of .bat files.. Anyone got any pointers. Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: CFMX bug?
Peter, I would like to look into this issue for you. What was your upgrade path? michael d corbridge macromedia 617.219.2307 [EMAIL PROTECTED] -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 2:09 AM To: CF-Talk Subject: CFMX bug? h5About You:/h5 ul cfoutput pli type=squarebYour IP Address:/bnbsp;#Remote_Addr#br pli type=squarebBrowser:/bnbsp;#HTTP_User_Agent#br /ul h5About Us:/h5 ul pli type=squarebServer:/bnbsp;#Server.ColdFusion.ProductName# #Server.ColdFusion.ProductLevel# (#Server.ColdFusion.ProductVersion#) /cfoutput /ul The above code reports the ProductVersion the product as ColdFusion Server Evaluation (6,0,0,52311) despite being upgraded to Professional :( ** The information contained in this e-mail, and any attachments to it, is intended for the use of addressee and is confidential. If you are not the intended recipient, you must not use, disclose, read, forward, copy or retain any of the information. If you have received this e-mail in error, please delete it and notify the sender by return e-mail or telephone. The Commonwealth does not warrant that any attachments are free from viruses or any other defects. You assume all liability for any loss, damage, or other consequences which may arise from opening or using the attachments. ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Installing Tomcat 4
ah it doesnt matter, turns out its a piece of piss :-) -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 14:10 To: CF-Talk Subject: RE: Installing Tomcat 4 there isnt an .exe installer, only binaries -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 14:01 To: CF-Talk Subject: RE: Installing Tomcat 4 run the exe and once done check the tomcat service is running (if you're opn windows) then you should be able to browse http://localhost:8080 which will provide the local tomcat docs hth mark -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 13:59 To: CF-Talk Subject: Re: Installing Tomcat 4 http://jakarta.apache.org/tomcat/ There's a pointer for you ;o) - Original Message - From: Robertson-Ravo, Neil (REC) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 1:44 PM Subject: Installing Tomcat 4 I know this is not CF related, but we are using Tomcat for one of our application features; thing is, do any of you guys know the process of installing it? I have Tomcat 4.x binary files which have been delivered to me as a .zip archive. I extracted these and I have the Tomcat.exe etc and whole host of .bat files.. Anyone got any pointers. Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Installing Tomcat 4
is that the technical term? ;) -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 14:13 To: CF-Talk Subject: RE: Installing Tomcat 4 ah it doesnt matter, turns out its a piece of piss :-) -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 14:10 To: CF-Talk Subject: RE: Installing Tomcat 4 there isnt an .exe installer, only binaries -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 14:01 To: CF-Talk Subject: RE: Installing Tomcat 4 run the exe and once done check the tomcat service is running (if you're opn windows) then you should be able to browse http://localhost:8080 which will provide the local tomcat docs hth mark -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 13:59 To: CF-Talk Subject: Re: Installing Tomcat 4 http://jakarta.apache.org/tomcat/ There's a pointer for you ;o) - Original Message - From: Robertson-Ravo, Neil (REC) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 1:44 PM Subject: Installing Tomcat 4 I know this is not CF related, but we are using Tomcat for one of our application features; thing is, do any of you guys know the process of installing it? I have Tomcat 4.x binary files which have been delivered to me as a .zip archive. I extracted these and I have the Tomcat.exe etc and whole host of .bat files.. Anyone got any pointers. Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Payflow in MX?
Since our upgrade to MX, the CFX_Cybercash tag has been flaky at best so we're making the move away from Cybercash to Payflow. Can anyone out there confirm for me that the CFX_PaymentNet tag functions correctly in MX? I believe Verisign offers an XML gateway too, but I really want the minimum amount of coding to get the migration done. Heh, who doesn't? Thanks, - Sean ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: Non-Windows CFMX interfacing emulated MS-Access db. was: SOT How to set up win XP network to be recognized by OS X
On Thursday, October 3, 2002, at 07:17 AM, Dick Applebaum wrote: It is possible to interface ColdFusion MX (CFMX) running on OS X 10.2.1 (Jaguar) to a MS-Access database running under VirtualPC emulated WinXP on the same machine. Dick, thanks for posting this update. Someday when I have some free time I'm definitely going to play with this. All of your work on behalf of the Mac CF developers out there are greatly appreciated! Running MX developer on my G4 tower rocks! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFC debug bug...
Here's my debug info: ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Math In MX?
Lee, Any resolution to this math error? I ran the division on my MX box and indeed the quotient is 0.346752058554 michael d corbridge macromedia 617.219.2307 [EMAIL PROTECTED] -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 10:19 PM To: CF-Talk Subject: Math In MX? Ok.. I'm confused... If... #countmale.record# = 379 (which a cfoutput confirms) And... #responses# = 1093 (which a cfoutput confirms) Then how the heck does... cfset Answer = #CountMale.RecordCount#/#Responses# End up being 0.0111569031498 ? The answer is simple math.. And SHOULD be.. 0.346752058554. Which, when multiplied by 100 yields the percentage. Sooo What am I missing? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: CFC debug bug...
Looks like your page is working :OD -Original Message- From: Michael Corbridge [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 14:35 To: CF-Talk Subject: RE: CFC debug bug... Here's my debug info: ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Header info displaying on site?
Hi all, I've got an app that's suddenly showing what looks like http header information at the top of every page on the site: HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Thu, 03 Oct 2002 13:46:25 GMT Connection: close Content-type: text/html Page-Completion-Status: Normal Set-Cookie: CFGLOBALS=HITCOUNT%3D1%23LASTVISIT%3D%7Bts+%272002%2D10%2D03+06%3A46%3A25%27 %7D%23TIMECREATED%3D%7Bts+%272002%2D10%2D03+06%3A46%3A25%27%7D%23; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; Set-Cookie: CFID=2150; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; Set-Cookie: CFTOKEN=47991225; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; Any idea what might be causing this? Thanks, Ian -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Payflow in MX?
Yes, I have tested CFX_PaymentNet with MX and have had no problems, the only thing you will have a problem with, at least I ran into this, if you use the installer it will tell you it can't detect Coldfusion on the system, just copy the dll file to your winnt\system32(if you're using windows) and register the tag yourself, other than that, it works fine. Ben -Original Message- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 9:26 AM To: CF-Talk Subject: Payflow in MX? Since our upgrade to MX, the CFX_Cybercash tag has been flaky at best so we're making the move away from Cybercash to Payflow. Can anyone out there confirm for me that the CFX_PaymentNet tag functions correctly in MX? I believe Verisign offers an XML gateway too, but I really want the minimum amount of coding to get the migration done. Heh, who doesn't? Thanks, - Sean ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
need info
My boss needs me to gather information for a project. What we need to quote is a system that will accept a minimum of 2500 faxes a day, store the image, a CF app will then store the image in the database. I have the CF part down, but Im still learning about the hardware required to handle the load. TIA Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - HYPERLINK http://www.comspecinternational.com; \nhttp://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** HYPERLINK http://www.empower-xl.com; \nhttp://www.empower-xl.com --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.391 / Virus Database: 222 - Release Date: 9/19/2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Header info displaying on site?
Let me guess, you've just upgraded IE? Perhaps to 6 SP1? Jb. -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 14:49 To: CF-Talk Subject: Header info displaying on site? Hi all, I've got an app that's suddenly showing what looks like http header information at the top of every page on the site: HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Thu, 03 Oct 2002 13:46:25 GMT Connection: close Content-type: text/html Page-Completion-Status: Normal Set-Cookie: CFGLOBALS=HITCOUNT%3D1%23LASTVISIT%3D%7Bts+%272002%2D10%2D03+06%3A46%3A25%27 %7D%23TIMECREATED%3D%7Bts+%272002%2D10%2D03+06%3A46%3A25%27%7D%23; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; Set-Cookie: CFID=2150; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; Set-Cookie: CFTOKEN=47991225; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; Any idea what might be causing this? Thanks, Ian -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
CFM Files Display as TXT
Any idea why CFM files when called by a browser would display them as if they were TEXT and not served up as CFM files from the CF Application Server? I am running CF5 under IIS. I do have index.cfm as a default document. But when I call: http://localhost/mydir/index.cfm it displays the contents of the file as text and not being processed accordingly. TIA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
need info...cont
FYI Ive done some research on this and found FAXPRESS, Optus Software, and Castelle. What Im looking for is an implementation, or in other words a solution that is working now. Thanks, Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - HYPERLINK http://www.comspecinternational.com; \nhttp://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** HYPERLINK http://www.empower-xl.com; \nhttp://www.empower-xl.com --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.391 / Virus Database: 222 - Release Date: 9/19/2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: Header info displaying on site?
Nope. I'm using Mozilla. This also happens in NS 4 and 6, on three separate client computers and two different servers... On 10/3/02 6:56 AM, John Beynon [EMAIL PROTECTED] wrote: Let me guess, you've just upgraded IE? Perhaps to 6 SP1? Jb. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Header info displaying on site?
talking of Moz, whats the best kind out there at the mo? -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 15:09 To: CF-Talk Subject: Re: Header info displaying on site? Nope. I'm using Mozilla. This also happens in NS 4 and 6, on three separate client computers and two different servers... On 10/3/02 6:56 AM, John Beynon [EMAIL PROTECTED] wrote: Let me guess, you've just upgraded IE? Perhaps to 6 SP1? Jb. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Header info displaying on site?
It will be to do with how CF puts information into the title tags of the page... Are you using CFHTMLHEAD or cfform tags on the pages where this occurs? -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 3, 2002 15:09 To: CF-Talk Subject: Re: Header info displaying on site? Nope. I'm using Mozilla. This also happens in NS 4 and 6, on three separate client computers and two different servers... On 10/3/02 6:56 AM, John Beynon [EMAIL PROTECTED] wrote: Let me guess, you've just upgraded IE? Perhaps to 6 SP1? Jb. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Header info displaying on site?
Hmm, I've only seen recent reports on people upgrading to IE6 - header info was displayed for some on MM's site... -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 15:09 To: CF-Talk Subject: Re: Header info displaying on site? Nope. I'm using Mozilla. This also happens in NS 4 and 6, on three separate client computers and two different servers... On 10/3/02 6:56 AM, John Beynon [EMAIL PROTECTED] wrote: Let me guess, you've just upgraded IE? Perhaps to 6 SP1? Jb. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
QofQ weirdness when using QueryNew
OK, I really need some help on this one. I have a query I create on the fly using QueryNew/QueryAddRow/QuerySetCell. Everything is fine until I try to use a cfquery with dbtype=Query on the created query to order the results - it throws a QofQ runtime error. If I comment out the cfquery and call the original query created with QueryNew, it runs fine and spits out the data (albeit unordered). I could really use some insight on this. I need to get that query in a particular ordered format and time is breathing down my neck. Here's a code snippet, it dies right on the cfquery tag saying Unsupported Numeric type conversionyet it worked fine in CF5: cfset newRow = QueryAddRow(teamStandings, 1) !--- set the cells in the query row --- cfset temp = QuerySetCell(teamStandings, site_id, #site_id#, #loop_count#) cfset temp = QuerySetCell(teamStandings, name, #orginization_name#, #loop_count#) cfset temp = QuerySetCell(teamStandings, wins, #wins#, #loop_count#) cfset temp = QuerySetCell(teamStandings, losses, #losses#, #loop_count#) cfset temp = QuerySetCell(teamStandings, ties, #ties#, #loop_count#) cfset temp = QuerySetCell(teamStandings, dist_wins, #dist_wins#, #loop_count#) cfset temp = QuerySetCell(teamStandings, dist_losses, #dist_losses#, #loop_count#) cfset temp = QuerySetCell(teamStandings, dist_ties, #dist_ties#, #loop_count#) cfset loop_count = loop_count + 1 /cfloop cfquery dbtype=Query name=Standings SELECT site_id, name, wins, losses, ties, dist_wins, dist_losses, dist_ties FROM teamStandings ORDER BY dist_wins /cfquery Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: QofQ weirdness when using QueryNew
Let me format that code a little better: cfset newRow = QueryAddRow(teamStandings, 1) !--- set the cells in the query row --- cfset temp = QuerySetCell(teamStandings, site_id, #site_id#, #loop_count#) cfset temp = QuerySetCell(teamStandings, name, #orginization_name#, #loop_count#) cfset temp = QuerySetCell(teamStandings, wins, #wins#, #loop_count#) cfset temp = QuerySetCell(teamStandings, losses, #losses#, #loop_count#) cfset temp = QuerySetCell(teamStandings, ties, #ties#, #loop_count#) cfset temp = QuerySetCell(teamStandings, dist_wins, #dist_wins#, #loop_count#) cfset temp = QuerySetCell(teamStandings, dist_losses, #dist_losses#, #loop_count#) cfset temp = QuerySetCell(teamStandings, dist_ties, #dist_ties#, #loop_count#) cfset loop_count = loop_count + 1 /cfloop cfquery dbtype=Query name=Standings SELECT site_id, name, wins, losses, ties, dist_wins, dist_losses, dist_ties FROM teamStandings ORDER BY dist_wins /cfquery -Original Message- From: Ryan Kime [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 9:23 AM To: CF-Talk Subject: QofQ weirdness when using QueryNew OK, I really need some help on this one. I have a query I create on the fly using QueryNew/QueryAddRow/QuerySetCell. Everything is fine until I try to use a cfquery with dbtype=Query on the created query to order the results - it throws a QofQ runtime error. If I comment out the cfquery and call the original query created with QueryNew, it runs fine and spits out the data (albeit unordered). I could really use some insight on this. I need to get that query in a particular ordered format and time is breathing down my neck. Here's a code snippet, it dies right on the cfquery tag saying Unsupported Numeric type conversionyet it worked fine in CF5: cfset newRow = QueryAddRow(teamStandings, 1) !--- set the cells in the query row --- cfset temp = QuerySetCell(teamStandings, site_id, #site_id#, #loop_count#) cfset temp = QuerySetCell(teamStandings, name, #orginization_name#, #loop_count#) cfset temp = QuerySetCell(teamStandings, wins, #wins#, #loop_count#) cfset temp = QuerySetCell(teamStandings, losses, #losses#, #loop_count#) cfset temp = QuerySetCell(teamStandings, ties, #ties#, #loop_count#) cfset temp = QuerySetCell(teamStandings, dist_wins, #dist_wins#, #loop_count#) cfset temp = QuerySetCell(teamStandings, dist_losses, #dist_losses#, #loop_count#) cfset temp = QuerySetCell(teamStandings, dist_ties, #dist_ties#, #loop_count#) cfset loop_count = loop_count + 1 /cfloop cfquery dbtype=Query name=Standings SELECT site_id, name, wins, losses, ties, dist_wins, dist_losses, dist_ties FROM teamStandings ORDER BY dist_wins /cfquery Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
TSQL
Hi folks: This question could be innapropiate but this list has always been great . Besides I'm a newbie. My problem is Transact-SQL related. I want to convert a numeric value (it 's the amount of seconds a user has spend in one of my sites) to this format hh:mm:ss .Is there any function in SQL transact that I could use ??. Any piece of advice should be appreciated. regards Mario ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: SQL error - Arithmetic overflow...?
Don't know for sure, but could it be that the fields where you're adding
27.5 are set up as integer fields? This might not have been a problem in
Access where there's just a 'number' datatype, but could make a difference
in sql with 'int', 'float', 'decimal' etc
If you've auto-upsized your access db to SQL and all the values in an access
'number' field were integers, the upsizer would probably create a SQL field
with type 'int'.
HTH
Alex
-Original Message-
From: Ed Gordon [mailto:[EMAIL PROTECTED]]
Sent: 03 October 2002 03:30
To: CF-Talk
Subject: SQL error - Arithmetic overflow...?
This ran just fine using Microsoft Access. Now I get an overflow?
Can you spot what's wrong? The values in the fields aren't
very big - the
largest is like 1952 to which I'm adding 20 or 30 or so...
=
ODBC Error Code = 22003 (Numeric value out of range)
[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic
overflow error
converting numeric to data type numeric.
SQL = Update MEMBERS Set status='Gold', current_point_ratio=1.25,
total_purchases=total_purchases+22,
purchases_this_year=purchases_this_year+22,
purchases_quarter_1=purchases_quarter_1+22,
total_points_earned=total_points_earned+27.5,
points_earned_this_year=points_earned_this_year+27.5,
points_earned_quarter_1=points_earned_quarter_1+27.5,
point_balance=point_balance+27.5, last_tran_posted_on={d
'2002-10-02'},
last_tran_posted_at={t '21:16:33'} Where
uuid='23A99597-9F04-11D6-AEAA00A0CC617FCD'
I guess it's too much to ask that they tell me WHAT value is
out of range -
or, since I am now using a real SQL database instead of MS
Access, do I
have to do all the calculations outside of the Update?
Thanks in Advance,
Ed Gordon
=
HERE'S THE CF CODE
=
CFQUERY datasource=#application.ds#
Update MEMBERS
Set status='#STATUSCHANGE#',
current_point_ratio=#RATIOCHANGE#,
total_purchases=total_purchases+#numAmount#,
purchases_this_year=purchases_this_year+#numAmount#,
purchases_quarter_1=purchases_quarter_1+#numAmount#,
total_points_earned=total_points_earned+#numPoints#,
points_earned_this_year=points_earned_this_year+#numPoints#,
points_earned_quarter_1=points_earned_quarter_1+#numPoints#,
point_balance=point_balance+#numPoints#,
last_tran_posted_on=#CREATEODBCDATE(tdazedate)#,
last_tran_posted_at=#CREATEODBCTIME(theodbctime)#
Where uuid='#getmember.uuid#'
/CFQUERY
=
HELP?
TIA
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CFM Files Display as TXT
Your default documents list shouldn't matter in this case although you may want to check to make sure the CF Server service hasn't stopped in NT Services... If the service is stopped, afaik IIS just passes the file on to the browser as is. Any idea why CFM files when called by a browser would display them as if they were TEXT and not served up as CFM files from the CF Application Server? I am running CF5 under IIS. I do have index.cfm as a default document. But when I call: http://localhost/mydir/index.cfm it displays the contents of the file as text and not being processed accordingly. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Header info displaying on site?
John, That may be the problem, but I've seen this happen before on ie4 and ie5 Ian, Check the HTML on that page. If I remember correctly, sometimes if this occurs if there is stuff in the header or above the html tag... Its been such a long time since I encountered this personally that I forget what the exact cause is, but basically its malformed HTML at the head of the page... Stephen - Original Message - From: John Beynon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 2:56 PM Subject: RE: Header info displaying on site? Let me guess, you've just upgraded IE? Perhaps to 6 SP1? Jb. -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 14:49 To: CF-Talk Subject: Header info displaying on site? Hi all, I've got an app that's suddenly showing what looks like http header information at the top of every page on the site: HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Thu, 03 Oct 2002 13:46:25 GMT Connection: close Content-type: text/html Page-Completion-Status: Normal Set-Cookie: CFGLOBALS=HITCOUNT%3D1%23LASTVISIT%3D%7Bts+%272002%2D10%2D03+06%3A46%3A25%27 %7D%23TIMECREATED%3D%7Bts+%272002%2D10%2D03+06%3A46%3A25%27%7D%23; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; Set-Cookie: CFID=2150; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; Set-Cookie: CFTOKEN=47991225; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; Any idea what might be causing this? Thanks, Ian -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Header info displaying on site?
Do you have any browsers where it doesn't happen? -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 15:09 To: CF-Talk Subject: Re: Header info displaying on site? Nope. I'm using Mozilla. This also happens in NS 4 and 6, on three separate client computers and two different servers... On 10/3/02 6:56 AM, John Beynon [EMAIL PROTECTED] wrote: Let me guess, you've just upgraded IE? Perhaps to 6 SP1? Jb. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Cumulative Patch for SQL Server (Q316333) Crtical for 2000
Microsoft Security Bulletin MS02-056 http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/bulletin/MS02-056.asp have fun, yet another crappy m$ patch from with no installer and 2 pages of instructions and it's rated critical for all internet instances z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: QofQ weirdness when using QueryNew
Ryan Kime wrote: OK, I really need some help on this one. I have a query I create on the fly using QueryNew/QueryAddRow/QuerySetCell. Everything is fine until I try to use a cfquery with dbtype=Query on the created query to order the results - it throws a QofQ runtime error. If I comment out the cfquery and call the original query created with QueryNew, it runs fine and spits out the data (albeit unordered). I could really use some insight on this. I need to get that query in a particular ordered format and time is breathing down my neck. Here's a code snippet, it dies right on the cfquery tag saying Unsupported Numeric type conversionyet it worked fine in CF5: when using querysetcell you need to explictly force the datatype with int() etc, there was a thread on this late last week z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: QofQ weirdness when using QueryNew
Ryan,
We had this error discussed a little while back. QuerySetCell types your
data as a string if you do not trick it into knowing othewise. It really
needs an additional parameter called type or something. Anyway, try this
trick on the dist_wins column set:
QuerySetCell(teamStandings, dist_wins, dist_wins * 1,loop_count);
This will cause it to be stored and typed as a number.
Also (since you are worried about formatting), you can do a lot less typing
with cfscript and querysetcell - i.e.
cfscript
FOR(loopcount = 1; loopcount LE somevalue; loopcount = loopcount + 1)
{ newRow = QueryAddRow(teamStandings, 1);
// set the cells in the query row
QuerySetCell(teamStandings, site_id,site_id,loop_count);
QuerySetCell(teamStandings, name, orginization_name,loop_count);
QuerySetCell(teamStandings, wins, wins,loop_count);
QuerySetCell(teamStandings, losses, losses,loop_count);
QuerySetCell(teamStandings, ties, ties, loop_count);
QuerySetCell(teamStandings, dist_wins, dist_wins * 1,loop_count);
QuerySetCell(teamStandings, dist_losses, dist_losses,loop_count);
QuerySetCell(teamStandings, dist_ties, dist_ties,loop_count);
}
/cfscript
As you can see - both in cfscript and Cfset syntax - you do not need the
pound signs. But in cfscript, you can skip the temp= because functions
that return boolean can be used directly.
-Mark
-Original Message-
From: Ryan Kime [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 9:29 AM
To: CF-Talk
Subject: RE: QofQ weirdness when using QueryNew
Let me format that code a little better:
cfset newRow = QueryAddRow(teamStandings, 1)
!--- set the cells in the query row ---
cfset temp = QuerySetCell(teamStandings, site_id, #site_id#,
#loop_count#)
cfset temp = QuerySetCell(teamStandings, name, #orginization_name#,
#loop_count#)
cfset temp = QuerySetCell(teamStandings, wins, #wins#, #loop_count#)
cfset temp = QuerySetCell(teamStandings, losses, #losses#,
#loop_count#)
cfset temp = QuerySetCell(teamStandings, ties, #ties#, #loop_count#)
cfset temp = QuerySetCell(teamStandings, dist_wins, #dist_wins#,
#loop_count#)
cfset temp = QuerySetCell(teamStandings, dist_losses, #dist_losses#,
#loop_count#)
cfset temp = QuerySetCell(teamStandings, dist_ties, #dist_ties#,
#loop_count#)
cfset loop_count = loop_count + 1
/cfloop
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Re: TSQL
I'm not aware of a simple native way to do this, though you can use dateadd math... select convert(varchar,hour(dateadd(s,#seconds#,#createodbcdate(now())#))) + ':' + convert(varchar,minute(dateadd(s,#seconds#,#createodbcdate(now())#))) + ':' + convert(varchar,second(dateadd(s,#seconds#,#createodbcdate(now())#))) If you're using SQL Server 2000 you could probably create a user defined function to return a value like this similarly: declare today smalldatetime; set today = convert(smalldatetime,convert(int,getdate())); then select as above using today and your seconds hth S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 Hi folks: This question could be innapropiate but this list has always been great . Besides I'm a newbie. My problem is Transact-SQL related. I want to convert a numeric value (it 's the amount of seconds a user has spend in one of my sites) to this format hh:mm:ss .Is there any function in SQL transact that I could use ??. Any piece of advice should be appreciated. regards Mario ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Running the CFMX Updater - virtual sites
Hi, I've just stumbled across the COM problems in CFMX and have installed the Update but nothing has changed with my COM problem. Its a simple call to the Excel object to read a simple value and worked fine in CF4.5.2 I've even re-run wsconfig.jar on the server in an attempt to transfer the *update* to the virtual sites. My code, which worked fine in CF4.5 is below: _ cfset file=D:\datasource\finance.xls !--- Try to connect to the Excel application object --- CFTRY !--- If it exists, connect to it --- CFOBJECT ACTION=CONNECT CLASS=Excel.Application NAME=objExcel TYPE=COM CFCATCH !--- The object doesn't exist, so create it --- CFOBJECT ACTION=CREATE CLASS=Excel.Application NAME=objExcel TYPE=COM /CFCATCH /CFTRY cfscript // Get the workbooks collection // objBooks = objExcel.Workbooks; // Open and activate the workbook // objBook = objBooks.Open(File); objBook.Activate(); // Get the sheets collection // objSheets = objBook.WorkSheets; // Get a named sheet // objSheet = objSheets.Item(apr); // Create the range and copy the records from ADO // objRange = objSheet.Range(B2:B2); objRange.Value=#quotation.term#; objRange = objSheet.Range(C2:C2); objRange.Value=-#monthlyadj#; objRange = objSheet.Range(D2:D2); objRange.Value=#loan_amt#; objRange = objSheet.Range(E2:E2); objRange.Value=#quotation.apr#/100; // Save the file // objSheet.SaveAs(File, Val(1)); // Kill the ADO and Excel objects // objBook.Close(); /cfscript _ All this does is utilise Excel's APR calculation macro. Although I may be able to figure a workaround to this particular issue without using COM, I do have other applications which rely heavily on connecting to Exchange using COM. Are there any other alternatives for connecting to Exchange? Many TIA _ Dave Wilson Chief Technology Officer Integrated Auto Solutions Ltd The Howard Building 155 Northumberland Street Belfast BT13 2JF t: +44 28 9024 3123 f: +44 28 9024 3124 e: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Header info displaying on site?
I spoke to MS about it when I first saw it and they referred me to an article that basically affected *any* update of the IE software..althought there was no definitive answer and I've forgotten the Q number. Jb. -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 15:35 To: CF-Talk Subject: Re: Header info displaying on site? John, That may be the problem, but I've seen this happen before on ie4 and ie5 Ian, Check the HTML on that page. If I remember correctly, sometimes if this occurs if there is stuff in the header or above the html tag... Its been such a long time since I encountered this personally that I forget what the exact cause is, but basically its malformed HTML at the head of the page... Stephen - Original Message - From: John Beynon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 2:56 PM Subject: RE: Header info displaying on site? Let me guess, you've just upgraded IE? Perhaps to 6 SP1? Jb. -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 14:49 To: CF-Talk Subject: Header info displaying on site? Hi all, I've got an app that's suddenly showing what looks like http header information at the top of every page on the site: HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Thu, 03 Oct 2002 13:46:25 GMT Connection: close Content-type: text/html Page-Completion-Status: Normal Set-Cookie: CFGLOBALS=HITCOUNT%3D1%23LASTVISIT%3D%7Bts+%272002%2D10%2D03+06%3A46%3A25%27 %7D%23TIMECREATED%3D%7Bts+%272002%2D10%2D03+06%3A46%3A25%27%7D%23; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; Set-Cookie: CFID=2150; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; Set-Cookie: CFTOKEN=47991225; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; Any idea what might be causing this? Thanks, Ian -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Header info displaying on site?
No - it's definitely my code... On 10/3/02 7:41 AM, Adrian Lynch [EMAIL PROTECTED] wrote: Do you have any browsers where it doesn't happen? -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: -OT- Another Javascript problem with forms
Thane,
I can get the fields to sum correctly by ensuring that the initial value of:
window.document.ExpenseForm.GrandTotalAmount.value = 0;
outside the while loop;
SCRIPT language=Javascript
function addTotals()
{
i = 0
window.document.ExpenseForm.GrandTotalAmount.value = i;
while (i = #GetFormInfo.RecordCount#)
{
window.document.ExpenseForm.GrandTotalAmount.value=parseFloat(window.document.ExpenseForm.GrandTotalAmount.value)+parseFloat(eval(window.document.ExpenseForm.TotalAmount+i+.value));
i++
}
}
/SCRIPT
- mike
-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 01, 2002 11:29 AM
To: CF-Talk
Subject: -OT- Another Javascript problem with forms
Ok, I got my two fields to add up and display in another field with this:
onchange=window.document.ExpenseForm.TotalAmount#Line#.value=parseFloat(window.document.ExpenseForm.Mileage#Line#.value)+parseFloat(window.document.ExpenseForm.CostOfMeals#Line#.value);addTotals();
Now I'm trying to add up all the TotalAmounts and put it at the bottom of
the form. I need to loop through the entire list from 1 to #list# on each
onChange and update the GrandTotal. I can't figure out how to loop in
Javascript and hand it a dynamic variable name. I tried this:
SCRIPT language=Javascript
function addTotals()
{
i = 0
while (i = #GetFormInfo.RecordCount#)
{
window.document.ExpenseForm.GrandTotalAmount.value=parseFloat(window.document.ExpenseForm.GrandTotalAmount.value)+parseFloat(eval(window.document.ExpenseForm.TotalAmount+i+.value));
i++
}
}
/SCRIPT
But it doesn't work doesn't appear to go through each variable name. How
would I do this?
T
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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
RE: TSQL
Mario, If you know the field is a cerain length you can cast it as a char: CAST(myNumField, Char(6)), then use substring( ) to concatenate it: DECLARE @myString char(6) DECLARE @myTime char(8) SELECT @myString = (SELECT CAST(myNumField, Char(6)) FROM table where . ) SELECT @myTime = LEFT(@mySTring,2) + ':' + SUBSTRING(@myString,3,2) + ':' + RIGHT(@myString,2) You could do this within a query (without the declaritive syntax) by casting 3 times: SELECT LEFT(CAST(myNumField, Char(6)),2) + ':' + SUBSTRING(CAST(myNumField, Char(6)),3,2) + ':' + RIGHT(CAST(myNumField, Char(6)),2) AS myTimeString FROM mytable If you are using SQL 2000 you can create a UDF scalar function and use it in-line. -mk -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 9:30 AM To: CF-Talk Subject: TSQL Hi folks: This question could be innapropiate but this list has always been great . Besides I'm a newbie. My problem is Transact-SQL related. I want to convert a numeric value (it 's the amount of seconds a user has spend in one of my sites) to this format hh:mm:ss .Is there any function in SQL transact that I could use ??. Any piece of advice should be appreciated. regards Mario ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: CFC debug bug...
sorry, try again 0 ms 0 ms 1 CFC[ C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfc | feedTheBeaver( grapes, 1) ] from C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfm 0 ms 0 ms 1 CFC[ C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfc | feedTheBeaver( pears, 1) ] from C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfm 0 ms 0 ms 1 CFC[ C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfc | feedTheBeaver( sirloin steak, 1) ] from C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfm 0 ms 0 ms 1 CFC[ C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfc | feedTheBeaver(apples, 1) ] from C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfm -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 9:37 AM To: CF-Talk Subject: RE: CFC debug bug... Looks like your page is working :OD -Original Message- From: Michael Corbridge [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 14:35 To: CF-Talk Subject: RE: CFC debug bug... Here's my debug info: ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Report: CF Fatal Errors
Has anyone seen this error in the server.log file from the CF Administrator? Caught a fatal signal (4) - Aborting OR Caught a fatal signal (11) - Aborting After receiving this error, CF Executive (I imagine) initiates a call for restarting the CF Application Server Services. If so, any ideas what it means as well as possible causes? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: QofQ weirdness when using QueryNew (SOLVED)
Thank you Zac and Mark! The int() did the trick...you're right Mark, the
cfscript way does look cleaner.
Thanks again
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 9:52 AM
To: CF-Talk
Subject: RE: QofQ weirdness when using QueryNew
Ryan,
We had this error discussed a little while back. QuerySetCell types your
data as a string if you do not trick it into knowing othewise. It really
needs an additional parameter called type or something. Anyway, try this
trick on the dist_wins column set:
QuerySetCell(teamStandings, dist_wins, dist_wins * 1,loop_count);
This will cause it to be stored and typed as a number.
Also (since you are worried about formatting), you can do a lot less typing
with cfscript and querysetcell - i.e.
cfscript
FOR(loopcount = 1; loopcount LE somevalue; loopcount = loopcount + 1)
{ newRow = QueryAddRow(teamStandings, 1);
// set the cells in the query row
QuerySetCell(teamStandings, site_id,site_id,loop_count);
QuerySetCell(teamStandings, name, orginization_name,loop_count);
QuerySetCell(teamStandings, wins, wins,loop_count);
QuerySetCell(teamStandings, losses, losses,loop_count);
QuerySetCell(teamStandings, ties, ties, loop_count);
QuerySetCell(teamStandings, dist_wins, dist_wins * 1,loop_count);
QuerySetCell(teamStandings, dist_losses, dist_losses,loop_count);
QuerySetCell(teamStandings, dist_ties, dist_ties,loop_count); }
/cfscript
As you can see - both in cfscript and Cfset syntax - you do not need the
pound signs. But in cfscript, you can skip the temp= because functions
that return boolean can be used directly.
-Mark
-Original Message-
From: Ryan Kime [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 9:29 AM
To: CF-Talk
Subject: RE: QofQ weirdness when using QueryNew
Let me format that code a little better:
cfset newRow = QueryAddRow(teamStandings, 1)
!--- set the cells in the query row ---
cfset temp = QuerySetCell(teamStandings, site_id, #site_id#,
#loop_count#) cfset temp = QuerySetCell(teamStandings, name,
#orginization_name#, #loop_count#) cfset temp =
QuerySetCell(teamStandings, wins, #wins#, #loop_count#) cfset temp =
QuerySetCell(teamStandings, losses, #losses#, #loop_count#) cfset temp
= QuerySetCell(teamStandings, ties, #ties#, #loop_count#) cfset temp =
QuerySetCell(teamStandings, dist_wins, #dist_wins#, #loop_count#) cfset
temp = QuerySetCell(teamStandings, dist_losses, #dist_losses#,
#loop_count#) cfset temp = QuerySetCell(teamStandings, dist_ties,
#dist_ties#, #loop_count#)
cfset loop_count = loop_count + 1
/cfloop
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
RE: CFC debug bug...
More importantly, is the beaver still getting fed? Ade -Original Message- From: Michael Corbridge [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 14:40 To: CF-Talk Subject: RE: CFC debug bug... sorry, try again 0 ms 0 ms 1 CFC[ C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfc | feedTheBeaver( grapes, 1) ] from C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfm 0 ms 0 ms 1 CFC[ C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfc | feedTheBeaver( pears, 1) ] from C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfm 0 ms 0 ms 1 CFC[ C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfc | feedTheBeaver( sirloin steak, 1) ] from C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfm 0 ms 0 ms 1 CFC[ C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfc | feedTheBeaver(apples, 1) ] from C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfm -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 9:37 AM To: CF-Talk Subject: RE: CFC debug bug... Looks like your page is working :OD -Original Message- From: Michael Corbridge [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 14:35 To: CF-Talk Subject: RE: CFC debug bug... Here's my debug info: ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Repost: CF Fatal Errors
Has anyone seen this error in the server.log file from the CF Administrator? Caught a fatal signal (4) - Aborting OR Caught a fatal signal (11) - Aborting After receiving this error, CF Executive (I imagine) initiates a call for restarting the CF Application Server Services. If so, any ideas what it means as well as possible causes? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: TSQL
Quoting Mario Martinez [EMAIL PROTECTED]:
My problem is Transact-SQL related. I want to convert a numeric value
(it 's the amount of seconds a user has spend in one of my sites) to
this format hh:mm:ss .Is there any function in SQL transact that I
could use ??.
Why not use plain old SQL?
SELECT
EXTRACT('hour', INTERVAL 'your_number SECOND')
|| ':'
|| EXTRACT('minute', INTERVAL 'your_number SECOND')
|| ':'
|| EXTRACT('second', INTERVAL 'your_number SECOND');
Jochem
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
RE: Printing Crystal Report from web page?
Thanks to both Kevan and Frank. We ARE using the ActiveX control (well, the viewrpt.cwr file), but we can't use a native Crystal report because it includes the option to change the query parameters. In our case that would be a huge security hole. So, the reports are dumped to HTML (for now), but now we introduce problems when printing. We are digging through the documentation now to try using PDF. Thanks for the info though. Shawn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 2:20 AM To: CF-Talk Subject: RE: Printing Crystal Report from web page? You can also get crystal to output to PDF, if like us you think the report viewers are a bit clunky. -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 02:38 To: CF-Talk Subject: Re: Printing Crystal Report from web page? The best method I've found is to install Crystal Reports Developers Edition on your web server and use their ActiveX or Java viewers. This way you get perfect reports as they we designed to look and print. However there is a learning curve to integrate them with CF. All of the knowledge available to do this from the Crystal site involves ASP. In order to be as productive as possible, we purchased a product called ReCrystallize which generates the ASP pages for us. Both the input forms and the processing page to open the viewer and send in your report parameters. We basically discard the input form and create our own to suit our needs with CF. Of course we need to match the field names the generated processing page is expecting. Hope this helps, Frank Mamone - Original Message - From: Shawn Grover [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 02, 2002 4:37 PM Subject: OT: Printing Crystal Report from web page? We have a number of crystal reports which get rendered to a web page. The developer that set this stuff up has left us, leaving me to fix some minor issues. For the most part, I don't have a problem working with the reports themselves. However, using a Crystal report in a web page leaves me with a few questions. The biggest of which is printing. The problem I'm seeing right now is that when we print a report (from the web page), it will occasionally print half a line on one page, and the other half on the next page. I modified the reports to leave some space in the page footer, and to reserve space for the page footer, but I still see the splitting of lines. Further digging shows that the print function is doing a javascript window.print(); - so it's printing the web page, not the report itself. Any suggestions how to deal with this issue? Thanks in advance. Shawn Grover ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Installed CFMX Updater - Administrator has disappeared!!
Hi, Further to my last email about discovering COM problems and installing the updater, I've just discovered the CF Administration tool has become inaccessible. I'm getting a 404 not found returned when I browse to http://servername/cfide/administrator/index.cfm which is the url I've always used over the years. I've checked the server and all files are indeed where they should be. All mappings are as they should be in IIS and there are no network problems occurring. I also ran wsconfig.jar as I noticed my COM problems were still present after the update and thought perhaps the updated settings needed *transferring* to the virtual sites. Anyone any ideas what could be the problem here? TIA, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
SOLVED: Re: Header info displaying on site?
Just thought I'd post this - I found the solution. Turns out the ampersand in the title tag was causing the browser/server to dump the header info. Interesting feature... On 10/3/02 7:54 AM, Ian Lurie [EMAIL PROTECTED] wrote: No - it's definitely my code... On 10/3/02 7:41 AM, Adrian Lynch [EMAIL PROTECTED] wrote: Do you have any browsers where it doesn't happen? -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CFC debug bug...
Curious...I am able to replicate it with ease. Have you applied the patch yet? -- jon mailto:[EMAIL PROTECTED] Thursday, October 3, 2002, 9:39:57 AM, you wrote: MC sorry, MC try again MC 0 ms 0 ms 1 CFC[ C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfc | feedTheBeaver( grapes, 1) ] from C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfm MC 0 ms 0 ms 1 CFC[ C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfc | feedTheBeaver( pears, 1) ] from C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfm MC 0 ms 0 ms 1 CFC[ C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfc | feedTheBeaver( sirloin steak, 1) ] from C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfm MC 0 ms 0 ms 1 CFC[ C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfc | feedTheBeaver(apples, 1) ] from C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfm ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFC debug bug...
Jon, can you zip the stuff up and send to me offline so I can test against my CFMX install? -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 16:56 To: CF-Talk Subject: Re: CFC debug bug... Curious...I am able to replicate it with ease. Have you applied the patch yet? -- jon mailto:[EMAIL PROTECTED] Thursday, October 3, 2002, 9:39:57 AM, you wrote: MC sorry, MC try again MC 0 ms 0 ms 1 CFC[ C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfc | feedTheBeaver( grapes, 1) ] from C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfm MC 0 ms 0 ms 1 CFC[ C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfc | feedTheBeaver( pears, 1) ] from C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfm MC 0 ms 0 ms 1 CFC[ C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfc | feedTheBeaver( sirloin steak, 1) ] from C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfm MC 0 ms 0 ms 1 CFC[ C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfc | feedTheBeaver(apples, 1) ] from C:\CFusionMX\wwwroot\research\cfBugs\cftalk-03.cfm ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
OT: CF_TwoSelectsRelated beg
Could someone send me a copy of Nate Weiss' TwoSelectsRelated or point me to a site where I can grab it? devex.macromedia appears to be down, and Nate's site is mostly offline. TIA, Jeff ([EMAIL PROTECTED], [EMAIL PROTECTED]) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: TSQL
cool - never seen that syntax before.
-mk
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 9:55 AM
To: CF-Talk
Subject: Re: TSQL
Quoting Mario Martinez [EMAIL PROTECTED]:
My problem is Transact-SQL related. I want to convert a numeric value
(it 's the amount of seconds a user has spend in one of my sites) to
this format hh:mm:ss .Is there any function in SQL transact that I
could use ??.
Why not use plain old SQL?
SELECT
EXTRACT('hour', INTERVAL 'your_number SECOND')
|| ':'
|| EXTRACT('minute', INTERVAL 'your_number SECOND')
|| ':'
|| EXTRACT('second', INTERVAL 'your_number SECOND');
Jochem
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CF_TwoSelectsRelated beg
Oldish version coming to you off line - Original Message - From: Jeff Beer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 5:06 PM Subject: OT: CF_TwoSelectsRelated beg Could someone send me a copy of Nate Weiss' TwoSelectsRelated or point me to a site where I can grab it? devex.macromedia appears to be down, and Nate's site is mostly offline. TIA, Jeff ([EMAIL PROTECTED], [EMAIL PROTECTED]) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Websphere version
The info reported back to me on the question is that 4.03 is the supported version. It may work with other versions, but it's not been tested on them. I hope this info helps! -Vern -Original Message- From: Robert Shaw [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 12:47 PM To: CF-Talk Subject: Websphere version In the CFMX for Websphere Docs it states version 4.03 is supported, can someone please confirm that any versions higher, i.e. 4.04 or 5, are definitely _not_ supported. Thanks, Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
CFC Browser in DWMX
Anyone have this just stop working? I'm running CFMX on win2k on the local machine. I can access CFC's in the explorer via the URL in a browser but not through DWMX. I haven't changed any of my settings for the defined site...but re-verified them just to make sure and everything looks as it should... Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFC Browser in DWMX
Now this is odd... http://localhost:8500/CFIDE/componentutils/cfcexplorer.cfc?method=getcfcs Which I believe is the method used by DWMX returns this in a browser: Error Occurred While Processing Request Variable FILENAMES is undefined. The error occurred in C:\CFusionMX\wwwroot\CFIDE\componentutils\cfcexplorer_utils.cfm: line 152 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: CFC Browser in DWMX
Appears to be a bug. It turned out to be a custom tag path that I added in the CFAdmin. The dir contains one tag called forward...whenever I enable this tag path the CFC explorer in DWMX breaks...and also via the web as per my last email... *shrugs* -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 12:33 PM To: CF-Talk Subject: RE: CFC Browser in DWMX Now this is odd... http://localhost:8500/CFIDE/componentutils/cfcexplorer.cfc?method=getcfcs Which I believe is the method used by DWMX returns this in a browser: Error Occurred While Processing Request Variable FILENAMES is undefined. The error occurred in C:\CFusionMX\wwwroot\CFIDE\componentutils\cfcexplorer_utils.cfm: line 152 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: CFC Browser in DWMX
I will attempt to reproduce and log a bug if necessary. Thanks Stacy. Collin Tobin QA Engineer 617 219 2000 [EMAIL PROTECTED] Macromedia® What the web can be.(tm) -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 12:50 PM To: CF-Talk Subject: RE: CFC Browser in DWMX Appears to be a bug. It turned out to be a custom tag path that I added in the CFAdmin. The dir contains one tag called forward...whenever I enable this tag path the CFC explorer in DWMX breaks...and also via the web as per my last email... *shrugs* -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 12:33 PM To: CF-Talk Subject: RE: CFC Browser in DWMX Now this is odd... http://localhost:8500/CFIDE/componentutils/cfcexplorer.cfc?method=getcfcs Which I believe is the method used by DWMX returns this in a browser: Error Occurred While Processing Request Variable FILENAMES is undefined. The error occurred in C:\CFusionMX\wwwroot\CFIDE\componentutils\cfcexplorer_utils.cfm: line 152 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Where can I find a free source of news content?
I am looking for a source of inexpensive news-based content that can be either consumed as a web service or harvested from conventional web pages. I don't want to have to link or be redirected to the actual source but include it in my site and make it look as if it is mine. The reason why I ask is that I want to keep my site full of fresh content. I have done a search on free Webservices and got lots of stuff, but all of them have a little Gotch in the license agreement. Any ideas?? Thanks in advance. Dave Adams CFUG Ottawa ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Converting new lines to br
Thanks for the info. That did the trick. I ended up writing it a function cffunction name=nl2br returnType=string cfargument name=string type=string cfreturn replace(string, #chr(10)#, br#chr(10)#, all) /cffunction Luis -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 5:06 PM To: CF-Talk Subject: RE: Converting new lines to br I've used this: replace(string, #chr(10)#, br#chr(10)#, all) --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Luis Lebron [mailto:[EMAIL PROTECTED]] : Sent: Wednesday, October 02, 2002 5:53 PM : To: CF-Talk : Subject: Converting new lines to br : : : I'm new to Cold Fusion so bear with me. Is there a way of converting new : lines in a string to html line breaks br. If you are familiar : with PHP I'm : looking for something like the nl2br function. : : : thanks, : : Luis : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: CFC Browser in DWMX
Thanks Collin...here's the details: Aside from the default custom tag mapping I had two others. Both mapped to directories somewhere under c:\CFusionMX\wwwroot C:\CFusionMX\wwwroot\ino\src\customTags forward2.cfm secure.cfm C:\CFusionMX\wwwroot\zeus\customTags Forward.cfm I'm running on Win2k with Apache 2 but I'm using the internal web server to access any CFC explorer related functions. My mappings in DWMX also use the internal web server. HTH, Stace -Original Message- From: Collin Tobin [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 12:52 PM To: CF-Talk Subject: RE: CFC Browser in DWMX I will attempt to reproduce and log a bug if necessary. Thanks Stacy. Collin Tobin QA Engineer 617 219 2000 [EMAIL PROTECTED] Macromedia(r) What the web can be.(tm) -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 12:50 PM To: CF-Talk Subject: RE: CFC Browser in DWMX Appears to be a bug. It turned out to be a custom tag path that I added in the CFAdmin. The dir contains one tag called forward...whenever I enable this tag path the CFC explorer in DWMX breaks...and also via the web as per my last email... *shrugs* -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 12:33 PM To: CF-Talk Subject: RE: CFC Browser in DWMX Now this is odd... http://localhost:8500/CFIDE/componentutils/cfcexplorer.cfc?method=getcfcs Which I believe is the method used by DWMX returns this in a browser: Error Occurred While Processing Request Variable FILENAMES is undefined. The error occurred in C:\CFusionMX\wwwroot\CFIDE\componentutils\cfcexplorer_utils.cfm: line 152 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Where can I find a free source of news content?
Tons of them out there. http://www.syndic8.com is a decent one. Webservices, I think, has a different meaning for most of the web than what you're searching for. Try XML Newsfeeds or RSS Newsfeeds and the like. HTH, Russ -Original Message- From: David Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 11:50 AM To: CF-Talk Subject: Where can I find a free source of news content? I am looking for a source of inexpensive news-based content that can be either consumed as a web service or harvested from conventional web pages. I don't want to have to link or be redirected to the actual source but include it in my site and make it look as if it is mine. The reason why I ask is that I want to keep my site full of fresh content. I have done a search on free Webservices and got lots of stuff, but all of them have a little Gotch in the license agreement. Any ideas?? Thanks in advance. Dave Adams CFUG Ottawa ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Client Variables
Is anyone experiencing odd database issues with MX? We are migrating to MX, have MS SQL 7 database, and are experiencing things such as: * client variables not being saved - cfide:token are but the data is not * some select statements that used to work in 5 are now returning 0 records in MX, but when run in query analyzer return records (so it's good SQL) Seems odd that everything worked fine on 5 now lots of stuff is bombing on MX. We are thinking it might be a JDBC-ODBC problem... Anyway, is anyone having strange database happenings with MS SQL 7? Cheers, Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Header info displaying on site?
I've run into this problem before. I believe, in my case, it occurred when using the cfhtmlhead tag and the cflocation tag in tandem. If I looked at the source of the page that was the target of the redirection, I'd see the content set by the cfhtmlhead tag above the HTTP headers of the page. If I remember correctly, the work around was to use the cfheader tag to set the temporary redirect in place of the cflocation tag. Actually, I think I issued a refresh rather than a HTTP temporary redirect. Not sure why though. It's all a bit hazy. :P HTTP refresh: cfheader name=Refresh value=0; URL=http://www.domain.com/page.cfm; Or, you might just try a HTTP temporary redirect: cfheader name=location value=http://www.domain.com/page.cfm; cfheader statuscode=302 statustext=Document Temporarily Moved Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 9:49 AM To: CF-Talk Subject: Header info displaying on site? Hi all, I've got an app that's suddenly showing what looks like http header information at the top of every page on the site: HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Thu, 03 Oct 2002 13:46:25 GMT Connection: close Content-type: text/html Page-Completion-Status: Normal Set-Cookie: CFGLOBALS=HITCOUNT%3D1%23LASTVISIT%3D%7Bts+%272002%2D10%2D03+06%3A46%3A2 5%27 %7D%23TIMECREATED%3D%7Bts+%272002%2D10%2D03+06%3A46%3A25%27%7D%23; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; Set-Cookie: CFID=2150; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; Set-Cookie: CFTOKEN=47991225; expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/; Any idea what might be causing this? Thanks, Ian -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Client Variables
It seems that CFMX has us tighting up our code. We had an issue where a db column conflicted with a session structure setting, we had to rename the structure (or the table column name). There are other things, but we found that it was usually something sloppy on our end ... I am not sure if they meant for it to be that way, but all the errors we found could have been done a better way so we changed things. Paul Giesenhagen QuillDesign - Original Message - From: Rob Rohan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:19 PM Subject: Client Variables Is anyone experiencing odd database issues with MX? We are migrating to MX, have MS SQL 7 database, and are experiencing things such as: * client variables not being saved - cfide:token are but the data is not * some select statements that used to work in 5 are now returning 0 records in MX, but when run in query analyzer return records (so it's good SQL) Seems odd that everything worked fine on 5 now lots of stuff is bombing on MX. We are thinking it might be a JDBC-ODBC problem... Anyway, is anyone having strange database happenings with MS SQL 7? Cheers, Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Client Variables
Thank you, that is a possibility - I am rather sure there is some code that does what you are suggesting. Thanks again I'll check that. -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 10:25 AM To: CF-Talk Subject: Re: Client Variables It seems that CFMX has us tighting up our code. We had an issue where a db column conflicted with a session structure setting, we had to rename the structure (or the table column name). There are other things, but we found that it was usually something sloppy on our end ... I am not sure if they meant for it to be that way, but all the errors we found could have been done a better way so we changed things. Paul Giesenhagen QuillDesign - Original Message - From: Rob Rohan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 12:19 PM Subject: Client Variables Is anyone experiencing odd database issues with MX? We are migrating to MX, have MS SQL 7 database, and are experiencing things such as: * client variables not being saved - cfide:token are but the data is not * some select statements that used to work in 5 are now returning 0 records in MX, but when run in query analyzer return records (so it's good SQL) Seems odd that everything worked fine on 5 now lots of stuff is bombing on MX. We are thinking it might be a JDBC-ODBC problem... Anyway, is anyone having strange database happenings with MS SQL 7? Cheers, Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
