RE: Client storage (RE: ColdFusion 4.0.1/SPARC/Solaris help sought - registry corruption and cf scheduler problems)
The point is that an over-large registry *significantly* increases that odds of a registry-related failure, and write actions are the worst. Since we identified this issue, we haven't had a single problem with corruption of the registry. If you get the client vars out of it, most of the access is read, not write, which actually causes nearly nill action, since as near as I can tell, the registry is read into memory when CF fires up. If you've got client vars in it, every time CF serves a page, a write occurs, updating the last-access time for the client var. Michael J. Sheldon http://www.desertraven.com/ Make a fast friend, adopt a greyhound! -Original Message- From: Ed Toon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 22:09 To: [EMAIL PROTECTED] Subject: RE: Client storage (RE: ColdFusion 4.0.1/SPARC/Solaris help sought - registry corruption and cf scheduler problems) Well, yeah, using client variables in the registry certainly won't help, but the point is that the registry on Solaris is fubar (we won't get into NT.) I'm not saying everyone should start refreshing their registry every day... I'm saying that it's not difficult at all to find yourself with a very big registry corruption problem, and there's precious little you can do to stop it, other than avoiding the registry like the plague. I'm sure we could all sit here and tell stories about CF's erratic behavior on Solaris for days. ;) Ed (Now I wonder if there's a coorelation between the traffic Solaris sites experience vs. NT sites and the number of gaping errors...) -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
query builder
Hi there I'd like to make a query builder in Cold Fusion, so that users can refine their searches by picking a table, choosing fields and providing criteria, without having to know SQL. Something like the query builder in CF Studio but even simpler - perhaps with a wizard interface. Has anyone done or seen anything like this? Thanks a lot Tom -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Verity: Allaire's Disowned Step Child?
Fire away. There is some expertise on the list dealing with Verity. dave At 09:44 AM 9/6/00 -0400, you wrote: Is there anyone here with experience setting Verity up? Someone willing to answer a couple questions? Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- dave fauth [EMAIL PROTECTED] "The opinions expressed here are my own and not those of DOMAIN technologies, inc." -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Is CF a high risk application?
SHORT ANSWER: TRUE SLIGHTLY LONGER ANSWER: The same applies to ASP, PERL, etc.. Hosting ANY application presents some sort of inherent risk to the hosting company in a SHARED environment. It's called "the nature of the beast".. Cold Fusion Enterprise Edition, with its advanced security, can even that score a bit, but most hosting companies don't really go that far unless they SPECIALIZE in CF hosting. You may want to either seek THOSE kinds of companies out, or consider CO-LOCATING your own server, which removes those risks for the company hosting the bandwidth. Of course, that would open up a whole NEW set of security considerations.. ; Packet sniffers can be a nasty thing too.. We don't host CF or ASP or any CGI for a client unless we know them and trust them (and we have rock solid contracts too)... Generally we'll host what we develop (cause we're primarily a development company). my two cents.. Gregory --- annex.com, Inc. - http://www.annex.com/ --- - If you EcoBuild it, they will come. - - http://www.ecobuilder.com/ - --- -Original Message- From: Garry Viner [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 2:39 AM To: [EMAIL PROTECTED] Subject: Is CF a "high risk application"? This is a multi-part message in MIME format. --=_NextPart_000_000E_01C01903.4B82E640 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi all We have built a CF global bank trading platform, and currently the site is doing nicely. However the powers that be are moving the hosting of the site to a new company, who have made the following comments regarding Cold Fusion. Anybody know if this is true, and what's a good line of argument for convincing them that CF is the way to proceed into the future? Here is their statement: ColdFusion is considered a "high risk application", which means that it can be installed but the server SLA no longer applies for that server(s). ColdFusion is a security risk because Allaire has not published the actual rights required for ColdFusion to run under NT. For this reason, the only choice when running ColdFusion is to allow the ColdFusion application full administrative rights. This is a security risk both because any security flaw in ColdFusion allows the attacker full administrative privileges, and because #Host# must give administrative control to the customer. Any feedback would be greatly appreciated Thanks a lot Garry Viner -- -- Red 5 Interactive Media Pty Ltd Level 4, 9-13 Bronte Rd Bondi Junction NSW 2022 Ph 61 2 9387 6493 Fax 61 2 9387 8355 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Request scope variables
The ColdFusion Locking Best Practices article http://www.allaire.com/handlers/index.cfm?ID=17318Method=FullTitle=ColdFus ion%20Locking%20Best%20PracticesCache=False talks about using the request scope when you want to use application variables for DSN names Can anyone explain what request scope variables are and when to use them? A little sample code would be really helpful :-) CF Studio help has a paragraph on the page "Passing Attribute Values between Custom Tags", but it didn't help much and a search on allaire.com didn't produce anything valuable. Thanks in advance -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Is CF a high risk application?
Actually they have published them. Look for the document entitled "running CF under a different user account" or something similar??on Allaires site. It describes how to run cf under a different account and what directories / regkeys need permissions set etc... ~Justin MacCarthy ColdFusion is a security risk because Allaire has not published the actual rights required for ColdFusion to run under NT. For this reason, the only choice when running ColdFusion is to allow the ColdFusion application full administrative rights. This is a security risk both -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Request scope variables
On 9/7/00, Aidan Whitehall penned: Can anyone explain what request scope variables are and when to use them? A little sample code would be really helpful :-) CF Studio help has a paragraph on the page "Passing Attribute Values between Custom Tags", but it didn't help much and a search on allaire.com didn't produce anything valuable. From what I understand, request is just like any local variables scope. cfset variables.dns = "mydatasource" cfset attributes.dns = "mydatasource" cfset request.dns = "mydatasource" The difference being, if you need to access the first 2 inside of a custom tag, you'd have to pass it into the tag then access it with the attributes scope. cf_mytag dsn = #variable.dns# or cf_mytag dsn = #attributes.dns# The inside the custom tag: cfquery name="myquery" datasource="#attributes.dns#" Where with the request variable, you could access it directly. cf_mytag Then inside: cfquery name="myquery" datasource="#request.dns#" Of course, it's not limited to datasource names. Any variable that you set outside the tag that you need to access inside the tag can be accessed directly without referencing them in the caller tag if you set them with the request scope. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
logon problems
Hello, First off this is not a CF problem, but I'm pickin brains so to speak to see if any web admins out there encountered this. I am running IIS 4.0 for our Intranet site. Users can access the id/password protected site using IE browser, but receive a "Authorization failed" error when entering the id and password using Netscape Navigator (it seems version does not matter). They are entered in the User Mgr and are part of Domain User, Guest, and User group. Any ideas suggestions please? Thanks. Robert O. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: logon problems
What are your authentication methods for the site? If it doesn't include Basic authentication, I don't think Netscape will be able to get to it. dave At 08:15 AM 9/7/00 -0500, you wrote: Hello, First off this is not a CF problem, but I'm pickin brains so to speak to see if any web admins out there encountered this. I am running IIS 4.0 for our Intranet site. Users can access the id/password protected site using IE browser, but receive a "Authorization failed" error when entering the id and password using Netscape Navigator (it seems version does not matter). They are entered in the User Mgr and are part of Domain User, Guest, and User group. Any ideas suggestions please? Thanks. Robert O. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- dave fauth [EMAIL PROTECTED] "The opinions expressed here are my own and not those of DOMAIN technologies, inc." -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: logon problems
Thanks for the quick reply. I have Basic Authentication checked off. If I leave out NT Challenge I believe IE users will not be able to login. RO -Original Message- From: dave fauth [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 7:34 AM To: [EMAIL PROTECTED] Subject: Re: logon problems What are your authentication methods for the site? If it doesn't include Basic authentication, I don't think Netscape will be able to get to it. dave At 08:15 AM 9/7/00 -0500, you wrote: Hello, First off this is not a CF problem, but I'm pickin brains so to speak to see if any web admins out there encountered this. I am running IIS 4.0 for our Intranet site. Users can access the id/password protected site using IE browser, but receive a "Authorization failed" error when entering the id and password using Netscape Navigator (it seems version does not matter). They are entered in the User Mgr and are part of Domain User, Guest, and User group. Any ideas suggestions please? Thanks. Robert O. -- - --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- dave fauth [EMAIL PROTECTED] "The opinions expressed here are my own and not those of DOMAIN technologies, inc." --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_ talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Is CF a high risk application?
additionally, the CF service does not have to be run as an administrator. Chris Olive, DOEHRS Website Administrator -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 5:08 AM To: [EMAIL PROTECTED] Subject: Re: Is CF a "high risk application"? Actually they have published them. Look for the document entitled "running CF under a different user account" or something similar??on Allaires site. It describes how to run cf under a different account and what directories / regkeys need permissions set etc... ~Justin MacCarthy ColdFusion is a security risk because Allaire has not published the actual rights required for ColdFusion to run under NT. For this reason, the only choice when running ColdFusion is to allow the ColdFusion application full administrative rights. This is a security risk both -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: query builder
Tom, What your looking for is generically called Query By Example (QBE). There was a CFDJ article on it about a year ago. There's also a product called HotQuery which does this. Here's info from its web site, www.hotquery.com: "HotQuery is a web browser based, enterprise database query engine reporting tool for Oracle SQL Server. There's no other product like HotQuery available! HotQuery allows you to view, query report on your Oracle SQL Server tables views, directly from any standard web browser. You gain complete access to your corporate data. With HotQuery you can create save any valid SQL query. The exclusive HotQuery-By-Example interface makes it easy for any user to find important information with point click simplicity ease of use. The HotExport HotPrint features allow users to retrieve data to their PC for use in any program. Query results can be emailed immediately. Load data into MS Excel, Word or a local database." I don't use HotQuery but it looks good, and now it supports queries from multiple tables, a key feature lacking in earlier versions. I have written an intranet app which does this as well. The first page lets you construct the "where" clause. The second page lets you pick database fields to construct the "select" clause. The code then constructs the "from" clause and the proper table joins, submits the query and displays the results. A search for "QBE" on the CFDJ web site turned up CF_QBE as well. -David On Thu, 07 Sep 2000 08:29:49 +0200 Tom Dyson [EMAIL PROTECTED] writes: Hi there I'd like to make a query builder in Cold Fusion, so that users can refine their searches by picking a table, choosing fields and providing criteria, without having to know SQL. Something like the query builder in CF Studio but even simpler - perhaps with a wizard interface. Has anyone done or seen anything like this? YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: logon problems
This is a multi-part message in MIME format. --=_NextPart_000_0029_01C018A2.F1737C60 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable I agree, if Challenge and Response is enabled your stuck in regards to = your Netscape users. NS - Original Message -=20 From: dave fauth=20 To: [EMAIL PROTECTED]=20 Sent: Thursday, September 07, 2000 7:34 AM Subject: Re: logon problems What are your authentication methods for the site? If it doesn't = include Basic authentication, I don't think Netscape will be able to get to = it. dave At 08:15 AM 9/7/00 -0500, you wrote: Hello, First off this is not a CF problem, but I'm pickin brains so to speak = to see if any web admins out there encountered this. I am running IIS 4.0 for our Intranet site. Users can access the = id/password protected site using IE browser, but receive a "Authorization failed" = error when entering the id and password using Netscape Navigator (it seems = version does not matter). They are entered in the User Mgr and are part of = Domain User, Guest, and User group. Any ideas suggestions please? Thanks. Robert O. = = --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit = http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dlists/cf_ta= lk or send a message to [EMAIL PROTECTED] with 'unsubscribe' = in the body. --- dave fauth [EMAIL PROTECTED] "The opinions expressed here are my own and not those of=20 DOMAIN technologies, inc." = -= - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit = http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dlists/cf_ta= lk or send a message to [EMAIL PROTECTED] with = 'unsubscribe' in the body. --=_NextPart_000_0029_01C018A2.F1737C60 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dwindows-1252" META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT size=3D2I agree, if Challenge and Response is enabled your = stuck in=20 regards to your Netscape users./FONT/DIV DIVFONT size=3D2/FONTnbsp;/DIV DIVFONT size=3D2nbsp;NS/FONT/DIV BLOCKQUOTE=20 style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; = BORDER-LEFT: #00 2px solid; MARGIN-RIGHT: 0px" DIV style=3D"FONT: 10pt arial"- Original Message - /DIV DIV=20 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"BFrom:/B=20 A [EMAIL PROTECTED] = href=3D"mailto:[EMAIL PROTECTED]"dave=20 fauth/A /DIV DIV style=3D"FONT: 10pt arial"BTo:/B A = [EMAIL PROTECTED]=20 = href=3D"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/A = /DIV DIV style=3D"FONT: 10pt arial"BSent:/B Thursday, September 07, = 2000 7:34=20 AM/DIV DIV style=3D"FONT: 10pt arial"BSubject:/B Re: logon = problems/DIV DIVBR/DIVWhat are your authentication methods for the = site?nbsp; If it=20 doesn't includeBRBasic authentication, I don't think Netscape will = be able=20 to get to it.BRBRdaveBRBRAt 08:15 AM 9/7/00 -0500, you=20 wrote:BRgt;Hello,BRgt;BRgt;First off this is not a CF = problem, but=20 I'm pickin brains so to speak to seeBRgt;if any web admins out = there=20 encountered this.BRgt;BRgt;I am running IIS 4.0 for our Intranet = site.=20 Users can access the id/passwordBRgt;protected site using IE = browser, but=20 receive a "Authorization failed" errorBRgt;when entering the id and = password using Netscape Navigator (it seems versionBRgt;does not = matter).=20 They are entered in the User Mgr and are part ofnbsp; = DomainBRgt;User,=20 Guest, and User group.BRgt;BRgt;Any ideas suggestions please?=20 Thanks.BRgt;BRgt;Robert=20 = O.BRgt;BRgt;---= BR---BRgt;Archives:=20 A=20 = href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"http://ww= [EMAIL PROTECTED]//ABRgt;To=20 Unsubscribe visitBRA=20 = href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsamp;body=3D= lists/cf_talk"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsamp= ;body=3Dlists/cf_talk/A=20 orBRsend a message to A=20 = href=3D"mailto:[EMAIL PROTECTED]"cf-talk-request@houseof= fusion.com/A=20 with 'unsubscribe' inBRthe = body.BRgt;BRgt;BR---BRdave=20 fauthBRA=20 = href=3D"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/ABRB= R"The=20 opinions expressed hereBRare my own and not those of BRDOMAIN=20 technologies,=20 = inc."BR=
No Subject
Hello pleas help me i have the following error Message. -- [Thu Sep 7 14:56:17 2000] [notice] bt_init[1282]: mapped ClusterCATS shared state at 0xff2e. [Thu Sep 7 14:56:17 2000] [notice] bt_init[1282]: sending ClusterCATS Hello message for server 213.68.26.50. [Thu Sep 7 14:56:17 2000] [alert] bt_init[1282]: ClusterCATS server filter config mismatch forserver 213.68.26.50. Trying next known server address. [Thu Sep 7 14:56:17 2000] [alert] bt_init[1282]: ClusterCATS server does not recognize this instance of the Apache server! Aborting! Thanks for every help -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: ColdFusion 4.0.1/SPARC/Solaris help sought - registry corruption and cf scheduler problems
My personal opinion is that if you are writing multi platform software using something like the registry is a not so great idea. Heck relying on the registry is a not so great idea just given the chance it has of going corrupt from some other software screwing it up. Where, if you wrote your own configuration database which should not be incredibly complex since I have written something very similar just on a smaller scale for a C program I was working with. I realize they use the registry for things like client variables but I just think the whole idea is a bit hokey and I wouldnt trust it at all. Makes no sense to destabalize your software so much when the solution is not that difficult. Jeremy Allen [EMAIL PROTECTED] -Original Message- From: Ed Toon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 3:44 PM To: [EMAIL PROTECTED] Subject: RE: ColdFusion 4.0.1/SPARC/Solaris help sought - registry corruption and cf scheduler problems I don't think there will ever be any resolution to the registry problems... my suspicion has always been that the problem lied with the Bristol libraries, since Allaire wouldn't say a damn word about it. Granted, they never wanted to talk much about Solaris, but at least they would look at other issues. You might want to try your luck with a premium support ticket, or hunt down someone like Sim Simeonov at Allaire, and maybe they'll actually get you a fix. But my suspicion is that they'll just tell you to upgrade. What we ended up doing was regularly pulling one machine out, replacing the registry, rebooting... crappy? Yes! But it at least keeps up the appearance of functioning servers. Good luck, Ed. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
How to Auto downloading of file
I have create a program that will create a excel file. Cool, this works great, but what I need to do next is not so clear. How do I allow the user to create the file on their local computer? Using this code: CFSET OUTFILE="E:\inetpub\wwwroot\vsts\ExcelExport.txt", creates the file on the server. I need to create this file on the users local HD. Thanks for the help. Jim Ray -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Web servers
Are there any advantages in running Website over the native IIS5 with CF/Win2K? Oh great, now you did it. This thread won't die for a week or two. :) I've run both (and Apache for that matter). IIS can't handle as many domains on a single server as WebSite. This has to do with the intigration of IIS into NT, specifically in regards to security. As always, integration has its pros and cons. WebSite seems to handle pure CGI apps much better than IIS. However, (and this comes from personal experience and therefore cannot be verified by statistics :P) ISAPI seems to be faster and more powerful than WSAPI. For this matter, and the fact that I don't run that many domains on a single server, I only run ColdFusion sites on IIS. In fact, I saw a tremendous performance gain switching my ColdFusion sites from WebSite to IIS to the extent that competitors were asking what we had done to our service to speed it up. :) There are some other things to think about as well. If you may need to support ASP pages, you'll definitely want to go with IIS. Another consideration is SSL keys. An SSL key can be moved from one server to another as long as they are running the same Web server. This would suggest that you go with the product with a greater user base (both now and in the future). This would be an argument in favor of IIS which holds 20% of the market as oposed to WebSite which holds .5% of the market. Of course, the natural extension to this argument is to use Apache (60%). :) From a managability standpoint, IIS has more anoying little habits like the naming the logs directory "W3SVC#." Although I'm not a big fan of the MMC (the app framework from which you manage IIS) the interface from which WebSite is managed is horendous. One of the best arguments in IIS's favor is that it is free (with the purchase of the operating system of course). But, as far as support goes, you're on your own. You've got the mailing lists, the news groups, a couple books, and the MSKB. If you fork out the cash for WebSite, you have what I consider to be the best tech support in the industry. Sorry about the long winded answer. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Is CF a high risk application?
On 9/7/00, Olive, Christopher M Mr NMR penned: additionally, the CF service does not have to be run as an administrator. What will this do to the functionality? Will this disable any features? Or will that all depend upon what permissions the User has that it's running under. I'm extremely NOT NT-centric, so be kind. LOL -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Is CF a high risk application?
A good resource for this is www.defusion.com/articles/index.cfm?ArticleID=89 I just did it so several machines on the same domain could access one central Verity collection on one machine. You could always use the CFIMPERSONATE tag if you needed other rights but I haven't noticed any problems. dave At 09:45 AM 9/7/00 -0400, you wrote: your last question was correct. if i remember correctly (i have our rights and such set up correctly, so i have promptly forgotten WHY i did it this way), CF will inherit all rights of the user account under which it runs. this means that the account needs permissions to the CF bin directory (at least). my suggestion is to dink around with it. change it to a non-admin account and see what happens. Chris Olive, DOEHRS Website Administrator -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 9:40 AM To: [EMAIL PROTECTED] Subject: RE: Is CF a "high risk application"? On 9/7/00, Olive, Christopher M Mr NMR penned: additionally, the CF service does not have to be run as an administrator. What will this do to the functionality? Will this disable any features? Or will that all depend upon what permissions the User has that it's running under. I'm extremely NOT NT-centric, so be kind. LOL -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- dave fauth [EMAIL PROTECTED] "The opinions expressed here are my own and not those of DOMAIN technologies, inc." -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Is CF a high risk application?
My notes on needed rights are at http://www.defusion.com/articles/index.cfm?ArticleID=89 -Original Message- From: Olive, Christopher M Mr NMR [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 9:45 AM To: '[EMAIL PROTECTED]' Subject: RE: Is CF a "high risk application"? your last question was correct. if i remember correctly (i have our rights and such set up correctly, so i have promptly forgotten WHY i did it this way), CF will inherit all rights of the user account under which it runs. this means that the account needs permissions to the CF bin directory (at least). my suggestion is to dink around with it. change it to a non-admin account and see what happens. Chris Olive, DOEHRS Website Administrator -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 9:40 AM -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF and Websphere??
I have a client that is currently using CF for the a document retrieval site and a third party development company wants to create a similar type of retrieval process using websphere web server. I'm looking for any info regarding running both CF and Websphere and the effects that this may have. Any feedback would be appreciated. Thanks -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: replace
Try the following #GetDirectoryFromPath(CF_TEMPLATE_PATH)#filename.cfm Regards John Sheehan -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: 07 September 2000 14:57 To: CF-Talk List Subject: replace Given the following string: /directoryname/subdirectoryname/filename.cfm How could I return only the following? /directoryname/subdirectoryname Forgive me if this is obvious in the CF Docs. My brain is slow this morning. ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
HTML strip function
This is a multi-part message in MIME format.
--=_NextPart_000_0073_01C018AE.0A58ECF0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Hello,
I was wondering if there is a built in function in CF to remove any HTML
from a string.
Thanks,
Brandon Behrens
Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.com
--=_NextPart_000_0073_01C018AE.0A58ECF0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40"
head
meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1"
meta name=3DProgId content=3DWord.Document
meta name=3DGenerator content=3D"Microsoft Word 9"
meta name=3DOriginator content=3D"Microsoft Word 9"
link rel=3DFile-List href=3D"cid:[EMAIL PROTECTED]"
!--[if gte mso 9]xml
o:OfficeDocumentSettings
o:DoNotRelyOnCSS/
/o:OfficeDocumentSettings
/xml![endif]--!--[if gte mso 9]xml
w:WordDocument
w:ViewNormal/w:View
w:Zoom0/w:Zoom
w:DocumentKindDocumentEmail/w:DocumentKind
w:EnvelopeVis/
/w:WordDocument
/xml![endif]--
style
!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle15
{mso-style-type:personal-compose;
mso-ansi-font-size:11.0pt;
mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";
mso-bidi-font-family:Arial;
color:black;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
--
/style
/head
body lang=3DEN-US style=3D'tab-interval:.5in'
div class=3DSection1
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'Hello,o:p/o:p/s=
pan/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'![if =
!supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'I
was wondering if there is a built in function in CF to remove any HTML =
from a
string.o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'![if =
!supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'Thanks,o:p/o:p/=
span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'![if =
!supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'Brandon
Behrenso:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'![if =
!supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p
p class=3DMsoAutoSig!--[if supportFields]font color=3Dblackspan=20
style=3D'color:black'span =
style=3D'mso-element:field-begin'/spanspan=20
style=3D"mso-spacerun: yes"nbsp;/spanAUTOTEXTLIST \s quot;E-mail=20
Signaturequot; span =
style=3D'mso-element:field-separator'/span/span/font![endif]--f=
ont
size=3D2 color=3Dblackspan =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt;
color:black'Brandon Behrens/span/fontfont size=3D2 =
color=3Dblackspan
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt;color:black;mso-color=
-alt:
windowtext'o:p/o:p/span/font/p
p class=3DMsoAutoSigfont size=3D2 color=3Dblack face=3D"Times New =
Roman"span
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt;color:black'The =
Internet
Design Firm/span/fontfont size=3D2 color=3Dblackspan =
style=3D'font-size:11.0pt;
mso-bidi-font-size:12.0pt;color:black;mso-color-alt:windowtext'o:p/o:=
p/span/font/p
RE: Setting Dynamic Structure Variables
Thank you!
These two methods work:
CFSET temp = structinsert(evaluate(option), suboption,
evaluate("#option#_contents")) This method's from Cedric Mollet
CFSET temp = evaluate("#option#[#suboption#] = #option#_contents") This
one's from Todd Hartle
-Original Message-
From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 2:26 PM
To: '[EMAIL PROTECTED]'
Subject: Setting Dynamic Structure Variables
I don't know if anyone's run into construct problems when trying to set
dynamic structure variables on the fly.
I'm creating a structure, other["key"]=value but I want to set the whole
thing on the fly.
For example this works:
CFSET other["#suboption#"]=evaluate("#option#_contents")
But this doesn't:
CFSET option="other"
CFSET #option#["#suboption#"]=evaluate("#option#_contents")
Nor:
CFSET "#option#["#suboption#"]"=evaluate("#option#_contents")
CFSET ""#option#["#suboption#"]""=evaluate("#option#_contents")
CFSET "#option#[""#suboption#""]"=evaluate("#option#_contents")
CFSET '#option#["#suboption#"]'=evaluate("#option#_contents")
CFSET "#option#['#suboption#']"=evaluate("#option#_contents")
CFSET "#evaluate("#option#["#suboption#"]")"=evaluate("#option#_contents")
CFSET
"#evaluate("#option#[#chr(34)##suboption##chr(34)#]")"=evaluate("#option#_co
ntents")
Any ideas on how to set the structure other["#suboption#"]
I've included the whole context which this structure is being set in
Orlando Correa
IHS Web Team
Web Applications Developer, DBA
http://my.ihs.gov
CFSWITCH expression = "#option#"
CFCASE value="other"
CFSWITCH expression = "#suboption#"
CFCASE value="1"CFSET
filename="what_is_a_control_chart.htm"/CFCASE
CFCASE value="2"CFSET filename="stats.htm"/CFCASE
CFCASE value="3"CFSET filename="sample.htm"/CFCASE
CFCASE value="4"CFSET
filename="core_measures_implementation_plan.htm"/CFCASE
CFDEFAULTCASECFSET
filename="what_is_a_control_chart.htm"/CFDEFAULTCASE
/CFSWITCH
CFIF NOT IsDefined("application.#option#")
CFSET "#option#"=StructNew()
CFELSE
CFSET "#option#"=evaluate("application.#option#")
/CFIF
CFIF NOT StructKeyExists(other,suboption) OR
IsDefined("cachetime")
CFLOCK NAME="read_#option#" TIMEOUT="60"
CFFILE ACTION="READ" FILE="#dirpath##option#\#filename#"
VARIABLE="#option#_contents"
/CFLOCK
CFSET
"#option#_contents"=replacelist(evaluate("#option#_contents"),"#chr(34)#imag
es","#chr(34)##option#/images")
CFLOCK NAME="application_#option#" TIMEOUT="60"
CFSET
'#option#["#suboption#"]'=evaluate("#option#_contents")!--- HERE's the
problem code ---
CFSET "application.#option#"=evaluate(option)
CFOUTPUT#evaluate("#option#_contents")#/CFOUTPUT
/CFLOCK
CFELSE
CFOUTPUT#other["#suboption#"]##chr(13)##chr(10)#/CFOUTPUT
/CFIF
/CFCASE
CFDEFAULTCASE!--- do nothing ---/CFDEFAULTCASE
/CFSWITCH
/CFCASE
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: replace
Of course there's this too, but it's no fun. Left(GetDirectoryFromPath(x), Len(GetDirectoryFromPath(x))-1) -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFDIRECTORY Filtering?
I want to display the contents of a directory. Using CFDIRECTORY, I can restrict the output to the files that end in .XLS. with the filter property. This works just fine. However, there is one .xls file that I do NOT want to appear in the listing. It always has the same name. Can I put a statement into the filter that says, effectively... filter="*.XLS" and NOT "Main_Table.xls" I get an error message when I try this in the filter statement. Can anyone suggest a workaround? Thanks! Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: replace
Thanks. I like that even better than the one I came up with:
Replace(path_info, ListLast(path_info, "/"), "", "ALL")
And the reason I like it better is that it removes the final "/" whereas my script
didn't.
---mark
--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--
-Original Message-
From: Ed Toon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 07, 2000 7:29 AM
To: [EMAIL PROTECTED]
Subject: RE: replace
This should work...
#IIF(ListLen(x, '/') GT 1, DE(ListDeleteAt(x, listlen(x, "/"), '/')),
DE('/'))#
G'mornin. ;)
Ed
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: replace
That returns the full physical path of the template. Sorry! -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: John Sheehan [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 7:34 AM To: [EMAIL PROTECTED] Subject: RE: replace Try the following #GetDirectoryFromPath(CF_TEMPLATE_PATH)#filename.cfm Regards John Sheehan -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: 07 September 2000 14:57 To: CF-Talk List Subject: replace Given the following string: /directoryname/subdirectoryname/filename.cfm How could I return only the following? /directoryname/subdirectoryname Forgive me if this is obvious in the CF Docs. My brain is slow this morning. ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Text-parsing in long word-lists ?
Hi List I have a HTML-File that looks similar like this: !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head titleUntitled/title /head body cellobr treebr carbr shoebr truckbr applebr ... ... ... /body /html The problem: I have thousands of words like that in 20 files and I want to get them in an unordered list in a table of a database. Has s.o. already done this ? With the text-parsing features of ColdFusion ? Thank you for ideas. Uwe SD Solutions Lange Zeile 27 85435 Erding Fon: 08122/903791 Fax: 08122/903792 Mail: [EMAIL PROTECTED] Web: www.sdsolutions.de -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: HTML strip function
Use this regex function: REReplace(report, "[^]*", "", "All")
Courtney E. Payne, Developer
Fig Leaf Software
"We've got you covered"
[EMAIL PROTECTED]
www.figleaf.com
-Original Message-
From: Brandon Behrens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 07, 2000 10:29 AM
To: Cf-Talk@Houseoffusion. Com
Subject: HTML strip function
This is a multi-part message in MIME format.
--=_NextPart_000_0073_01C018AE.0A58ECF0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Hello,
I was wondering if there is a built in function in CF to remove any HTML
from a string.
Thanks,
Brandon Behrens
Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.com
--=_NextPart_000_0073_01C018AE.0A58ECF0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40"
head
meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1"
meta name=3DProgId content=3DWord.Document
meta name=3DGenerator content=3D"Microsoft Word 9"
meta name=3DOriginator content=3D"Microsoft Word 9"
link rel=3DFile-List href=3D"cid:[EMAIL PROTECTED]"
!--[if gte mso 9]xml
o:OfficeDocumentSettings
o:DoNotRelyOnCSS/
/o:OfficeDocumentSettings
/xml![endif]--!--[if gte mso 9]xml
w:WordDocument
w:ViewNormal/w:View
w:Zoom0/w:Zoom
w:DocumentKindDocumentEmail/w:DocumentKind
w:EnvelopeVis/
/w:WordDocument
/xml![endif]--
style
!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle15
{mso-style-type:personal-compose;
mso-ansi-font-size:11.0pt;
mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";
mso-bidi-font-family:Arial;
color:black;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
--
/style
/head
body lang=3DEN-US style=3D'tab-interval:.5in'
div class=3DSection1
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'Hello,o:p/o:p/s=
pan/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'![if =
!supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'I
was wondering if there is a built in function in CF to remove any HTML =
from a
string.o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'![if =
!supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'Thanks,o:p/o:p/=
span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'![if =
!supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'Brandon
Behrenso:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'![if =
!supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p
p class=3DMsoAutoSig!--[if supportFields]font color=3Dblackspan=20
style=3D'color:black'span =
style=3D'mso-element:field-begin'/spanspan=20
style=3D"mso-spacerun: yes"nbsp;/spanAUTOTEXTLIST \s quot;E-mail=20
Signaturequot; span =
style=3D'mso-element:field-separator'/span/span/font![endif]--f=
ont
size=3D2 color=3Dblackspan =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt;
color:black'Brandon Behrens/span/fontfont size=3D2 =
color=3Dblackspan
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt;color:black;mso-color=
-alt:
RE: CFDIRECTORY Filtering?
i don't believe you can do it with the filter property. however, you could just drop that logic into the display code. if the file name is Main_Table.xls, don't show it there. Chris Olive, DOEHRS Website Administrator -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 10:27 AM To: '[EMAIL PROTECTED]' Subject: CFDIRECTORY Filtering? I want to display the contents of a directory. Using CFDIRECTORY, I can restrict the output to the files that end in .XLS. with the filter property. This works just fine. However, there is one .xls file that I do NOT want to appear in the listing. It always has the same name. Can I put a statement into the filter that says, effectively... filter="*.XLS" and NOT "Main_Table.xls" I get an error message when I try this in the filter statement. Can anyone suggest a workaround? Thanks! Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: lower SQL function
Hello, Apologies for an OT question, but what are the equivalents of the Lower function in Access, MS SQL, Sybase? I know it's LOWER in Oracle, but I can't get that to work in Access. Thank you -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: HTML strip function
I was wondering if there is a built in function in CF to remove any HTML from a string. cfset text = REReplace(text, "[^]*", "", "All") --- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to Auto downloading of file
I think u can only do this if u write an ActiveX program or u can let them download it off the web -Original Message- From: Ray, James A [mailto:[EMAIL PROTECTED]] Sent: 07 September 2000 14:33 To: [EMAIL PROTECTED] Subject: How to Auto downloading of file I have create a program that will create a excel file. Cool, this works great, but what I need to do next is not so clear. How do I allow the user to create the file on their local computer? Using this code: CFSET OUTFILE="E:\inetpub\wwwroot\vsts\ExcelExport.txt", creates the file on the server. I need to create this file on the users local HD. Thanks for the help. Jim Ray -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: logon problems
I have Basic Authentication checked off. If I leave out NT Challenge I believe IE users will not be able to login. IE supports Basic Authentication as well as NTLM Authentication (NT Challenge/Response). NTLM Authentication is somewhat more secure than Basic Authentication without SSL, but you could just use Basic Authentication for all web clients. Keep in mind that the necessary user rights will differ between authentication methods. Basic Authentication through IIS requires that the user have the "Log on Locally" right to the server in question, whether through a domain or local account. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFDIRECTORY Filtering?
Just use a CFIF when outputting the contents to exlcude that file name. cfif name neq "main_table.xls" -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 7:27 AM To: '[EMAIL PROTECTED]' Subject: CFDIRECTORY Filtering? I want to display the contents of a directory. Using CFDIRECTORY, I can restrict the output to the files that end in .XLS. with the filter property. This works just fine. However, there is one .xls file that I do NOT want to appear in the listing. It always has the same name. Can I put a statement into the filter that says, effectively... filter="*.XLS" and NOT "Main_Table.xls" I get an error message when I try this in the filter statement. Can anyone suggest a workaround? Thanks! Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: HTML strip function
USE REReplace(mytext, "[^]*", "", "All")
~Justin MacCarthy
- Original Message -
From: "Brandon Behrens" [EMAIL PROTECTED]
To: "Cf-Talk@Houseoffusion. Com" [EMAIL PROTECTED]
Sent: Thursday, September 07, 2000 3:28 PM
Subject: HTML strip function
This is a multi-part message in MIME format.
--=_NextPart_000_0073_01C018AE.0A58ECF0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Hello,
I was wondering if there is a built in function in CF to remove any HTML
from a string.
Thanks,
Brandon Behrens
Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.com
--=_NextPart_000_0073_01C018AE.0A58ECF0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40"
head
meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1"
meta name=3DProgId content=3DWord.Document
meta name=3DGenerator content=3D"Microsoft Word 9"
meta name=3DOriginator content=3D"Microsoft Word 9"
link rel=3DFile-List href=3D"cid:[EMAIL PROTECTED]"
!--[if gte mso 9]xml
o:OfficeDocumentSettings
o:DoNotRelyOnCSS/
/o:OfficeDocumentSettings
/xml![endif]--!--[if gte mso 9]xml
w:WordDocument
w:ViewNormal/w:View
w:Zoom0/w:Zoom
w:DocumentKindDocumentEmail/w:DocumentKind
w:EnvelopeVis/
/w:WordDocument
/xml![endif]--
style
!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle15
{mso-style-type:personal-compose;
mso-ansi-font-size:11.0pt;
mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";
mso-bidi-font-family:Arial;
color:black;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
--
/style
/head
body lang=3DEN-US style=3D'tab-interval:.5in'
div class=3DSection1
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'Hello,o:p/o:p/s=
pan/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'![if =
!supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'I
was wondering if there is a built in function in CF to remove any HTML =
from a
string.o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'![if =
!supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'Thanks,o:p/o:p/=
span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'![if =
!supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'Brandon
Behrenso:p/o:p/span/font/span/p
p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 =
color=3Dblack
face=3D"Times New Roman"span =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'![if =
!supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p
p class=3DMsoAutoSig!--[if supportFields]font color=3Dblackspan=20
style=3D'color:black'span =
style=3D'mso-element:field-begin'/spanspan=20
style=3D"mso-spacerun: yes"nbsp;/spanAUTOTEXTLIST \s quot;E-mail=20
Signaturequot; span =
style=3D'mso-element:field-separator'/span/span/font![endif]--f=
ont
size=3D2 color=3Dblackspan =
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt;
color:black'Brandon Behrens/span/fontfont size=3D2 =
color=3Dblackspan
style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt;color:black;mso-color=
-alt:
windowtext'o:p/o:p/span/font/p
p class=3DMsoAutoSigfont size=3D2 color=3Dblack face=3D"Times New =
Roman"span
RE: Request scope variables
Can anyone explain what request scope variables are and when to use them? A little sample code would be really helpful :-) CF Studio help has a paragraph on the page "Passing Attribute Values between Custom Tags", but it didn't help much and a search on allaire.com didn't produce anything valuable. The Request scope is available to all scripts used to generate a single response to a request. So, let's say you call index.cfm from your browser, and index.cfm calls the cf_foo custom tag, which in turn calls the cf_bar custom tag, which in turn recurses. The Request scope will be the same for all of them, as opposed to the local variables scope which will be unique to each of them. I find the Request scope to be useful for two things: 1. Setting "constants" which should be available to all scripts within an application, including custom tags. Some people use the Application scope for this, but if I can avoid having one more thing that needs a CFLOCK, I'm happy. The Request scope is ideal for this. 2. Dealing with variables through multiple custom tag iterations (recursion, etc). It's my understanding that this is specifically why the Request scope was introduced - Spectra uses so many custom tags in this way that it would have been much more difficult without the Request scope. Sorry, but no code sample. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
simple date problem major brain fart
Lets say CurrentDate is 9/7/2000 and you need to do a check to see if DateToCheck is equal to or greater than CurrentDate - 7 days. if you subtract 7 from the days you get 9/0/2000 which is an invalid date. Is there an easy way to do this? Please help, my brain is full of gas Art _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Client storage (RE: ColdFusion 4.0.1/SPARC/Solaris help sought - registry corruption and cf scheduler problems)
If you're using client vars, get them into a database. If you're not using them, make absolutely sure they're not enabled anywhere. I'd like to strongly second this recommendation. No one, under any circumstances, should store client variables for an application within the registry. The registry, under NT or Solaris with WindU, isn't a good repository for volatile data. That's not what it's designed for, and it will fail. Export your registry, the only client var entries you should see will be from use of the CF Administrator application. (Though why in all of heaven and earth they are enabled there, I'll never know.) You can actually move these out as well, by changing the default client storage repository to a specific database. Of course, the problem with this is that if the database becomes unavailable, you won't be able to run the CF Administrator. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Client storage (RE: ColdFusion 4.0.1/SPARC/Solaris help sought - registry corruption and cf scheduler problems)
This has nothing to do with client variables. Cold Fusion uses the Registry a great deal itself internally. For example, all datasource info, scheduled tasks, etc... Most of this is done when the service starts up, and reads the data from the Registry. The Registry isn't designed to store volatile data. It's a repository for configuration data. CF doesn't actually interact much with the registry during normal operations. If you were going to measure registry reads and writes from CF on a busy CF server (using NTREGMON from http://www.sysinternals.com/ for example), you'd find them to be negligible. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: query builder
I'd like to make a query builder in Cold Fusion, so that users can refine their searches by picking a table, choosing fields and providing criteria, without having to know SQL. Something like the query builder in CF Studio but even simpler - perhaps with a wizard interface. Has anyone done or seen anything like this? You might find this helpful: http://devex.allaire.com/developer/gallery/SearchResults.cfm?keywords=QBE Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
PROBLEM with ALLAIRE CUSTOMER SERVICE ?
Does anyone have tried to contact Allaire Customer support ? I tryed many times, for the past 9 days and I never received any answer form Allaire Company! Am I the only one facing this problem? Yanik Lupien Visicom Media http://www.visic.com http://www.gograph.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: lower SQL function
Try LCase Regards, Howie - Original Message - From: "Stas Newdel" [EMAIL PROTECTED] To: "CFTalk" [EMAIL PROTECTED] Sent: Thursday, September 07, 2000 10:49 AM Subject: OT: "lower" SQL function Hello, Apologies for an OT question, but what are the equivalents of the Lower function in Access, MS SQL, Sybase? I know it's LOWER in Oracle, but I can't get that to work in Access. Thank you -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFDIRECTORY Filtering?
you could certainly just nuke the offending records from the returned recordset when the list is rather small and it is just an output issue of not seeing certain files (and hey, you also typically do NOT want to see the "." and ".." record anyway, right?), you could just have a variable set like cfset IgnoredFilesList = (.,..,myexcel.xls) and then when you loop over the file list do a CFIF on the IgnoredFiles List for the current row's filename. - Original Message - From: Claremont, Timothy S [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 07, 2000 10:27 AM Subject: CFDIRECTORY Filtering? I want to display the contents of a directory. Using CFDIRECTORY, I can restrict the output to the files that end in .XLS. with the filter property. This works just fine. However, there is one .xls file that I do NOT want to appear in the listing. It always has the same name. Can I put a statement into the filter that says, effectively... filter="*.XLS" and NOT "Main_Table.xls" I get an error message when I try this in the filter statement. Can anyone suggest a workaround? Thanks! Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Help needed with a datasource problem
Folks, I hope someone can advise me on this: Successfully running CF 4.5.1 on NT 4.0 SP5 using Oracle73 (7.3.4) as a datasource Installed Oracle 8.1.5 (8i). Migrated database to 8i. Accessed migrated database via SQL*Plus. Verified that it worked and was indeed running under Oracle 8.1.5 In CF Administrator, configured new datasource specifying Oracle80 as the database and the same user id and password that I used above in the SQL*Plus. CF Verification failed! Why? SQL*Plus worked. Why not CF? Any help will be appreciated Thanks, -- Tim Dempsey -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Problem with URLDecode
Hello, Can anyone help me with this problem? I am trying to get a trademark character #8482; to translate back into its correct text. When I display it to screen before the CF Code that uses it in a query all works fine (except that in order to display it at this point put's it in the wrong place), however if I do the query before displaying it it won't work. I have put the URLDecode around it and it still stays encoded. It actually starts out as the characters, but being passed through Form Fields it gets translated to the encoded version (it is being passed around in the variable Criteria_#ThisRow#). Any ideas would very much be appreciated. Terry Stewart -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Web servers
- Original Message - From: "Benjamin S. Rogers" [EMAIL PROTECTED] Sent: Thursday, September 07, 2000 2:38 PM server, I only run ColdFusion sites on IIS. In fact, I saw a tremendous performance gain switching my ColdFusion sites from WebSite to IIS to the extent that competitors were asking what we had done to our service to speed it up. :) Thanks - that is what I was trying to get too :-) Adrian Cooper. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Web servers
- Original Message - From: "Ed Toon" [EMAIL PROTECTED] Sent: Thursday, September 07, 2000 1:37 AM Yes... WebSite doesn't suck donkey balls. OK - apart from that? Adrian Cooper. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OUTER JOIN w/more than 2 tables
Ok, I have never done this with RIGHT JOINs, just LEFT JOINs. The trick to making it work is you put () around one the joins and treat that as if it is one table and join that to the third table. This will not be right for your case, but let me do a SQL statement with the three tables below as a LEFT JOIN totally. SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID, Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName, Customers.PhoneNumber, Customers.EmailAddress FROM (Calendar LEFT OUTER JOIN FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID) LEFT OUTER JOIN Customers ON Customers.CustomerID = Calendar.CustomerID Ok, this one should work, bringing up all the Calendar results and only those associated FixedTeeTimes and Customers. Maybe you want to bring up all the customers and their associatioed FixedTeeTimes and Calendar results, well that would look like this with LEFT JOINS: SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID, Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName, Customers.PhoneNumber, Customers.EmailAddress FROM (Customers LEFT OUTER JOIN Calendar ON Customers.CustomerID = Calendar.CustomerID) LEFT OUTER JOIN FixedTeeTimes ON FixedTeeTimes.TeeID = Calendar.TeeID What the trick is that there is () around one of the joins and then you treat that as a single table that has all the columns of the first two tables and join it on a third. I have not tried with RIGHT JOINs yet, and I am having a lot of trouble figuring out how to order it to work with RIGHT JOINs, but I think the LEFT JOIN SQL statement I just gave above should accomplish what you want, if I am guessing right from your SQL statement. Hope this helps you to understand joining multiple tables better... Justin Kidman -Original Message- From: Mark Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 7:13 PM To: [EMAIL PROTECTED] Subject: Re: OUTER JOIN w/more than 2 tables Hey, Justin This is wierd I post a message it takes about 3 to 4 hours before its posted. Is that normal for this list? Anyway I thought it would be more productive to just email you direct I'm still not getting anywhere with this OUTER JOIN thing as I said before I have successfully done these with 2 tables no problem, but when I add a 3rd table then there's a problem. MS Access says to create two queries then refer to the 1st query with the 2nd this does work but it seems like there is a better way. !-Here is the code you sent- SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID, Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName, Customers.PhoneNumber, Customers.EmailAddress FROM (oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID) RIGHT OUTER JOIN Customers ON Customers.CustomerID = Calendar.CustomerID !-Here is the code you sent- Here is the latest error, !-Error Message- Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Join expression not supported. I'm just not getting this stuff. It seems so easy yet its irritating the h#$%@l out of me. AHHH! HELP! -Mark - Original Message - From: Justin Kidman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 06, 2000 1:05 PM Subject: RE: OUTER JOIN w/more than 2 tables Hmm, me not cutting out enough things... Bah, no more copy paste on other ppl's code... =P Justin Kidman -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 12:01 PM To: [EMAIL PROTECTED] Subject: RE: OUTER JOIN w/more than 2 tables What is the "oj" right after the FROM? Shouldnt that not be there..? Or is oj a table and your aliasing it to Calendar?? Jeremy -Original Message- From: Mark Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 2:17 PM To: [EMAIL PROTECTED] Subject: Re: OUTER JOIN w/more than 2 tables I tried it and I keep getting this error. Its the same error I was getting before. I must be missing something. !-Error Message- ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in JOIN operation. -Mark - Original Message - From: Justin Kidman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 06, 2000 10:27 AM Subject: RE: OUTER JOIN w/more than 2 tables Do this all the time, n-table joins, just need to use () well. SELECT FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID, Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName, Customers.PhoneNumber, Customers.EmailAddress FROM oj Calendar RIGHT OUTER JOIN (FixedTeeTimes ON Calendar.TeeID = FixedTeeTimes.TeeID RIGHT OUTER JOIN Customers) ON Customers.CustomerID = Calendar.CustomerID Use the () to left if you are
RE: Using CFDIRECTORY with CFSELECT
Yes, if you use the LIST action of CFDIRECTORY, that will give you a QUERY specified by the name attribute. Then you have a QUERY you can use to populate the CFSELECT box. Justin Kidman -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 8:02 AM To: '[EMAIL PROTECTED]' Subject: Using CFDIRECTORY with CFSELECT Can I combine CFSELECT and CFDIRECTORY to allow the end user to select a file that exists in a directory? The result I am after is a drop down list of all of the .XLS files in a given directory, so that the end user can choose the file that they want to update via CFFILE. Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Using CFDIRECTORY with CFSELECT
of course :) the result of cfdirectory is a query set. Can I combine CFSELECT and CFDIRECTORY to allow the end user to select a file that exists in a directory? The result I am after is a drop down list of all of the .XLS files in a given directory, so that the end user can choose the file that they want to update via CFFILE. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Web servers
Go to their website (no pun intended =) and look at their information. They have a section comparing them to IIS and Netscape Webserver. Also, IMO, I think WebSite Pro is easier to use and more powerful than IIS, from my own experience. It makes managing a bunch of domains and aliases pretty easy with its setup. I can't wait until they get an upgrade out. Justin Kidman -Original Message- From: Adrian Cooper [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 2:18 PM To: [EMAIL PROTECTED] Subject: Re: Web servers - Original Message - From: "John Fix 3rd" [EMAIL PROTECTED] Sent: Wednesday, September 06, 2000 8:47 PM Website Pro from O'Reilly works great with Cold Fusion and Windows 2000. http://website.oreilly.com Are there any advantages in running Website over the native IIS5 with CF/Win2K? Adrian Cooper. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: logon problems
Dave, It worked! All users required to log on to the Intranet were setup as Domain Users and then I enabled Domain Users to "Log on locally". Thanks for the help and insight. With all the Knowledge base info on Microsoft I was drawing blanks on this one. Robert Orlini Web Admin -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 9:57 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: logon problems I have Basic Authentication checked off. If I leave out NT Challenge I believe IE users will not be able to login. IE supports Basic Authentication as well as NTLM Authentication (NT Challenge/Response). NTLM Authentication is somewhat more secure than Basic Authentication without SSL, but you could just use Basic Authentication for all web clients. Keep in mind that the necessary user rights will differ between authentication methods. Basic Authentication through IIS requires that the user have the "Log on Locally" right to the server in question, whether through a domain or local account. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_ talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: count() or recordcount
Well, that is kind of a weighted test then, since using Count() + data verses RecordCount + data, you are really just adding Count(), since the data and RecordCount is given with both of those. Justin Kidman -Original Message- From: Kevin Miller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 5:32 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: count() or recordcount In my situation, I needed the data anyway, so the comparison was Count() + data versus RecordCount + data. Kevin [EMAIL PROTECTED] 09/06/00 01:01PM I tested this using CF 4.01 using a 9000+ record Access database. Using Query.RecordCount was actually about 10-20% faster. The thing is that Query.RecordCount requires the db server to pull data out of the database and clog up the lan between it and cf server. Do that on a busy production server on the application.cfm file, etc and you're going to notice the performance degradation. A simple count(*) or preferably count(field) put less resource load on the overall server/lan. --min -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Using CFDIRECTORY with CFSELECT
Sure, but I'd avoid CFSELECT altogether. Just output the results of the directory list like this: form action="whateverprocessingscript.cfm" method="post" select name="whatever" cfoutput query="myDirectory" option value="#name#"#name# /cfoutput /select input type="submit" value="Show File" /form ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 8:02 AM To: '[EMAIL PROTECTED]' Subject: Using CFDIRECTORY with CFSELECT Can I combine CFSELECT and CFDIRECTORY to allow the end user to select a file that exists in a directory? The result I am after is a drop down list of all of the .XLS files in a given directory, so that the end user can choose the file that they want to update via CFFILE. Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: simple date problem major brain fart
The dateadd function does this. Just give the dateadd function a "number"
of -7. Something like:
cfset newdate=dateadd("d",-7,now())
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
- Original Message -
From: "Art Broussard" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 07, 2000 11:20 AM
Subject: simple date problem major brain fart
Lets say CurrentDate is 9/7/2000 and you need to do a check to see if
DateToCheck is equal to or greater than CurrentDate - 7 days. if you
subtract 7 from the days you get 9/0/2000 which is an invalid date. Is
there
an easy way to do this?
Please help, my brain is full of gas
Art
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: simple date problem major brain fart
If you use the DateAdd() function you won't end up
with 9/0/200.
DateAdd("d", "-7", "9/7/2000")
You also might want to look at DateDiff()
Ric
- Original Message -
From: "Art Broussard" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 07, 2000 11:20 AM
Subject: simple date problem major brain fart
Lets say CurrentDate is 9/7/2000 and you need to do a check to see if
DateToCheck is equal to or greater than CurrentDate - 7 days. if you
subtract 7 from the days you get 9/0/2000 which is an invalid date. Is
there
an easy way to do this?
Please help, my brain is full of gas
Art
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Access uploads and Remote CF restart
This is a cryptographically signed message in MIME format. --ms1C95003524CA825ECA7335D5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit De-lurking to ask if/how the can following be done? Problem: I have a client that must upload a database to my server. This database is Access97 and contains mission critical data. (This database is output from a larger, more cumbersome database that the client keeps at his location) Question: Is there a way to remotely stop and restart CF so that this client does not need to phone in and tell me when they are uploading a new database? will -- William H. Bowen misterbowen.com *Web Design Solutions for Business* [EMAIL PROTECTED] http://www.misterbowen.com/ 425.423.0794 Voice 425.740.0183 FAX ICQ#: 2062149 --ms1C95003524CA825ECA7335D5 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIIH8AYJKoZIhvcNAQcCoIIH4TCCB90CAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC BcEwggKlMIICDqADAgECAgMBZ1kwDQYJKoZIhvcNAQEEBQAwgZQxCzAJBgNVBAYTAlpBMRUw EwYDVQQIEwxXZXN0ZXJuIENhcGUxFDASBgNVBAcTC0R1cmJhbnZpbGxlMQ8wDQYDVQQKEwZU aGF3dGUxHTAbBgNVBAsTFENlcnRpZmljYXRlIFNlcnZpY2VzMSgwJgYDVQQDEx9QZXJzb25h bCBGcmVlbWFpbCBSU0EgMTk5OS45LjE2MB4XDTk5MDkxNzE1Mjg0MloXDTAwMDkxNjE1Mjg0 MlowRjEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEjMCEGCSqGSIb3DQEJARYU d2lsbEBtaXN0ZXJib3dlbi5jb20wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAOlzm9u0 WrSTiSs5uemdEFoljOltJYrtMmJt7e3A1BkYagk+fj/tNaovsW6GvcVnG68ABiBLZKNJ4DGH +uFPxfG9aEdFKats99IdiVQBz4qC1ry7Wbouj+yaW6tO/VpS8QKv2dk3o0EbFn3Yk8PzXWOd s6+rFWA9bxuFvV95ZkwPAgMBAAGjUjBQMB8GA1UdEQQYMBaBFHdpbGxAbWlzdGVyYm93ZW4u Y29tMAwGA1UdEwEB/wQCMAAwHwYDVR0jBBgwFoAUiKvxYINmVfTkWMdGHcBhvSPXw4wwDQYJ KoZIhvcNAQEEBQADgYEAM1GGG2bT8fMPoLz+ZHqqtqTr85taghWnOTF3PjUqaYeanZzBuI29 fyIYgPZKQoRm3zgdANNU9GaveX9HLc6rStY5pOplLuJuUyoWMlJ/UIXzftTw/89yPmNXAzMN ShRzJ68RRGnXoRWYreb/t+HiavJ7Yninpvdfcoq6hwN4Av0wggMUMIICfaADAgECAgELMA0G CSqGSIb3DQEBBAUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIw EAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQL Ex9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVy c29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRo YXd0ZS5jb20wHhcNOTkwOTE2MTQwMTQwWhcNMDEwOTE1MTQwMTQwWjCBlDELMAkGA1UEBhMC WkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxDzANBgNV BAoTBlRoYXd0ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1Bl cnNvbmFsIEZyZWVtYWlsIFJTQSAxOTk5LjkuMTYwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJ AoGBALNpWpfU0BYLerXFXekhnCNyzRJMS/d+z8f7ynIk9EJSrFeV43theheE5/1yOTiUtOrt ZaeSBl694GX2GbuUeXZMPrlocHWEHPQRdAC8BSxPCQMXMcz0QdRyxqZd4ohEsIsuxE3x8NaF PmzzlZR4kX5A6ZzRjRVXjsJz5TDeRvVPAgMBAAGjNzA1MBIGA1UdEwEB/wQIMAYBAf8CAQAw HwYDVR0jBBgwFoAUcknCczTGVfQLdnKBfnf0h+fGsg4wDQYJKoZIhvcNAQEEBQADgYEAa8ZZ 6TH66bbssQPY33Jy/pFgSOrGVd178GeOxmFw523CpTfYnbcXKFYFi91cdW/GkZDGbGZxE9AQ fGuRb4bgITYtwdfqsgmtzy1txoNSm/u7/pyHnfy36XSS5FyXrvx+rMoNb3J6Zyxrc/WG+Z31 AG70HQfOnZ6CYynvkwl+Vd4xggH3MIIB8wIBATCBnDCBlDELMAkGA1UEBhMCWkExFTATBgNV BAgTDFdlc3Rlcm4gQ2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxDzANBgNVBAoTBlRoYXd0 ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1BlcnNvbmFsIEZy ZWVtYWlsIFJTQSAxOTk5LjkuMTYCAwFnWTAJBgUrDgMCGgUAoIGxMBgGCSqGSIb3DQEJAzEL BgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTAwMDkwNzE2NDMwMVowIwYJKoZIhvcNAQkE MRYEFNB2aGIO00MiaNZoccGZxu2lEXmbMFIGCSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcNAwcw DgYIKoZIhvcNAwICAgCAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgFAMA0GCCqGSIb3DQMCAgEo MA0GCSqGSIb3DQEBAQUABIGAA5lqE75wIjfmvtHh8Kfsj0yZRyABkLbWM9DQ4ELY7F90xTQA jTMM70RQPJ+IO0s0SBrTL9qZY1Ny65cWWZvNEj4PVTlHsSMyrThrqtYSRtELXHIkRSyRN1J/ +UNiRXK8QAHMv4aH/M/cqXco4x6qsnmksPBWACvxYXr18ispvMs= --ms1C95003524CA825ECA7335D5-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: simple date problem major brain fart
This code should do the job:
cfset datetocheck = "#DateFormat("09/02/2000", "mm/dd/")#"
cfset currentdate = "#DateFormat(Now(), "mm/dd/")#"
cfset lastweekdate = "#DateFormat(currentdate-7, "mm/dd/")#"
cfset difference = DateDiff("d", lastweekdate, datetocheck)
cfoutput
Date to Check: #datetocheck#br
Current Date: #currentdate#br
Last Week's Date: #lastweekdate#br
Difference between last week's date and date to check: #difference#
/cfoutput
--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--
-Original Message-
From: Art Broussard [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 07, 2000 8:21 AM
To: [EMAIL PROTECTED]
Subject: simple date problem major brain fart
Lets say CurrentDate is 9/7/2000 and you need to do a check to see if
DateToCheck is equal to or greater than CurrentDate - 7 days. if you
subtract 7 from the days you get 9/0/2000 which is an invalid
date. Is there
an easy way to do this?
Please help, my brain is full of gas
Art
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Web-based email
Hi everybody, I'm trying to build a functional, usable e-mail system based on the framework of the example application included with ColdFusion. Every time I run into a snag, I wonder why I'm reinventing the wheel when others must be trying to do the same thing. There don't seem to be a lot of resources available on the subject. Are there other people out there trying to do this? -- Owen - Athens County Library Services http://www.athenscounty.lib.oh.us -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SQL Quotes (aka End of the working day in england and I'm tired)
I am trying to put a wddx string into the database. It won't go. Any ideas how to get the single quotes into the database without messing up the wddx? Paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: PROBLEM with ALLAIRE CUSTOMER SERVICE ?
Does anyone have tried to contact Allaire Customer support ? I tryed many times, for the past 9 days and I never received any answer form Allaire Company! Am I the only one facing this problem? I have been... When I finally was contacted by someone at Allaire, it wasn't a tech support person trying to fix the problem. It was instead a salesman trying to sell me a $28,000 support package from Allaire. And when I commented that I didn't appreciate someone trying to sell me support when I was still trying to resolve an issue, I was told that Allaire needed to make money. Marcus -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Using CFDIRECTORY with CFSELECT
This should work for you... cfdirectory action="LIST" directory="c:\mydocs\xls_files" name="files" filter="*.xls" sort="name" !--- stash the file names in a list --- cfset file_list = valuelist(files.name) !--- generate the select --- select name="xls_file" !--- loop through the list --- cfloop index="file_name" list="#file_list#" option value="#file_name#"#file_name#/option /cfloop /select -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 10:02 AM To: '[EMAIL PROTECTED]' Subject: Using CFDIRECTORY with CFSELECT Can I combine CFSELECT and CFDIRECTORY to allow the end user to select a file that exists in a directory? The result I am after is a drop down list of all of the .XLS files in a given directory, so that the end user can choose the file that they want to update via CFFILE. Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: simple date problem major brain fart
cfset lastweek = Now() -7 cfif DateTocheck GTE lastweekYepcfelseNope/cfif I think this should do it...you may have to play with it a bit... -Adrian -Original Message- From: Art Broussard [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 8:21 AM To: [EMAIL PROTECTED] Subject: simple date problem major brain fart Lets say CurrentDate is 9/7/2000 and you need to do a check to see if DateToCheck is equal to or greater than CurrentDate - 7 days. if you subtract 7 from the days you get 9/0/2000 which is an invalid date. Is there an easy way to do this? Please help, my brain is full of gas Art _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF/Solaris on Intel
This is a multi-part message in MIME format. --7044766746D9E10C0B119316 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi. We have a client who uses Solaris on SPARC boxes, and we need to develop a CF app for them. From what I can tell, Solaris for CF only works on SPARC. Problem is, we don't have a SPARC. Can CF for Solaris be put on an Intel box running Solaris? If not, what do you suggest? Running the Linux version? Are there any differences btwn the CF/Linux and CF/Solaris versions which would present problems when we migrate the application onto the client's SPARC? Thanks for any clues. Steve Ray --7044766746D9E10C0B119316 Content-Type: text/x-vcard; charset=us-ascii; name="sray.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Steve Ray Content-Disposition: attachment; filename="sray.vcf" begin:vcard n:; tel;fax:703.838.9799 tel;work:703.838.9777 x-mozilla-html:TRUE url:www.matrixgroup.net org:Matrix Group International version:2.1 email;internet:[EMAIL PROTECTED] title:Developer/Hipster adr;quoted-printable:;;801 N. Fairfax Street=0D=0ASte. 205;Alexandria;Virginia;22314; fn:Steve Ray end:vcard --7044766746D9E10C0B119316-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFWebstore Users - ICVerify Success?
I recently purchased CFWebstore and so far its great EXCEPT I can't get the ICVerify credit card processing to work. Very frustrating! I'm specifically having trouble configuring the IC Share Directory in the Payment Mgr. I've entered "I:\icdata" but doesn't work. Can someone please provide an example of the appropriate syntax for this field? I've installed the CFX_MICV tag. I've phoned ICVerify and sent them emails but cannot get in touch with a technical support representative. Please Help Me! -Laura This is the Cold Fusion error message: Just in time compilation error Invalid token found on line 11 at position 6. ColdFusion was looking at the following text: Invalid expression element. The usual cause of this error is a misspelling in the expression text. The last successfully parsed CFML construct was a CFX_MICV tag occupying document position (10:1) to (10:9). The specific sequence of files included or processed is: E:\GOTOREC\REC\CFWEBSTORE\SHOPPING\CHECKOUT\CONTINUE.CFM E:\GOTOREC\REC\CFWEBSTORE\SHOPPING\CHECKOUT\..\FUNCTIONS\ICVERIFY.CFM CFInclude The error occurred while processing an element with a general identifier of (CFINCLUDE), occupying document position (70:1) to (70:48). -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Help needed with a datasource problem
Are you running the Enterprise edition of ColdFusion server? -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Dempsey, Timothy F. [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 8:47 AM To: '[EMAIL PROTECTED]' Subject: Help needed with a datasource problem Folks, I hope someone can advise me on this: Successfully running CF 4.5.1 on NT 4.0 SP5 using Oracle73 (7.3.4) as a datasource Installed Oracle 8.1.5 (8i). Migrated database to 8i. Accessed migrated database via SQL*Plus. Verified that it worked and was indeed running under Oracle 8.1.5 In CF Administrator, configured new datasource specifying Oracle80 as the database and the same user id and password that I used above in the SQL*Plus. CF Verification failed! Why? SQL*Plus worked. Why not CF? Any help will be appreciated Thanks, -- Tim Dempsey -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFDIRECTORY Filtering?
You can't do this in the filter. Two workarounds: 1) Use a cfif within a loop over your query results. 2) rename the file before and after the call to cfdirectory. Jim -Original Message- From: Claremont, Timothy S [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Thursday, September 07, 2000 8:52 AM Subject: CFDIRECTORY Filtering? I want to display the contents of a directory. Using CFDIRECTORY, I can restrict the output to the files that end in .XLS. with the filter property. This works just fine. However, there is one .xls file that I do NOT want to appear in the listing. It always has the same name. Can I put a statement into the filter that says, effectively... filter="*.XLS" and NOT "Main_Table.xls" I get an error message when I try this in the filter statement. Can anyone suggest a workaround? Thanks! Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Problem with URLDecode
That isn't URLEncoded... that's an HTML entity. Some lame-brained browsers will wreak havoc with it while passing through form fields... especially in the URL. IE is a particularly lame-brained browser. Beyond that... good luck ;) -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Problem with URLDecode
Terry, Try escaping the # symbol. It sounds like you have the entity reference stored in a text field in a database (not sure from your description of the problem). If so, write it as ##8482. HTH, --John Terry Stewart stew@stewnetTo: [EMAIL PROTECTED] .comcc: Subject: Problem with URLDecode 09/07/2000 10:48 AM Please respond to cf-talk Hello, Can anyone help me with this problem? I am trying to get a trademark character #8482; to translate back into its correct text. When I display it to screen before the CF Code that uses it in a query all works fine (except that in order to display it at this point put's it in the wrong place), however if I do the query before displaying it it won't work. I have put the URLDecode around it and it still stays encoded. It actually starts out as the characters, but being passed through Form Fields it gets translated to the encoded version (it is being passed around in the variable Criteria_#ThisRow#). Any ideas would very much be appreciated. Terry Stewart -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Web servers
Hmmm... I don't recall "sucking donkey balls" on IIS's feature list, but I'll ask MS tech support about that feature. Although I've never observed IIS anywhere near a Donkey's ass...I'll be dammed if that's a redundancy or what :-p Seriously tho, as far as speed is concerned I've noticed nothing terribly significant between versions of Website and IIS that I've run, but I can compare only low band sites because I've never run a high band site on Website (this being just coincidence and showing no bias towards IIS). The only winning point I'd have for IIS would be the interface, granted I spend more time changing features (so it seems) in website than I am in IIS. Other than that nothing terribly significant between the 2. Gregory Harris Los Angeles Information Technology Agency (ITA) [EMAIL PROTECTED] [EMAIL PROTECTED] 09/07 8:51 AM - Original Message - From: "Ed Toon" [EMAIL PROTECTED] Sent: Thursday, September 07, 2000 1:37 AM Yes... WebSite doesn't suck donkey balls. OK - apart from that? Adrian Cooper. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Is CF a high risk application?
You don't say if this is to be run on a dedicated ("managed"?) server or
on a shared host? If the the hosting provider has such extreme
reservations about hosting and supporting CF applications, then someone
definitely picked the wrong host and you may be in for quite a nightmare
if you run into problems down the road.
Jim
-Original Message-
From: Garry Viner [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, September 07, 2000 2:41 AM
Subject: Is CF a "high risk application"?
This is a multi-part message in MIME format.
--=_NextPart_000_000E_01C01903.4B82E640
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Hi all
We have built a CF global bank trading platform, and currently the site
is
doing nicely. However the powers that be are moving the hosting of the
site
to a new company, who have made the following comments regarding Cold
Fusion. Anybody know if this is true, and what's a good line of
argument for
convincing them that CF is the way to proceed into the future? Here is
their
statement:
ColdFusion is considered a "high risk application", which means that it
can
be installed but the server SLA no longer applies for that server(s).
ColdFusion is a security risk because Allaire has not published the
actual
rights required for ColdFusion to run under NT. For this reason, the
only
choice when running ColdFusion is to allow the ColdFusion application
full
administrative rights. This is a security risk both because any
security
flaw in ColdFusion allows the attacker full administrative privileges,
and
because #Host# must give administrative control to the customer.
Any feedback would be greatly appreciated
Thanks a lot
Garry Viner
---
-
Red 5 Interactive Media Pty Ltd
Level 4, 9-13 Bronte Rd
Bondi Junction NSW 2022
Ph 61 2 9387 6493 Fax 61 2 9387 8355
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Access uploads and Remote CF restart
Why do they need to restart your server to upload the DB? CFUG-SFL Manager -Kev /CFUG-SFL Manager -Original Message- From: William H. Bowen [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 12:43 PM To: [EMAIL PROTECTED] Subject: Access uploads and Remote CF restart This is a cryptographically signed message in MIME format. --ms1C95003524CA825ECA7335D5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit De-lurking to ask if/how the can following be done? Problem: I have a client that must upload a database to my server. This database is Access97 and contains mission critical data. (This database is output from a larger, more cumbersome database that the client keeps at his location) Question: Is there a way to remotely stop and restart CF so that this client does not need to phone in and tell me when they are uploading a new database? will -- William H. Bowen misterbowen.com *Web Design Solutions for Business* [EMAIL PROTECTED] http://www.misterbowen.com/ 425.423.0794 Voice 425.740.0183 FAX ICQ#: 2062149 --ms1C95003524CA825ECA7335D5 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIIH8AYJKoZIhvcNAQcCoIIH4TCCB90CAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC BcEwggKlMIICDqADAgECAgMBZ1kwDQYJKoZIhvcNAQEEBQAwgZQxCzAJBgNVBAYTAlpBMRUw EwYDVQQIEwxXZXN0ZXJuIENhcGUxFDASBgNVBAcTC0R1cmJhbnZpbGxlMQ8wDQYDVQQKEwZU aGF3dGUxHTAbBgNVBAsTFENlcnRpZmljYXRlIFNlcnZpY2VzMSgwJgYDVQQDEx9QZXJzb25h bCBGcmVlbWFpbCBSU0EgMTk5OS45LjE2MB4XDTk5MDkxNzE1Mjg0MloXDTAwMDkxNjE1Mjg0 MlowRjEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEjMCEGCSqGSIb3DQEJARYU d2lsbEBtaXN0ZXJib3dlbi5jb20wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAOlzm9u0 WrSTiSs5uemdEFoljOltJYrtMmJt7e3A1BkYagk+fj/tNaovsW6GvcVnG68ABiBLZKNJ4DGH +uFPxfG9aEdFKats99IdiVQBz4qC1ry7Wbouj+yaW6tO/VpS8QKv2dk3o0EbFn3Yk8PzXWOd s6+rFWA9bxuFvV95ZkwPAgMBAAGjUjBQMB8GA1UdEQQYMBaBFHdpbGxAbWlzdGVyYm93ZW4u Y29tMAwGA1UdEwEB/wQCMAAwHwYDVR0jBBgwFoAUiKvxYINmVfTkWMdGHcBhvSPXw4wwDQYJ KoZIhvcNAQEEBQADgYEAM1GGG2bT8fMPoLz+ZHqqtqTr85taghWnOTF3PjUqaYeanZzBuI29 fyIYgPZKQoRm3zgdANNU9GaveX9HLc6rStY5pOplLuJuUyoWMlJ/UIXzftTw/89yPmNXAzMN ShRzJ68RRGnXoRWYreb/t+HiavJ7Yninpvdfcoq6hwN4Av0wggMUMIICfaADAgECAgELMA0G CSqGSIb3DQEBBAUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIw EAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQL Ex9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVy c29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRo YXd0ZS5jb20wHhcNOTkwOTE2MTQwMTQwWhcNMDEwOTE1MTQwMTQwWjCBlDELMAkGA1UEBhMC WkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxDzANBgNV BAoTBlRoYXd0ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1Bl cnNvbmFsIEZyZWVtYWlsIFJTQSAxOTk5LjkuMTYwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJ AoGBALNpWpfU0BYLerXFXekhnCNyzRJMS/d+z8f7ynIk9EJSrFeV43theheE5/1yOTiUtOrt ZaeSBl694GX2GbuUeXZMPrlocHWEHPQRdAC8BSxPCQMXMcz0QdRyxqZd4ohEsIsuxE3x8NaF PmzzlZR4kX5A6ZzRjRVXjsJz5TDeRvVPAgMBAAGjNzA1MBIGA1UdEwEB/wQIMAYBAf8CAQAw HwYDVR0jBBgwFoAUcknCczTGVfQLdnKBfnf0h+fGsg4wDQYJKoZIhvcNAQEEBQADgYEAa8ZZ 6TH66bbssQPY33Jy/pFgSOrGVd178GeOxmFw523CpTfYnbcXKFYFi91cdW/GkZDGbGZxE9AQ fGuRb4bgITYtwdfqsgmtzy1txoNSm/u7/pyHnfy36XSS5FyXrvx+rMoNb3J6Zyxrc/WG+Z31 AG70HQfOnZ6CYynvkwl+Vd4xggH3MIIB8wIBATCBnDCBlDELMAkGA1UEBhMCWkExFTATBgNV BAgTDFdlc3Rlcm4gQ2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxDzANBgNVBAoTBlRoYXd0 ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1BlcnNvbmFsIEZy ZWVtYWlsIFJTQSAxOTk5LjkuMTYCAwFnWTAJBgUrDgMCGgUAoIGxMBgGCSqGSIb3DQEJAzEL BgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTAwMDkwNzE2NDMwMVowIwYJKoZIhvcNAQkE MRYEFNB2aGIO00MiaNZoccGZxu2lEXmbMFIGCSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcNAwcw DgYIKoZIhvcNAwICAgCAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgFAMA0GCCqGSIb3DQMCAgEo MA0GCSqGSIb3DQEBAQUABIGAA5lqE75wIjfmvtHh8Kfsj0yZRyABkLbWM9DQ4ELY7F90xTQA jTMM70RQPJ+IO0s0SBrTL9qZY1Ny65cWWZvNEj4PVTlHsSMyrThrqtYSRtELXHIkRSyRN1J/ +UNiRXK8QAHMv4aH/M/cqXco4x6qsnmksPBWACvxYXr18ispvMs= --ms1C95003524CA825ECA7335D5-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT - Best configuration for a hardware
Hi, Sorry for the OT!! I want to know what's the best system configuration for a website. If I have SQL server, IIS and Cold Fusion. Is it better to have them on the same machine(like a 2 cpu's server) or SQL on a server and IIS/CF on another one? Any thoughts or experince about that? Thanks Christian labrecque Web Developer -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
No Subject
I have a question about Cookies and SSL on Netscape. I have almost finished my shopping cart, but when my users were testing, there was a problem. It seems that Netscape won't allow pages on the SSL part of the server to use the Cookies generated by the non-SSL section of the server. Everything works OK in IE. Directory structure webroot racbp(beginning of shopping cart) 1.cfm 2.cfm 3.cfm ... application.cfm(writes two cookies Customer_ID and Order_ID) secure racbp(secure section of shoppingcart) 4.cfm 5.cfm 6.cfm 1. I thouhgt that I could just move the application.cfm to the webroot directory, but then what do i do when I need to write another application that would have the same problem 2. I could put the entire shopping cart app in the SSL folder 3. I could pass the Cookies as variables from page 3.cfm to page 4.cfm anf have page 4 write cookies from the SSl server. Then I will have to identical sets of cookie and I will have to delete them twice. 4. Every CF developer must have the same problem and there must be an industry standard fix... but I don't know what it is which is why I am contacting you. Any help would be much appreciated, Bonnie -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Quotes (aka End of the working day in england and I'm tired)
Have you tried the PreserveSingleQuotes() function around the packet in the insert/update SQL statement? Justin Kidman -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 9:55 AM To: Cf-Talk Subject: SQL Quotes (aka End of the working day in england and I'm tired) I am trying to put a wddx string into the database. It won't go. Any ideas how to get the single quotes into the database without messing up the wddx? Paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: simple date problem major brain fart
Date addition and subtraction is really much easier than this. CF does a
lot of implicit data type conversion for you.
Instead of
cfset datetocheck = "#DateFormat("09/02/2000", "mm/dd/")#"
cfset currentdate = "#DateFormat(Now(), "mm/dd/")#"
cfset lastweekdate = "#DateFormat(currentdate-7, "mm/dd/")#"
cfset difference = DateDiff("d", lastweekdate, datetocheck)
Try
cfset datetocheck = "9/2/2000"
cfset lastweekdate = now() - 7
cfset difference = lastweekdate - datetocheck
Accomplishes the same thing unless I got the subtraction reversed . . .
don't use datediff often enough to remember which way it goes. One caveat,
you may need the datediff if the time component decides to interfere with
what you are doing.
Dan
-Original Message-
From: Mark Warrick [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 07, 2000 9:48 AM
To: [EMAIL PROTECTED]
Subject: RE: simple date problem major brain fart
This code should do the job:
cfset datetocheck = "#DateFormat("09/02/2000", "mm/dd/")#"
cfset currentdate = "#DateFormat(Now(), "mm/dd/")#"
cfset lastweekdate = "#DateFormat(currentdate-7, "mm/dd/")#"
cfset difference = DateDiff("d", lastweekdate, datetocheck)
cfoutput
Date to Check: #datetocheck#br
Current Date: #currentdate#br
Last Week's Date: #lastweekdate#br
Difference between last week's date and date to check: #difference#
/cfoutput
--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--
-Original Message-
From: Art Broussard [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 07, 2000 8:21 AM
To: [EMAIL PROTECTED]
Subject: simple date problem major brain fart
Lets say CurrentDate is 9/7/2000 and you need to do a check to see if
DateToCheck is equal to or greater than CurrentDate - 7 days. if you
subtract 7 from the days you get 9/0/2000 which is an invalid
date. Is there
an easy way to do this?
Please help, my brain is full of gas
Art
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Access uploads and Remote CF restart
You could easily do this, but you probably need to write it in something other than CF. Assuming you are running NT the following batch script will restart CF... net stop "Cold Fusion Application Server" net stop "Cold Fusion Executive" net stop "Cold Fusion RDS" net start "Cold Fusion Application Server" net start "Cold Fusion Executive" net start "Cold Fusion RDS" I am not sure what would happen if you ran that in CFEXECUTE, so you would probably want to run it in another language. Ofcourse there are permission issues that you may also need to tackle. __ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM / NETDesign Inc. ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: William H. Bowen [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 12:43 PM To: [EMAIL PROTECTED] Subject: Access uploads and Remote CF restart This is a cryptographically signed message in MIME format. --ms1C95003524CA825ECA7335D5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit De-lurking to ask if/how the can following be done? Problem: I have a client that must upload a database to my server. This database is Access97 and contains mission critical data. (This database is output from a larger, more cumbersome database that the client keeps at his location) Question: Is there a way to remotely stop and restart CF so that this client does not need to phone in and tell me when they are uploading a new database? will -- William H. Bowen misterbowen.com *Web Design Solutions for Business* [EMAIL PROTECTED] http://www.misterbowen.com/ 425.423.0794 Voice 425.740.0183 FAX ICQ#: 2062149 --ms1C95003524CA825ECA7335D5 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIIH8AYJKoZIhvcNAQcCoIIH4TCCB90CAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC BcEwggKlMIICDqADAgECAgMBZ1kwDQYJKoZIhvcNAQEEBQAwgZQxCzAJBgNVBAYTAlpBMRUw EwYDVQQIEwxXZXN0ZXJuIENhcGUxFDASBgNVBAcTC0R1cmJhbnZpbGxlMQ8wDQYDVQQKEwZU aGF3dGUxHTAbBgNVBAsTFENlcnRpZmljYXRlIFNlcnZpY2VzMSgwJgYDVQQDEx9QZXJzb25h bCBGcmVlbWFpbCBSU0EgMTk5OS45LjE2MB4XDTk5MDkxNzE1Mjg0MloXDTAwMDkxNjE1Mjg0 MlowRjEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEjMCEGCSqGSIb3DQEJARYU d2lsbEBtaXN0ZXJib3dlbi5jb20wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAOlzm9u0 WrSTiSs5uemdEFoljOltJYrtMmJt7e3A1BkYagk+fj/tNaovsW6GvcVnG68ABiBLZKNJ4DGH +uFPxfG9aEdFKats99IdiVQBz4qC1ry7Wbouj+yaW6tO/VpS8QKv2dk3o0EbFn3Yk8PzXWOd s6+rFWA9bxuFvV95ZkwPAgMBAAGjUjBQMB8GA1UdEQQYMBaBFHdpbGxAbWlzdGVyYm93ZW4u Y29tMAwGA1UdEwEB/wQCMAAwHwYDVR0jBBgwFoAUiKvxYINmVfTkWMdGHcBhvSPXw4wwDQYJ KoZIhvcNAQEEBQADgYEAM1GGG2bT8fMPoLz+ZHqqtqTr85taghWnOTF3PjUqaYeanZzBuI29 fyIYgPZKQoRm3zgdANNU9GaveX9HLc6rStY5pOplLuJuUyoWMlJ/UIXzftTw/89yPmNXAzMN ShRzJ68RRGnXoRWYreb/t+HiavJ7Yninpvdfcoq6hwN4Av0wggMUMIICfaADAgECAgELMA0G CSqGSIb3DQEBBAUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIw EAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQL Ex9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVy c29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRo YXd0ZS5jb20wHhcNOTkwOTE2MTQwMTQwWhcNMDEwOTE1MTQwMTQwWjCBlDELMAkGA1UEBhMC WkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxDzANBgNV BAoTBlRoYXd0ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1Bl cnNvbmFsIEZyZWVtYWlsIFJTQSAxOTk5LjkuMTYwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJ AoGBALNpWpfU0BYLerXFXekhnCNyzRJMS/d+z8f7ynIk9EJSrFeV43theheE5/1yOTiUtOrt ZaeSBl694GX2GbuUeXZMPrlocHWEHPQRdAC8BSxPCQMXMcz0QdRyxqZd4ohEsIsuxE3x8NaF PmzzlZR4kX5A6ZzRjRVXjsJz5TDeRvVPAgMBAAGjNzA1MBIGA1UdEwEB/wQIMAYBAf8CAQAw HwYDVR0jBBgwFoAUcknCczTGVfQLdnKBfnf0h+fGsg4wDQYJKoZIhvcNAQEEBQADgYEAa8ZZ 6TH66bbssQPY33Jy/pFgSOrGVd178GeOxmFw523CpTfYnbcXKFYFi91cdW/GkZDGbGZxE9AQ fGuRb4bgITYtwdfqsgmtzy1txoNSm/u7/pyHnfy36XSS5FyXrvx+rMoNb3J6Zyxrc/WG+Z31 AG70HQfOnZ6CYynvkwl+Vd4xggH3MIIB8wIBATCBnDCBlDELMAkGA1UEBhMCWkExFTATBgNV BAgTDFdlc3Rlcm4gQ2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxDzANBgNVBAoTBlRoYXd0 ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1BlcnNvbmFsIEZy ZWVtYWlsIFJTQSAxOTk5LjkuMTYCAwFnWTAJBgUrDgMCGgUAoIGxMBgGCSqGSIb3DQEJAzEL BgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTAwMDkwNzE2NDMwMVowIwYJKoZIhvcNAQkE MRYEFNB2aGIO00MiaNZoccGZxu2lEXmbMFIGCSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcNAwcw DgYIKoZIhvcNAwICAgCAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgFAMA0GCCqGSIb3DQMCAgEo MA0GCSqGSIb3DQEBAQUABIGAA5lqE75wIjfmvtHh8Kfsj0yZRyABkLbWM9DQ4ELY7F90xTQA jTMM70RQPJ+IO0s0SBrTL9qZY1Ny65cWWZvNEj4PVTlHsSMyrThrqtYSRtELXHIkRSyRN1J/ +UNiRXK8QAHMv4aH/M/cqXco4x6qsnmksPBWACvxYXr18ispvMs= --ms1C95003524CA825ECA7335D5-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
RE: Web-based email
Hi Owen, Yes, give up using the sample webmail with CF. Go with Howies iMS solution www.coolfusion.com or purchase a specially built webmail package like SoftEdge from www.software.com or WebMail from www.infinite.com. There are other free solutions out there but you get what you pay for. Good Luck, - Steve Steve Pierce, HDL "Co-Location starting $99 per month, no setup fee" (734) 482-9682 | mailto:[EMAIL PROTECTED] | http://HDL.com -Original Message- From: Owen Leonard [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 12:54 PM To: CF-Talk Subject: Web-based email Hi everybody, I'm trying to build a functional, usable e-mail system based on the framework of the example application included with ColdFusion. Every time I run into a snag, I wonder why I'm reinventing the wheel when others must be trying to do the same thing. There don't seem to be a lot of resources available on the subject. Are there other people out there trying to do this? -- Owen - Athens County Library Services http://www.athenscounty.lib.oh.us -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: PROBLEM with ALLAIRE CUSTOMER SERVICE ?
If you are trying to get free support then I agree, your expectation level is too high. Microsoft doesn't offer free support, neither does Oracle, IBM, Sun or most other database integration companies. Allaire shouldn't be expected to behave any differently. If you can't solve the problem with Allaire Forums or CF_Talk, then pay for the support call and move on. How much lost time and money did you lose waiting nine days? $100 to $200 for a support call is a very good value. Pay it, and move on soldier. g - Steve Steve Pierce, HDL "Co-Location starting $99 per month, no setup fee" (734) 482-9682 | mailto:[EMAIL PROTECTED] | http://HDL.com -Original Message- From: Marcus [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 1:03 PM To: [EMAIL PROTECTED] Subject: RE: PROBLEM with ALLAIRE CUSTOMER SERVICE ? Does anyone have tried to contact Allaire Customer support ? I tryed many times, for the past 9 days and I never received any answer form Allaire Company! Am I the only one facing this problem? I have been... When I finally was contacted by someone at Allaire, it wasn't a tech support person trying to fix the problem. It was instead a salesman trying to sell me a $28,000 support package from Allaire. And when I commented that I didn't appreciate someone trying to sell me support when I was still trying to resolve an issue, I was told that Allaire needed to make money. Marcus -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: lower SQL function
That's it in Access and it's LOWER inn the other 2. Nick - Original Message - From: Howie Hamlin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 07, 2000 4:30 PM Subject: Re: "lower" SQL function Try LCase Regards, Howie - Original Message - From: "Stas Newdel" [EMAIL PROTECTED] To: "CFTalk" [EMAIL PROTECTED] Sent: Thursday, September 07, 2000 10:49 AM Subject: OT: "lower" SQL function Hello, Apologies for an OT question, but what are the equivalents of the Lower function in Access, MS SQL, Sybase? I know it's LOWER in Oracle, but I can't get that to work in Access. Thank you -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: simple date problem major brain fart
Actually, you just need a little Dateadd()
cfset CurrentDate=now()
cfset lastweek=dateadd('D',-7,now())
cfif DatetoCheck GTE lastweek /cfif
Stuart Duncan
MaracasMedia Inc.
At 10:20 AM 9/7/00 -0500, you wrote:
Lets say CurrentDate is 9/7/2000 and you need to do a check to see if
DateToCheck is equal to or greater than CurrentDate - 7 days. if you
subtract 7 from the days you get 9/0/2000 which is an invalid date. Is there
an easy way to do this?
Please help, my brain is full of gas
Art
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Good Web Report tool for CF
Hi, Does anyone knows any good web report tool for CF? Thank you very much! YC -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL server SQL*net fighting for the same port?
Dave, Thanks a lot for your help. I ran the query analyzer and it worked ok. Any other files should I look at besides MDAC? How do I know if some MDAC files have been overwritten by their old version? Thanks. Richard. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 7:08 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: SQL server SQL*net fighting for the same port? This is a bit off topic but hopefully somebody can help. We use MS SQL server 7.0 and I have the SQL server enterprise manager installed on my machine. Everything was fine till I installed Oracle SQL Plus 8.0 and some Oracle tools on my machine. Since then I was not able to do something like right click at a table name and open that table. If I do that, I will get the following error message: The query cannot be executed because some files are missing or mot registered. Run setup again to make sure the required files are registered. It looks to me, based on the error message, that some files got overridden by the SQL plus installation. But some one told me that it might be that the SQL server enterprise manager and SQL*net were fighting for the same port. If you have seen this, can you give me some hint on how to fix it? I haven't had that problem specifically, and I've got SQL Server 6.5, 7.0, and Oracle 8i plus client tools installed on my machine. I haven't seen any port conflicts - in any case, the database server itself specifies the port, not the client tools. Your problem sounds more like an MDAC problem. Reinstall the latest MDAC (2.5) on your machine, and I'd bet that will fix the problem. I suspect that Oracle overwrote some MDAC files with older versions, which will definitely break the query analyzer part of SQL Server 7 Enterprise Manager. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Application in ASP
Hi, Here I am again, defiling the list with another ASP question. Sorry, but it is somewhat CF related Does anyone know if ASP has an application.cfm equivalent? Thanks, Geoff B -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFWebstore Users - ICVerify Success?
I recently purchased CFWebstore and so far its great EXCEPT I can't get the ICVerify credit card processing to work. Very frustrating! I'm specifically having trouble configuring the IC Share Directory in the Payment Mgr. I've entered "I:\icdata" but doesn't work. Can someone please provide an example of the appropriate syntax for this field? I've installed the CFX_MICV tag. I've phoned ICVerify and sent them emails but cannot get in touch with a technical support representative. Surprise surprise... ICVerify (ICV) is a dying software product. CyberCash bought it a year ago, and is letting it die because it will be too hard to upgrade with the new internet requirements Visa and MC are forcing on everyone. CyberCash has stated it will support ICV only through next March... after that, you're on your own. They're giving current ICV owners an upgrade to WebAuthorize (used to be owned by Tellan) if you ask. And if you think getting ahold of an ICV tech is tough, try finding the author of the CFX_MICV tag!! If you still want to use it, make sure CF has read/write privileges to I:\icdata. Set up a little test template using the CFFILE tag, and try to read and write to that directory. Your syntax looks fine... but you might want to try it with and without a trailing backslash. In case you're wondering, we're moving to Authorize.net from MerchantExpress.com... so far so good. Ron Allen Hornbaker President/CTO Humankind Systems, Inc. http://humankindsystems.com mailto:[EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF/Solaris on Intel
--=_89D10A9F.325332CA Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Your question isn't very clear - is your client running a Solaris = webserver or do they have users with actual Sparcs on their desktops? And = is your client going to be developing CF apps themselves, or are you = developing/maintaining everything? When you say "CF" are you talking = about Studio or Server? =20 In any case, I don't quite see the problem. If you're responsible for = developing an app, isn't that pretty much independent of what kind of = webserver is used? If your client is just looking for install help to do = their own developing, and have Sparc workstations instead of PCs - you = don't need Studio to develop CF apps. If they're merely using their = Sparcs to launch a web browser - presumably Netscape - you develop your = app on your own setup and then go over there to test it. There WILL be = some appearance differences, but I haven't yet found anything that doesn't = work like it should (I happen to have a Sparc and prefer it for surfing.) Carol [EMAIL PROTECTED] 09/07/00 01:20PM Hi. We have a client who uses Solaris on SPARC boxes, and we need to develop a CF app for them. From what I can tell, Solaris for CF only works on SPARC. Problem is, we don't have a SPARC. Can CF for Solaris be put on an Intel box running Solaris? If not, what do you suggest? Running the Linux version? Are there any differences btwn the CF/Linux and CF/Solaris versions which would present problems when we migrate the application onto the client's SPARC? Thanks for any clues. Steve Ray --7044766746D9E10C0B119316 Content-Type: text/x-vcard; charset=3Dus-ascii; name=3D"sray.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Steve Ray Content-Disposition: attachment; filename=3D"sray.vcf" begin:vcard=20 n:; tel;fax:703.838.9799 tel;work:703.838.9777 x-mozilla-html:TRUE url:www.matrixgroup.net org:Matrix Group International version:2.1 email;internet:[EMAIL PROTECTED] title:Developer/Hipster adr;quoted-printable:;;801 N. Fairfax Street=3D0D=3D0ASte. 205;Alexandria;V= irginia;22314; fn:Steve Ray end:vcard --7044766746D9E10C0B119316-- ---= --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= body=3Dlists/cf_talk or send a message to [EMAIL PROTECTED]= m with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF/Solaris on Intel
Hi. We have a client who uses Solaris on SPARC boxes, and we need to develop a CF app for them. From what I can tell, Solaris for CF only works on SPARC. Problem is, we don't have a SPARC. Can CF for Solaris be put on an Intel box running Solaris? No, CF only runs on Sparc Solaris. If not, what do you suggest? Running the Linux version? Are there any differences btwn the CF/Linux and CF/Solaris versions which would present problems when we migrate the application onto the client's SPARC? There aren't really any serious code-specific issues of which I'm aware, but it's still a platform change, and you're likely to run into some Solaris-specific problems. This is especially true as you start doing more advanced things, like using Advanced Security (not provided on Linux). Your best bet is to bite the bullet, and go get a Sparc box. Fortunately, you don't have to get a good Sparc box. You can get one of the Ultra 5 workstations, which run about $4,000 or so. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: MULTIPLE COLUMN output problem!
Dear Courtney, Thank you very much for your help... works fine. One thing however is that e.g. if I have 12 categories, instead of having 6 on each side, it splits after ouputting 5 on one side and then outputs 7 on the other. I tried a variation to the ceiling(numcategories/2) by adding a 1. i.e. ceiling((numcategories + 1)/2). That made it perfectly align with 6 on each side. What would you suggest to output the category names that have no underlying sub categories (currently they are not ouput as they are filtered out at the WHERE clause due to not having any matching sub_category.category_id = categories.category_id). Thank you very much once again. Regards Hassan Khawaja - Original Message - From: "Courtney Payne" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 06, 2000 12:49 PM Subject: RE: MULTIPLE COLUMN output problem! Ok, try this. Didn't have the tables set up to test this against but it should point you in the right direction. !--- Get number of top-level categories for TD delimitting later --- cfquery name="GetNumCategories" ... SELECT DISTINCT(CategoryName) FROM [your table] /cfquery cfset numcategories = GetNumCategories.recordcount !--- Your query here --- cfquery name="GetAllCategories" ... . . . /cfquery !--- Since you can't use currentrow (because you're grouping), maintain your own category (top-level) counter --- cfset count = 0 !--- You're only gonna have 2 TDs in your table - one on the left, one on the right. --- table tr td valign="top" cfoutput query="GetAllCategories" group="CategoryName" cfset count = count + 1 !--- TD delimit check --- cfif count EQ ceiling(numcategories / 2) /tdtd valign="top" /cfif #CategoryName#br cfoutput #SubCategoryName# | /cfoutput brbr /cfoutput /td /tr /table Again, haven't tested this or anything... hope it helps. Courtney E. Payne, Developer Figleaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Hassan Khawaja [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 12:45 PM To: [EMAIL PROTECTED] Subject: MULTIPLE COLUMN output problem! Hi all, I am experiencing a certain problem, and will try to explain it as well as I can. I have a list of links that I am trying to output in a 2 column format, very similar to Yahoo! main menu design. As you know there are main Categories listed with sub categories right underneath them. kind of like: NewsComputers - World, US..-Software, WWW... BusinessReference - B2B, Companies..- Encyclopedias, Lists.. Now, I have in my database 2 tables - categories, and sub-categories, which are linked together thru a category id. The idea is to ouput the categories with their subcategories with them in a 2 column format. I can output 2 columns correctly if I only ouput the categories. or if I just output the subcategory. However it gets all very hairy if join the tables and output using the GROUP parameter of CFOUTPUT. The problem arises when there are a dissimilar number of subcategories for each category. In my code it looks for cfif currentrow MOD columncount eq 0 to determine if the current row's MOD 2 is 0 to know if 2 columns have already been output, but when there are different no. of subcategories, this logic statement gets evaluated at the wrong point than the one I want it to. Right now it is printing 3 columns for one row and only one column for another, while the rest of the rows are alright with 2 columns. What I mean is that if a certain category has 1 sub-cat. and the other has 2 sub-cats, the output counts them as 3 rows total and instead of starting a new row after the category and its sub-cats have been output, it tries to start a new one as soon as 2 columns have been evaluated. So even though the 3rd row is still part of the main category, for the logic statement, it's a NEW row. Sample output: [ numbers are rowcount ] -- -- 1-Administration2-Daily Reports 1- Areas | 2- Divisions | 3-Data Entry 4-Help 3- Products | 4- About | 5-MDS6-MSDS 5- Areas | 6- Facilities | 7-Process Control9-Production10-Reports ***problem 7- Business | 8- Divisional | 9- Reports | 10-Data | *** 3 columns 11-SSOP 12-Safety 11- Tasks | 12- Data | 13-Sales* problem 13- Facilities | just 1 column***
Re: MULTIPLE COLUMN output problem!
Ok, I did an outer join and it fixed my problem of not being ale to display
categories not having any sub categories.
Thanks.
SELECT mnu_categories.category_id,
mnu_categories.category_name,
mnu_categories.category_url,
mnu_sub_categories.sub_cat_id,
mnu_sub_categories.sub_cat_name
FROM mnu_categories, mnu_sub_categories
WHERE mnu_categories.category_id = mnu_sub_categories.category_id (+)
{outer join syntax for Oracle}
ORDER BY
mnu_categories.category_name,
mnu_sub_categories.sub_cat_nam
- Original Message -
From: "Courtney Payne" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 06, 2000 12:49 PM
Subject: RE: MULTIPLE COLUMN output problem!
Ok, try this. Didn't have the tables set up to test this against but it
should point you in the right direction.
!--- Get number of top-level categories for TD delimitting later ---
cfquery name="GetNumCategories" ...
SELECT DISTINCT(CategoryName)
FROM [your table]
/cfquery
cfset numcategories = GetNumCategories.recordcount
!--- Your query here ---
cfquery name="GetAllCategories" ...
.
.
.
/cfquery
!--- Since you can't use currentrow (because you're grouping), maintain
your own category (top-level) counter ---
cfset count = 0
!--- You're only gonna have 2 TDs in your table - one on the left, one on
the right. ---
table
tr
td valign="top"
cfoutput query="GetAllCategories"
group="CategoryName"
cfset count = count + 1
!--- TD delimit check ---
cfif count EQ ceiling(numcategories / 2)
/tdtd valign="top"
/cfif
#CategoryName#br
cfoutput
#SubCategoryName# |
/cfoutput
brbr
/cfoutput
/td
/tr
/table
Again, haven't tested this or anything... hope it helps.
Courtney E. Payne, Developer
Figleaf Software
"We've got you covered"
[EMAIL PROTECTED]
www.figleaf.com
-Original Message-
From: Hassan Khawaja [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 12:45 PM
To: [EMAIL PROTECTED]
Subject: MULTIPLE COLUMN output problem!
Hi all,
I am experiencing a certain problem, and will try to explain it as well as
I
can.
I have a list of links that I am trying to output in a 2 column format,
very
similar to Yahoo! main menu design. As you know there are main Categories
listed with sub categories right underneath them. kind of like:
NewsComputers
- World, US..-Software, WWW...
BusinessReference
- B2B, Companies..- Encyclopedias, Lists..
Now, I have in my database 2 tables - categories, and sub-categories,
which
are linked together thru a category id. The idea is to ouput the
categories
with their subcategories with them in a 2 column format.
I can output 2 columns correctly if I only ouput the categories. or if I
just output the subcategory. However it gets all very hairy if join the
tables and output using the GROUP parameter of CFOUTPUT.
The problem arises when there are a dissimilar number of subcategories for
each category. In my code it looks for cfif currentrow MOD columncount eq
0 to determine if the current row's MOD 2 is 0 to know if 2 columns have
already been output, but when there are different no. of subcategories,
this
logic statement gets evaluated at the wrong point than the one I want it
to.
Right now it is printing 3 columns for one row and only one column for
another, while the rest of the rows are alright with 2 columns.
What I mean is that if a certain category has 1 sub-cat. and the other has
2
sub-cats, the output counts them as 3 rows total and instead of starting a
new row after the category and its sub-cats have been output, it tries to
start a new one as soon as 2 columns have been evaluated. So even though
the 3rd row is still part of the main category, for the logic statement,
it's a NEW row.
Sample output: [ numbers are rowcount ]
--
--
1-Administration2-Daily Reports
1- Areas | 2- Divisions |
3-Data Entry 4-Help
3- Products | 4- About |
5-MDS6-MSDS
5- Areas | 6- Facilities |
7-Process Control9-Production10-Reports
***problem
7- Business | 8- Divisional | 9- Reports | 10-Data |
*** 3 columns
11-SSOP 12-Safety
11- Tasks | 12- Data |
13-Sales* problem
13- Facilities | just 1 column***
--
--
To stop confusing you further, I am including the code snippet to
accomplish
this:
!--- the query to gather
OT: Java Script Question
I would like to flash a java script alert box saying that a login name is already in use. This will happen on the submit and it will go to the action page to check the db. My question is can I have the alert box pop up on the form page so the person does not have to go back and re-enter all of their information. How do I do this? TIA DDINC -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
how to tell if radio button is checked
I have a set of radio buttons in a CFFORM where the user can choose Yes or
No. I need to make sure they fill in another field if they have chosen the
"yes" radio button. I'm not sure if I'm going about checking to see if it
is checked "yes" the right way. I have "If (form.radiobutton.value == "Y")
Is there some other way like form.radiobutton.value.checked or something
like that? Here is my javascript below...the radiobutton in question is
named "degreed_fl".
Thanks, KIm
function auditBSBA(form) {
var submitForm=true //-- Changes to false when bad field found.
if (form.degreed_fl.value == "Y") {
if (form.schl_grad.value == "") {
window.alert("Please provide the name, city and state of the school
where you received your BS or BA degree");
submitForm=false;
form.schl_grad.focus();
}
}
if (submitForm==true) {
//-- The statement below submits the form, if all OK.
document.BSBAQuestions.submit()
}
}
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Access uploads and Remote CF restart
Problem: I have a client that must upload a database to my server. This database is Access97 and contains mission critical data. (This database is output from a larger, more cumbersome database that the client keeps at his location) Question: Is there a way to remotely stop and restart CF so that this client does not need to phone in and tell me when they are uploading a new database? Answer: Sure there is. You could write a batch file to stop and restart the CF server, then call that batch file from CF using CFEXECUTE. Alternatively, you could write an ASP script (assuming you're running IIS) that will do the same thing. Finally, there used to be a web-based interface for this; it was removed from the latest version of CF for security reasons, but you could conceivably get that and put it on your server. Better answer: Instead of cycling the CF service, you might examine other alternatives. For example, you might disable database connections to the specific database, or break the existing database connection (there's a minimally-documented function, I believe it's CFUSION_DBCONNECTION_FLUSH() or something like that, which is described on the Allaire knowledge base). Possibly, an even better answer: For some reason, I found this line amusing: "This database is Access97 and contains mission critical data." While I understand why a lot of people use Access, that doesn't mean I condone it. If you're running SQL Server, for example, you could build all kinds of batch processes to transfer data through the internet from one database to another. It may be the case that you're better off using Access in this case, but maybe not. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: How to dock a pop-up ad?
Hi, Someone once told me of a method to 'dock' pop-ups in free hosting sites, so that the ad would appear at the bottom of my page and not in a separate pop-up window. Can anyone remind me of how to do it? Sincerely, --- Hubert Earl ICQ#: 16199853 See pictures of items in my Jamaican Art, Craft More Online Sale (please excuse the pop-ups--this is currently being hosted on just a temporary, emergency server: http://www.angelfire.com/ny/hearl/eBay_links_page_on_Angelfire.htm -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Access uploads and Remote CF restart
I was having a problem with .ldb files being created when CF was accessing the databases. It essentially took restarting the CF Server to disconnect. I discovered today that Maintain Database Connections was checked in the Edit ODBC Admin page (the only one of 7 client databases where this has occured... and, of course, the only one that is maintained remotely...) yeesh...Unchecking Maintain Database Connections seems to have solved the problem. Kevin Langevin wrote: Why do they need to restart your server to upload the DB? CFUG-SFL Manager -Kev /CFUG-SFL Manager -Original Message- From: William H. Bowen [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 12:43 PM To: [EMAIL PROTECTED] Subject: Access uploads and Remote CF restart This is a cryptographically signed message in MIME format. --ms1C95003524CA825ECA7335D5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit De-lurking to ask if/how the can following be done? Problem: I have a client that must upload a database to my server. This database is Access97 and contains mission critical data. (This database is output from a larger, more cumbersome database that the client keeps at his location) Question: Is there a way to remotely stop and restart CF so that this client does not need to phone in and tell me when they are uploading a new database? will -- William H. Bowen misterbowen.com *Web Design Solutions for Business* [EMAIL PROTECTED] http://www.misterbowen.com/ 425.423.0794 Voice 425.740.0183 FAX ICQ#: 2062149 --ms1C95003524CA825ECA7335D5 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIIH8AYJKoZIhvcNAQcCoIIH4TCCB90CAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC BcEwggKlMIICDqADAgECAgMBZ1kwDQYJKoZIhvcNAQEEBQAwgZQxCzAJBgNVBAYTAlpBMRUw EwYDVQQIEwxXZXN0ZXJuIENhcGUxFDASBgNVBAcTC0R1cmJhbnZpbGxlMQ8wDQYDVQQKEwZU aGF3dGUxHTAbBgNVBAsTFENlcnRpZmljYXRlIFNlcnZpY2VzMSgwJgYDVQQDEx9QZXJzb25h bCBGcmVlbWFpbCBSU0EgMTk5OS45LjE2MB4XDTk5MDkxNzE1Mjg0MloXDTAwMDkxNjE1Mjg0 MlowRjEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEjMCEGCSqGSIb3DQEJARYU d2lsbEBtaXN0ZXJib3dlbi5jb20wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAOlzm9u0 WrSTiSs5uemdEFoljOltJYrtMmJt7e3A1BkYagk+fj/tNaovsW6GvcVnG68ABiBLZKNJ4DGH +uFPxfG9aEdFKats99IdiVQBz4qC1ry7Wbouj+yaW6tO/VpS8QKv2dk3o0EbFn3Yk8PzXWOd s6+rFWA9bxuFvV95ZkwPAgMBAAGjUjBQMB8GA1UdEQQYMBaBFHdpbGxAbWlzdGVyYm93ZW4u Y29tMAwGA1UdEwEB/wQCMAAwHwYDVR0jBBgwFoAUiKvxYINmVfTkWMdGHcBhvSPXw4wwDQYJ KoZIhvcNAQEEBQADgYEAM1GGG2bT8fMPoLz+ZHqqtqTr85taghWnOTF3PjUqaYeanZzBuI29 fyIYgPZKQoRm3zgdANNU9GaveX9HLc6rStY5pOplLuJuUyoWMlJ/UIXzftTw/89yPmNXAzMN ShRzJ68RRGnXoRWYreb/t+HiavJ7Yninpvdfcoq6hwN4Av0wggMUMIICfaADAgECAgELMA0G CSqGSIb3DQEBBAUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIw EAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQL Ex9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVy c29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRo YXd0ZS5jb20wHhcNOTkwOTE2MTQwMTQwWhcNMDEwOTE1MTQwMTQwWjCBlDELMAkGA1UEBhMC WkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxDzANBgNV BAoTBlRoYXd0ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1Bl cnNvbmFsIEZyZWVtYWlsIFJTQSAxOTk5LjkuMTYwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJ AoGBALNpWpfU0BYLerXFXekhnCNyzRJMS/d+z8f7ynIk9EJSrFeV43theheE5/1yOTiUtOrt ZaeSBl694GX2GbuUeXZMPrlocHWEHPQRdAC8BSxPCQMXMcz0QdRyxqZd4ohEsIsuxE3x8NaF PmzzlZR4kX5A6ZzRjRVXjsJz5TDeRvVPAgMBAAGjNzA1MBIGA1UdEwEB/wQIMAYBAf8CAQAw HwYDVR0jBBgwFoAUcknCczTGVfQLdnKBfnf0h+fGsg4wDQYJKoZIhvcNAQEEBQADgYEAa8ZZ 6TH66bbssQPY33Jy/pFgSOrGVd178GeOxmFw523CpTfYnbcXKFYFi91cdW/GkZDGbGZxE9AQ fGuRb4bgITYtwdfqsgmtzy1txoNSm/u7/pyHnfy36XSS5FyXrvx+rMoNb3J6Zyxrc/WG+Z31 AG70HQfOnZ6CYynvkwl+Vd4xggH3MIIB8wIBATCBnDCBlDELMAkGA1UEBhMCWkExFTATBgNV BAgTDFdlc3Rlcm4gQ2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxDzANBgNVBAoTBlRoYXd0 ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1BlcnNvbmFsIEZy ZWVtYWlsIFJTQSAxOTk5LjkuMTYCAwFnWTAJBgUrDgMCGgUAoIGxMBgGCSqGSIb3DQEJAzEL BgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTAwMDkwNzE2NDMwMVowIwYJKoZIhvcNAQkE MRYEFNB2aGIO00MiaNZoccGZxu2lEXmbMFIGCSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcNAwcw DgYIKoZIhvcNAwICAgCAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgFAMA0GCCqGSIb3DQMCAgEo MA0GCSqGSIb3DQEBAQUABIGAA5lqE75wIjfmvtHh8Kfsj0yZRyABkLbWM9DQ4ELY7F90xTQA jTMM70RQPJ+IO0s0SBrTL9qZY1Ny65cWWZvNEj4PVTlHsSMyrThrqtYSRtELXHIkRSyRN1J/ +UNiRXK8QAHMv4aH/M/cqXco4x6qsnmksPBWACvxYXr18ispvMs= --ms1C95003524CA825ECA7335D5-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit
RE: logon problems
Is there an answer in here somewhere? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 2:57 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: logon problems All users required to log on to the Intranet were setup as Domain Users and then I enabled Domain Users to "Log on locally". Thanks for the help and insight. With all the Knowledge base info on Microsoft I was drawing blanks on this one. I just lifted this right out of the Microsoft IIS Resource Kit book, which is a worthwhile purchase if you're running IIS. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Access uploads and Remote CF restart
This is a cryptographically signed message in MIME format. --ms2D1D0D6B0A76E7482821ABB7 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit For some reason, I found this line amusing: "This database is Access97 and contains mission critical data." Yeah, I know...sigh "mission critical" is probably not the best way to describe the data, realistically. But, I got a good batch of answers ;o) Thanks :o) While I understand why a lot of people use Access, that doesn't mean I condone it. If you're running SQL Server, for example, you could build all kinds of batch processes to transfer data through the internet from one database to another. It may be the case that you're better off using Access in this case, but maybe not. in this case, Access suits the purpose and performs quite well (The site gets ~2000 page views a day, so not very busy). A simple search of a database of waterparks. will -- William H. Bowen misterbowen.com *Web Design Solutions for Business* [EMAIL PROTECTED] http://www.misterbowen.com/ 425.423.0794 Voice 425.740.0183 FAX ICQ#: 2062149 --ms2D1D0D6B0A76E7482821ABB7 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIIH8AYJKoZIhvcNAQcCoIIH4TCCB90CAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC BcEwggKlMIICDqADAgECAgMBZ1kwDQYJKoZIhvcNAQEEBQAwgZQxCzAJBgNVBAYTAlpBMRUw EwYDVQQIEwxXZXN0ZXJuIENhcGUxFDASBgNVBAcTC0R1cmJhbnZpbGxlMQ8wDQYDVQQKEwZU aGF3dGUxHTAbBgNVBAsTFENlcnRpZmljYXRlIFNlcnZpY2VzMSgwJgYDVQQDEx9QZXJzb25h bCBGcmVlbWFpbCBSU0EgMTk5OS45LjE2MB4XDTk5MDkxNzE1Mjg0MloXDTAwMDkxNjE1Mjg0 MlowRjEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEjMCEGCSqGSIb3DQEJARYU d2lsbEBtaXN0ZXJib3dlbi5jb20wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAOlzm9u0 WrSTiSs5uemdEFoljOltJYrtMmJt7e3A1BkYagk+fj/tNaovsW6GvcVnG68ABiBLZKNJ4DGH +uFPxfG9aEdFKats99IdiVQBz4qC1ry7Wbouj+yaW6tO/VpS8QKv2dk3o0EbFn3Yk8PzXWOd s6+rFWA9bxuFvV95ZkwPAgMBAAGjUjBQMB8GA1UdEQQYMBaBFHdpbGxAbWlzdGVyYm93ZW4u Y29tMAwGA1UdEwEB/wQCMAAwHwYDVR0jBBgwFoAUiKvxYINmVfTkWMdGHcBhvSPXw4wwDQYJ KoZIhvcNAQEEBQADgYEAM1GGG2bT8fMPoLz+ZHqqtqTr85taghWnOTF3PjUqaYeanZzBuI29 fyIYgPZKQoRm3zgdANNU9GaveX9HLc6rStY5pOplLuJuUyoWMlJ/UIXzftTw/89yPmNXAzMN ShRzJ68RRGnXoRWYreb/t+HiavJ7Yninpvdfcoq6hwN4Av0wggMUMIICfaADAgECAgELMA0G CSqGSIb3DQEBBAUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIw EAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQL Ex9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVy c29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRo YXd0ZS5jb20wHhcNOTkwOTE2MTQwMTQwWhcNMDEwOTE1MTQwMTQwWjCBlDELMAkGA1UEBhMC WkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxDzANBgNV BAoTBlRoYXd0ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1Bl cnNvbmFsIEZyZWVtYWlsIFJTQSAxOTk5LjkuMTYwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJ AoGBALNpWpfU0BYLerXFXekhnCNyzRJMS/d+z8f7ynIk9EJSrFeV43theheE5/1yOTiUtOrt ZaeSBl694GX2GbuUeXZMPrlocHWEHPQRdAC8BSxPCQMXMcz0QdRyxqZd4ohEsIsuxE3x8NaF PmzzlZR4kX5A6ZzRjRVXjsJz5TDeRvVPAgMBAAGjNzA1MBIGA1UdEwEB/wQIMAYBAf8CAQAw HwYDVR0jBBgwFoAUcknCczTGVfQLdnKBfnf0h+fGsg4wDQYJKoZIhvcNAQEEBQADgYEAa8ZZ 6TH66bbssQPY33Jy/pFgSOrGVd178GeOxmFw523CpTfYnbcXKFYFi91cdW/GkZDGbGZxE9AQ fGuRb4bgITYtwdfqsgmtzy1txoNSm/u7/pyHnfy36XSS5FyXrvx+rMoNb3J6Zyxrc/WG+Z31 AG70HQfOnZ6CYynvkwl+Vd4xggH3MIIB8wIBATCBnDCBlDELMAkGA1UEBhMCWkExFTATBgNV BAgTDFdlc3Rlcm4gQ2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxDzANBgNVBAoTBlRoYXd0 ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1BlcnNvbmFsIEZy ZWVtYWlsIFJTQSAxOTk5LjkuMTYCAwFnWTAJBgUrDgMCGgUAoIGxMBgGCSqGSIb3DQEJAzEL BgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTAwMDkwNzIxMTEyMlowIwYJKoZIhvcNAQkE MRYEFC3HUs7gZeIV1H3jT8YZVqdkm4cZMFIGCSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcNAwcw DgYIKoZIhvcNAwICAgCAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgFAMA0GCCqGSIb3DQMCAgEo MA0GCSqGSIb3DQEBAQUABIGA3eQELiGYKDfbWNQlClQHEVoofGqq0IqmfEl8aj8spjr89qE+ LIScAXI8GAlF91wjGrYNtN2NpcNw/hHBLJQ5URDqFe23uI0jBomL+inSW1De7Xdpfj8OeYOg DEN6B1PGju18tVa5Yuitrx3S9rknElIsCSPYK8eC6yfCipkwUQM= --ms2D1D0D6B0A76E7482821ABB7-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Web-based email
Hey, i have a fully functional (more or less) email system built up. It is POP compliant, and can support any number of users ( it depends on what mail server you are running). If you would like to take a look at it, email me. Chris Martin [EMAIL PROTECTED] www.fslink.com www.fsenablers.com - Original Message - From: "Owen Leonard" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, September 07, 2000 12:53 Subject: Web-based email Hi everybody, I'm trying to build a functional, usable e-mail system based on the framework of the example application included with ColdFusion. Every time I run into a snag, I wonder why I'm reinventing the wheel when others must be trying to do the same thing. There don't seem to be a lot of resources available on the subject. Are there other people out there trying to do this? -- Owen - Athens County Library Services http://www.athenscounty.lib.oh.us -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Web-based email
I'm using iMS Mail from ODS, and I say it rocks! Totally extensible, totally configurable, and I haven't found a single feature that isn't possible with the server yet. CFUG-SFL Manager -Kev /CFUG-SFL Manager -Original Message- From: Steve Pierce [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 3:10 PM To: [EMAIL PROTECTED] Subject: RE: Web-based email Hi Owen, Yes, give up using the sample webmail with CF. Go with Howies iMS solution www.coolfusion.com or purchase a specially built webmail package like SoftEdge from www.software.com or WebMail from www.infinite.com. There are other free solutions out there but you get what you pay for. Good Luck, - Steve Steve Pierce, HDL "Co-Location starting $99 per month, no setup fee" (734) 482-9682 | mailto:[EMAIL PROTECTED] | http://HDL.com -Original Message- From: Owen Leonard [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 12:54 PM To: CF-Talk Subject: Web-based email Hi everybody, I'm trying to build a functional, usable e-mail system based on the framework of the example application included with ColdFusion. Every time I run into a snag, I wonder why I'm reinventing the wheel when others must be trying to do the same thing. There don't seem to be a lot of resources available on the subject. Are there other people out there trying to do this? -- Owen - Athens County Library Services http://www.athenscounty.lib.oh.us -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
