Re: Studio and Save As shenanigans
In the settings, do you have "use standard file dialogs" turned off? I think that's the setting to allow the folder in the side bar to be the default save folder. Don't know but I reported this back in the days that V4.0 was in beta, if it hasn't been fixed I suggest sending an email to [EMAIL PROTECTED] with the details:-) -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 03:20 To: CF-Talk Subject: Studio and Save As shenanigans How can you get Studio to open successive Save As dialogue boxes starting in the same folder instead of having to constantly change to the folder you're working in? 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: OT: getting IP Address w/o cf
i replied to this earlier, but the list server seems distressed as it has been lately. anyway, you access REMOTE_ADDR as a CGI variable. when you mention you're programming in CGI...do you mean PERL? CGI (Common Gateway Interface) is not a language, but a descriptor given to numerous languages based on the types of functions the application(s) they're written in perform. however, in ASP, you can call REMOTE_ADDR as: %= Request.ServerVariables("REMOTE_ADDR") %. so i think the real question is what language are you required to write in if not CF? ASP? VBS? --dylan I have a client who has a site that is on unix (eww) and am needing to know a way to get a user's ip address. I know how to do it with cold fusion, but don't know how to with CGI or FrontPage. They have FrontPage 2000 server on their web server. Any ideas? Bernd VanSkiver [EMAIL PROTECTED] ICQ #: 916324 ~~ 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: Application generating HTML?
I think in general it's not only what works at the moment, but what will also work for the foreseeable future that should be used. nice quote, max!!! will remember this :Þ cheers han ~~ 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: barbecue grill
I think Janet Reno is now selling BBQs... Ask a dumb question... Howie - Original Message - From: "Phoeun Pha" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, November 25, 2000 7:01 PM Subject: OT: barbecue grill anyone know what brand/models i should get? i'm havin a party soon eh heh ~~ 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: CFExpress
http://www.allaire.com/handlers/index.cfm?ID=13700 http://www.allaire.com/handlers/index.cfm?ID=13570Method=FullTitle=Edition %20Comparison%20MatrixCache=False HTH, 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: "Duane Boudreau" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, February 26, 2001 1:21 PM Subject: CFExpress Does anyone know where a list of supported functionality for CFExpress can be found? Either its not available on Allaire's website or I'm not looking in the right spot. Thanks Duane ~~ 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: progressive searching
Phil, Try this and see if it helps: http://javascript.internet.com/forms/list-chooser.html 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; Firetalk: Ag78 -Original Message- From: Phil Palmer [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 10:23 PM Dear CFers I have a requirement for a drop down list that allows progressive searches. ie: as you enter letters the list shortens to match the text. I am sure you can do this but not quite sure of the way to tackle it. I suppose that using CF would require going back to the server each time so thats not really a good option. Am I looking at some clever javascript do you think? Anyone got any bright ideas? Hope I am not too OT here. Regards Phil Palmer ~~ 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: CFExpress
http://www.allaire.com/products/coldfusion/cfexpress/ - Original Message - Does anyone know where a list of supported functionality for CFExpress can be found? Either its not available on Allaire's website or I'm not looking in the right spot. ~~ 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: Encoding URL Variables
Not 100% secure, but you could encrypt the value... How do I encode URL variables so that I can pass semi-sensitive info over URL? !--- duh.cfm --- cfset thestring = "A new value?" cfset thekey = "test" cfoutput form action="duh2.cfm" method="get" input type="hidden" name="test10" value="#URLEncodedFormat(Encrypt(thestring, thekey))#" input type="submit" value="Test" /form /cfoutput !---Duh2.cfm--- cfset thekey = "test" cfset decodedvalue = decrypt(URLDecode(test10), thekey) cfoutput #decodedvalue# /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
New at HoF
Links to new resources are up on www.houseoffusion.com. Michael Dinowitz Publisher: Fusion Authority weekly news alert (www.fusionauthority.com/alert) Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc. (www.houseoffusion.com) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
gettting form.variables using pure html?
hi.. juz to confirm my thoughts... is there any way we can pass variables of a form to another page and display the variables.. using pure html?? my friend thinking of doing a simple homepage at those free hosting site. Hes thinking of having a form that can send email directly w/o using the mail program. i know we can do this w/ CF... but can this be done using pure html.. or maybe w/ javascript? cheers han ~~ 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
autorun cd rom for html
hi... a client of my company request for a cdrom version of their website. (for their presentation purposes) They request the index.html to be autorun once they load the cd into the cdrom drive.. so.. can we actually do this?? i know autorun.inf normally open .EXE file.. or can it open html file too? cheers han ~~ 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: Building Cold Fusion Search - Dynamic SQL
hmm.. maybe u hav to set #frmSkill# as array... then put each skill into different variables at yr query.. use AND for each isdefined(variables.skill) hope this help.. cheers han - Original Message - From: Kim Mayhall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 3:23 AM Subject: Building Cold Fusion Search - Dynamic SQL I'm trying to build some sql statements based on selections from a list box: select name="frmSkill" option Skill1 option Skill2 option Skill3 option Skill4 (etcthis size will vary as it's dynamically populated) /select A user can do a multiple select, so let's say the user picked option 1 and option 3. On my action page, I want to pick ONLY the employees that have the 2 skills selected. If I use an IN statement, I get employees with one skill or the other, but I only want those with both: SELECT e.empId,es.skillId from emp e,empSkills es where skillId IN (#frmSkill#) AND e.empId=es.empId How can I write the SQL to select only the employees with both, or do I use Cold Fusion to do that? Kim Mayhall The Garrigan Lyman Group http://www.glg.com http://www.glg.com/ (206) 223-5548 ~~ 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: New App engine for CFML
Gotta love this guy ... and this co's angle. Looks to me they are just trying to be of enough nuisance to perhaps get "purchased" .. A wanna be JRun if you will. what good will this tagServlet be in one quarter or so's time? Imagine if Allaire put out the following quote . "Here ya go folks here's Pharoah the new JRun/CFML processing engine redesigned. It cant process do WDDX, COM, nor X, Y nor Z you've built your apps on ... but hey man ... its more effecient at what it can process, and best of all ... its here to use today." yi! sounds kinda like what the n-ary people are saying. "Ceri Moran, Chief Operations Officer for n-ary, added: ``In recent weeks we have seen a tremendous increase of interest in tagServlet. ColdFusion users have expressed to us concern about the merger of Allaire and MacroMedia (Nasdaq: MACR - news). Although there are new products from them in the pipeline, tagServlet is here now, available for beta download.'' """ Steve - Original Message - From: "defective dreams" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, February 26, 2001 11:39 AM Subject: New App engine for CFML ~~ 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: Text disappears!
just a guess, but your comments are using 2 dashes !-- -- CF templates give you some really cool funky ass results when you do not make them with 3 !--- ---. Exactly what text disappears. - Original Message - From: "Jeff Epstein" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, February 26, 2001 1:55 PM Subject: Text disappears! sighCan anyone help me figure out why my text is disappearing in some configurations? Is this a CF issue? It's www.sfcg.org using http://www.sfcg.org using CF4.5 / ISS / NT on a SQL Server 7.0 DB, with text formatted on CSS1. Have heard the complaint on IE5 Mac and NS6 Mac. IE and NS on Windows are good. Any diagnostic help greatly appreciated. Very frustrating. Jeff Epstein Web Producer Search for Common Ground 1601 Connecticut Avenue, NW Suite 200 Washington, DC 20009 USA +1 (202) 265-4300 +1 (202) 777-2238 (direct) +1 (202) 232-6718 (fax) [EMAIL PROTECTED] www.sfcg.org http://www.sfcg.org/ ~~ 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: Building Cold Fusion Search - Dynamic SQL
Hmmm, are you trimming the variables in the IN statement? Is skillId set to CHAR or VARCHAR? If its CHAR you should check to make sure the values themselves in the database don't have extra spaces. If that's all correct, make sure your form's method is "post" and not "get". That is, form action="Mytemplate.cfm" method="post" - Original Message - From: "Kim Mayhall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, February 26, 2001 11:23 AM Subject: Building Cold Fusion Search - Dynamic SQL I'm trying to build some sql statements based on selections from a list box: select name="frmSkill" option Skill1 option Skill2 option Skill3 option Skill4 (etcthis size will vary as it's dynamically populated) /select A user can do a multiple select, so let's say the user picked option 1 and option 3. On my action page, I want to pick ONLY the employees that have the 2 skills selected. If I use an IN statement, I get employees with one skill or the other, but I only want those with both: SELECT e.empId,es.skillId from emp e,empSkills es where skillId IN (#frmSkill#) AND e.empId=es.empId How can I write the SQL to select only the employees with both, or do I use Cold Fusion to do that? Kim Mayhall The Garrigan Lyman Group http://www.glg.com http://www.glg.com/ (206) 223-5548 ~~ 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: autorun cd rom for html
a client of my company request for a cdrom version of their website. (for their presentation purposes) They request the index.html to be autorun once they load the cd into the cdrom drive.. From a colleague: A normal .inf file can only open .exe files. To open a .html file you need a little program i found on the net called browsercall. I have enclosed the zip file with full instructions, it's quite easy to follow. NB other list members - if you want the .zip that was attached to this e-mail, let me know. -- 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: autorun cd rom for html
It has to open an exe file - theres a (free) .exe program around somewhere to autoload an htm file... -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 08:06 To: CF-Talk Subject: autorun cd rom for html hi... a client of my company request for a cdrom version of their website. (for their presentation purposes) They request the index.html to be autorun once they load the cd into the cdrom drive.. so.. can we actually do this?? i know autorun.inf normally open .EXE file.. or can it open html file too? cheers han ~~ 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: New App engine for CFML
Looks to me they are just trying to be of enough nuisance to perhaps get "purchased" My first thought exactly. -- 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: gettting form.variables using pure html?
you mean something like this? form action="mailto:[EMAIL PROTECTED]?subject=Some subject" method="post" input type="text" name="name" value="John Doe"br input type="text" name="age" value="21"br input type="submit" name="submit" /form Both browsers will fire off a warning, and the form fields will be name value pairs sent as an attachment to the email. Like this... name=John+Doeage=21submit=Submit+Query You could also href it or javascript the same... A HREF="mailto:[EMAIL PROTECTED]?subject=Some subjectbody=this is the body of this email"Sean Renet/a - Original Message - From: "han peng" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 12:01 AM Subject: gettting form.variables using pure html? hi.. juz to confirm my thoughts... is there any way we can pass variables of a form to another page and display the variables.. using pure html?? my friend thinking of doing a simple homepage at those free hosting site. Hes thinking of having a form that can send email directly w/o using the mail program. i know we can do this w/ CF... but can this be done using pure html.. or maybe w/ javascript? cheers han ~~ 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: gettting form.variables using pure html?
I dont know what free hosting site you plan on using, but most sites offer a free e-mail script that you can submit to - generally more reliable than relying on the clients machine... -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 08:01 To: CF-Talk Subject: gettting form.variables using pure html? hi.. juz to confirm my thoughts... is there any way we can pass variables of a form to another page and display the variables.. using pure html?? my friend thinking of doing a simple homepage at those free hosting site. Hes thinking of having a form that can send email directly w/o using the mail program. i know we can do this w/ CF... but can this be done using pure html.. or maybe w/ javascript? cheers han ~~ 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
Browsercall for opening html files on a CD
http://www.ashzfall.com/products/autorun/browsercall.html ~~ 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: Browsercall for opening html files on a CD
Or this http://www.avdf.com/oct98/art_ot005.html - Original Message - From: "Sean Renet" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 1:49 AM Subject: Browsercall for opening html files on a CD http://www.ashzfall.com/products/autorun/browsercall.html ~~ 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: Studio and Save As shenanigans
In the settings, do you have "use standard file dialogs" turned off? I think that's the setting to allow the folder in the side bar to be the default save folder. I've just played around with altering this and found that in 4.5.2 it didn't seem to make any difference whether it was checked or not - possibly the bug to which Andrew referred. I discovered, as you mentioned, that the Save As dialogue defaults to whatever folder is selected in the Files Resource Window. This is maddening if you're working with a Project and can't figure out why consecutive Saves don't subsequently open the folder in which you saved your first file;-) In the end I just selected the folder in which the project was located in Resource Window | Files and then carried on working with the Project as before. Is it a problem with Studio or is it a function of Windows? Another developer here said she had exactly the same problem with Photoshop... Thanks for the advice. -- 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: autorun cd rom for html
From: "han peng" [EMAIL PROTECTED] Subject: autorun cd rom for html hi... a client of my company request for a cdrom version of their website. (for their presentation purposes) They request the index.html to be autorun once they load the cd into the cdrom drive.. so.. can we actually do this?? i know autorun.inf normally open .EXE file.. or can it open html file too? cheers han http://www.ashzfall.com/products/autorun/index.html http://www.ashzfall.com/products/autorun/browsercall.html 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: Browsercall for opening html files on a CD
thanx guys..!! will try that.. cheers han - Original Message - From: Sean Renet [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 5:49 PM Subject: Browsercall for opening html files on a CD http://www.ashzfall.com/products/autorun/browsercall.html ~~ 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: Where is Ramonda Ramos ?
off the list. Hooray! -- 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: Images loading slow and possible image caching?
Have a site that we are using CF caching and the text of the page comes up perfect... However, the graphics are lagging Any suggestions?? Erm, CF serves pages, the web server serves images... look at the web server either eating memory and not releasing it, upgrading your software or upgrading the RAM in your server 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: WDVL Poll
Not to mention under Authoring they don't even have a coldfusion section *snicker* (Which makes one wonder why Howie thinks a CF developer would become a wdlv user in the first place?) I think it says something that they got as many CF votes as they did from their particular audience. heh heh -Gel -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] I'd be interested to see who they polled. Considering they do not have any CF resourses and thier Java resources are rudimentary, I think this is more of a window into thier marketing ability. If you poll my house, people here think - Original Message - From: "Howie Hamlin" [EMAIL PROTECTED] Maybe more CF developers should become WDVL users - CF ranks only slightly above CGI - sheesh... http://wdvl.internet.com/poll.html ~~ 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: owa/email
Becky, Dave gave you the route for OWA 5.5. If you are using the OWA from Exchange 2000 you just need to make the changes to the IE security settings, because of architecture changes in the application the logon form stuff has gone away. And the same is still true of needing IE. -eric Common sense is genius dressed in its working clothes. -- Ralph Waldo Emerson Eric Barr Zeff Design (p) 212.714.6390 (f) 212.580.7181 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 11:55 AM To: CF-Talk Subject: RE: owa/email is anyone familiar with microsofts web version of outlook? what i want to do is bypass the login screens so my users dont have to keep logging in to see their mail. (they login once to get on the network...i just want to pass those credentials right to owa, so when the click on the email icon, they dont have to login a second time.) You can do this, if your users are using IE. They'll need to configure IE to pass their network credentials to the remote server when they access that particular server. Typically, this means adding the URL to the "Intranet" or "Trusted Sites" zone, and ensuring that the option to send network credentials is checked. You'll also need to use NTLM Authentication on the web server. Then, you'll have to change some ASP code slightly. There are two pages in the \WEBDATA\USA directory, logon.asp and logonfrm.asp. The first one is the form in which the username is entered. The second one is the action page for the first, and it takes the username and authenticates with that name. You'll need to add some logic here to read the CGI variable containing the username, if it exists, and if it does, have it use that automatically. Your best bet to have it work both with and without the variable is to add some logic to each page. In logon.asp, if the CGI username variable exists, just redirect to logonfrm.asp. In logonfrm.asp, if the CGI username variable exists, use it instead of the form variable. If I recall correctly, the CGI variable you'll be interested in is Request.ServerVariables("AUTH_USER"). 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: Building Cold Fusion Search - Dynamic SQL
OK, I'm going to break this down bit by bit I'm trying to build some sql statements based on selections from a list box: select name="frmSkill" option Skill1 option Skill2 option Skill3 option Skill4 (etcthis size will vary as it's dynamically populated) /select A user can do a multiple select, so let's say the user picked option 1 and option 3. Is there a huge list of skills? If not, do it via Checkboxes as multiple selects really confuse people On my action page, I want to pick ONLY the employees that have the 2 skills selected. If I use an IN statement, I get employees with one skill or the other, but I only want those with both: SELECT e.empId,es.skillId from emp e,empSkills es where skillId IN (#frmSkill#) AND e.empId=es.empId How can I write the SQL to select only the employees with both, or do I use Cold Fusion to do that? IN is effectively an OR, that's what it's there for... if you want to do an AND it's going to be a lot more complicated I can't think of a quick way to do this in SQL, it might be a mixture of CF and SQL (this code is ugly, but it'll work cfquery name="myQuery" datasource="myDSN" select e.empId,es.skillId from emp e,empSkills es where skillId IN (#frmSkill#) AND e.empId=es.empId order by e.empId,es.skillId /cfquery cfscript // Start with an array empArray=ArrayNew(1); // currently no person and skills thisEmp=0; thisEmpSkills=""; // loop through the data for (i=1; i lte myQuery.RecordCount; i=i+1) {// if we're not building for the current employee, add the last employee's stuff into the array if (myQuery.empID[i] neq thisEmp) {// If it's not blank if (thisEmp neq 0) {// build it in a structure as it's easier to get info out of tmpStruct=StructNew(); tmpStruct.empID=thisEmp; tmpStruct.SkillList=thisEmpSkills; // add it to the array ArrayAppend(empArray,thisStruct); } // we're looking at "this" employee thisEmp=myQuery.empID[i]; // start with blank skills thisEmpSkills=""; } // add the current skill to the list thisEmpSkills=ListAppend(thisEmpSkills,myQuery.skillID[i]); } // Add the last person's entries to the array tmpStruct=StructNew(); tmpStruct.empID=thisEmp; tmpStruct.SkillList=thisEmpSkills; ArrayAppend(empArray,thisStruct); /cfscript You'll now have an array of the employees with their skills - so loop through them and remove the ones who don't have all of the skills As I say, ugly, but it should work 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: Building Cold Fusion Search - Dynamic SQL
or you could do cfset SkillsClause = Replace( frmSkill, ",", " AND SkillID = ", "ALL" ) cfquery ... SELECT e.empId,es.skillId from emp e,empSkills es where skillId = #SkillsClause# AND e.empId=es.empId /cfquery So given frmSkill = 1,3,4,7, ..etc your query would say .. where skillID = 1 AND SkillID = 3 AND SkillID = 4 AND SkillID = 7 ..etc That should do it hope it helps Alistair Davidson Senior Web Developer Rocom www.rocomx.net -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 11:49 To: CF-Talk Subject: RE: Building Cold Fusion Search - Dynamic SQL OK, I'm going to break this down bit by bit I'm trying to build some sql statements based on selections from a list box: select name="frmSkill" option Skill1 option Skill2 option Skill3 option Skill4 (etcthis size will vary as it's dynamically populated) /select A user can do a multiple select, so let's say the user picked option 1 and option 3. Is there a huge list of skills? If not, do it via Checkboxes as multiple selects really confuse people On my action page, I want to pick ONLY the employees that have the 2 skills selected. If I use an IN statement, I get employees with one skill or the other, but I only want those with both: SELECT e.empId,es.skillId from emp e,empSkills es where skillId IN (#frmSkill#) AND e.empId=es.empId How can I write the SQL to select only the employees with both, or do I use Cold Fusion to do that? IN is effectively an OR, that's what it's there for... if you want to do an AND it's going to be a lot more complicated I can't think of a quick way to do this in SQL, it might be a mixture of CF and SQL (this code is ugly, but it'll work cfquery name="myQuery" datasource="myDSN" select e.empId,es.skillId from emp e,empSkills es where skillId IN (#frmSkill#) AND e.empId=es.empId order by e.empId,es.skillId /cfquery cfscript // Start with an array empArray=ArrayNew(1); // currently no person and skills thisEmp=0; thisEmpSkills=""; // loop through the data for (i=1; i lte myQuery.RecordCount; i=i+1) {// if we're not building for the current employee, add the last employee's stuff into the array if (myQuery.empID[i] neq thisEmp) {// If it's not blank if (thisEmp neq 0) {// build it in a structure as it's easier to get info out of tmpStruct=StructNew(); tmpStruct.empID=thisEmp; tmpStruct.SkillList=thisEmpSkills; // add it to the array ArrayAppend(empArray,thisStruct); } // we're looking at "this" employee thisEmp=myQuery.empID[i]; // start with blank skills thisEmpSkills=""; } // add the current skill to the list thisEmpSkills=ListAppend(thisEmpSkills,myQuery.skillID[i]); } // Add the last person's entries to the array tmpStruct=StructNew(); tmpStruct.empID=thisEmp; tmpStruct.SkillList=thisEmpSkills; ArrayAppend(empArray,thisStruct); /cfscript You'll now have an array of the employees with their skills - so loop through them and remove the ones who don't have all of the skills As I say, ugly, but it should work 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: Building Cold Fusion Search - Dynamic SQL
Phillip, her original code works, she just needs to make the form's method "post" - Original Message - From: "Philip Arnold - ASP" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 3:49 AM Subject: RE: Building Cold Fusion Search - Dynamic SQL OK, I'm going to break this down bit by bit I'm trying to build some sql statements based on selections from a list box: select name="frmSkill" option Skill1 option Skill2 option Skill3 option Skill4 (etcthis size will vary as it's dynamically populated) /select A user can do a multiple select, so let's say the user picked option 1 and option 3. Is there a huge list of skills? If not, do it via Checkboxes as multiple selects really confuse people On my action page, I want to pick ONLY the employees that have the 2 skills selected. If I use an IN statement, I get employees with one skill or the other, but I only want those with both: SELECT e.empId,es.skillId from emp e,empSkills es where skillId IN (#frmSkill#) AND e.empId=es.empId How can I write the SQL to select only the employees with both, or do I use Cold Fusion to do that? IN is effectively an OR, that's what it's there for... if you want to do an AND it's going to be a lot more complicated I can't think of a quick way to do this in SQL, it might be a mixture of CF and SQL (this code is ugly, but it'll work cfquery name="myQuery" datasource="myDSN" select e.empId,es.skillId from emp e,empSkills es where skillId IN (#frmSkill#) AND e.empId=es.empId order by e.empId,es.skillId /cfquery cfscript // Start with an array empArray=ArrayNew(1); // currently no person and skills thisEmp=0; thisEmpSkills=""; // loop through the data for (i=1; i lte myQuery.RecordCount; i=i+1) {// if we're not building for the current employee, add the last employee's stuff into the array if (myQuery.empID[i] neq thisEmp) {// If it's not blank if (thisEmp neq 0) {// build it in a structure as it's easier to get info out of tmpStruct=StructNew(); tmpStruct.empID=thisEmp; tmpStruct.SkillList=thisEmpSkills; // add it to the array ArrayAppend(empArray,thisStruct); } // we're looking at "this" employee thisEmp=myQuery.empID[i]; // start with blank skills thisEmpSkills=""; } // add the current skill to the list thisEmpSkills=ListAppend(thisEmpSkills,myQuery.skillID[i]); } // Add the last person's entries to the array tmpStruct=StructNew(); tmpStruct.empID=thisEmp; tmpStruct.SkillList=thisEmpSkills; ArrayAppend(empArray,thisStruct); /cfscript You'll now have an array of the employees with their skills - so loop through them and remove the ones who don't have all of the skills As I say, ugly, but it should work 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: Where is Ramonda Ramos ?
Goodie! A game! Is this anything like Where's Waldo??? 8-) Dave - Original Message - From: "Massimo "Fuse" Gianadda" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, February 26, 2001 7:36 PM Subject: OT: Where is Ramonda Ramos ? Out of the office ? Max ~~ 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: Where is Ramonda Ramos ?
Out of the office ? Or maybe beaten and bloody after turning on OutOfOffice messages to CF-Talk Hundreds of CF-Talkers queue up like that but with hysterical woman in Airplane the Movie g 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: WDVL Poll
ASP better than CF, Heretics! Maybe this is an issue MM/Allaire can address, i.e. more marketing or something. Rick - Original Message - From: "Howie Hamlin" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, February 26, 2001 12:09 PM Subject: WDVL Poll Maybe more CF developers should become WDVL users - CF ranks only slightly above CGI - sheesh... http://wdvl.internet.com/poll.html 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! ~~ 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: Voice XML
Check out http://community.voxeo.com DC - Original Message - From: "Paul Campano" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, February 26, 2001 23:54 Subject: Voice XML Does anyone have sample code using CF and Voice XML, specfically code to query a database and use the results?. I have been to studio.tellme.com, but they only give example code in Perl and ASP. Thanks. Paul Campano Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at 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: Javascript problem
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_000_01C0A0C2.5A29E9D0 Content-Type: text/plain; charset="iso-8859-1" Javascript wiping form values problem: == .I have a problem with cold fusion causing form values to be wiped when they are entered with the use of javascript. .I tried saving the same file as an htm file and the problem did not occur. .Is there any possible solution. Here is the code I have used: = form action="calendar.asp" name="frm" method="post" input type="text" name="coverdate" value="" size="12" a href="javascript:show_calendar('frm.coverdate');" onmouseover="window.status='Date Picker';return true;" onmouseout="window.status='';return true;" Test Calendar /a BR input type="submit" value="test" /form I have attached my script to this email. Any help would be greatly appreciated. Yours Sincerely, Kwasi Date-Bah BSc(Hons), MSc, MCP Systems Developer Optimad-iMediapoint [EMAIL PROTECTED] http://www.iMediapoint.com office: 020 7598 3060 Mobile: 07801 819336 CONFIDENTIALITY - The information in this e-mail and any attachment is confidential. It is intended only for the named recipient(s). If you are not a named recipient please notify the sender immediately, do not disclose the contents to another person or take copies, and delete immediately. --_=_NextPart_000_01C0A0C2.5A29E9D0 Content-Type: application/octet-stream; name="calendar.cfm" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="calendar.cfm" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head script language=3D"Javascript" !-- Original: Kedar R. Bhave ([EMAIL PROTECTED]) -- !-- Web Site: http://www.softricks.com -- =09 !-- This script and many more are available free online at -- !-- The JavaScript Source!! http://javascript.internet.com -- =09 var weekend =3D [0,6]; var weekendColor =3D "#EE"; var fontface =3D "Tahoma, Arial, Helvetica, sans serif"; var fontsize =3D 2; =09 var gNow =3D new Date(); var ggWinCal; isNav =3D (navigator.appName.indexOf("Netscape") !=3D -1) ? true : = false; isIE =3D (navigator.appName.indexOf("Microsoft") !=3D -1) ? true : = false; =09 // Non-Leap year Month days.. Calendar.DOMonth =3D [31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, = 31]; // Leap year Month days.. Calendar.lDOMonth =3D [31, 29, 31, 30, 31, 30, 31, 31, 30, 31, 30, = 31]; =09 Calendar.Months =3D ["January", "February", "March", "April", "May", = "June", "July", "August", "September", "October", "November", "December"]; =09 function Calendar(p_item, p_WinCal, p_month, p_year, p_format) { if ((p_month =3D=3D null) (p_year =3D=3D null)) return; =09 if (p_WinCal =3D=3D null) this.gWinCal =3D ggWinCal; else this.gWinCal =3D p_WinCal; =09 if (p_month =3D=3D null) { this.gMonthName =3D null; this.gMonth =3D null; this.gYearly =3D true; } else { this.gMonthName =3D Calendar.get_month(p_month); this.gMonth =3D new Number(p_month); this.gYearly =3D false; } =09 this.gYear =3D p_year; this.gFormat =3D p_format; this.gBGColor =3D "white"; this.gFGColor =3D "black"; this.gTextColor =3D "black"; this.gHeaderColor =3D "black"; this.gReturnItem =3D p_item; } =09 Calendar.get_daysofmonth =3D Calendar_get_daysofmonth; Calendar.get_month =3D Calendar_get_month; Calendar.calc_month_year =3D Calendar_calc_month_year; Calendar.print =3D Calendar_print; =09 function Calendar_get_daysofmonth(monthNo, p_year) { /*=20 Check for leap year .. 1.Years evenly divisible by four are normally leap years, except = for...=20 2.Years also evenly divisible by 100 are not leap years, except =
Problem with CFFILE (sort of)
OK got a strange one. I think this will end up being an NT permissions problem but thought one of you may have come across it. I have a web site which sits on 2 seperate web servers. It is load balanced and state is maintained via client variables stored in SQL server on a 3rd machine. All 3 are networked. I have a cfm page on both web servers which is attempting to create a file on the 3rd machine using cffile. Both web servers have mapped drives to a folder on the 3rd server so when this cfm page is requested it writes a file to the same place regardless of which web server delivered the page (due to load balancing). The problem I am having is that when CFServer executes the cffile command it says that it can't access the file. I have checked all the permissions on the NT server and that folder is opened up for full access to everyone. I have tried sucessfully to create a file in this folder from a dosbox on one of the webservers so the path I'm using is definitely correct. To complicate the problem I have changed the code to write to C:\ (which exists on both web servers) as opposed to the mapped drive to the 3rd server. This works fine. However I can't use this as I won't know which C drive it has created the file on due to the load balancing and when request the next page which looks for this file it will not find it if the page gets delivered from the other web server. Finally I put a specific IP address in the url that requests the page that creates the file and subsequently reads it so I could guarantee that it would write and read to the same server (ie bypass load balancing). But when I did this the session auomaically expired (which I don't understand). Has anyone ever come across anything remotely similar to this by any remote chance!??? Andy -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- 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)207 387 8890. ~~ 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: New App engine for CFML
I imagine you're talking about Tagfusion. I brought this same topic up a while back. The general consensus was that Allaire probably hasn't copyrighted specific elements of the language. someone just created a new interpreter for it. Similar to the many different compilers for C. I suppose the difference between C and CFML is that there is a standard 'C' language. Who defines the 'standard C' language? Is some standards body, like w3.org? I actually don't know. If I were Allaire, my biggest worry would be the branding they have put into ColdFusion. If someone comes along and writes a horribly slow and buggy interpreter , then it could turn around and give Allaire (Macromedia) products a bad name. The most interesting thing about Tagfusion (as someone else once stated) is that it was written based on entirely different principles than ColdFusion. At 12:50 PM 02/26/2001 -0700, you wrote: My GF and I got into a discussion of whether or not Allaire could sue this company for using a language that Allaire owns. The discussion turned to whether or not one could own a language (computer language or otherwise). She said yes, if you develop a language you could copyright it and charge people to use/speak it. I'm not sure what I think. Free speach may not apply here, because the first admendment says you can (almost) say anything you want, doesn't say what language it can be in. Any comments? ~~ 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: Problem with CFFILE (sort of)
IS Coldfusion logged on as a user account or as system - it needs to be logged on as a user to access files over the network. session management etc is on a domain basis 200.200.200.200 is a different domain to www.myserver.com even if they happed to be exactly the same location... -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 13:38 To: CF-Talk Subject: Problem with CFFILE (sort of) OK got a strange one. I think this will end up being an NT permissions problem but thought one of you may have come across it. I have a web site which sits on 2 seperate web servers. It is load balanced and state is maintained via client variables stored in SQL server on a 3rd machine. All 3 are networked. I have a cfm page on both web servers which is attempting to create a file on the 3rd machine using cffile. Both web servers have mapped drives to a folder on the 3rd server so when this cfm page is requested it writes a file to the same place regardless of which web server delivered the page (due to load balancing). The problem I am having is that when CFServer executes the cffile command it says that it can't access the file. I have checked all the permissions on the NT server and that folder is opened up for full access to everyone. I have tried sucessfully to create a file in this folder from a dosbox on one of the webservers so the path I'm using is definitely correct. To complicate the problem I have changed the code to write to C:\ (which exists on both web servers) as opposed to the mapped drive to the 3rd server. This works fine. However I can't use this as I won't know which C drive it has created the file on due to the load balancing and when request the next page which looks for this file it will not find it if the page gets delivered from the other web server. Finally I put a specific IP address in the url that requests the page that creates the file and subsequently reads it so I could guarantee that it would write and read to the same server (ie bypass load balancing). But when I did this the session auomaically expired (which I don't understand). Has anyone ever come across anything remotely similar to this by any remote chance!??? Andy -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- 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)207 387 8890. ~~ 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: Problem with CFFILE (sort of)
Cold Fusion is logged on as the system account but I don't think that's the problem because I have set up the same system on a test suite of servers where Coldfusion is running as the system account on an NT server and it writes a file to a Linux server. This works ok - the only difference is that there is only one web server serving the pages and hence no load balancing. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- 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)207 387 8890. -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 13:45 To: CF-Talk Subject: RE: Problem with CFFILE (sort of) IS Coldfusion logged on as a user account or as system - it needs to be logged on as a user to access files over the network. session management etc is on a domain basis 200.200.200.200 is a different domain to www.myserver.com even if they happed to be exactly the same location... -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 13:38 To: CF-Talk Subject: Problem with CFFILE (sort of) OK got a strange one. I think this will end up being an NT permissions problem but thought one of you may have come across it. I have a web site which sits on 2 seperate web servers. It is load balanced and state is maintained via client variables stored in SQL server on a 3rd machine. All 3 are networked. I have a cfm page on both web servers which is attempting to create a file on the 3rd machine using cffile. Both web servers have mapped drives to a folder on the 3rd server so when this cfm page is requested it writes a file to the same place regardless of which web server delivered the page (due to load balancing). The problem I am having is that when CFServer executes the cffile command it says that it can't access the file. I have checked all the permissions on the NT server and that folder is opened up for full access to everyone. I have tried sucessfully to create a file in this folder from a dosbox on one of the webservers so the path I'm using is definitely correct. To complicate the problem I have changed the code to write to C:\ (which exists on both web servers) as opposed to the mapped drive to the 3rd server. This works fine. However I can't use this as I won't know which C drive it has created the file on due to the load balancing and when request the next page which looks for this file it will not find it if the page gets delivered from the other web server. Finally I put a specific IP address in the url that requests the page that creates the file and subsequently reads it so I could guarantee that it would write and read to the same server (ie bypass load balancing). But when I did this the session auomaically expired (which I don't understand). Has anyone ever come across anything remotely similar to this by any remote chance!??? Andy -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- 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)207 387 8890. ~~ Structure your ColdFusion
RE: Problem with CFFILE (sort of)
You should really use UNC instead a mapped drive . Check out some links from http://www.cffaq.org/cfserveruseraccount.cfm Justin [EMAIL PROTECTED] -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 1:38 PM To: CF-Talk Subject: Problem with CFFILE (sort of) OK got a strange one. I think this will end up being an NT permissions problem but thought one of you may have come across it. I have a web site which sits on 2 seperate web servers. It is load balanced and state is maintained via client variables stored in SQL server on a 3rd machine. All 3 are networked. I have a cfm page on both web servers which is attempting to create a file on the 3rd machine using cffile. Both web servers have mapped drives to a folder on the 3rd server so when this cfm page is requested it writes a file to the same place regardless of which web server delivered the page (due to load balancing). The problem I am having is that when CFServer executes the cffile command it says that it can't access the file. I have checked all the permissions on the NT server and that folder is opened up for full access to everyone. I have tried sucessfully to create a file in this folder from a dosbox on one of the webservers so the path I'm using is definitely correct. To complicate the problem I have changed the code to write to C:\ (which exists on both web servers) as opposed to the mapped drive to the 3rd server. This works fine. However I can't use this as I won't know which C drive it has created the file on due to the load balancing and when request the next page which looks for this file it will not find it if the page gets delivered from the other web server. Finally I put a specific IP address in the url that requests the page that creates the file and subsequently reads it so I could guarantee that it would write and read to the same server (ie bypass load balancing). But when I did this the session auomaically expired (which I don't understand). Has anyone ever come across anything remotely similar to this by any remote chance!??? Andy -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- 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)207 387 8890. ~~ 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: Problem with CFFILE (sort of)
writes a file to a Linux server. This works ok - the only difference is that there is only one web server serving the pages and hence no load balancing. Linux is unlikly to be supprting the full Windows set of permissions (I certainly had problems with a Samba server and NT for a while...), so thats quite a big difference. ~~ 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: Problem with CFFILE (sort of)
We've also tried mapping a drive to a folder on the same server (NT) and it works fine in the test suite but not in the live suite -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- 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)207 387 8890. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 13:58 To: CF-Talk Subject: RE: Problem with CFFILE (sort of) writes a file to a Linux server. This works ok - the only difference is that there is only one web server serving the pages and hence no load balancing. Linux is unlikly to be supprting the full Windows set of permissions (I certainly had problems with a Samba server and NT for a while...), so thats quite a big difference. ~~ 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
OLEDB vs. ODBC
I have set up an OLEDB datasource and an ODBC datasource within the Coldfusion Administrator (4.5.1 Sp2) so I can compare the processing times of each datasource. I then ran each datasource on the same database and the same .cfm file. The database is an Access 2000 database, my provider is Microsoft.Jet.OLEDB.4.0, my system is W2K Sp1, and the browser is IE 5.5. The OLEDB was actually slower than the ODBC connection. I have read that OLEDB was faster than ODBC. Is the test I've run the exception to the rule? Are there modifications to Coldfusion Administrator that will allow OLEDB to run faster? Attempt 1 2 3 ODBC (milliseconds) 14100 14130 13710 OLEDB (milliseconds)18827 18507 18337 Thanks, Jim Christiano Clearwire Technologies, Inc. ~~ 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: Problem with CFFILE (sort of)
Uh...ignore my last mail in response to this!.I am unable to write to a mapped drive to an NT server in both the test suite and the Live server!...I'm going to try what Daniel suggested and run CF as a user account and see what happensI'll let you all know what happens! -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- 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)207 387 8890. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 13:58 To: CF-Talk Subject: RE: Problem with CFFILE (sort of) writes a file to a Linux server. This works ok - the only difference is that there is only one web server serving the pages and hence no load balancing. Linux is unlikly to be supprting the full Windows set of permissions (I certainly had problems with a Samba server and NT for a while...), so thats quite a big difference. ~~ 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: Problem with CFFILE (sort of)
well - just try it runnig on a user account that has permissions to that server It shouldnt work over a local network logged in as system - the system account on NT gives full access to the local system - and no access whatsoever to networked systems using the NT security model. search the archives its cropped up loads of times... I've had it happen myself when I was learning CF... -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 13:53 To: CF-Talk Subject: RE: Problem with CFFILE (sort of) Cold Fusion is logged on as the system account but I don't think that's the problem because I have set up the same system on a test suite of servers where Coldfusion is running as the system account on an NT server and it writes a file to a Linux server. This works ok - the only difference is that there is only one web server serving the pages and hence no load balancing. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- 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)207 387 8890. -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 13:45 To: CF-Talk Subject: RE: Problem with CFFILE (sort of) IS Coldfusion logged on as a user account or as system - it needs to be logged on as a user to access files over the network. session management etc is on a domain basis 200.200.200.200 is a different domain to www.myserver.com even if they happed to be exactly the same location... -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 13:38 To: CF-Talk Subject: Problem with CFFILE (sort of) OK got a strange one. I think this will end up being an NT permissions problem but thought one of you may have come across it. I have a web site which sits on 2 seperate web servers. It is load balanced and state is maintained via client variables stored in SQL server on a 3rd machine. All 3 are networked. I have a cfm page on both web servers which is attempting to create a file on the 3rd machine using cffile. Both web servers have mapped drives to a folder on the 3rd server so when this cfm page is requested it writes a file to the same place regardless of which web server delivered the page (due to load balancing). The problem I am having is that when CFServer executes the cffile command it says that it can't access the file. I have checked all the permissions on the NT server and that folder is opened up for full access to everyone. I have tried sucessfully to create a file in this folder from a dosbox on one of the webservers so the path I'm using is definitely correct. To complicate the problem I have changed the code to write to C:\ (which exists on both web servers) as opposed to the mapped drive to the 3rd server. This works fine. However I can't use this as I won't know which C drive it has created the file on due to the load balancing and when request the next page which looks for this file it will not find it if the page gets delivered from the other web server. Finally I put a specific IP address in the url that requests the page that creates the file and subsequently reads it so I could guarantee that it would write and read to the same server (ie bypass load balancing). But when I did this the session auomaically expired (which I don't understand). Has anyone ever come across anything remotely similar to this by any remote chance!??? Andy -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the
RE: Problem with CFFILE (sort of)
If you create a domain account with access to the shared drive that will work. (running cf under that account) Otherwise if you create an account with the same username password on each box that will work too I do this with out problem.. Justin -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 1:54 PM To: CF-Talk Subject: RE: Problem with CFFILE (sort of) You should really use UNC instead a mapped drive . Check out some links from http://www.cffaq.org/cfserveruseraccount.cfm Justin [EMAIL PROTECTED] -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 1:38 PM To: CF-Talk Subject: Problem with CFFILE (sort of) OK got a strange one. I think this will end up being an NT permissions problem but thought one of you may have come across it. I have a web site which sits on 2 seperate web servers. It is load balanced and state is maintained via client variables stored in SQL server on a 3rd machine. All 3 are networked. I have a cfm page on both web servers which is attempting to create a file on the 3rd machine using cffile. Both web servers have mapped drives to a folder on the 3rd server so when this cfm page is requested it writes a file to the same place regardless of which web server delivered the page (due to load balancing). The problem I am having is that when CFServer executes the cffile command it says that it can't access the file. I have checked all the permissions on the NT server and that folder is opened up for full access to everyone. I have tried sucessfully to create a file in this folder from a dosbox on one of the webservers so the path I'm using is definitely correct. To complicate the problem I have changed the code to write to C:\ (which exists on both web servers) as opposed to the mapped drive to the 3rd server. This works fine. However I can't use this as I won't know which C drive it has created the file on due to the load balancing and when request the next page which looks for this file it will not find it if the page gets delivered from the other web server. Finally I put a specific IP address in the url that requests the page that creates the file and subsequently reads it so I could guarantee that it would write and read to the same server (ie bypass load balancing). But when I did this the session auomaically expired (which I don't understand). Has anyone ever come across anything remotely similar to this by any remote chance!??? Andy -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- 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)207 387 8890. ~~ 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 Read error code when using CFFile
Yes I did, finally. Thank You to anyone who answered this, I have gotten it figured out and working great. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 7:47 PM To: CF-Talk Subject: Re: How to Read error code when using CFFile I am attempting to check for the existence of a file on my hard drive. Have you tried the FileExists() function? cfif FileExists(some file) Great.. cfelse Drat.. /cfif http://cfhub.com/language/index.cfm?ID=85 ~~ 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
Removing Duplicate Values in a List
I have a List that is generated from a query, How about do I remove duplicate values within the list? I couldn't find any kind of reference to this anywhere not even in Ben's Bible. Thanks for your help! Jason Larson [EMAIL PROTECTED] 406-728-4422 ~~ 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: barbecue grill
Only if I'm invited to the party.. Erika -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 25, 2000 7:01 PM To: CF-Talk Subject: OT: barbecue grill anyone know what brand/models i should get? i'm havin a party soon eh heh ~~ 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: Problem with CFFILE (sort of)
OK I can't seem to restart cold fusion as anything other than the local system account. I have created a new user which is part of Domain users and Users but when I try to start Cold Fusion I get an "Internal NT error" number 2140 "Unable to start ColdFusion Service" -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- 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)207 387 8890. -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 13:45 To: CF-Talk Subject: RE: Problem with CFFILE (sort of) IS Coldfusion logged on as a user account or as system - it needs to be logged on as a user to access files over the network. session management etc is on a domain basis 200.200.200.200 is a different domain to www.myserver.com even if they happed to be exactly the same location... -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 13:38 To: CF-Talk Subject: Problem with CFFILE (sort of) OK got a strange one. I think this will end up being an NT permissions problem but thought one of you may have come across it. I have a web site which sits on 2 seperate web servers. It is load balanced and state is maintained via client variables stored in SQL server on a 3rd machine. All 3 are networked. I have a cfm page on both web servers which is attempting to create a file on the 3rd machine using cffile. Both web servers have mapped drives to a folder on the 3rd server so when this cfm page is requested it writes a file to the same place regardless of which web server delivered the page (due to load balancing). The problem I am having is that when CFServer executes the cffile command it says that it can't access the file. I have checked all the permissions on the NT server and that folder is opened up for full access to everyone. I have tried sucessfully to create a file in this folder from a dosbox on one of the webservers so the path I'm using is definitely correct. To complicate the problem I have changed the code to write to C:\ (which exists on both web servers) as opposed to the mapped drive to the 3rd server. This works fine. However I can't use this as I won't know which C drive it has created the file on due to the load balancing and when request the next page which looks for this file it will not find it if the page gets delivered from the other web server. Finally I put a specific IP address in the url that requests the page that creates the file and subsequently reads it so I could guarantee that it would write and read to the same server (ie bypass load balancing). But when I did this the session auomaically expired (which I don't understand). Has anyone ever come across anything remotely similar to this by any remote chance!??? Andy -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- 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)207 387 8890. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:
Re: Voice XML
Try http://www.voxeo.com They have examples using CF, ASP and PHP. Paul Campano wrote: Does anyone have sample code using CF and Voice XML, specfically code to query a database and use the results?. I have been to studio.tellme.com, but they only give example code in Perl and ASP. Thanks. Paul Campano Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at 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
Slightly OT: nycfug
Does anyone here belong to NYCFUG? If so, who does the website? When is the next meeting? Is it regularly scheduled? Does it get a lot of interest? Thanks! Erika -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 2:41 AM To: CF-Talk Subject: New at HoF Links to new resources are up on www.houseoffusion.com. Michael Dinowitz Publisher: Fusion Authority weekly news alert (www.fusionauthority.com/alert) Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc. (www.houseoffusion.com) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Removing Duplicate Values in a List
This is code I use. CFSET LIST = "2,1,6,3,2,99,5,2,1,4,1,1" CFSET UNIQUE_LIST = REReplace(ListSort(LIST,"Numeric"),"([^,])(,\1)*","\1","ALL") CFOUTPUT#UNIQUE_LIST#/CFOUTPUT In order to sort text, just change Numeric to TextNoCase. === Raymond Camden, Principal Spectra Compliance Engineer for Allaire Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 9:19 AM To: CF-Talk Subject: Removing Duplicate Values in a List I have a List that is generated from a query, How about do I remove duplicate values within the list? I couldn't find any kind of reference to this anywhere not even in Ben's Bible. Thanks for your help! Jason Larson [EMAIL PROTECTED] 406-728-4422 ~~ 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: Removing Duplicate Values in a List
use the Select Distinct option thats in SQL? Select Distinct COl1,Col2,...etc from My_Table where x=y Jason Lees National Express Ltd E-Mail : [EMAIL PROTECTED] -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 14:19 To: CF-Talk Subject: Removing Duplicate Values in a List I have a List that is generated from a query, How about do I remove duplicate values within the list? I couldn't find any kind of reference to this anywhere not even in Ben's Bible. Thanks for your help! Jason Larson [EMAIL PROTECTED] 406-728-4422 ~~ 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
Any RegEx wizards about??
HELP! I hate these things.. Why won't: #REReplace("#Form.EmailText#","["]","","ALL")# work, when #REReplace("#Form.EmailText#","[(]","","ALL")# does work I bet it's the speechmarks I'm trying to replace with blanks. what should I use instead of a speechmark :-( Any help would be greatly appreciated -= Ed ~~ 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
Input type=File
Is there a way to change the button text on a file field? 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: Problem with CFFILE (sort of)
Put the user in the local administrators group. Or, see a breakdown of the actual rights needed here: http://www.defusion.com/articles/index.cfm?ArticleID=89 -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 9:22 AM To: CF-Talk Subject: RE: Problem with CFFILE (sort of) OK I can't seem to restart cold fusion as anything other than the local system account. I have created a new user which is part of Domain users and Users but when I try to start Cold Fusion I get an "Internal NT error" number 2140 "Unable to start ColdFusion Service" -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- 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)207 387 8890. -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 13:45 To: CF-Talk Subject: RE: Problem with CFFILE (sort of) IS Coldfusion logged on as a user account or as system - it needs to be logged on as a user to access files over the network. session management etc is on a domain basis 200.200.200.200 is a different domain to www.myserver.com even if they happed to be exactly the same location... -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 13:38 To: CF-Talk Subject: Problem with CFFILE (sort of) OK got a strange one. I think this will end up being an NT permissions problem but thought one of you may have come across it. I have a web site which sits on 2 seperate web servers. It is load balanced and state is maintained via client variables stored in SQL server on a 3rd machine. All 3 are networked. I have a cfm page on both web servers which is attempting to create a file on the 3rd machine using cffile. Both web servers have mapped drives to a folder on the 3rd server so when this cfm page is requested it writes a file to the same place regardless of which web server delivered the page (due to load balancing). The problem I am having is that when CFServer executes the cffile command it says that it can't access the file. I have checked all the permissions on the NT server and that folder is opened up for full access to everyone. I have tried sucessfully to create a file in this folder from a dosbox on one of the webservers so the path I'm using is definitely correct. To complicate the problem I have changed the code to write to C:\ (which exists on both web servers) as opposed to the mapped drive to the 3rd server. This works fine. However I can't use this as I won't know which C drive it has created the file on due to the load balancing and when request the next page which looks for this file it will not find it if the page gets delivered from the other web server. Finally I put a specific IP address in the url that requests the page that creates the file and subsequently reads it so I could guarantee that it would write and read to the same server (ie bypass load balancing). But when I did this the session auomaically expired (which I don't understand). Has anyone ever come across anything remotely similar to this by any remote chance!??? Andy -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- 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
Re: WDVL Poll
CGI is an old technology and oft times is not free. Sure, the interface is free but you need developers to code and debug the CGI. What you can code up in CF in literally minutes could take days or weeks to develop in CGI - and CGI is inherently slower. There were movements to enhanve CGI (FastCGI) but you don't see many FastCGI apps... Regards, Howie - Original Message - From: "Adrian Cooper" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, February 26, 2001 6:50 PM Subject: Re: WDVL Poll I guess the free solutions will always come out on top (I realise CGI is free). That's why you see Apache as the top webserver etc.. I am sure it isn't a reflection on the technology - just that people prefer things that are free, and/or bundled with the O/S. 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: [Any RegEx wizards about??]
try #REReplace("#Form.EmailText#","[\"]","","ALL")# "Edward Chanter" [EMAIL PROTECTED] wrote: HELP! I hate these things.. Why won't: #REReplace("#Form.EmailText#","["]","","ALL")# work, when #REReplace("#Form.EmailText#","[(]","","ALL")# does work I bet it's the speechmarks I'm trying to replace with blanks. what should I use instead of a speechmark :-( Any help would be greatly appreciated -= Ed ~~ 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: Problem with CFFILE (sort of)
Have a look at the link I sent you, they will give you info you need , for the permissions etc.. Justin -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 2:22 PM To: CF-Talk Subject: RE: Problem with CFFILE (sort of) OK I can't seem to restart cold fusion as anything other than the local system account. I have created a new user which is part of Domain users and Users but when I try to start Cold Fusion I get an "Internal NT error" number 2140 "Unable to start ColdFusion Service" ~~ 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: Building Cold Fusion Search - Dynamic SQL
since a multiple select gives you nothing more than a list, try a list loop. SELECT e.empId, es.skillId FROM emp e, empSkills es WHERE e.empId=es.empId CFLOOP INDEX="skillidx" LIST="#FORM.frmSkill#) AND skillId = #frmSkill# /CFLOOP chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Kim Mayhall [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 2:23 PM To: CF-Talk Subject: Building Cold Fusion Search - Dynamic SQL I'm trying to build some sql statements based on selections from a list box: select name="frmSkill" option Skill1 option Skill2 option Skill3 option Skill4 (etcthis size will vary as it's dynamically populated) /select A user can do a multiple select, so let's say the user picked option 1 and option 3. On my action page, I want to pick ONLY the employees that have the 2 skills selected. If I use an IN statement, I get employees with one skill or the other, but I only want those with both: SELECT e.empId,es.skillId from emp e,empSkills es where skillId IN (#frmSkill#) AND e.empId=es.empId How can I write the SQL to select only the employees with both, or do I use Cold Fusion to do that? Kim Mayhall The Garrigan Lyman Group http://www.glg.com http://www.glg.com/ (206) 223-5548 ~~ 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: Input type=File
not that I know of. As far as I have ever been able to tell, you can't change anything about the button associated with the file input type. |-Original Message- |From: Rick Eidson [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, February 27, 2001 9:34 AM |To: CF-Talk |Subject: Input type=File | |Is there a way to change the button text on a file field? | |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
Link Checker/Bot
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Has anyone written a CF link checker? I have searched around on allaire devex and can't find anything. I will probably attempt it myself, but wanted to make sure I wasn't duplicating anyone elses effort - -- Jon Tillman http://www.eruditum.org TCP/IP Illustrated... Is that the swimsuit edition? -- rgh22 -BEGIN PGP SIGNATURE- Version: PGP 6.5.1i iQA/AwUBOpu9qNga7tZtnIOtEQIwUQCeNvlCJLQvoPIn8rGH7iA3EWTlk/oAniOc qs51pM5q7f7BmLdkZuGB7KEV =4qYw -END PGP SIGNATURE- ~~ 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
Verity: Question about code generated by Wizard
If you look at the code generated by the Verity wizard in CF Studio, it stuffs most of the CFINDEX attributes using CFSET, but it simply inserts the values of the ACTION and URLPATH attributes without first setting it in a variable. For example: CFSET IndexCollection = "CollectionName" CFSET IndexDirectory = "c:\..." CFINDEX collection = "#IndexCollection#" action = "REFRESH" key = "#IndexDirectory#\" urlPath = "http://some_path_here" Is there a reason for generating the code that way? When I code the CFINDEX tag by hand I can use CFSET for all the variables with no problem. I ask because I'm working on an extension for macromedia UltraDev and I don't know why the CF Studio wizard would create the code this way. Regards, Marc Garrett ~~ 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
anyone used CF_aSession?
i'm curious if anyone has had better experiences using/managing sessions with CF_aSessions than default CF session management. i just read about CF_aSessions and it looks pretty intriguing. http://devex.allaire.com/developer/gallery/info.cfm?ID=AE230230-45FF-11D4-AA 9800508B94F380method=Full --dylan ~~ 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: WDVL Poll
Speaking of CGI, does anyone know of a decent CGI wrapper that monitors code for inappropriate behavior? Duane -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 9:37 AM To: CF-Talk Subject: Re: WDVL Poll CGI is an old technology and oft times is not free. Sure, the interface is free but you need developers to code and debug the CGI. What you can code up in CF in literally minutes could take days or weeks to develop in CGI - and CGI is inherently slower. There were movements to enhanve CGI (FastCGI) but you don't see many FastCGI apps... Regards, Howie - Original Message - From: "Adrian Cooper" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, February 26, 2001 6:50 PM Subject: Re: WDVL Poll I guess the free solutions will always come out on top (I realise CGI is free). That's why you see Apache as the top webserver etc.. I am sure it isn't a reflection on the technology - just that people prefer things that are free, and/or bundled with the O/S. 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: Any RegEx wizards about??
Try escaping the quotes: #REReplace("#Form.EmailText#","[\"]","","ALL")# Speaking of wizards... http://www.builder.com/Programming/Scripter/050698/toolrei.html -Original Message- From: Edward Chanter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 9:31 AM To: CF-Talk Subject: Any RegEx wizards about?? HELP! I hate these things.. Why won't: #REReplace("#Form.EmailText#","["]","","ALL")# work, when #REReplace("#Form.EmailText#","[(]","","ALL")# does work I bet it's the speechmarks I'm trying to replace with blanks. what should I use instead of a speechmark :-( Any help would be greatly appreciated -= Ed ~~ 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: Where is Ramonda Ramos ?
Um, where's Ramona, a quick look makes me guess that she's a government drone. cdpr.ca.gov is the California Department of Pesticide Regulation. Perhaps the pesticide fumes got to her just before she turned on the auto responder. larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- Dave Hannum wrote: Goodie! A game! Is this anything like Where's Waldo??? 8-) Dave - Original Message - From: "Massimo "Fuse" Gianadda" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, February 26, 2001 7:36 PM Subject: OT: Where is Ramonda Ramos ? Out of the office ? Max ~~ 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: Verity: Question about code generated by Wizard
Sorry about that duplicate post -- I thought the first one bounced! Marc ~~ 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: Removing Duplicate Values in a List
I've have tried this and it doesn't work. Here's a little better explaination. cfquery name="Keywords" datasource="#DS#" username="#DSUsername#" password="#DSPassword#" SELECT Keywords FROMPhotos /cfquery !--- Creates a list and Alphabetizes out of the database, i.e. bear,elk,wolve --- cfset KeywordList = ListSort(ValueList(Keywords.Keywords), "textnocase") Know is where I run into a problem. This list will contain duplicate values that I want to replace Any ideas? Thanks for your time Jason Larson [EMAIL PROTECTED] -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 7:31 AM To: CF-Talk Subject: RE: Removing Duplicate Values in a List use the Select Distinct option thats in SQL? Select Distinct COl1,Col2,...etc from My_Table where x=y Jason Lees National Express Ltd E-Mail : [EMAIL PROTECTED] -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 14:19 To: CF-Talk Subject: Removing Duplicate Values in a List I have a List that is generated from a query, How about do I remove duplicate values within the list? I couldn't find any kind of reference to this anywhere not even in Ben's Bible. Thanks for your help! Jason Larson [EMAIL PROTECTED] 406-728-4422 ~~ 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 RegEx wizards about??
Thanks Alex but it doesn't work, I get the following error Error Diagnostic Information Just in time compilation error Invalid parser construct found on line 3 at position 54. ColdFusion was looking at the following text: ] Invalid expression format. The usual cause is an error in the expression structure. The last successfully parsed CFML construct was a CFSET tag occupying document position (3:1) to (3:6). Date/Time: 02/27/01 15:00:14 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0) Remote Address: 193.122.20.2 HTTP Referer: http://www.iir-conferences.com/admin/eshot/view-search.cfm?bananas=yummy -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 2:43 PM To: CF-Talk Subject: Re: [Any RegEx wizards about??] try #REReplace("#Form.EmailText#","[\"]","","ALL")# "Edward Chanter" [EMAIL PROTECTED] wrote: HELP! I hate these things.. Why won't: #REReplace("#Form.EmailText#","["]","","ALL")# work, when #REReplace("#Form.EmailText#","[(]","","ALL")# does work I bet it's the speechmarks I'm trying to replace with blanks. what should I use instead of a speechmark :-( Any help would be greatly appreciated -= Ed ~~ 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: WDVL Poll
i don't know about FastCGI, but CGI is not a language in and of itself. it's a standard (Common Gateway Interface) for talking to web server components, etc. you can write CGI apps in PERL, C++, etc. so while i agree it might take longer to write a CGI app in, say, C++ than CF, i don't know if you're saying CGI applications are slow, because they're not necessarily. for a good overview by NCSA, see: http://hoohoo.ncsa.uiuc.edu/cgi/intro.html --dylan -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 6:37 AM To: CF-Talk Subject: Re: WDVL Poll CGI is an old technology and oft times is not free. Sure, the interface is free but you need developers to code and debug the CGI. What you can code up in CF in literally minutes could take days or weeks to develop in CGI - and CGI is inherently slower. There were movements to enhanve CGI (FastCGI) but you don't see many FastCGI apps... Regards, Howie - Original Message - From: "Adrian Cooper" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, February 26, 2001 6:50 PM Subject: Re: WDVL Poll I guess the free solutions will always come out on top (I realise CGI is free). That's why you see Apache as the top webserver etc.. I am sure it isn't a reflection on the technology - just that people prefer things that are free, and/or bundled with the O/S. 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: Any RegEx wizards about??
I hate these things.. Why won't: #REReplace("#Form.EmailText#","["]","","ALL")# work, when #REReplace("#Form.EmailText#","[(]","","ALL")# does work I bet it's the speechmarks I'm trying to replace with blanks. what should I use instead of a speechmark Not a regex problem but a balancing problem You need to double up the " inside, and you also don't need to use REReplace Replace(form.EmailText,,"","all") will work just fine 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: Problem with CFFILE (sort of)
Thank you allproblem sorted. Managed to restart CF as administrator and worked fine. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- 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)207 387 8890. -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 14:45 To: CF-Talk Subject: RE: Problem with CFFILE (sort of) Have a look at the link I sent you, they will give you info you need , for the permissions etc.. Justin -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 2:22 PM To: CF-Talk Subject: RE: Problem with CFFILE (sort of) OK I can't seem to restart cold fusion as anything other than the local system account. I have created a new user which is part of Domain users and Users but when I try to start Cold Fusion I get an "Internal NT error" number 2140 "Unable to start ColdFusion Service" ~~ 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: Input type=File
Here's a script I got to change the file button to an image. It might give you some ideas at least. form name="form" input type="Text" name="textField" action="beautyFileUpload.htm" input type="image" src="whatever.gif" name="button" value="File Upload" onclick="document.form.fileField.click(); return false;"br span id="fileField" style="display:none;"input type="File" name="fileField" onchange="document.form.textField.value=document.form.fileField.value;"/sp an input type="Submit" /form Looking over it again it looks like it just uses a button image type and then uses javascript to invoke the file functionality when clicked. So, I'm sure you could do the same thing with a regurlar button type and give it the text you would like instead of using an image. I've tested it with an image and it works in IE anyway. Rick -Original Message- From: Rick Eidson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 8:34 AM To: CF-Talk Subject: Input type=File Is there a way to change the button text on a file field? 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: Web Mining, Analysis, and Reporting
Dave, My company supports a suite of products from Cognos Corporation. These tolls are for data mining, analysis and reporting. These are also called Business Intelligence(BI) tools. if you have any more question please ask away. Thank You, Peter Peter J. MacDonald II Creative Computing, Inc. 100 Middle Street Lincoln, RI 02865 Phone: 401.727.0183 x123 Fax: 401.727.4998 Portable: 401.965.3661 E-MAIL: [EMAIL PROTECTED] Web Page: www.creatcomp.com -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 08:52 To: CF-Talk Subject: Web Mining, Analysis, and Reporting Looking for a software package used for Web Mining, Analysis, and Reporting. What are the packages everyone is currently using and would recommend? Would Allaire Spectra accomplish what I need? Thanks, Dave ~~ 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 RegEx wizards about??
Nope, it didn't work :-( -Original Message- From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 3:04 PM To: CF-Talk Subject: RE: Any RegEx wizards about?? Try escaping the quotes: #REReplace("#Form.EmailText#","[\"]","","ALL")# Speaking of wizards... http://www.builder.com/Programming/Scripter/050698/toolrei.html -Original Message- From: Edward Chanter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 9:31 AM To: CF-Talk Subject: Any RegEx wizards about?? HELP! I hate these things.. Why won't: #REReplace("#Form.EmailText#","["]","","ALL")# work, when #REReplace("#Form.EmailText#","[(]","","ALL")# does work I bet it's the speechmarks I'm trying to replace with blanks. what should I use instead of a speechmark :-( Any help would be greatly appreciated -= Ed ~~ 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
Domain Move and Data Integrity
Little bit off topic, but I wanted to ask people who uses ColdFusion to develop sites with database. Here is the situation: I need to move a site to another hosting. The site has a database and that needs to be upgraded from Access to SQL. When the domain registration modification takes place, it takes more than a couple of days to propagate through the net. So, some people will access the old site that connects to the Access database, and some people will access the new one that connects to SQL. Consequently, from the time the propagation starts to the time it finishes, there will be new data on both the databases. The integrity of the database is kept on the coding side and not on the database side, and I can't simply add the new data on Access to SQL by importing. What would people usually do in this kind of situation? I appreciate any kind of suggestions/inputs/ideas! Thanks in advance. ~~ 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: Removing Duplicate Values in a List
Use SELECT DISTINCT . Britta Wingenroth West Coast Web - Original Message - From: "Jason Larson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 6:18 AM Subject: Removing Duplicate Values in a List I have a List that is generated from a query, How about do I remove duplicate values within the list? I couldn't find any kind of reference to this anywhere not even in Ben's Bible. Thanks for your help! Jason Larson [EMAIL PROTECTED] 406-728-4422 ~~ 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: Removing Duplicate Values in a List
Jason, In order for the DISTINCT keyword to work, the query must be ordered. This query should work: cfquery name="Keywords" datasource="#DS#" username="#DSUsername#" password="#DSPassword#" SELECT DISTINCT Keywords FROMPhotos ORDER BY Keywords /cfquery cfset KeywordList = ValueList(Keywords.Keywords) Craig -Original Message- From: Jason Larson [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 10:05 AM To: CF-Talk Subject: RE: Removing Duplicate Values in a List I've have tried this and it doesn't work. Here's a little better explaination. cfquery name="Keywords" datasource="#DS#" username="#DSUsername#" password="#DSPassword#" SELECT Keywords FROMPhotos /cfquery !--- Creates a list and Alphabetizes out of the database, i.e. bear,elk,wolve --- cfset KeywordList = ListSort(ValueList(Keywords.Keywords), "textnocase") Know is where I run into a problem. This list will contain duplicate values that I want to replace Any ideas? Thanks for your time Jason Larson [EMAIL PROTECTED] -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 7:31 AM To: CF-Talk Subject: RE: Removing Duplicate Values in a List use the Select Distinct option thats in SQL? Select Distinct COl1,Col2,...etc from My_Table where x=y Jason Lees National Express Ltd E-Mail : [EMAIL PROTECTED] -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 14:19 To: CF-Talk Subject: Removing Duplicate Values in a List I have a List that is generated from a query, How about do I remove duplicate values within the list? I couldn't find any kind of reference to this anywhere not even in Ben's Bible. Thanks for your help! Jason Larson [EMAIL PROTECTED] 406-728-4422 ~~ 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
Manager of Support
Anyone know who the Manager of Support is at Allaire. Thanks Lanny Udey Hofstra University ~~ 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: Removing Duplicate Values in a List
cfquery name="Keywords" datasource="#DS#" username="#DSUsername#" password="#DSPassword#" SELECT DISTINCT Keywords FROMPhotos /cfquery This will return a query where there are no Duplicates. Jason Lees National Express Ltd E-Mail : [EMAIL PROTECTED] -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 15:05 To: CF-Talk Subject: RE: Removing Duplicate Values in a List I've have tried this and it doesn't work. Here's a little better explaination. cfquery name="Keywords" datasource="#DS#" username="#DSUsername#" password="#DSPassword#" SELECT Keywords FROMPhotos /cfquery !--- Creates a list and Alphabetizes out of the database, i.e. bear,elk,wolve --- cfset KeywordList = ListSort(ValueList(Keywords.Keywords), "textnocase") Know is where I run into a problem. This list will contain duplicate values that I want to replace Any ideas? Thanks for your time Jason Larson [EMAIL PROTECTED] -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 7:31 AM To: CF-Talk Subject: RE: Removing Duplicate Values in a List use the Select Distinct option thats in SQL? Select Distinct COl1,Col2,...etc from My_Table where x=y Jason Lees National Express Ltd E-Mail : [EMAIL PROTECTED] -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 14:19 To: CF-Talk Subject: Removing Duplicate Values in a List I have a List that is generated from a query, How about do I remove duplicate values within the list? I couldn't find any kind of reference to this anywhere not even in Ben's Bible. Thanks for your help! Jason Larson [EMAIL PROTECTED] 406-728-4422 ~~ 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: Removing Duplicate Values in a List
cfquery name="Keywords" datasource="#DS#" username="#DSUsername#" password="#DSPassword#" SELECT DISTINCT Keywords FROMPhotos ORDER BY Keywords /cfquery Let the SQL engine do the work. If you select distinct keywords they won't be duplicated. Also might as well let the engine sort them as well. - Original Message - From: "Jason Larson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 8:05 AM Subject: RE: Removing Duplicate Values in a List I've have tried this and it doesn't work. Here's a little better explaination. cfquery name="Keywords" datasource="#DS#" username="#DSUsername#" password="#DSPassword#" SELECT Keywords FROMPhotos /cfquery !--- Creates a list and Alphabetizes out of the database, i.e. bear,elk,wolve --- cfset KeywordList = ListSort(ValueList(Keywords.Keywords), "textnocase") Know is where I run into a problem. This list will contain duplicate values that I want to replace Any ideas? Thanks for your time Jason Larson [EMAIL PROTECTED] -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 7:31 AM To: CF-Talk Subject: RE: Removing Duplicate Values in a List use the Select Distinct option thats in SQL? Select Distinct COl1,Col2,...etc from My_Table where x=y Jason Lees National Express Ltd E-Mail : [EMAIL PROTECTED] -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 14:19 To: CF-Talk Subject: Removing Duplicate Values in a List I have a List that is generated from a query, How about do I remove duplicate values within the list? I couldn't find any kind of reference to this anywhere not even in Ben's Bible. Thanks for your help! Jason Larson [EMAIL PROTECTED] 406-728-4422 ~~ 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: Removing Duplicate Values in a List
Then in the Query, can you use the DISTINCT function? That way there is no duplicates. -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 10:05 AM To: CF-Talk Subject: RE: Removing Duplicate Values in a List I've have tried this and it doesn't work. Here's a little better explaination. cfquery name="Keywords" datasource="#DS#" username="#DSUsername#" password="#DSPassword#" SELECT Keywords FROMPhotos /cfquery !--- Creates a list and Alphabetizes out of the database, i.e. bear,elk,wolve --- cfset KeywordList = ListSort(ValueList(Keywords.Keywords), "textnocase") Know is where I run into a problem. This list will contain duplicate values that I want to replace Any ideas? Thanks for your time Jason Larson [EMAIL PROTECTED] -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 7:31 AM To: CF-Talk Subject: RE: Removing Duplicate Values in a List use the Select Distinct option thats in SQL? Select Distinct COl1,Col2,...etc from My_Table where x=y Jason Lees National Express Ltd E-Mail : [EMAIL PROTECTED] -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 14:19 To: CF-Talk Subject: Removing Duplicate Values in a List I have a List that is generated from a query, How about do I remove duplicate values within the list? I couldn't find any kind of reference to this anywhere not even in Ben's Bible. Thanks for your help! Jason Larson [EMAIL PROTECTED] 406-728-4422 ~~ 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: OLEDB vs. ODBC
Jim, You will see the real performance difference when you are connected to a SQL 7.0 or greater server. OLEDB is the native driver for SQL 7.0/2000. Thanks, David Sparkman, CTO iNET Messaging http://www.inetmessaging.com -Original Message- From: Architect [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 8:07 AM To: CF-Talk Subject: OLEDB vs. ODBC I have set up an OLEDB datasource and an ODBC datasource within the Coldfusion Administrator (4.5.1 Sp2) so I can compare the processing times of each datasource. I then ran each datasource on the same database and the same .cfm file. The database is an Access 2000 database, my provider is Microsoft.Jet.OLEDB.4.0, my system is W2K Sp1, and the browser is IE 5.5. The OLEDB was actually slower than the ODBC connection. I have read that OLEDB was faster than ODBC. Is the test I've run the exception to the rule? Are there modifications to Coldfusion Administrator that will allow OLEDB to run faster? Attempt 1 2 3 ODBC (milliseconds) 14100 14130 13710 OLEDB (milliseconds)18827 18507 18337 Thanks, Jim Christiano Clearwire Technologies, Inc. ~~ 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 RegEx wizards about??
Philip, Once again you've saved my sanity, it worked like a dream. Thank you very much! We are not worthy. -= Ed -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 3:06 PM To: CF-Talk Subject: RE: Any RegEx wizards about?? I hate these things.. Why won't: #REReplace("#Form.EmailText#","["]","","ALL")# work, when #REReplace("#Form.EmailText#","[(]","","ALL")# does work I bet it's the speechmarks I'm trying to replace with blanks. what should I use instead of a speechmark Not a regex problem but a balancing problem You need to double up the " inside, and you also don't need to use REReplace Replace(form.EmailText,,"","all") will work just fine 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: Cheaper Alternative to SQL Server 2000
Another weakness is that Interbase does not support outer joins of any kind. Thank You, Peter Peter J. MacDonald II Creative Computing, Inc. 100 Middle Street Lincoln, RI 02865 Phone: 401.727.0183 x123 Fax: 401.727.4998 Portable: 401.965.3661 E-MAIL: [EMAIL PROTECTED] Web Page: www.creatcomp.com -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 12:28 To: CF-Talk Subject: RE: Cheaper Alternative to SQL Server 2000 Whatever you do don't get interbase!!!it's a pigging nightmare. Besides there is a major security flaw: Interbase contains a backdoor user account and password called "LOCKSMITH". When accessed this account will eliminate all implemented security allowing full control of any database and contents within the database, this level of access will allow any function to be performed including modification of objects, root access and execution of arbitrary functions. "LOCKSMITH" is hard coded in the database engine and is located in the jrd/pwd.h header. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- 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)207 387 8890. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: 22 February 2001 16:43 To: CF-Talk Subject: Re: Cheaper Alternative to SQL Server 2000 Interbase is free. www.borland.com/interbase. You'll have to get an ODBC driver - there are several to be found for around $100. HTH, 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: "Jason Larson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, February 22, 2001 10:49 AM Subject: OT: Cheaper Alternative to SQL Server 2000 Sorry about the OT post. I was wondering if someone could give me some feedback on a cheaper alternative to SQL Server. I am on a limited budget to create my own webserver and I have only experience in developing with CF and SQL Server. I really can't afford the $5,000 that Microsoft wants for SQL Server 2000. Anybody have any suggestions? Thanks for your time Jason Larson [EMAIL PROTECTED] 406-728-4422 ~~ 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
Early Expiring Sessions
Does anyone notice on CF 4.51 SP2 that sessions expire early? I set my application to 30 minutes and I am sure the admin is set to have sessions of 1 day! ANy ideas? 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: Domain Move and Data Integrity
place a http refer on the old site to redirect everyone to the new site and only update the new one! J "You're a big man, but you're out of shape. With me it's a full time job. Now behave yourself." "Get Carter" 1964 -Original Message- From: river [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 15:29 To: CF-Talk Subject: Domain Move and Data Integrity Little bit off topic, but I wanted to ask people who uses ColdFusion to develop sites with database. Here is the situation: I need to move a site to another hosting. The site has a database and that needs to be upgraded from Access to SQL. When the domain registration modification takes place, it takes more than a couple of days to propagate through the net. So, some people will access the old site that connects to the Access database, and some people will access the new one that connects to SQL. Consequently, from the time the propagation starts to the time it finishes, there will be new data on both the databases. The integrity of the database is kept on the coding side and not on the database side, and I can't simply add the new data on Access to SQL by importing. What would people usually do in this kind of situation? I appreciate any kind of suggestions/inputs/ideas! Thanks in advance. ~~ 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: Attribute set validation Error. Why?
Yeah, I'm an idiot. I guess I'll need a group attribute [EMAIL PROTECTED] 2/26/01 1:50:53 PM This is the error I'm getting: Attribute set validation error in tag CFOUTPUT The tag has an invalid attribute combination: the most likely attribute combination is Required attributes: 'GROUP,QUERY'. Optional attributes: 'GROUPCASESENSITIVE,MAXROWS,STARTROW'. Here's the tag I'm using: cfoutput query="qMyQuery" startrow="#startrow#" maxrows="#temp#" groupcasesensitive="No" Why the hell am I getting this error? It's like the error says, "Do exactly what you're doing." I've been getting the same thing on some cfmail tags. I have all the right attributes, but it gives me this attribute set validation error. Why!? Willy Ray ~~ 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: Domain Move and Data Integrity
What I meant to say is http refer the old site to the new ip address - which should be live before the DNS updates happen. J -Original Message- From: river [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 15:29 To: CF-Talk Subject: Domain Move and Data Integrity Little bit off topic, but I wanted to ask people who uses ColdFusion to develop sites with database. Here is the situation: I need to move a site to another hosting. The site has a database and that needs to be upgraded from Access to SQL. When the domain registration modification takes place, it takes more than a couple of days to propagate through the net. So, some people will access the old site that connects to the Access database, and some people will access the new one that connects to SQL. Consequently, from the time the propagation starts to the time it finishes, there will be new data on both the databases. The integrity of the database is kept on the coding side and not on the database side, and I can't simply add the new data on Access to SQL by importing. What would people usually do in this kind of situation? I appreciate any kind of suggestions/inputs/ideas! Thanks in advance. ~~ 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
CFFILE with UNC Paths.
Anyone know a way to write a file via a UNC path? 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: Domain Move and Data Integrity
How about a re-direct to the new site's IP address for awhile until the dns is only hitting the new site. That way, all users will be using the SQL database instead of the Access one. David Schmidt, ACP -Original Message- From: river [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 7:29 AM To: CF-Talk Subject: Domain Move and Data Integrity Little bit off topic, but I wanted to ask people who uses ColdFusion to develop sites with database. Here is the situation: I need to move a site to another hosting. The site has a database and that needs to be upgraded from Access to SQL. When the domain registration modification takes place, it takes more than a couple of days to propagate through the net. So, some people will access the old site that connects to the Access database, and some people will access the new one that connects to SQL. Consequently, from the time the propagation starts to the time it finishes, there will be new data on both the databases. The integrity of the database is kept on the coding side and not on the database side, and I can't simply add the new data on Access to SQL by importing. What would people usually do in this kind of situation? I appreciate any kind of suggestions/inputs/ideas! Thanks in advance. ~~ 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: Domain Move and Data Integrity
Couldn't you just point the DSN on the access side to the SQL db until the change takes place? Jay Patton Web Design / Application Design Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com - Original Message - From: "river" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 8:28 AM Subject: Domain Move and Data Integrity Little bit off topic, but I wanted to ask people who uses ColdFusion to develop sites with database. Here is the situation: I need to move a site to another hosting. The site has a database and that needs to be upgraded from Access to SQL. When the domain registration modification takes place, it takes more than a couple of days to propagate through the net. So, some people will access the old site that connects to the Access database, and some people will access the new one that connects to SQL. Consequently, from the time the propagation starts to the time it finishes, there will be new data on both the databases. The integrity of the database is kept on the coding side and not on the database side, and I can't simply add the new data on Access to SQL by importing. What would people usually do in this kind of situation? I appreciate any kind of suggestions/inputs/ideas! Thanks in advance. ~~ 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: Removing Duplicate Values in a List
Actually, it is telling you that you need to make your query return exactly what you want. YES, using Distinct or Unique will work, but it is not the best way to get what you want out of the data. Distinct is shortcut to effectively grouping your results... or: "The DISTINCT keyword sorts the results set in ascending order by the first column listed in the DISTINCT list" So it may not give you the exact answer that you are looking for every time. In short, the repeating values are telling you to reword your query, because you didn't ask it quite right the first time. (This is, of course, my opinion... but it works for me.) Heath -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 9:19 AM To: CF-Talk Subject: Removing Duplicate Values in a List I have a List that is generated from a query, How about do I remove duplicate values within the list? I couldn't find any kind of reference to this anywhere not even in Ben's Bible. Thanks for your help! Jason Larson [EMAIL PROTECTED] 406-728-4422 ~~ 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: Virus Scanning Service
Hello! Does anyone know of any good e-mail virus scanning services (not software)? I want all of our e-mail to be passed thru a service before it is forwarded on to the recepient... Thx ~~ 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
TO USE SQL or something entirely different.
I need a good starting point. I am looking to streamline our shipping procedures. Right now I generate two queries that divide out packages that are going UPS and US mail. Thats the easy part.. These insert easily into our standard UPS software. LOL What I would like to do. Each business card order is shipped pretty much separately (for drop ship purposes and the fact that not every color is produced everyday). So A UPS query may have multiple sets of cards (records) going to the same place. How in the world can I take that query, combine all the records that are the same, add their weights up and insert them back into the list only once??? I am open for suggestions. Jeff Priority Business Cards ~~ 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: Building Cold Fusion Search - Dynamic SQL
You know, I've tried this exact code, but it pulls up 0 records even though I know there was at least one matching record.this confuses the heck out of me. A lot of people have mentioned the POST - I only put the snippet in here to show you how I'm passing itmy problem is with actually writing the query the right way. The action page is receiving the proper valuesbut I can't get the recordset to return correctly. I was sure the code that Alistair posted would work, but it doesn't.. Kim Mayhall The Garrigan Lyman Group http://www.glg.com http://www.glg.com/ (206) 223-5548 ~~ 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