RE: NumberFormat UGH
sounds like the problem is with the DB you are using. Not sure how formatting the number with CF once you have pulled it from the db would help. What DB is it you are using? will -Original Message- From: David Schmidt [mailto:[EMAIL PROTECTED]] Sent: 19 April 2002 20:54 To: CF-Talk Subject: RE: NumberFormat UGH Will that work for Income Taxes too??? -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 12:48 PM To: CF-Talk Subject: RE: NumberFormat UGH Place curser on your NumberFormat and push the F1 key. All answers shall be revealed. :) -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 2:37 PM To: CF-Talk Subject: NumberFormat UGH I have searched hi and low for some explination, but am at a loss. I have a column in the db: weight, it is a float Values can range beyond 123445.23223 and .03322323 Is there a way to use numberformat so you can show these as they are... when I stick .03322323 into the database, it comes out 3.32232299E-2 Can't use decimalformat, need the multiple decimals ... numberformat either padds too many spaces or doesn't give me enough.. Anyone have any good recommendations for formating variable sized numbers with decimals? Thank Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
BIG VULNERABILITY
Hi All, I found this on cfdjlist and found it very worth of posting here since this list is getting more traffic than cfdjlist these days. I've tried this test on several of our more well known CF sites and many of them failed. Good morning: I wanted to pass this one along from the webappsec list. CF 4 and 4.5 also appear to be vulnerable to this- the workaround is ok. I'm battening down the hatches this morning. Kudos to Peter Grundl for finding this and letting us know. -Sean - Original Message - From: Peter Gründl [EMAIL PROTECTED] To: bugtraq [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 8:01 AM Subject: KPMG-2002013: Coldfusion Path Disclosure Title: Coldfusion Path Disclosure BUG-ID: 2002013 Released: 18th Apr 2002 Problem: Requests for certain DOS-devices are parsed by the isapi filter that handles .cfm and .dbm and result in error messages containing the physical path to the web root. Vulnerable: === - Coldfusion 5.0 on Windows 2000 w. IIS5 - Other versions were not tested. Details: Requests for non-existant .cfm and .dbm files return a coldfusion Object Not Found error message similar to this: Error Occurred While Processing Request Error Diagnostic Information An error has occurred. HTTP/1.0 404 Object Not Found Requesting a DOS-device, such as nul.dbm or nul.cfm returns: Error Occurred While Processing Request Error Diagnostic Information Cannot open CFML file The requested file C:\data\nul.dbm cannot be found. The specific sequence of files included or processed is: C:\data\nul.dbm Date/Time: 04/18/02 11:32:16 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0; T312461) Remote Address: xxx.xxx.xxx.xxx A similar result can be achieved with this request: /nul..dbm which returns: Error Occurred While Processing Request Error Diagnostic Information The template specification, 'C:\data\nul..dbm', is illegal. Template specifications cannot include '..' nor begin with a backslash ('\\'). Vendor URL: === You can visit the vendors webpage here: http://www.coldfusion.com Vendor response: The vendor was contacted on the 26th of November, 2001. The vendor suggested a workaround for the problem on the 8th of January, 2002. This advisory was delayed was due to a lapse of communication. Corrective action: == The vendor suggests turning on Check that file exists: Windows 2000: 1. Open the Management console 2. Click on Internet Information Services 3. Right-click on the website and select Properties 4. Select Home Directory 5. Click on Configuration 6. Select .cfm 7. Click on Edit 8. Make sure Check that file exists is checked 9. Do the same for .dbm Author: Peter Gründl ([EMAIL PROTECTED]) KPMG is not responsible for the misuse of the information we provide through our security advisories. These advisories are a service to the professional security community. In no event shall KPMG be lia- ble for any consequences whatsoever arising out of or in connection with the use or spread of this information. !--- Jason Dowdell [EMAIL PROTECTED] 321.799.6845 IM AES - Web Developer --- __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF's Most Wanted ::
(Features, that is...) With all this talk of learning other languages to flesh out your portfolio, and more importantly your knowledge, along with the looming release of NEO/CFMX, I've been trying to think of the features that I currently miss in my ColdFusion. And I thought what better way to get Macromedia's attention, then by creating a heated discussion among the leading, path-forging cf users, which obviously reside on this list (yes, I'm buttering you up.) It seams to me that we see some of the same issues puzzling new or begginer users over and over again, or some great features that are available though creative uses of custom tags are not readily available to those developers hosting on shared servers. And I feel that MM could easily add some nice new tags or attributes to current tags that solve most everyone's problems (and I know nothing is that easy, but it'd be nice.) I also know most of us have submitted feature requests on MM's site, but the community never really geats to chime in. So what I'd like to do is gather up a few of your ideas for improving ColdFusion just to let MM know what we're are thinking. I'm also very interested in what other developers are thinking, and I'm sure y'all are too. I know that timing probably isn't the best for their very, very busy brains over in MM land right now, but there really isn't anytime better than the present. Here's some of the basic probelms that I've come across and that I've seen pop up on this list over and over from the last couple of years: cfmail/cfpop: Needs more stability, more power, ability to read and write multi-part messages (at least), maybe kill the spool or move straight to the a Java spool (with NEO's Java backbone, there really is no excuse not to revamp this tag) cfimage (new tag): Abilty to resize images on the fly, store in cache, read dimensions, etc. (should be a cinch with Macromedia's expertise in graphic products [yea, right]) locking: Needs to protect the server. Period. cfgraph: Use flash to it's fullest. The current tag is a start, but still weak. Needs options galore. cfdirectory: Please just give us one more attribute (filesonly=True, or type=file) or update filter to accept type=file or type=dir. Those directory dots irk me 99% of the time I use the tag. c# support: I'm not even sure this is a possilbilty and it's probably a little early to call for it, but something to think about. And I know that a lot of these features are available as custom tags, etc, right now. But it's not always a feasible option for many developers who are on a monetary or time constraint, or are just hosting on a public server that doesn't allow custom tags. (Honestly, I'm not trying to put anyone out of business.) NOTE: I'm also aware that some some of these things may already be alleviated or improved upon in NEO. For all the Beta testers and PDA hounds out there, please do not jump in on this discussion and say That's already developed and then the subsequent You're not allowed to say that and then I have to say Please keep this discussion in a pre-NEO context etc, etc. So, I'll go ahead and say that now, please keep this discussion to pre-NEO improvements. Although NEO is on it's way, please just submit features you have thought and dreamt about prior to NEO, and future releases. Anyways, I really think that the best minds in the cf community are hanging amidst us, so please share your thoughts and ideas, and maybe we can make CF an even easier, more robust, powerful product- Tyler Silcox email | [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF's Most Wanted ::
Yes, those of you in NEO land, please make sure that CFGRAPH is a stable, fully developed feature. - Matt Small -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 10:05 AM To: CF-Talk Subject: CF's Most Wanted :: (Features, that is...) With all this talk of learning other languages to flesh out your portfolio, and more importantly your knowledge, along with the looming release of NEO/CFMX, I've been trying to think of the features that I currently miss in my ColdFusion. And I thought what better way to get Macromedia's attention, then by creating a heated discussion among the leading, path-forging cf users, which obviously reside on this list (yes, I'm buttering you up.) It seams to me that we see some of the same issues puzzling new or begginer users over and over again, or some great features that are available though creative uses of custom tags are not readily available to those developers hosting on shared servers. And I feel that MM could easily add some nice new tags or attributes to current tags that solve most everyone's problems (and I know nothing is that easy, but it'd be nice.) I also know most of us have submitted feature requests on MM's site, but the community never really geats to chime in. So what I'd like to do is gather up a few of your ideas for improving ColdFusion just to let MM know what we're are thinking. I'm also very interested in what other developers are thinking, and I'm sure y'all are too. I know that timing probably isn't the best for their very, very busy brains over in MM land right now, but there really isn't anytime better than the present. Here's some of the basic probelms that I've come across and that I've seen pop up on this list over and over from the last couple of years: cfmail/cfpop: Needs more stability, more power, ability to read and write multi-part messages (at least), maybe kill the spool or move straight to the a Java spool (with NEO's Java backbone, there really is no excuse not to revamp this tag) cfimage (new tag): Abilty to resize images on the fly, store in cache, read dimensions, etc. (should be a cinch with Macromedia's expertise in graphic products [yea, right]) locking: Needs to protect the server. Period. cfgraph: Use flash to it's fullest. The current tag is a start, but still weak. Needs options galore. cfdirectory: Please just give us one more attribute (filesonly=True, or type=file) or update filter to accept type=file or type=dir. Those directory dots irk me 99% of the time I use the tag. c# support: I'm not even sure this is a possilbilty and it's probably a little early to call for it, but something to think about. And I know that a lot of these features are available as custom tags, etc, right now. But it's not always a feasible option for many developers who are on a monetary or time constraint, or are just hosting on a public server that doesn't allow custom tags. (Honestly, I'm not trying to put anyone out of business.) NOTE: I'm also aware that some some of these things may already be alleviated or improved upon in NEO. For all the Beta testers and PDA hounds out there, please do not jump in on this discussion and say That's already developed and then the subsequent You're not allowed to say that and then I have to say Please keep this discussion in a pre-NEO context etc, etc. So, I'll go ahead and say that now, please keep this discussion to pre-NEO improvements. Although NEO is on it's way, please just submit features you have thought and dreamt about prior to NEO, and future releases. Anyways, I really think that the best minds in the cf community are hanging amidst us, so please share your thoughts and ideas, and maybe we can make CF an even easier, more robust, powerful product- Tyler Silcox email | [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: BIG VULNERABILITY
Hi All, I found this on cfdjlist and found it very worth of posting here since this list is getting more traffic than cfdjlist these days. I've tried this test on several of our more well known CF sites and many of them failed. Thanks for the heads-up (again), but this was discussed here several times last week. Check the archives if you need more info. Thanks, Dave. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: BIG VULNERABILITY
See what happens when you have your head in code. Thanks for the reply :) -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 10:06 AM To: CF-Talk Subject: Re: BIG VULNERABILITY Hi All, I found this on cfdjlist and found it very worth of posting here since this list is getting more traffic than cfdjlist these days. I've tried this test on several of our more well known CF sites and many of them failed. Thanks for the heads-up (again), but this was discussed here several times last week. Check the archives if you need more info. Thanks, Dave. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: BIG VULNERABILITY
Hello Jason, Monday, April 22, 2002, 3:55:33 PM, you wrote: DJG Hi All, DJG I found this on cfdjlist and found it very worth of posting here since this DJG list DJG is getting more traffic than cfdjlist these days. I've tried this test on DJG several DJG of our more well known CF sites and many of them failed. DJG Good morning: DJG I wanted to pass this one along from the webappsec list. CF 4 and 4.5 also DJG appear to be vulnerable to this- the workaround is ok. I'm battening down DJG the hatches this morning. DJG Kudos to Peter Grundl for finding this and letting us know. DJG -Sean DJG - Original Message - DJG From: Peter Gründl [EMAIL PROTECTED] DJG To: bugtraq [EMAIL PROTECTED] DJG Sent: Thursday, April 18, 2002 8:01 AM DJG Subject: KPMG-2002013: Coldfusion Path Disclosure Title: Coldfusion Path Disclosure BUG-ID: 2002013 Released: 18th Apr 2002 Problem: Requests for certain DOS-devices are parsed by the isapi filter that handles .cfm and .dbm and result in error messages containing the physical path to the web root. Vulnerable: === - Coldfusion 5.0 on Windows 2000 w. IIS5 - Other versions were not tested. Details: Requests for non-existant .cfm and .dbm files return a coldfusion Object Not Found error message similar to this: Error Occurred While Processing Request Error Diagnostic Information An error has occurred. HTTP/1.0 404 Object Not Found Requesting a DOS-device, such as nul.dbm or nul.cfm returns: Error Occurred While Processing Request Error Diagnostic Information Cannot open CFML file The requested file C:\data\nul.dbm cannot be found. The specific sequence of files included or processed is: C:\data\nul.dbm Date/Time: 04/18/02 11:32:16 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0; T312461) Remote Address: xxx.xxx.xxx.xxx A similar result can be achieved with this request: /nul..dbm which returns: Error Occurred While Processing Request Error Diagnostic Information The template specification, 'C:\data\nul..dbm', is illegal. Template specifications cannot include '..' nor begin with a backslash ('\\'). Vendor URL: === You can visit the vendors webpage here: http://www.coldfusion.com Vendor response: The vendor was contacted on the 26th of November, 2001. The vendor suggested a workaround for the problem on the 8th of January, 2002. This advisory was delayed was due to a lapse of communication. Corrective action: == The vendor suggests turning on Check that file exists: Windows 2000: 1. Open the Management console 2. Click on Internet Information Services 3. Right-click on the website and select Properties 4. Select Home Directory 5. Click on Configuration 6. Select .cfm 7. Click on Edit 8. Make sure Check that file exists is checked 9. Do the same for .dbm Author: Peter Gründl ([EMAIL PROTECTED]) KPMG is not responsible for the misuse of the information we provide through our security advisories. These advisories are a service to the professional security community. In no event shall KPMG be lia- ble for any consequences whatsoever arising out of or in connection with the use or spread of this information. DJG !--- DJG Jason Dowdell DJG [EMAIL PROTECTED] DJG 321.799.6845 DJG IM AES - Web Developer DJG --- DJG __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF's Most Wanted ::
Yes, those of you in NEO land, please make sure that CFGRAPH is a stable, fully developed feature. Why not buy an add-on that is intended as a graphing product, rather than a bolt on?? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Oracle Gurus
I already have the create table and create sequence part complete I just actually need help with the insert part. I have never worked with a sequence. I have this much can anyone tell me if I am heading in the right direction and if so feel free to throw in any thing to help put me in the correct direction. CREATE SEQUENCE DeptCodeSeq INCREMENT BY 20 START WITH 1000 MAXVALUE 9080 NOCYCLE; CREATE TABLE Departments (DeptCode NUMBER(4), Name VARCHAR2(30), DeptSize NUMBER(5)); DECLARE V_DeptCode DeptCodeSeq.nextval%type; v_Name varchar2(30); v_DeptSize number(5); BEGIN END -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 21, 2002 6:59 PM To: CF-Talk Subject: Oracle Gurus I would be at anyone's mercy if they could do this for me. 1.Create a sequence DeptCodeSeq to generate dept codes in the range 1000, 1020, 1040, . .., 9080 Create table called Departments that has the following columns in it. DeptCode Name DeptSize NUMBER(4) VARCHAR2(30) NUMBER(5) Create a PL/SQL anonymous block called POPDEPTS.sql (Populate Department ) using FOR .. LOOP that uses the DeptCodeSeq to generate the department code and the name Where the name is constructed as DEPT-1020 DEPT-1040, and so on. That is the name of the department is the concatenation of DEPT- and the department code generated by the sequence. As each row is inserted print out the department t code and department name delimited by ';' on a separate line. ( use the DBMS_OUTPUT.PUT_LINE ). When testing your code you may need to constantly drop your sequence and create it until your PL/SQL block works correctly. DECLARE ... .. BEGIN Your code goes here ( you need FOR .. LOOP statement ) END; 2.Create a PL/SQL block to delete from Departments the departments that have their name ending in 40 and 80 digits. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: BIG VULNERABILITY
Last week? Is this next week already! ARGHHH! Thanks for the heads-up (again), but this was discussed here several times last week. Check the archives if you need more info. Thanks, Dave. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF's Most Wanted ::
Sorry, I meant CFGRID. - Matt Small -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 10:15 AM To: CF-Talk Subject: Re: CF's Most Wanted :: Yes, those of you in NEO land, please make sure that CFGRAPH is a stable, fully developed feature. Why not buy an add-on that is intended as a graphing product, rather than a bolt on?? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF's Most Wanted ::
Abilty to resize images on the fly, store in cache, read dimensions, etc. (should be a cinch with Macromedia's expertise in graphic products [yea, right]) There are plenty of CFX tags out there that do this. I'm not saying we shouldn't do it - just that solutions exist already. :) locking: Needs to protect the server. Period. Sure - the answer is to use locking - but I'm assuming your saying that we _shouldnt_ need locking for server stability. There will _always_ be a need for logical type locks. cfdirectory: Please just give us one more attribute (filesonly=True, or type=file) or update filter to accept type=file or type=dir. Those directory dots irk me 99% of the time I use the tag. Hey, just use startrow=3 when looping. ;) c# support: I'm not even sure this is a possilbilty and it's probably a little early to call for it, but something to think about. Um - you mean writing C#? Why? That's like asking for Perl support. Why not just use perl.exe? NOTE: I'm also aware that some some of these things may already be alleviated or improved upon in NEO. For all the Beta testers and PDA hounds out there, please do not jump in on this discussion and say That's already developed and then the subsequent You're not allowed to say that and then I have to say Please keep this discussion in a pre-NEO context etc, etc. So, I'll go ahead and say that now, please keep this discussion to pre-NEO improvements. Although NEO is on it's way, please just submit features you have thought and dreamt about prior to NEO, and future releases. Neo, what's Neo? :) === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Business Logic
I agree 100%. C++ and VB syntax covers most of what you have down there, and the fundamentals of those languages prepares for pretty much anything else you'll run across. A couple of extra concepts, like OO and SQL, and you're really cooking. --- Billy Cravens -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 20, 2002 2:40 PM To: CF-Talk Subject: RE: CF and Business Logic You would be surprised. I have found that once you understand C and C++ well, you can learn any language in a matter of weeks. My current list of languages I have proficiency with is as follows. C, C++, C#, J#, VB, VB.NET, VBA, ColdFusion, Java, JavaScript, Jscript, VBscript, ASP, ASP.NET, PHP, TCL, PERL, AWK, SH, BASH, HTML, XHTML, XML, XSL, PL/SQL, T-SQL More recently I have started playing with Python, Ruby, and Eiffel. And when I am looking to stretch my mind into AI territory, I play with Lisp, Scheme, and Prolog. -Matt -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 20, 2002 12:12 PM To: CF-Talk Subject: Re: CF and Business Logic H wonder if I could do that in my life time. What a resume it would be though. C C# C++ Javascript java php asp coldfusion perl delphi mfc vb assembly pascal html xml jsp actionscript Success is a journey, not a destination!! Doug Brown - Original Message - From: Matt Liotta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, April 20, 2002 8:41 AM Subject: RE: CF and Business Logic No, I was serious about trying to learn every language there is. Although, you could avoid the strictly academic languages if time is an issue. :) -Matt -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 20, 2002 4:50 AM To: CF-Talk Subject: RE: CF and Business Logic Do yourself a service and learn every language under the Sun ... Is this a subtle push in the direction of Java specifically? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: BIG VULNERABILITY
In my humble opinion it is better to repeat something like this at the risk of being repetitious than not to send it at all in case it looks like history. Thanks Jason. Mike Brunt, CTO Webapper http://www.webapper.com Tel: 562.243.6255 Instant Messaging AIM: MediaEmbee Webbaper, Downey CA Office Webapper - Making the NET Work -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 7:08 AM To: CF-Talk Subject: RE: BIG VULNERABILITY See what happens when you have your head in code. Thanks for the reply :) -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 10:06 AM To: CF-Talk Subject: Re: BIG VULNERABILITY Hi All, I found this on cfdjlist and found it very worth of posting here since this list is getting more traffic than cfdjlist these days. I've tried this test on several of our more well known CF sites and many of them failed. Thanks for the heads-up (again), but this was discussed here several times last week. Check the archives if you need more info. Thanks, Dave. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
viewing code in Netscape
Hi all, Sometimes when I am trying to view the source code of a page in Netscape, the view page source selection is greyed out. Any ideas on why or how to get around it? Thanks, Matt Small __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF's Most Wanted ::
I think would be great to start seeing some of the custom tags built in to new versions of CF. I have some sites that are hosted on servers I do not control so I can't use some cutome tags or it takes me day's to get support to install something I need now. Rick -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 9:18 AM To: CF-Talk Subject: RE: CF's Most Wanted :: Abilty to resize images on the fly, store in cache, read dimensions, etc. (should be a cinch with Macromedia's expertise in graphic products [yea, right]) There are plenty of CFX tags out there that do this. I'm not saying we shouldn't do it - just that solutions exist already. :) locking: Needs to protect the server. Period. Sure - the answer is to use locking - but I'm assuming your saying that we _shouldnt_ need locking for server stability. There will _always_ be a need for logical type locks. cfdirectory: Please just give us one more attribute (filesonly=True, or type=file) or update filter to accept type=file or type=dir. Those directory dots irk me 99% of the time I use the tag. Hey, just use startrow=3 when looping. ;) c# support: I'm not even sure this is a possilbilty and it's probably a little early to call for it, but something to think about. Um - you mean writing C#? Why? That's like asking for Perl support. Why not just use perl.exe? NOTE: I'm also aware that some some of these things may already be alleviated or improved upon in NEO. For all the Beta testers and PDA hounds out there, please do not jump in on this discussion and say That's already developed and then the subsequent You're not allowed to say that and then I have to say Please keep this discussion in a pre-NEO context etc, etc. So, I'll go ahead and say that now, please keep this discussion to pre-NEO improvements. Although NEO is on it's way, please just submit features you have thought and dreamt about prior to NEO, and future releases. Neo, what's Neo? :) === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Dynamic Pages and Search Engines
I've read through the archives and Ben Forta's article on friendly URL's and I don't think anything addresses this issue. I could be wrong though. I'm working on a new site that's essentially all database driven, a typical url is category.cfm?ID=4 . If I want the contents of this page to be indexed with the necessary database data how would I go about doing that? Ben's article and other posts mention replacing the '?' with a '/' but isn't that just going to get the information that is in the cfm file without the db data? My query needs the '4' to retrieve the relevant content, without that there is no content on the page worth searching. How does the spider know that there should be a '4' on the end of the query string? And that there should also be 15 other category identifiers that go with the category.cfm page? How do I get spiders to crawl these kinds of pages in their 'content filled' stages not just the static text. Thanks for any help, Daron J. Smith Web Developer PSEA [EMAIL PROTECTED] 717-255-7141 1-800-944-PSEA (7732) x 7141 Please note new email address (old one with 'mail' will soon expire) FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: viewing code in Netscape
Try killing your cache and / or temp files Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder Hi all, Sometimes when I am trying to view the source code of a page in Netscape, the view page source selection is greyed out. Any ideas on why or how to get around it? Thanks, Matt Small __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF's Most Wanted ::
Have you tried calling them via cfmodule rather than the traditional custom tag method? That will let you put them anywhere you wish and remove your reliance upon the hosting support folks. Ken -Original Message- From: Rick Eidson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 10:17 AM To: CF-Talk Subject: RE: CF's Most Wanted :: I think would be great to start seeing some of the custom tags built in to new versions of CF. I have some sites that are hosted on servers I do not control so I can't use some cutome tags or it takes me day's to get support to install something I need now. Rick __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: viewing code in Netscape
I'm not sure why it's doing that, but Control-U should show you the source. Cheers, Helen Simpson At 10:33 AM 4/22/02, you wrote: Hi all, Sometimes when I am trying to view the source code of a page in Netscape, the view page source selection is greyed out. Any ideas on why or how to get around it? Thanks, Matt Small __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: viewing code in Netscape
Thanks, but that did not solve the problem. I'm using Netscape 6.2. - Matt Small -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 10:38 AM To: CF-Talk Subject: Re: viewing code in Netscape Try killing your cache and / or temp files Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder Hi all, Sometimes when I am trying to view the source code of a page in Netscape, the view page source selection is greyed out. Any ideas on why or how to get around it? Thanks, Matt Small __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: viewing code in Netscape
I think this is an 'aol' enhancement to mozilla. I have noticed this as well on netscape 6.2. Especially not being able to view source on https files also not being to vs on certain js generated pages. After hearing that netscape is also used as spyware for aol, I switched to mozilla. I can't verify this atm, since I removed all traces of netscape. Now I use mozilla all the time. www.mozilla.org. It is a damn good alternative to ie. Alexander Sicular Chief Technology Architect Neurological Institute of New York Columbia University as867 [at] columbia {dot} edu |-Original Message- |From: Matthew R. Small [mailto:[EMAIL PROTECTED]] |Sent: Monday, April 22, 2002 10:34 AM |To: CF-Talk |Subject: viewing code in Netscape | | |Hi all, | Sometimes when I am trying to view the source code of a |page in Netscape, the view page source selection is greyed |out. Any ideas on why or how to get around it? | |Thanks, |Matt Small | | __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: viewing code in Netscape
Nope, doesn't work. Thanks. If you're using Netscape 6.2 or something close, see if it happens to you as well: The second page after http://showstopperonline.com/new_form/index.cfm Is the page that I am having problems with. The url for that page is: http://showstopperonline.com/new_form/reg_form_electronic2.cfm Question 2: I posted this last week but haven't solved it yet: Using Netscape 4.08, can somebody check out the second page (reg_form_electronic2.cfm) and tell me why if I can through the index.cfm page to arrive at the second page then the javascript does not work, but if I go through the first page, then it does? View trhe source of the second page, it's a weird Missing Post Operation error that is the source. I totally don't understand it at all. Thanks, - Matt Small -Original Message- From: Helen Simpson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 10:41 AM To: CF-Talk Subject: Re: viewing code in Netscape I'm not sure why it's doing that, but Control-U should show you the source. Cheers, Helen Simpson At 10:33 AM 4/22/02, you wrote: Hi all, Sometimes when I am trying to view the source code of a page in Netscape, the view page source selection is greyed out. Any ideas on why or how to get around it? Thanks, Matt Small __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: viewing code in Netscape
Can you explain that in further detail? I can view the source on the first of my pages but not the second. Also, this is not being accessed via https yet, it's still in dev. Thank you, Matt Small -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 10:47 AM To: CF-Talk Subject: RE: viewing code in Netscape I think this is an 'aol' enhancement to mozilla. I have noticed this as well on netscape 6.2. Especially not being able to view source on https files also not being to vs on certain js generated pages. After hearing that netscape is also used as spyware for aol, I switched to mozilla. I can't verify this atm, since I removed all traces of netscape. Now I use mozilla all the time. www.mozilla.org. It is a damn good alternative to ie. Alexander Sicular Chief Technology Architect Neurological Institute of New York Columbia University as867 [at] columbia {dot} edu |-Original Message- |From: Matthew R. Small [mailto:[EMAIL PROTECTED]] |Sent: Monday, April 22, 2002 10:34 AM |To: CF-Talk |Subject: viewing code in Netscape | | |Hi all, | Sometimes when I am trying to view the source code of a |page in Netscape, the view page source selection is greyed |out. Any ideas on why or how to get around it? | |Thanks, |Matt Small | | __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
At my new job
Well i'm now settled in at my new job :) WHOO HOO!! After my boss tried to have me arrested for HACKING his servers and all that was fun my old boss was a threatster :) OK OK now to the point i need to find a win32 textbased editor that does not have to load the whole damn file into memory first. I remember it being on here before so i'm curious. Any help would be appreciated! Bill Wheatley Senior Database Developer Ediets.com Macromedia Certified Coldfusion Developer 954.360.9022 X159 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF's Most Wanted ::
ummm...cfmodule ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Rick Eidson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 22, 2002 7:17 AM Subject: RE: CF's Most Wanted :: I think would be great to start seeing some of the custom tags built in to new versions of CF. I have some sites that are hosted on servers I do not control so I can't use some cutome tags or it takes me day's to get support to install something I need now. Rick -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 9:18 AM To: CF-Talk Subject: RE: CF's Most Wanted :: Abilty to resize images on the fly, store in cache, read dimensions, etc. (should be a cinch with Macromedia's expertise in graphic products [yea, right]) There are plenty of CFX tags out there that do this. I'm not saying we shouldn't do it - just that solutions exist already. :) locking: Needs to protect the server. Period. Sure - the answer is to use locking - but I'm assuming your saying that we _shouldnt_ need locking for server stability. There will _always_ be a need for logical type locks. cfdirectory: Please just give us one more attribute (filesonly=True, or type=file) or update filter to accept type=file or type=dir. Those directory dots irk me 99% of the time I use the tag. Hey, just use startrow=3 when looping. ;) c# support: I'm not even sure this is a possilbilty and it's probably a little early to call for it, but something to think about. Um - you mean writing C#? Why? That's like asking for Perl support. Why not just use perl.exe? NOTE: I'm also aware that some some of these things may already be alleviated or improved upon in NEO. For all the Beta testers and PDA hounds out there, please do not jump in on this discussion and say That's already developed and then the subsequent You're not allowed to say that and then I have to say Please keep this discussion in a pre-NEO context etc, etc. So, I'll go ahead and say that now, please keep this discussion to pre-NEO improvements. Although NEO is on it's way, please just submit features you have thought and dreamt about prior to NEO, and future releases. Neo, what's Neo? :) === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Access /SQL Server
Hi, We have recently migrated an access database to sql server 2000. The transfer has gone great and the site runs quicker in 98% of the site However there is one page (around 1500 lines of code) which carries out allot of calculations and references 2 tables with about 20 records in each of them. We have found that the page still runs quicker in an access database than a sql server db, we have also checked indexes and created stored procedure for a number of the queries. Can anyone tell me what we should check for as currently it is running about 3 times slower? TIA Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com ** If you are not the intended recipient, or person responsible for delivering it to the intended recipient, you are not authorized to and must not disclose, copy, distribute or retain this message or any part of it. The opinions / views / comments on this e-mail do not necessarily reflect any views or policies of biznet The recipient should check this email and any attachments for the presence of viruses. biznet accepts no liability for any damage caused by any virus transmitted by this email. biznet 2001. ** __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
JavaScript/CFinclude
I have one page that is a form that will be included in a java script popup. I was thinking about setting the page to a variable then outputting the page into the java script popup. Can anyone help me with this one? What I want to do: cfset content=cfinclude template=content.cfm Java Script Pop Up: script language=JavaScript window.onload=function(){ new popUp(155, 400, 696, 250, Div_ID1, cfoutput#content#/cfoutput, CC, FF, bold 10pt sans-serif, Add Users to cfoutput#appname.applname#/cfoutput, 66, white, #dd, gray, black, false, true, true, true, false); } /script __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access /SQL Server
Sounds like the majority processing on this page is CF. Check the debugging output and see how long the SQL queries take. If your SQL queries are taking a noticable abmount of time then I'd suggest ensuring that your indexes are correct and that your Transact SQL is effecient. Without seeing the code it's hard to suggest what it is. Is this page inserting/updating/or deleting data? if so your indexes will increase the time it takes to execute the SQL statement and hence the page as all of your indexes have to be rebuilt when an action other than a select is performed on the table. -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: 22 April 2002 16:08 To: CF-Talk Subject: Access /SQL Server Hi, We have recently migrated an access database to sql server 2000. The transfer has gone great and the site runs quicker in 98% of the site However there is one page (around 1500 lines of code) which carries out allot of calculations and references 2 tables with about 20 records in each of them. We have found that the page still runs quicker in an access database than a sql server db, we have also checked indexes and created stored procedure for a number of the queries. Can anyone tell me what we should check for as currently it is running about 3 times slower? TIA Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com ** If you are not the intended recipient, or person responsible for delivering it to the intended recipient, you are not authorized to and must not disclose, copy, distribute or retain this message or any part of it. The opinions / views / comments on this e-mail do not necessarily reflect any views or policies of biznet The recipient should check this email and any attachments for the presence of viruses. biznet accepts no liability for any damage caused by any virus transmitted by this email. biznet 2001. ** __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF's Most Wanted ::
Raymond There will _always_ be a need for logical type locks. why will there always be a need for using cflock with session variables. Should they manage muliple access automatically? And if there is a need for cflock, why doesn't client vars use them? Mark -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: 22 April 2002 15:18 To: CF-Talk Subject: RE: CF's Most Wanted :: Abilty to resize images on the fly, store in cache, read dimensions, etc. (should be a cinch with Macromedia's expertise in graphic products [yea, right]) There are plenty of CFX tags out there that do this. I'm not saying we shouldn't do it - just that solutions exist already. :) locking: Needs to protect the server. Period. Sure - the answer is to use locking - but I'm assuming your saying that we _shouldnt_ need locking for server stability. There will _always_ be a need for logical type locks. cfdirectory: Please just give us one more attribute (filesonly=True, or type=file) or update filter to accept type=file or type=dir. Those directory dots irk me 99% of the time I use the tag. Hey, just use startrow=3 when looping. ;) c# support: I'm not even sure this is a possilbilty and it's probably a little early to call for it, but something to think about. Um - you mean writing C#? Why? That's like asking for Perl support. Why not just use perl.exe? NOTE: I'm also aware that some some of these things may already be alleviated or improved upon in NEO. For all the Beta testers and PDA hounds out there, please do not jump in on this discussion and say That's already developed and then the subsequent You're not allowed to say that and then I have to say Please keep this discussion in a pre-NEO context etc, etc. So, I'll go ahead and say that now, please keep this discussion to pre-NEO improvements. Although NEO is on it's way, please just submit features you have thought and dreamt about prior to NEO, and future releases. Neo, what's Neo? :) === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF's Most Wanted ::
And if there is a need for cflock, why doesn't client vars use them? There aren't any concurrency issues for Client variables. They're not stored in memory. They're typically stored in a database or registry, which will provide its own concurrency controls, or in cookies, which have no concurrency issues. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: JavaScript/CFinclude
What I want to do: cfset content=cfinclude template=content.cfm Instead, try : cfsavecontent variable=content cfinclude template=content.cfm /cfsavecontent If you're not on CF5, look up CF_BodyContent from the fusebox.org website. Regards Stephen __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JavaScript/CFinclude
Why do you need to use cfinclude? Surely a cfset page =content.cfm will do? Is there any reason that you are using an include? Neil Clark Team Macromedia http://www.macromedia.com/go/team __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF's Most Wanted ::
Raymond There will _always_ be a need for logical type locks. why will there always be a need for using cflock with session variables. Should they manage muliple access automatically? I wasn't talking about always needing locks for session vars. I'm talking about issues like so: cfset session(or app or whatever)x = x + 1 In this case, you want to make sure only one thread is incrementing the value of X. Using a lock ensures this. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: At my new job
Not sure about the memory thing , but the editor I use in windows is hackman... http://www.technologismiki.com/hackman/. Gl, Alexander Sicular Chief Technology Architect Neurological Institute of New York Columbia University as867 [at] columbia {dot} edu |-Original Message- |From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] |Sent: Monday, April 22, 2002 11:00 AM |To: CF-Talk |Subject: At my new job | | |Well i'm now settled in at my new job :) WHOO HOO!! |After my boss tried to have me arrested for HACKING his |servers and all that was fun |my old boss was a threatster :) | | |OK OK now to the point |i need to find a win32 textbased editor that does not have to |load the whole damn file into memory first. I remember it |being on here before so i'm curious. | |Any help would be appreciated! | | | |Bill Wheatley |Senior Database Developer |Ediets.com |Macromedia Certified Coldfusion Developer |954.360.9022 X159 | | | __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: JavaScript/CFinclude
cfset content=cfinclude template=content.cfm I think you'd need to use CFFILE to read a file's contents into a variable. Otherwise, you can create a custom tag that uses ThisTag.GeneratedContent to write the markup between the opening and closing tag calls to a variable. Contact me off-list if you want a copy of my own tag for this. - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: viewing code in Netscape
This is probably the known issue of Mozilla, which Netscape 6 was based on. The bug was simple, and stupid. If you view source on a form action page, the browser would re-request the source. Yes, that's stupid - very stupid. It was only fixed in the very latest release of Mozilla, rc1. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 11:02 AM To: CF-Talk Subject: RE: viewing code in Netscape Nope, doesn't work. Thanks. If you're using Netscape 6.2 or something close, see if it happens to you as well: The second page after http://showstopperonline.com/new_form/index.cfm Is the page that I am having problems with. The url for that page is: http://showstopperonline.com/new_form/reg_form_electronic2.cfm Question 2: I posted this last week but haven't solved it yet: Using Netscape 4.08, can somebody check out the second page (reg_form_electronic2.cfm) and tell me why if I can through the index.cfm page to arrive at the second page then the javascript does not work, but if I go through the first page, then it does? View trhe source of the second page, it's a weird Missing Post Operation error that is the source. I totally don't understand it at all. Thanks, - Matt Small -Original Message- From: Helen Simpson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 10:41 AM To: CF-Talk Subject: Re: viewing code in Netscape I'm not sure why it's doing that, but Control-U should show you the source. Cheers, Helen Simpson At 10:33 AM 4/22/02, you wrote: Hi all, Sometimes when I am trying to view the source code of a page in Netscape, the view page source selection is greyed out. Any ideas on why or how to get around it? Thanks, Matt Small __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using cftransaction/cftransaction... Why?
-Original Message- From: James Sleeman [mailto:[EMAIL PROTECTED]] What it means to you as a developer is essentially that however many queries you do inside a CFSTRANSACTION/CFTRANSACTION block they will ALL be executed at the same time (well, they won't strictly, but it will look that way to you). Generally you use them to maintain database query integrit, think of this (most common) example... Is there much of a processing cost to this? If not why wouldn't I surround all my associated query blocks with the cftransaction tags. Thank you very much to all who responded and emailed, Charles Nahm __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access /SQL Server
Andy, It is only selecting data and it is running on the same server as the access versions? We would appreciate any advice. Jerry -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 22 April 2002 16:13 To: CF-Talk Subject: RE: Access /SQL Server Sounds like the majority processing on this page is CF. Check the debugging output and see how long the SQL queries take. If your SQL queries are taking a noticable abmount of time then I'd suggest ensuring that your indexes are correct and that your Transact SQL is effecient. Without seeing the code it's hard to suggest what it is. Is this page inserting/updating/or deleting data? if so your indexes will increase the time it takes to execute the SQL statement and hence the page as all of your indexes have to be rebuilt when an action other than a select is performed on the table. -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: 22 April 2002 16:08 To: CF-Talk Subject: Access /SQL Server Hi, We have recently migrated an access database to sql server 2000. The transfer has gone great and the site runs quicker in 98% of the site However there is one page (around 1500 lines of code) which carries out allot of calculations and references 2 tables with about 20 records in each of them. We have found that the page still runs quicker in an access database than a sql server db, we have also checked indexes and created stored procedure for a number of the queries. Can anyone tell me what we should check for as currently it is running about 3 times slower? TIA Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com ** If you are not the intended recipient, or person responsible for delivering it to the intended recipient, you are not authorized to and must not disclose, copy, distribute or retain this message or any part of it. The opinions / views / comments on this e-mail do not necessarily reflect any views or policies of biznet The recipient should check this email and any attachments for the presence of viruses. biznet accepts no liability for any damage caused by any virus transmitted by this email. biznet 2001. ** __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: viewing code in Netscape
I'm using Netscape 4.78 (I uninstalled 6.0 and haven't been back yet), and in this browser it's viewing the source just fine. I'm not very familiar with later versions so I can't be of much help, sorry. To the best of my knowledge, Netscape doesn't (or didn't until after 4.78) cache pages from a POST operation. To view the source you have to either hit Control-R to repost while you're looking at the source, or save the page and view in a text editor. It's a pain. Cheers, Helen Simpson At 11:01 AM 4/22/02, you wrote: Nope, doesn't work. Thanks. If you're using Netscape 6.2 or something close, see if it happens to you as well: The second page after http://showstopperonline.com/new_form/index.cfm Is the page that I am having problems with. The url for that page is: http://showstopperonline.com/new_form/reg_form_electronic2.cfm Question 2: I posted this last week but haven't solved it yet: Using Netscape 4.08, can somebody check out the second page (reg_form_electronic2.cfm) and tell me why if I can through the index.cfm page to arrive at the second page then the javascript does not work, but if I go through the first page, then it does? View trhe source of the second page, it's a weird Missing Post Operation error that is the source. I totally don't understand it at all. Thanks, - Matt Small -Original Message- From: Helen Simpson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 10:41 AM To: CF-Talk Subject: Re: viewing code in Netscape I'm not sure why it's doing that, but Control-U should show you the source. Cheers, Helen Simpson At 10:33 AM 4/22/02, you wrote: Hi all, Sometimes when I am trying to view the source code of a page in Netscape, the view page source selection is greyed out. Any ideas on why or how to get around it? Thanks, Matt Small __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access /SQL Server
Turn debugging on for your IP address and see how many milliseconds the page takes to execute, then see how many milliseconds the SQL statements take to execute, that way you can tell whether it is your SQL or your CF which is the major part of the overhead. If it is your SQL then ensure that your Transact SQL has no big overhead - e.g. If you are using cursors in your SQL code this will have a v.large overhead. If however you are using ANSI standard SQL (which it sounds like you are if you have mapped directly from Access to SQL with no changes/additions) then I'm stuck as to what to suggest. It may come down to the ODBC drivers you are using - i.e. the ODBC driver for access is better than the SQL one that you are using. Try swapping to OLEDB to see if this gives you any improvements although I'd be very surprised if it did -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: 22 April 2002 16:33 To: CF-Talk Subject: RE: Access /SQL Server Andy, It is only selecting data and it is running on the same server as the access versions? We would appreciate any advice. Jerry -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 22 April 2002 16:13 To: CF-Talk Subject: RE: Access /SQL Server Sounds like the majority processing on this page is CF. Check the debugging output and see how long the SQL queries take. If your SQL queries are taking a noticable abmount of time then I'd suggest ensuring that your indexes are correct and that your Transact SQL is effecient. Without seeing the code it's hard to suggest what it is. Is this page inserting/updating/or deleting data? if so your indexes will increase the time it takes to execute the SQL statement and hence the page as all of your indexes have to be rebuilt when an action other than a select is performed on the table. -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: 22 April 2002 16:08 To: CF-Talk Subject: Access /SQL Server Hi, We have recently migrated an access database to sql server 2000. The transfer has gone great and the site runs quicker in 98% of the site However there is one page (around 1500 lines of code) which carries out allot of calculations and references 2 tables with about 20 records in each of them. We have found that the page still runs quicker in an access database than a sql server db, we have also checked indexes and created stored procedure for a number of the queries. Can anyone tell me what we should check for as currently it is running about 3 times slower? TIA Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com ** If you are not the intended recipient, or person responsible for delivering it to the intended recipient, you are not authorized to and must not disclose, copy, distribute or retain this message or any part of it. The opinions / views / comments on this e-mail do not necessarily reflect any views or policies of biznet The recipient should check this email and any attachments for the presence of viruses. biznet accepts no liability for any damage caused by any virus transmitted by this email. biznet 2001. ** __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using cftransaction/cftransaction... Why?
Is there much of a processing cost to this? If not why wouldn't I surround all my associated query blocks with the cftransaction tags. Nothing is free, including CFTRANSACTION. When you designate a set of queries as a transaction, the database has to take special actions which typically limit what other transactions can do while your transaction is running. (Note that any single query is a transaction - it'll either succeed or fail in its entirety.) So, if you unnecessarily chain a bunch of queries together within a single transaction, that may cause a significant bottleneck. That being said, if you do have associated queries, and they do need to be treated as a single, atomic database operation, you'll need to group them together within a transaction. If possible, you might do this within a stored procedure, which will generally run faster. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: At my new job
What I use is textpad http://www.textpad.com Success is a journey, not a destination!! Doug Brown - Original Message - From: Bill Wheatley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 22, 2002 8:00 AM Subject: At my new job Well i'm now settled in at my new job :) WHOO HOO!! After my boss tried to have me arrested for HACKING his servers and all that was fun my old boss was a threatster :) OK OK now to the point i need to find a win32 textbased editor that does not have to load the whole damn file into memory first. I remember it being on here before so i'm curious. Any help would be appreciated! Bill Wheatley Senior Database Developer Ediets.com Macromedia Certified Coldfusion Developer 954.360.9022 X159 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dynamic Pages and Search Engines
Google indexs pages fine that have a ? in them. Not all search engines do, so a lot of us want to be covered by all bases cause you never know where you could get a big surge in traffic. So Ben and others, www.erikv.com have created tags you can place in your application.cfm that will parse everything after .cfm so you can have category.cfm?ID=4 be category.cfm/ID/4. The tag will parse everything back and make ID a url variable equal to 4 so that coldfusion knows it is there. The search engine is stupid though, it will only be able to index what is in front of it, so you would have to have some way to show all of your other artciles if you want those to be indexed also. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Smith, Daron [PA] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 10:36 AM To: CF-Talk Subject: Dynamic Pages and Search Engines I've read through the archives and Ben Forta's article on friendly URL's and I don't think anything addresses this issue. I could be wrong though. I'm working on a new site that's essentially all database driven, a typical url is category.cfm?ID=4 . If I want the contents of this page to be indexed with the necessary database data how would I go about doing that? Ben's article and other posts mention replacing the '?' with a '/' but isn't that just going to get the information that is in the cfm file without the db data? My query needs the '4' to retrieve the relevant content, without that there is no content on the page worth searching. How does the spider know that there should be a '4' on the end of the query string? And that there should also be 15 other category identifiers that go with the category.cfm page? How do I get spiders to crawl these kinds of pages in their 'content filled' stages not just the static text. Thanks for any help, Daron J. Smith Web Developer PSEA [EMAIL PROTECTED] 717-255-7141 1-800-944-PSEA (7732) x 7141 Please note new email address (old one with 'mail' will soon expire) FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Ben Forta's CFX_Spell tag -- demo?
Hey folks... We're considering the addition of Ben Forta's CFX_Spell tag to our site, and while I don't doubt the complete awesomeness of it, it would be really cool to take a look at it before we plunk down the $$$. (We are, after all, a nonprofit.) Anyone got a publicly accessible usage of it I could take a quick look at it? Thanks... -- jon - jon roig senior manager, online production epilepsy foundation site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: At my new job
I am a fan of Ultra Edit32 http://www.ultraedit.com/ It is a fantastic text editor with CF, HTML, JS etc... style sheets and most useful to me Column Editing. Take a peek. I love it. David DiPietro Systems Developer / Engineer OSU College of Medicine Public Health Voice (614) 292-5960 Fax (614) 292-0745 -Original Message- From: Bill Wheatley [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 11:00 AM To: CF-Talk Subject: At my new job Well i'm now settled in at my new job :) WHOO HOO!! After my boss tried to have me arrested for HACKING his servers and all that was fun my old boss was a threatster :) OK OK now to the point i need to find a win32 textbased editor that does not have to load the whole damn file into memory first. I remember it being on here before so i'm curious. Any help would be appreciated! Bill Wheatley Senior Database Developer Ediets.com Macromedia Certified Coldfusion Developer 954.360.9022 X159 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Ben Forta's CFX_Spell tag -- demo?
We're considering the addition of Ben Forta's CFX_Spell tag to our site, and while I don't doubt the complete awesomeness of it, it would be really cool to take a look at it before we plunk down the $$$. (We are, after all, a nonprofit.) Anyone got a publicly accessible usage of it I could take a quick look at it? Well, I'm not sure what you'd see, since it's server-side code. You can write whatever interface you like to use with it. We've used it before (not on any publicly available sites that I can recall though), and in general have been satisfied with it, except that it's not thread-safe, so you'll have to wrap it in CFLOCK. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Ben Forta's CFX_Spell tag -- demo?
I haven't heard of this CFX_Spell tag, what does it do? How is it completely awesome? Ryan -Original Message- From: jon [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 12:14 PM To: CF-Talk Subject: Ben Forta's CFX_Spell tag -- demo? Hey folks... We're considering the addition of Ben Forta's CFX_Spell tag to our site, and while I don't doubt the complete awesomeness of it, it would be really cool to take a look at it before we plunk down the $$$. (We are, after all, a nonprofit.) Anyone got a publicly accessible usage of it I could take a quick look at it? Thanks... -- jon - jon roig senior manager, online production epilepsy foundation site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Ben Forta's CFX_Spell tag -- demo?
Here's the link to get a demo version http://www.emteksys.com/products/cfx_spell/ -Original Message- From: jon [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 12:14 PM To: CF-Talk Subject: Ben Forta's CFX_Spell tag -- demo? Hey folks... We're considering the addition of Ben Forta's CFX_Spell tag to our site, and while I don't doubt the complete awesomeness of it, it would be really cool to take a look at it before we plunk down the $$$. (We are, after all, a nonprofit.) Anyone got a publicly accessible usage of it I could take a quick look at it? Thanks... -- jon - jon roig senior manager, online production epilepsy foundation site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF's Most Wanted ::
I think they were referring to CFX tags, not CFML Custom tags. Even if you use the cf_tagname syntax, you can put them in the current directory and CF will find them, thus removing any need for reliance on the host. At 10:39 AM 4/22/2002 -0400, you wrote: Have you tried calling them via cfmodule rather than the traditional custom tag method? That will let you put them anywhere you wish and remove your reliance upon the hosting support folks. Ken -Original Message- From: Rick Eidson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 10:17 AM To: CF-Talk Subject: RE: CF's Most Wanted :: I think would be great to start seeing some of the custom tags built in to new versions of CF. I have some sites that are hosted on servers I do not control so I can't use some cutome tags or it takes me day's to get support to install something I need now. Rick __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access /SQL Server
Memory issues? MS SQL 2000 will use a lot more memory. When working with small tables and datasets you may be staying within the bounds of physical memory on the machine and never notice a difference. If you force the system to use virtual memory, though, the slowdown could be the effects of swapping to disk. Jim - Original Message - From: Jerry Staple [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 22, 2002 9:33 AM Subject: RE: Access /SQL Server Andy, It is only selecting data and it is running on the same server as the access versions? We would appreciate any advice. Jerry -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 22 April 2002 16:13 To: CF-Talk Subject: RE: Access /SQL Server Sounds like the majority processing on this page is CF. Check the debugging output and see how long the SQL queries take. If your SQL queries are taking a noticable abmount of time then I'd suggest ensuring that your indexes are correct and that your Transact SQL is effecient. Without seeing the code it's hard to suggest what it is. Is this page inserting/updating/or deleting data? if so your indexes will increase the time it takes to execute the SQL statement and hence the page as all of your indexes have to be rebuilt when an action other than a select is performed on the table. -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: 22 April 2002 16:08 To: CF-Talk Subject: Access /SQL Server Hi, We have recently migrated an access database to sql server 2000. The transfer has gone great and the site runs quicker in 98% of the site However there is one page (around 1500 lines of code) which carries out allot of calculations and references 2 tables with about 20 records in each of them. We have found that the page still runs quicker in an access database than a sql server db, we have also checked indexes and created stored procedure for a number of the queries. Can anyone tell me what we should check for as currently it is running about 3 times slower? TIA Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access /SQL Server
Also, watch the locking. Make sure if there's select statements that you use the SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED to ensure a dirty read. You may be accidentally locking yourself out. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 9:44 AM To: CF-Talk Subject: Re: Access /SQL Server Memory issues? MS SQL 2000 will use a lot more memory. When working with small tables and datasets you may be staying within the bounds of physical memory on the machine and never notice a difference. If you force the system to use virtual memory, though, the slowdown could be the effects of swapping to disk. Jim - Original Message - From: Jerry Staple [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 22, 2002 9:33 AM Subject: RE: Access /SQL Server Andy, It is only selecting data and it is running on the same server as the access versions? We would appreciate any advice. Jerry -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 22 April 2002 16:13 To: CF-Talk Subject: RE: Access /SQL Server Sounds like the majority processing on this page is CF. Check the debugging output and see how long the SQL queries take. If your SQL queries are taking a noticable abmount of time then I'd suggest ensuring that your indexes are correct and that your Transact SQL is effecient. Without seeing the code it's hard to suggest what it is. Is this page inserting/updating/or deleting data? if so your indexes will increase the time it takes to execute the SQL statement and hence the page as all of your indexes have to be rebuilt when an action other than a select is performed on the table. -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: 22 April 2002 16:08 To: CF-Talk Subject: Access /SQL Server Hi, We have recently migrated an access database to sql server 2000. The transfer has gone great and the site runs quicker in 98% of the site However there is one page (around 1500 lines of code) which carries out allot of calculations and references 2 tables with about 20 records in each of them. We have found that the page still runs quicker in an access database than a sql server db, we have also checked indexes and created stored procedure for a number of the queries. Can anyone tell me what we should check for as currently it is running about 3 times slower? TIA Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Equivalent to cffile under ASP ?
Hi list, almost totally OT. I know. But is there an easy (and cheap) function/tag for MS-ASP (.asp) which covers the cffile-feature ? I have searched quite a while but couldn't find an appropriate one. Uwe __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Equivalent to cffile under ASP ?
Check out http://www.softartisans.com/ They have a few options there. -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 1:31 PM To: CF-Talk Subject: OT: Equivalent to cffile under ASP ? Hi list, almost totally OT. I know. But is there an easy (and cheap) function/tag for MS-ASP (.asp) which covers the cffile-feature ? I have searched quite a while but couldn't find an appropriate one. Uwe __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Update Query
Obviously a logic error but I cannot be sure. I am a proponent of KISS. On Mon, 22 Apr 2002, Janine Jakim wrote: I have a page that runs an update query. It seems that sometimes the grades update incorrectly or will overwrite the wrong information. This is the query I use- does anyone see anything wrong/could cause this? TIA CFPARAM NAME=SubjectMark DEFAULT= CFSET Courseset=CourseID CFSET Courseset=#Courseset#-1 CFTRANSACTION CFLOOP INDEX=X FROM=1 TO=#ListLen(SubjectMark)# CFQUERY NAME=EditMarks DATASOURCE=#Request.dsn# UPDATE T_StudentMarks SET SubjectMark='#ListGetAt(attributes.SubjectMark,X)#' WHERE StudentID='#StudentID#' and Quarter=#Quarter# And CourseID=#Evaluate(X + Courseset)# /CFQUERY /CFLOOP /CFTRANSACTION __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: At my new job
emacs or visual slickedit On Mon, 22 Apr 2002, Bill Wheatley wrote: Well i'm now settled in at my new job :) WHOO HOO!! After my boss tried to have me arrested for HACKING his servers and all that was fun my old boss was a threatster :) OK OK now to the point i need to find a win32 textbased editor that does not have to load the whole damn file into memory first. I remember it being on here before so i'm curious. Any help would be appreciated! Bill Wheatley Senior Database Developer Ediets.com Macromedia Certified Coldfusion Developer 954.360.9022 X159 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Equivalent to cffile under ASP ?
You can use the FileSystem object to do most of it (renaming, creating, etc) Uploading is a different beast. Here is a list of asp upload components: http://www.aspfaq.com/show.asp?id=2189 You might also want to check aspfaq.com for other filesystem faqs as well. Tim P. - Original Message - From: cf-talk [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 22, 2002 1:31 PM Subject: OT: Equivalent to cffile under ASP ? Hi list, almost totally OT. I know. But is there an easy (and cheap) function/tag for MS-ASP (.asp) which covers the cffile-feature ? I have searched quite a while but couldn't find an appropriate one. Uwe __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Ben Forta's CFX_Spell tag -- demo?
An alternative is spellchecker.net --- Billy Cravens -Original Message- From: jon [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 11:14 AM To: CF-Talk Subject: Ben Forta's CFX_Spell tag -- demo? Hey folks... We're considering the addition of Ben Forta's CFX_Spell tag to our site, and while I don't doubt the complete awesomeness of it, it would be really cool to take a look at it before we plunk down the $$$. (We are, after all, a nonprofit.) Anyone got a publicly accessible usage of it I could take a quick look at it? Thanks... -- jon - jon roig senior manager, online production epilepsy foundation site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Is there a list for MCSE's?
Does anyone know of a list for MCSE's not a bulletin board. Thanks L Marcus Email: [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Ben Forta's CFX_Spell tag -- demo?
Yeah... they're charging now, though. They actually would've been our first choice, but I don't really want to have to monitor user sessions and whatnot. 'Sides, our forums could probably burn through 10,000 user sessions in 2 months... we'd rather have something in house. As it turns out, forta's tag comes with some working examples, so crisis averted. Call off the dogs. .. looks pretty cool, too. -- jon - jon roig senior manager, online production epilepsy foundation site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 1:35 PM To: CF-Talk Subject: RE: Ben Forta's CFX_Spell tag -- demo? An alternative is spellchecker.net --- Billy Cravens -Original Message- From: jon [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 11:14 AM To: CF-Talk Subject: Ben Forta's CFX_Spell tag -- demo? Hey folks... We're considering the addition of Ben Forta's CFX_Spell tag to our site, and while I don't doubt the complete awesomeness of it, it would be really cool to take a look at it before we plunk down the $$$. (We are, after all, a nonprofit.) Anyone got a publicly accessible usage of it I could take a quick look at it? Thanks... -- jon - jon roig senior manager, online production epilepsy foundation site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: filename in code documentation - WHY?!
Gyrus asked: Every instance of code documentation [..] I've seen has 'filename' included. Any reason? Surely it's spurious [..] Is it? I put the filename and virtual path of the file at the top of every CFM file I write (or edit). [Ex: /Admin/People.cfm] Why? Because my job is mainly writing intranets, extranets, and web site for clients. The vast majority of the code is pretty much the same old thing: add/edit/delete information from tables, or get info out of tables to display. With a good common methodology and structure, any one of my coworkers can open a file and quickly find the portion that they are looking for. It's all too easy to write CF spaghetti code that is nigh impossible to understand. A common structure is the only thing that saves you from insanity. The down side to this is that many of the files look the same at first glance. That is, they all have pretty much the same structure: local variables being initialized at the top, logic to check those variables after that, logic to act on those variables after that, and finally a big switch statement at the end to display the appropriate content. If you even have a common variable naming convention (good for you!) then that's another bit of abstraction that makes one page even more indistinguishable from the next. This is made even trickier by picky clients. Client A wants Column B from Table C included in their results, but Client D wants Column E from Table F. This changes query and display logic, and even occasionally business logic. But, the code is still just similar enough such that only a few lines will be different here or there. If I'm working on several of these files at the same time, Ctrl-Tab-ing back and forth between then, opening and closing other files, and I don't have a filename at the top ... well, it gets very easy to forget which is which. Especially after The Boss comes in and distracts me for 5 minutes with his idea of what the Next Big Thing is. It's easy enough to Ctrl-Home to the top of the document to make sure that I come back to the same document I think I've come back to. So that's why I put the filename (and path) at the top of every document. -R P.S. - A non-programming coworker brought up an excellent point about CF Studio the other day: Wouldn't it be nice if each file had an associated context for the file/directory tree? That is, when you switched between open files the file and directory browsers would atomagically switch back to the last place they had been *for that file*. It's so simple it's positively brilliant, and yet I've never heard another programmer say it. From the mouths of babes ... --R __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RE: filename in code documentation - WHY?!
I've been wanting this since day one. P.S. - A non-programming coworker brought up an excellent point about CF Studio the other day: Wouldn't it be nice if each file had an associatedcontext for the file/directory tree? That is, when you switched between open files the file and directory browsers would atomagically switch back to the last place they had been *for that file*. It's so simple it's positively brilliant, and yet I've never heard another programmer say it. From the mouths of babes ... --R __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RegEx for alpha num
I'm very new to regular expressions. I see there is a posix class [:alnum:], but I don't begin to understand how to use it. I have a need to implement it though in server side password validation. I know my syntax isn't right, but I'm not sure how to format it. Below is an example of what I need. Can anyone offer advice? cfif REFind([:alnum:],#Form.Password# Insert the password into the database cfelse Send the user back to the form with an error message /cfif TIA! ~Val __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RegEx for alpha num
Im still kinda new to RegEx... but I think this will work. cfset MyValue = ReFind([^A-Za-z0-9], Form.Password) cfif MyValue GT 0 send error cfelse go /cfif Basically the [^A-Za-z0-9] is saying everything except A-Za-z0-9 so it will find all your non alphanum chars and will return the location of the first one it finds. I think you could do it with posix too. HTH Sean -Original Message- From: Valerie L. Criswell [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 2:00 PM To: CF-Talk Subject: RegEx for alpha num I'm very new to regular expressions. I see there is a posix class [:alnum:], but I don't begin to understand how to use it. I have a need to implement it though in server side password validation. I know my syntax isn't right, but I'm not sure how to format it. Below is an example of what I need. Can anyone offer advice? cfif REFind([:alnum:],#Form.Password# Insert the password into the database cfelse Send the user back to the form with an error message /cfif TIA! ~Val __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RegEx for alpha num
At a very simple level, the POSIX class [:digit:] can be used wherever you would type a single character or group of characters. What I mean by this: REFind(a,Form.Password) the class can fit where a character would go. REFind([:class:],Form.Password) It MEANS something different than that character, but it FITS in the same place. What it sounds like you want is to find out if all the characters in your password are [:alnum:], yes? OR, stated another way, you want to find out if any characters in password are NOT [:alnum:]? As Sean suggested, you do this by looking for anything NOT in the class. cfif REFind([^[:alnum:]],Form.Password) fail cfelse go on /cfif HTH at all, Jerry Johnson [EMAIL PROTECTED] 04/22/02 02:00PM I'm very new to regular expressions. I see there is a posix class [:alnum:], but I don't begin to understand how to use it. I have a need to implement it though in server side password validation. I know my syntax isn't right, but I'm not sure how to format it. Below is an example of what I need. Can anyone offer advice? cfif REFind([:alnum:],#Form.Password# Insert the password into the database cfelse Send the user back to the form with an error message /cfif TIA! ~Val __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
DSNless connections
What are the advantages/disadvantages to using DSNless connections? T __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RegEx for alpha num
Very cool. I'm going to try it! Thanks so much. The funny thing is that as good as some documentation is, for me... a few real-world examples go a long way. Too many docs try to focus on the mumbo jumbo rules (which are good for reference, but don't get you anywhere fast). I'm sure once I use a few of these things, I'll get the hang of it. So, thanks again, Sean and Jerry. ~Val - Original Message - From: Jerry Johnson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 22, 2002 2:23 PM Subject: Re: RegEx for alpha num At a very simple level, the POSIX class [:digit:] can be used wherever you would type a single character or group of characters. What I mean by this: REFind(a,Form.Password) the class can fit where a character would go. REFind([:class:],Form.Password) It MEANS something different than that character, but it FITS in the same place. What it sounds like you want is to find out if all the characters in your password are [:alnum:], yes? OR, stated another way, you want to find out if any characters in password are NOT [:alnum:]? As Sean suggested, you do this by looking for anything NOT in the class. cfif REFind([^[:alnum:]],Form.Password) fail cfelse go on /cfif HTH at all, Jerry Johnson [EMAIL PROTECTED] 04/22/02 02:00PM I'm very new to regular expressions. I see there is a posix class [:alnum:], but I don't begin to understand how to use it. I have a need to implement it though in server side password validation. I know my syntax isn't right, but I'm not sure how to format it. Below is an example of what I need. Can anyone offer advice? cfif REFind([:alnum:],#Form.Password# Insert the password into the database cfelse Send the user back to the form with an error message /cfif TIA! ~Val __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JavaScript/CFinclude
I am assuming this is just a standard pop up window, and not some modal thing... Perhaps you want to consider doing this in straight javascript? window.open ('newwin', 'content.cfm', [attributes]); Or, if you are feeling really cool, try writing the new window without loading the one off the server: !--- I know this code is a little off, but with some tweeking it would work.) //--- var content = ''; content = 'htmlheadtitlesometitle/title/headbody'; content = content + '#the content for the new page#'; content = content + '/body/html'; window.open('newwin','blank.htm',''); window.document.write(content); M -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 11:14 AM To: CF-Talk Subject: JavaScript/CFinclude I have one page that is a form that will be included in a java script popup. I was thinking about setting the page to a variable then outputting the page into the java script popup. Can anyone help me with this one? What I want to do: cfset content=cfinclude template=content.cfm Java Script Pop Up: script language=JavaScript window.onload=function(){ new popUp(155, 400, 696, 250, Div_ID1, cfoutput#content#/cfoutput, CC, FF, bold 10pt sans-serif, Add Users to cfoutput#appname.applname#/cfoutput, 66, white, #dd, gray, black, false, true, true, true, false); } /script __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RegEx for alpha num
It sounds like you want to make sure the password only consists of letters and numbers. I think the following would be what you're looking for: REFind(^[[:alnum:]]+$, #Form.Password#) ^ matches the beginning of the string $ matches the end of the string + translates to 1 or more The ^ and $ anchors are needed, since otherwise the regex will match if the password string _contains_ an alphanumeric string, as in *-bob##. You could also use a regex like: ^[[:alnum:]]{5,15}$ to make sure the password is betwee 5 and 15 characters in length. Jim - Original Message - From: Valerie L. Criswell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 22, 2002 12:00 PM Subject: RegEx for alpha num I'm very new to regular expressions. I see there is a posix class [:alnum:], but I don't begin to understand how to use it. I have a need to implement it though in server side password validation. I know my syntax isn't right, but I'm not sure how to format it. Below is an example of what I need. Can anyone offer advice? cfif REFind([:alnum:],#Form.Password# Insert the password into the database cfelse Send the user back to the form with an error message /cfif TIA! ~Val __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RegEx for alpha num
... a few real-world examples go a long way. Here is my all time favourite RE. It has a little of everything: A special thanks to Erik Voldengen for this email validation RE. It handles multiple top levels, checks for valid root domains, disallows double @@ and will ensure that the email address contains just alphanumeric characters. Very nice piece of work! cfset email_address=[EMAIL PROTECTED] cfif REFindNocase(^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*\.(([a-z ]{2,3})|(aero|coop|info|museum|name))$,email_address) .good.. cfelse .bad.. /cfif __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Application Log Warnging using CFX Excel
We've successfully used the CFX_Excel tag for a couple of years now. We've just upgraded our server, and we've now got a problem with the usage of the tag. Here's the setup: Windows 2000 Server CF 5.0 Office 2000 (complete install) When the CFX_Excel tag is invoked, the following warnings are generated in the server's Applicaiton Log: Warning #1 Detection of product '{00010409-781-11D2-B60F-006097C998E7}' feature 'ExcelUserData', component '{8AD02C96-C8B7-11D1-9C67-F81F1B38}' failed Warning #2 Detection of product '{00010409-78E1-1102-B60F-006097C998E7}', feature 'OfficeUserData', component '{C9AF9050-C8BE-11D1-9C67-F81F1B38}' failed. We've tried everything (with Office and the CFX tag) from re-install, to uninstall and re-install to having the Office disk in when the tag is invoked. Nothing helps and this error fills the Application log about every day (because the application is heavily used). Can anyone help or shed any light on the problem? Thanks, Dave __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RegEx for alpha num
*choke* hehe... I'm sure it's a thing of beauty to those who are enlightened. Thx, ~Val - Original Message - From: Joseph Thompson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 22, 2002 2:37 PM Subject: Re: RegEx for alpha num ... a few real-world examples go a long way. Here is my all time favourite RE. It has a little of everything: A special thanks to Erik Voldengen for this email validation RE. It handles multiple top levels, checks for valid root domains, disallows double @@ and will ensure that the email address contains just alphanumeric characters. Very nice piece of work! cfset email_address=[EMAIL PROTECTED] cfif REFindNocase(^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*\.(([a-z ]{2,3})|(aero|coop|info|museum|name))$,email_address) .good.. cfelse .bad.. /cfif __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
where can we make announcements?
want to know where we can make announcements about CF projects (ie. tags, useful tools) we are developing? is it appropriate to announce them here? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Using cftransaction/cftransaction... Why?
Dave Watts wrote: Nothing is free, including CFTRANSACTION. When you designate a set of queries as a transaction, the database has to take special actions which typically limit what other transactions can do while your transaction is running. (Note that any single query is a transaction - it'll either succeed or fail in its entirety.) So, if you unnecessarily chain a bunch of queries together within a single transaction, that may cause a significant bottleneck. Unless your database uses MVCC. When using MVCC the concept of a transaction is slightly different, it is not just to group queries, it is also to timestamp them and (in)validate the tuples that are affected by them. Everything is in a transaction, it simply is not possible to have a query that is not in a transaction. Jochem __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: SQL select question
I know that my problem lies in a one to many relationship, but I cannot seem to figure this out without jerry rigging the query. I want customers to be able to do a search by artist, album, music type and song title. Each album has several songTitles and therefore my problem arises. I am using the same query for all the search options using an IF statement to determine the search paramaters. Whenever someone searches for music by (music type) it pulls multiple of the same album due to the join of the titles table. Table layouts [artists] ID (PK) artist_name [albums] ID (PK) artist_id (FK_artists) album_name [titles] ID (PK) artist_id (FK_artists) album_id (FK_albums) songTitle Here is the query currently. I know I should be able to mold it into just one query, and this is just how I have rigged it to work. This irritates me though and would like to see if it can be fixed. cfif isDefined(searchOptions) !--- If the search value is anything other than by songTitle, use this query without the title table join//--- cfif (searchOptions EQ 1) OR (searchOptions EQ 2) OR (searchOptions EQ 3) CFQUERY DATASOURCE=cmg NAME=get_products_search SELECT distinct(artists.id) AS artist_id, artists.artistfirstName, artists.artistLastName, artists.groupName, artists.musicType_ID, albums.id AS album_id, albums.album_name, albums.releaseDate, albums.smImage, albums.lgImage, products.id AS products_id, products.sku, products.salePrice, musicTypes.musicType FROMartists INNER JOIN albums ONartists.ID = albums.artist_id INNER JOIN products ONalbums.id = products.album_id INNER JOIN musicTypes ONartists.musicType_ID = musicTypes.ID WHERE right(products.sku,2) = 'CD' AND CFIF searchOptions EQ 1 (artistFirstName = '#searchString#') OR (artistLastName = '#searchString#') OR (artistFirstName + ' ' + artistLastName = '#searchString#') OR (groupName = '#searchString#') CFELSEIF searchOptions EQ 2 musicTypes.musicType = '#type#' CFELSEIF searchOptions EQ 3 album_name = '#searchString#' /CFIF /CFQUERY cfelse !---If the searchoption is by songTitle insert the join into the query for the titles table//--- CFQUERY DATASOURCE=cmg NAME=get_products_search SELECT distinct(artists.id) AS artist_id, artists.artistfirstName, artists.artistLastName, artists.groupName, artists.musicType_ID, albums.id AS album_id, albums.album_name, albums.releaseDate, albums.smImage, albums.lgImage, products.id AS products_id, products.sku, products.salePrice, musicTypes.musicType, titles.songTitle FROM artists INNER JOIN albums ON artists.ID = albums.artist_id INNER JOIN products ON albums.id = products.album_id INNER JOIN musicTypes ON artists.musicType_ID = musicTypes.ID INNER JOIN titles ONartists.id = titles.artist_id ANDalbums.id = titles.album_id WHERE right(products.sku,2) = 'CD' ANDsongTitle = '#searchString#' /CFQUERY /cfif /cfif Success is a journey, not a destination!! Doug Brown __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DSNless connections
Here's just one advantage... I'd like to hear more too.. If you don't have the access to create or edit DSNs, then a DSNless connections are very useful. -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 2:23 PM To: CF-Talk Subject: DSNless connections What are the advantages/disadvantages to using DSNless connections? T __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
querying funky text files
I've done it again. I've underbid on a project that's tured out to be a monster. I have to query a text file that has fixed-width columns. Anyone pulled this off before? Help. singed Brain Fried Nick __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Converting from TIFF to Searchable PDF on the fly
Does anyone know of a CFX tag, COM object, or other component that will be able to convert TIFF images to searchable PDF documents on the fly? I think it goes without saying, but I would like to accomplish this task using ColdFusion. The TIFF files will reside locally on the server and I would like to use a nightly scheduled batch process to convert all documents to searchable PDF files. I have downloaded and installed an ActiveX component called ScanButton that claims to do what I need, but I am receiving an error message when attempting to run it. Also, I am aware of several other options, such as Adobe Capture 3.0, so I am really looking for anyone with experience or direction a component and some CF code samples. That is ending up as the hardest item in this search. Thank You. Alex Santantonio __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL select question
It sounds like your problem is not in the query, but in the output of the query. Of course you will pull multiple entries with the same album, that is to be expected. Try outputting like this: cfoutput query=music group=musicType #musicType#br cfoutput group=albumTitle -- #albumTitle#br cfoutput #songTitle#br /cfoutput /cfoutput /cfoutput but in order for this to work you MUST AT LEAST order by musicType and albumTitle: ORDER BY musicType, albumTitle [add more here if you want] +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 12:20 PM To: CF-Talk Subject: OT: SQL select question I know that my problem lies in a one to many relationship, but I cannot seem to figure this out without jerry rigging the query. I want customers to be able to do a search by artist, album, music type and song title. Each album has several songTitles and therefore my problem arises. I am using the same query for all the search options using an IF statement to determine the search paramaters. Whenever someone searches for music by (music type) it pulls multiple of the same album due to the join of the titles table. Table layouts [artists] ID (PK) artist_name [albums] ID (PK) artist_id (FK_artists) album_name [titles] ID (PK) artist_id (FK_artists) album_id (FK_albums) songTitle Here is the query currently. I know I should be able to mold it into just one query, and this is just how I have rigged it to work. This irritates me though and would like to see if it can be fixed. cfif isDefined(searchOptions) !--- If the search value is anything other than by songTitle, use this query without the title table join//--- cfif (searchOptions EQ 1) OR (searchOptions EQ 2) OR (searchOptions EQ 3) CFQUERY DATASOURCE=cmg NAME=get_products_search SELECT distinct(artists.id) AS artist_id, artists.artistfirstName, artists.artistLastName, artists.groupName, artists.musicType_ID, albums.id AS album_id, albums.album_name, albums.releaseDate, albums.smImage, albums.lgImage, products.id AS products_id, products.sku, products.salePrice, musicTypes.musicType FROMartists INNER JOIN albums ONartists.ID = albums.artist_id INNER JOIN products ONalbums.id = products.album_id INNER JOIN musicTypes ONartists.musicType_ID = musicTypes.ID WHERE right(products.sku,2) = 'CD' AND CFIF searchOptions EQ 1 (artistFirstName = '#searchString#') OR (artistLastName = '#searchString#') OR (artistFirstName + ' ' + artistLastName = '#searchString#') OR (groupName = '#searchString#') CFELSEIF searchOptions EQ 2 musicTypes.musicType = '#type#' CFELSEIF searchOptions EQ 3 album_name = '#searchString#' /CFIF /CFQUERY cfelse !---If the searchoption is by songTitle insert the join into the query for the titles table//--- CFQUERY DATASOURCE=cmg NAME=get_products_search SELECT distinct(artists.id) AS artist_id, artists.artistfirstName, artists.artistLastName, artists.groupName, artists.musicType_ID, albums.id AS album_id, albums.album_name, albums.releaseDate, albums.smImage, albums.lgImage, products.id AS products_id, products.sku, products.salePrice, musicTypes.musicType, titles.songTitle FROM artists INNER JOIN albums ON artists.ID = albums.artist_id INNER JOIN products ON albums.id = products.album_id INNER JOIN musicTypes ON artists.musicType_ID = musicTypes.ID INNER JOIN titles ONartists.id = titles.artist_id ANDalbums.id = titles.album_id WHERE right(products.sku,2) = 'CD' ANDsongTitle = '#searchString#' /CFQUERY /cfif /cfif Success is a journey, not a destination!! Doug Brown __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
connection error
I have establised a connection with my SQL database throught CF Administrator and have verified it's connection. However, when I go to my main .cfm page, I get an error that it cannot find my base table. How can that be? I can see my database and see that it's connected and see all the tables in it when I open it in SQL? Anyone know what's going on? This is the exact message. Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Events'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (5:1) to (5:48). Date/Time: 04/22/02 15:50:15 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) Remote Address: 127.0.0.1 Here's my query to access the database: cfquery name=selectevent datasource=Events SELECT * FROM Events WHERE ID = ID /cfquery __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DSNless connections
you don't have to pay $$$ for the hosting company to setup a DSN for you. ;) Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:29 PM To: CF-Talk Subject: RE: DSNless connections Here's just one advantage... I'd like to hear more too.. If you don't have the access to create or edit DSNs, then a DSNless connections are very useful. -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 2:23 PM To: CF-Talk Subject: DSNless connections What are the advantages/disadvantages to using DSNless connections? T __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: querying funky text files
Fixed width makes it easy to convert, but if you are just querying you shouldn't have to convert anything. Just use Find() or something similar... Refind() is capable of returning multiple results if you need that instead... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 12:55 PM To: CF-Talk Subject: querying funky text files I've done it again. I've underbid on a project that's tured out to be a monster. I have to query a text file that has fixed-width columns. Anyone pulled this off before? Help. singed Brain Fried Nick __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Converting from TIFF to Searchable PDF on the fly
http://www.logipole.com/indexe.html Command line use CFEXECUTE. Rick -Original Message- From: Alex Santantonio [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:05 PM To: CF-Talk Subject: Converting from TIFF to Searchable PDF on the fly Does anyone know of a CFX tag, COM object, or other component that will be able to convert TIFF images to searchable PDF documents on the fly? I think it goes without saying, but I would like to accomplish this task using ColdFusion. The TIFF files will reside locally on the server and I would like to use a nightly scheduled batch process to convert all documents to searchable PDF files. I have downloaded and installed an ActiveX component called ScanButton that claims to do what I need, but I am receiving an error message when attempting to run it. Also, I am aware of several other options, such as Adobe Capture 3.0, so I am really looking for anyone with experience or direction a component and some CF code samples. That is ending up as the hardest item in this search. Thank You. Alex Santantonio __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: connection error
Database owner? dbo.tablename and username.tablename are two different tables. Rick -Original Message- From: Judy [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:02 PM To: CF-Talk Subject: connection error I have establised a connection with my SQL database throught CF Administrator and have verified it's connection. However, when I go to my main .cfm page, I get an error that it cannot find my base table. How can that be? I can see my database and see that it's connected and see all the tables in it when I open it in SQL? Anyone know what's going on? This is the exact message. Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Events'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (5:1) to (5:48). Date/Time: 04/22/02 15:50:15 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) Remote Address: 127.0.0.1 Here's my query to access the database: cfquery name=selectevent datasource=Events SELECT * FROM Events WHERE ID = ID /cfquery __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: connection error
specify a uname and pword in the CFQUERY... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Rick Eidson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 12:58 PM To: CF-Talk Subject: RE: connection error Database owner? dbo.tablename and username.tablename are two different tables. Rick -Original Message- From: Judy [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:02 PM To: CF-Talk Subject: connection error I have establised a connection with my SQL database throught CF Administrator and have verified it's connection. However, when I go to my main .cfm page, I get an error that it cannot find my base table. How can that be? I can see my database and see that it's connected and see all the tables in it when I open it in SQL? Anyone know what's going on? This is the exact message. Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Events'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (5:1) to (5:48). Date/Time: 04/22/02 15:50:15 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) Remote Address: 127.0.0.1 Here's my query to access the database: cfquery name=selectevent datasource=Events SELECT * FROM Events WHERE ID = ID /cfquery __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: querying funky text files
That ones easy you need to just use the mid function, start with the first number in the column definition, and then go to the end of the column. CFSCRIPT thisVar = mid(listGetAt(yourFileVariable, i, chr(13)), 1, 9); /CFSCRIPT This will return the variable in column one of row one. If you need to loop through to get all the rows treat it like a list with chr(13) as the delimiter. You should also be able to do something similar to return an actual query set using the query functions. I am not sure but you may also be able to set it up as a datasource. I have heard of it working for comma and tab delimited files, just not fixed width. Let me know if it works please, I would like to try it some time. Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:55 PM To: CF-Talk Subject: querying funky text files I've done it again. I've underbid on a project that's tured out to be a monster. I have to query a text file that has fixed-width columns. Anyone pulled this off before? Help. singed Brain Fried Nick __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF's Most Wanted ::
I'd like to see custom tags able to tell CF to process the code inside. Some tags do, like cfoutput and cfquery, while some don't like cfloop. I'd like to be able to do this too with my custom tags without having to plonk ugly cfoutput tags inside each invocation. - Original Message - From: Tyler Silcox [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 2:05 AM Subject: CF's Most Wanted :: (Features, that is...) With all this talk of learning other languages to flesh out your portfolio, and more importantly your knowledge, along with the looming release of NEO/CFMX, I've been trying to think of the features that I currently miss in my ColdFusion. And I thought what better way to get Macromedia's attention, then by creating a heated discussion among the leading, path-forging cf users, which obviously reside on this list (yes, I'm buttering you up.) It seams to me that we see some of the same issues puzzling new or begginer users over and over again, or some great features that are available though creative uses of custom tags are not readily available to those developers hosting on shared servers. And I feel that MM could easily add some nice new tags or attributes to current tags that solve most everyone's problems (and I know nothing is that easy, but it'd be nice.) I also know most of us have submitted feature requests on MM's site, but the community never really geats to chime in. So what I'd like to do is gather up a few of your ideas for improving ColdFusion just to let MM know what we're are thinking. I'm also very interested in what other developers are thinking, and I'm sure y'all are too. I know that timing probably isn't the best for their very, very busy brains over in MM land right now, but there really isn't anytime better than the present. Here's some of the basic probelms that I've come across and that I've seen pop up on this list over and over from the last couple of years: cfmail/cfpop: Needs more stability, more power, ability to read and write multi-part messages (at least), maybe kill the spool or move straight to the a Java spool (with NEO's Java backbone, there really is no excuse not to revamp this tag) cfimage (new tag): Abilty to resize images on the fly, store in cache, read dimensions, etc. (should be a cinch with Macromedia's expertise in graphic products [yea, right]) locking: Needs to protect the server. Period. cfgraph: Use flash to it's fullest. The current tag is a start, but still weak. Needs options galore. cfdirectory: Please just give us one more attribute (filesonly=True, or type=file) or update filter to accept type=file or type=dir. Those directory dots irk me 99% of the time I use the tag. c# support: I'm not even sure this is a possilbilty and it's probably a little early to call for it, but something to think about. And I know that a lot of these features are available as custom tags, etc, right now. But it's not always a feasible option for many developers who are on a monetary or time constraint, or are just hosting on a public server that doesn't allow custom tags. (Honestly, I'm not trying to put anyone out of business.) NOTE: I'm also aware that some some of these things may already be alleviated or improved upon in NEO. For all the Beta testers and PDA hounds out there, please do not jump in on this discussion and say That's already developed and then the subsequent You're not allowed to say that and then I have to say Please keep this discussion in a pre-NEO context etc, etc. So, I'll go ahead and say that now, please keep this discussion to pre-NEO improvements. Although NEO is on it's way, please just submit features you have thought and dreamt about prior to NEO, and future releases. Anyways, I really think that the best minds in the cf community are hanging amidst us, so please share your thoughts and ideas, and maybe we can make CF an even easier, more robust, powerful product- Tyler Silcox email | [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF's Most Wanted ::
I would like to see an uplaod feature built in to cfmail for attachments!!! Success is a journey, not a destination!! Doug Brown - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 22, 2002 2:00 PM Subject: Re: CF's Most Wanted :: I'd like to see custom tags able to tell CF to process the code inside. Some tags do, like cfoutput and cfquery, while some don't like cfloop. I'd like to be able to do this too with my custom tags without having to plonk ugly cfoutput tags inside each invocation. - Original Message - From: Tyler Silcox [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 2:05 AM Subject: CF's Most Wanted :: (Features, that is...) With all this talk of learning other languages to flesh out your portfolio, and more importantly your knowledge, along with the looming release of NEO/CFMX, I've been trying to think of the features that I currently miss in my ColdFusion. And I thought what better way to get Macromedia's attention, then by creating a heated discussion among the leading, path-forging cf users, which obviously reside on this list (yes, I'm buttering you up.) It seams to me that we see some of the same issues puzzling new or begginer users over and over again, or some great features that are available though creative uses of custom tags are not readily available to those developers hosting on shared servers. And I feel that MM could easily add some nice new tags or attributes to current tags that solve most everyone's problems (and I know nothing is that easy, but it'd be nice.) I also know most of us have submitted feature requests on MM's site, but the community never really geats to chime in. So what I'd like to do is gather up a few of your ideas for improving ColdFusion just to let MM know what we're are thinking. I'm also very interested in what other developers are thinking, and I'm sure y'all are too. I know that timing probably isn't the best for their very, very busy brains over in MM land right now, but there really isn't anytime better than the present. Here's some of the basic probelms that I've come across and that I've seen pop up on this list over and over from the last couple of years: cfmail/cfpop: Needs more stability, more power, ability to read and write multi-part messages (at least), maybe kill the spool or move straight to the a Java spool (with NEO's Java backbone, there really is no excuse not to revamp this tag) cfimage (new tag): Abilty to resize images on the fly, store in cache, read dimensions, etc. (should be a cinch with Macromedia's expertise in graphic products [yea, right]) locking: Needs to protect the server. Period. cfgraph: Use flash to it's fullest. The current tag is a start, but still weak. Needs options galore. cfdirectory: Please just give us one more attribute (filesonly=True, or type=file) or update filter to accept type=file or type=dir. Those directory dots irk me 99% of the time I use the tag. c# support: I'm not even sure this is a possilbilty and it's probably a little early to call for it, but something to think about. And I know that a lot of these features are available as custom tags, etc, right now. But it's not always a feasible option for many developers who are on a monetary or time constraint, or are just hosting on a public server that doesn't allow custom tags. (Honestly, I'm not trying to put anyone out of business.) NOTE: I'm also aware that some some of these things may already be alleviated or improved upon in NEO. For all the Beta testers and PDA hounds out there, please do not jump in on this discussion and say That's already developed and then the subsequent You're not allowed to say that and then I have to say Please keep this discussion in a pre-NEO context etc, etc. So, I'll go ahead and say that now, please keep this discussion to pre-NEO improvements. Although NEO is on it's way, please just submit features you have thought and dreamt about prior to NEO, and future releases. Anyways, I really think that the best minds in the cf community are hanging amidst us, so please share your thoughts and ideas, and maybe we can make CF an even easier, more robust, powerful product- Tyler Silcox email | [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Structure your ColdFusion code with Fusebox. Get the official book at
REReplace and RegExp
Dear CF-Talkers: I have a string in the following format( I've added carriage returns for readability): cfset agents = 'agent primary=NO aid=157 acutter=O469Oldenburg, Claes Thure, b.1929/agent' 'agent primary=NO aid=2481 acutter=B847Bruggen, Coosje van, b.1942/agent' 'agent primary=YES aid=9387 acutter=B343Berger, Patrick, b. 1947/agent' I want to process the string to look like this (replace the AGENT tags with ANCHOR tags): cfset agents = 'a href=results.cfm?c=aidq=157Oldenburg, Claes Thure, b.1929/a' 'a href=results.cfm?c=aidq=2481Bruggen, Coosje van, b.1942/a' 'a href=reulsts.cfm?c=aidq=9387Berger, Patrick, b. 1947/a' I have somewhat accomplished this like so but still need some work and have become a little lost. REReplaceNoCase( agent, 'agent[[:space:]]+primary=(YES|NO)[[:space:]]+aid=([0-9]*)[[:space:]]+a cutter=([a-z0-9]*)(.*)?/agent', ' a href=results.cfm?c=aidq=\2\4/a ', ALL) **Another problem is that the AGENT Attributes can be in any order which really throughs wrench into things. Anyone have any advise on how to approach this? I would really appreciated it. Thanks, Troy -- Troy Simpson Applications Analyst/Programmer - MCSE, OCP-DBA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: connection error
I had this happen to me last week for the first time. I'm not sure exactly what happened. I'm using CF 5.0 on Windows 2000. I restarted the server where CF lives and it worked just fine. It happened again last weekend when I changed a data source. It was almost like it needed to be restarted to refresh something. Restarting the CF services did not do the trick. Sorry I can't be more specific. Hopefully it will point you to something that you can simply restart or refresh to get it going. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Judy [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:02 PM To: CF-Talk Subject: connection error I have establised a connection with my SQL database throught CF Administrator and have verified it's connection. However, when I go to my main .cfm page, I get an error that it cannot find my base table. How can that be? I can see my database and see that it's connected and see all the tables in it when I open it in SQL? Anyone know what's going on? This is the exact message. Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Events'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (5:1) to (5:48). Date/Time: 04/22/02 15:50:15 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) Remote Address: 127.0.0.1 Here's my query to access the database: cfquery name=selectevent datasource=Events SELECT * FROM Events WHERE ID = ID /cfquery __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
s
-- Troy Simpson Applications Analyst/Programmer - MCSE, OCP DBA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: filename in code documentation - WHY?!
If I'm working on several of these files at the same time, Ctrl-Tab-ing back and forth between then, opening and closing other files, and I don't have a filename at the top ... well, it gets very easy to forget which is which. Especially after The Boss comes in and distracts me for 5 minutes with his idea of what the Next Big Thing is. It's easy enough to Ctrl-Home to the top of the document to make sure that I come back to the same document I think I've come back to. Isn't it even easier to look at the file tabs across the bottom of CF Studio for the filename? I agree that a Synch TOC-type function to get the open file and the explorer tab working together would be great. But for now, if you're unsure about where the current file is, you just look across Studio's title bar at the top. Yet again, another place you can check for the filename as well. Putting it inside the file comments still seems totally spurious. Someone mentioned that Fusedoc comments need the filename in the header comments as XML data so files can be parsed automatically in certain ways. This makes sense, but again, surely whatever parsing could work from the name of the file itself? Well, I'm ditching filenames in code comment headers for now, unless someone comes up with a good argument! - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: connection error
When the ODBC DSN was set up, the default database is master, so you are trying to connect to the Events table in the master database which doesn't exist. The solution will be to edit the ODBC DSN to point to the proper database HTH Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: Gieseman, Athelene [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 22, 2002 5:09 PM Subject: RE: connection error I had this happen to me last week for the first time. I'm not sure exactly what happened. I'm using CF 5.0 on Windows 2000. I restarted the server where CF lives and it worked just fine. It happened again last weekend when I changed a data source. It was almost like it needed to be restarted to refresh something. Restarting the CF services did not do the trick. Sorry I can't be more specific. Hopefully it will point you to something that you can simply restart or refresh to get it going. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Judy [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:02 PM To: CF-Talk Subject: connection error I have establised a connection with my SQL database throught CF Administrator and have verified it's connection. However, when I go to my main .cfm page, I get an error that it cannot find my base table. How can that be? I can see my database and see that it's connected and see all the tables in it when I open it in SQL? Anyone know what's going on? This is the exact message. Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Events'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (5:1) to (5:48). Date/Time: 04/22/02 15:50:15 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) Remote Address: 127.0.0.1 Here's my query to access the database: cfquery name=selectevent datasource=Events SELECT * FROM Events WHERE ID = ID /cfquery __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF's Most Wanted ::
How about a rock solid dependable cfmail :) jeff -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 2:09 PM To: CF-Talk Subject: Re: CF's Most Wanted :: I would like to see an uplaod feature built in to cfmail for attachments!!! Success is a journey, not a destination!! Doug Brown - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 22, 2002 2:00 PM Subject: Re: CF's Most Wanted :: I'd like to see custom tags able to tell CF to process the code inside. Some tags do, like cfoutput and cfquery, while some don't like cfloop. I'd like to be able to do this too with my custom tags without having to plonk ugly cfoutput tags inside each invocation. - Original Message - From: Tyler Silcox [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 2:05 AM Subject: CF's Most Wanted :: (Features, that is...) With all this talk of learning other languages to flesh out your portfolio, and more importantly your knowledge, along with the looming release of NEO/CFMX, I've been trying to think of the features that I currently miss in my ColdFusion. And I thought what better way to get Macromedia's attention, then by creating a heated discussion among the leading, path-forging cf users, which obviously reside on this list (yes, I'm buttering you up.) It seams to me that we see some of the same issues puzzling new or begginer users over and over again, or some great features that are available though creative uses of custom tags are not readily available to those developers hosting on shared servers. And I feel that MM could easily add some nice new tags or attributes to current tags that solve most everyone's problems (and I know nothing is that easy, but it'd be nice.) I also know most of us have submitted feature requests on MM's site, but the community never really geats to chime in. So what I'd like to do is gather up a few of your ideas for improving ColdFusion just to let MM know what we're are thinking. I'm also very interested in what other developers are thinking, and I'm sure y'all are too. I know that timing probably isn't the best for their very, very busy brains over in MM land right now, but there really isn't anytime better than the present. Here's some of the basic probelms that I've come across and that I've seen pop up on this list over and over from the last couple of years: cfmail/cfpop: Needs more stability, more power, ability to read and write multi-part messages (at least), maybe kill the spool or move straight to the a Java spool (with NEO's Java backbone, there really is no excuse not to revamp this tag) cfimage (new tag): Abilty to resize images on the fly, store in cache, read dimensions, etc. (should be a cinch with Macromedia's expertise in graphic products [yea, right]) locking: Needs to protect the server. Period. cfgraph: Use flash to it's fullest. The current tag is a start, but still weak. Needs options galore. cfdirectory: Please just give us one more attribute (filesonly=True, or type=file) or update filter to accept type=file or type=dir. Those directory dots irk me 99% of the time I use the tag. c# support: I'm not even sure this is a possilbilty and it's probably a little early to call for it, but something to think about. And I know that a lot of these features are available as custom tags, etc, right now. But it's not always a feasible option for many developers who are on a monetary or time constraint, or are just hosting on a public server that doesn't allow custom tags. (Honestly, I'm not trying to put anyone out of business.) NOTE: I'm also aware that some some of these things may already be alleviated or improved upon in NEO. For all the Beta testers and PDA hounds out there, please do not jump in on this discussion and say That's already developed and then the subsequent You're not allowed to say that and then I have to say Please keep this discussion in a pre-NEO context etc, etc. So, I'll go ahead and say that now, please keep this discussion to pre-NEO improvements. Although NEO is on it's way, please just submit features you have thought and dreamt about prior to NEO, and future releases. Anyways, I really think that the best minds in the cf community are hanging amidst us, so please share your thoughts and ideas, and maybe we can make CF an even easier, more robust, powerful product- Tyler Silcox email | [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe:
RE: REReplace and RegExp
Try this: REReplaceNoCase(agents, (/?)agent([[:space:]]*|[[:space:]]+[^]*), \1a\2, ALL) I have tested this code on CFAS 5 on WinXP. James Ang Senior Programmer MedSeek, Inc. -Original Message- From: Troy Simpson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 2:15 PM To: CF-Talk Subject: REReplace and RegExp Dear CF-Talkers: I have a string in the following format( I've added carriage returns for readability): cfset agents = 'agent primary=NO aid=157 acutter=O469Oldenburg, Claes Thure, b.1929/agent' 'agent primary=NO aid=2481 acutter=B847Bruggen, Coosje van, b.1942/agent' 'agent primary=YES aid=9387 acutter=B343Berger, Patrick, b. 1947/agent' I want to process the string to look like this (replace the AGENT tags with ANCHOR tags): cfset agents = 'a href=results.cfm?c=aidq=157Oldenburg, Claes Thure, b.1929/a' 'a href=results.cfm?c=aidq=2481Bruggen, Coosje van, b.1942/a' 'a href=reulsts.cfm?c=aidq=9387Berger, Patrick, b. 1947/a' I have somewhat accomplished this like so but still need some work and have become a little lost. REReplaceNoCase( agent, 'agent[[:space:]]+primary=(YES|NO)[[:space:]]+aid=([0-9]*)[[:space: ]]+a cutter=([a-z0-9]*)(.*)?/agent', ' a href=results.cfm?c=aidq=\2\4/a ', ALL) **Another problem is that the AGENT Attributes can be in any order which really throughs wrench into things. Anyone have any advise on how to approach this? I would really appreciated it. Thanks, Troy -- Troy Simpson Applications Analyst/Programmer - MCSE, OCP-DBA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF's Most Wanted ::
ahemyeah that too Success is a journey, not a destination!! Doug Brown - Original Message - From: Jeff Green [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 22, 2002 2:49 PM Subject: RE: CF's Most Wanted :: How about a rock solid dependable cfmail :) jeff -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 2:09 PM To: CF-Talk Subject: Re: CF's Most Wanted :: I would like to see an uplaod feature built in to cfmail for attachments!!! Success is a journey, not a destination!! Doug Brown - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 22, 2002 2:00 PM Subject: Re: CF's Most Wanted :: I'd like to see custom tags able to tell CF to process the code inside. Some tags do, like cfoutput and cfquery, while some don't like cfloop. I'd like to be able to do this too with my custom tags without having to plonk ugly cfoutput tags inside each invocation. - Original Message - From: Tyler Silcox [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 2:05 AM Subject: CF's Most Wanted :: (Features, that is...) With all this talk of learning other languages to flesh out your portfolio, and more importantly your knowledge, along with the looming release of NEO/CFMX, I've been trying to think of the features that I currently miss in my ColdFusion. And I thought what better way to get Macromedia's attention, then by creating a heated discussion among the leading, path-forging cf users, which obviously reside on this list (yes, I'm buttering you up.) It seams to me that we see some of the same issues puzzling new or begginer users over and over again, or some great features that are available though creative uses of custom tags are not readily available to those developers hosting on shared servers. And I feel that MM could easily add some nice new tags or attributes to current tags that solve most everyone's problems (and I know nothing is that easy, but it'd be nice.) I also know most of us have submitted feature requests on MM's site, but the community never really geats to chime in. So what I'd like to do is gather up a few of your ideas for improving ColdFusion just to let MM know what we're are thinking. I'm also very interested in what other developers are thinking, and I'm sure y'all are too. I know that timing probably isn't the best for their very, very busy brains over in MM land right now, but there really isn't anytime better than the present. Here's some of the basic probelms that I've come across and that I've seen pop up on this list over and over from the last couple of years: cfmail/cfpop: Needs more stability, more power, ability to read and write multi-part messages (at least), maybe kill the spool or move straight to the a Java spool (with NEO's Java backbone, there really is no excuse not to revamp this tag) cfimage (new tag): Abilty to resize images on the fly, store in cache, read dimensions, etc. (should be a cinch with Macromedia's expertise in graphic products [yea, right]) locking: Needs to protect the server. Period. cfgraph: Use flash to it's fullest. The current tag is a start, but still weak. Needs options galore. cfdirectory: Please just give us one more attribute (filesonly=True, or type=file) or update filter to accept type=file or type=dir. Those directory dots irk me 99% of the time I use the tag. c# support: I'm not even sure this is a possilbilty and it's probably a little early to call for it, but something to think about. And I know that a lot of these features are available as custom tags, etc, right now. But it's not always a feasible option for many developers who are on a monetary or time constraint, or are just hosting on a public server that doesn't allow custom tags. (Honestly, I'm not trying to put anyone out of business.) NOTE: I'm also aware that some some of these things may already be alleviated or improved upon in NEO. For all the Beta testers and PDA hounds out there, please do not jump in on this discussion and say That's already developed and then the subsequent You're not allowed to say that and then I have to say Please keep this discussion in a pre-NEO context etc, etc. So, I'll go ahead and say that now, please keep this discussion to pre-NEO improvements. Although NEO is on it's way, please just submit features you have thought and dreamt about prior to NEO, and future releases. Anyways, I really think that the best minds in the cf community are hanging amidst us, so please share your thoughts and ideas, and maybe we can make CF an even easier, more
Oracle Sequence
Please help me, I have gotten this far and I am not having any luck. I need to output the numbers from the sequence into a database. CREATE SEQUENCE DeptCodeSeq INCREMENT BY 20 START WITH 1000 MAXVALUE 9080 NOCYCLE; CREATE TABLE Departments (DeptCode NUMBER(4), Name VARCHAR2(30), DeptSize NUMBER(5)); DECLARE V_DeptCode DeptCodeSeq; v_Name varchar2(30); v_DeptSize number(5); BEGIN for i in v_deptcode.nextval loop insert into Departments (DeptCode, Name, DeptSize) values (i, v_name, v_deptsize); end loop; drop sequence DeptCodeSeq __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: REReplace and RegExp
Actually, this looks like a UDF candidate for cflib.org. Ray Camden? I don't have time to format it nicely for cflib.org. Anyone wants to volunteer? :) // Assuming that strFind and strReplace has no RegExp characters that need to be escaped // else, someone has to make this UDF more robust! ;) function SwapTag(strSource, strFind, strReplace) { var retVal = strSource; // make sure that the substring to find is not empty. if (Len(Trim(strFind))) { retVal = REFindNoCase(strSource, (/?)#strFind#([[:space:]]*|[[:space:]]+[^]*), \1#strReplace#\2, ALL); } return retVal; } James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: James Ang Sent: Monday, April 22, 2002 2:45 PM To: CF-Talk Subject: RE: REReplace and RegExp Try this: REReplaceNoCase(agents, (/?)agent([[:space:]]*|[[:space:]]+[^]*), \1a\2, ALL) I have tested this code on CFAS 5 on WinXP. James Ang Senior Programmer MedSeek, Inc. -Original Message- From: Troy Simpson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 2:15 PM To: CF-Talk Subject: REReplace and RegExp Dear CF-Talkers: I have a string in the following format( I've added carriage returns for readability): cfset agents = 'agent primary=NO aid=157 acutter=O469Oldenburg, Claes Thure, b.1929/agent' 'agent primary=NO aid=2481 acutter=B847Bruggen, Coosje van, b.1942/agent' 'agent primary=YES aid=9387 acutter=B343Berger, Patrick, b. 1947/agent' I want to process the string to look like this (replace the AGENT tags with ANCHOR tags): cfset agents = 'a href=results.cfm?c=aidq=157Oldenburg, Claes Thure, b.1929/a' 'a href=results.cfm?c=aidq=2481Bruggen, Coosje van, b.1942/a' 'a href=reulsts.cfm?c=aidq=9387Berger, Patrick, b. 1947/a' I have somewhat accomplished this like so but still need some work and have become a little lost. REReplaceNoCase( agent, 'agent[[:space:]]+primary=(YES|NO)[[:space:]]+aid=([0-9]*)[[:space: ]]+a cutter=([a-z0-9]*)(.*)?/agent', ' a href=results.cfm?c=aidq=\2\4/a ', ALL) **Another problem is that the AGENT Attributes can be in any order which really throughs wrench into things. Anyone have any advise on how to approach this? I would really appreciated it. Thanks, Troy -- Troy Simpson Applications Analyst/Programmer - MCSE, OCP-DBA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF's Most Wanted ::
Huh? You can already attach files - and what would server-side code be uploading to? --- Billy Cravens -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 4:09 PM To: CF-Talk Subject: Re: CF's Most Wanted :: I would like to see an uplaod feature built in to cfmail for attachments!!! Success is a journey, not a destination!! Doug Brown - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 22, 2002 2:00 PM Subject: Re: CF's Most Wanted :: I'd like to see custom tags able to tell CF to process the code inside. Some tags do, like cfoutput and cfquery, while some don't like cfloop. I'd like to be able to do this too with my custom tags without having to plonk ugly cfoutput tags inside each invocation. - Original Message - From: Tyler Silcox [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 2:05 AM Subject: CF's Most Wanted :: (Features, that is...) With all this talk of learning other languages to flesh out your portfolio, and more importantly your knowledge, along with the looming release of NEO/CFMX, I've been trying to think of the features that I currently miss in my ColdFusion. And I thought what better way to get Macromedia's attention, then by creating a heated discussion among the leading, path-forging cf users, which obviously reside on this list (yes, I'm buttering you up.) It seams to me that we see some of the same issues puzzling new or begginer users over and over again, or some great features that are available though creative uses of custom tags are not readily available to those developers hosting on shared servers. And I feel that MM could easily add some nice new tags or attributes to current tags that solve most everyone's problems (and I know nothing is that easy, but it'd be nice.) I also know most of us have submitted feature requests on MM's site, but the community never really geats to chime in. So what I'd like to do is gather up a few of your ideas for improving ColdFusion just to let MM know what we're are thinking. I'm also very interested in what other developers are thinking, and I'm sure y'all are too. I know that timing probably isn't the best for their very, very busy brains over in MM land right now, but there really isn't anytime better than the present. Here's some of the basic probelms that I've come across and that I've seen pop up on this list over and over from the last couple of years: cfmail/cfpop: Needs more stability, more power, ability to read and write multi-part messages (at least), maybe kill the spool or move straight to the a Java spool (with NEO's Java backbone, there really is no excuse not to revamp this tag) cfimage (new tag): Abilty to resize images on the fly, store in cache, read dimensions, etc. (should be a cinch with Macromedia's expertise in graphic products [yea, right]) locking: Needs to protect the server. Period. cfgraph: Use flash to it's fullest. The current tag is a start, but still weak. Needs options galore. cfdirectory: Please just give us one more attribute (filesonly=True, or type=file) or update filter to accept type=file or type=dir. Those directory dots irk me 99% of the time I use the tag. c# support: I'm not even sure this is a possilbilty and it's probably a little early to call for it, but something to think about. And I know that a lot of these features are available as custom tags, etc, right now. But it's not always a feasible option for many developers who are on a monetary or time constraint, or are just hosting on a public server that doesn't allow custom tags. (Honestly, I'm not trying to put anyone out of business.) NOTE: I'm also aware that some some of these things may already be alleviated or improved upon in NEO. For all the Beta testers and PDA hounds out there, please do not jump in on this discussion and say That's already developed and then the subsequent You're not allowed to say that and then I have to say Please keep this discussion in a pre-NEO context etc, etc. So, I'll go ahead and say that now, please keep this discussion to pre-NEO improvements. Although NEO is on it's way, please just submit features you have thought and dreamt about prior to NEO, and future releases. Anyways, I really think that the best minds in the cf community are hanging amidst us, so please share your thoughts and ideas, and maybe we can make CF an even easier, more robust, powerful product- Tyler Silcox email | [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives:
RE: CF's Most Wanted ::
And if there is a need for cflock, why doesn't client vars use them? There aren't any concurrency issues for Client variables. They're not stored in memory. They're typically stored in a database It is my firm and biased opinion that memory variable concurrency locking should be part of the application server code and not performed in the scripting language or pseudo-code. However, I think I have said that before and am being repetitiously redundant. Best regards, Dennis Powers UXB Internet - A Web Design and Hosting Company tel: (203)879-2844 fax: (203)879-6254 http://www.uxbinternet.com/ http://dennis.uxb.net/ -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 11:23 AM To: CF-Talk Subject: RE: CF's Most Wanted :: And if there is a need for cflock, why doesn't client vars use them? There aren't any concurrency issues for Client variables. They're not stored in memory. They're typically stored in a database or registry, which will provide its own concurrency controls, or in cookies, which have no concurrency issues. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists