RE: How will Macromedia resolve conflict of interest?
I set up a list yesterday for this at http://www.egroups.com/group/AllMac Chris Montgomery [EMAIL PROTECTED] Web Development Consulting http://www.astutia.com Allaire Consulting Partner 210-490-3249/888-745-7603Fax 210-490-4692 AIM: "astutiaweb", ICQ: 7381282 -Original Message- From: Adrian Cooper [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 4:37 PM To: CF-Talk Subject: Re: How will Macromedia resolve conflict of interest? snip Hi John: What we need is a list service (like these) so that we can discuss all of the merger implication issues among ourselves (and keep it off this list) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Varaible Names with -
You could do the following if you don't have control of the DB:-) cfquery name="qtest: datasource="datasource" select `field-name` as FieldName from TableName /cfquery Notice the ` which is located under the tilda(~) key this will return the fieldname as it was written in the DB. However you can't use this with CF, so using the as command this will rename the field to anything you want it to be. So you could then reference it instead of qtest.field-name, but as qtest.FieldName instead. Hope this helps:-) regards Andrew Scott Senior Cold Fusion Application Developer ANZ Business eCommerce * Ph 8615 6018 * [EMAIL PROTECTED] --- This e-mail and any attachments to it (the "Communication") is confidential and is for the use only of the intended recipient. The Communication may contain copyright material of Australia and New Zealand Banking Group Limited ABN 11 005 357 522 ("ANZ"), or any of its related entities or of third parties. If you are not the intended recipient of the Communication, please notify the sender immediately by return e-mail, delete the Communication, and do not read, copy, print, retransmit, store or act in reliance on the Communication. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of ANZ. ANZ does not guarantee the integrity of the Communication, or that it is free from errors, viruses or interference. -Original Message- From: Warrick, Mark [mailto:[EMAIL PROTECTED]] Sent: 18 January 2001 10:09 To: CF-Talk Subject: RE: Varaible Names with "-" This probably isn't the answer you're looking for, but you should rename the column. That's just plain bad database design to begin with. And there's no need to add on another layer of unnecessary programming when all you've gotta do is rename the field. ---mark -- Mark Warrick Phone: (714) 547-5386 Fax: (714) 972-2181 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Troy Hiltbrand [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 10:00 AM To: CF-Talk Subject: Varaible Names with "-" Is there any way to pull out the information about a query column that has a "-" in it? The problem is that with SQL Server 2000, when you do a "for xml" select statement, the column name that is returned has "-"s in it. From the documentation in SQL Server 2000, I am not seeing a name to rename that. I am trying to pull out the xml from this query, but in order to do this, I need to get at the data with a column name that has a "-" in it. If anyone has any suggestions, please let me know. Thanks. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Macromedia and Allaire to Merge
From: "Dave Watts" [EMAIL PROTECTED] Take a look at this, and tell me Flash has no place in business apps: http://www.figleaf.com/development/flash4/orgchart.swf ObObvious: Went to page. Asked if I want acitveX control to run. clicked no. Blank page. Relying on flash (or other similar) with no alternative content for those choosing not to allow activex is ... In an intranet or vpn (with all that a closed and controlled quasi-laboratory situation implies) I can see axtivex playing a role. Exposed to the world though ... well I dunno. And what about lynx and ADA requirements? Especially the ADA requirements - being near DC you should have a good handle on that, Dave. Pan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [merger] Where to next?
I am sold on Macromedia/Allaire, but that damn -min keeps saying stuff that makes me think I gotta learn more before diving in. And this might mean fundamental changes to how I develop, and the tools I use. I'm jonsing for a smoke, so perhaps you shouldn't listen too closely to me these days. Min the Grumpy. But... short term (ie, the next year) I'd say it's pretty much business as usual. No significant changes. Don't panic. A year or so out though things get interesting I'm not saying the New Macromedia is bad thing. I mainly pointed out Flash is semi-doomed medium-term as more advanced browser technology becomes available. If the New Macromedia integrates Flash too tightly with CF (which will be a temptation) we may have a problem down the road. As long as it can be ignored, no real problem. Speaking of problems, the real one with Alliare is they can't seem to concentrate on the product at hand. First Spectra drains off resources. Then their new Java-based CF. How about focusing on the CF we're all using NOW? :) Not to denigrate Allaire's programmers, I'm sure they work hard, but HELL... I don't consider my a great programmer by any means, but most of the "bugs" and other issues that have been plaguing CF for years (especially the tcp/ip related ones) are things I could probably take care of myself over a long sleepless weekend with access to the source code. You have to wonder what their focus is at times. That's what's killing them them. Mismanagement of resources and priorities. (Though it does nicely bring about a decent crop of third-party suppliers of work-arounds. Although it may not be obvious at first, this does help to further the market base of a product as all these middleman will also push CF because it's in thier economic interest to do so.) Watch competitive tools. For application servers in order of preference. 1.) Zope 2.) ASP 3.) PHP Zope php. Not irrevelant, but... never will be mainstream. PHP probably will take the place of Perl in most geek hearts though. Worth a weekend to become "familiar" with. You'll probably have to deal with it occasionally. ASP ASP.NET. Going to be there and relevant as long as MS says it will be. You should be able to read ASP+ even if you never use it. I can almost assure you that at some point you'll either have to convert ASP code to CF or integrate a CF site with one written in an ASP. Frankly, any serious web developer should know both CF ASP. --that damn min :) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How will Macromedia resolve conflict of interest?
Again, no disrespect, but the CF-Community fits in with the community speaking about this and the CF-Stock fits in with people talking about the financials. A number of posts have gone to the stock list about this already. I set up a list yesterday for this at http://www.egroups.com/group/AllMac Chris Montgomery [EMAIL PROTECTED] Web Development Consulting http://www.astutia.com Allaire Consulting Partner 210-490-3249/888-745-7603Fax 210-490-4692 AIM: "astutiaweb", ICQ: 7381282 -Original Message- From: Adrian Cooper [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 4:37 PM To: CF-Talk Subject: Re: How will Macromedia resolve conflict of interest? snip Hi John: What we need is a list service (like these) so that we can discuss all of the merger implication issues among ourselves (and keep it off this list) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Storing/Encrypting Credit Cards
At 06:11 PM 1/17/01 -0500, you wrote: On 1/17/01, Jeremy Allen penned: Next, you should use a public/private key system and encrypt the credit card with a public key, store the private key's TOTALLY off the server. Hi Jeremy. Just curious. If the private key is created with a sufficient passphrase, how hard would it be for a cracker to use the private key to decrypt the data? It seems it would be difficult to use any sort of online encryption/decryption routine without the private keys stored on the server. Part of the problem is that when you store the private key totally off the server as stated, such as, behind a firewall that lies behind the server, protected from network entry, you have an issue retrieving the Credit Card info for the sake of the user, which could be the problem in this case. Encryption is not as much of a problem as decryption. You can set up your network to allow decryption behind the firewall behind the server but that means that you can't put the CC number in the form, which is what this is normally used for. The server can't make requests to the other side of the firewall, which is why the private key is safe. Basically it's a big nasty mess. Besides, if your encryption scheme isn't strong enough a hacker doesn't need a private key. You could store the last four digits in the database unencrypted and send that to the browser for user confirmation but your order processing would have to be on the other side of the firewall. Storing credit cards = bad. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Netscape/CF_Twoselects oddity
Puzzled I'm using CF_Twoselects to manipulate a pair of drop down menus, populated by a simple SELECT query. In IE, this page has two nice drop down menus, the right one is populated by javascript based on what is chosen in the left drop down. In Netscape 4.6 and 4.7 (and other NNs for all I know but I've only tested in those two so far) the left hand menu drops down nicely, the right menu comes down one line with tiny spin buttons and cycles through the options one by one. IT's annoying and at some resolutions difficult to read. Can anyone tell me why this happens? How come one menu is fine, the other is difficult? The url is http://www.choice.com.au/calculators/gsmphones1.cfm - look under "A. Search the database by make and model" Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks (p.s. don't put too much store by the data - this is test data only so far) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Macromedia and Allaire to Merge
I have tried to subscribe to this list in digest form ... but I can't seem to make it work.. heck I don't know how I managed to finally get it to work the first time I looked up the old mail and tried to use that command. I am really getting bugged trying to get this list in digest form. Please somebody!!! either make this list go in digest form or unsubscribe me lol Shelly ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Struct keys - if text, all upper case?
no, that's correct. (altough i can't speak for your crack smoking habits.:) internally, cf represents all structure keys as uppercase strings. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 7:05 PM To: CF-Talk Subject: Struct keys - if text, all upper case? Anyone else find that using a string as a key for a structure, that the string/key gets converted to uppercase? Or am I just smoking too much crack? :/ --Scott ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia and Allaire to Merge
What's it supposed to do? It just sits there for me. best, paul At 06:18 PM 1/17/01 -0500, you wrote: Take a look at this, and tell me Flash has no place in business apps: http://www.figleaf.com/development/flash4/orgchart.swf ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: SSL information
yeah. ask away. :) i did some security work as webadministrator for a DOD project with SSL. it's VERY easy to implement. are you using IIS? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Peter J. MacDonald [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 7:13 PM To: CF-Talk Subject: Slightly OT: SSL information I was wondering where there is a good place to learn about SSL implementation? Thank You, Peter Peter J. MacDonald II Creative Computing, Inc. 100 Middle Street Lincoln, RI 02865 Phone: 401.727.0183 x208 Fax: 401.727.4998 Portable: 401.965.3661 E-MAIL: [EMAIL PROTECTED] Web Page: www.creatcomp.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Slightly OT: SSL information
http://www.modssl.org/ if you are using apache - Original Message - From: Peter J. MacDonald [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 18, 2001 8:12 AM Subject: Slightly OT: SSL information I was wondering where there is a good place to learn about SSL implementation? Thank You, Peter Peter J. MacDonald II Creative Computing, Inc. 100 Middle Street Lincoln, RI 02865 Phone: 401.727.0183 x208 Fax: 401.727.4998 Portable: 401.965.3661 E-MAIL: [EMAIL PROTECTED] Web Page: www.creatcomp.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HELP! file rename!!!
CFfile action="upload" nameconflict="makeunique" ... then if you need to rename it to something that makes sense: cfif file.filewasrenamed = "yes" cffile source="[path]#file.ServerFile#" destination="path/newfilename.ext" ... /cfif At 05:05 PM 1/17/01 -0700, Jay Patton wrote: Sorry this didnt seem to go through the last time. does anyone know of a way to make the server rename a file that is being uploaded if it already exists? ie. if the file test.doc is already there is there a way that i can use the makeunique or another command for that matter rename the file to test_v2.doc, test_v3.doc ect i have files that will be downloaded by clients manipulated and then uploaded again. but i would like them to keep the same file name (sort of) but just add a _v2, _v3 ect.. to the end of it? has anyone else ever dealt with this? or have any ideas? Your help is much appreciated. Thanks, Now announcing my newly updated website http://www.blivit.org/mr_urc/index.cfm Resume: http://www.blivit.org/mr_urc/resume.cfm ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: macromedia forums
http://www.macromedia.com/support/forums/ -Original Message- From: lsellers [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 6:49 PM To: CF-Talk Subject: macromedia forums Does Macromedia (the old pre-Allaire Macromedia that is) have an offical forums/newsgroup? --min ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: business days
This might help get you started: 1) get all the dates between 2 dates using something like SELECT the_date FROM table WHERE the_date BETWEEN CreateODBCDate(date1) AND CreateODBCDate(date2) then 2) on your CFOUTPUT, something like CFOUTPUT QUERY="queryname" CFIF #DayOfWeek(the_date)# NEQ 1 AND #DayOfWeek(the_date)# NEQ 7 #the_date# BR /CFIF /CFOUTPUT -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 5:31 PM To: CF-Talk Subject: business days i am using SQLServer7. is there a function or custom tag to get the number of business days between 2 dates? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Replace function
Hi Here i have wddx_packet variable, it contains text file So my question is can i replace whole file by using following code. Becos when i use this code cfwddx action="WDDX2CFML" input="#wddx_packet#" output="EZB_PO_WDDX" cfset EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Getting this error:- An error occurred while evaluating the expression: EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Error near line 310, column 11. Parameter 1 of function Replace must be a basic value, i.e., a string, number, logical, or date/time value i am here Thanx in advance Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Replace function
Hi Here i have wddx_packet variable, it contains text file So my question is can i replace whole file by using following code. Becos when i use this code cfwddx action="WDDX2CFML" input="#wddx_packet#" output="EZB_PO_WDDX" cfset EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Getting this error:- An error occurred while evaluating the expression: EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Error near line 310, column 11. Parameter 1 of function Replace must be a basic value, i.e., a string, number, logical, or date/time value i am here Thanx in advance Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Replace function
Hi Here i have wddx_packet variable, it contains text file So my question is can i replace whole file by using following code. Becos when i use this code cfwddx action="WDDX2CFML" input="#wddx_packet#" output="EZB_PO_WDDX" cfset EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Getting this error:- An error occurred while evaluating the expression: EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Error near line 310, column 11. Parameter 1 of function Replace must be a basic value, i.e., a string, number, logical, or date/time value i am here Thanx in advance Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Replace function(very urgent)
Hi Here i have wddx_packet variable, it contains text file So my question is can i replace whole file by using following code. Becos when i use this code cfwddx action="WDDX2CFML" input="#wddx_packet#" output="EZB_PO_WDDX" cfset EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Getting this error:- An error occurred while evaluating the expression: EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Error near line 310, column 11. Parameter 1 of function Replace must be a basic value, i.e., a string, number, logical, or date/time value i am here Thanx in advance Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Macromedia makes more than flash
- Original Message - From: "Dylan Bromby" [EMAIL PROTECTED] Sent: Wednesday, January 17, 2001 11:51 PM as for those who have these concerns because CF is the only development language they have experience with; it never hurts to learn more, and it should help you advance your career both in terms of position and economics. at least, if those are meaningful for you. Yes. Development environments, like operating systems etc.. should_never_become a religion. We should always keep our eye on the ball, and the end objective which is productivity - i.e. producing the most state-of-the-art applications possible, with the best tools available at the time. Those that refuse to move with the times will pay the price. What I want to see out of this merger is the ultimate environment for creating powerful, integrated, homogeneous database driven Internet services, with a full array of tools for graphics etc.. To that end I am not bothered whether the end product is Cold Fusion, a development of it, or better still a combination of all environments available. Lets not also forget XML, PHP etc. etc.. - they all have to be factored in. The only caveat is backwards compatibility at all times for legacy applications. Adrian Cooper. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HotMail in CF
You may want to have a look at iMS. iMS turns your ColdFusion server into a world-class mail server that utilizes CFML for all server logic. We have several large sites running iMS as a webmail back end (email me off-list for references). With iMS you don't need CFMAIL or CFPOP to send and receive mail (I don't think I would use CFMAIL and CFPOP for a large hotmail-like system). One of the most powerful features of iMS is that incoming mail is processed immediately by CFML so you can do most anything that you want. For example, we have a small demo set up that retrieves accuweather reports for a designated area. If you want to try it out send mail to [EMAIL PROTECTED] substituting x with a valid zip code. You will recieve a response with the weather within seconds of the iMS server receiving your request. There is more information on our site (along with a 60-day demo). Please feel free to send me mail if you have any questions. Since you're in Florida it may also interest you that the South Florida CFUG uses iMS. Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server Get your free copy of iMS POST-SE Server from CoolFusion! - Original Message - From: "Jim Mixon" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 17, 2001 1:28 PM Subject: HotMail in CF Feedback please . . .! BEFORE I start on this project for this Client, any of you wizards know of any reason why a HotMail.com cannot be done entirely in CF? thanks . . . Jim Mixon - CEO APT POINT NET, Inc. "A Premiere InterNET Gateway" . . . [EMAIL PROTECTED] http://www.apt.net/ PO Box 160217 Hialeah, FL 33016 305-418-4111 FAX (305) 418-4111 press 7 and SEND! powered by Cold Fusion 4.01 . . . . feel the force! CF Hosting Now Available . . . . ! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
AW: [merger] Where to next?
Hi Eric, -Ursprüngliche Nachricht- Von: Eric Dawson [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 17. Januar 2001 17:55 An: CF-Talk Betreff: [merger] Where to next? [snip] Somewhere in this commentary I am crying out for someone to tell me what I want to hear in the language I understand. Short Term: what do I develop in. Medium Term: What will I develop in. Long Term: What will I develop in. How do I create a career path that supports my movement through these stages? How do I best focus my learning to be in the best position possible to take advantage of my next step environment. What are the trade offs as I move through my career development. [snip] Watch competitive tools. For application servers in order of preference. 1.) Zope 2.) ASP 3.) PHP Tomorrow. ? Next Year. ? [snip] one thing is for sure (and was sure before the merger!): You won't be developing in CF for the next 10 years. The same goes for PHP, ASP, etc. There will be more powerful servers and better tools to develop with. If we were to use the same language set for such a long period of time it would mean we're working on the slow side of the world. In fact it would be less interesting, even boring, and hardly 10% of the current developer community would exist. If you want to be a long term developer in the wide field of internet based apps (or whatever follows the thing we today call the internet), you got no choice but to keep watching, learning, re-orienting. As was said earlier in this discussion: We knew that CF would not be around forever. And also mentioned earlier: If CF will disappear I (too) trust in my abilities as a developer to do the same job in a different programming language. Regards, Chris ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: URLToken Algorithm
CFID is simply a sequential integer per machine CFTOKEN is, in default setting, assigned a random unsigned long int (0 x 2^32-1). If you're client needs to know the exact algorythm used to generate the random method, you'll probably have to ask an Allaire programmer. CF doesn't validate the CFTOKEN anymore (as of 4.5 I think, not sure) so you can use any value you want for it; as it's just to stop people hijacking sessions by entering in a sequential CFID. If you want, you can have a UUID appended to CFTOKEN by changing the UUIDToken key in the registry to 1 (I've never done this on a system w/o a registry before so not sure where it would be stored). [HKEY_LOCAL_MACHINE\Software\Allaire\ColdFusion\CurrentVersion\Clients\] So if you're really uptight about someone guessing a 10 digit random number, either use your own algorythm to generate the CFTOKEN or concat the UUID on to the end. Hope it helps :) -Original Message- From: Teng-Yan Loke [mailto:[EMAIL PROTECTED]] Sent: January 17, 2001 21:41 To: CF-Talk Subject: URLToken Algorithm My client would like to know the algorithm used to generate unique values and the ranges for CFID and CFTOKEN for session management. Any help please? Thanx. Loke, Teng-Yan | [EMAIL PROTECTED] | +65-2169725 E-commerce | novaSPRINT.com (S) Pte Ltd ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to encript source code?
Be aware though that the encryption at best is only a slight deterent to the completely uniformed. Due to the fact that code has to be decrypted by any system to run (meaning a set key is present) and done quickly so as not to impede performance (meaning a simple hash) decrypting is extremely simple. If you know much about crypto you can sit down and figure out how to reverse the hash in an afternoon, if you don't there are premade binaries or source for most platforms that decrypt the code. I'm not slamming the Allaire people here at all, they came up w/ the best they could I'm sure to balance the various aspects. -Original Message- From: Deb Dickerson [mailto:[EMAIL PROTECTED]] Sent: January 17, 2001 22:46 To: CF-Talk Subject: RE: How to encript source code? Use cfencode.exe in the \cfusion\bin directory (for 4.5x) It was cfcrypt.exe for 4.0x Debbie -Original Message- From: George Dong [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 8:25 PM To: CF-Talk Subject: How to encript source code? Hi there, If anyone can tell me to how encript source code, it can be done by cfstudio or need other application program? thank you very much. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Action on image
Hi All, How do i add a cfm action on an image. Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Netscape/CF_Twoselects oddity
I have never used the custom tag but wrote my own javascript to deliver the same functionality and i came across the same problem. I solved it by having the second select box have blank items in the original html/cf option value="-1"nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; option value="-1"nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; option value="-1"nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; option value="-1"nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; option value="-1"nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; Hope this works for you as well Allan Pichler -Original Message- From: Michael Kear [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 9:22 PM To: CF-Talk Subject: Netscape/CF_Twoselects oddity Puzzled I'm using CF_Twoselects to manipulate a pair of drop down menus, populated by a simple SELECT query. In IE, this page has two nice drop down menus, the right one is populated by javascript based on what is chosen in the left drop down. In Netscape 4.6 and 4.7 (and other NNs for all I know but I've only tested in those two so far) the left hand menu drops down nicely, the right menu comes down one line with tiny spin buttons and cycles through the options one by one. IT's annoying and at some resolutions difficult to read. Can anyone tell me why this happens? How come one menu is fine, the other is difficult? The url is http://www.choice.com.au/calculators/gsmphones1.cfm - look under "A. Search the database by make and model" Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks (p.s. don't put too much store by the data - this is test data only so far) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Please help....
At 4:18 PM -0600 1/17/01, Vani Kolli wrote: Hi all, Can anyone help me in doing the following. i have a page which has a form with 20 fields. When a user submits this form i want check one of the field against the database and then give an message. Based on user's response if it's yes then i should insert all the form values into database otherwise he should be directed to the same page for corrections. Right now i am doing is, after submitting the form i check against the database and then give a confirm (javascript function) box and based on the answer i go to the end page where i insert data or send back to the original page. Now i want to know is.. Can i use the form field values directly in the end page without passing thru the between page as hidden fields. If yes how?? Use session variables to maintain state between pages. And secondly whatever value i get from the javascript, can i use this value in cf. If yes how?? You can set the value of a form field with JavaScript before submitting the form any help on this would be appreciated. Vani ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia and Allaire to Merge
Click Search you get a list of names which you can drag drop into the various boxes. When I hit OK I get a 404 though :-( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 5:58 AM To: CF-Talk Subject: RE: Macromedia and Allaire to Merge What's it supposed to do? It just sits there for me. best, paul At 06:18 PM 1/17/01 -0500, you wrote: Take a look at this, and tell me Flash has no place in business apps: http://www.figleaf.com/development/flash4/orgchart.swf ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: business days
There isn't a function in SQL server. For such a function to work everywhere, you would need to tell it what country you're in supply data on what holidays are scheduled. Often, holidays cannot be determined programmatically are not known very far in advance. Reuters has this data somewhere. Not sure if it's on the Web. Maybe Bloomberg too? Nick -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 1:31 AM To: CF-Talk Subject: business days i am using SQLServer7. is there a function or custom tag to get the number of business days between 2 dates? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: any ideas?
No b/c IIF() is a true/false evaluation. Mod 3 would simply be the two colours in a false, true, true arrangement. -Original Message- From: Scott, Andrew [mailto:[EMAIL PROTECTED]] Sent: January 17, 2001 23:24 To: CF-Talk Subject: RE: any ideas? Wouldn't changing the mod 2 to mod 3 do the trick:-) regards Andrew Scott Senior Cold Fusion Application Developer -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: 18 January 2001 07:52 To: CF-Talk Subject: any ideas? does anyone know how i can make this tag output 3 colors instead of 2? tr bgcolor="#IIf(DirList.CurrentRow Mod 2, DE('E7'), DE('FAFAFA'))#" thanks, Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfstoredproc and cftransaction
I dont think there is any need, as I think a stored proc runs as a transaction anyway within sql server... -Original Message- From: Sandra Clark [mailto:[EMAIL PROTECTED]] Sent: 12 January 2001 20:20 To: CF-Talk Subject: cfstoredproc and cftransaction Does cftransaction work wrapped around cfstoredproc? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Replace function
Ramesh wddx_packet is a string but output is a complex data type depending on what the packet contains. You could operate on wddx_packet before converting it. Or would the ampersands invalidate the XML?... try it see. Nick -Original Message- From: ramesh deva [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 7:06 AM To: CF-Talk Subject: Replace function Hi Here i have wddx_packet variable, it contains text file So my question is can i replace whole file by using following code. Becos when i use this code cfwddx action="WDDX2CFML" input="#wddx_packet#" output="EZB_PO_WDDX" cfset EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Getting this error:- An error occurred while evaluating the expression: EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Error near line 310, column 11. Parameter 1 of function Replace must be a basic value, i.e., a string, number, logical, or date/time value i am here Thanx in advance Ramesh ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Replace function(very urgent)
And calm down! ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How will Macromedia resolve conflict of interest?
- Original Message - From: "Michael Dinowitz" [EMAIL PROTECTED] Sent: Thursday, January 18, 2001 4:42 AM Again, no disrespect, but the CF-Community fits in with the community speaking about this and the CF-Stock fits in with people talking about the financials. Yes - I agree that this list is fine for discussing the merger in general (although some people are finding the moise levels too high it seems), and clearly CF-Stock is the place for financials. But I would_really_like to see a list though_totally_focussed_on ideas and brainstorming on the products, we, as developers, would like to see arise as a result of this great merger. A list which members of staff of the merged Allaire/Macromedia entity can monitor and/or participate in if they like, without having to sift through all of the hundreds of other general posts on the list. We are the companies primary customers, and I am sure they would appreciate knowing what our thoughts and aspirations are for future and new products, rather than having to decide in other ways. I don't know how much would come out of it in tangible terms, if anything, but at least we can throw ideas and suggestions around, and if Macromedia want to take any of them up all well and good. But unless we tell them what we want, they won't know, and at the very least they can't turn round later in retrospect and say we didn't think of that, or we did not know developers wanted that. How about setting up such a list Michael? What do others think? Adrian Cooper. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Form Post with Image
Hi all , How can I post a form with an image instead of a button. Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Date problem
Thanks for the replies/suggestions everyone. I think I'm gonna go with the 3-fields setup for now. Neil - Original Message - From: "Jennifer" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 17, 2001 11:42 AM Subject: Re: Date problem I haven't come across this but I do see an issue in your example that might cause it. The first part of a date (in US format which is the default) is the month and there is no 17th month. Perhaps CF server recognizes that 17 is not a month and decides that it must be a year instead. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Replace function(very urgent)
have u try this: cfset EZB_PO_WDDX = #Replace(EZB_PO_WDDX,"~","","ALL")# -Original Message- From: ramesh deva [mailto:[EMAIL PROTECTED]] Sent: Thursday, 18 January 2001 3:07 PM To: CF-Talk Subject: Replace function(very urgent) Hi Here i have wddx_packet variable, it contains text file So my question is can i replace whole file by using following code. Becos when i use this code cfwddx action="WDDX2CFML" input="#wddx_packet#" output="EZB_PO_WDDX" cfset EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Getting this error:- An error occurred while evaluating the expression: EZB_PO_WDDX = Replace(#EZB_PO_WDDX#,"~","","ALL") Error near line 310, column 11. Parameter 1 of function Replace must be a basic value, i.e., a string, number, logical, or date/time value i am here Thanx in advance Ramesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Remoting and Location of CFML Files
Suppose I have set up a web server (dog) with the CF plug-in for remote CF processing, and a CF server (cat) with the network listener module running. LOCALPATH and REMOTEPATH are both set to "c:\inetpub\wwwroot". Which machine should I place my CFM files? As of now, it seems like they have to reside on cat, but my HTML and image files can be on the web server. If this is true, wouldn't it seem confusing when it comes to specifying paths? Loke, Teng-Yan | [EMAIL PROTECTED] | +65-2169725 E-commerce | novaSPRINT.com (S) Pte Ltd ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Post with Image
Like this; input name="submit" type="image" src="image.gif" border="0" (border=0 is for versions of Netscape) Kath Katherine Maltby Senior Producer -- United Kingdom http://www.thoughtbubble.co.uk/ Ph: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Ph: +64 (0) 9 419 4235 The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 -Original Message- From: Albert K Arhin [mailto:[EMAIL PROTECTED]] Sent: 18 January 2001 09:56 To: CF-Talk Subject: Form Post with Image Hi all , How can I post a form with an image instead of a button. Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Netscape/CF_Twoselects oddity
Hi Mike, when you create a SELECT-box without options and afterwards add options with e.g. JavaScript, Netscape always shows this behaviour. Workaround: Create the number of empty options you need for the SELECT-box to look nicely then delete them with document.myForm.myBox.options.length = 0; HTH, Chris --Original Message-- From: Michael Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: January 18, 2001 5:21:52 AM GMT Subject: Netscape/CF_Twoselects oddity Puzzled I'm using CF_Twoselects to manipulate a pair of drop down menus, populated by a simple SELECT query. In IE, this page has two nice drop down menus, the right one is populated by javascript based on what is chosen in the left drop down. In Netscape 4.6 and 4.7 (and other NNs for all I know but I've only tested in those two so far) the left hand menu drops down nicely, the right menu comes down one line with tiny spin buttons and cycles through the options one by one. IT's annoying and at some resolutions difficult to read. Can anyone tell me why this happens? How come one menu is fine, the other is difficult? The url is http://www.choice.com.au/calculators/gsmphones1.cfm - look under "A. Search the database by make and model" Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks (p.s. don't put too much store by the data - this is test data only so far) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Action on image
Is this what you're looking for? On the template where you're viewing the image: img src="template.cfm" border=0 On template.cfm: some cfcode /some cfcode cflocation url="theimage.gif" addtoken="no" rgds * Holger Lockertsen, Solutions Developer * Pixelduck AS - Nedre Slottsgate 5, N-0157 OSLO, Noreg/Norway * 23 31 03 04 / 91 83 20 51 * [EMAIL PROTECTED] * http://www.pixelduck.com/ -Original Message- From: Albert K Arhin [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 9:36 AM To: CF-Talk Subject: Action on image Hi All, How do i add a cfm action on an image. Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: My impressions of the MM/CF conference call
Conference calls following earnings are geared to Wall Street and stock holders. Business should be the focus. Bill Reichard Willow Gold [EMAIL PROTECTED] http://www.willowgold.com In a message dated 1/17/01 8:13:08 PM Eastern Standard Time, [EMAIL PROTECTED] writes: My guts tell me the merger was for business not technology reasons. A significant portion of the questions were corporate related. I would have felt more comfortable is there was more dialogue and directions in regards to CF/MM's position towards MS .net, java, and the UNIX world. Does anyone feel the same? Dave Adams CFUG Ottawa, Canada ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Form Post with Image
You can execute the onclick event of the image to call the submit method of the form. In Javescript you would use something like: img src="someimage.gif" onclick="document.frmYourForm.submit();" Bill Reichard Willow Gold [EMAIL PROTECTED] http://www.willowgold.com In a message dated 1/18/01 5:53:12 AM Eastern Standard Time, [EMAIL PROTECTED] writes: Hi all , How can I post a form with an image instead of a button. Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Post with Image
input type="Image" src="image.ext" or an onclick even to submit the form w/ JS. Both have their drawbacks, you can also use CSS to change the style of the submit button itself. -Original Message- From: Albert K Arhin [mailto:[EMAIL PROTECTED]] Sent: January 18, 2001 04:56 To: CF-Talk Subject: Form Post with Image Hi all , How can I post a form with an image instead of a button. Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Post with Image
Avoid this if you can. Only takes one person without JS enabled and bingo...they can't submit the form...not good... -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 11:31 AM To: CF-Talk Subject:Re: Form Post with Image You can execute the onclick event of the image to call the submit method of the form. In Javescript you would use something like: img src="someimage.gif" onclick="document.frmYourForm.submit();" Bill Reichard Willow Gold [EMAIL PROTECTED] http://www.willowgold.com In a message dated 1/18/01 5:53:12 AM Eastern Standard Time, [EMAIL PROTECTED] writes: Hi all , How can I post a form with an image instead of a button. Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT:Access SQL Extraction VB Script
This was posted sometime ago, could somebody email me directly or give me a link to be able to download this script that creates the SQL for a database? Thanks Best Regards, Adam Reynolds ColdFusion Web Developer ISMG Development, Unilever London ( +44 20 7822 x5450 m: +44 7973 386620 * [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: duplicating inserts
I cant think of a reason why an insert query should be cached, so any caching would probably be uneccessary. A solution to your problem would be to check for the existense of a record before inserting or, if there is no reason why the user would validly need to go back, make the page content expire and if they hit back, they will need to refresh. Which will cause any form fields to clear and there would be nothing to insert then... This snippet does the trick for me. CFHEADER NAME="Expires" VALUE="Mon, 06 Jan 1990 00:00:01 GMT" CFHEADER NAME="Pragma" VALUE="no-cache" CFHEADER NAME="cache-control" VALUE="no-cache" There's always one problem with relying on this sort of solution - people often set their browser to "Never" to retrieve a new version of a file, this over-rides any of the meta settings which means they can go Back any time they want and re-submit Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: business days
Alex, Here is how to do it in SQL Server (assuming Saturday and Sunday are not business days) Select count(*) as daycount From DateTable Where DateTable.EntryDatetime = [beginnindate] AND DateTable.EntryDateTime = [enddate] AND ((DateName(dw, DateTable.EntryDatetime) != 'Saturday') AND (DateName(dw, DateTable.EntryDatetime) != 'Sunday')) -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 8:31 PM To: CF-Talk Subject: business days i am using SQLServer7. is there a function or custom tag to get the number of business days between 2 dates? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cross Browser DHTML Menu
Here's an example that worked for me: http://www.webreview.com/1998/07_24/webauthors/07_24_98_10.shtml -Original Message- From: Raymond B. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 4:40 PM To: CF-Talk Subject: RE: Cross Browser DHTML Menu http://www.dynamicdrive.com http://www.dynamicdrive.com/dynamicindex1/index.html -- Menu and Nav scripts They have a host of free scripts. I'm not much on the front end display side but I'm sure they'll have something you can use "out of the box" or adapt easily. -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: January 17, 2001 11:31 To: CF-Talk Subject: OT: Cross Browser DHTML Menu Guys, I need a cross browser DHTML menu asap that can do drop down, and slide menus. Menu |-Item1 |-Item2 |-Item3--|-Item5 |-Item4 |-Item6 Does anyone know of a good simple API or generator, that has been tested (the important part of the question) on NN4+ and IE4+, that they would recommend? Please don't suggest CF_DHTMLMenu as it specifically states that it's not for NN. Thanks Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cross Browser DHTML Menu
Be careful you get one that is NN6 compatible. There are a lot of scripts out there and only a few I have seen that work with any degree of success on NN6 N ! --- Neil Clark Senior Web Applications Engineer ColdFusion / Spectra / XML mcb digital [Allaire Premier Partner] Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] http://www.mcbdigital.com --- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia and Allaire to Merge
What Flash software packages can be used to do this? Can the free Flash 5 Print Authoring Kit do it? best, paul At 03:29 PM 1/17/01 -0800, you wrote: Actually Flash 5 is very usefull for all those things, the action script in it allows you to connect to a database via middleware, like coldfusion, so your content can be just as dynamic as any site that is database driven. I have seen demos of working input forms and shopping carts that were 100% flash using CF for database interaction. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia and Allaire to Merge
Jeez, what is all this talk of Flash - it is a TERRIBLE program; far too time consuming and cumbersome. uurgggh N ! --- Neil Clark Senior Web Applications Engineer ColdFusion / Spectra / XML mcb digital [Allaire Premier Partner] Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] http://www.mcbdigital.com --- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Adam, you got to be kidding?
You actually develop with the mindset that a user might not have scripting enabled? Ouch! My guess would be that at a minimum, 98% of all users have scripting enabled. So, you would forfeit the capability of client-side data validation, client-side DOM manipulation, etc.? You would add unneeded round trips to your server to accomplish scripting, validation, etc.? So 98% of your users will pay the Performance price for the 2% of your users? Not to mention the extra load on your server and the wasted bandwidth. Not a good idea ... Please! Bill Reichard Willow Gold [EMAIL PROTECTED] http://www.willowgold.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Great idea Adam! [Was: Re: Adam, you got to be kidding?
Adam, I applaud you for doing things the right way - assuming that the client won't have javascript enabled. As a web developer, as well as a user of a variety of browsers in which there either is no javascript, minimal javascript, or javascript which works differently from version to version (lynx, netscape communicator 4.x and 6.x, and IE 5.x on Solaris), as well as a user who encounters users regularly who work in government or other industries where security requires them to disable both java and javascript, I applaud those doing the right thing - using javascript only in arenas where they total, 100% control of the user's environment. To dismiss any user who doesn't configure their browser to meet the the server's requirements seems to be the height of arrogance - similar to the car dealer who won't talk to a customer unless they are wearing a 3 piece suit, regardless of how much money they have to spend... -- Larry W. Virden URL: mailto:[EMAIL PROTECTED] URL: http://www.purl.org/net/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Macromedia Coldfusion
But you'll have to admit "Macromedia Coldfusion" is sexier than "Macromedia Confusion" ;-) best, paul At 07:00 PM 1/17/01 -0500, you wrote: Lol Macromedia Coldfusion does not sound as Sexy as Allaire Coldfusion =) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Flash 5.0 timeconsuming and cumbersome? Naaaahh....
LOL!! What the hey do you use to develop Flash man? Flash is great for even simple stuff on webpages, and the new Actions in Flash 5 are even better. Its a programming language, that you just have to learn like any other, but it isn't that difficult. It usually involves very simple IF THen statements that jump you between frames in the animation. Think about each animation frame like a Line Number in QBasic, and you just GOTO different portions depending on what events are triggered. That's basic Flash Programming there. It just gets complicated to actually come up with all those cool effects yourself, from scratch. THAT takes a lot of time, and trial and error. So leave that for the artists and the physicists :) And use sites such as www.flashkit.com , products like Swift 3D, Wildform and Swish to build your simple Flash files quickly and easily. This gets over the initial hurdle of learning the interface. You can also use Livemotion 1.0 from Adobe that gives you the layered goodness you're accustomed to in all the rest of Adobe's products. You don't necessarily have to use Macromedia Flash 5.0's development program, to create Flash 5.0 whizz-bang thingies (applets? :) ). That said, Macromedia's Flash 5.0's development interface needs a LOT of work to make it more userfriendly. SOmething that they should realise with the proliferation of tools such as Swish and Wildform. Of course the diehard Flash Developers may not appreciate them putting such ease of use functionality in the proggy, and making everyone a Flash-Head...but it would be a good thing for macromedia..and Allaire..no? :) If you want to add interactivity, then you still have to dip your hand into the programming teapot, but basic activity with Buttons etc. is preeetty easy. Anyways..I really disagree that Flash is a Terrible program, at least based on the issues you brought up: Time Consuming and Cumbersome. :) Have a great day! -Gel, who is in a FLASHY mood. *grips his trenchcoat with a lacivious stare at those around him* Hey..hey you..yeah..c'mere.. *FLASH!* ;-P -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, 18 January 2001 09:17 To: CF-Talk Subject: RE: Macromedia and Allaire to Merge Jeez, what is all this talk of Flash - it is a TERRIBLE program; far too time consuming and cumbersome. uurgggh N ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia Coldfusion
What about MacroFusion or ColdMedia? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 18 January 2001 13:33 To: CF-Talk Subject: Re: Macromedia Coldfusion But you'll have to admit "Macromedia Coldfusion" is sexier than "Macromedia Confusion" ;-) best, paul At 07:00 PM 1/17/01 -0500, you wrote: Lol Macromedia Coldfusion does not sound as Sexy as Allaire Coldfusion =) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
string to number
I am trying to get a variable to work that would tell me how many rooms a person would need if they has X amount of people in their party. Here is the Code I am working with: CFSET Grp=("form.adult + form.children") CFSET SmRmRq=0 CFIF Grp LTE 4 CFSET SmRmRq=1 CFELSEIF (Grp GTE 5) and (Grp LTE 8) CFSET SmRmRq=2 CFELSEIF (Grp GTE 9) and (Grp LTE 12) CFSET SmRmRq=3 CFELSEIF (Grp GTE 13) and (Grp LTE 16) CFSET SmRmRq=4 CFELSEIF (Grp GTE 17) and (Grp LTE 20) CFSET SmRmRq=5 CFELSEIF (Grp GTE 21) and (Grp LTE 24) CFSET SmRmRq=6 CFELSEIF (Grp GTE 25) and (Grp LTE 28) CFSET SmRmRq=7 CFELSEIF Grp GTE 29 CFSET SmRmRq=8 /CFIF The problem I am having is when you output grp it gives you the total of form.adult + form.children. But when you use grp to set the variable SmRmRq it goes to a string "number + number" and will not accurately convert the variable. Is there a way to change the grp to a number? In Javascript It would be something like Var = (parseInt(form.adult) + parseInt(form.children)) Thanks in advance for any assistance, Steve Doran :) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Adam, you got to be kidding?
How do you explain that to an important customer when a user with a javascriptdisabled browser who tried to submit a feedbackform couldn't get it to work, and phoned the company complaining about it? I agree that some funcionality can and should be done on the clientside using javascript, but I always develope webpages with basic functionality that everyone can use. Submitting a form is in my mind considered basic functionality. Crossbrowser-compatibility is not only a question of brand, but of version and enabled options as well. rgds * Holger Lockertsen, Solutions Developer * Pixelduck AS - Nedre Slottsgate 5, N-0157 OSLO, Noreg/Norway * +47 23 31 03 04 / 91 83 20 51 * [EMAIL PROTECTED] * http://www.pixelduck.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 2:15 PM To: CF-Talk Subject: Adam, you got to be kidding? You actually develop with the mindset that a user might not have scripting enabled? Ouch! My guess would be that at a minimum, 98% of all users have scripting enabled. So, you would forfeit the capability of client-side data validation, client-side DOM manipulation, etc.? You would add unneeded round trips to your server to accomplish scripting, validation, etc.? So 98% of your users will pay the Performance price for the 2% of your users? Not to mention the extra load on your server and the wasted bandwidth. Not a good idea ... Please! Bill Reichard Willow Gold [EMAIL PROTECTED] http://www.willowgold.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia and Allaire to Merge
Jeez, what is all this talk of Flash - it is a TERRIBLE program; far too time consuming and cumbersome. uurgggh Flash has one use, and one use only - making pretty animations that are there to pad an otherwise bland page One of our clients wanted us to make a completely Flash site - we told them how long it would take to make updates (and thus us charging them), so they took the option to do the updates themselves (surprisingly) Occasionally you see something interesting in Flash, but it's an incredible rarity... I feel sorry for companies that only work in Flash, as they can't tell clients who has been where on their site - either by something like WebTrends or by logging to a database. Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia Coldfusion
i'm just glad that CF has a 'whizzy' name already, so MM wont have to give it a jazzy one from their extensive library or names that Adobe thought were too stupid :-) N ! --- Neil Clark Senior Web Applications Engineer ColdFusion / Spectra / XML mcb digital [Allaire Premier Partner] Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] http://www.mcbdigital.com --- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Storing/Encrypting Credit Cards
Does able commerce store credit card info in the database? If so, what security do they use? Rich -Original Message- From: Jennifer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 11:51 PM To: CF-Talk Subject: RE: Storing/Encrypting Credit Cards At 06:11 PM 1/17/01 -0500, you wrote: On 1/17/01, Jeremy Allen penned: Next, you should use a public/private key system and encrypt the credit card with a public key, store the private key's TOTALLY off the server. Hi Jeremy. Just curious. If the private key is created with a sufficient passphrase, how hard would it be for a cracker to use the private key to decrypt the data? It seems it would be difficult to use any sort of online encryption/decryption routine without the private keys stored on the server. Part of the problem is that when you store the private key totally off the server as stated, such as, behind a firewall that lies behind the server, protected from network entry, you have an issue retrieving the Credit Card info for the sake of the user, which could be the problem in this case. Encryption is not as much of a problem as decryption. You can set up your network to allow decryption behind the firewall behind the server but that means that you can't put the CC number in the form, which is what this is normally used for. The server can't make requests to the other side of the firewall, which is why the private key is safe. Basically it's a big nasty mess. Besides, if your encryption scheme isn't strong enough a hacker doesn't need a private key. You could store the last four digits in the database unencrypted and send that to the browser for user confirmation but your order processing would have to be on the other side of the firewall. Storing credit cards = bad. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MM/ALLAIRE No more Studio?
It sounds like Studio 5 is going to UltraDev?? Rick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Netscape/CF_Twoselects oddity
On my Netscape® Communicator 4.75 the right menu comes down one line with tiny spin buttons, but I had to manually cycle thru the options one by one (which might be what you meant to say). best, paul At 04:21 PM 1/18/01 +1100, you wrote: In Netscape 4.6 and 4.7 (and other NNs for all I know but I've only tested in those two so far) the left hand menu drops down nicely, the right menu comes down one line with tiny spin buttons and cycles through the options one by one. IT's annoying and at some resolutions difficult to read. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: string to number
You want this: CFSET Grp = form.adult + form.children When setting quotes around it, CF assumes it's a string. rgds * Holger Lockertsen, Solutions Developer * Pixelduck AS - Nedre Slottsgate 5, N-0157 OSLO, Noreg/Norway * 23 31 03 04 / 91 83 20 51 * [EMAIL PROTECTED] * http://www.pixelduck.com/ -Original Message- From: Steve Doran [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 2:36 PM To: CF-Talk Subject: string to number I am trying to get a variable to work that would tell me how many rooms a person would need if they has X amount of people in their party. Here is the Code I am working with: CFSET Grp=("form.adult + form.children") CFSET SmRmRq=0 CFIF Grp LTE 4 CFSET SmRmRq=1 CFELSEIF (Grp GTE 5) and (Grp LTE 8) CFSET SmRmRq=2 CFELSEIF (Grp GTE 9) and (Grp LTE 12) CFSET SmRmRq=3 CFELSEIF (Grp GTE 13) and (Grp LTE 16) CFSET SmRmRq=4 CFELSEIF (Grp GTE 17) and (Grp LTE 20) CFSET SmRmRq=5 CFELSEIF (Grp GTE 21) and (Grp LTE 24) CFSET SmRmRq=6 CFELSEIF (Grp GTE 25) and (Grp LTE 28) CFSET SmRmRq=7 CFELSEIF Grp GTE 29 CFSET SmRmRq=8 /CFIF The problem I am having is when you output grp it gives you the total of form.adult + form.children. But when you use grp to set the variable SmRmRq it goes to a string "number + number" and will not accurately convert the variable. Is there a way to change the grp to a number? In Javascript It would be something like Var = (parseInt(form.adult) + parseInt(form.children)) Thanks in advance for any assistance, Steve Doran :) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: string to number
I think what you want CFSET Grp=(form.adult + form.children). (no quotes) ~Simon Simon Horwith Allaire Certified ColdFusion Instructor Certified ColdFusion Developer Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Steve Doran [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 8:36 AM To: CF-Talk Subject: string to number I am trying to get a variable to work that would tell me how many rooms a person would need if they has X amount of people in their party. Here is the Code I am working with: CFSET Grp=("form.adult + form.children") CFSET SmRmRq=0 CFIF Grp LTE 4 CFSET SmRmRq=1 CFELSEIF (Grp GTE 5) and (Grp LTE 8) CFSET SmRmRq=2 CFELSEIF (Grp GTE 9) and (Grp LTE 12) CFSET SmRmRq=3 CFELSEIF (Grp GTE 13) and (Grp LTE 16) CFSET SmRmRq=4 CFELSEIF (Grp GTE 17) and (Grp LTE 20) CFSET SmRmRq=5 CFELSEIF (Grp GTE 21) and (Grp LTE 24) CFSET SmRmRq=6 CFELSEIF (Grp GTE 25) and (Grp LTE 28) CFSET SmRmRq=7 CFELSEIF Grp GTE 29 CFSET SmRmRq=8 /CFIF The problem I am having is when you output grp it gives you the total of form.adult + form.children. But when you use grp to set the variable SmRmRq it goes to a string "number + number" and will not accurately convert the variable. Is there a way to change the grp to a number? In Javascript It would be something like Var = (parseInt(form.adult) + parseInt(form.children)) Thanks in advance for any assistance, Steve Doran :) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Great idea Adam! [Was: Re: Adam, you got to be kidding?
Let me guess ... the good of the many does NOT outweigh the good of the few! Geez ... do you develop all your web pages strictly in English? Hmmm ... talk about 'the height of arrogance'. Bill Reichard Willow Gold [EMAIL PROTECTED] http://www.willowgold.com In a message dated 1/18/01 8:25:55 AM Eastern Standard Time, [EMAIL PROTECTED] writes: Adam, I applaud you for doing things the right way - assuming that the client won't have javascript enabled. As a web developer, as well as a user of a variety of browsers in which there either is no javascript, minimal javascript, or javascript which works differently from version to version (lynx, netscape communicator 4.x and 6.x, and IE 5.x on Solaris), as well as a user who encounters users regularly who work in government or other industries where security requires them to disable both java and javascript, I applaud those doing the right thing - using javascript only in arenas where they total, 100% control of the user's environment. To dismiss any user who doesn't configure their browser to meet the the server's requirements seems to be the height of arrogance - similar to the car dealer who won't talk to a customer unless they are wearing a 3 piece suit, regardless of how much money they have to spend... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia and Allaire to Merge
NOW, it does. It didn't last night. I guess it wasn't quite ready for prime time then. Thanks. best, paul PS I get the 404 on OK, too (They probably don't want the changes to be permanent.) At 09:18 AM 1/18/01 +, you wrote: Click Search you get a list of names which you can drag drop into the various boxes. When I hit OK I get a 404 though :-( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 5:58 AM To: CF-Talk Subject: RE: Macromedia and Allaire to Merge What's it supposed to do? It just sits there for me. best, paul At 06:18 PM 1/17/01 -0500, you wrote: Take a look at this, and tell me Flash has no place in business apps: http://www.figleaf.com/development/flash4/orgchart.swf ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: random record
Your method is actually the one that I ended up using, not because I saw that there may be a problem with the other method, but because it seemed a little more straight forward to implement. It seems to be working just fine. JLB -Original Message- From: BORKMAN Lee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 5:50 PM To: CF-Talk Subject: RE: random record Hi Mark, howzit going? ;-) Actually, I think your method (choosing a random number between 1 and MaxID, then going for the first record = MaxID) could lead to some very non-random behaviour when you have large gaps in your IDs. The first ID after a large gap will be heavily over-used. I still like my method, sent before. Should actually be random (within limits of RandRange() function). Watcha reckon? Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork -Original Message- From: Warrick, Mark [mailto:[EMAIL PROTECTED]] . !--- get the max record id from the table --- cfquery name="max" datasource="#session.dsn#" SELECT max (CONTACT_ID) as maxid FROM CONTACTS /cfquery !--- set a random number --- cfset randnum = RandRange(1,max.maxid) !--- Then select the a record where the recordid equal to or greater than the random number. --- cfquery name="random_record" datasource="#session.dsn#" SELECT MIN (CONTACT_ID) as random_record FROM contacts where CONTACT_ID = #randnum# /cfquery cfoutput query="random_record" #random_record# /cfoutput IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorised alterations to this e-mail or attachment to it. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MM/ALLAIRE No more Studio?
At 08:42 AM 1/18/2001 -0500, Richard L Smith wrote: It sounds like Studio 5 is going to UltraDev?? presently, studio 4.5 can be tightly integrated with ultradev. so ultradev 5 won't be a huge leap. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Session var resources
Anyone have a good site that tells all there is about session and client vars. I need to learn when is a good time to use them and how to implement them at that time. Jim Becker ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
More on Data problem
Just in case anyone's having the same issue, Bjørn Jensen pointed me in the direction of the setlocale() function which seems to do the trick, as below. This will now treat a form date as dd/mm/yy regardless of 4 or 2-digit years. cfset previous_locale = SetLocale("English (UK)") CFOUTPUTLocale has changed from #previous_locale# to #GetLocale()#/CFOUTPUT cfset US_Date = ParseDateTime(form_date) cfset UK_Date = LSParseDateTime(form_date) -- Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sessions
THanks all. Here is my application.cfm code as it is. It may not be pretty. In a perfect world I want to check to see the sessionid variable is active(aka the user is already here). If so then update a table. If not i want it to find a number and create one(sessionid). Then add it to the table. Thanks !---Application.cfm page. Sets variables--- CFAPPLICATION NAME="TCOM" SESSIONMANAGEMENT="YES" SESSIONTIMEOUT="#CREATETIMESPAN(0,0,30,0)#" CFIF NOT ISDEFINED('SESSION.USER_NAME') CFPARAM NAME="SESSION.USER_NAME" DEFAULT="na" CFPARAM NAME="SESSION.NAME" DEFAULT="na" CFPARAM NAME="SESSION.SECUREDGROUP" DEFAULT="na" CFPARAM NAME="SESSION.SESSIONID" DEFAULT="na" CFPARAM NAME="SESSION.LOGIN" DEFAULT="na" CFPARAM NAME="SESSION.ORGROUP" DEFAULT="na" CFSET DIFF = 'NO' CFLOOP CONDITION="DIFF EQ 'NO'" CFSET IDNUMBER= #RANDRANGE(1, 1000)# CFQUERY NAME="ID" DATASOURCE="PCNET" SELECT IDNUMBER FROM tblsessions WHERE IDNUMBER = #IDNUMBER# /CFQUERY CFIF #ID.RECORDCOUNT# IS 0 CFSET DIFF = 'Yes' /CFIF /CFLOOP CFLOCK TIMEOUT="30" NAME="#SESSION.USER_NAME#" CFSET SESSION.USER_NAME="#IDNUMBER#" /CFLOCK CFLOCK TIMEOUT="30" NAME="#SESSION.SESSIONID#" CFSET SESSION.SESSIONID="#IDNUMBER#" /CFLOCK CFSET TIMET= TIMEFORMAT(NOW(), 'HH:MM:SS') CFSET DATED= DATEFORMAT(NOW(), 'mm-dd-') CFQUERY DATASOURCE="PCNET" NAME="INSERT" INSERT INTO tblsessions(TIMEIN, IDNUMBER, IPADDRESS, DATED) VALUES('#VARIABLES.TIMET#', #SESSION.USER_NAME#, '#REMOTE_ADDR#', '#VARIABLES.DATED#') /CFQUERY CFELSE CFSET TIMEL= TIMEFORMAT(NOW(), 'HH:MM:SS') CFQUERY NAME="UPDATE" DATASOURCE="PCNET" UPDATE tblsessions SET LASTTIME ='#VARIABLES.TIMEL#' WHERE IDNUMBER= #SESSION.USER_NAME# /CFQUERY /CFIF CFIF ISDEFINED("Cookie.CFID") AND ISDEFINED("Cookie.CFTOKEN") CFSET CFID_LOCAL = COOKIE.CFID CFSET CFTOKEN_LOCAL = COOKIE.CFTOKEN CFCOOKIE NAME="CFID" VALUE="#cfid_local#" CFCOOKIE NAME="CFTOKEN" VALUE="#cftoken_local#" /CFIF [EMAIL PROTECTED] 01/17/01 11:57AM MM Michael, Can we see the application.cfm code? And/Or a link to the offending page. BB, --K -Original Message- From: Michael Ross [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 8:53 PM To: CF-Talk Subject: Re: Sessions opps I am sorry to everyone. It was pointed to me that my message might be viewed differently than I intended. My message didn't really show that I do have a problem. My problem is that on the first call of the page my sessionid is 49494949 (or eight numbers only). The second time any page is called I get the one below tcom_686_#. Why is it changing on me I don't want it too.??How is that generated anyway. Sorry to sound rude before... Thanks [EMAIL PROTECTED] 01/17/01 12:06PM I have an app that sets a session id. The first time you call any page(which uses application.cfm)it sets a number and works great. If i refresh the page I get a var that looks like this tcom_686_### where tcom is the application name, 686 is a number that is being incremented everytime I call a new session. and changes randomly. Anyone ever seen this??? Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia and Allaire to Merge
Ah...what might have been! The textual content could have been managed by Spectra/CF with the Flash objects being dynamically updated by Generator...as Fig Leaf has done successfully in several implementations. The logging of dynamic content items could have been accomplished through a variety of services -- including Spectra's Business Intelligence systems. Now you can tell your client that with the merger, integrating these platforms will only be getting easier...reducing their overall costs of development. Regards, Steve Drucker CEO Fig Leaf Software http://www.figleaf.com -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 8:41 AM To: CF-Talk Subject: RE: Macromedia and Allaire to Merge Jeez, what is all this talk of Flash - it is a TERRIBLE program; far too time consuming and cumbersome. uurgggh Flash has one use, and one use only - making pretty animations that are there to pad an otherwise bland page One of our clients wanted us to make a completely Flash site - we told them how long it would take to make updates (and thus us charging them), so they took the option to do the updates themselves (surprisingly) Occasionally you see something interesting in Flash, but it's an incredible rarity... I feel sorry for companies that only work in Flash, as they can't tell clients who has been where on their site - either by something like WebTrends or by logging to a database. Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server export/import preserving diagrams
You can get a script to export diagrams from http://www.swynk.com/sqlhome/7library.asp Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Adam, you got to be kidding?
How do you explain that to an important customer when a user with a javascriptdisabled browser who tried to submit a feedbackform couldn't get it to work, and phoned the company complaining about it? I agree that some funcionality can and should be done on the clientside using javascript, but I always develope webpages with basic functionality that everyone can use. Submitting a form is in my mind considered basic functionality. Crossbrowser-compatibility is not only a question of brand, but of version and enabled options as well. We do our validation server-side as we have a LOT of visitors to a couple of our sites who have JavaScript, Java and Cookies disabled, so we have to work around this Having everything in JS and saying "Well, the people without it just won't be able to use the system" is not only ignorant, but completely against Customer Service Are you going to stop someone from spending several thousand dollars (or whatever) on a shopping cart just because you want to only use JS validation? I'd suggest that your client asks you for the money for lost sales just because you rely on an option that can be turned off easily... then see how much you rely on client side validation g Also, with JS validation, someone smart enough could look into the code and see if there are any loop-holes If in doubt, use a mixture of client and server side validation, but never rely on just one... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ASpUpload
Anyone using ASPUpload via CF? If so could you tell me how so I can try using it? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Great idea Adam! [Was: Re: Adam, you got to be kidding?
There's no point putting 'basic' functionality on a web site that's supposed to be for all of your users if it won't work on some of their browsers. How you can expect users to go back to your website if half of it doesn't work because they haven't got the right settings or the latest browser? This seems to be a very narrow minded attitude to have and will cost you potential customers and clients. Granted, a lot of the time you can have things that won't work on some browsers, but only if there's an alternative for people who may not have right settings and it doesn't loose any functionality or the message that you're trying to convey to the user. Kath Katherine Maltby Senior Producer -- United Kingdom http://www.thoughtbubble.co.uk/ Ph: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Ph: +64 (0) 9 419 4235 The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 18 January 2001 13:52 To: CF-Talk Subject: Re: Great idea Adam! [Was: Re: Adam, you got to be kidding? Let me guess ... the good of the many does NOT outweigh the good of the few! Geez ... do you develop all your web pages strictly in English? Hmmm ... talk about 'the height of arrogance'. Bill Reichard Willow Gold [EMAIL PROTECTED] http://www.willowgold.com In a message dated 1/18/01 8:25:55 AM Eastern Standard Time, [EMAIL PROTECTED] writes: Adam, I applaud you for doing things the right way - assuming that the client won't have javascript enabled. As a web developer, as well as a user of a variety of browsers in which there either is no javascript, minimal javascript, or javascript which works differently from version to version (lynx, netscape communicator 4.x and 6.x, and IE 5.x on Solaris), as well as a user who encounters users regularly who work in government or other industries where security requires them to disable both java and javascript, I applaud those doing the right thing - using javascript only in arenas where they total, 100% control of the user's environment. To dismiss any user who doesn't configure their browser to meet the the server's requirements seems to be the height of arrogance - similar to the car dealer who won't talk to a customer unless they are wearing a 3 piece suit, regardless of how much money they have to spend... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia and Allaire to Merge
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hey Dave, I wasn't trying to say that Flash has no business applications. I was replying to previous posts where I was under the assumption that people were thinking that Flash would literally become the defacto standard for the display of information in a web page, which I think you'd agree is not and will not become the case. In fact, I've used Generator Spectra here at MINDSEYE for displaying information and showing dynamically-generated info on multiple sites. The Generator/Flash/CF combo is a powerful one, and I must say that I think the most powerful example of a business application I've seen built using Generator is the site you've done for Rydex Funds. Respectfully, AJ Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. phn617.350.0339 fax617.350.8884 icq66172567 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Adam, you got to be kidding?
how can you develop assuming that scripting is ON? if 2% of your customers have scripting disabled (just to use your numbers for a mo'), that's 2% of the people who WON'T be coming back to your site to buy something. that's like refusing to put in handicapped access ramps, because hey, only a small portion of the population is disabled, and i don't care if they can't get into my store. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 8:15 AM To: CF-Talk Subject: Adam, you got to be kidding? You actually develop with the mindset that a user might not have scripting enabled? Ouch! My guess would be that at a minimum, 98% of all users have scripting enabled. So, you would forfeit the capability of client-side data validation, client-side DOM manipulation, etc.? You would add unneeded round trips to your server to accomplish scripting, validation, etc.? So 98% of your users will pay the Performance price for the 2% of your users? Not to mention the extra load on your server and the wasted bandwidth. Not a good idea ... Please! Bill Reichard Willow Gold [EMAIL PROTECTED] http://www.willowgold.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Adam, you got to be kidding?
It really depends. I've taken over sites where business logic was done in Javascript. That is horrendous and was a nightmare to sort some of the bugs. Javascript should be used to make things pretty and if you must do it, some validation (just to make life easy), but any data validation should also be backed up with server side validation cos you know somebody will be doing something that messes up your site or more precisely the way you view your site. -Original Message- From: Holger Lockertsen [SMTP:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 1:39 PM To: CF-Talk Subject:RE: Adam, you got to be kidding? How do you explain that to an important customer when a user with a javascriptdisabled browser who tried to submit a feedbackform couldn't get it to work, and phoned the company complaining about it? I agree that some funcionality can and should be done on the clientside using javascript, but I always develope webpages with basic functionality that everyone can use. Submitting a form is in my mind considered basic functionality. Crossbrowser-compatibility is not only a question of brand, but of version and enabled options as well. rgds * Holger Lockertsen, Solutions Developer * Pixelduck AS - Nedre Slottsgate 5, N-0157 OSLO, Noreg/Norway * +47 23 31 03 04 / 91 83 20 51 * [EMAIL PROTECTED] * http://www.pixelduck.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 2:15 PM To: CF-Talk Subject: Adam, you got to be kidding? You actually develop with the mindset that a user might not have scripting enabled? Ouch! My guess would be that at a minimum, 98% of all users have scripting enabled. So, you would forfeit the capability of client-side data validation, client-side DOM manipulation, etc.? You would add unneeded round trips to your server to accomplish scripting, validation, etc.? So 98% of your users will pay the Performance price for the 2% of your users? Not to mention the extra load on your server and the wasted bandwidth. Not a good idea ... Please! Bill Reichard Willow Gold [EMAIL PROTECTED] http://www.willowgold.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia and Allaire to Merge
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 You're right, I guess. I said specifically that you can't "...get stats for which part of your .swf was viewed..." Your article mentions Macromedia Flash advertisements, and the implications are that you can track "clicks" by assiging a "clickTag"(in MM lingo). My point is that .swf's are inherently not trackable My point is that for every click or action in a .swf, if it's designed right, most of the time no request is made to the server, thus no log, thus no tracking. Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. phn617.350.0339 fax617.350.8884 icq66172567 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MM/ALLAIRE No more Studio?
As long as it isn't WYSIWYG only! Duane -Original Message- From: Duane Douglas [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 9:01 AM To: CF-Talk Subject: Re: MM/ALLAIRE No more Studio? At 08:42 AM 1/18/2001 -0500, Richard L Smith wrote: It sounds like Studio 5 is going to UltraDev?? presently, studio 4.5 can be tightly integrated with ultradev. so ultradev 5 won't be a huge leap. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and FrontPage
Looks like it's time for me to learn DreamWeaver. I am not good enough a programmer to take any extra confusion caused by FrontPage's alleged shenanigans. (I have some experience with these shenanigans myself, though I've learned to deal with most of them. But I am not ready to throw CF into the mix.) Thanks for everyone's feedback. By the way, the tally as I count it so far is: Pro-DW/Anti-FP: 7 Pro-FP: 1 No stunning endorsement either way: 2 Matthieu -Original Message- From: Shane Witbeck [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 9:36 PM To: CF-Talk Subject: RE: CF and FrontPage I highly recommend Dreamweaver 4 over Frontpage. Shane Witbeck www.digitalsanctum.com -Original Message- From: Bob Lehman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 4:45 PM To: CF-Talk Subject: Re: CF and FrontPage Hmmm Haven't had a problem yet, am running CF4.5, Frontpage and Flash 4 all on the same machine. Bob Lehman New Horizon Mgmt and Consulting 440-542-0992 [EMAIL PROTECTED] Website: www.nhmac.com Client website: www.nhmac-user.com - Original Message - From: "Cornillon, Matthieu" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, January 17, 2001 1:46 PM Subject: CF and FrontPage Hi. I have a development machine with ColdFusion Studio/Server (single license) on it. For a couple of reasons, I'd like to install FrontPage on the same machine to do some simple visual HTML editing that can be a drag in CFStudio. Someone suggested to me that FrontPage might foul things up because of Personal Web Server or something else. Does anyone have any thoughts/horror stories to share about this? Thanks in advance, Matthieu ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia and Allaire to Merge -- A couple examples of mixin g technologies
I'm afraid that Dave gave out the url of a very early prototype that we created over a year ago using Flash 4 and CF...the demo (with code ripped from the production app) is actually located here... http://www.figleaf.com/development/flash4/orgchart/orgchart.cfm This demonstrates the use of Flash and CF to create an org-chart interface. You can lookup users by name (passing information to a CF page for data retrieval) and then drag names into the appropriate locations on the chart. Clicking the Save button passes the information back to CF for DB processing. A couple additional benefits are that the org chart dynamically resizes based on browser resizing and the EXACT SAME CODEBASE works on Netscape 4.x and Internet Explorer... Other data-driven demos are available at http://www.figleaf.com/figleafhome/flash/ and the Harpoon project is all about creating data-driven Flash business objects from CF. At the ACFUG and ChiFug this month, I will be demonstrating using CF, Flash, Spectra, and Generator for content management purposes. This compelling mix of technologies is what we feel will drive the web in the future. Is it a panacea? No...but it does deliver many compelling advantages. Regards, Steve Drucker CEO Fig Leaf Software -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 8:55 AM To: CF-Talk Subject: RE: Macromedia and Allaire to Merge NOW, it does. It didn't last night. I guess it wasn't quite ready for prime time then. Thanks. best, paul PS I get the 404 on OK, too (They probably don't want the changes to be permanent.) At 09:18 AM 1/18/01 +, you wrote: Click Search you get a list of names which you can drag drop into the various boxes. When I hit OK I get a 404 though :-( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 5:58 AM To: CF-Talk Subject: RE: Macromedia and Allaire to Merge What's it supposed to do? It just sits there for me. best, paul At 06:18 PM 1/17/01 -0500, you wrote: Take a look at this, and tell me Flash has no place in business apps: http://www.figleaf.com/development/flash4/orgchart.swf ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ASpUpload
Anyone using ASPUpload via CF? No, but I've used it via ASP that's very easy. I can't see CF being any different. Do you know how to use CFOBJECT ? ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Adam, you got to be kidding?
your guess? when i devlelop intranets/extranets i use javascript because the client can tell its employees/partners what the requirements are for using a given web-based applicaton. however, when i develop publicly accessed sites i don't rely on javascript. the reason is it can be turned off, not whether i guess at how many people have/leave it turned on. the sites i build and maintain generally have moderately high traffic and inevitably there are people who write in and say "this didn't work" or "why did this happen". it depends on the scope of work and who the audience is. but if your audience is big enough, you'll get feedback here and there by not conforming to a low common denominator with respect to browser capabilities. i'm not saying you're doing it right or wrong, but i am saying you shouldn't blatantly dismiss it as a development methodology. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 5:15 AM To: CF-Talk Subject: Adam, you got to be kidding? You actually develop with the mindset that a user might not have scripting enabled? Ouch! My guess would be that at a minimum, 98% of all users have scripting enabled. So, you would forfeit the capability of client-side data validation, client-side DOM manipulation, etc.? You would add unneeded round trips to your server to accomplish scripting, validation, etc.? So 98% of your users will pay the Performance price for the 2% of your users? Not to mention the extra load on your server and the wasted bandwidth. Not a good idea ... Please! Bill Reichard Willow Gold [EMAIL PROTECTED] http://www.willowgold.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Adam, you got to be kidding?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bill, Ouch yerself. :) Your assumption is that 98% of all users have scripting enabled. Reality, as always is different. I'd guess much lower, especially taking into consideration all the viruses and IE bugs over the last year where users, especially at corporations and ESPECIALLY in the government have been required to turn JS off. So I'd back up Adam in a heartbeat, you can NEVER be sure with client side scripting. ALWAYS check on the server. And really, what's the performance price for a trip to the server these days? 2 seconds? What's the performance hit for your client having to wade through error messages from clients when they get a JS error or when a form is submitted with invalid information? Hours? Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. phn617.350.0339 fax617.350.8884 icq66172567 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How to refresh screen?
Hi there, I tried to refresh screen when I redirect to a cf file throuth javascript (location.href=filename), but I can see the new content until manually refresh, I tried to use cfcache, but it doesn't work properly. Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
data in columns
Hello, I'm still a newbie with this one though I've tried. How can I count data in certain columns of a table for each record. Some records have no data in this field of the column so of course I don't want that counted. I kept it VERY VERY simple below. I've tried different configurations, but #cbicount# always returns a blank. Any help is always appreciated. Thank you. Robert O. -- Below I'm trying to count how many times CBI appears in the cbi column and display the total tally in the #cbicount# variable: cfquery name="Get" datasource="wweb" SELECT id, cbi FROM wweb Where cbi like 'CBI' cfif cbi EQ "CBI" cfset cbicount + 1 /cfif /cfquery CFOUTPUT #cbiCount# /CFOUTPUT ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Variable Names with -
The problem with this is that I am working with a Microsoft product that has a mind of its own. The SQL statement looks like this: SELECT * FROM TABLE for xml auto,elements It returns a one column result whose name is XML_F52E2B61-18A1-11d1-B105-00805F49916B and the xml is broken up to a certain number of characters per line. What I want to do is to put that back together as a single xml string that I can get my hands on, but because of the name that Microsoft creates, I can't loop through it with Cold Fusion. If anyone has any suggestions on how to get at this strange Microsoft column with Cold Fusion, I would greatly appreciate it. Thanks. -Original Message- From: Scott, Andrew [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 9:37 PM To: CF-Talk Subject: RE: Varaible Names with "-" You could do the following if you don't have control of the DB:-) cfquery name="qtest: datasource="datasource" select `field-name` as FieldName from TableName /cfquery Notice the ` which is located under the tilda(~) key this will return the fieldname as it was written in the DB. However you can't use this with CF, so using the as command this will rename the field to anything you want it to be. So you could then reference it instead of qtest.field-name, but as qtest.FieldName instead. Hope this helps:-) regards Andrew Scott Senior Cold Fusion Application Developer ANZ Business eCommerce * Ph 8615 6018 * [EMAIL PROTECTED] --- This e-mail and any attachments to it (the "Communication") is confidential and is for the use only of the intended recipient. The Communication may contain copyright material of Australia and New Zealand Banking Group Limited ABN 11 005 357 522 ("ANZ"), or any of its related entities or of third parties. If you are not the intended recipient of the Communication, please notify the sender immediately by return e-mail, delete the Communication, and do not read, copy, print, retransmit, store or act in reliance on the Communication. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of ANZ. ANZ does not guarantee the integrity of the Communication, or that it is free from errors, viruses or interference. -Original Message- From: Warrick, Mark [mailto:[EMAIL PROTECTED]] Sent: 18 January 2001 10:09 To: CF-Talk Subject: RE: Varaible Names with "-" This probably isn't the answer you're looking for, but you should rename the column. That's just plain bad database design to begin with. And there's no need to add on another layer of unnecessary programming when all you've gotta do is rename the field. ---mark -- Mark Warrick Phone: (714) 547-5386 Fax: (714) 972-2181 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Troy Hiltbrand [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 10:00 AM To: CF-Talk Subject: Varaible Names with "-" Is there any way to pull out the information about a query column that has a "-" in it? The problem is that with SQL Server 2000, when you do a "for xml" select statement, the column name that is returned has "-"s in it. From the documentation in SQL Server 2000, I am not seeing a name to rename that. I am trying to pull out the xml from this query, but in order to do this, I need to get at the data with a column name that has a "-" in it. If anyone has any suggestions, please let me know. Thanks. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The acquisition of Allaire by Macromedia
Paul Smith wrote: Does Flash play/stream compressed video/audio? Either Flash or Director Shockwave streams compressed audio. Dave Yang - Quantumwave Interactive Inc. Toronto, Ontario, Canada http://www.quantumwave.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Great idea Adam! [Was: Re: Adam, you got to be kidding?
Please ... I just checked Webtrends for browser types hitting our site and 98% of all browsers are NN 4+ and IE 4+ ... with the over 60% being IE 5. With a sample of over 5 million hits. You really are going to tell the website owner to ante up another X thousands of dollars to develop downward browser capability? Not to mention the cost of maintaining the various website variants. Let me see ... you could lose one or two sales to the 2% of browser that don't support scripting/have scripting enabled ... or you spend 50K and capture them. Cost verus payoff? Ohhh, and let me guess ... you also develop non-cookie-based/non-session-based site variants also! Cha Ching! And don't even think about all the people who can't read English? Let me see 2% of the people speak Yiddish ... so let's spend 50K to present our site in Yiddish? You got to be kidding! Bill Reichard Willow Gold [EMAIL PROTECTED] http://www.willowgold.com In a message dated 1/18/01 9:42:40 AM Eastern Standard Time, [EMAIL PROTECTED] writes: There's no point putting 'basic' functionality on a web site that's supposed to be for all of your users if it won't work on some of their browsers. How you can expect users to go back to your website if half of it doesn't work because they haven't got the right settings or the latest browser? This seems to be a very narrow minded attitude to have and will cost you potential customers and clients. Granted, a lot of the time you can have things that won't work on some browsers, but only if there's an alternative for people who may not have right settings and it doesn't loose any functionality or the message that you're trying to convey to the user. Kath ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: string to number
Steve, As long as you keep your ranges as you have them in your If statements, the following formula should yield the correct result. I know this doesn't address the question that you asked, but others have responded to that, and I just couldn't help fiddling. Hope you don't mind. CFSET Grp=("form.adult + form.children") CFSET SmRmRq=0 !--- The \ in this formula is correct. --- CFSET SmRmRq=Iif(Grp LTE 28,(Grp-1)\4+1,8) Of course, this is harder to modify in the future, should one range change. I'm also not sure whether it runs slower or faster. I am still not sure whether my obsession with physically compact code runs counter to good programming sense. I guess I should flip through a CS book! Matthieu -Original Message- From: Steve Doran [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 8:36 AM To: CF-Talk Subject: string to number I am trying to get a variable to work that would tell me how many rooms a person would need if they has X amount of people in their party. Here is the Code I am working with: CFSET Grp=("form.adult + form.children") CFSET SmRmRq=0 CFIF Grp LTE 4 CFSET SmRmRq=1 CFELSEIF (Grp GTE 5) and (Grp LTE 8) CFSET SmRmRq=2 CFELSEIF (Grp GTE 9) and (Grp LTE 12) CFSET SmRmRq=3 CFELSEIF (Grp GTE 13) and (Grp LTE 16) CFSET SmRmRq=4 CFELSEIF (Grp GTE 17) and (Grp LTE 20) CFSET SmRmRq=5 CFELSEIF (Grp GTE 21) and (Grp LTE 24) CFSET SmRmRq=6 CFELSEIF (Grp GTE 25) and (Grp LTE 28) CFSET SmRmRq=7 CFELSEIF Grp GTE 29 CFSET SmRmRq=8 /CFIF The problem I am having is when you output grp it gives you the total of form.adult + form.children. But when you use grp to set the variable SmRmRq it goes to a string "number + number" and will not accurately convert the variable. Is there a way to change the grp to a number? In Javascript It would be something like Var = (parseInt(form.adult) + parseInt(form.children)) Thanks in advance for any assistance, Steve Doran :) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Allaire, Macromedia merger
Allaire has been acquired by Macromedia: http://www2.marketwatch.com/quotes/articles.asp?symb=ALLRsid=129237source= htx/http2_mwview=detailedguid=%7BDE0E69E1%2DAC03%2D4326%2D9D1C%2D1EB7A9B69 4EC%7D (credit to Enayet Rasul for this info) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Session var resources
Even better get either Ben's book "The ColdFusion 4.0 Web Application Construction Kit", or "Mastering Cold Fusion 4.5" from Arman Danesh. This is where I learned about sessions. Jeff Waris Priority Business Cards - Original Message - From: "JLB" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, January 18, 2001 9:03 AM Subject: Session var resources Anyone have a good site that tells all there is about session and client vars. I need to learn when is a good time to use them and how to implement them at that time. Jim Becker ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Inserting HTML into a database.
I'm using EZEdit (awesome tag!) to enable a user to paste in excel tables etc as HTML. I'm having problems if the spreadsheet pasted in is too big. Is this a known problem? Also could somebody tell me how I get around the user using the ' character. Thanks. Best Regards, Adam Reynolds ColdFusion Web Developer ISMG Development, Unilever London ( +44 20 7822 x5450 m: +44 7973 386620 * [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia Coldfusion
Oh, I don't know. What about another's suggestion here: MacroFusion best, paul PS Don't bother. MacroFusion.com is already reserved ;-) At 01:48 PM 1/18/01 +, you wrote: i'm just glad that CF has a 'whizzy' name already, so MM wont have to give it a jazzy one from their extensive library or names that Adobe thought were too stupid :-) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Unable to Verify ODBC
I thought the system account was the Administrator login. I can not seem to find out where to change the system account permissions. I think this is my problem. Any help is appreciated? Thank You, Peter Peter J. MacDonald II Creative Computing, Inc. 100 Middle Street Lincoln, RI 02865 Phone: 401.727.0183 x208 Fax: 401.727.4998 Portable: 401.965.3661 E-MAIL: [EMAIL PROTECTED] Web Page: www.creatcomp.com -Original Message- From: Ruslan Sivak [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 18:34 To: CF-Talk Subject: RE: Unable to Verify ODBC The system account is a special account that most services run under. It has special permissions for files, etc, and I believe you cannot log on as system. You can add or remove the permissions for system, but I wouldn't recommend removing any unless you know what you're doing. Russ -Original Message- From: Peter J. MacDonald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 2:50 PM To: CF-Talk Subject: RE: Unable to Verify ODBC What is the System Account? Thank You, Peter Peter J. MacDonald II Creative Computing, Inc. 100 Middle Street Lincoln, RI 02865 Phone: 401.727.0183 x208 Fax: 401.727.4998 Portable: 401.965.3661 E-MAIL: [EMAIL PROTECTED] Web Page: www.creatcomp.com -Original Message- From: Warrick, Mark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 14:08 To: CF-Talk Subject: RE: Unable to Verify ODBC Sure. Open up the Services applet in the Control Panel. Click on the ColdFusion Application Server, then Startup. Look at the "Log On As" options. The simplest way to solve this problem is to make sure that you're using the System Account. Do the same for the other ColdFusion services: Executive RDS. Now I'm assuming that the DSN you're trying to hook up is for an Access database. Find that MDB file on the server and check it's permissions by right-clicking on it, choosing properties, then security, then permissions. If you used the SYSTEM account for the services, then it won't matter what permissions are applied here, but if you used any other account, make sure that same account has full control of the MDB file. Hopefully this helps. Basically, to sum it all up, don't screw with the account settings unless you understand Windows NT security! ---mark -- Mark Warrick Phone: (714) 547-5386 Fax: (714) 972-2181 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Peter J. MacDonald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 10:33 AM To: CF-Talk Subject: RE: Unable to Verify ODBC Mark, Could you be a little more specific about the security issues. I login as Administrator and have check all of the directories and files and administrator can open them no problem through that. The 3 different CF services where running as default system login and now as administrator. Thank You, Peter Peter J. MacDonald II Creative Computing, Inc. 100 Middle Street Lincoln, RI 02865 Phone: 401.727.0183 x208 Fax: 401.727.4998 Portable: 401.965.3661 E-MAIL: [EMAIL PROTECTED] Web Page: www.creatcomp.com -Original Message- From: Warrick, Mark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 11:49 To: CF-Talk Subject: RE: Unable to Verify ODBC If you're able to run ODBC connectivity tests through the control panel with no problems, but not with the CF Administrator, then you probably have a permissions/security conflict. Make sure that the ColdFusion server is running as a SYSTEM account or some other account that has permission to access those datasources. ---mark -- Mark Warrick Phone: (714) 547-5386 Fax: (714) 972-2181 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Peter J. MacDonald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 7:55 AM To: CF-Talk Subject: Unable to Verify ODBC Help Please, I have installed CFServer 4.5.1 on an NT Workstation 4.0 Build 5. I am trying to get it setup and run the Demo Applications. I have installed the current MDAC from MS. I have checked ODBC connectivity through other software and it is fine. I can also change ODBC information through the CF Admin interface. When I run the Administrator test query I get a S1000 General ODBC error Disk or network error. Any Ideas appreciated. Thank You, Peter Peter J. MacDonald II Creative Computing, Inc. 100 Middle
RE: any ideas?
Jay, How about the following nested Iif statement? tr bgcolor="#IIf(DirList.CurrentRow Mod 2, DE('E7'), Iif(ElseIfCondition, DE('FAFAFA'), DE('OtherColorCode'))#" I don't exactly understand what your conditions/results are, but I use this sort of 3-way If statement all the time in Excel. An example: MyVal LT 5, return " 5" MyVal GTE 5, AND LTE 10 return "5-10" MyVal GT 10, return " 10" CFSET MyResult="#Iif(MyVal LT 5, DE('5'), Iif(MyVal LTE 10, DE('5-10'), DE('10')))#" And you can, of course, keep nesting as deep as you want. Great in Excel, where you must put all the processing in a single formula (unless you write a VBA macro). Maybe it gets a little confusing here, though, where the visually clearer CFIF statements are an option. Hope this helps, Matthieu -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 3:52 PM To: CF-Talk Subject: any ideas? does anyone know how i can make this tag output 3 colors instead of 2? tr bgcolor="#IIf(DirList.CurrentRow Mod 2, DE('E7'), DE('FAFAFA'))#" thanks, Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists