RE: Verity Question
Use custom1, custom2 and title -Original Message- From: Smith, Daron [PA] [mailto:[EMAIL PROTECTED]] Sent: dinsdag 18 december 2001 21:44 To: CF-Talk Subject: Verity Question I don't know which is better in this situation. I am working on a new site that will be almost exclusively database driven. I need to associate three fields with the collection. CFINDEX only allows 2 custom1 and custom2. Is there any way using verity I can keep a third with the collection? Or should I just use a stored procedure to a database to do the search? Daron J. Smith Web Developer PSEA [EMAIL PROTECTED] 717-255-7141 1-800-944-PSEA (7732) x 7141 Please note new email address (old one with 'mail' will soon expire) FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ 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: problems with _date
The problem is: If you have a field named something_date, CF will try to validate a formfield something as a US date. As the field something doesn't exist, the validation will fail. The value of the form field is used as errormessage (that's why the message is like that). The solution is to change the name of the formfield something_date. If you _absolutly_ want that name kept, create a hidden formfield with the name 'something' and the value '01/01/2000'. Pascal Peters Macromedia Certified Instructor Certified ColdFusion (5.0) Advanced Developer Certified Web Developer LR Technologies, Belgium Tel +32 2 639 68 70 Fax +32 2 639 68 99 Email [EMAIL PROTECTED] Web www.lrt.be -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED]] Sent: dinsdag 18 december 2001 21:29 To: CF-Talk Subject: Re: problems with _date ok, but that does not explain why i am getting this error. the date seems to be a properly formatted date - Original Message - From: Howie Hamlin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 18, 2001 3:04 PM Subject: Re: problems with _date That's by design in ColdFusion: The following table describes the hidden field suffixes that you can use to do validation: _integer Custom error message Verifies that the user entered a number. If the user enters a floating point value, it is rounded to an integer. _float Custom error message Verifies that the user entered a number. Does not do any rounding of floating point values. _range MIN=MinValue MAX=MaxValue Verifies that the numeric value entered is within the specified boundaries. You can specify one or both of the boundaries separated by a space. _date Custom error message Verifies that the user entered a date and converts the date into the proper ODBC date format. Will accept most common date forms; for example, 9/1/98; Sept. 9, 1998. _time Custom error message Verifies that the user correctly entered a time and converts the time to the proper ODBC time format. _eurodate Custom error message Verifies that the user entered a date in a standard European date format and converts into the proper ODBC date format. Regards, Howie - Original Message - From: Tyler Clendenin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 18, 2001 3:02 PM Subject: problems with _date has anyone seen this before? we arte having big problems with any form fields ending with _date please help =( Form Entries Incomplete or Invalid One or more problems exist with the data you have entered. a.. 12/20/2001 Use the Back button on your web browser to return to the previous page and correct the listed problems. - --- Parameters Form Fields: FIELDNAMES=NEWS,FUSEACTION,RFA,SUBBUT FUSEACTION=Events.EditNewsAct NEWS=Wer dude NEWS_DATE=12/20/2001 RFA=Events.EditEvent SUBBUT=edit News __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cf monitoring service
Hi. Who has experience with the ColdFusion Monitoring Service on windows platforms? Specifically its interactions with the web servers. I have seen several situations now where this service severely messes up the IIS metabase, like virtual servers that disappear when IIS is restarted, etc. Cheers Michiel __ 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
cfsearch - Improving indexing speed for DB collection.
I have several verity collections that index database records. It was behaving fine before when I indexed these collections. I have altered my code some, and it now indexes about twice as many pages, but takes at least 10x as long to execute. The only significant changes that I made are 1) I am adding rows to the query using QueryAddRow(), and 2) I changed they Key that is used from a numeric identity to a mixed number/text combination. Is it important that the key is an integer? TIA - Ben Morris __ 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
DevCon2001 CD's
Anybody heard when the DevCon2001 CD's will ship. We were supposed to have them this month. Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] If your wife is having fun and you're not, you're still having a lot more fun than if you're having fun and she's not!' - Red Green __ 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: Stripping last 4 characters from string
Hi, I have a variable #GetFontFamily# which displays the results Garamond.fnt How can I strip off the .fnt and only display Garamond on my page? Thanks __ 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: Stripping last 4 characters from string
ListFirst(GetFontFamily, .) -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: 19 December 2001 14:46 To: CF-Talk Subject: Re: Stripping last 4 characters from string Hi, I have a variable #GetFontFamily# which displays the results Garamond.fnt How can I strip off the .fnt and only display Garamond on my page? 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: Stripping last 4 characters from string
You could simply treat the string as a .delimited list and use ListFirst(GetFontFamily, '.') -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: 19 December 2001 14:46 To: CF-Talk Subject: Re: Stripping last 4 characters from string Hi, I have a variable #GetFontFamily# which displays the results Garamond.fnt How can I strip off the .fnt and only display Garamond on my page? Thanks __ 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: Stripping last 4 characters from string
CFSET fontName = #Left(fontName,Len(fontName)-4)# Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 8:46 AM To: CF-Talk Subject: Re: Stripping last 4 characters from string Hi, I have a variable #GetFontFamily# which displays the results Garamond.fnt How can I strip off the .fnt and only display Garamond on my page? Thanks __ 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: Stripping last 4 characters from string
#Left(GetFontFamily,Len(GetFontFamily)-4)# Joshua Miller Web Development::Programming Eagle Technologies Group, Inc. www.eagletgi.com [EMAIL PROTECTED] (304) 622-4499 x320 (VMail) CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential, and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us by telephone call at the number listed above. -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 9:46 AM To: CF-Talk Subject: Re: Stripping last 4 characters from string Hi, I have a variable #GetFontFamily# which displays the results Garamond.fnt How can I strip off the .fnt and only display Garamond on my page? Thanks __ 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 5 can't handle DB2 (was: Server running way too slow)
I need to figure out why CF 4.5 and a piddly server can handle our traffic whereas CF 5.0 and a powerful server cannot. Our requests were running so slow when I initially loaded CF 5 that I had to go back to CF 4.5, where it worked splendidly. Now I reinstalled CF 5 and page requests are taking way too long again. Way too long. PerfMon shows cached requests in the 100+ range (and running requests to 5 I think, which is the default setting in CFIDE - note that I have not changed these from 4.5, where the default settings worked). My conclusion is that it has something to do with CF5 and DB2. Most of our site accesses a DB2 back end but the whole site is slow. I'm connecting to DB2 via ODBC because we cannot get the native driver to work (is there a trick here! DANG!!!). I just don't see how CF can even be a factor here -- but how can it not? DB2 query processing times are fine (3 seconds), but the page comes up much later (35+ seconds). All of the relevant server settings are set to their defaults as they were with CF 4.5, though I made mods to them the first time I loaded CF 5 to no avail. Macromedia does not wish to hear from me until I fork over support $$$, which would be fine but as a govt agency we pay by voucher which can take weeks. Can someone bail me out? Thanks, Andy __ 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: Stripping last 4 characters from string
left(variable,length(Variable)-4) On Wed, 19 Dec 2001, phumes1 wrote: Hi, I have a variable #GetFontFamily# which displays the results Garamond.fnt How can I strip off the .fnt and only display Garamond on my page? Thanks __ 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: DevCon2001 CD's
Last I heard was that they were supposed to ship between the 17th and 20th. Dave Hannum hannum@ohio.To: CF-Talk [EMAIL PROTECTED] edu cc: Subject: DevCon2001 CD's 12/19/01 07:58 AM Please respond to cf-talk Anybody heard when the DevCon2001 CD's will ship. We were supposed to have them this month. Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] If your wife is having fun and you're not, you're still having a lot more fun than if you're having fun and she's not!' - Red Green __ 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: Forms and CF Code
Why would anyone need to clean cfcode? Unless you save user input to a file and cfinclude it, it will not get executed. FYI, to clean HTML and stuff, look for StripHTML on cflib.org. === 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: Jennifer Larkin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 7:14 PM To: CF-Talk Subject: RE: Forms and CF Code In addition to CF code, you may need to strip out other characters to avoid SQL hacks and such. If I can, I strip all ; # % * ' ( ) and , with REReplace or use REFind to detect the nasty ones and throw an error message, including sending an email message to me. and eliminate the functionality of CF... # can be icky if it comes up in a bad place. ( and ) missing will eliminate the functionality of a CF function. ; can be used in a query to do nasty things like execute a second SQL command in your CFQuery and drop your tables. % is a sql wildcard so a user could get more returns than you want them to. , has caused me a lot of problems when I try to dump the data to a text file. * just makes me nervous. *twitch* At 04:02 PM 12/18/01 -0700, you wrote: I wrote a simple routine that would loop through all the form elements, strip out HTML, and change single quotes to chr(97). It'd be easy enough to do something similar for cfcode - just check for the CF or specific CF functions. A simple search/replace, or regular expression can handle this. If you need it, I can dig out my routine, but it's simple enough that it can be recreated from scratch in about 30 minutes. __ 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
Session variables expiring
I thought I had this all figured out -- it works fine on sites running under CF Ver. 4.0 -- but now I realize that I don't. My session variables on a site running on an NT 4/CF 4.5 server keep expiring prematurely (it seems like after 10 or 20 minutes). The following code is in my Application.cfm file: cfapplication name=SNAMeLearning clientmanagement=Yes sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(1,0,0,0)# applicationtimeout=#CreateTimeSpan(1,0,0,0)# In CF Administrator, I have the following settings for Session Variables: Maximum: 1 0 0 0 Default: 1 0 0 0 I have tried setting this to 5 hours and it didn't work either: 0 5 0 0 I even tried removing the sessiontimeout line from the cfapplication tag so that the CF Admin defaults would kick in. No good. Application variable timeouts appear to be working fine. They are set the same way as the session variables. I am at my wits end with this. Like I said, I use the same settings on my CF 4.0 apps and they work fine. Any help would be greatly appreciated. Thanks in advance, Joe Tartaglia High Caliber Systems 212-684-5553 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Forms and CF Code
Just spotted this thread. Surely, unless the scenario referred to by Ray is encountered you should simply HTMLEditFormat() any user submitted output in order to escape any special characters. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: 19 December 2001 15:44 To: CF-Talk Subject: RE: Forms and CF Code Why would anyone need to clean cfcode? Unless you save user input to a file and cfinclude it, it will not get executed. FYI, to clean HTML and stuff, look for StripHTML on cflib.org. === 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: Jennifer Larkin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 7:14 PM To: CF-Talk Subject: RE: Forms and CF Code In addition to CF code, you may need to strip out other characters to avoid SQL hacks and such. If I can, I strip all ; # % * ' ( ) and , with REReplace or use REFind to detect the nasty ones and throw an error message, including sending an email message to me. and eliminate the functionality of CF... # can be icky if it comes up in a bad place. ( and ) missing will eliminate the functionality of a CF function. ; can be used in a query to do nasty things like execute a second SQL command in your CFQuery and drop your tables. % is a sql wildcard so a user could get more returns than you want them to. , has caused me a lot of problems when I try to dump the data to a text file. * just makes me nervous. *twitch* At 04:02 PM 12/18/01 -0700, you wrote: I wrote a simple routine that would loop through all the form elements, strip out HTML, and change single quotes to chr(97). It'd be easy enough to do something similar for cfcode - just check for the CF or specific CF functions. A simple search/replace, or regular expression can handle this. If you need it, I can dig out my routine, but it's simple enough that it can be recreated from scratch in about 30 minutes. __ 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: Forms and CF Code
Raymond Camden wrote: Why would anyone need to clean cfcode? Unless you save user input to a file and cfinclude it, it will not get executed. That is a dangerous oversimplification. Many people generate dynamic forms and loop over either form.fieldnames or the form collection to evaluate the forms that are posted back. This frequently involves the Evaluate() function. Something like: cfloop list=#form.fieldnames# index=i cfset temp = Evaluate(field) other code /cfloop In testing somebodies site I have used this to slow his site to a crawl by making a custom form with code like: form action= input type=text name=CFUSION_DBCONNECTIONS_FLUSH() /form Naturally correct scoping of variables prevents this, but sloppy use of Evaluate() and certain other functions is just as dangerous as executing user code the way you describe. Jochem PS: Safe would be not to scope functions to the form scope and use: cfloop list=#form.fieldnames# index=i cfset temp = Evaluate(form. field) other code /cfloop __ 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: Forms and CF Code
Why would anyone need to clean cfcode? Unless you save user input to a file and cfinclude it, it will not get executed. Many people generate dynamic forms and loop over either form.fieldnames or the form collection to evaluate the forms that are posted back. This frequently involves the Evaluate() function. Something like: cfloop list=#form.fieldnames# index=i cfset temp = Evaluate(field) other code /cfloop This is bad for multiple reasons. I don't deny that many people do it, but as a reminder, it's much easier, and quicker, to do: cfset temp = form[field] Furthermore, this is only an issue if you pass a _function_ as you describe below. In testing somebodies site I have used this to slow his site to a crawl by making a custom form with code like: form action= input type=text name=CFUSION_DBCONNECTIONS_FLUSH() /form Interesting. Good point. This is one more reason why we need to preach to people to NOT use evaluate to get form fields. I need to go on a crusade or something. ;) === 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 __ 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: Forms and CF Code
Raymond Camden wrote: Many people generate dynamic forms and loop over either form.fieldnames or the form collection to evaluate the forms that are posted back. This frequently involves the Evaluate() function. Something like: cfloop list=#form.fieldnames# index=i cfset temp = Evaluate(field) other code /cfloop This is bad for multiple reasons. I don't deny that many people do it, but as a reminder, it's much easier, and quicker, to do: cfset temp = form[field] It was in the old days :) But I wouldn't count on everybody updating his code, even if they updated CF version :( 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: Forms and CF Code
In my case, I do web front ends to database applications. Some of the database allows data entry from the public (mail list sign up, etc.) I can't guarantee how the database info is going to be used in the future. But even now, a good amount of the information is retrieved and displayed to a web page - some of it within EVALUATE functions. Therefore, stripping out unwanted code (javascript, cfcode, etc) is a good idea - unless I want some script kiddie messing around with my sites. On the otherhand, you are right. If you are simply collecting information from the website, and not using this info on the site itself, then the effort to strip this code becomes meaningless. I place my stripping functions in the application.cfm - so that every page I code is automagically protected from the script kiddies, without me having to worry about it on every page I write. (My functions loop through the Query parameters, and the form elements - guess I should include cookies in there too.) My two cents worth. Shawn Grover -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: 19 December 2001 15:44 To: CF-Talk Subject: RE: Forms and CF Code Why would anyone need to clean cfcode? Unless you save user input to a file and cfinclude it, it will not get executed. FYI, to clean HTML and stuff, look for StripHTML on cflib.org. === 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: Jennifer Larkin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 7:14 PM To: CF-Talk Subject: RE: Forms and CF Code In addition to CF code, you may need to strip out other characters to avoid SQL hacks and such. If I can, I strip all ; # % * ' ( ) and , with REReplace or use REFind to detect the nasty ones and throw an error message, including sending an email message to me. and eliminate the functionality of CF... # can be icky if it comes up in a bad place. ( and ) missing will eliminate the functionality of a CF function. ; can be used in a query to do nasty things like execute a second SQL command in your CFQuery and drop your tables. % is a sql wildcard so a user could get more returns than you want them to. , has caused me a lot of problems when I try to dump the data to a text file. * just makes me nervous. *twitch* At 04:02 PM 12/18/01 -0700, you wrote: I wrote a simple routine that would loop through all the form elements, strip out HTML, and change single quotes to chr(97). It'd be easy enough to do something similar for cfcode - just check for the CF or specific CF functions. A simple search/replace, or regular expression can handle this. If you need it, I can dig out my routine, but it's simple enough that it can be recreated from scratch in about 30 minutes. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT was wondering if any Javascript guru's could give me a hand with this code
Hello, sorry for the OT but only place I actually get some answers to my questions. I was wondering if somebody code point me in the right direction why this form Validation won't work in NS6 it works great in IE. in NS6 all it does is submit the form and no validation happens. I have tested the function with out the credit card info in it and works and I also tested the credit card info by it self and that works fine but with them combined it doesn't work. here is the code if you want to take a look hopefully someone can point me in the right direction. SCRIPT LANGUAGE=JavaScript !-- Begin function checkFields() { missinginfo = ; FormVar = document.getElementById(JoinForm); var Cards = new makeArray(8); Cards[0] = new CardType(MasterCard, 51,52,53,54,55, 16); var MasterCard = Cards[0]; Cards[1] = new CardType(VisaCard, 4, 13,16); var VisaCard = Cards[1]; Cards[2] = new CardType(AmExCard, 34,37, 15); var AmExCard = Cards[2]; Cards[3] = new CardType(DinersClubCard, 30,36,38, 14); var DinersClubCard = Cards[3]; Cards[4] = new CardType(DiscoverCard, 6011, 16); var DiscoverCard = Cards[4]; Cards[5] = new CardType(enRouteCard, 2014,2149, 15); var enRouteCard = Cards[5]; Cards[6] = new CardType(JCBCard, 3088,3096,3112,3158,3337,3528, 16); var JCBCard = Cards[6]; var LuhnCheckSum = Cards[7] = new CardType(); var tmpyear; if ((FormVar.CardNumber.value.length == 0) || (FormVar.CardNumber.value.Length 16)) { missinginfo += \n - Please enter a Card Number.; } if (FormVar.ExpYear.value.length == 4) tmpyear = FormVar.ExpYear.value; else { missinginfo += \n - The Expiration Year is not valid.; } tmpmonth = FormVar.ExpMon.options[FormVar.ExpMon.selectedIndex].value; // The following line doesn't work in IE3, you need to change it // to something like (new CardType()) // if (!CardType().isExpiryDate(tmpyear, tmpmonth)) { if (!(new CardType()).isExpiryDate(tmpyear, tmpmonth)) { missinginfo += \n - This card has already expired.; } card = FormVar.CardType.options[FormVar.CardType.selectedIndex].value; var retval = eval(card + .checkCardNumber(\ + FormVar.CardNumber.value + \, + tmpyear + , + tmpmonth + );); cardname = ; if (retval) // comment this out if used on an order form /* missinginfo += \n - This card number appears to be valid.; */; else { // The cardnumber has the valid luhn checksum, but we want to know which // cardtype it belongs to. for (var n = 0; n Cards.size; n++) { if (Cards[n].checkCardNumber(JoinForm.CardNumber.value, tmpyear, tmpmonth)) { cardname = Cards[n].getCardType(); break; } } if (cardname.length 0) { missinginfo += \n - This looks like a + cardname + number, not a + card + number.; } } / *\ Object CardType([String cardtype, String rules, String len, int year, int month]) cardtype: type of card, eg: MasterCard, Visa, etc. rules : rules of the cardnumber, eg: 4, 6011, 34,37. len : valid length of cardnumber, eg: 16,19, 13,16. year: year of expiry date. month : month of expiry date. eg: var VisaCard = new CardType(Visa, 4, 16); var AmExCard = new CardType(AmEx, 34,37, 15); \ */ function CardType() { var n; var argv = CardType.arguments; var argc = CardType.arguments.length; this.objname = object CardType; var tmpcardtype = (argc 0) ? argv[0] : CardObject; var tmprules = (argc 1) ? argv[1] : 0,1,2,3,4,5,6,7,8,9; var tmplen = (argc 2) ? argv[2] : 13,14,15,16,19; this.setCardNumber = setCardNumber; // set CardNumber method. this.setCardType = setCardType; // setCardType method. this.setLen = setLen; // setLen method. this.setRules = setRules; // setRules method. this.setExpiryDate = setExpiryDate; // setExpiryDate method. this.setCardType(tmpcardtype); this.setLen(tmplen); this.setRules(tmprules); if (argc 4) this.setExpiryDate(argv[3], argv[4]); this.checkCardNumber = checkCardNumber; // checkCardNumber method. this.getExpiryDate = getExpiryDate; // getExpiryDate method. this.getCardType = getCardType; // getCardType method. this.isCardNumber = isCardNumber; // isCardNumber method. this.isExpiryDate = isExpiryDate; // isExpiryDate method. this.luhnCheck = luhnCheck;// luhnCheck method. return this; } / *\ boolean checkCardNumber([String cardnumber, int year, int month]) return true if cardnumber pass the luhncheck and the expiry date is valid, else return false. \ */ function checkCardNumber() { var argv = checkCardNumber.arguments; var argc = checkCardNumber.arguments.length; var cardnumber = (argc 0) ? argv[0] : this.cardnumber; var year = (argc 1) ? argv[1] : this.year; var month = (argc 2) ? argv[2] : this.month; this.setCardNumber(cardnumber);
Re: Stripping last 4 characters from string
ListGetAt(GetFontFamily,1,'.') I have a variable #GetFontFamily# which displays the results Garamond.fnt How can I strip off the .fnt and only display Garamond on my page? Thanks __ 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: Forms and CF Code
Shawn Grover wrote: I place my stripping functions in the application.cfm - so that every page I code is automagically protected from the script kiddies, without me having to worry about it on every page I write. (My functions loop through the Query parameters, and the form elements - guess I should include cookies in there too.) How do you prevent your functions from stripping characters from uploaded files? Jochem __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Attacks (was Forms and CF Code)
Don't forget the SQL attacks - similar to the type of attack we've been discussing, but not addressed thus far. Something like this: cfquery name=myQuery datasource=MyDSN Select * From MyTable Where SomeField = #Form.SomeField# /cfquery now if Form.SomeField were b'; use dbname; drop table tablename; --' then The original query would get executed with 'b' as the filter, but then standard SQL commands are issued. The --' ensures that anything following this point is treated as a comment. try it out on one of YOUR sites - except maybe replace the drop table statement with a select or something... Protect against this by using stored procedures where possible and/or doing some sort of filter. The preservesinglequotes might help with this too, not sure. No, I'm not revealing anything new here - I learned the details of this at the MS PDC conference in LA, and know I've seen reference to the issue on the list a few times. Here's hoping that mentioning it here helps improve some sites. Shawn Grover -Original Message- This is bad for multiple reasons. I don't deny that many people do it, but as a reminder, it's much easier, and quicker, to do: cfset temp = form[field] Furthermore, this is only an issue if you pass a _function_ as you describe below. In testing somebodies site I have used this to slow his site to a crawl by making a custom form with code like: form action= input type=text name=CFUSION_DBCONNECTIONS_FLUSH() /form Interesting. Good point. This is one more reason why we need to preach to people to NOT use evaluate to get form fields. I need to go on a crusade or something. ;) === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Attacks (was Forms and CF Code)
I have a page up which discusses this http://www.vawter.com/urlhack.cfm - Original Message - From: Shawn Grover [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 9:32 AM Subject: RE: SQL Attacks (was Forms and CF Code) Don't forget the SQL attacks - similar to the type of attack we've been discussing, but not addressed thus far. Something like this: cfquery name=myQuery datasource=MyDSN Select * From MyTable Where SomeField = #Form.SomeField# /cfquery now if Form.SomeField were b'; use dbname; drop table tablename; --' then The original query would get executed with 'b' as the filter, but then standard SQL commands are issued. The --' ensures that anything following this point is treated as a comment. try it out on one of YOUR sites - except maybe replace the drop table statement with a select or something... Protect against this by using stored procedures where possible and/or doing some sort of filter. The preservesinglequotes might help with this too, not sure. No, I'm not revealing anything new here - I learned the details of this at the MS PDC conference in LA, and know I've seen reference to the issue on the list a few times. Here's hoping that mentioning it here helps improve some sites. Shawn Grover -Original Message- This is bad for multiple reasons. I don't deny that many people do it, but as a reminder, it's much easier, and quicker, to do: cfset temp = form[field] Furthermore, this is only an issue if you pass a _function_ as you describe below. In testing somebodies site I have used this to slow his site to a crawl by making a custom form with code like: form action= input type=text name=CFUSION_DBCONNECTIONS_FLUSH() /form Interesting. Good point. This is one more reason why we need to preach to people to NOT use evaluate to get form fields. I need to go on a crusade or something. ;) === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Forms and CF Code
I haven't had to deal with that particular case yet. I do have an app that uploads files, but it's an internal app and the requirements doc did not call for that level of security. Good point though... I'll have to dwell on it for a while... :) -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 9:32 AM To: CF-Talk Subject: Re: Forms and CF Code Shawn Grover wrote: I place my stripping functions in the application.cfm - so that every page I code is automagically protected from the script kiddies, without me having to worry about it on every page I write. (My functions loop through the Query parameters, and the form elements - guess I should include cookies in there too.) How do you prevent your functions from stripping characters from uploaded files? Jochem __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF 5 can't handle DB2 (was: Server running way too slow)
I assume that you have all of the shared variables locked? Whereas you could more or less get away with this in prior version, CF5 is very picky about it. --- Billy Cravens - Original Message - From: Andrew Peterson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 9:07 AM Subject: CF 5 can't handle DB2 (was: Server running way too slow) I need to figure out why CF 4.5 and a piddly server can handle our traffic whereas CF 5.0 and a powerful server cannot. Our requests were running so slow when I initially loaded CF 5 that I had to go back to CF 4.5, where it worked splendidly. Now I reinstalled CF 5 and page requests are taking way too long again. Way too long. PerfMon shows cached requests in the 100+ range (and running requests to 5 I think, which is the default setting in CFIDE - note that I have not changed these from 4.5, where the default settings worked). My conclusion is that it has something to do with CF5 and DB2. Most of our site accesses a DB2 back end but the whole site is slow. I'm connecting to DB2 via ODBC because we cannot get the native driver to work (is there a trick here! DANG!!!). I just don't see how CF can even be a factor here -- but how can it not? DB2 query processing times are fine (3 seconds), but the page comes up much later (35+ seconds). All of the relevant server settings are set to their defaults as they were with CF 4.5, though I made mods to them the first time I loaded CF 5 to no avail. Macromedia does not wish to hear from me until I fork over support $$$, which would be fine but as a govt agency we pay by voucher which can take weeks. Can someone bail me out? Thanks, Andy __ 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: OT was wondering if any Javascript guru's could give me a hand with this code
I suppose you have type javascript: (hard to see colon) in the address bar and verified there are no errors? - Original Message - From: Troy Montour [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 9:31 AM Subject: OT was wondering if any Javascript guru's could give me a hand with this code Hello, sorry for the OT but only place I actually get some answers to my questions. I was wondering if somebody code point me in the right direction why this form Validation won't work in NS6 it works great in IE. in NS6 all it does is submit the form and no validation happens. I have tested the function with out the credit card info in it and works and I also tested the credit card info by it self and that works fine but with them combined it doesn't work. here is the code if you want to take a look hopefully someone can point me in the right direction. SCRIPT LANGUAGE=JavaScript !-- Begin function checkFields() { missinginfo = ; FormVar = document.getElementById(JoinForm); var Cards = new makeArray(8); Cards[0] = new CardType(MasterCard, 51,52,53,54,55, 16); var MasterCard = Cards[0]; Cards[1] = new CardType(VisaCard, 4, 13,16); var VisaCard = Cards[1]; Cards[2] = new CardType(AmExCard, 34,37, 15); var AmExCard = Cards[2]; Cards[3] = new CardType(DinersClubCard, 30,36,38, 14); var DinersClubCard = Cards[3]; Cards[4] = new CardType(DiscoverCard, 6011, 16); var DiscoverCard = Cards[4]; Cards[5] = new CardType(enRouteCard, 2014,2149, 15); var enRouteCard = Cards[5]; Cards[6] = new CardType(JCBCard, 3088,3096,3112,3158,3337,3528, 16); var JCBCard = Cards[6]; var LuhnCheckSum = Cards[7] = new CardType(); var tmpyear; if ((FormVar.CardNumber.value.length == 0) || (FormVar.CardNumber.value.Length 16)) { missinginfo += \n - Please enter a Card Number.; } if (FormVar.ExpYear.value.length == 4) tmpyear = FormVar.ExpYear.value; else { missinginfo += \n - The Expiration Year is not valid.; } tmpmonth = FormVar.ExpMon.options[FormVar.ExpMon.selectedIndex].value; // The following line doesn't work in IE3, you need to change it // to something like (new CardType()) // if (!CardType().isExpiryDate(tmpyear, tmpmonth)) { if (!(new CardType()).isExpiryDate(tmpyear, tmpmonth)) { missinginfo += \n - This card has already expired.; } card = FormVar.CardType.options[FormVar.CardType.selectedIndex].value; var retval = eval(card + .checkCardNumber(\ + FormVar.CardNumber.value + \, + tmpyear + , + tmpmonth + );); cardname = ; if (retval) // comment this out if used on an order form /* missinginfo += \n - This card number appears to be valid.; */; else { // The cardnumber has the valid luhn checksum, but we want to know which // cardtype it belongs to. for (var n = 0; n Cards.size; n++) { if (Cards[n].checkCardNumber(JoinForm.CardNumber.value, tmpyear, tmpmonth)) { cardname = Cards[n].getCardType(); break; } } if (cardname.length 0) { missinginfo += \n - This looks like a + cardname + number, not a + card + number.; } } / *\ Object CardType([String cardtype, String rules, String len, int year, int month]) cardtype: type of card, eg: MasterCard, Visa, etc. rules : rules of the cardnumber, eg: 4, 6011, 34,37. len : valid length of cardnumber, eg: 16,19, 13,16. year: year of expiry date. month : month of expiry date. eg: var VisaCard = new CardType(Visa, 4, 16); var AmExCard = new CardType(AmEx, 34,37, 15); \ */ function CardType() { var n; var argv = CardType.arguments; var argc = CardType.arguments.length; this.objname = object CardType; var tmpcardtype = (argc 0) ? argv[0] : CardObject; var tmprules = (argc 1) ? argv[1] : 0,1,2,3,4,5,6,7,8,9; var tmplen = (argc 2) ? argv[2] : 13,14,15,16,19; this.setCardNumber = setCardNumber; // set CardNumber method. this.setCardType = setCardType; // setCardType method. this.setLen = setLen; // setLen method. this.setRules = setRules; // setRules method. this.setExpiryDate = setExpiryDate; // setExpiryDate method. this.setCardType(tmpcardtype); this.setLen(tmplen); this.setRules(tmprules); if (argc 4) this.setExpiryDate(argv[3], argv[4]); this.checkCardNumber = checkCardNumber; // checkCardNumber method. this.getExpiryDate = getExpiryDate; // getExpiryDate method. this.getCardType = getCardType; // getCardType method. this.isCardNumber = isCardNumber; // isCardNumber method. this.isExpiryDate = isExpiryDate; // isExpiryDate method. this.luhnCheck = luhnCheck;// luhnCheck method. return this; } / *\ boolean checkCardNumber([String cardnumber, int year, int month]) return true if cardnumber
Report Utilities
We have serveral clients requesting the ability to print preformated forms. The same data is used but the printer and form variations are amost impossible to consider. Are there any good quality com objects, other pluggins available to allow remote printing of reports and forms? We're cosidering a CF to PDF tag, Crystal ( Seagate ) Reports or attempting to interface with Access's reporting facility. it anyone has any suggestions, they'd be greatly appreciated. Thanks. Douglas __ 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: OT was wondering if any Javascript guru's could give me a hand with this code
That's a whole lotta code. Have you tried placing alerts at different points to see where it breaks? In order to figure out where your code is breaking, someone would have to either read all of your code, or recreate your form, since you didn't include the HTML. I doubt anyone will do either. Also, have you tested the code with older IE browsers? (4,5,5.5) I'm just curious why you are using document.getElementById - as far as I know, document.formName seems to work in all browsers. --- Billy Cravens - Original Message - From: Troy Montour [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 10:31 AM Subject: OT was wondering if any Javascript guru's could give me a hand with this code Hello, sorry for the OT but only place I actually get some answers to my questions. I was wondering if somebody code point me in the right direction why this form Validation won't work in NS6 it works great in IE. in NS6 all it does is submit the form and no validation happens. I have tested the function with out the credit card info in it and works and I also tested the credit card info by it self and that works fine but with them combined it doesn't work. here is the code if you want to take a look hopefully someone can point me in the right direction. SCRIPT LANGUAGE=JavaScript !-- Begin function checkFields() { missinginfo = ; FormVar = document.getElementById(JoinForm); var Cards = new makeArray(8); Cards[0] = new CardType(MasterCard, 51,52,53,54,55, 16); var MasterCard = Cards[0]; Cards[1] = new CardType(VisaCard, 4, 13,16); var VisaCard = Cards[1]; Cards[2] = new CardType(AmExCard, 34,37, 15); var AmExCard = Cards[2]; Cards[3] = new CardType(DinersClubCard, 30,36,38, 14); var DinersClubCard = Cards[3]; Cards[4] = new CardType(DiscoverCard, 6011, 16); var DiscoverCard = Cards[4]; Cards[5] = new CardType(enRouteCard, 2014,2149, 15); var enRouteCard = Cards[5]; Cards[6] = new CardType(JCBCard, 3088,3096,3112,3158,3337,3528, 16); var JCBCard = Cards[6]; var LuhnCheckSum = Cards[7] = new CardType(); var tmpyear; if ((FormVar.CardNumber.value.length == 0) || (FormVar.CardNumber.value.Length 16)) { missinginfo += \n - Please enter a Card Number.; } if (FormVar.ExpYear.value.length == 4) tmpyear = FormVar.ExpYear.value; else { missinginfo += \n - The Expiration Year is not valid.; } tmpmonth = FormVar.ExpMon.options[FormVar.ExpMon.selectedIndex].value; // The following line doesn't work in IE3, you need to change it // to something like (new CardType()) // if (!CardType().isExpiryDate(tmpyear, tmpmonth)) { if (!(new CardType()).isExpiryDate(tmpyear, tmpmonth)) { missinginfo += \n - This card has already expired.; } card = FormVar.CardType.options[FormVar.CardType.selectedIndex].value; var retval = eval(card + .checkCardNumber(\ + FormVar.CardNumber.value + \, + tmpyear + , + tmpmonth + );); cardname = ; if (retval) // comment this out if used on an order form /* missinginfo += \n - This card number appears to be valid.; */; else { // The cardnumber has the valid luhn checksum, but we want to know which // cardtype it belongs to. for (var n = 0; n Cards.size; n++) { if (Cards[n].checkCardNumber(JoinForm.CardNumber.value, tmpyear, tmpmonth)) { cardname = Cards[n].getCardType(); break; } } if (cardname.length 0) { missinginfo += \n - This looks like a + cardname + number, not a + card + number.; } } / *\ Object CardType([String cardtype, String rules, String len, int year, int month]) cardtype: type of card, eg: MasterCard, Visa, etc. rules : rules of the cardnumber, eg: 4, 6011, 34,37. len : valid length of cardnumber, eg: 16,19, 13,16. year: year of expiry date. month : month of expiry date. eg: var VisaCard = new CardType(Visa, 4, 16); var AmExCard = new CardType(AmEx, 34,37, 15); \ */ function CardType() { var n; var argv = CardType.arguments; var argc = CardType.arguments.length; this.objname = object CardType; var tmpcardtype = (argc 0) ? argv[0] : CardObject; var tmprules = (argc 1) ? argv[1] : 0,1,2,3,4,5,6,7,8,9; var tmplen = (argc 2) ? argv[2] : 13,14,15,16,19; this.setCardNumber = setCardNumber; // set CardNumber method. this.setCardType = setCardType; // setCardType method. this.setLen = setLen; // setLen method. this.setRules = setRules; // setRules method. this.setExpiryDate = setExpiryDate; // setExpiryDate method. this.setCardType(tmpcardtype); this.setLen(tmplen); this.setRules(tmprules); if (argc 4) this.setExpiryDate(argv[3], argv[4]); this.checkCardNumber = checkCardNumber; // checkCardNumber method. this.getExpiryDate = getExpiryDate; // getExpiryDate method.
Re: Report Utilities
You might want to check out ActivePDF (www.activepdf.com) Plays well with CF. Chuck Rodgers At 11:45 AM 12/19/01 -0500, you wrote: We have serveral clients requesting the ability to print preformated forms. The same data is used but the printer and form variations are amost impossible to consider. Are there any good quality com objects, other pluggins available to allow remote printing of reports and forms? We're cosidering a CF to PDF tag, Crystal ( Seagate ) Reports or attempting to interface with Access's reporting facility. it anyone has any suggestions, they'd be greatly appreciated. Thanks. Douglas __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Re: Report Utilities
Also checkout www.pdflib.com for some great stuff. /Robert [EMAIL PROTECTED] wrote: You might want to check out ActivePDF (www.activepdf.com) Plays well with CF. Chuck Rodgers At 11:45 AM 12/19/01 -0500, you wrote: We have serveral clients requesting the ability to print preformated forms. The same data is used but the printer and form variations are amost impossible to consider. Are there any good quality com objects, other pluggins available to allow remote printing of reports and forms? We're cosidering a CF to PDF tag, Crystal ( Seagate ) Reports or attempting to interface with Access's reporting facility. it anyone has any suggestions, they'd be greatly appreciated. Thanks. Douglas __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Error displaying Text Fields
I am having trouble displaying a text field in a form textarea box. The only thing that is displayed after running a simple SELECT query is the Long Text string of text. This only happens on certain rows of data. I am using SQL Server 2000. Has anyone seen this problem before?? Is there a solution for it?? __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: VNC vs PC Anywhere
Has anyone had any experience using VNC from ATT - it seems reasonably good (and free) at first glance. Anything I should be aware of if we were to use it on a production box? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Cache test
As many of you have noticed, I have dynamic banner ads and list information at the bottom of all list posts. Normally, this information is cached using a CFQUERY with a cachedwithin attribute set to 1 (which means 1 day). In order to test a new ad, I removed the cachedwithin attribute and all worked ok. When I placed it back in (without restarting the CF server) the old cached information was used rather than the newer. Has anyone seen anything similar in CF 5? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: VNC vs PC Anywhere
We use both, however I prefer VNC over PCA for remote control. It's lightweight and you can even hit your VNC Server using a web browser. Chris -Original Message- From: Ben Whalley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 12:15 PM To: CF-Talk Subject: OT: VNC vs PC Anywhere Has anyone had any experience using VNC from ATT - it seems reasonably good (and free) at first glance. Anything I should be aware of if we were to use it on a production box? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF 5 can't handle DB2 (was: Server running way too slow)
We are running a very large app here with CF5.0 and DB2 with no issues at all re performance. The Shared Variables issue is huge if not done properly, here are some cost-effective ideas, if I am repeating ones suggested I apologize. Go into CF Admin and turn on all debugging options if possible enter specific IP's so only these few the exploded benchmarking debug output. Check and re check for which files are slowing things down and look closely at the slow running pages, check for any Application, Server or Session scoped variable reads and writes. Look at your ColdFusion logs, particularly Application and Server, if they are huge don't despair. Look for any messages with thread, threading and/or unresponsive in them and hunt down the .cfm pages shown to contain these words, again look for unlocked Application, Server or Session scoped variables. I hope this helps. Mike Brunt Sempra Energy 213.244.5226 For every action, there is an equal and opposite malfunction. -Original Message- From: BILLY CRAVENS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 8:20 AM To: CF-Talk Subject: Re: CF 5 can't handle DB2 (was: Server running way too slow) I assume that you have all of the shared variables locked? Whereas you could more or less get away with this in prior version, CF5 is very picky about it. --- Billy Cravens - Original Message - From: Andrew Peterson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 9:07 AM Subject: CF 5 can't handle DB2 (was: Server running way too slow) I need to figure out why CF 4.5 and a piddly server can handle our traffic whereas CF 5.0 and a powerful server cannot. Our requests were running so slow when I initially loaded CF 5 that I had to go back to CF 4.5, where it worked splendidly. Now I reinstalled CF 5 and page requests are taking way too long again. Way too long. PerfMon shows cached requests in the 100+ range (and running requests to 5 I think, which is the default setting in CFIDE - note that I have not changed these from 4.5, where the default settings worked). My conclusion is that it has something to do with CF5 and DB2. Most of our site accesses a DB2 back end but the whole site is slow. I'm connecting to DB2 via ODBC because we cannot get the native driver to work (is there a trick here! DANG!!!). I just don't see how CF can even be a factor here -- but how can it not? DB2 query processing times are fine (3 seconds), but the page comes up much later (35+ seconds). All of the relevant server settings are set to their defaults as they were with CF 4.5, though I made mods to them the first time I loaded CF 5 to no avail. Macromedia does not wish to hear from me until I fork over support $$$, which would be fine but as a govt agency we pay by voucher which can take weeks. Can someone bail me out? Thanks, Andy __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: VNC vs PC Anywhere
Ben Whalley wrote: Has anyone had any experience using VNC from ATT - it seems reasonably good (and free) at first glance. Anything I should be aware of if we were to use it on a production box? Last time I looked it only encrypted the login process and not the entire session. Jochem __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: VNC vs PC Anywhere
vnc for the web stuff gets my vote. Alexander Sicular Chief Technology Architect Neurological Institute of New York Columbia University as867 {at} columbia [dot] edu -Original Message- From: Ben Whalley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 12:15 PM To: CF-Talk Subject: OT: VNC vs PC Anywhere Has anyone had any experience using VNC from ATT - it seems reasonably good (and free) at first glance. Anything I should be aware of if we were to use it on a production box? __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT was wondering if any Javascript guru's could give me a hand with this code
I could include the form no problem on that. I had it with document.formname but was trying to see if that was causing my NS problem which it didn't help anything. and yes I have tested it with IE 3 and it works good but with NS it just basically submits the form with no error. here is the html code FORM id=JoinForm NAME=JoinForm ENCTYPE=multipart/form-data ACTION=test3.cfm METHOD=POST onSubmit=return checkFields(); input type=hidden name=MailDomain value=troy.com TABLE ID=Table6 BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=100% TR VALIGN=TOP TD WIDTH=757 HEIGHT=415 P TABLE WIDTH=751 BORDER=0 CELLSPACING=0 CELLPADDING=0 ALIGN=LEFT NOF=TE TR TD TABLE ID=Table11 BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=100% COLGROUP COL WIDTH=24 COL WIDTH=179 COL WIDTH=259 COL WIDTH=289 /COLGROUP TR TD WIDTH=24 BGCOLOR=#006699 Pnbsp;/P /TD TD WIDTH=179 BGCOLOR=#006699 PBFONT COLOR=#FF SIZE=-1Private Information/FONT/B/P /TD TD COLSPAN=2 BGCOLOR=#006699 Pnbsp;/P /TD /TR TR TD WIDTH=24 Pnbsp;/P /TD TD WIDTH=179 Pnbsp;/P /TD TD COLSPAN=2 Pnbsp;/P /TD /TR TR TD WIDTH=24 PBFONT FACE=Arial,Helvetica,Univers,Zurich BT,sans-serif SIZE=-11./FONT/B/P /TD TD WIDTH=179 PBFONT COLOR=#FF SIZE=-1 FACE=Abadi MT Condensed Light,sans-serif*/FONTFONT FACE=Arial,Helvetica,Univers,Zurich BT,sans-serif SIZE=-1First Name:/FONT/B/P /TD TD COLSPAN=2 PINPUT ID=Forms Edit Field1 TYPE=TEXT NAME=First_Name VALUE= SIZE=40 MAXLENGTH=50/TD /TR TR TD WIDTH=24 PBFONT FACE=Arial,Helvetica,Univers,Zurich BT,sans-serif SIZE=-12./FONT/B/P /TD TD WIDTH=179 PBFONT COLOR=#FF SIZE=-1 FACE=Abadi MT Condensed Light,sans-serif*/FONTFONT FACE=Arial,Helvetica,Univers,Zurich BT,sans-serif SIZE=-1Last Name:/FONT/B/P /TD TD COLSPAN=2 PINPUT ID=FormsEditField4 TYPE=TEXT NAME=Last_Name VALUE= SIZE=40 MAXLENGTH=50/TD /TR TR TD WIDTH=24 PBFONT FACE=Arial,Helvetica,Univers,Zurich BT,sans-serif
Re: VNC vs PC Anywhere
On Windows 2000, terminal services is the way to go unless you need access from a browser. Jim - Original Message - From: Ben Whalley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 10:15 AM Subject: OT: VNC vs PC Anywhere Has anyone had any experience using VNC from ATT - it seems reasonably good (and free) at first glance. Anything I should be aware of if we were to use it on a production box? __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: VNC vs PC Anywhere
You can encrypt the entire session using SSH. Read the documenation at http://www.uk.research.att.com/vnc/sshvnc.html Chris -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 12:22 PM To: CF-Talk Subject: Re: OT: VNC vs PC Anywhere Ben Whalley wrote: Has anyone had any experience using VNC from ATT - it seems reasonably good (and free) at first glance. Anything I should be aware of if we were to use it on a production box? Last time I looked it only encrypted the login process and not the entire session. Jochem __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFGrid does not show up in CF50 even after the HotFix is applied
I have CF50 set up on a Win2000 server and can not see any of my templates that use CFGrid. I have downloaded and replaced the new jar file from Allaire and still cn not get these to load. Any insight would be greatly appreciated. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: VNC vs PC Anywhere
I'd say VNC unless it's a Windows 2000 box. If it's Windows 2000, use Terminal Services. --- Billy Cravens - Original Message - From: Ben Whalley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 11:15 AM Subject: OT: VNC vs PC Anywhere Has anyone had any experience using VNC from ATT - it seems reasonably good (and free) at first glance. Anything I should be aware of if we were to use it on a production box? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: VNC vs PC Anywhere
Another advantage to VNC is that the client is small enough to fit on a floppy disk. I keep a copy in one of mail folders and can grab it whenever I'm off site. Chris -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 12:24 PM To: CF-Talk Subject: Re: VNC vs PC Anywhere On Windows 2000, terminal services is the way to go unless you need access from a browser. Jim - Original Message - From: Ben Whalley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 10:15 AM Subject: OT: VNC vs PC Anywhere Has anyone had any experience using VNC from ATT - it seems reasonably good (and free) at first glance. Anything I should be aware of if we were to use it on a production box? __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: VNC vs PC Anywhere
Actually, there's an activeX control for that as well... -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 9:24 AM To: CF-Talk Subject: Re: VNC vs PC Anywhere On Windows 2000, terminal services is the way to go unless you need access from a browser. Jim - Original Message - From: Ben Whalley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 10:15 AM Subject: OT: VNC vs PC Anywhere Has anyone had any experience using VNC from ATT - it seems reasonably good (and free) at first glance. Anything I should be aware of if we were to use it on a production box? __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: VNC vs PC Anywhere
You can actually access it from a browser (ActiveX control): http://www.microsoft.com/windows2000/downloads/recommended/TSAC/default.asp --- Billy Cravens - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 11:24 AM Subject: Re: VNC vs PC Anywhere On Windows 2000, terminal services is the way to go unless you need access from a browser. Jim - Original Message - From: Ben Whalley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 10:15 AM Subject: OT: VNC vs PC Anywhere Has anyone had any experience using VNC from ATT - it seems reasonably good (and free) at first glance. Anything I should be aware of if we were to use it on a production box? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: VNC vs PC Anywhere
Zvnv is worth a look It encapsulates zebedee technology... http://people.we.mediaone.net/ddyer/znc/zvnc.html Ian -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: 19 December 2001 17:22 To: CF-Talk Subject: Re: OT: VNC vs PC Anywhere Ben Whalley wrote: Has anyone had any experience using VNC from ATT - it seems reasonably good (and free) at first glance. Anything I should be aware of if we were to use it on a production box? Last time I looked it only encrypted the login process and not the entire session. Jochem __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup FAQ: http://www.thenetprofits.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 Attacks (was Forms and CF Code)
One should use parameterised SQL to get around that For example: cfquery name=myQuery datasource=MyDSN Select * From MyTable Where SomeField = cfqueryparam cfsqltype=cf_sql_varchar value=#Form.SomeField# /cfquery -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: 19 December 2001 16:38 To: CF-Talk Subject: Re: SQL Attacks (was Forms and CF Code) I have a page up which discusses this http://www.vawter.com/urlhack.cfm - Original Message - From: Shawn Grover [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 9:32 AM Subject: RE: SQL Attacks (was Forms and CF Code) Don't forget the SQL attacks - similar to the type of attack we've been discussing, but not addressed thus far. Something like this: cfquery name=myQuery datasource=MyDSN Select * From MyTable Where SomeField = #Form.SomeField# /cfquery now if Form.SomeField were b'; use dbname; drop table tablename; --' then The original query would get executed with 'b' as the filter, but then standard SQL commands are issued. The --' ensures that anything following this point is treated as a comment. try it out on one of YOUR sites - except maybe replace the drop table statement with a select or something... Protect against this by using stored procedures where possible and/or doing some sort of filter. The preservesinglequotes might help with this too, not sure. No, I'm not revealing anything new here - I learned the details of this at the MS PDC conference in LA, and know I've seen reference to the issue on the list a few times. Here's hoping that mentioning it here helps improve some sites. Shawn Grover -Original Message- This is bad for multiple reasons. I don't deny that many people do it, but as a reminder, it's much easier, and quicker, to do: cfset temp = form[field] Furthermore, this is only an issue if you pass a _function_ as you describe below. In testing somebodies site I have used this to slow his site to a crawl by making a custom form with code like: form action= input type=text name=CFUSION_DBCONNECTIONS_FLUSH() /form Interesting. Good point. This is one more reason why we need to preach to people to NOT use evaluate to get form fields. I need to go on a crusade or something. ;) === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Report Utilities
PDF is the way to go. If the format of the form is static (and only the data changes) look at using FDF; otherwise, I'd recommend something like ActivePDF (though I've heard some that HTMLDoc, a freeware EXE, works pretty good too) --- Billy Cravens - Original Message - From: Douglas Lamb [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 10:45 AM Subject: Report Utilities We have serveral clients requesting the ability to print preformated forms. The same data is used but the printer and form variations are amost impossible to consider. Are there any good quality com objects, other pluggins available to allow remote printing of reports and forms? We're cosidering a CF to PDF tag, Crystal ( Seagate ) Reports or attempting to interface with Access's reporting facility. it anyone has any suggestions, they'd be greatly appreciated. Thanks. Douglas __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: VNC vs PC Anywhere
VNC is nice, we use it on most boxes at school since they don't give keys to us students for the server room :-) We used to use PCAnywhere but that was shortlived. Mike -Original Message- From: Ben Whalley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 12:15 PM To: CF-Talk Subject: OT: VNC vs PC Anywhere Has anyone had any experience using VNC from ATT - it seems reasonably good (and free) at first glance. Anything I should be aware of if we were to use it on a production box? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: VNC vs PC Anywhere
Folks, I've got to tell you that Remote Administrator ($35 from Famatech.com) is fantastic. Best for the money I've found anywhere. (An d I'm as big a Symantec fan as there is). A single license covers two computers. FWIW, Dave - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 12:21 PM Subject: Re: OT: VNC vs PC Anywhere Ben Whalley wrote: Has anyone had any experience using VNC from ATT - it seems reasonably good (and free) at first glance. Anything I should be aware of if we were to use it on a production box? Last time I looked it only encrypted the login process and not the entire session. Jochem __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Exporting data to Excel
In CFDJ this month, there was a really good article about using Internet Queries in Excel... You could consider doing an import instead... Or, if you're using SQL Server, consider creating a DTS package that will do the export for you. I've got a package that runs through DTS that works pretty well... Alternatively, you can use the COM object. Check out what's on www.cfcomet.com -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 1:08 PM To: CF-Talk Subject: Exporting data to Excel I've used Excel datasources in the past, but simply reading data from them. Now, I'd like to be able to export data to an Excel spreadsheet. I'm not sure what the best approach to doing this might be. My biggest concerns are concurrency issues. I suspect I may run into problems dealing with OS-imposed file locks as well. The first problem that I'm running into is: I have an Excel datasource that points to an Excel file. If that single file is to be used for the data output, then I need to clear the file each time before beginning the export process. The ODBC driver is saying that DELETE FROM is unsupported. Any advice appreciated, Jim __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: VNC vs PC Anywhere
With vnc you can also use IP based rules to allow/disallow connection. -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: 19 December 2001 17:40 To: CF-Talk Subject: RE: VNC vs PC Anywhere VNC is nice, we use it on most boxes at school since they don't give keys to us students for the server room :-) We used to use PCAnywhere but that was shortlived. Mike -Original Message- From: Ben Whalley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 12:15 PM To: CF-Talk Subject: OT: VNC vs PC Anywhere Has anyone had any experience using VNC from ATT - it seems reasonably good (and free) at first glance. Anything I should be aware of if we were to use it on a production box? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Could you give my application a once through
The deterant for SQL attacks is the CFQUERYPARAM tag. Anytime a user defined data (FORM or URL) is accessed inside CFQUERY and you're not using it, you're pushing your luck. It is also much simpler to use CFQUERYPARAM instead of applying a filter check to all input. Of course if you're running on a server prior to 4.5 then nevermind. HTH, t ** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ** -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 2:06 PM To: CF-Talk Subject: RE: Could you give my application a once through Oooh I can reproduce that bad boy every darn time (it was your fault) but it let me see that the input filter isn't a good deterant on SQL attacks. I will fill out the wish form, hopefully it will get fixed. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 5:11 PM To: CF-Talk Subject: Re: Could you give my application a once through Robert Everland wrote: Had to reboot, JRUN eats memory when you give it a query with no records and tell it to draw a graph If that was me: sorry. But if you can reproduce that don't forget to tell MM because IMHO crashing because of that is a bug. http://www.macromedia.com/support/email/wishform/?6213=3 Jochem __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Credit Card, TAG/Questions
I am going with a company called Firepay for my online transactions. Do you think it would be easy to just copy the authorize_3 custom tag, change the info to fit firepay and use that? Has anyone used these guys before? Thanks Mike __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session variables expiring
Joe, You need to stop and re-start CF services on your web server for the changes to take effect in CF Administrator. James -Original Message- From: Joe Tartaglia [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 11:10 AM To: CF-Talk Subject: Session variables expiring I thought I had this all figured out -- it works fine on sites running under CF Ver. 4.0 -- but now I realize that I don't. My session variables on a site running on an NT 4/CF 4.5 server keep expiring prematurely (it seems like after 10 or 20 minutes). The following code is in my Application.cfm file: cfapplication name=SNAMeLearning clientmanagement=Yes sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(1,0,0,0)# applicationtimeout=#CreateTimeSpan(1,0,0,0)# In CF Administrator, I have the following settings for Session Variables: Maximum: 1 0 0 0 Default: 1 0 0 0 I have tried setting this to 5 hours and it didn't work either: 0 5 0 0 I even tried removing the sessiontimeout line from the cfapplication tag so that the CF Admin defaults would kick in. No good. Application variable timeouts appear to be working fine. They are set the same way as the session variables. I am at my wits end with this. Like I said, I use the same settings on my CF 4.0 apps and they work fine. Any help would be greatly appreciated. Thanks in advance, Joe Tartaglia High Caliber Systems 212-684-5553 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT - Porn sites have their uses
I think there is one point that is missed on this issue. We're giving the porn industry credit for being pioneers in many fields, but the real question is: Would we have dealt with those issues without the porn industry and how far behind are we? I'm guessing we were/are right on their tails and every one of those concepts would have been solved (perhaps in a better way, perhaps worse) without that industry. Or maybe not. Just a thought. Josh - [EMAIL PROTECTED] _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT was wondering if any Javascript guru's could give me a hand with this code
Here is what I use for CC validation, you could just add a few more cards , and it works fine with NS6. Function validate_card(){ var target = document.forms[0]; var number = target.card_number.value; var type = target.card_type[target.card_type.selectedIndex].value; var first_number = number.substring(0,1); switch (type) { case VISA: if ( parseInt(first_number) != 4){ alert(Invalid Visa Card Number); return; } break; case AMEX: var first_two_numbers = number.substring(0,2); if ( parseInt(first_two_numbers) != 34 parseInt(first_two_numbers) != 37){ alert(Invalid American Express Card Number); return; } break; case MAST: var first_two_numbers = number.substring(0,2); if ( parseInt(first_two_numbers) 50 || parseInt(first_two_numbers) 56 ){ alert(Invalid Mastercard Number); return; } break; case DISC: var first_four_numbers = number.substring(0,4); if( parseInt(first_four_numbers) != 6011){ alert(Invalid Discover Card Number); return; } break; } } Doug - Original Message - From: Troy Montour [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 9:27 AM Subject: Re: OT was wondering if any Javascript guru's could give me a ha nd with this code I could include the form no problem on that. I had it with document.formname but was trying to see if that was causing my NS problem which it didn't help anything. and yes I have tested it with IE 3 and it works good but with NS it just basically submits the form with no error. here is the html code FORM id=JoinForm NAME=JoinForm ENCTYPE=multipart/form-data ACTION=test3.cfm METHOD=POST onSubmit=return checkFields(); input type=hidden name=MailDomain value=troy.com TABLE ID=Table6 BORDER=0 CELLSPACING=0 CELLPADDING=0 WI DTH=100% TR VALIGN=TOP TD WIDTH=757 HEIGHT=415 P TABLE WIDTH=751 BORDER=0 CELLSPACING=0 CELLPADDING=0 ALIGN=LEFT NOF=TE TR TD TABLE ID=Table11 BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=100% COLGROUP COL WIDTH=24 COL WIDTH=179 COL WIDTH=259 COL WIDTH=289 /COLGROUP TR TD WIDTH=24 BGCOLOR=#006699 Pnbsp;/ P /TD TD WIDTH=179 BGCOLOR=#006699 PBFONT COLOR=#FF SIZE=-1Private Information/FONT/B/P /TD TD COLSPAN=2 BGCOLOR=#006699 Pnbsp;/ P /TD /TR TR TD WIDTH=24 Pnbsp;/ P /TD TD WIDTH=179 Pnbsp;/ P /TD TD COLSPAN=2 Pnbsp;/ P /TD /TR TR TD WIDTH=24 PBFONT FACE=Arial,Helvetica,Univers,Zurich BT,sans-serif SIZE=-11./FONT/B/P /TD TD WIDTH=179 PBFONT COLOR=#FF SIZE=-1 FACE=Abadi MT Condensed Light,sans-serif*/FONTFONT FACE=Arial,Helvetica,Univers,Zurich BT,sans-serif SIZE=-1First Name:/FONT/B/P /TD TD COLSPAN=2 PINPUT ID=Forms Edit Field1
RE: VNC vs PC Anywhere
Has anyone had any experience using VNC from ATT - it seems reasonably good (and free) at first glance. Anything I should be aware of if we were to use it on a production box? Yes. By itself, it is pretty unsecure, while pcAnywhere isn't if properly configured. If you want to use VNC securely, you can set it up to run through SSH, but on Windows, you're probably better off using pcAnywhere or Terminal Server. I'm a big Terminal Server fan now - I can run it from a Pocket PC! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Credit Card, TAG/Questions
I seriously doubt it would be that easy. Some processors utilize an HTTP post, some use a get, some have you tie into an API at a low level, etc. As such, there's no way of knowing if it integrates the same way as Authorize - if noone has written anything, you'll need to code it yourself. On the plus side, perhaps you can sell your code if you're the first. (nothing like an unbroached market!) --- Billy Cravens - Original Message - From: Michael Ross [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 11:54 AM Subject: Credit Card, TAG/Questions I am going with a company called Firepay for my online transactions. Do you think it would be easy to just copy the authorize_3 custom tag, change the info to fit firepay and use that? Has anyone used these guys before? Thanks Mike __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: VNC vs PC Anywhere
Just noticed that there's a pocket pc version of vnc too... :-) http://www.uk.research.att.com/vnc/download.html Ian -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 19 December 2001 18:03 To: CF-Talk Subject: RE: VNC vs PC Anywhere Has anyone had any experience using VNC from ATT - it seems reasonably good (and free) at first glance. Anything I should be aware of if we were to use it on a production box? Yes. By itself, it is pretty unsecure, while pcAnywhere isn't if properly configured. If you want to use VNC securely, you can set it up to run through SSH, but on Windows, you're probably better off using pcAnywhere or Terminal Server. I'm a big Terminal Server fan now - I can run it from a Pocket PC! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfsearch - Improving indexing speed for DB collection.
The key only needs to be unique. Be that a unique path or a unique number I am not sure whether that matters speed wise. Using QueryAddRow() is a great method to combine database and file content in a collection and I haven't found it to rum *much slower. Certainly not ten times slower. Is it just the indexing that takes longer or does the search suffer as well?. Are you using CFHTTP or CFDIRECTORY to get the file content? I have several verity collections that index database records. It was behaving fine before when I indexed these collections. I have altered my code some, and it now indexes about twice as many pages, but takes at least 10x as long to execute. The only significant changes that I made are 1) I am adding rows to the query using QueryAddRow(), and 2) I changed they Key that is used from a numeric identity to a mixed number/text combination. Is it important that the key is an integer? TIA - Ben Morris __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cache test
Instead of removing and replacing the cache attribute on your query, first set it to 0,0,0,0 then run it then remove it. Now it has been uncached and you should be able to add a new cache later. As many of you have noticed, I have dynamic banner ads and list information at the bottom of all list posts. Normally, this information is cached using a CFQUERY with a cachedwithin attribute set to 1 (which means 1 day). In order to test a new ad, I removed the cachedwithin attribute and all worked ok. When I placed it back in (without restarting the CF server) the old cached information was used rather than the newer. Has anyone seen anything similar in CF 5? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF 5 can't handle DB2 (was: Server running way too slow)
Also try deleting and reinstalling the odbc driver, my SQL queries were taking way way way too long, I updated the MDAC, deleted the driver deleted the odbc connection reinstalled it and now it works great. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: BILLY CRAVENS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 11:20 AM To: CF-Talk Subject: Re: CF 5 can't handle DB2 (was: Server running way too slow) I assume that you have all of the shared variables locked? Whereas you could more or less get away with this in prior version, CF5 is very picky about it. --- Billy Cravens - Original Message - From: Andrew Peterson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 9:07 AM Subject: CF 5 can't handle DB2 (was: Server running way too slow) I need to figure out why CF 4.5 and a piddly server can handle our traffic whereas CF 5.0 and a powerful server cannot. Our requests were running so slow when I initially loaded CF 5 that I had to go back to CF 4.5, where it worked splendidly. Now I reinstalled CF 5 and page requests are taking way too long again. Way too long. PerfMon shows cached requests in the 100+ range (and running requests to 5 I think, which is the default setting in CFIDE - note that I have not changed these from 4.5, where the default settings worked). My conclusion is that it has something to do with CF5 and DB2. Most of our site accesses a DB2 back end but the whole site is slow. I'm connecting to DB2 via ODBC because we cannot get the native driver to work (is there a trick here! DANG!!!). I just don't see how CF can even be a factor here -- but how can it not? DB2 query processing times are fine (3 seconds), but the page comes up much later (35+ seconds). All of the relevant server settings are set to their defaults as they were with CF 4.5, though I made mods to them the first time I loaded CF 5 to no avail. Macromedia does not wish to hear from me until I fork over support $$$, which would be fine but as a govt agency we pay by voucher which can take weeks. Can someone bail me out? Thanks, Andy __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: VNC vs PC Anywhere
Just noticed that there's a pocket pc version of vnc too... :-) Yes, and it works well enough. Unfortunately, there's no SSH client for Pocket PC that allows port forwarding, and I wouldn't deploy VNC without SSH. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: VNC vs PC Anywhere
That's pretty cool, what I do is establish a VPN to the computer then VNC. I would use Zvnc but I use the tight version of VNc so I get pretty good refresh rates. Maybe they can implement tight encoding into Zvnc then it would be kick ass. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Ian Tait [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 12:37 PM To: CF-Talk Subject: RE: OT: VNC vs PC Anywhere Zvnv is worth a look It encapsulates zebedee technology... http://people.we.mediaone.net/ddyer/znc/zvnc.html Ian -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: 19 December 2001 17:22 To: CF-Talk Subject: Re: OT: VNC vs PC Anywhere Ben Whalley wrote: Has anyone had any experience using VNC from ATT - it seems reasonably good (and free) at first glance. Anything I should be aware of if we were to use it on a production box? Last time I looked it only encrypted the login process and not the entire session. Jochem __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: VNC vs PC Anywhere
True enough - (although zvnc addresses that issue [windows only]) - but the best feature of vnc has got to be the cross platform stylee. Ian -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 19 December 2001 18:35 To: CF-Talk Subject: RE: VNC vs PC Anywhere Just noticed that there's a pocket pc version of vnc too... :-) Yes, and it works well enough. Unfortunately, there's no SSH client for Pocket PC that allows port forwarding, and I wouldn't deploy VNC without SSH. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfm file/image downloader
I have searched through the CF-Talk archives, but could not find a solution that actually works every time on this, want to be able to use cfcontent/cfheader to force the user to download a file that i specify in the ColdFusion template so that I don't have to give away the locations of the file or use FTP to have them downloaded. Anyone have some code for this they would be willing to share about doing it? Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Exporting data to Excel
If you are looking to export data to an Excel file for downloading or related purposes, the solution I am about to describe may be an option you wish to consider. You can also create XML files with the data in them to create the Excel spreadsheet you need. If you save them as .XLS files, Excel should open them on the fly. You can test this by creating a very basic file that has the code pasted below; or you can do something more elaborate by using your existing spreadsheet and saving the sheet as an HTML file. If you combine the multiple files that Excel creates (so that the styles are integrated in the main file), rename that file with a XLS extension, and open it, Excel will even maintain all of the format settings you have applied. It takes a little playing with it to get the precise results you want, but you can use the basic file exported from Excel as a template, then use CFFILE to create a file that the user can download and all will look exactly as you want it to. This is a very good way to maintain page margins, headers, footers, and other specific format options that are difficult to do in other fashions. This method has the added advantage of not having to deal with the Excel COM object, which can be a bit troublesome at times for a variety of reasons. Hope this helps... Chip Griffin --- CODE SNIPPED FOLLOWS --- html head/head body table tr tdSome Data/td td123/td td/td /tr /table /body /html --- CODE SNIPPET ENDS --- -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 12:50 PM To: CF-Talk Subject: RE: Exporting data to Excel In CFDJ this month, there was a really good article about using Internet Queries in Excel... You could consider doing an import instead... Or, if you're using SQL Server, consider creating a DTS package that will do the export for you. I've got a package that runs through DTS that works pretty well... Alternatively, you can use the COM object. Check out what's on www.cfcomet.com -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 1:08 PM To: CF-Talk Subject: Exporting data to Excel I've used Excel datasources in the past, but simply reading data from them. Now, I'd like to be able to export data to an Excel spreadsheet. I'm not sure what the best approach to doing this might be. My biggest concerns are concurrency issues. I suspect I may run into problems dealing with OS-imposed file locks as well. The first problem that I'm running into is: I have an Excel datasource that points to an Excel file. If that single file is to be used for the data output, then I need to clear the file each time before beginning the export process. The ODBC driver is saying that DELETE FROM is unsupported. Any advice appreciated, Jim _ _ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfm file/image downloader
Create a file called GetImage.cfm It takes an ID as a parameter. Code would look something like this (pseudocode): Get Image file info based on passed ID Set the filename the user sees using the CFHEADER Use the Physical path retrieved from the database with CFCONTENT to send the file to the user. Now, any call you make to a file/image, you call the GetImage.cfm with the appropriate ID. The user will only ever see the path to GetImage.cfm - never the path to the actual file. HTH Shawn Grover -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 11:41 AM To: CF-Talk Subject: cfm file/image downloader I have searched through the CF-Talk archives, but could not find a solution that actually works every time on this, want to be able to use cfcontent/cfheader to force the user to download a file that i specify in the ColdFusion template so that I don't have to give away the locations of the file or use FTP to have them downloaded. Anyone have some code for this they would be willing to share about doing it? Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cryptogram
http://www.vawter.com/crypto.cfm The first time I visit the page, the solution is displayed. (When I go to a new crypto, the solution isn't given till I hit Give Up) Other than that, pretty cool. Scott -- Scott Brady http://www.scottbrady.net/ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: VNC vs PC Anywhere
Can you install Terminal Server on Windows 2000 professional? I have it installed on some servers, but my workstation is professional and pc anywhere is abit slow. - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 1:03 PM Subject: RE: VNC vs PC Anywhere Has anyone had any experience using VNC from ATT - it seems reasonably good (and free) at first glance. Anything I should be aware of if we were to use it on a production box? Yes. By itself, it is pretty unsecure, while pcAnywhere isn't if properly configured. If you want to use VNC securely, you can set it up to run through SSH, but on Windows, you're probably better off using pcAnywhere or Terminal Server. I'm a big Terminal Server fan now - I can run it from a Pocket PC! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: VNC vs PC Anywhere
Not the server, but you can install the client. (Windows XP Professional does have a TS server though) Go to the link I posted earlier. Thee should be a link to the workstation client. Alternately, you can install the web version (same link) on any IIS box to control a TS server. --- Billy Cravens - Original Message - From: David Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 1:03 PM Subject: Re: VNC vs PC Anywhere Can you install Terminal Server on Windows 2000 professional? I have it installed on some servers, but my workstation is professional and pc anywhere is abit slow. - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 1:03 PM Subject: RE: VNC vs PC Anywhere Has anyone had any experience using VNC from ATT - it seems reasonably good (and free) at first glance. Anything I should be aware of if we were to use it on a production box? Yes. By itself, it is pretty unsecure, while pcAnywhere isn't if properly configured. If you want to use VNC securely, you can set it up to run through SSH, but on Windows, you're probably better off using pcAnywhere or Terminal Server. I'm a big Terminal Server fan now - I can run it from a Pocket PC! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfgraph and urls
When using cfgraph with the urlcolumn feature, the flash movie creates links like traflog%2Ecfm%3Fip%3D192%2E0%2E76%2E250%20%20%20 instead of traflog.cfm?ip=192.0.76.40 and my server tells me he can't find the page. Any way around that? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cryptogram
Well what fun would it be if the solution were already posted? Kinda defeats the purpose of playing doesnt it. In any event. I have redone the ui so that it is all point and click no dropdowns. Any comments on which you like? http://www.vawter.com/cryptotwo.cfm (point and click) http://www.vawter.com/crypto.cfm (dropdowns) - Original Message - From: Scott Brady [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 11:58 AM Subject: Re: Cryptogram http://www.vawter.com/crypto.cfm The first time I visit the page, the solution is displayed. (When I go to a new crypto, the solution isn't given till I hit Give Up) Other than that, pretty cool. Scott -- Scott Brady http://www.scottbrady.net/ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT - Javascript questions
Whats another way to do size in NS like IE will use something.size Thanks __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cache test
Actually, setting it to plain 0 works as well. The general assumption would be that if you remove the cache info from a query it should uncache. Doesn't happen. Still, the real problem was it keeping the cache more than 24 hours. I'm going to have to play with this some more. I'll throw this up to the MM bug list not as a 'real' tech bug but as an assumption bug. Change the query attributes should also change the cache, not just changing the query code. At 01:19 PM 12/19/01, you wrote: Instead of removing and replacing the cache attribute on your query, first set it to 0,0,0,0 then run it then remove it. Now it has been uncached and you should be able to add a new cache later. As many of you have noticed, I have dynamic banner ads and list information at the bottom of all list posts. Normally, this information is cached using a CFQUERY with a cachedwithin attribute set to 1 (which means 1 day). In order to test a new ad, I removed the cachedwithin attribute and all worked ok. When I placed it back in (without restarting the CF server) the old cached information was used rather than the newer. Has anyone seen anything similar in CF 5? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Exporting data to Excel
Thanks. After taking a quick look through the tag gallery and seeing how a few of the tags worked, I realized that I was approaching it all wroing. All the tags do is write out HTML tables, which Excel happily imports. I'm not sure which versions of Excel support this, I'm guessing just Excel 97 and later. So all I'm doing is using cfheader and cfcontent and spitting out an HTML table containing the data. It seems to work well. Formatting isn't an issue in this application. The only reason the customer wants to get data in Excel is to print mailing labels for their quarterly snail-mail newsletter. Jim - Original Message - From: Chip Griffin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 11:35 AM Subject: RE: Exporting data to Excel If you are looking to export data to an Excel file for downloading or related purposes, the solution I am about to describe may be an option you wish to consider. You can also create XML files with the data in them to create the Excel spreadsheet you need. If you save them as .XLS files, Excel should open them on the fly. You can test this by creating a very basic file that has the code pasted below; or you can do something more elaborate by using your existing spreadsheet and saving the sheet as an HTML file. If you combine the multiple files that Excel creates (so that the styles are integrated in the main file), rename that file with a XLS extension, and open it, Excel will even maintain all of the format settings you have applied. It takes a little playing with it to get the precise results you want, but you can use the basic file exported from Excel as a template, then use CFFILE to create a file that the user can download and all will look exactly as you want it to. This is a very good way to maintain page margins, headers, footers, and other specific format options that are difficult to do in other fashions. This method has the added advantage of not having to deal with the Excel COM object, which can be a bit troublesome at times for a variety of reasons. Hope this helps... Chip Griffin --- CODE SNIPPED FOLLOWS --- html head/head body table tr tdSome Data/td td123/td td/td /tr /table /body /html --- CODE SNIPPET ENDS --- -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 12:50 PM To: CF-Talk Subject: RE: Exporting data to Excel In CFDJ this month, there was a really good article about using Internet Queries in Excel... You could consider doing an import instead... Or, if you're using SQL Server, consider creating a DTS package that will do the export for you. I've got a package that runs through DTS that works pretty well... Alternatively, you can use the COM object. Check out what's on www.cfcomet.com -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 1:08 PM To: CF-Talk Subject: Exporting data to Excel I've used Excel datasources in the past, but simply reading data from them. Now, I'd like to be able to export data to an Excel spreadsheet. I'm not sure what the best approach to doing this might be. My biggest concerns are concurrency issues. I suspect I may run into problems dealing with OS-imposed file locks as well. The first problem that I'm running into is: I have an Excel datasource that points to an Excel file. If that single file is to be used for the data output, then I need to clear the file each time before beginning the export process. The ODBC driver is saying that DELETE FROM is unsupported. Any advice appreciated, Jim _ _ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
modify access databases via sql and cf
Hello, Anyone have a reference for administering access via sql? We normally use mysql and need to modify access db's the same way. We've build a cf page that we can type sql into. One of the developers is having a hard time finding all the syntax for drop, alter, etc. Any suggestions? Thanks. -Erik __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: PLEASE HELP - CFGrid does not show up in CF50 even after the HotFix is applied
I still need to find an answer for this problem, ANY help would br greatl y appreciated. -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 11:31 AM To: CF-Talk Subject: CFGrid does not show up in CF50 even after the HotFix is applied I have CF50 set up on a Win2000 server and can not see any of my template s that use CFGrid. I have downloaded and replaced the new jar file from Allaire and still cn not get these to load. Any insight would be greatly appreciated. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Digest
Anyone remember how I can make this forum a digest? I have misplaced the subscription email Chris Luksha IS/Web Programmer Helmers Publishing, Inc. Publishers of Desktop Engineering and Supply Chain Systems Magazines (603)924-9631 ext. 267 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
2 types of timeouts?
I'm getting two types of timeouts in my catch statements - one with type=UNKNOWN and one with type=COM.ALLAIRE.COLDFUSION.REQUEST.TIMEOUT (see below). I was expecting the TIMEOUT one (CF 4.5.1 SP2 on Solaris). I'm curious why I get different timeout types - anybody seen this? thanks, Chris Norloff xx Date 2001-12-14 Time 10:49:20 QueryName= Type=UNKNOWN Msg=Request timed outP Detail=The time taken to process your request has exceeded the allowable limit of 60 seconds. Please notify the server administrator (using the mail link below) that this error has occurred. PNote: You can override the request time limit by adding a 'RequestTimeout' parameter to the URL used to request the page (e.g. page.cfm?RequestTimeout=500).PSQL = SELECT name, street, city, state, zip_code, zip_plus4 FROMp_permit_periodical_ref WHERE LTRIM(permit_no, '0') = LTRIM(2725, '0') ANDpermit_type = 'PI' ANDfinance_no = '565480'PData Source = DEVUTLIMEPpThe error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (547:1) to (547:90) in the template file /netscape/server4/docs/DEVlime/postage_statements/web13602-r.cfm./p xx xx Date 2001-12-19 Time 12:50:59 QueryName=updateInd Type=COM.ALLAIRE.COLDFUSION.REQUEST.TIMEOUT Msg=The time taken to process your request has exceeded the allowable limit of 60 seconds. Please notify the server administrator (using the mail link below) that this error has occurred. PNote: You can override the request time limit by adding a 'RequestTimeout' parameter to the URL used to request the page (e.g. page.cfm?RequestTimeout=500).P Detail= __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfgraph and urls
Have him urldecode() it. -Original Message- From: Admin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 12:11 PM To: CF-Talk Subject: cfgraph and urls When using cfgraph with the urlcolumn feature, the flash movie creates links like traflog%2Ecfm%3Fip%3D192%2E0%2E76%2E250%20%20%20 instead of traflog.cfm?ip=192.0.76.40 and my server tells me he can't find the page. Any way around that? __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Secure POP
Has NO ONE had to approach this problem? I'm slightly taken back by the lack of information out there. Certainly we can't be the only institution burdened by an anti-clear text password policy. So, Seriously, I'm curious if anyone has dipped their finger in this or has any ideas of some resources available to achieve SLA POP or IMAP authentication via web. Trey Rouse -Original Message- From: Trey Rouse [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 3:04 PM To: CF-Talk Subject: Secure POP I have an application that is going to require the ability to use SLA POP to authenticate users. I can see that CFPOP is not that feature enabled. Is anyone aware of any other tag, function, script, tool, etc that is capable of performing this function? Trey Rouse Internet Project Coordinator Rice University __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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 include file
I've looked around (Forta, Micah Brown, CFHub and others) and cannot find a way to include a file that would be processed by the server. I would like to include a list of holidays that I could use in more than one file. ie. cfif holiday do this cfesle do that /cfif cfinclude template doesn't work. Is there anything that does? TIA This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.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 include file
The whole point of cfinclude is to include code. What happens when you use cfinclude? You are using CFINCLUDE, right? === 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: Gilbert Midonnet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 2:43 PM To: CF-Talk Subject: cf include file I've looked around (Forta, Micah Brown, CFHub and others) and cannot find a way to include a file that would be processed by the server. I would like to include a list of holidays that I could use in more than one file. ie. cfif holiday do this cfesle do that /cfif cfinclude template doesn't work. Is there anything that does? TIA -- -- This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cryptogram
Well what fun would it be if the solution were already posted? Kinda defeats the purpose of playing doesnt it. Sorry, I may not have been clear. My point wasn't that the solution should be posted. My point was that the solution already is posted when I first load the page, which isn't right. When I choose other puzzles, the solution isn't posted (which is the way it should be). I definitely like the point-and-click better than the drop-downs. It seems more intuitive to me. Scott -- Scott Brady http://www.scottbrady.net/ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.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 include file
Im not sure I understand what you want to do! cfif condition cfinclude somefile.cfm cfelseif condition cfinclude somefile.cfm cfelse cfinclude somefile.cfm -Original Message- From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 2:43 PM To: CF-Talk Subject: cf include file I've looked around (Forta, Micah Brown, CFHub and others) and cannot find a way to include a file that would be processed by the server. I would like to include a list of holidays that I could use in more than one file. ie. cfif holiday do this cfesle do that /cfif cfinclude template doesn't work. Is there anything that does? TIA This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfselect question
Does anyone know of a way to display a default field when using cfselect and a query first? I've put an option tag between the cfselect and /cfselect tags and it displays it as the last entry. I would like it to display first. What I'm doing is using my states database to populate the select box, but I want it to default to Select State as the very first entry, but it's showing up last. cfselect query=getStates name=stateid value=stateid display=name option value=0 selectedSelect State /cfselect Sorry for such a simple post, but I'm fried and can't think of any way around putting it in the table itself. Thanks, Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfselect question
Put the option tag before the output query.. Then in the select tag, make the option selected. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 2:49 PM To: CF-Talk Subject: cfselect question Does anyone know of a way to display a default field when using cfselect and a query first? I've put an option tag between the cfselect and /cfselect tags and it displays it as the last entry. I would like it to display first. What I'm doing is using my states database to populate the select box, but I want it to default to Select State as the very first entry, but it's showing up last. cfselect query=getStates name=stateid value=stateid display=name option value=0 selectedSelect State /cfselect Sorry for such a simple post, but I'm fried and can't think of any way around putting it in the table itself. Thanks, Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.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 include file
The actual code you would use... cfif lEatGreenEggsAndHam EQ 1 cfinclude template=notSamIAm.cfm cfelse cfinclude template=SamIAm.cfm /cfif HTH C. Hatton Humphrey, Developer Fisher, Towne Associates 716-839-2141 x336 [EMAIL PROTECTED] -Original Message- From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 2:43 PM To: CF-Talk Subject: cf include file I've looked around (Forta, Micah Brown, CFHub and others) and cannot find a way to include a file that would be processed by the server. I would like to include a list of holidays that I could use in more than one file. ie. cfif holiday do this cfesle do that /cfif cfinclude template doesn't work. Is there anything that does? TIA -- -- This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SOLVED: cfselect question
OMG - do I feel stupid. Thanks Michael. I totally knew how to do it that way and my brain just locked up. Thanks for the nudge. I need a beer. Is it x-mas yet? I need a break! Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 - Original Message - From: Tangorre, Michael T. To: CF-Talk Sent: Wednesday, December 19, 2001 1:48 PM Subject: RE: cfselect question Put the option tag before the output query.. Then in the select tag, make the option selected. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 2:49 PM To: CF-Talk Subject: cfselect question Does anyone know of a way to display a default field when using cfselect and a query first? I've put an option tag between the cfselect and /cfselect tags and it displays it as the last entry. I would like it to display first. What I'm doing is using my states database to populate the select box, but I want it to default to Select State as the very first entry, but it's showing up last. cfselect query=getStates name=stateid value=stateid display=name option value=0 selectedSelect State /cfselect Sorry for such a simple post, but I'm fried and can't think of any way around putting it in the table itself. Thanks, Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cache test
Changing the query paramaters just loads a new query into the cache. Same name... different cached query. This is great because you will often have many people running different queries and they all get thier very own cached copy. The flip side is removing them all can be tricky. I like to set an Application variable to hold the query cache time and use the CachedAfter attribute rather than cached whithin. Then just re-set that Application.MyCache variable whenever you want to uncache all the slightly different queries. Change the query attributes should also change the cache, not just changing the query code. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfselect question
Just my .02. But I mostly stay away form CFSELECT, because I don't use CFFORM you could just use select SELECT name=stateid option value=0 SELECTEDSelect State/option CFOUTPUT query=getstates option value=#stateid##name#/option /CFOUTPUT /SELECT This I believe would get you what you want. (but watch my typing, was just done on the spur of the moment ;o) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 12:49 PM To: CF-Talk Subject: cfselect question Does anyone know of a way to display a default field when using cfselect and a query first? I've put an option tag between the cfselect and /cfselect tags and it displays it as the last entry. I would like it to display first. What I'm doing is using my states database to populate the select box, but I want it to default to Select State as the very first entry, but it's showing up last. cfselect query=getStates name=stateid value=stateid display=name option value=0 selectedSelect State /cfselect Sorry for such a simple post, but I'm fried and can't think of any way around putting it in the table itself. Thanks, Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SOLVED: cfselect question
Almost xmas.. Lets have a US wide happy hour. :-) Maybe in NYC tomorrow night, I'll be driving there tomorrow morning from Elmira NY!! Mike :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 2:56 PM To: CF-Talk Subject: SOLVED: cfselect question OMG - do I feel stupid. Thanks Michael. I totally knew how to do it that way and my brain just locked up. Thanks for the nudge. I need a beer. Is it x-mas yet? I need a break! Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 - Original Message - From: Tangorre, Michael T. To: CF-Talk Sent: Wednesday, December 19, 2001 1:48 PM Subject: RE: cfselect question Put the option tag before the output query.. Then in the select tag, make the option selected. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 2:49 PM To: CF-Talk Subject: cfselect question Does anyone know of a way to display a default field when using cfselect and a query first? I've put an option tag between the cfselect and /cfselect tags and it displays it as the last entry. I would like it to display first. What I'm doing is using my states database to populate the select box, but I want it to default to Select State as the very first entry, but it's showing up last. cfselect query=getStates name=stateid value=stateid display=name option value=0 selectedSelect State /cfselect Sorry for such a simple post, but I'm fried and can't think of any way around putting it in the table itself. Thanks, Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.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 include file
I take it you have allready checked this link then: http://www.cfhub.com/html/include/index.cfm The CFINCLUDE tag is one of the simpler ones and any template you point it at will be included (and proccessed) What trouble are you having exactly? Perhaps a path error? I've looked around (Forta, Micah Brown, CFHub and others) and cannot find a way to include a file that would be processed by the server. I would like to include a list of holidays that I could use in more than one file. ie. cfif holiday do this cfesle do that /cfif cfinclude template doesn't work. Is there anything that does? TIA -- -- This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cryptogram
When I view the page with NS 4.7, the message (blue letters) and the red letters don't show up. The boxes are empty. Works fine with IE 5.5 -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 12:14 PM To: CF-Talk Subject: Re: Cryptogram Well what fun would it be if the solution were already posted? Kinda defeats the purpose of playing doesnt it. In any event. I have redone the ui so that it is all point and click no dropdowns. Any comments on which you like? http://www.vawter.com/cryptotwo.cfm (point and click) http://www.vawter.com/crypto.cfm (dropdowns) - Original Message - From: Scott Brady [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 11:58 AM Subject: Re: Cryptogram http://www.vawter.com/crypto.cfm The first time I visit the page, the solution is displayed. (When I go to a new crypto, the solution isn't given till I hit Give Up) Other than that, pretty cool. Scott -- Scott Brady http://www.scottbrady.net/ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cryptogram
Known issue. Forgot to state in recent message that it is NS6 (still working on colors though) and IE 5+ (maybe 4+ havent tested) Uses way too much dhtml for NS4. Notice I am rewriting page constantly without server trip. I think it can be done in NS4 but havent done it yet. Thanks for heads up though - Original Message - From: Bruce, Rodney (Contractor) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 1:19 PM Subject: RE: Cryptogram When I view the page with NS 4.7, the message (blue letters) and the red letters don't show up. The boxes are empty. Works fine with IE 5.5 -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 12:14 PM To: CF-Talk Subject: Re: Cryptogram Well what fun would it be if the solution were already posted? Kinda defeats the purpose of playing doesnt it. In any event. I have redone the ui so that it is all point and click no dropdowns. Any comments on which you like? http://www.vawter.com/cryptotwo.cfm (point and click) http://www.vawter.com/crypto.cfm (dropdowns) - Original Message - From: Scott Brady [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 11:58 AM Subject: Re: Cryptogram http://www.vawter.com/crypto.cfm The first time I visit the page, the solution is displayed. (When I go to a new crypto, the solution isn't given till I hit Give Up) Other than that, pretty cool. Scott -- Scott Brady http://www.scottbrady.net/ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.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 include file - doh!!!
sheepish grin it works now. thx all long story below, if you're interested :-) What doesn't work is to pull out part of the if-else into a template. !--- start --- cfloop index=myIndex from 1 to xxx fset getDate=- myIndex cfset weekDay = #DateFormat(DateAdd(d,getDate,Now()),mmm dd, YY)# cfset list_holidays = 20011212,20011213,20011217 cfif #DayOfWeekAsString(DayOfWeek(#weekDay#))# EQ Saturday OR #DayOfWeekAsString(DayOfWeek(#weekDay#))# EQ Sunday br cfelseif #list_holidays# CONTAINS #DateFormat(DateAdd(d,getDate,Now()),mmdd)# cfoutput font color=##99#DateFormat(DateAdd(d,getDate,Now()), dd, )#/fontbr /cfoutput // snip !--- end --- What works is to put the cfset ... into the include. Why didn't work earlier? Because there were other mistakes :-) But, if I put the cfelseif ... into the include then the page breaks apart. Of course, there's no need to do so in this case. Thx for your input. Your responses helped me find the error. gilbert midonnet -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 3:03 PM To: CF-Talk Subject: Re: cf include file I take it you have allready checked this link then: http://www.cfhub.com/html/include/index.cfm The CFINCLUDE tag is one of the simpler ones and any template you point it at will be included (and proccessed) What trouble are you having exactly? Perhaps a path error? I've looked around (Forta, Micah Brown, CFHub and others) and cannot find a way to include a file that would be processed by the server. I would like to include a list of holidays that I could use in more than one file. ie. cfif holiday do this cfesle do that /cfif cfinclude template doesn't work. Is there anything that does? TIA -- -- This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists