RE: British Pound symbol in a .txt upload file
I wouldn't worry too much, we'll be using Euros (EUR) in not too long a time now course, you'll have to deal with that then too! -Original Message- From: Casey C Cook [mailto:[EMAIL PROTECTED]] Sent: 30 April 2002 21:19 To: CF-Talk Subject: RE: British Pound symbol in a .txt upload file CF is simply displaying whats in the database, which means the symbol conversion occurred between the source file and sequel server 2K. Our DBA pointed us to windows collation designators. Interesting. Still investigating. CC BillyC @BaylorHealthTo: CF-Talk [EMAIL PROTECTED] .edu cc: Subject: RE: British Pound symbol in a .txt upload file 04/30/02 03:07 PM Please respond to cf-talk Verify that ASCII character code of the symbol in question ( you can load the file with a scripting language like cf or vbscript, and use a function like asc() ) --- Billy Cravens Web and Software Consulting www.Architechx.com -Original Message- From: Casey C Cook [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 2:56 PM To: CF-Talk Subject: British Pound symbol in a .txt upload file Hello - We have a UK client uploading a .txt (comma separated) file to a varchar 100 field in our database. The piece of data their trying to upload includes a British Pound symbol and when the user is viewing a report to check their data, the symbol has been replaced by the letter u with a tick over it. Has anyone heard of such a thing? Casey Cook __ 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: web hosts
www.Cfdynamics.com All the support and solutions you'll need. Clients have switched and been oh, so happy. :-) Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) -Original Message- From: Jennifer Larkin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 12:01 AM To: CF-Talk Subject: web hosts One of my clients is trying to decide upon a new webhost. The two that we're looking at are media3 and CrystalTech. We've heard good things about both (and I have good experience with media3). Has anybody had any problems with tech support from either of them? After an hour of being on hold to report that CF server was not responding, we gave up and decided to switch hosts. Now available in a San Francisco Bay Area near you! http://www.blivit.org/mr_urc/index.cfm http://www.blivit.org/mr_urc/resume.cfm __ 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: web hosts
Jennifer, I have a shared host at Crystaltech for over a year now and I have never had a problem with them. I only had to email support once about something and they had responded back within an hour. Whenever any maintenance work or scheduled downtime needs to be done, they inform you with a lot of advance notice. Tim P. - Original Message - From: Jennifer Larkin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 01, 2002 1:45 AM Subject: Re: web hosts At 12:10 AM 5/1/02 -0500, you wrote: CRYSTALTECH... period.. Media3 loads down their servers with many clients ... some people have good luck, but if you get stuck on a system with multiple heavy users, you are out of luck. I have been with crystaltech dedicated servers for over a year and they have been incredible! I don't think it's fair to compare a shared server solution with a dedicated server solution, but I appreciate your comments anyway. Now available in a San Francisco Bay Area near you! http://www.blivit.org/mr_urc/index.cfm http://www.blivit.org/mr_urc/resume.cfm __ 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
Html to PDF, Excel, Word formats
Hi, What are the options of converting a html file on the fly to PDF, Excel and Word using CF ? Thanks. Nyon __ 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: Html to PDF, Excel, Word formats
www.cfcomet.com will give you boundless options. Macromedia's Developer's Exchange is another source of options. Erika | -Original Message- | From: YC Nyon [mailto:[EMAIL PROTECTED]] | | Hi, | | What are the options of converting a html file on the fly | to PDF, Excel and Word using CF ? | | Thanks. | Nyon __ 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
help with unsubscribing
Can someone please tell me how to unsubscribe to this list? I have tried everything but it won't let me. I have sent a message with the following in the body of the message: unsubscribe cf-talk [EMAIL PROTECTED] I have sent a message with the following in the body: unsubscribe cf-talk and unsubscribe cf-talk Nothing works - I keep getting a message back telling me it doesn't recognize a command in the subject - I'm not putting anything in the subject. Please, I need to free up my mailbox - the list has been very helpful, but I'm finished with my CF project for now. ThanksGet more from the Web. FREE MSN Explorer download : http://explorer.msn.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: help with unsubscribing
There's a link at the bottom of every message: http://www.houseoffusion.com/index.cfm?sidebar=lists Going to the CF-Talk page gets you this: http://www.houseoffusion.com/hof/lists/CF_Talk.cfm Choose the unsubscribe option, enter in the email address you are subscribed with, and away you go. HTH, Erika | -Original Message- | From: Judy Mardar [mailto:[EMAIL PROTECTED]] | Sent: 01 May 2002 12:18 | To: CF-Talk | Subject: help with unsubscribing | | | Can someone please tell me how to unsubscribe to this list? | I have tried everything but it won't let me. | | I have sent a message with the following in the body of the message: | | unsubscribe cf-talk [EMAIL PROTECTED] | | | I have sent a message with the following in the body: | | unsubscribe cf-talk | | and | | unsubscribe cf-talk | | Nothing works - I keep getting a message back telling me it | doesn't recognize a command in the subject - I'm not | putting anything in the subject. | | Please, I need to free up my mailbox - the list has been | very helpful, but I'm finished with my CF project for now. | | ThanksGet more from the Web. FREE MSN Explorer download : http://explorer.msn.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: web hosts
At 10:01 PM 30/04/02 -0700, Jennifer Larkin wrote: One of my clients is trying to decide upon a new webhost. The two that we're looking at are media3 and CrystalTech. We've heard good things about I'm very happy with CrystalTech. Their techs reply to e-mails within the hour (and normally within 15 minutes.) All changes I've needed done (switching primary domains, etc.) has been done within 12 hours. T __ 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: help with unsubscribing
this was at the bottom of your mail: __ 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: web hosts
I have to second this opinion. I'm with HostMySite, and I've been extremely satisfied with their support. Very helpful. -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 2:06 AM To: CF-Talk Subject: Re: web hosts I know it is not on your list, but I like http://www.hostmysite.com excellent support!! Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Jennifer Larkin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 10:45 PM Subject: Re: web hosts At 12:10 AM 5/1/02 -0500, you wrote: CRYSTALTECH... period.. Media3 loads down their servers with many clients ... some people have good luck, but if you get stuck on a system with multiple heavy users, you are out of luck. I have been with crystaltech dedicated servers for over a year and they have been incredible! I don't think it's fair to compare a shared server solution with a dedicated server solution, but I appreciate your comments anyway. Now available in a San Francisco Bay Area near you! http://www.blivit.org/mr_urc/index.cfm http://www.blivit.org/mr_urc/resume.cfm __ 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 __ 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: Dollarformat -vs- Numberformat
Thanks for the reply, I ended up finding the cluprit in a difference of SQL statements... one page had select round(line.price * line.rec_qty) and another had just sum(line.price * line.rec_qty)... the difference ended up being on the SQL site of things. Thanks again! Hatton Bud wrote: On 4/30/02, Hatton Humphrey penned: Here's the problem: I recently added a summary report to a financial calculation page. The page has been using NumberFormat(tot_tot+misc_tot,9-$999,999,999.99) for several years (the application has been in live use since around 1998). The report that I built is using DollarFormat instead. I was told that several of the totals are coming up fine in a few cases, off by a penny in most cases and off by two pennies in more than a few cases as well. First of all, am I correct in thinking that this is a display issue? Also, which one is more accurate? I think they pretty much work the same. The main thing you need to do is make sure you aren't calculating on a rounded number. You can't calculate on DollarFormat or NumberFormat with a dollar sign as it will return an error, so the problem may be in the tot_tot or misc_tot being calculated on DecimalFormat elsewhere. For instance. cfset tot_tot = 1.022 cfset num1 = tot_tot * 10 returns 10.22 correctly. cfset num2 = DecimalFormat(tot_tot) * 10 returns 10.20, which is off by 2 cents. __ 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: web hosts
Yes, we run on a dedicated server with them but with our other clients accounts on shared systems with them and dealing with their tech support it is still CRYSTALTECH period. :) Paul Giesenhagen QuillDesign http://ww.quilldesign.com SiteDirector Commerce Builder - Original Message - From: Jennifer Larkin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 01, 2002 12:45 AM Subject: Re: web hosts At 12:10 AM 5/1/02 -0500, you wrote: CRYSTALTECH... period.. Media3 loads down their servers with many clients ... some people have good luck, but if you get stuck on a system with multiple heavy users, you are out of luck. I have been with crystaltech dedicated servers for over a year and they have been incredible! I don't think it's fair to compare a shared server solution with a dedicated server solution, but I appreciate your comments anyway. Now available in a San Francisco Bay Area near you! http://www.blivit.org/mr_urc/index.cfm http://www.blivit.org/mr_urc/resume.cfm __ 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: MX and CustomTags again
Server Details Server Product Neo Version 6,0,0,42977 Edition Enterprise Serial Number Operating System UNIX OS Version 2.4.9-21 -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 5:25 PM To: CF-Talk Subject: RE: MX and CustomTags again What version of CFMX are you running? -Matt -Original Message- From: Shawn McKee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 3:11 PM To: CF-Talk Subject: MX and CustomTags again At install the server was set to /home/cfadm/neo/CustomTags but applications couldn't find the custom tags. I checked case and location and all was correct. I deleted that path from the server and went to add it back in and now I get this error message: Unable to add custom tag path /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin. Even though the path I added was as above. I have typed it by hand and used the browse server function. I am at a loss. Shawn McKee Manager, Web Development NewsStand, Inc. 8620 Burnet Rd., Suite 100 Austin, TX 78757 USA 512-334-5100 Read newspapers and magazines from around the world in a whole new way. NewsStand delivers them to your PC without paper and without delay! Try: http://www.newsstand.com?NSEMC=EMNSI01 __ 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
sql query
I would like to run an update query to take a 9 digit social security number and place the dashes in the correct spots. IE.. 999-99-. Can anyone help me with this? Joshua Tipton __ 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: Html to PDF, Excel, Word formats
I recommend checking out CF_HTML2PDF3 (can be found in the DevEx), a free Custom Tag that generates PDF files. Tried and tested, and very easy to implement. This tag utilizes HTMLDOC.EXE, and you must have CFEXECUTE access on your server. My only gripe is that it does not support CSS. v/r, Jeff -Original Message- From: YC Nyon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 1:28 AM To: CF-Talk Subject: Html to PDF, Excel, Word formats Hi, What are the options of converting a html file on the fly to PDF, Excel and Word using CF ? Thanks. Nyon __ 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 query
All you need is the Insert() function, something like: SSN = Insert(-, SSN, 3); SSN = Insert(-, SSN, 6); Joshua Tipton [EMAIL PROTECTED] 05/01/02 09:14AM I would like to run an update query to take a 9 digit social security number and place the dashes in the correct spots. IE.. 999-99-. Can anyone help me with this? Joshua Tipton __ 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 query
The example below seems easier, but you could also: cfset ssn_formatted = Left(ssn, 3)-Mid(ssn, 4, 2)-Right(ssn, 3) v/r, Jeff -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:20 AM To: CF-Talk Subject: Re: sql query All you need is the Insert() function, something like: SSN = Insert(-, SSN, 3); SSN = Insert(-, SSN, 6); Joshua Tipton [EMAIL PROTECTED] 05/01/02 09:14AM I would like to run an update query to take a 9 digit social security number and place the dashes in the correct spots. IE.. 999-99-. Can anyone help me with this? Joshua Tipton __ 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
IsDefined and Form[testvar] question
If I'm using code like this: cfloop index=QuestionNumber from=1 to=#Form.TotalQuestions# step=1 CFSET Form.NumericAnswer=Form[QuestionQuestionNumber] /CFLOOP Is there a way to use IsDefined to check to see if the form variable has been defined? I tried CFIF IsDefined(Form[QuestionQuestionNumber]) but I get the error Invalid parser construct found on line 8 at position 25. ColdFusion was looking at the following text:Question T __ 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
SQL Server permission question
does nayone know of a way to allow a user to only have permission to execute stored procedures in sql server and not select, update, insert, delete permissions directly? i want people to only be able to access the data in my database from a sp and not directly using select, update, insert, delete. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ 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 Server permission question
Yup - in SQL server you want to create a user that only has permissions to execute SP's. The DSN you set up that the webser uses needs to login using this user. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 01 May 2002 14:37 To: CF-Talk Subject: SQL Server permission question does nayone know of a way to allow a user to only have permission to execute stored procedures in sql server and not select, update, insert, delete permissions directly? i want people to only be able to access the data in my database from a sp and not directly using select, update, insert, delete. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ 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: SQL Server permission question
If you are doing this via the web, then you can use the CF Administrator to do this. Select the DSN that you want to execute only teh Sp, make sure that you chek the Stored Procedures check box. If you are talking about using enterprise manager, then you would need to create a login for the users and allow only SP permissions on the database. -- Original Message -- From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 1 May 2002 09:36:54 -0400 does nayone know of a way to allow a user to only have permission to execute stored procedures in sql server and not select, update, insert, delete permissions directly? i want people to only be able to access the data in my database from a sp and not directly using select, update, insert, delete. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ 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: IsDefined and Form[testvar] question
You can either do: isDefined(form.question#questionnumber#) or structKeyExists(form,question#questionnumber#) I prefer the first method. === 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: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 5:24 AM To: CF-Talk Subject: IsDefined and Form[testvar] question If I'm using code like this: cfloop index=QuestionNumber from=1 to=#Form.TotalQuestions# step=1 CFSET Form.NumericAnswer=Form[QuestionQuestionNumber] /CFLOOP Is there a way to use IsDefined to check to see if the form variable has been defined? I tried CFIF IsDefined(Form[QuestionQuestionNumber]) but I get the error Invalid parser construct found on line 8 at position 25. ColdFusion was looking at the following text:Question T __ 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: SQL Server permission question
Oh - forgot to mention - every SP you create you then need to put a Grant Execute. to that user (or group) -Original Message- From: Andy Ewings Sent: 01 May 2002 14:44 To: '[EMAIL PROTECTED]' Subject: RE: SQL Server permission question Yup - in SQL server you want to create a user that only has permissions to execute SP's. The DSN you set up that the webser uses needs to login using this user. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 01 May 2002 14:37 To: CF-Talk Subject: SQL Server permission question does nayone know of a way to allow a user to only have permission to execute stored procedures in sql server and not select, update, insert, delete permissions directly? i want people to only be able to access the data in my database from a sp and not directly using select, update, insert, delete. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ 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: IsDefined and Form[testvar] question
At 09:44 AM 01/05/02 -0400, Raymond Camden wrote: You can either do: isDefined(form.question#questionnumber#) or structKeyExists(form,question#questionnumber#) I prefer the first method. Thanks Raymond. You are saving me from using evaluate again. I really appreciate all your help. T __ 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
Repost + more info -cfsets and activepdf
REPOST PART I have a page with hundreds of cfsets in it--we are using it to kick out report cards for elementary schools. Each grade card will have over 250 boxes that need filled in using ActivePDF. Unfortunately, when we run a batch for a class or grade level the cold fusion server cpu hits 100% for 10-30 seconds depending on the number of pages. I have run tests and eliminated the queries and if/else statements as the problem. It seems to be in the cfsets such as when there are many of these: CFSET GR1=PDFToolkit.SetFormFieldData(GR1, #GetGrades.Grade[1]#, 0) CFSET GR2=PDFToolkit.SetFormFieldData(GR2, #GetGrades.Grade[2]#, 0) CFSET GR3=PDFToolkit.SetFormFieldData(GR3, #GetGrades.Grade[3]#, 0) I'm wondering what can be done to change this problem as we have 15 elementary schools-with anywhere from 200-700 students per school. NEW PART Several folks said try cfscript--that didn't make a change in the time/resource issue. I emailed the tech support at Activepdf and their response was: Per your issue, there are no workaround for this. Except the only think we can suggest to you is by trying to embedding your application inside a dll and adding it to MTS, which *may* create less stress on the server but there is no guarantee. Do people think this would work? And if so how would I do such a thing? Thanks Janine M. Jakim Database Programmer/Analyst Albemarle County Public Schools Department of Technology Phone: (804) 975-9443 Fax: (804) 975-9442 __ 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
installing application on a linux box
I only have limited experience with Coldfusion on a Unix/Linux platform. The network department at a client site has CF installed on their webserver, so that side is settled. Is there a checklist out there of what I should test and/or change in my code so that the application can be installed seamlessly? I'm looking for things besides making sure filenames are referenced properly, due to the case sensitivity in unix/linux. Thanks, Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.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: Html to PDF, Excel, Word formats
I take it you already searched on google? On Wed, 1 May 2002, YC Nyon wrote: Hi, What are the options of converting a html file on the fly to PDF, Excel and Word using CF ? Thanks. Nyon __ 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: sql query
this has nothing to do with sql. you have to parse the 9 digit number and set it equal to your reformatted number. Use left() or substring On Wed, 1 May 2002, Joshua Tipton wrote: I would like to run an update query to take a 9 digit social security number and place the dashes in the correct spots. IE.. 999-99-. Can anyone help me with this? Joshua Tipton __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql query
Thanks everyone. -Original Message- From: Jeff Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:28 AM To: CF-Talk Subject: RE: sql query The example below seems easier, but you could also: cfset ssn_formatted = Left(ssn, 3)-Mid(ssn, 4, 2)-Right(ssn, 3) v/r, Jeff -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:20 AM To: CF-Talk Subject: Re: sql query All you need is the Insert() function, something like: SSN = Insert(-, SSN, 3); SSN = Insert(-, SSN, 6); Joshua Tipton [EMAIL PROTECTED] 05/01/02 09:14AM I would like to run an update query to take a 9 digit social security number and place the dashes in the correct spots. IE.. 999-99-. Can anyone help me with this? Joshua Tipton __ 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: installing application on a linux box
No direct experience, but I remember reading that Applicaiton.cfm and OnRequestEnd.cfm must be capitalized in a certain way. Pete - Original Message - From: Steven Dworman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 01, 2002 10:12 AM Subject: installing application on a linux box I only have limited experience with Coldfusion on a Unix/Linux platform. The network department at a client site has CF installed on their webserver, so that side is settled. Is there a checklist out there of what I should test and/or change in my code so that the application can be installed seamlessly? I'm looking for things besides making sure filenames are referenced properly, due to the case sensitivity in unix/linux. Thanks, Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.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: IsDefined and Form[testvar] question
One more reason to not use Evaluate... in CFMX. Variables is now a real structure. So, instead of: cfset x = 1 cfset theVar = x cfoutput x is #evaluate(theVar)#/cfoutput You can do: cfset x= 1 cfset theVar = x cfoutputx is #Variables[x]#/cfoutput You can also dump all your local vars: cfdump var=#variables# label=My Local Crap === 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: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:46 AM To: CF-Talk Subject: RE: IsDefined and Form[testvar] question At 09:44 AM 01/05/02 -0400, Raymond Camden wrote: You can either do: isDefined(form.question#questionnumber#) or structKeyExists(form,question#questionnumber#) I prefer the first method. Thanks Raymond. You are saving me from using evaluate again. I really appreciate all your help. T __ 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: Html to PDF, Excel, Word formats
And try CFComet.com. They are pretty smart. Jerry Johnson [EMAIL PROTECTED] 05/01/02 09:51AM I take it you already searched on google? On Wed, 1 May 2002, YC Nyon wrote: Hi, What are the options of converting a html file on the fly to PDF, Excel and Word using CF ? Thanks. Nyon __ 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
CFDJ subscription
Does anybody here know where I can subscribe to the CFDJ online. I tried this link: http://www.sys-con.com/coldfusion/subscribe/SubscribeForm.cfm but it's giving me a 404 error. Anybody know where I can subscribe? Thanks. Ryan J. Pieszak Applications Engineer Marker Systems, Inc. Ziphany, LLC. __ 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: IsDefined and Form[testvar] question
At 10:15 AM 01/05/02 -0400, Raymond Camden wrote: You can do: cfset x= 1 cfset theVar = x cfoutputx is #Variables[x]#/cfoutput You can also dump all your local vars: cfdump var=#variables# label=My Local Crap Well that's really cool. I guess I'll have to move to CFMX soon. T __ 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: sql query
You could do it in SQL, just like you said: DECLARE @oldSsn char(9) SET @oldSsn = '#ssn#' DECLARE @newSsn char(11) SET @newSsn = SUBSTRING(@oldSsn, 1, 3) + '-' + SUBSTRING(@oldSsn, 4, 5) + '-' + SUBSTRING(@oldSsn, 6, 9) INSERT INTO myTable (ssn) VALUES (@newSsn) --- Billy Cravens -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 8:57 AM To: CF-Talk Subject: Re: sql query this has nothing to do with sql. you have to parse the 9 digit number and set it equal to your reformatted number. Use left() or substring On Wed, 1 May 2002, Joshua Tipton wrote: I would like to run an update query to take a 9 digit social security number and place the dashes in the correct spots. IE.. 999-99-. Can anyone help me with this? Joshua Tipton __ 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: Html to PDF, Excel, Word formats
You should be very cautious about invoking HTMLDOC on the server - it has a habit of leaving its thread running. So, a few hundred PDF's could bring your server to its knees. One of my past gigs used it by writing a wrapper ActiveX DLL that used the Win32 API to kill the thread (after n timeout) if it didn't kill itself. For somewhat robust document manipulation, check out ActivePDF, and be sure to check out ASPIN.com for some server-side components for other file types. --- Billy Cravens -Original Message- From: Jeff Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 8:22 AM To: CF-Talk Subject: RE: Html to PDF, Excel, Word formats I recommend checking out CF_HTML2PDF3 (can be found in the DevEx), a free Custom Tag that generates PDF files. Tried and tested, and very easy to implement. This tag utilizes HTMLDOC.EXE, and you must have CFEXECUTE access on your server. My only gripe is that it does not support CSS. v/r, Jeff -Original Message- From: YC Nyon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 1:28 AM To: CF-Talk Subject: Html to PDF, Excel, Word formats Hi, What are the options of converting a html file on the fly to PDF, Excel and Word using CF ? Thanks. Nyon __ 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: IsDefined and Form[testvar] question
dont forget, you can also use isdefined(form.question questionnumber) as in this example: cfparam name=form.question4 default=why did the chicken cross the road cfloop from=1 to=10 index=i cfoutput#i#:/cfoutput cfif isDefined(form.question i) cfoutputit existsbr#form[question i]#br/cfoutput cfelse cfoutputno existbr/cfoutput /cfif /cfloop At 10:45 AM 5/1/2002 -0300, you wrote: At 09:44 AM 01/05/02 -0400, Raymond Camden wrote: You can either do: isDefined(form.question#questionnumber#) or structKeyExists(form,question#questionnumber#) I prefer the first method. Thanks Raymond. You are saving me from using evaluate again. I really appreciate all your help. 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
RE: MX and CustomTags again
It must be a bug then because I am running the same version without issue. I would submit the bug and then possible reinstall beta 3 to get the custom tag path back. If you don't want to reinstall beta 3, rc 1 should be available soon. -Matt -Original Message- From: Shawn McKee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 6:10 AM To: CF-Talk Subject: RE: MX and CustomTags again Server Details Server Product Neo Version 6,0,0,42977 Edition Enterprise Serial Number Operating System UNIX OS Version 2.4.9-21 -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 5:25 PM To: CF-Talk Subject: RE: MX and CustomTags again What version of CFMX are you running? -Matt -Original Message- From: Shawn McKee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 3:11 PM To: CF-Talk Subject: MX and CustomTags again At install the server was set to /home/cfadm/neo/CustomTags but applications couldn't find the custom tags. I checked case and location and all was correct. I deleted that path from the server and went to add it back in and now I get this error message: Unable to add custom tag path /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin. Even though the path I added was as above. I have typed it by hand and used the browse server function. I am at a loss. Shawn McKee Manager, Web Development NewsStand, Inc. 8620 Burnet Rd., Suite 100 Austin, TX 78757 USA 512-334-5100 Read newspapers and magazines from around the world in a whole new way. NewsStand delivers them to your PC without paper and without delay! Try: http://www.newsstand.com?NSEMC=EMNSI01 __ 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: states - counties - zip codes database?
Bump, can anyone help me out with this? This has to be a common question. Anyone know of an updated database as mentioned in the subject line - preferably one that stores the relationships between counties - zip codes? __ 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: states - counties - zip codes database?
Zipinfo.com --- Billy Cravens -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:49 AM To: CF-Talk Subject: RE: states - counties - zip codes database? Bump, can anyone help me out with this? This has to be a common question. Anyone know of an updated database as mentioned in the subject line - preferably one that stores the relationships between counties - zip codes? __ 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: states - counties - zip codes database?
Bump, can anyone help me out with this? This has to be a common question. Anyone know of an updated database as mentioned in the subject line - preferably one that stores the relationships between counties - zip codes? http://www.usps.com/search97cgi/s97_cgi?action=ViewVdkVgwKey=http%3A%2F%2Fw ww%2Eusps%2Ecom%2Ffoia%2Freadroom%2Fzipcodedir%2EhtmDocOffset=4DocsFound=4 23QueryZip=zip+codesCollection=externalHLNavigate=off The USPS can help you out, for a fee of course. I do not know of any FREE versions of the same thing. -Craig Thomas __ 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: installing application on a linux box
Aside from case-sensitivity If your code is not doing anything with the OS then you do not have to change anything. Write once run anywhere On Wed, 1 May 2002, Steven Dworman wrote: I only have limited experience with Coldfusion on a Unix/Linux platform. The network department at a client site has CF installed on their webserver, so that side is settled. Is there a checklist out there of what I should test and/or change in my code so that the application can be installed seamlessly? I'm looking for things besides making sure filenames are referenced properly, due to the case sensitivity in unix/linux. Thanks, Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.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: CFDJ subscription
Does anybody here know where I can subscribe to the CFDJ online. I tried this link: http://www.sys-con.com/coldfusion/subscribe/SubscribeForm.cfm but it's giving me a 404 error. Anybody know where I can subscribe? Thanks. To be perfectly honest with you, I think that their site is one of the worst sites I have ever seen. For what subscribers pay annually just to CFDJ, let alone their other publications, you would figure that they would put something a big more user-friendly and less ad-intensive. But that doesn't answer your question, I know. Sorry, just had to vent on that one. My suggestion would be to go to your nearest bookstore (i.e., Barnes and Noble) and look for a subscription insert in one of their issues. My boss subscribed to it for our department a few months back, and all we got were timeouts and 404 errors. So I just went down to BN and grabbed an insert. Snail mail still has its benefits!! Regards, Dave. _ Send and receive Hotmail on your mobile device: http://mobile.msn.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: states - counties - zip codes database?
For just city and state: http://www.usps.com/ncsc/lookups/lookup_ctystzip.html -- sam -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 8:11 AM To: CF-Talk Subject: RE: states - counties - zip codes database? Bump, can anyone help me out with this? This has to be a common question. Anyone know of an updated database as mentioned in the subject line - preferably one that stores the relationships between counties - zip codes? http://www.usps.com/search97cgi/s97_cgi?action=ViewVdkVgwKey=http%3A%2F%2Fw ww%2Eusps%2Ecom%2Ffoia%2Freadroom%2Fzipcodedir%2EhtmDocOffset=4DocsFound=4 23QueryZip=zip+codesCollection=externalHLNavigate=off The USPS can help you out, for a fee of course. I do not know of any FREE versions of the same thing. -Craig Thomas __ 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: CFDJ subscription
1-800-513-7111 -Craig Thomas __ 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
sql Stored Proc
The red protion works and I can output the variable my problem is the blue highlighted part. Is it possible to create that part of the query from what is in a variable? CREATE PROCEDURE sp_ctmdatacorp corp char(4) = null, reg_no char(4) =null, dis_no char(4) =null, date1 varchar(4), date2 varchar(4) = null, rpttype char(10) AS /*SELECT corp, reg_no, dis_no, date1,date2, rpttype*/ declare col varchar(30) if(rpttype) = 'Missing' begin set col = [desc] Like '%Missing%' OR [DESC] IS NULL end set nocount on if (corp is not null and reg_no is null and dis_no is null and date1 is not null and date2 is null) BEGIN SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into #blahtable FROM vw_CTMCORPAPPFULLVIEWprod WHERE (col) and year = date1 GROUP BY reg_NO, y_id, M_id ORDER BY cast(y_id as int), cast(m_id as int) insert into #blahtable SELECT DISTINCT dbo.tbl_CTMCORPMONTHYEARRDD.m_id, dbo.tbl_CTMCORPMONTHYEARRDD.y_id, dbo.tbl_CTMCORPMONTHYEARRDD.reg_no, 0 as intcost, 0 as extcost, CONVERT(datetime, (cast(tbl_CTMCORPMONTHYEARRDD.m_id as varchar)) + '/01/' + (cast(tbl_CTMCORPMONTHYEARRDD.y_id as varchar))) as dateinput FROM dbo.tbl_CTMCORPMONTHYEARRDD LEFT OUTER JOIN #blahtable ON dbo.tbl_CTMCORPMONTHYEARRDD.y_id = #blahtable.y_id AND dbo.tbl_CTMCORPMONTHYEARRDD.m_id = #blahtable.m_id AND dbo.tbl_CTMCORPMONTHYEARRDD.reg_no = #blahtable.reg_no WHERE (#blahtable.m_id IS NULL) AND (#blahtable.y_id IS NULL) AND (#blahtable.reg_no IS NULL) and dbo.tbl_CTMCORPMONTHYEARRDD.y_id = right(date1,1) select * from #blahtable drop table #blahtable END __ 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: CFDJ subscription
No kidding. Slow, too many ads, broken functionality. Kinda like hiring a painter whose house is chipping and cracking... --- Billy Cravens -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 10:14 AM To: CF-Talk Subject: Re: CFDJ subscription Does anybody here know where I can subscribe to the CFDJ online. I tried this link: http://www.sys-con.com/coldfusion/subscribe/SubscribeForm.cfm but it's giving me a 404 error. Anybody know where I can subscribe? Thanks. To be perfectly honest with you, I think that their site is one of the worst sites I have ever seen. For what subscribers pay annually just to CFDJ, let alone their other publications, you would figure that they would put something a big more user-friendly and less ad-intensive. But that doesn't answer your question, I know. Sorry, just had to vent on that one. My suggestion would be to go to your nearest bookstore (i.e., Barnes and Noble) and look for a subscription insert in one of their issues. My boss subscribed to it for our department a few months back, and all we got were timeouts and 404 errors. So I just went down to BN and grabbed an insert. Snail mail still has its benefits!! Regards, Dave. _ Send and receive Hotmail on your mobile device: http://mobile.msn.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: states - counties - zip codes database?
Yeah, but I bet they're looking for a database, not an interactive form. (And USPS states that they have the right to restrict access, for all those geniuses that want to steal someone else's bandwidth with CFHTTP) --- Billy Cravens -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 10:15 AM To: CF-Talk Subject: RE: states - counties - zip codes database? For just city and state: http://www.usps.com/ncsc/lookups/lookup_ctystzip.html -- sam -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 8:11 AM To: CF-Talk Subject: RE: states - counties - zip codes database? Bump, can anyone help me out with this? This has to be a common question. Anyone know of an updated database as mentioned in the subject line - preferably one that stores the relationships between counties - zip codes? http://www.usps.com/search97cgi/s97_cgi?action=ViewVdkVgwKey=http%3A%2F %2Fw ww%2Eusps%2Ecom%2Ffoia%2Freadroom%2Fzipcodedir%2EhtmDocOffset=4DocsFou nd=4 23QueryZip=zip+codesCollection=externalHLNavigate=off The USPS can help you out, for a fee of course. I do not know of any FREE versions of the same thing. -Craig Thomas __ 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: IsDefined and Form[testvar] question
cfparam name=form.question4 default=why did the chicken cross the road cfloop from=1 to=10 index=i cfoutput#i#:/cfoutput cfif isDefined(form.question i) cfoutputit existsbr#form[question i]#br/cfoutput cfelse cfoutputno existbr/cfoutput /cfif /cfloop Seems funny that you're using the form[] to speed things up, but then using CFParam to slow it down again... Much quicker to make a UDF for CFParam and then cfset CFParam(form.question4, why did the chicken cross the road) Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ 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
Need NT Authentication Tag for CFMX
Since CFMX no longer supports Advanced Security, we can no longer authenticate against an NT Domain. The philosophy for our Intranet is that we use the same login as the PC to login to specific protected resources ouf our Intranet. We use NT groups to centrally manage these protected areas and using CFAS to check belongs to a specific group. I'm looking for a tag which can return that info that I can use with CFMX before we upgrade. I looked at IHT stuff as Dave W. suggested but it doesn't seem to have anything that will answer the question Is this user authenticated and what groups he/she belongs to? Any suggestions would be appreciated. Thanks __ 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: IsDefined and Form[testvar] question
My 2 cents - not a MACR official position: Not using cfparam because it is slower than if(isdefined...) doesn't make much sense. If your application is at the level where it does matter, fine, but this won't account for more than 0.001% of the sites out there. To me, this is like the argument against using: cfif x is foo as opposed to compareNoCase, which to me, makes the code much less readable. The only time I tell people not to use cfparam is when they using it like cfset. (Ie, they ALWAYS want it to set.) === 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: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 11:40 AM To: CF-Talk Subject: RE: IsDefined and Form[testvar] question cfparam name=form.question4 default=why did the chicken cross the road cfloop from=1 to=10 index=i cfoutput#i#:/cfoutput cfif isDefined(form.question i) cfoutputit existsbr#form[question i]#br/cfoutput cfelse cfoutputno existbr/cfoutput /cfif /cfloop Seems funny that you're using the form[] to speed things up, but then using CFParam to slow it down again... Much quicker to make a UDF for CFParam and then cfset CFParam(form.question4, why did the chicken cross the road) __ 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: Need NT Authentication Tag for CFMX
I think I found it! Must be blind:) - Original Message - From: Frank Mamone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 01, 2002 11:42 AM Subject: Need NT Authentication Tag for CFMX Since CFMX no longer supports Advanced Security, we can no longer authenticate against an NT Domain. The philosophy for our Intranet is that we use the same login as the PC to login to specific protected resources ouf our Intranet. We use NT groups to centrally manage these protected areas and using CFAS to check belongs to a specific group. I'm looking for a tag which can return that info that I can use with CFMX before we upgrade. I looked at IHT stuff as Dave W. suggested but it doesn't seem to have anything that will answer the question Is this user authenticated and what groups he/she belongs to? Any suggestions would be appreciated. Thanks __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql Stored Proc
If the colors didnt come across the declare and set all work fine the part that is giving me a problem is the @col when I try to use it in the query. Does anyone know how to make this work correctly? Joshua TIpton -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 11:35 AM To: CF-Talk Subject: sql Stored Proc The red protion works and I can output the variable my problem is the blue highlighted part. Is it possible to create that part of the query from what is in a variable? CREATE PROCEDURE sp_ctmdatacorp @corp char(4) = null, @reg_no char(4) =null, @dis_no char(4) =null, @date1 varchar(4), @date2 varchar(4) = null, @rpttype char(10) AS /*SELECT @corp, @reg_no, @dis_no, @date1,@date2, @rpttype*/ declare @col varchar(30) if(@rpttype) = 'Missing' begin set @col = [desc] Like '%Missing%' OR [DESC] IS NULL end set nocount on if (@corp is not null and @reg_no is null and @dis_no is null and @date1 is not null and @date2 is null) BEGIN SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into #blahtable FROM vw_CTMCORPAPPFULLVIEWprod WHERE (@col) and year = @date1 GROUP BY reg_NO, y_id, M_id ORDER BY cast(y_id as int), cast(m_id as int) insert into #blahtable SELECT DISTINCT dbo.tbl_CTMCORPMONTHYEARRDD.m_id, dbo.tbl_CTMCORPMONTHYEARRDD.y_id, dbo.tbl_CTMCORPMONTHYEARRDD.reg_no, 0 as intcost, 0 as extcost, CONVERT(datetime, (cast(tbl_CTMCORPMONTHYEARRDD.m_id as varchar)) + '/01/' + (cast(tbl_CTMCORPMONTHYEARRDD.y_id as varchar))) as dateinput FROM dbo.tbl_CTMCORPMONTHYEARRDD LEFT OUTER JOIN #blahtable ON dbo.tbl_CTMCORPMONTHYEARRDD.y_id = #blahtable.y_id AND dbo.tbl_CTMCORPMONTHYEARRDD.m_id = #blahtable.m_id AND dbo.tbl_CTMCORPMONTHYEARRDD.reg_no = #blahtable.reg_no WHERE (#blahtable.m_id IS NULL) AND (#blahtable.y_id IS NULL) AND (#blahtable.reg_no IS NULL) and dbo.tbl_CTMCORPMONTHYEARRDD.y_id = right(@date1,1) select * from #blahtable drop table #blahtable END __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql Stored Proc
You missed the word AS in the declare statement: DECLARE @col AS nvarchar(30) -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:00 AM To: CF-Talk Subject: RE: sql Stored Proc If the colors didnt come across the declare and set all work fine the part that is giving me a problem is the @col when I try to use it in the query. Does anyone know how to make this work correctly? Joshua TIpton -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 11:35 AM To: CF-Talk Subject: sql Stored Proc The red protion works and I can output the variable my problem is the blue highlighted part. Is it possible to create that part of the query from what is in a variable? CREATE PROCEDURE sp_ctmdatacorp @corp char(4) = null, @reg_no char(4) =null, @dis_no char(4) =null, @date1 varchar(4), @date2 varchar(4) = null, @rpttype char(10) AS /*SELECT @corp, @reg_no, @dis_no, @date1,@date2, @rpttype*/ declare @col varchar(30) if(@rpttype) = 'Missing' begin set @col = [desc] Like '%Missing%' OR [DESC] IS NULL end set nocount on if (@corp is not null and @reg_no is null and @dis_no is null and @date1 is not null and @date2 is null) BEGIN SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into #blahtable FROM vw_CTMCORPAPPFULLVIEWprod WHERE (@col) and year = @date1 GROUP BY reg_NO, y_id, M_id ORDER BY cast(y_id as int), cast(m_id as int) insert into #blahtable SELECT DISTINCT dbo.tbl_CTMCORPMONTHYEARRDD.m_id, dbo.tbl_CTMCORPMONTHYEARRDD.y_id, dbo.tbl_CTMCORPMONTHYEARRDD.reg_no, 0 as intcost, 0 as extcost, CONVERT(datetime, (cast(tbl_CTMCORPMONTHYEARRDD.m_id as varchar)) + '/01/' + (cast(tbl_CTMCORPMONTHYEARRDD.y_id as varchar))) as dateinput FROM dbo.tbl_CTMCORPMONTHYEARRDD LEFT OUTER JOIN #blahtable ON dbo.tbl_CTMCORPMONTHYEARRDD.y_id = #blahtable.y_id AND dbo.tbl_CTMCORPMONTHYEARRDD.m_id = #blahtable.m_id AND dbo.tbl_CTMCORPMONTHYEARRDD.reg_no = #blahtable.reg_no WHERE (#blahtable.m_id IS NULL) AND (#blahtable.y_id IS NULL) AND (#blahtable.reg_no IS NULL) and dbo.tbl_CTMCORPMONTHYEARRDD.y_id = right(@date1,1) select * from #blahtable drop table #blahtable END __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql Stored Proc
Oops... My Bad... Tested after... Not needed... -Original Message- From: Costas Piliotis Sent: Wednesday, May 01, 2002 9:00 AM To: CF-Talk Subject: RE: sql Stored Proc You missed the word AS in the declare statement: DECLARE @col AS nvarchar(30) -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:00 AM To: CF-Talk Subject: RE: sql Stored Proc If the colors didnt come across the declare and set all work fine the part that is giving me a problem is the @col when I try to use it in the query. Does anyone know how to make this work correctly? Joshua TIpton -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 11:35 AM To: CF-Talk Subject: sql Stored Proc The red protion works and I can output the variable my problem is the blue highlighted part. Is it possible to create that part of the query from what is in a variable? CREATE PROCEDURE sp_ctmdatacorp @corp char(4) = null, @reg_no char(4) =null, @dis_no char(4) =null, @date1 varchar(4), @date2 varchar(4) = null, @rpttype char(10) AS /*SELECT @corp, @reg_no, @dis_no, @date1,@date2, @rpttype*/ declare @col varchar(30) if(@rpttype) = 'Missing' begin set @col = [desc] Like '%Missing%' OR [DESC] IS NULL end set nocount on if (@corp is not null and @reg_no is null and @dis_no is null and @date1 is not null and @date2 is null) BEGIN SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into #blahtable FROM vw_CTMCORPAPPFULLVIEWprod WHERE (@col) and year = @date1 GROUP BY reg_NO, y_id, M_id ORDER BY cast(y_id as int), cast(m_id as int) insert into #blahtable SELECT DISTINCT dbo.tbl_CTMCORPMONTHYEARRDD.m_id, dbo.tbl_CTMCORPMONTHYEARRDD.y_id, dbo.tbl_CTMCORPMONTHYEARRDD.reg_no, 0 as intcost, 0 as extcost, CONVERT(datetime, (cast(tbl_CTMCORPMONTHYEARRDD.m_id as varchar)) + '/01/' + (cast(tbl_CTMCORPMONTHYEARRDD.y_id as varchar))) as dateinput FROM dbo.tbl_CTMCORPMONTHYEARRDD LEFT OUTER JOIN #blahtable ON dbo.tbl_CTMCORPMONTHYEARRDD.y_id = #blahtable.y_id AND dbo.tbl_CTMCORPMONTHYEARRDD.m_id = #blahtable.m_id AND dbo.tbl_CTMCORPMONTHYEARRDD.reg_no = #blahtable.reg_no WHERE (#blahtable.m_id IS NULL) AND (#blahtable.y_id IS NULL) AND (#blahtable.reg_no IS NULL) and dbo.tbl_CTMCORPMONTHYEARRDD.y_id = right(@date1,1) select * from #blahtable drop table #blahtable END __ 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: MX and CustomTags again
Well I tried but the bug submittal blew up. I sent them an e-mail about that and will try later. -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:48 AM To: CF-Talk Subject: RE: MX and CustomTags again It must be a bug then because I am running the same version without issue. I would submit the bug and then possible reinstall beta 3 to get the custom tag path back. If you don't want to reinstall beta 3, rc 1 should be available soon. -Matt -Original Message- From: Shawn McKee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 6:10 AM To: CF-Talk Subject: RE: MX and CustomTags again Server Details Server Product Neo Version 6,0,0,42977 Edition Enterprise Serial Number Operating System UNIX OS Version 2.4.9-21 -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 5:25 PM To: CF-Talk Subject: RE: MX and CustomTags again What version of CFMX are you running? -Matt -Original Message- From: Shawn McKee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 3:11 PM To: CF-Talk Subject: MX and CustomTags again At install the server was set to /home/cfadm/neo/CustomTags but applications couldn't find the custom tags. I checked case and location and all was correct. I deleted that path from the server and went to add it back in and now I get this error message: Unable to add custom tag path /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin. Even though the path I added was as above. I have typed it by hand and used the browse server function. I am at a loss. Shawn McKee Manager, Web Development NewsStand, Inc. 8620 Burnet Rd., Suite 100 Austin, TX 78757 USA 512-334-5100 Read newspapers and magazines from around the world in a whole new way. NewsStand delivers them to your PC without paper and without delay! Try: http://www.newsstand.com?NSEMC=EMNSI01 __ 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: sql Stored Proc
you don't need it.. -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: 01 May 2002 17:00 To: CF-Talk Subject: RE: sql Stored Proc You missed the word AS in the declare statement: DECLARE @col AS nvarchar(30) -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:00 AM To: CF-Talk Subject: RE: sql Stored Proc If the colors didnt come across the declare and set all work fine the part that is giving me a problem is the @col when I try to use it in the query. Does anyone know how to make this work correctly? Joshua TIpton -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 11:35 AM To: CF-Talk Subject: sql Stored Proc The red protion works and I can output the variable my problem is the blue highlighted part. Is it possible to create that part of the query from what is in a variable? CREATE PROCEDURE sp_ctmdatacorp @corp char(4) = null, @reg_no char(4) =null, @dis_no char(4) =null, @date1 varchar(4), @date2 varchar(4) = null, @rpttype char(10) AS /*SELECT @corp, @reg_no, @dis_no, @date1,@date2, @rpttype*/ declare @col varchar(30) if(@rpttype) = 'Missing' begin set @col = [desc] Like '%Missing%' OR [DESC] IS NULL end set nocount on if (@corp is not null and @reg_no is null and @dis_no is null and @date1 is not null and @date2 is null) BEGIN SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into #blahtable FROM vw_CTMCORPAPPFULLVIEWprod WHERE (@col) and year = @date1 GROUP BY reg_NO, y_id, M_id ORDER BY cast(y_id as int), cast(m_id as int) insert into #blahtable SELECT DISTINCT dbo.tbl_CTMCORPMONTHYEARRDD.m_id, dbo.tbl_CTMCORPMONTHYEARRDD.y_id, dbo.tbl_CTMCORPMONTHYEARRDD.reg_no, 0 as intcost, 0 as extcost, CONVERT(datetime, (cast(tbl_CTMCORPMONTHYEARRDD.m_id as varchar)) + '/01/' + (cast(tbl_CTMCORPMONTHYEARRDD.y_id as varchar))) as dateinput FROM dbo.tbl_CTMCORPMONTHYEARRDD LEFT OUTER JOIN #blahtable ON dbo.tbl_CTMCORPMONTHYEARRDD.y_id = #blahtable.y_id AND dbo.tbl_CTMCORPMONTHYEARRDD.m_id = #blahtable.m_id AND dbo.tbl_CTMCORPMONTHYEARRDD.reg_no = #blahtable.reg_no WHERE (#blahtable.m_id IS NULL) AND (#blahtable.y_id IS NULL) AND (#blahtable.reg_no IS NULL) and dbo.tbl_CTMCORPMONTHYEARRDD.y_id = right(@date1,1) select * from #blahtable drop table #blahtable END __ 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: sql Stored Proc
I recieve an error incorrect synatx near the keyword and. declare @col as varchar(500) if(@rpttype) = 'Missing' begin set @col = ([desc] Like '%Missing%' OR [DESC] IS NULL) end set nocount on if (@corp is not null and @reg_no is null and @dis_no is null and @date1 is not null and @date2 is null) BEGIN SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into #blahtable FROM vw_CTMCORPAPPFULLVIEWprod where @col and year = @date1 GROUP BY reg_NO, y_id, M_id ORDER BY cast(y_id as int), cast(m_id as int) -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 12:00 PM To: CF-Talk Subject: RE: sql Stored Proc You missed the word AS in the declare statement: DECLARE @col AS nvarchar(30) -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:00 AM To: CF-Talk Subject: RE: sql Stored Proc If the colors didnt come across the declare and set all work fine the part that is giving me a problem is the @col when I try to use it in the query. Does anyone know how to make this work correctly? Joshua TIpton -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 11:35 AM To: CF-Talk Subject: sql Stored Proc The red protion works and I can output the variable my problem is the blue highlighted part. Is it possible to create that part of the query from what is in a variable? CREATE PROCEDURE sp_ctmdatacorp @corp char(4) = null, @reg_no char(4) =null, @dis_no char(4) =null, @date1 varchar(4), @date2 varchar(4) = null, @rpttype char(10) AS /*SELECT @corp, @reg_no, @dis_no, @date1,@date2, @rpttype*/ declare @col varchar(30) if(@rpttype) = 'Missing' begin set @col = [desc] Like '%Missing%' OR [DESC] IS NULL end set nocount on if (@corp is not null and @reg_no is null and @dis_no is null and @date1 is not null and @date2 is null) BEGIN SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into #blahtable FROM vw_CTMCORPAPPFULLVIEWprod WHERE (@col) and year = @date1 GROUP BY reg_NO, y_id, M_id ORDER BY cast(y_id as int), cast(m_id as int) insert into #blahtable SELECT DISTINCT dbo.tbl_CTMCORPMONTHYEARRDD.m_id, dbo.tbl_CTMCORPMONTHYEARRDD.y_id, dbo.tbl_CTMCORPMONTHYEARRDD.reg_no, 0 as intcost, 0 as extcost, CONVERT(datetime, (cast(tbl_CTMCORPMONTHYEARRDD.m_id as varchar)) + '/01/' + (cast(tbl_CTMCORPMONTHYEARRDD.y_id as varchar))) as dateinput FROM dbo.tbl_CTMCORPMONTHYEARRDD LEFT OUTER JOIN #blahtable ON dbo.tbl_CTMCORPMONTHYEARRDD.y_id = #blahtable.y_id AND dbo.tbl_CTMCORPMONTHYEARRDD.m_id = #blahtable.m_id AND dbo.tbl_CTMCORPMONTHYEARRDD.reg_no = #blahtable.reg_no WHERE (#blahtable.m_id IS NULL) AND (#blahtable.y_id IS NULL) AND (#blahtable.reg_no IS NULL) and dbo.tbl_CTMCORPMONTHYEARRDD.y_id = right(@date1,1) select * from #blahtable drop table #blahtable END __ 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: states - counties - zip codes database?
http://www.speedkeys.com/download.htm There is a text file on this site with zip, city, and area code. This may be helpful. -- Sam -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 8:15 AM To: CF-Talk Subject: RE: states - counties - zip codes database? For just city and state: http://www.usps.com/ncsc/lookups/lookup_ctystzip.html -- sam -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 8:11 AM To: CF-Talk Subject: RE: states - counties - zip codes database? Bump, can anyone help me out with this? This has to be a common question. Anyone know of an updated database as mentioned in the subject line - preferably one that stores the relationships between counties - zip codes? http://www.usps.com/search97cgi/s97_cgi?action=ViewVdkVgwKey=http%3A%2F%2Fw ww%2Eusps%2Ecom%2Ffoia%2Freadroom%2Fzipcodedir%2EhtmDocOffset=4DocsFound=4 23QueryZip=zip+codesCollection=externalHLNavigate=off The USPS can help you out, for a fee of course. I do not know of any FREE versions of the same thing. -Craig Thomas __ 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: Calling server code without reloading
I just went through a few days of trying to figure this out and found that the only two ways were using a javascript to load a .gif and passing the parameters or using a hidden frame and dynamically changing the frame src. If you have control over the page you are submitting and can cause it return a .gif content type then the .gif method is the easiest. If you do not have control over the page then the hidden frame method will work the best as you will be able to confirm that the page is loaded. I have a URL at home on this that I will forward tonight as I cannot seem to find it from here. Justin -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 4:26 PM To: CF-Talk Subject: Calling server code without reloading Lets say I have a form field on a page. When I type in it, I want what I have typed to be sent to the server and something done to it. THe result of that something will come back to me and be loaded into a different form field. This should be done without reloading the page. Normally, I'd do this with a hidden frame and some javascript. I've been asked to do it some other way using layers, objects or other stuff. I'm researching it but I might as well ask if anyone here has heard of something in this area. Thanks Michael Dinowitz Publisher: Fusion Authority weekly news alert (www.fusionauthority.com/alert) Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc. (www.houseoffusion.com) __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IsDefined and Form[testvar] question
the cfparam was just a quick add in, so that the form element existed for the test, but would still exist if a real form element were sent At 04:40 PM 5/1/2002 +0100, you wrote: cfparam name=form.question4 default=why did the chicken cross the road cfloop from=1 to=10 index=i cfoutput#i#:/cfoutput cfif isDefined(form.question i) cfoutputit existsbr#form[question i]#br/cfoutput cfelse cfoutputno existbr/cfoutput /cfif /cfloop Seems funny that you're using the form[] to speed things up, but then using CFParam to slow it down again... Much quicker to make a UDF for CFParam and then cfset CFParam(form.question4, why did the chicken cross the road) Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ 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: Where's Advanced Security?
Dave Watts wrote: Well, that should save some work. Sandbox Security appears to be Enterprise Edition only, so we will simply leave the CF hosting business because there is no way to justify such an investment :( Yeah, that's a tough break. However, it seems like the big thing you lose without the integrated security is RDS access. Why not offer the same sort of access you offer to edit Perl, PHP, and so on? Then, you could take advantage of the new lower price for CF Professional, and you could justify the loss of RDS by giving your CF customers a price cut! Discussing this is pretty pointless until we know what is actually included in the various versions of CFMX. But that has never stopped me before :) I have done some digging and came up with some more official info: The feature comparison matrix says that all versions have Resource security, and only the Enterprise editions have Server Sandbox Security. http://www.macromedia.com/software/coldfusion/whitepapers/pdf/ColdFusionMXFeatureGrid_03.pdf Developing ColdFusion MX Applications with CFML says the following: The directory or directories to which a set of rules apply is called a sandbox, and resource security is also called sandbox security http://livedocs.macromedia.com/cf6docs/Developing_ColdFusion_MX_Applications_with_CFML/appSecurity3.jsp? So will it be possible in CF MX Pro to limit the resources a hosted customer can access based on the directory in which his templates are or not? BTW, giving a price cut is not an option. That would mean we would have to pay customers to use CF :) Jochem __ 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
Distributing self-contained CFMX apps
Not really a question, just some thoughts and musings... One of the neatest (and understated) features of the Neo beta and the Preview CFMX release is the inclusion of a standalone web server (along with the jvm jre). This allows MM customers to download and install a complete, operational CF system without having to install prerequisite/corequisite software, service packs, etc... Simplify, simplify! There were many installation issues in the beta, but MM will work these out. This encapsulation was done on all the supported platforms [sigh]! What is exciting to me is the potential ability to distribute/install a completely self-contained package on a CD or a kiosk. With proper licensing, I could include my CF app on a CD along with all that is needed to install or run it (the CFMF package) on any of the supported OSes. Also included on the CD would be the data necessary to run the app, along with the RDBMS (if open source) or special CF tags to emulate dbs with flat files (already available). There have been several threads, in the past, that discussed the desirability of this. So, it would be relatively easy to put together a complete application package (operational or evaluation), burn a CD (in reality multiple CDs or DVD) and send it off to the end user! With a simple (if somewhat lengthy) install, the customer would be up and running! A variation, would be to install this encapsulated system on a kiosk where the app could run standalone or, periodically, as an intelligent client to a remote server (or both). This could be a real boon to developers, in general, and ASPs in particular! Dick __ 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
CF Wishlist
Ok, Have carefully considered what I want from CF, the most striking feature I want to see is... Stop treating empty list items as null. That is a list of 3,5,,,3,2,2 should have a length of 7, instead of 5. Doing this would nearly eliminate the need for any field names like name=cost_#i#, since HTML sends back 3,5,,,3,2,2 for duplicate text fields named cost anyways. __ 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 Wishlist
Oh, man! That would be great. -Original Message- From: David Schmidt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 11:42 AM To: CF-Talk Subject: CF Wishlist Ok, Have carefully considered what I want from CF, the most striking feature I want to see is... Stop treating empty list items as null. That is a list of 3,5,,,3,2,2 should have a length of 7, instead of 5. Doing this would nearly eliminate the need for any field names like name=cost_#i#, since HTML sends back 3,5,,,3,2,2 for duplicate text fields named cost anyways. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX = Neo ?
Since Dreamweaver is one of the most extensible programs out there and it has its own DOM, read the help files and write the code to close all open documents yourself. Then share it with everyone. I glad you can finally print the source code. :-) Mike - Original Message - From: Shawn Regan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 3:55 PM Subject: RE: CFMX = Neo ? I miss the Close All function :( -Shawn Regan -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 9:44 AM To: CF-Talk Subject: RE: CFMX = Neo ? And actually, right click on the tab itself (beneath the document) and you can close, save, etc. --- Ben -Original Message- From: Vernon Viehe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 12:37 PM To: CF-Talk Subject: RE: CFMX = Neo ? Y'all know you can hand-code to your heart's desire in DWMX, right? Just go to the code view, and have at it! I was a huge fan of CF Studio, but I've also been a big fan of DW. I have to say that in DWMX, I feel I can work in either mode, but after using it for about a month, I find that I switch back forth depending on the task at hand. I saw that someone else mentioned that they were dissappointed that the right-click close-file wasn't in DWMX. I have to agree on that point, but hey, I'm amazed at how the engineers merged the functionalities of the two programs! I for one will be sending in a request that they add that to the right-click on the doc window-menu by using the feature request bug report form at: http://www.macromedia.com/support/email/wishform -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 6:58 PM To: CF-Talk Subject: RE: CFMX = Neo ? Is Macromedia Studio MX, CF Studio 6? Not exactly. CF Studio, as we knew it, is an end-of-life product. It's being replaced with Dreamweaver MX (one of the components of Studio MX, I think), which is supposed to combine the best features of the previous versions of Dreamweaver Ultradev and CF Studio. The above is scary since I never really liked dreamweaver/ultradev too much, or for that matter any code/html generators. Just let me keep my Studio! :) Jeff __ 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: sql Stored Proc
Can anyone else give me any insight on this? -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 12:08 PM To: CF-Talk Subject: RE: sql Stored Proc I recieve an error incorrect synatx near the keyword and. declare @col as varchar(500) if(@rpttype) = 'Missing' begin set @col = ([desc] Like '%Missing%' OR [DESC] IS NULL) end set nocount on if (@corp is not null and @reg_no is null and @dis_no is null and @date1 is not null and @date2 is null) BEGIN SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into #blahtable FROM vw_CTMCORPAPPFULLVIEWprod where @col and year = @date1 GROUP BY reg_NO, y_id, M_id ORDER BY cast(y_id as int), cast(m_id as int) -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 12:00 PM To: CF-Talk Subject: RE: sql Stored Proc You missed the word AS in the declare statement: DECLARE @col AS nvarchar(30) -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:00 AM To: CF-Talk Subject: RE: sql Stored Proc If the colors didnt come across the declare and set all work fine the part that is giving me a problem is the @col when I try to use it in the query. Does anyone know how to make this work correctly? Joshua TIpton -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 11:35 AM To: CF-Talk Subject: sql Stored Proc The red protion works and I can output the variable my problem is the blue highlighted part. Is it possible to create that part of the query from what is in a variable? CREATE PROCEDURE sp_ctmdatacorp @corp char(4) = null, @reg_no char(4) =null, @dis_no char(4) =null, @date1 varchar(4), @date2 varchar(4) = null, @rpttype char(10) AS /*SELECT @corp, @reg_no, @dis_no, @date1,@date2, @rpttype*/ declare @col varchar(30) if(@rpttype) = 'Missing' begin set @col = [desc] Like '%Missing%' OR [DESC] IS NULL end set nocount on if (@corp is not null and @reg_no is null and @dis_no is null and @date1 is not null and @date2 is null) BEGIN SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into #blahtable FROM vw_CTMCORPAPPFULLVIEWprod WHERE (@col) and year = @date1 GROUP BY reg_NO, y_id, M_id ORDER BY cast(y_id as int), cast(m_id as int) insert into #blahtable SELECT DISTINCT dbo.tbl_CTMCORPMONTHYEARRDD.m_id, dbo.tbl_CTMCORPMONTHYEARRDD.y_id, dbo.tbl_CTMCORPMONTHYEARRDD.reg_no, 0 as intcost, 0 as extcost, CONVERT(datetime, (cast(tbl_CTMCORPMONTHYEARRDD.m_id as varchar)) + '/01/' + (cast(tbl_CTMCORPMONTHYEARRDD.y_id as varchar))) as dateinput FROM dbo.tbl_CTMCORPMONTHYEARRDD LEFT OUTER JOIN #blahtable ON dbo.tbl_CTMCORPMONTHYEARRDD.y_id = #blahtable.y_id AND dbo.tbl_CTMCORPMONTHYEARRDD.m_id = #blahtable.m_id AND dbo.tbl_CTMCORPMONTHYEARRDD.reg_no = #blahtable.reg_no WHERE (#blahtable.m_id IS NULL) AND (#blahtable.y_id IS NULL) AND (#blahtable.reg_no IS NULL) and dbo.tbl_CTMCORPMONTHYEARRDD.y_id = right(@date1,1) select * from #blahtable drop table #blahtable END __ 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: Calling server code without reloading
You can do this with Flash, also. Flash has some very nice client/server form interaction (in addition to all the sizzle). Dick On Wednesday, May 1, 2002, at 09:20 AM, Justin Greene wrote: I just went through a few days of trying to figure this out and found that the only two ways were using a javascript to load a .gif and passing the parameters or using a hidden frame and dynamically changing the frame src. If you have control over the page you are submitting and can cause it return a .gif content type then the .gif method is the easiest. If you do not have control over the page then the hidden frame method will work the best as you will be able to confirm that the page is loaded. I have a URL at home on this that I will forward tonight as I cannot seem to find it from here. Justin -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 4:26 PM To: CF-Talk Subject: Calling server code without reloading Lets say I have a form field on a page. When I type in it, I want what I have typed to be sent to the server and something done to it. THe result of that something will come back to me and be loaded into a different form field. This should be done without reloading the page. Normally, I'd do this with a hidden frame and some javascript. I've been asked to do it some other way using layers, objects or other stuff. I'm researching it but I might as well ask if anyone here has heard of something in this area. Thanks Michael Dinowitz Publisher: Fusion Authority weekly news alert (www.fusionauthority.com/alert) Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc. (www.houseoffusion.com) __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Wishlist
Amen!!! Shawn McKee -Original Message- From: David Schmidt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 11:42 AM To: CF-Talk Subject: CF Wishlist Ok, Have carefully considered what I want from CF, the most striking feature I want to see is... Stop treating empty list items as null. That is a list of 3,5,,,3,2,2 should have a length of 7, instead of 5. Doing this would nearly eliminate the need for any field names like name=cost_#i#, since HTML sends back 3,5,,,3,2,2 for duplicate text fields named cost anyways. __ 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: CFStudio DWMX hiccups
You ought to read the hlp files on that one. - Find you snippets you want to share - Copy those to a network drive - Tell whomever to copy them to there machine - They can now change them Not really shared are they? Also, no way to create shortcut keys for snippets. Bummer. I noticed that any new snippets were saved in (win2000) C:\Documents and Settings\mbruce\Application Data\Macromedia\Dreamweaver MX\Configuration ... and not in the Program Files\Macromedia\Dreamweaver MX\Configuration ... as the help file state. If this is not happening to others, please let me know. To the registry Maybe some neet-o setting there. Mike - Original Message - From: Gyrus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 1:45 PM Subject: Re: CFStudio DWMX hiccups - Is there anything like shared snippets in DWMX? installing them in the above location makes them always available. To whom? There doesn't seem to be a way of changing the location of snippets. And in CFStudio there's a definite distinction between local and shared snippet folders. Having them all local means no shared, no? - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ 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
CFNORTH nearly sold out!
** -- CFNORTH IS IN 3 DAYS -- Register now, or you might miss it! http://www.CFNorth.com/ Price: $230.00 (Canadian) or $145.00 (American). ** The organizers and the speakers are extremely excited about the CFNorth Developers Conference this weekend in Toronto. So is the development community, so much so that we have seen a recent surge in registration. CFNorth is now 90% sold-out. We expect that the conference will sell-out by Tomorrow or Friday. If you miss this conference, you will miss out on a lot of great things whether you are a ColdFusion developer on not. With Macromedias recent MX announcements including ColdFusion MX and Macromedia Flash Remoting, CFNorth has become an international event and is being seen as the world-wide premiere of the next generation ColdFusion technology, on J2EE!We have over 10 sessions just on ColdFusion MX, exploring new features and new techniques. We also have 4 sessions on Flash and the new Macromedia Flash Remoting. Flash Remoting replaces the need for XML or LoadVariables. Plus, you can now do Server-Side ActionScripting we will talk about that too! We have all the major players in the ColdFusion market place at the conference, so it is bound to be a great weekend. The weatherman predicts it will be 20 degrees Celsius this weekend, so lots of warm May weather in Toronto. Register now, or you might miss it! http://www.CFNorth.com/ Price: $230.00 (Canadian) or $145.00 (American). -- Michael Smith, TeraTech Inc VB, CF , SQL, Math programming 12221 Parklawn Dr Ste 200, Rockville MD 20852-1711 USA Voice: +1-301-881-1440 x110, 800-447-9120 Fax:301-881-3586 Web: http://www.teratech.com/sig/ Email: mailto:[EMAIL PROTECTED] ICQ: 66057682 __ 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 Wishlist
In the meantime, let me contribute this method...
cfloop condition=IsDefined('form.cost_#i#') EQ true
!--- Your process goes here. ---
/cfloop
It's not perfect, but it works...
-Original Message-
From: David Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 30, 2002 9:42 AM
To: CF-Talk
Subject: CF Wishlist
Ok,
Have carefully considered what I want from CF, the most striking feature I
want to see is...
Stop treating empty list items as null. That is a list of 3,5,,,3,2,2
should have a length of 7, instead of 5. Doing this would nearly
eliminate
the need for any field names like name=cost_#i#, since HTML sends back
3,5,,,3,2,2 for duplicate text fields named cost anyways.
__
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 Wishlist
David, Depending on the context of the data, you can simulate the required behavior by replacing instances of double commas with a comma followed by a space (or any character you desire) followed by another comma. For example: Replace(3,5,,,3,2,2, ,,, , ,, ALL) You could also use a RegEx replacement if you want a little more control over how the replacement is done. -Dan -Original Message- From: David Schmidt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 12:42 PM To: CF-Talk Subject: CF Wishlist Ok, Have carefully considered what I want from CF, the most striking feature I want to see is... Stop treating empty list items as null. That is a list of 3,5,,,3,2,2 should have a length of 7, instead of 5. Doing this would nearly eliminate the need for any field names like name=cost_#i#, since HTML sends back 3,5,,,3,2,2 for duplicate text fields named cost anyways. __ 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 Wishlist
Have asked for that about 500 times. Hope we get it!! ;) | -Original Message- | From: David Schmidt [mailto:[EMAIL PROTECTED]] | Sent: Tuesday, April 30, 2002 9:42 AM | To: CF-Talk | Subject: CF Wishlist | | | Ok, | | Have carefully considered what I want from CF, the most | striking feature I want to see is... | | Stop treating empty list items as null. That is a list of | 3,5,,,3,2,2 should have a length of 7, instead of 5. Doing | this would nearly eliminate the need for any field names like | name=cost_#i#, since HTML sends back 3,5,,,3,2,2 for | duplicate text fields named cost anyways. | | | __ 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 Wishlist
Whoops, here it is, correctly...
cfset i = 1
cfloop condition=IsDefined('form.cost_#i#') EQ true
!--- Your process goes here. ---
cfset i=i+1
/cfloop
-Original Message-
From: David Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 30, 2002 9:53 AM
To: CF-Talk
Subject: RE: CF Wishlist
In the meantime, let me contribute this method...
cfloop condition=IsDefined('form.cost_#i#') EQ true
!--- Your process goes here. ---
/cfloop
It's not perfect, but it works...
-Original Message-
From: David Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 30, 2002 9:42 AM
To: CF-Talk
Subject: CF Wishlist
Ok,
Have carefully considered what I want from CF, the most
striking feature I
want to see is...
Stop treating empty list items as null. That is a list of
3,5,,,3,2,2
should have a length of 7, instead of 5. Doing this would nearly
eliminate
the need for any field names like name=cost_#i#, since HTML sends back
3,5,,,3,2,2 for duplicate text fields named cost anyways.
__
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
Quick question...
Anyone remember the CHR code for a tab? I'm having a senior moment and I'm not event 35 yet... Portent Interactive Helping clients build customer relationships on the web since 1995 Consulting, design, development, measurement http://www.portentinteractive.com Talk with us: http://projects.portentinteractive.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: Quick question...
Chr(9) --- Billy Cravens -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 11:56 AM To: CF-Talk Subject: Quick question... Anyone remember the CHR code for a tab? I'm having a senior moment and I'm not event 35 yet... Portent Interactive Helping clients build customer relationships on the web since 1995 Consulting, design, development, measurement http://www.portentinteractive.com Talk with us: http://projects.portentinteractive.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Quick question...
oi Ian!! 9 -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Wednesday, May 1, 2002, 12:56:16 PM, you wrote: IL Anyone remember the CHR code for a tab? I'm having a senior moment and I'm IL not event 35 yet... IL Portent Interactive IL Helping clients build customer relationships on the web since 1995 IL Consulting, design, development, measurement IL http://www.portentinteractive.com IL Talk with us: http://projects.portentinteractive.com IL __ 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: Quick question...
char 9 +---+ 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: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:56 AM To: CF-Talk Subject: Quick question... Anyone remember the CHR code for a tab? I'm having a senior moment and I'm not event 35 yet... Portent Interactive Helping clients build customer relationships on the web since 1995 Consulting, design, development, measurement http://www.portentinteractive.com Talk with us: http://projects.portentinteractive.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: Quick question...
I believe it's 9 (chr(9)) - Original Message - From: Ian Lurie [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 01, 2002 11:56 AM Subject: Quick question... Anyone remember the CHR code for a tab? I'm having a senior moment and I'm not event 35 yet... Portent Interactive Helping clients build customer relationships on the web since 1995 Consulting, design, development, measurement http://www.portentinteractive.com Talk with us: http://projects.portentinteractive.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: Quick question...
9 On Wednesday, May 1, 2002, at 09:56 AM, Ian Lurie wrote: Anyone remember the CHR code for a tab? I'm having a senior moment and I'm not event 35 yet... Portent Interactive Helping clients build customer relationships on the web since 1995 Consulting, design, development, measurement http://www.portentinteractive.com Talk with us: http://projects.portentinteractive.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: Distributing self-contained CFMX apps
Is the stand alone CFMX server using some one else's web server, or does the embedded JRun server act as a web server? Can it serve .htm(l) pages? -Craig Thomas __ 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: Where's Advanced Security?
Technically with Pro, the same set of resource permissions is given to all the templates, no matter how many CF applications you host. Christine -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 12:22 PM To: CF-Talk Subject: Re: Where's Advanced Security? Dave Watts wrote: Well, that should save some work. Sandbox Security appears to be Enterprise Edition only, so we will simply leave the CF hosting business because there is no way to justify such an investment :( Yeah, that's a tough break. However, it seems like the big thing you lose without the integrated security is RDS access. Why not offer the same sort of access you offer to edit Perl, PHP, and so on? Then, you could take advantage of the new lower price for CF Professional, and you could justify the loss of RDS by giving your CF customers a price cut! Discussing this is pretty pointless until we know what is actually included in the various versions of CFMX. But that has never stopped me before :) I have done some digging and came up with some more official info: The feature comparison matrix says that all versions have Resource security, and only the Enterprise editions have Server Sandbox Security. http://www.macromedia.com/software/coldfusion/whitepapers/pdf/ColdFusionMXFeatureGrid_03.pdf Developing ColdFusion MX Applications with CFML says the following: The directory or directories to which a set of rules apply is called a sandbox, and resource security is also called sandbox security http://livedocs.macromedia.com/cf6docs/Developing_ColdFusion_MX_Applications_with_CFML/appSecurity3.jsp? So will it be possible in CF MX Pro to limit the resources a hosted customer can access based on the directory in which his templates are or not? BTW, giving a price cut is not an option. That would mean we would have to pay customers to use CF :) Jochem __ 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: Distributing self-contained CFMX apps
AFAIK, JRun is the Web Appliication server, the Standalone web server is used in lieu of a web server such as IIS, Apache, etc. As such, the standalone server serves html. Dick On Wednesday, May 1, 2002, at 10:25 AM, Craig Thomas wrote: Is the stand alone CFMX server using some one else's web server, or does the embedded JRun server act as a web server? Can it serve .htm(l) pages? -Craig Thomas __ 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: Distributing self-contained CFMX apps
The only downside being that the CFMX license will make the cost of the software prohibitive. Imagine tacking on thousands of dollars to the price of your development. It's possible, though not likely. Bill [EMAIL PROTECTED] 5/1/02 9:26 AM Not really a question, just some thoughts and musings... One of the neatest (and understated) features of the Neo beta and the Preview CFMX release is the inclusion of a standalone web server (along with the jvm jre). This allows MM customers to download and install a complete, operational CF system without having to install prerequisite/corequisite software, service packs, etc... Simplify, simplify! There were many installation issues in the beta, but MM will work these out. This encapsulation was done on all the supported platforms [sigh]! What is exciting to me is the potential ability to distribute/install a completely self-contained package on a CD or a kiosk. With proper licensing, I could include my CF app on a CD along with all that is needed to install or run it (the CFMF package) on any of the supported OSes. Also included on the CD would be the data necessary to run the app, along with the RDBMS (if open source) or special CF tags to emulate dbs with flat files (already available). There have been several threads, in the past, that discussed the desirability of this. So, it would be relatively easy to put together a complete application package (operational or evaluation), burn a CD (in reality multiple CDs or DVD) and send it off to the end user! With a simple (if somewhat lengthy) install, the customer would be up and running! A variation, would be to install this encapsulated system on a kiosk where the app could run standalone or, periodically, as an intelligent client to a remote server (or both). This could be a real boon to developers, in general, and ASPs in particular! Dick __ 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: Distributing self-contained CFMX apps
The only downside being that the CFMX license will make the cost of the software prohibitive. Imagine tacking on thousands of dollars to the price of your development. Wouldn't 'cost prohibitive' depend on the client? If they are running their own server (or even using a dedicated host) they have to purchase CFMX anyway, so self contained CFMX apps is not only possible, it is more cost effective for the client as their IT personnel will only need to install once. -Craig Thomas __ 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: Distributing self-contained CFMX apps
Yeah, but self-contained apps would require one license per app, as opposed to one application server running multiple apps. Not to mention resolution of the issue that arises when you have a client that already has CFMX (hardly a brain-bender, but an issue nonetheless if you adopt the self-contained app business model) --- Billy Cravens -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 12:42 PM To: CF-Talk Subject: RE: Distributing self-contained CFMX apps The only downside being that the CFMX license will make the cost of the software prohibitive. Imagine tacking on thousands of dollars to the price of your development. Wouldn't 'cost prohibitive' depend on the client? If they are running their own server (or even using a dedicated host) they have to purchase CFMX anyway, so self contained CFMX apps is not only possible, it is more cost effective for the client as their IT personnel will only need to install once. -Craig Thomas __ 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: Distributing self-contained CFMX apps
Yeah, but self-contained apps would require one license per app, as opposed to one application server running multiple apps. Very good point. -Craig __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
JavaScript - Validation of Date - 3 Drop down lits
Hi, Does any body have Javascript code snippet that validates the date. I have a 3 drop lists (Year- 02 format , Month - 01 format, day - 01 format) I have to check the date selected by the user is greater or equal to today's date . I am combining all the three values I am stuck with this, as it is giving the int value of the combined string (parseInt()) as 0. I think there is a better way of doing this. Thanks in advance. Sudheer Chakka __ 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: Distributing self-contained CFMX apps
If the CF templates are compiled into classes, could you then run them on any ol' servlet web server? Would that violate the license agreement? - Matt Small -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 1:58 PM To: CF-Talk Subject: RE: Distributing self-contained CFMX apps Yeah, but self-contained apps would require one license per app, as opposed to one application server running multiple apps. Very good point. -Craig __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Distributing self-contained CFMX apps
Matt, It doesn't work quite that way. because the class files are actually a collection of callse to Java classes that are a part ofthe CFMX installation, they will NOT run without the CFMX run time. Mark - Original Message - From: Matthew R. Small [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 01, 2002 1:06 PM Subject: RE: Distributing self-contained CFMX apps If the CF templates are compiled into classes, could you then run them on any ol' servlet web server? Would that violate the license agreement? - Matt Small -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 1:58 PM To: CF-Talk Subject: RE: Distributing self-contained CFMX apps Yeah, but self-contained apps would require one license per app, as opposed to one application server running multiple apps. Very good point. -Craig __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Distributing self-contained CFMX apps
Just b/c they're compiled into classes, doesn't mean that they aren't calling classes proprietary to CFMX but external to the application. --- Billy Cravens -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 1:06 PM To: CF-Talk Subject: RE: Distributing self-contained CFMX apps If the CF templates are compiled into classes, could you then run them on any ol' servlet web server? Would that violate the license agreement? - Matt Small -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 1:58 PM To: CF-Talk Subject: RE: Distributing self-contained CFMX apps Yeah, but self-contained apps would require one license per app, as opposed to one application server running multiple apps. Very good point. -Craig __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Distributing self-contained CFMX apps
You are going to need a copy of CFMX running. However MM is as usual thinking the same way we are. They recently released this: http://www.macromedia.com/macromedia/proom/pr/2002/server_integration.html Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 2:06 PM To: CF-Talk Subject: RE: Distributing self-contained CFMX apps If the CF templates are compiled into classes, could you then run them on any ol' servlet web server? Would that violate the license agreement? - Matt Small -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 1:58 PM To: CF-Talk Subject: RE: Distributing self-contained CFMX apps Yeah, but self-contained apps would require one license per app, as opposed to one application server running multiple apps. Very good point. -Craig __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Distributing self-contained CFMX apps
Yeah, I was thinking that. But as a point of curiosity, you could just take the CF classes and your template classes after compilation and run them on any java server, right? Or am I missing something? - Matt Small -Original Message- From: Mk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 2:37 PM To: CF-Talk Subject: Re: Distributing self-contained CFMX apps Matt, It doesn't work quite that way. because the class files are actually a collection of callse to Java classes that are a part ofthe CFMX installation, they will NOT run without the CFMX run time. Mark - Original Message - From: Matthew R. Small [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 01, 2002 1:06 PM Subject: RE: Distributing self-contained CFMX apps If the CF templates are compiled into classes, could you then run them on any ol' servlet web server? Would that violate the license agreement? - Matt Small -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 1:58 PM To: CF-Talk Subject: RE: Distributing self-contained CFMX apps Yeah, but self-contained apps would require one license per app, as opposed to one application server running multiple apps. Very good point. -Craig __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Calling server code without reloading
Well there are two different ways to do it that I know of. The easiest would
be the xmlhttp objects available in IE5+ and Mozilla. Sending url
parameters, and getting back your data in a parseable format. I haven't done
this but in theory it is very easy. Some code...
try {
// for Mozilla
req = new XMLHttpRequest();
req.overrideMimeType(text/xml);
} catch (e) {
// for IE5+
req = new ActiveXObject(Msxml2.XMLHTTP);
}
req.open(GET, page.html,false);
req.send(null);
If NS4 is a requirement hidden ilayers are the only way to go. In which
case, you might as well use the hidden iframe method in IE/Moz. In this case
you would change the src of the ilayer/iframe, and in the page in the
invisible frame you would grab the data you want from the database based on
the url parameters, and have functions in the hidden object that basically
pass the data to functions in the parent page that do the visual stuff like
filling in form fields.
I have a site up that is doing this now for a phone number lookup, but it
requires a login. Shoot me an email and I can send you a demo u/p.
jon
- Original Message -
From: Michael Dinowitz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 4:26 PM
Subject: Calling server code without reloading
Lets say I have a form field on a page. When I type in it, I want what I
have typed to be sent to the server and something done to it. THe result of
that something will come back to me and be loaded into a different form
field. This should be done without reloading the page.
Normally, I'd do this with a hidden frame and some javascript. I've been
asked to do it some other way using layers, objects or other stuff. I'm
researching it but I might as well ask if anyone here has heard of something
in this area.
Thanks
Michael Dinowitz
Publisher: Fusion Authority weekly news alert
(www.fusionauthority.com/alert)
Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc.
(www.houseoffusion.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: Distributing self-contained CFMX apps
AFAIK, JRun is the Web Appliication server, the Standalone web server is used in lieu of a web server such as IIS, Apache, etc. As such, the standalone server serves html. Dick What is 'AFAIK'? -Craig Thomas __ 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 Wishlist
Lists behave the same way in MX as they do in CF5. You can download a ListFix UDF from cflib.org. It will replace null entries w/ a character of your chosing. === 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: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 12:53 PM To: CF-Talk Subject: RE: CF Wishlist Have asked for that about 500 times. Hope we get it!! ;) | -Original Message- | From: David Schmidt [mailto:[EMAIL PROTECTED]] | Sent: Tuesday, April 30, 2002 9:42 AM | To: CF-Talk | Subject: CF Wishlist | | | Ok, | | Have carefully considered what I want from CF, the most | striking feature I want to see is... | | Stop treating empty list items as null. That is a list of | 3,5,,,3,2,2 should have a length of 7, instead of 5. Doing | this would nearly eliminate the need for any field names like | name=cost_#i#, since HTML sends back 3,5,,,3,2,2 for | duplicate text fields named cost anyways. | | | __ 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: Distributing self-contained CFMX apps
as far as i know -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 2:17 PM To: CF-Talk Subject: RE: Distributing self-contained CFMX apps AFAIK, JRun is the Web Appliication server, the Standalone web server is used in lieu of a web server such as IIS, Apache, etc. As such, the standalone server serves html. Dick What is 'AFAIK'? -Craig Thomas __ 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 - Validation of Date - 3 Drop down lits
Use the Date object in JS:
(Haven't tested this, coding off the cuff):
objFrmDate = new Date(frm.year.value,frm.month.value,frm.days.value);
objToday = new Date();
// getTime method converts to ms since 1/1/70, allowing for absolute
date comparison
numFrmDate = objFrmDate.getTime();
numToday = objToday.getTime();
if (numFrmDate = numToday) {
// date is greater than or equal to today
return true;
} else {
return false;
}
Good info on the date object:
http://developer.netscape.com/viewsource/goodman_dateobject.html
---
Billy Cravens
-Original Message-
From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 12:50 PM
To: CF-Talk
Subject: JavaScript - Validation of Date - 3 Drop down lits
Hi,
Does any body have Javascript code snippet that validates the date.
I have a 3 drop lists (Year- 02 format , Month - 01 format, day - 01
format)
I have to check the date selected by the user is greater or equal to
today's date .
I am combining all the three values
I am stuck with this, as it is giving the int value of the combined
string
(parseInt()) as 0.
I think there is a better way of doing this.
Thanks in advance.
Sudheer Chakka
__
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: Distributing self-contained CFMX apps
What is 'AFAIK'? http://www.acronymfinder.com/af-query.asp?Acronym=AFAIK -Ron BOOKS JUST WANNA BE FREE! http://BookCrossing.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
