RE: Could Not Delete From Specified Tables
Patty: When you go into the relationships window in Access 2000, you can add your tables (which I gather you've done) to the diagram and then specify which fields match up, whether to enforce referential integrity between them, and what join type they use. Basically once you relate a primary key to other fields, those fields are considered foreign keys to the primary. So you only want one primary key called cabinID in the cabins table. The cabinID fields in the other two tables, the photo tables, will be foreign keys, which you don't have to specify directly. Basically they can even be foreign keys if you DON'T specify a relationship between them and the primary key, however as a best practice you want to have the database do as much work as possible so you don't have to manually enforce the relationships or cascade update and delete manually within your code. I've responded more below under your questions: -Original Message- From: P@tty Ayers [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 7:59 PM To: CF-Talk Subject: Re: Could Not Delete From Specified Tables Andy - Thanks for your response. (Still welcoming any help from others as well..) Do you mean you have a primary key called photoID in this table as a primary key? cabinID in this table should be a foreign key, related to the cabins table. Okay, I just checked and no, actually I didn't make photoID in the table 'photos' a primary key. I *did* make 'otherphotoID' in 'otherphotos' a primary key. Let me see if I am understanding you - should the two secondary tables, each which have a 'cabinID' column, each have 'cabinID' as a foreigh key, and neither should have a primary key? Both should have a primary key (again as a good database design practice, but not always necessary). Name the keys whatever you want. I suggest photoID and otherphotoID, as you have it now. Both should also have cabinID as a foreign key, related to the primary key cabinID in the cabins table. And (forgive my ignorance) how do I make a foreign key? I'm looking in Access's help files and a reference book, but haven't found it yet. In the relationships window, you can specify which keys are related. You can, for instance, click on the primary key in cabins (cabinID), hold down the mouse button and drag to the foreign key in photos (cabinID). A box will pop up (I take it you might've done this already) where you can specify more options for how the fields are related, join types, and more. Sorry if I've repeated myself -- it's late and time to sleep! - Andy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Sites discussion groups for coldfusion
Hi friends, I am working in coldfusion. I have done a demo project. I want to host it in the real server. Can anybody tell me the sites for coldfusion free hosting other than cfm-resources.com cf-developer.net? with thanks regards, G. KISHORE KUMAR Mail : [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT But Urgent - Knock CF if you dare
Thanks Mike, I got some more info. The Rival company is slating CF by saying it is not as secure as ASP. I am not gonna fling Mud but the client was looking for some independent reviews. Any one got info on CF security V ASP Security? Cheers D -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 00:12 To: CF-Talk Subject: RE: OT But Urgent - Knock CF if you dare Here are a couple of useful URL's http://www.webreview.com/2000/09_01/developers/09_01_00_1.shtml This is Microsoft's take on CFAS http://msdn.microsoft.com/library/default.asp?URL=/library/periodic/peri od00 /coldfusion.htm Kind Regards - Mike Brunt Macromedia Consulting Tel 562.243.6255 Fax 401.696.4335 http://www.allaire.com/services/consulting/ -Original Message- From: Daryl Fullerton [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 2:04 PM To: CF-Talk Subject: OT But Urgent - Knock CF if you dare Hi all, We use a little bit of ASP with CF from time to time. We are pitching for a contract whereby the opposition are slating CF big time. In actual fact they are saying all sorts of bad things about CF to the client in an effort to get the client to move to ASP. Any Amunition out there i can fire back with. I dont normally slate ASP but they have started this. Articles would be good... Appreciate the help Cheers D Daryl Fullerton, Managing Partner, BizNet Solutions, Allaire Premier Partner (Ireland) 133 - 137 Lisburn Road Belfast BT9 7AG N.Ireland Direct +44 (0) 28 9022 7888 Tel +44 (0) 028 9022 3224 Fax +44 (0) 028 9022 3223 [EMAIL PROTECTED] Http://www.BizNet-Solutions.com [EMAIL PROTECTED] (Chairman) Http://www.cfug.ie The Irish Cold Fusion User Group ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hosting recommendations
ATSWEBNET has been excellent. www.atswebnet.com Let Robert know, Randy sent you if you consider them. -Original Message- From: Nathan Nelson [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 12:10 AM To: CF-Talk Subject: RE: Hosting recommendations Check us out at CFDynamics http://www.cfdynamics.com -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 5:57 PM To: CF-Talk Subject: Hosting recommendations I am looking for hosting recommendations for multiple client sites. Requirements include CF 4.x SQL Server 7.0 MS Access Cybercash ASP Particularly interest in hosts with a good availability track record and excellent support... so I won't be be spending all my time performing support duties. TIA Dick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stored Procedure
You may be able to use xp_cmdshell to execute the appropriate command string although DTS is basically there so you don't have to use Transact SQL or command line stuff to import data. If you want to do it that way you can use BCP or simple Transact SQL. Either way you can use the scheduler within SQL to automate the process -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: 05 April 2001 22:29 To: CF-Talk Subject: Stored Procedure Is it possible for a stored procedure to run a dts package. Joshua Tipton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Scheduled tasks using CF
I have run scheduled tasks from the following platforms without a problem. One cause if not to put the scheduled tasks behind an odd port that a normal HTTP request can not get to. The CFSchedule acts as a USER thus behind a port that is internal that calls for authentication will not work unless this is changed in CF5. NT4/IIS/CF4.01 NT4/IIS/CF4.5 PWS/W2K/CF4.5 PWS/WIN98/CF4.5 PWS/WIN98/CF4.01 -Original Message- From: Michael S. Kimmett [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 6:03 PM To: CF-Talk Subject: Scheduled tasks using CF Question? What are some of the problems you or a client has had with scheduled tasks using CF? Specifics of the incident and the resolution would be very helpful. Also if you know, the web server used and version of CF server would be helpful. I am building a application for a client and reliablity is very important. If scheduled tasks are going to fail often, then the reliable answer will be to have this done manually. Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Scheduled tasks using CF
cfscheduler is renown for being unreliable - we've had two examples of scheduled events working fine on a daily basis for over a year or so, then failing completely - either not running at all, or having to be manually triggered in the administrator, or running but outputting 0kb size files. First case scenario was CF 4.01 Enterprise running on Solaris/Unix box - problem was fixed when back-ups of admin settings were re-instated - cause - never found Second case scenario was CF 4.5 Professional running on IIS/NT4 box - problem is still not resolved, have had to resort to changing the live site to call the dynamic page that was previously being called to print the static page via scheduler - cause - still not found - Allaire and usergroups have not been able to assist - have tried everything from start/stop, reinstall, remove/reinstate, upgrade and kicking the f**ker Hope this helped James "Remember amateurs built the ark... Professionals built the Titanic" (fyi - we now rely more or either server scheduled events or SQL server scheduled SPs to do the regular update stuff - a little more reliable - so far!!!) -Original Message- From: Michael S. Kimmett [mailto:[EMAIL PROTECTED]] Sent: 05 April 2001 23:03 To: CF-Talk Subject: Scheduled tasks using CF Question? What are some of the problems you or a client has had with scheduled tasks using CF? Specifics of the incident and the resolution would be very helpful. Also if you know, the web server used and version of CF server would be helpful. I am building a application for a client and reliablity is very important. If scheduled tasks are going to fail often, then the reliable answer will be to have this done manually. Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Submital
Are you speaking about a JavaScript Rollover? So moving the mouse over a certain area submits a form? If so, then on the Rollover function you can add form.submit = true within the JavaScript code where "form" should be the name of the form being submitted. -Original Message- From: Alan Koenig [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 5:51 PM To: CF-Talk Subject: Form Submital I have a rollover that needs to be a form submital. I need to make this rollover pass some paramaters for me. How can I best do this? TIA Alan Koenig ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: e fax
Andy, Thank you so mcuh! - Original Message - From: "Andrew Tyrone" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, April 05, 2001 5:34 PM Subject: RE: e fax Try Protus: http://www.protus.com/index.cfm A company I used to work for uses them with great success, apparently. (Andy they use ColdFusion...) - Andy -Original Message- From: Chang Liu [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:08 PM To: CF-Talk Subject: e fax hi all, my project needs to send out fax after web users input information to a form. does somebody know any custom tags and software for cold fusion server? PS. I know cf_fax and http://www.protonet.com/ , but seems their download server has something wrong. hope somebody can help this. thank you very much in advance! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: USPS API
Robert, We implemented USPS shipping via the XML/API for international shipping about 3 months ago. Pretty simple to work with. Let me know if you want any specifics. Kurt -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 3:09 PM To: CF-Talk Subject: USPS API Anyone do anything with the USPS api or anything with thier rate tables they have on the site? Robert Everland III Web Developer Dixon Ticonderoga ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Whiteboarding
Does anyone know of a whiteboarding app (preferably written in CF/Java) that can be licensed for use in custom apps? It would be use in a simple distance learning application. TIA Joe Tartaglia High Caliber Systems Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ASCII for Tab
'Mornin, Can anybody tell me what the ASCII for 'Tab' is so I can remove them? Thanks Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ASCII for Tab
I belive its ASCII '9' Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 13:01 To: CF-Talk Subject: ASCII for Tab 'Mornin, Can anybody tell me what the ASCII for 'Tab' is so I can remove them? Thanks Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ASCII for Tab
So it would be #009; in a replace statement. Is this correct? Thanks, Dave - Original Message - From: "Jason Lees (National Express)" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 8:06 AM Subject: RE: ASCII for Tab I belive its ASCII '9' Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 13:01 To: CF-Talk Subject: ASCII for Tab 'Mornin, Can anybody tell me what the ASCII for 'Tab' is so I can remove them? Thanks Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Whiteboarding
Webex.com? Erika -Original Message- From: Joe Tartaglia [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 8:12 AM To: CF-Talk Subject: Whiteboarding Does anyone know of a whiteboarding app (preferably written in CF/Java) that can be licensed for use in custom apps? It would be use in a simple distance learning application. TIA Joe Tartaglia High Caliber Systems Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ASCII for Tab
At 13:06 06/04/01 +0100 Jason Lees (National Express) said I belive its ASCII '9' http://www.neurophys.wisc.edu/www/comp/docs/ascii.html I have one of these printed off above my Desk and another in a folder for the occasions when others "borrow it"! Gordon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ASCII for Tab
I think it would be better to chr(9) in he replace statement, Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 13:11 To: CF-Talk Subject: Re: ASCII for Tab So it would be #009; in a replace statement. Is this correct? Thanks, Dave - Original Message - From: "Jason Lees (National Express)" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 8:06 AM Subject: RE: ASCII for Tab I belive its ASCII '9' Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 13:01 To: CF-Talk Subject: ASCII for Tab 'Mornin, Can anybody tell me what the ASCII for 'Tab' is so I can remove them? Thanks Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Fw: ASCII for Tab
Duh - #Chr(9)# does it - brain fart . . . - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 06, 2001 8:10 AM Subject: Re: ASCII for Tab So it would be #009; in a replace statement. Is this correct? Thanks, Dave - Original Message - From: "Jason Lees (National Express)" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 8:06 AM Subject: RE: ASCII for Tab I belive its ASCII '9' Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 13:01 To: CF-Talk Subject: ASCII for Tab 'Mornin, Can anybody tell me what the ASCII for 'Tab' is so I can remove them? Thanks Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ASCII for Tab
There's also a reference available at www.asciitable.com. I find that one very easy to remember. Bob -Original Message- From: Gordon Burns [mailto:[EMAIL PROTECTED]] Sent: April 6, 2001 8:06 AM To: CF-Talk Subject: RE: ASCII for Tab At 13:06 06/04/01 +0100 Jason Lees (National Express) said I belive its ASCII '9' http://www.neurophys.wisc.edu/www/comp/docs/ascii.html I have one of these printed off above my Desk and another in a folder for the occasions when others "borrow it"! Gordon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Hosting recommendations
Two things to consider before picking ATSWEBNET: Bandwidth Reliability It might just be me, but it seems they are down more than the average ISP. Good luck, Allison McMearty ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT But Urgent - Knock CF if you dare
This is going to sound annoyingly familiar, but: Most security holes in ColdFusion are not the product of ColdFusion, but faults of the underlying webserver (e.g. IIS), and this is not going to change between ASP and ColdFusion. Apart from that (and maybe a side note about Netegrity), I think this is really THE SAME DISCUSSION AS SCALABILITY -- it's not the language that is insecure, it's the code and architecture you build with it. If you're letting SQL statement parameters come through the URL without checking them first, if you're not filtering your form data, if you aren't preventing users from running includes directly, then your application is insecure in both ASP and ColdFusion. I could go on and on about this, but since pages and pages have been generated over the scalibility issue, and since I really think it's the exact same issue, and since the song is inherently boring to the choir, I'll stop. But go through the list archive and look at the scalability discussion, particularly at Doug Nottage's and Dave Watt's posts on this which I think were very good. Then tell your client the most important question is not what is the better language. It's who is the better firm. Michael Caulfield -Original Message- From: Daryl Fullerton [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 3:51 AM To: CF-Talk Subject: RE: OT But Urgent - Knock CF if you dare Thanks Mike, I got some more info. The Rival company is slating CF by saying it is not as secure as ASP. I am not gonna fling Mud but the client was looking for some independent reviews. Any one got info on CF security V ASP Security? Cheers D -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 00:12 To: CF-Talk Subject: RE: OT But Urgent - Knock CF if you dare Here are a couple of useful URL's http://www.webreview.com/2000/09_01/developers/09_01_00_1.shtml This is Microsoft's take on CFAS http://msdn.microsoft.com/library/default.asp?URL=/library/periodic/peri od00 /coldfusion.htm Kind Regards - Mike Brunt Macromedia Consulting Tel 562.243.6255 Fax 401.696.4335 http://www.allaire.com/services/consulting/ -Original Message- From: Daryl Fullerton [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 2:04 PM To: CF-Talk Subject: OT But Urgent - Knock CF if you dare Hi all, We use a little bit of ASP with CF from time to time. We are pitching for a contract whereby the opposition are slating CF big time. In actual fact they are saying all sorts of bad things about CF to the client in an effort to get the client to move to ASP. Any Amunition out there i can fire back with. I dont normally slate ASP but they have started this. Articles would be good... Appreciate the help Cheers D Daryl Fullerton, Managing Partner, BizNet Solutions, Allaire Premier Partner (Ireland) 133 - 137 Lisburn Road Belfast BT9 7AG N.Ireland Direct +44 (0) 28 9022 7888 Tel +44 (0) 028 9022 3224 Fax +44 (0) 028 9022 3223 [EMAIL PROTECTED] Http://www.BizNet-Solutions.com [EMAIL PROTECTED] (Chairman) Http://www.cfug.ie The Irish Cold Fusion User Group ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Hosting recommendations
Since my last flaming for posting about my service. I have tried to resist, but I have to take offense to the statement of being down more then the average ISP. As with all we are at the mercy of the internet in general, but we strive to keep our uptime at 99.7% or greater and have the numbers and stats to prove it. I constantly have my servers and sites monitored from 3 diverse links inbound and would be happy to look into any specific incidents people have had. Sorry for the post, but when someone strikes a cord, I will take the abuse from the flamers. Thanks, Robert - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 8:40 AM Subject: Re: Hosting recommendations Two things to consider before picking ATSWEBNET: Bandwidth Reliability It might just be me, but it seems they are down more than the average ISP. Good luck, Allison McMearty ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Hosting recommendations
I hate to differ with or start something... but I have been down once in 6months and that is due to someones bad code locking up CF. As for bandwidth, they are the fastest host I have ever used including my place of employment. I use my site everyday for development and I use my tools that I host there everyday. Thanks. -- Original Message -- From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 06 Apr 2001 08:40:50 EDT Two things to consider before picking ATSWEBNET: Bandwidth Reliability It might just be me, but it seems they are down more than the average ISP. Good luck, Allison McMearty ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Time off by an hour?
Our Windows NT 4 Server, running Cold Fusion 4.01 switched over with daylight savings time, yet Cold Fusion seems to still be an hour off.. The system time itself is correct, but running a script which outputs #now()# reports an hour behind. Has anybody else encountered this problem and have a fix for it? We've rebooted the machine, as well as stopped and started the Cold Fusion services, but it doesn't seem to have any effect... Thanks, Scott Becker Web Developer : ConnectWise, Inc. www.ConnectWise.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Hosting recommendations
Robert, Customers, without enough information, draw their own conclusions about the cause of downtime. I don't know what you do, but CFHosting shows the courtesy of sending out announcements following outages to explain why they happened. When I know some yo-yo in downtown Atlanta cut a fiber optic line, I tend not to be irritated with CFHosting. It's not a bad strategy. While your servers may be up 99.7% of the time, other factors cause downtime, too. Sending accurate information to customers should lessen the griping. Regards, --John net_man@minds pring.comTo: CF-Talk [EMAIL PROTECTED] cc: 04/06/2001Subject: Re: Hosting recommendations 07:52 AM Please respond to cf-talk Since my last flaming for posting about my service. I have tried to resist, but I have to take offense to the statement of being down more then the average ISP. As with all we are at the mercy of the internet in general, but we strive to keep our uptime at 99.7% or greater and have the numbers and stats to prove it. I constantly have my servers and sites monitored from 3 diverse links inbound and would be happy to look into any specific incidents people have had. Sorry for the post, but when someone strikes a cord, I will take the abuse from the flamers. Thanks, Robert - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 8:40 AM Subject: Re: Hosting recommendations Two things to consider before picking ATSWEBNET: Bandwidth Reliability It might just be me, but it seems they are down more than the average ISP. Good luck, Allison McMearty ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Old e-mails
don't you wish you were so special! *grin* I'm getting them also. Seems to happen every once and awhile. - Douglas Knudsen Leveraged Technologies Group Alltel AIS 678-351-6063 Got Linux? http://linuxmall.com From: [EMAIL PROTECTED] AT INTERNET on 04/06/2001 08:56 AM To: [EMAIL PROTECTED] AT INTERNET@CCMAIL cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) Subject: Old e-mails Am I the only one getting e-mails from a few days back all over again ? Regards, Thomas Chiverton, ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Hosting recommendations
If I were your ISP, and I saw what you just said, (begin quote) "I use my site everyday for development" (end quote) - I'd freeze your account. People "developing" on these shared servers has to be the cause of the biggest bulk of their down time. When you develop on a shared server, you put everyone else's websites in jeopardy. My $0.02 worth . . . Dave - Original Message - From: "Clint Tredway" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 9:05 AM Subject: Re: Hosting recommendations I hate to differ with or start something... but I have been down once in 6months and that is due to someones bad code locking up CF. As for bandwidth, they are the fastest host I have ever used including my place of employment. I use my site everyday for development and I use my tools that I host there everyday. Thanks. -- Original Message -- From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 06 Apr 2001 08:40:50 EDT Two things to consider before picking ATSWEBNET: Bandwidth Reliability It might just be me, but it seems they are down more than the average ISP. Good luck, Allison McMearty ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfselect required='yes' is useless....
cfselect What were they thinking. Pardon me if I am just being ignorant but the "Required='yes'" attribute is completely useless. When the query values are inserted there is no way to default the select box to null, therefore there is no way to "not" select a value... Any thoughts would be appreciated. Thanks Jeremy Castonguay Sr. Web Developer eCopy Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Time off by an hour?
This is a problem with old apps compiled with a broken C++ library. I suggest you upgrade CF / NT to more recent versions / patches. -Original Message- From: Scott Becker [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 2:08 PM To: CF-Talk Subject: CF Time off by an hour? Our Windows NT 4 Server, running Cold Fusion 4.01 switched over with daylight savings time, yet Cold Fusion seems to still be an hour off.. The system time itself is correct, but running a script which outputs #now()# reports an hour behind. Has anybody else encountered this problem and have a fix for it? We've rebooted the machine, as well as stopped and started the Cold Fusion services, but it doesn't seem to have any effect... Thanks, Scott Becker Web Developer : ConnectWise, Inc. www.ConnectWise.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Time off by an hour?
hey, yes, there is a problem on NT that the daylight savings time does not properly adjust the system time... the tray time will display proper time but the time is off in other things that call it from the system... this is suppose to self correct itself after the Arpil 8th... or you can go into the control panel and remove the check from "automatically adjust time for daylight savings" and set the time and it will be back to normal... I read this on the Microsoft web site... has to do with bug when daylights savings time adjustment occurs on April 1st... this year and again next year... Jay -Original Message- From: Scott Becker [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 9:08 AM To: CF-Talk Subject: CF Time off by an hour? Our Windows NT 4 Server, running Cold Fusion 4.01 switched over with daylight savings time, yet Cold Fusion seems to still be an hour off.. The system time itself is correct, but running a script which outputs #now()# reports an hour behind. Has anybody else encountered this problem and have a fix for it? We've rebooted the machine, as well as stopped and started the Cold Fusion services, but it doesn't seem to have any effect... Thanks, Scott Becker Web Developer : ConnectWise, Inc. www.ConnectWise.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Time off by an hour?
Same thing happens on our system running CF server 4.5.1 and windows NT4 SP 4 Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 2:26 PM To: CF-Talk Subject: RE: CF Time off by an hour? This is a problem with old apps compiled with a broken C++ library. I suggest you upgrade CF / NT to more recent versions / patches. -Original Message- From: Scott Becker [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 2:08 PM To: CF-Talk Subject: CF Time off by an hour? Our Windows NT 4 Server, running Cold Fusion 4.01 switched over with daylight savings time, yet Cold Fusion seems to still be an hour off.. The system time itself is correct, but running a script which outputs #now()# reports an hour behind. Has anybody else encountered this problem and have a fix for it? We've rebooted the machine, as well as stopped and started the Cold Fusion services, but it doesn't seem to have any effect... Thanks, Scott Becker Web Developer : ConnectWise, Inc. www.ConnectWise.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Time off by an hour?
We are having the same problem with one of our servers. According to Allaire, it is a problem with the Visual C++ that was used to create Cold Fusion. It doesn't recognize April 1st as the first day of Daylight Savings. It recognizes April 8th. This means that it should correct itself on Sunday. The other fix is to upgrade to 4.5.1 because the problem has been fixed since that version. http://forums.allaire.com/DevConf/Thread.cfm?Message_ID=691270_#Message69 1270 http://forums.allaire.com/DevConf/Thread.cfm?Message_ID=690790_#Message69 0790 -Original Message- From: Scott Becker [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 7:08 AM To: CF-Talk Subject: CF Time off by an hour? Our Windows NT 4 Server, running Cold Fusion 4.01 switched over with daylight savings time, yet Cold Fusion seems to still be an hour off.. The system time itself is correct, but running a script which outputs #now()# reports an hour behind. Has anybody else encountered this problem and have a fix for it? We've rebooted the machine, as well as stopped and started the Cold Fusion services, but it doesn't seem to have any effect... Thanks, Scott Becker Web Developer : ConnectWise, Inc. www.ConnectWise.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfselect required='yes' is useless....
Write your own javascript to validate the select box. The problem is that with a "single" select box there is always something selected. Using a multi-select box, the validation in CFFORM works just fine. You used to be able to modify the javascript that CFFORM used, but that changed with 4.0x. DC - Original Message - From: "Jeremy Castonguay" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 09:23 Subject: cfselect required='yes' is useless cfselect What were they thinking. Pardon me if I am just being ignorant but the "Required='yes'" attribute is completely useless. When the query values are inserted there is no way to default the select box to null, therefore there is no way to "not" select a value... Any thoughts would be appreciated. Thanks Jeremy Castonguay Sr. Web Developer eCopy Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfselect required='yes' is useless....
cfselect name="fiscalyr" size="1" query="queryname" message="Your Are Required to Enter A Fiscal Year" required="Yes" option value="" selected/option /cfselect I use the above example all the time for the scenario you described below. Steven Semrau SRA International, Inc. Senior Member, Professional Staff [EMAIL PROTECTED] [EMAIL PROTECTED] Com: (703) 805-1095 DSN: (703) 655-1095 -Original Message- From: Jeremy Castonguay [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 9:23 AM To: CF-Talk Subject: cfselect required='yes' is useless cfselect What were they thinking. Pardon me if I am just being ignorant but the "Required='yes'" attribute is completely useless. When the query values are inserted there is no way to default the select box to null, therefore there is no way to "not" select a value... Any thoughts would be appreciated. Thanks Jeremy Castonguay Sr. Web Developer eCopy Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Hosting recommendations
It really depends upon the policies of the host. A lot of places state up front that development on their server is not allowed. Of course, if by development ya just mean ftping your debugged, coded, and tested files to the shared hosting environment... that is different. At 09:16 AM 04/06/2001 -0400, you wrote: If I were your ISP, and I saw what you just said, (begin quote) "I use my site everyday for development" (end quote) - I'd freeze your account. People "developing" on these shared servers has to be the cause of the biggest bulk of their down time. When you develop on a shared server, you put everyone else's websites in jeopardy. My $0.02 worth . . . Dave - Original Message - From: "Clint Tredway" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 9:05 AM Subject: Re: Hosting recommendations I hate to differ with or start something... but I have been down once in 6months and that is due to someones bad code locking up CF. As for bandwidth, they are the fastest host I have ever used including my place of employment. I use my site everyday for development and I use my tools that I host there everyday. Thanks. -- Original Message -- From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 06 Apr 2001 08:40:50 EDT Two things to consider before picking ATSWEBNET: Bandwidth Reliability It might just be me, but it seems they are down more than the average ISP. Good luck, Allison McMearty ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Hosting recommendations [KILL]
Please kill this thread or take it to CF-Community. Thanks, Bill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hosting recommendations
i've hosted at a number of large companies. my BEST experience EVER has been with Epoch Internet for the past 10 months. i have a full cabinet there running 10Mbps burstable. it's always extremely fast reliable and their response has always been immediate. granted, this might not be the $49.95/month solution some people are looking for. i've gone with smaller shops, but my clients are generally large corporations (annual gross of $200M or more). i went with a small outfit which went BK in june 2000 and i won't do it again. just my opinion. luckily, like with most products, there are a range of solutions to cater to an equitable range of needs. -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 PM To: CF-Talk Subject: Hosting recommendations I am looking for hosting recommendations for multiple client sites. Requirements include CF 4.x SQL Server 7.0 MS Access Cybercash ASP Particularly interest in hosts with a good availability track record and excellent support... so I won't be be spending all my time performing support duties. TIA Dick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfselect required='yes' is useless....
Well no offense, think about what you just stated. Using the Required="Yes" function means You REQUIRE a value thus the field will never be NULL. Thus why would you want a NULL value or NOT Select an item in the select. If you want a case where a user does not have to select a field within the select simply use: Required="No" The Required="Yes" allows a JavaScript message to display when the USER has not selected anything from that box. I think it is useful given the situation. -Original Message- From: Jeremy Castonguay [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 9:23 AM To: CF-Talk Subject: cfselect required='yes' is useless cfselect What were they thinking. Pardon me if I am just being ignorant but the "Required='yes'" attribute is completely useless. When the query values are inserted there is no way to default the select box to null, therefore there is no way to "not" select a value... Any thoughts would be appreciated. Thanks Jeremy Castonguay Sr. Web Developer eCopy Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hosting recommendations
When I used to run CF sites, I had good luck with Media3 (http://www.media3.net).. Now that I only personally run PHP on Linux systems, I use JTL Networks (http://www.jtlnet.com) and they do have a CF offering as well. They've had good support and reliability, but I don't know if their NT and CF boxes are as good as the linux boxes are... So you're moving away from Onvia, formerly Zanova, formerly iTOOL? At 10:09 PM 4/5/01 -0600, you wrote: -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 5:57 PM To: CF-Talk Subject: Hosting recommendations I am looking for hosting recommendations for multiple client sites. Requirements include CF 4.x SQL Server 7.0 MS Access Cybercash ASP Particularly interest in hosts with a good availability track record and excellent support... so I won't be be spending all my time performing support duties. TIA Dick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfselect required='yes' is useless....
It's only useless on a select box with a size of 1. On a select box with a size greater then 1, it works fine, and is useful. What you could do, is crib the CFSELECT validation Javascript, add in your own code for Single Size Selects, and hook it up to the CFFORM validation routine, and just use a SELECT and loop over your OPTIONS instead of using a CFSELECT. Jeremy Castonguay wrote: cfselect What were they thinking. Pardon me if I am just being ignorant but the "Required='yes'" attribute is completely useless. When the query values are inserted there is no way to default the select box to null, therefore there is no way to "not" select a value... Any thoughts would be appreciated. Thanks Jeremy Castonguay Sr. Web Developer eCopy Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfselect required='yes' is useless....
The issue is that the idea is to force a selection, ie: an entry that has a value. Most of us use a "blank" option to start with as you show. Unfortunately the cfselect produced javascript does not properly handle this issue. In a single select box something is always selected. Dave - Original Message - From: "Semrau, Steven L Mr SRA" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 09:38 Subject: RE: cfselect required='yes' is useless cfselect name="fiscalyr" size="1" query="queryname" message="Your Are Required to Enter A Fiscal Year" required="Yes" option value="" selected/option /cfselect I use the above example all the time for the scenario you described below. Steven Semrau SRA International, Inc. Senior Member, Professional Staff [EMAIL PROTECTED] [EMAIL PROTECTED] Com: (703) 805-1095 DSN: (703) 655-1095 -Original Message- From: Jeremy Castonguay [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 9:23 AM To: CF-Talk Subject: cfselect required='yes' is useless cfselect What were they thinking. Pardon me if I am just being ignorant but the "Required='yes'" attribute is completely useless. When the query values are inserted there is no way to default the select box to null, therefore there is no way to "not" select a value... Any thoughts would be appreciated. Thanks Jeremy Castonguay Sr. Web Developer eCopy Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Could Not Delete From Specified Tables
Andy - Thank you very much for this response. I think I understand a lot better, and I'm reading the Access book and database theory book to get a better grip on this. I'm considering re-building my database now, which is why I'm not pursuing this particular question further. I think it could be improved upon greatly and I might be able to avoid a lot of similar problems. Thanks again, P@tty Patty: When you go into the relationships window in Access 2000, you can add your tables (which I gather you've done) to the diagram and then specify which fields match up, whether to enforce referential integrity between them, and what join type they use. Basically once you relate a primary key to other fields, those fields are considered foreign keys to the primary. So you only want one primary key called cabinID in the cabins table. The cabinID fields in the other two tables, the photo tables, will be foreign keys, which you don't have to specify directly. Basically they can even be foreign keys if you DON'T specify a relationship between them and the primary key, however as a best practice you want to have the database do as much work as possible so you don't have to manually enforce the relationships or cascade update and delete manually within your code. I've responded more below under your questions: -Original Message- From: P@tty Ayers [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 7:59 PM To: CF-Talk Subject: Re: Could Not Delete From Specified Tables Andy - Thanks for your response. (Still welcoming any help from others as well..) Do you mean you have a primary key called photoID in this table as a primary key? cabinID in this table should be a foreign key, related to the cabins table. Okay, I just checked and no, actually I didn't make photoID in the table 'photos' a primary key. I *did* make 'otherphotoID' in 'otherphotos' a primary key. Let me see if I am understanding you - should the two secondary tables, each which have a 'cabinID' column, each have 'cabinID' as a foreigh key, and neither should have a primary key? Both should have a primary key (again as a good database design practice, but not always necessary). Name the keys whatever you want. I suggest photoID and otherphotoID, as you have it now. Both should also have cabinID as a foreign key, related to the primary key cabinID in the cabins table. And (forgive my ignorance) how do I make a foreign key? I'm looking in Access's help files and a reference book, but haven't found it yet. In the relationships window, you can specify which keys are related. You can, for instance, click on the primary key in cabins (cabinID), hold down the mouse button and drag to the foreign key in photos (cabinID). A box will pop up (I take it you might've done this already) where you can specify more options for how the fields are related, join types, and more. Sorry if I've repeated myself -- it's late and time to sleep! - Andy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Could Not Delete From Specified Tables
Ben - Thanks very much for this response. I have the feeling I've built this database incorrectly, and I'm considering re-doing it. I will keep you posted! Appreciate your help, P@tty P@tty, If you have the tables related, with 'cabins' as the "parent" table, you cannot normally delete a 'cabins' record while there exist "child" records in 'photos' or 'otherphotos' with the same key (cabinID). You can use cascading delete in Access to do this. (As in "flows downhill".) Or, you can first delete all the photos for that cabinID, and subsequently delete the cabin record. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
syntactically valid variables?
Hi there, I'm getting the error below when attempting to generate a variable from a checkbox. I am using the FuseBox 'formURL2Attribute' tag, which is where the the issues are arising. Unfortunately, I'm not very sure what 'syntactically valid variable name' means in this context, or what about the variable is creating an error. Any pointers would be appreciated. (CF 4.5.1 on WinNT 4) TIA, Nicole. Error Occurred While Processing Request Error Diagnostic Information An error occurred while evaluating the expression: NOT ISDEFINED( 'ATTRIBUTES.' field ) Error near line 20, column 9. Parameter 1 of function IsDefined which is now "ATTRIBUTES.E6_HL_C/CCNOADD" must be a syntactically valid variable name The error occurred while processing an element with a general identifier of (CFIF), occupying document position (20:4) to (20:48) in the template file D:\CFUSION\CustomTags\formURL2Attributes.cfm. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: chat room application
Depending on the client's connection, auto-refresh the message frame could be annoying at best. I can envision a way of doing this entirely in Javascript using frames where you could autorefresh a "hidden" frame (one that doesn't draw anything), then use JS to check when a certain control field in that frame changes and update the main window, perhaps mainly a textarea box. Along the same lines, the "send a message" client frame would post to a script on your server that would cause the hidden frame's server source file to update. Getting it all to work out would be pretty cool...but not specifically cold fusion. The real trick of it all would be in the javascript; you could use CF to create the source pages, but thats about the limit of it. For grins and giggles, heres what I see the logic of individual frames would be: Frame:Submit, contains an input box and submit button. Action=post to server Frame:MainWindow, contains a textarea for messages and a hidden field called "lastMessage" Frame:JSControl, contains some javascript, a variable number of hidden fields and a meta refresh tag, time delayed 5-10 seconds The javascript would run everytime the page loads: int lastMessage=MainWindow.lastMessage while (there are messages in this frame later than MainWindow.lastMessage ) { get the message and message# append it to MainWindow.TextArea1 set MainWindow.lastMessage = this message number } On the server side, you would save the messages in some way, perhaps in a database; every time you get a post, age out the oldest one and add the newer one. The JSControl page would refresh and rebuild the message list from the database. The action page (when they post a message) would maintain the database and then redirect the client back to the original framed pages. Brian -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:39 PM To: CF-Talk Subject: RE: chat room application you can do it by auto refreshing a message pane with the META tag. if you want persistence, you should use something like Java or Flash. -Original Message- From: Jason Green [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 11:38 AM To: CF-Talk Subject: chat room application does anyone know of a place where i can find information about writing a chat room in coldfusion? or has anyone done this? i'm looking for something that would be like MSN Messenger, but not having to refresh the page all the time to view the new chats. if it can't be done in coldfusion, then i'll have to look elsewhere. thanks. jason ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Create login page with secure
There is a custom tag written by Digital Jungle called CF_Sentry, I believe their URL is http://www.digital-jungle.com and the tag is referenced on their home page. Hope this helps. Kind Regards - Mike Brunt Macromedia Consulting Tel 562.243.6255 Fax 401.696.4335 http://www.allaire.com/services/consulting/ -Original Message- From: Haryono ... [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 9:54 PM To: CF-Talk Subject: Create login page with secure Hallo everyone, Can anyone help me to create a login page securely? I you have made login page, can you give your source code? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Whiteboarding
Joe, check around the java applet sites. The basics of what makes whiteboarding work is less than 100 lines of java code. There a good chance you might find an free open source applet that works for you. If you have someone on staff who has ever written java, many "Learn Java" books use whiteboarding as a sample applet. It all depends on how complex you want it. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 8:12 AM To: CF-Talk Subject: Whiteboarding Does anyone know of a whiteboarding app (preferably written in CF/Java) that can be licensed for use in custom apps? It would be use in a simple distance learning application. TIA Joe Tartaglia High Caliber Systems Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hosting recommendations
When I used to run CF sites, I had good luck with Media3 (http://www.media3.net).. Now that I only personally run PHP on Linux systems, I use JTL Networks (http://www.jtlnet.com) and they do have a CF offering as well. They've had good support and reliability, but I don't know if their NT and CF boxes are as good as the linux boxes are... I can ditto the recommendation for Media3. They run Death Clock and have been near perfect for many months now. I've had one issue with them over the last year I think. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Create login page with secure
What exactly do you mean by securely? -- Original Message -- From: "Haryono ..." [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 05 Apr 2001 21:53:34 -0700 (PDT) Hallo everyone, Can anyone help me to create a login page securely? I you have made login page, can you give your source code? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: syntactically valid variables?
Remove the forward slash from the variable name. -Original Message- From: Toivonen, Nicole [SMTP:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 10:11 AM To: CF-Talk Subject: syntactically valid variables? Hi there, I'm getting the error below when attempting to generate a variable from a checkbox. I am using the FuseBox 'formURL2Attribute' tag, which is where the the issues are arising. Unfortunately, I'm not very sure what 'syntactically valid variable name' means in this context, or what about the variable is creating an error. Any pointers would be appreciated. (CF 4.5.1 on WinNT 4) TIA, Nicole. Error Occurred While Processing Request Error Diagnostic Information An error occurred while evaluating the expression: NOT ISDEFINED( 'ATTRIBUTES.' field ) Error near line 20, column 9. Parameter 1 of function IsDefined which is now "ATTRIBUTES.E6_HL_C/CCNOADD" must be a syntactically valid variable name The error occurred while processing an element with a general identifier of (CFIF), occupying document position (20:4) to (20:48) in the template file D:\CFUSION\CustomTags\formURL2Attributes.cfm. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc.
I am trying to get a db output where a user selects an alphabetical range in a form and then the sql selects all users in a db whose last names start with one of the letters in that range. For example, on a form page the user selects a range of a-f. I need to find all users whose last names start with a letter in that range and output the results. I think I recall a simple way to do this, but right now can't think of it. Could anyone jog my memory for me? Thanks, Paul Sinclair ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Tag Resource Index
I'm sure many of you have seen the CGI Resource Index (cgi-resources.com). Matt Wright has Perl and other scripts there (much like the Developers Exchange) but they are categorized more clearly PLUS you can rate the scripts. Members can comment on the scripts. Was it real or am I imagining that there was talk of Michael making a script depot at HoF? Is this correct Michael? If so, do you plan to make it so the tags can be rated. Most tags in the Dev Ex are very good. I've had a couple that were not really very useful though, and it would have been good to know what those who used the tags before me thought before I tried it. What do some of you others think? Myself, I find the format at CGI Resource Index very friendly. I use it all the time. Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT But Urgent - Knock CF if you dare
Daryl, Here's my take on the issue , taken from another list: johnnyb wrote: Is there any resources comparing these 3 server models - ASP, CF and JSP? What would be the main advantages/disadvantages of each? Johnny, Unless you're strongly into Visual Basic Script or JavaScript, CF is easier to use and learn. For instance, to do a simple query in ASP, it takes about 10 to 20 lines to query the database and then output the information to a web page. In contrast CF can do the exact same task in 6 to 8 lines. ColdFusion is easier to use, less cryptic and more powerful. If you know HTML you know about most of what it takes to code a basic Cold Fusion Page. In contrast ASP has a much steeper learning curve. There's a pretty good review of Cold Fusion at http://www.zdnet.com/products/stories/reviews/0,4161,402300,00.html In the same set they also compare other technologies. Compare how long does it take the average developer to set up a database enabled site in CF, ASP or whatever. CF is much more of a rapid development environment and considerably more efficient and understandable. For example, the following ASP script connects to a database and outputs the results to a browser: % Set OBJdbConnection = Server.CreateObject("ADODB.Connection") OBJdbConnection.Open "nba_membership" SQLQuery = "Select id, business FROM Directory" Set RSCustomers = OBJdbConnection.Execute(SQLQuery) Do Until rsCustomers.EOF Response.Write (rsCustomers("ID") " " rsCustomers("Business")) rsCustomers.MoveNext Loop % The same code in ColdFusion looks like this: cfquery name="rsCustomers" datasource="nba_membership" select id, business from directory /cfquery cfoutput query="rsCustomers"#id# #business#/cfoutput ASP take 9 lines to query the database and return the results to the browser, CF does it in 4. Both snippets do the exact same thing, but the ColdFusion code does it more elegantly and far more simply. It uses fewer commands, and those commands make a lot more sense. It doesn't take a genius to figure out what cfquery and cfoutput do. The ASP is a lot less intuitive. Also CF has integrated POP and SMTP mail components, is fully integrated with LDAP, and has a native search engine built into it based on the very powerful Verity97 search engine. Elsewhere in this newsgroup some have been asking how to set up a search. In CF its fully integrated into the server. You typically have to pay extra for those components with ASP. The result is that developers take far less time to develop an effective and usable site. When you are paying developers $65 per hour or more to develop the site, if a CF developer can set up the site in 6 hours vs. 18 or more for ASP or whatever, then you've paid for the ColdFusion server with the money you've saved in a very short time. Owen Palmer wrote: ASP servers are easier to find an often less expensive to host then CFML, JSP servers seem to be as rare as rocking horse shit, though I could be looking in the wrong place... Keep looking Owen. CF sites are as cheap to host as ASP sites, cheaper if you consider the number of security holes that ASP introduces to your server. There are free ColdFusion hosting companies, such as http://www.cfm-resources.com/. There are also some very low cost ones like http://www.Shanje.com or http://icn.net/, both of which charge around $15 to $25 for CF hosting. Additionally CF works with Unix, Linux (all flavors apparently, but I have not tested it yet), and NT. You need expensive add-ons to get ASP to work with Unix. The last I heard Linux has no ASP support There are several versions of the Cold Fusion Server - the FREE ColdFusion Express, ColdFusion Professional for $1200, and the $3000 ColdFusion Enterprise Server. The version of the CF Server that comes with UltraDev is the single user development version of CF Enterprise. Remember too that cost of ownership is a significant factor. With longer development times, more security concerns, etc., the cost of ownership is far higher for ASP than CF. I'm going to focus here on development costs. Lets say you costing an ASP or CF programmer at $65 an hour. They are developing 2 dynamic sites that do the exact same thing. The CF programmer will probably take less than half the amount of time to deliver a site than the ASP person, everything else considered equal - remember the 4 lines vs 9 lines of code? And at $65 per hour, that's a significantly lower cost to the client who is paying the bills. ASP(VBScript) is also probably easiest to pick up if your not from a programming background. I think I've covered that one already. ASP can be quite obscure and difficult to understand especially to newbies. Consider this output snippet again: Do Until rsCustomers.EOF Response.Write (rsCustomers("ID") " " rsCustomers("Business")) rsCustomers.MoveNext Loop % This loops through the output dataset and displays it onscreen. For a new learner
RE: DHTML Menu :: Spanning frameset?
if you want to see my rough solution. http://www.columbus.nbbj.com/Dhtml/Default.htm again Thanks to all who helped me! have a great weekend! -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 5:01 PM To: CF-Talk Subject: RE: DHTML Menu :: Spanning frameset? Paul, It's impossible to overlay a layer over a multiple frames. In order to have something appear over multiple frames, you'd need to use an ActiveX control or some other external control that's not bound to the browser window. The one thing you can do-but it's a big pain, is to have you're main topics in frame 1 then have the actual layers pop-up in frame 2. It'll appear to expand frames, but really the pieces are in two completely different frames. There's a library here that will work with frames, but the library is really slow loading for a lot of options (at least it was last time I looked at it.) http://www.webreference.com/dhtml/column51/ -Dan -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 2:48 PM To: CF-Talk Subject: RE: DHTML Menu :: Spanning frameset? here is the example i speak of. http://www.columbus.nbbj.com/Dhtml/Default.htm how would i put the sub menu in the frame set for the main page with the corporate Babel? also if i did that would the linked pages to that main frame set keep the sub menu intact? any advice would be Superb! thank you! -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 12:58 PM To: CF-Talk Subject: RE: DHTML Menu :: Spanning frameset? Hey Paul. I had some other problems as well with DHTML menus, and unfortunately, there are no workarounds. DHTML menus appear under IFRAMEs and SELECT boxes. Because you're loading two different pages, there is no workaround other than creating a layer in the other fram that you want the layer to appear in... Becauase in a normal framset, your framesets occur in the head of the page, not the body, I don't think you can put layers inside of the head tags successfully... Good luck... Hope you find a better answer =) -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 8:08 AM To: CF-Talk Subject: OT: DHTML Menu :: Spanning frameset? ok. i have a dhtml menu in my left frame set. is there a way that i can have the sub menus overlap the main frame or right frame? right now in the left frame nav, if i open a few sub menus they are partially hidden due to the next frameset. i would like the sub menu on top of all the frames? any ideas? please advise.. thank you -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: syntactically valid variables?
On 6 Apr 2001, at 10:11, Toivonen, Nicole wrote: Parameter 1 of function IsDefined which is now "ATTRIBUTES.E6_HL_C/CCNOADD" must be a syntactically valid variable name You can't have a slash in a variable name. A variable name must begin with a letter and contain only letters, numbers, and underscores. See "Naming and Scoping Variables" in "Developing Web Applications with ColdFusion". Keith C. Ivey [EMAIL PROTECTED] Webmaster, EEI Communications 66 Canal Center Plaza, Suite 200 Alexandria, VA 22314 Telephone: 703-683-0683 Fax: 703-683-4915 Web Site: http://www.eeicommunications.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc.
What type of database u using ? Rif -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 16:25 To: CF-Talk Subject:SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc. I am trying to get a db output where a user selects an alphabetical range in a form and then the sql selects all users in a db whose last names start with one of the letters in that range. For example, on a form page the user selects a range of a-f. I need to find all users whose last names start with a letter in that range and output the results. I think I recall a simple way to do this, but right now can't think of it. Could anyone jog my memory for me? Thanks, Paul Sinclair ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc.
try: WHERE field LIKE 'a%' OR field LIKE 'b%'... Aaron Cooper, BSc Application Developer, Freeserve.com Plc The Observatory, 36-41 Clerkenwell Close, London EC1R OAU T: 0207 553 4992 M: 07799 191 589 -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 16:25 To: CF-Talk Subject: SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc. I am trying to get a db output where a user selects an alphabetical range in a form and then the sql selects all users in a db whose last names start with one of the letters in that range. For example, on a form page the user selects a range of a-f. I need to find all users whose last names start with a letter in that range and output the results. I think I recall a simple way to do this, but right now can't think of it. Could anyone jog my memory for me? Thanks, Paul Sinclair ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfselect required='yes' is useless....
Thats the ticket, thanks for the code... -Original Message- From: Semrau, Steven L Mr SRA [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 9:38 AM To: CF-Talk Subject: RE: cfselect required='yes' is useless cfselect name="fiscalyr" size="1" query="queryname" message="Your Are Required to Enter A Fiscal Year" required="Yes" option value="" selected/option /cfselect I use the above example all the time for the scenario you described below. Steven Semrau SRA International, Inc. Senior Member, Professional Staff [EMAIL PROTECTED] [EMAIL PROTECTED] Com: (703) 805-1095 DSN: (703) 655-1095 -Original Message- From: Jeremy Castonguay [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 9:23 AM To: CF-Talk Subject: cfselect required='yes' is useless cfselect What were they thinking. Pardon me if I am just being ignorant but the "Required='yes'" attribute is completely useless. When the query values are inserted there is no way to default the select box to null, therefore there is no way to "not" select a value... Any thoughts would be appreciated. Thanks Jeremy Castonguay Sr. Web Developer eCopy Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc.
If it will always be exactly one character, instead of wildcards I would do select blah fromblahtable where left(lastname, 1) in (#listqualify(form.selectbox_of_letters, "'")#) you might have to use something other than left(lastname, 1) if your database uses a different function for that. Be sure to test with the max number of letters as some DBs don't allow an IN list to be longer than some magic number -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 11:25 AM To: CF-Talk Subject: SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc. I am trying to get a db output where a user selects an alphabetical range in a form and then the sql selects all users in a db whose last names start with one of the letters in that range. For example, on a form page the user selects a range of a-f. I need to find all users whose last names start with a letter in that range and output the results. I think I recall a simple way to do this, but right now can't think of it. Could anyone jog my memory for me? Thanks, Paul Sinclair ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: import 100 users into NT 4.0?
Is there any way to import 100 users into NT 4.0 rather then hand type them in? Thanks Chad ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfselect required='yes' is useless....
Anytime, glad I could provide a little help. Steven Semrau SRA International, Inc. Senior Member, Professional Staff [EMAIL PROTECTED] [EMAIL PROTECTED] Com: (703) 805-1095 DSN: (703) 655-1095 -Original Message- From: Jeremy Castonguay [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 12:26 PM To: CF-Talk Subject: RE: cfselect required='yes' is useless Thats the ticket, thanks for the code... -Original Message- From: Semrau, Steven L Mr SRA [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 9:38 AM To: CF-Talk Subject: RE: cfselect required='yes' is useless cfselect name="fiscalyr" size="1" query="queryname" message="Your Are Required to Enter A Fiscal Year" required="Yes" option value="" selected/option /cfselect I use the above example all the time for the scenario you described below. Steven Semrau SRA International, Inc. Senior Member, Professional Staff [EMAIL PROTECTED] [EMAIL PROTECTED] Com: (703) 805-1095 DSN: (703) 655-1095 -Original Message- From: Jeremy Castonguay [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 9:23 AM To: CF-Talk Subject: cfselect required='yes' is useless cfselect What were they thinking. Pardon me if I am just being ignorant but the "Required='yes'" attribute is completely useless. When the query values are inserted there is no way to default the select box to null, therefore there is no way to "not" select a value... Any thoughts would be appreciated. Thanks Jeremy Castonguay Sr. Web Developer eCopy Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help!
I'm not entirely sure what you're trying to do, but try something like this - SELECT Products.product_ID FROMProducts WHERE NOT EXISTS( SELECT Product_ID FROM StoreProducts WHERE Product_ID = Products.Product_ID AND Company_ID = Products.Company_ID ) That should get all Products from the Products table without a matching record in the storeProducts table. Just a tip - I always try to write my complicated queries in plain English first, then pseudocode, then translate it into SQL. I find it helps tremendously, because once you've written exactly what you want in english, the rest almost writes itself. Hope that helps Alistair Davidson Senior Developer Rocom New Media www.rocomx.net "A problem well stated is a problem half-solved" Albert Einstein -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: 04 April 2001 16:35 To: CF-Talk Subject: SQL: Help! I've got one heckuva mess on my hands. I am trying to straighten out a huge mess of an ecommerce application I have inherited. It went into production w/h zero testing a couple of months ago and now I am in firefighting mode). This app relies heavily on three tables company, products, storeproducts. Company contains store retailers and product distributors, products contain all products entered by distributors and storeproducts is a derived table that contains the combinations of products to retailers. (confused yet???). My problem is that I need to write a routine that lists all the combinations that exist in the company - products that do not exist in storeproducts and all the combinations in storeproducts that do not exist in company - products. A simplified version of the db schema looks like?: Company Company_ID (retailer or distributor) Products Company_ID (distributor) Product_ID StoreProducts Company_ID (retailer) Product_ID The answer probably uses outer joins but I haven't yet mastered the art of writting outer joins. Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF SCHEDULER
I have a page that if I run it in a browser it works fine. It processes the following code: CFHTTP method="get" url="http://www.blah.com/blah.cfm" CFSET newsindx = #CFHTTP.FILECONTENT# CFSET session.newsindxfilename = "#session.directory#\newsindx.htm" CFSET session.newsindxbody= "#newsindx#" !--- CFOUTPUT#newsindx#/CFOUTPUT --- CFLOCATION URL="newspublishnewsindx.cfm" Now if I run it manually it grabs the code from the CFHTTP, and then the CFLOCATION tag just pushes all the variables to another page to WRITE the file out on our server. It actually builds an HTML file. This all works fine IF I put the URL in the browser and do it manually. However if i do it through the scheduler it runs, says it's been successful but never really updates the page. Are there any issues I am unaware of with Scheduler that would cause this? Are there any other ways to schedule? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc.
Rif, It is an MSAccess db. Paul -Original Message- From: Rif Kiamil [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 12:01 PM To: CF-Talk Subject: RE: SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc. What type of database u using ? Rif -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 16:25 To: CF-Talk Subject: SQL LIKE statement: LIKE '%a'; LIKE '%b'; LIKE '%c', etc. I am trying to get a db output where a user selects an alphabetical range in a form and then the sql selects all users in a db whose last names start with one of the letters in that range. For example, on a form page the user selects a range of a-f. I need to find all users whose last names start with a letter in that range and output the results. I think I recall a simple way to do this, but right now can't think of it. Could anyone jog my memory for me? Thanks, Paul Sinclair ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Server parsing .js files...
I have a single javascript file (*.js) that I want to include CF variables with. I know how to set IIS up to allow CF Server to process a specific file extension, but I don't neccessarily want it to process all .js files. My question is Is there any command I can use to only process the single file or if I want CF Server to process one, it has to do them all? CF_ProcessThisJSFileOnly ..js file contents. /CF_ProcessThisJSFileOnly Anything like that? I know I'm reaching here and am pretty positive I can't do this, but I thought I'd ask anyway... Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Server parsing .js files...
I believe that if you cfinclude the .js file, CF automatically parses it, even though it isn't a .cfm file. In other words, cfinclude template="myjsfile.js" will process 'myjsfile.js' as if it were a .cfm file. Jason - Original Message - From: "Steve Reich" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 10:16 AM Subject: CF Server parsing .js files... I have a single javascript file (*.js) that I want to include CF variables with. I know how to set IIS up to allow CF Server to process a specific file extension, but I don't neccessarily want it to process all .js files. My question is Is there any command I can use to only process the single file or if I want CF Server to process one, it has to do them all? CF_ProcessThisJSFileOnly ..js file contents. /CF_ProcessThisJSFileOnly Anything like that? I know I'm reaching here and am pretty positive I can't do this, but I thought I'd ask anyway... Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Server parsing .js files...
The only way I can think of would be to wrap it in a CFINCLUDE inside a .cfm page. Dave - Original Message - From: "Steve Reich" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 1:16 PM Subject: CF Server parsing .js files... I have a single javascript file (*.js) that I want to include CF variables with. I know how to set IIS up to allow CF Server to process a specific file extension, but I don't neccessarily want it to process all .js files. My question is Is there any command I can use to only process the single file or if I want CF Server to process one, it has to do them all? CF_ProcessThisJSFileOnly ...js file contents. /CF_ProcessThisJSFileOnly Anything like that? I know I'm reaching here and am pretty positive I can't do this, but I thought I'd ask anyway... Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Urgent - load: class allire.controls.cfGridFormApplet error
Guys; I have a cfgrid that works excellent on my dev machine, but as soon as I try and look at it on another machine, I get the following error on the status line. Any instant help on this would be great. "load: class allaire.controls.cfGridFormApplet not found" Thanks Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Breaking Datasource Connection
I know, I know - this has been asked a trillion times. I need to upload a brand new copy of the access database, but 'its in use by another processs' so of course the upload fails. How do I break the connection so I can upload the updated database? Thanks. Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Breaking Datasource Connection
Query a table that doesn't exist. It will unlock the database: CFQUERY DATASOURCE="#DSN#" SELECT * FROM FourScoreAndSevenYearsAgo /CFQUERY That'll do it. --Ben At 10:09 AM 4/6/01, you wrote: I know, I know - this has been asked a trillion times. I need to upload a brand new copy of the access database, but 'its in use by another processs' so of course the upload fails. How do I break the connection so I can upload the updated database? Thanks. Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Urgent - load: class allire.controls.cfGridFormApplet error
I have a cfgrid that works excellent on my dev machine, but as soon as I try and look at it on another machine, I get the following error on the status line. Any instant help on this would be great. "load: class allaire.controls.cfGridFormApplet not found" Make sure that the CFIDE directory is available for that virtual server. You should be able to go to this URL: http://www.yourservernamehere.com/cfide/ If you receive a 404 error, you don't have the necessary mapping. As for why it works with your dev machine, once the applets have been installed using the IE CAB file, they'll work whether the mapping exists or not. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Breaking Datasource Connection
Write a query to that Datasource that is bad - I.E. a non existant table. Then as soon as you run that script, begin you upload before something else grabs the database. Dave - Original Message - From: "Erika Foster" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 11:09 AM Subject: Breaking Datasource Connection I know, I know - this has been asked a trillion times. I need to upload a brand new copy of the access database, but 'its in use by another processs' so of course the upload fails. How do I break the connection so I can upload the updated database? Thanks. Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: import 100 users into NT 4.0?
Is there any way to import 100 users into NT 4.0 rather then hand type them in? Yes, you can use the addusers.exe utility from the NT Resource Kit. It accepts comma-delimited files. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: import 100 users into NT 4.0?
Not sure if you can do this in your enviro but Ive brought up new servers as BDC, then sync to the PDC for account info. Then promote your BDC to a PDC. Another method would be to use the addusers.exe, do a search in MSKB on this, its a Resource Kit program. Hope it helps, Adrian -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 9:35 AM To: CF-Talk Subject: OT: import 100 users into NT 4.0? Is there any way to import 100 users into NT 4.0 rather then hand type them in? Thanks Chad ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Breaking Datasource Connection
I write a simple template to run when needed like so: cfquery name="killdb" datasource="DSN_NAme" SELECT * FROM CRAP /cfquery Since I have no table in my DSN called crap it returns an error which breaks the connection Save the file in a hard to find directory under your domain so that someone else doesn't run it on you. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: Erika Foster [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 10:10 AM To: CF-Talk Subject: Breaking Datasource Connection I know, I know - this has been asked a trillion times. I need to upload a brand new copy of the access database, but 'its in use by another processs' so of course the upload fails. How do I break the connection so I can upload the updated database? Thanks. Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Breaking Datasource Connection
Two ways come to mind.. (http://cfhub.com/faq/access_lock.cfm) cfquery datasource="YourODBCDataSource" Select BadData FROM UnknownTable /cfquery !---Seriously OverKill last resort... you get the picture--- cfset CFUSION_DBCONNECTIONS_FLUSH() ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Breaking Datasource Connection
Before doing this, you will need to make sure no one else would be attempting to write data to the database. Just do a simply Query that causes an error with the database. CFQUERY NAME="KILLLDB" DATASOURCE="#application.DSN#" Select * From NOTABLE /CFQUERY Make sure that this Datasource is correct and the table name you specify in the query does NOT exist. This will kill the LDB locking file. -Original Message- From: Erika Foster [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 11:10 AM To: CF-Talk Subject: Breaking Datasource Connection I know, I know - this has been asked a trillion times. I need to upload a brand new copy of the access database, but 'its in use by another processs' so of course the upload fails. How do I break the connection so I can upload the updated database? Thanks. Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Server parsing .js files...
On 6 Apr 2001, at 13:16, Steve Reich wrote: I have a single javascript file (*.js) that I want to include CF variables with. I know how to set IIS up to allow CF Server to process a specific file extension, but I don't neccessarily want it to process all .js files. Why not leave the file as a .cfm file but put CFCONTENT TYPE="application/x-javascript" at the top? Keith C. Ivey [EMAIL PROTECTED] Webmaster, EEI Communications 66 Canal Center Plaza, Suite 200 Alexandria, VA 22314 Telephone: 703-683-0683 Fax: 703-683-4915 Web Site: http://www.eeicommunications.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hosting recommendations [KILL]
Bang! Bang! Bang! Bang! Bang! Bang! Bang! Bang! Bang! Bang! "He's dead, Jim!" - Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 9:49 AM To: CF-Talk Subject: Re: Hosting recommendations [KILL] Please kill this thread or take it to CF-Community. Thanks, Bill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Recommended JSP IDE on linux?
Hi all, I am leaving the CF world for a while to do a JSP project over the summer. It will be on linux. The company has Visual Age, but say I can use any IDE I want. I have read that Visual Age does not have great JSP support. Does anyone have a good recommendation? Thanks James Milks Noncubicle Corporation www.noncubicle.com [EMAIL PROTECTED] (613) 560-9855 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hosting recommendations
Just FYI, 99.7% uptime means that there is over 26 hours of down time each year. Cheers! - Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 8:52 AM To: CF-Talk Subject: Re: Hosting recommendations Since my last flaming for posting about my service. I have tried to resist, but I have to take offense to the statement of being down more then the average ISP. As with all we are at the mercy of the internet in general, but we strive to keep our uptime at 99.7% or greater and have the numbers and stats to prove it. I constantly have my servers and sites monitored from 3 diverse links inbound and would be happy to look into any specific incidents people have had. Sorry for the post, but when someone strikes a cord, I will take the abuse from the flamers. Thanks, Robert - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 8:40 AM Subject: Re: Hosting recommendations Two things to consider before picking ATSWEBNET: Bandwidth Reliability It might just be me, but it seems they are down more than the average ISP. Good luck, Allison McMearty ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
HTML Email Detection
I want to send HTML enabled email with CFMAIL but I wan't to filter on whether the clients email browser accepts HTML email. Is there a way to do this with CF? I don't think there is. What about on the client side could they trigger an event with JS or VBS when they open the mail that detects whether or not their email browser can render HTML? Thanks for the help. Kevin Schmidt, Web Technology Manager Allaire Certified ColdFusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Grouping Problem
I'm sure at least one of you people have had this problem, and i'm pulling my hair out of here I have a field which has a date/time value. ie : 4/3/2001 12:00:00 PM now there are tons of records for each day, but with different times. I am trying to output a list of the past 10 days. Grouped by the Day only, not the time. I've tried to actually format the date field in my [group] functions in the cfoutput like this... cfoutput query="information" group="DateFormat("#information.Date#", "m/d/")#" but this gives me an error saying that the information in the query does not match within the loop Can someone help me on this one? I feel as though there is a really simple answer, though i am clearly not seeing it Thanks. Kevin ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Recommended JSP IDE on linux?
try out JBuilder 4. I hear it is really good. -- Original Message -- From: "James Milks" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 06 Apr 2001 14:54:37 -0400 Hi all, I am leaving the CF world for a while to do a JSP project over the summer. It will be on linux. The company has Visual Age, but say I can use any IDE I want. I have read that Visual Age does not have great JSP support. Does anyone have a good recommendation? Thanks James Milks Noncubicle Corporation www.noncubicle.com [EMAIL PROTECTED] (613) 560-9855 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HTML Email Detection
First thought would be to ask that question on your form. If 'yes' then create the HTML enabled version, else create Plain Text. Steven Semrau SRA International, Inc. Senior Member, Professional Staff [EMAIL PROTECTED] [EMAIL PROTECTED] Com: (703) 805-1095 DSN: (703) 655-1095 -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 4:10 PM To: CF-Talk Subject: HTML Email Detection I want to send HTML enabled email with CFMAIL but I wan't to filter on whether the clients email browser accepts HTML email. Is there a way to do this with CF? I don't think there is. What about on the client side could they trigger an event with JS or VBS when they open the mail that detects whether or not their email browser can render HTML? Thanks for the help. Kevin Schmidt, Web Technology Manager Allaire Certified ColdFusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Grouping Problem
I do this by using a SQL query like SELECT datefield as X, information as Y FROM table ORDER by datefield cfoutput query="X"#X#, #Y#/cfoutput Contact me offlist and I can help further. Robert - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 3:06 PM Subject: Grouping Problem I'm sure at least one of you people have had this problem, and i'm pulling my hair out of here I have a field which has a date/time value. ie : 4/3/2001 12:00:00 PM now there are tons of records for each day, but with different times. I am trying to output a list of the past 10 days. Grouped by the Day only, not the time. I've tried to actually format the date field in my [group] functions in the cfoutput like this... cfoutput query="information" group="DateFormat("#information.Date#", "m/d/")#" but this gives me an error saying that the information in the query does not match within the loop Can someone help me on this one? I feel as though there is a really simple answer, though i am clearly not seeing it Thanks. Kevin ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HTML Email Detection
Don't think so. There have been threads on this in the past. Some people figure they can parse headers and stuff, but that is messy at best. In my opinion, if the big sites still ask you to specify when joining a mailing list, there isn't a good way of doing it, or they would have . James -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 4:10 PM To: CF-Talk Subject: HTML Email Detection I want to send HTML enabled email with CFMAIL but I wan't to filter on whether the clients email browser accepts HTML email. Is there a way to do this with CF? I don't think there is. What about on the client side could they trigger an event with JS or VBS when they open the mail that detects whether or not their email browser can render HTML? Thanks for the help. Kevin Schmidt, Web Technology Manager Allaire Certified ColdFusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTML Email Detection
This operation is basically the same as when you detect a client's web browser. Most modern email clients send a header (X-Mailer) indicating the email client type. Here's an example: X-Mailer: Microsoft Outlook Express 5.50.4133.2400 So, there are several caveats: 1 - you must have already received an email from the intended recipient 2 - you must have already parsed out the X-Mailer header 3 - you need a list of the capabilities of each type of mail client One way to attempt to satisfy most email clients (most but definitely not all) is to send the mail in both formats within the same MIME-encoded email message. Or - you can do this the old-fashioned way - ask the user what format they wish to receive mail in and keep a database of their preferences. 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: "Kevin Schmidt" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 4:09 PM Subject: HTML Email Detection I want to send HTML enabled email with CFMAIL but I wan't to filter on whether the clients email browser accepts HTML email. Is there a way to do this with CF? I don't think there is. What about on the client side could they trigger an event with JS or VBS when they open the mail that detects whether or not their email browser can render HTML? Thanks for the help. Kevin Schmidt, Web Technology Manager Allaire Certified ColdFusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Recommended JSP IDE on linux?
Check out Kawa from Allaire. I don't think it runs on Linux but then again, your server may be the only thing that needs to run Linux. Rey Bango... - Original Message - From: "James Milks" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 2:54 PM Subject: OT: Recommended JSP IDE on linux? Hi all, I am leaving the CF world for a while to do a JSP project over the summer. It will be on linux. The company has Visual Age, but say I can use any IDE I want. I have read that Visual Age does not have great JSP support. Does anyone have a good recommendation? Thanks James Milks Noncubicle Corporation www.noncubicle.com [EMAIL PROTECTED] (613) 560-9855 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [HTML Email Detection]
Only way I can think that there could be come client detection is if the client supported HTML because otherwise it is not going to run any scripts at all. Only way to really do it is to ask the client which type they can/would prefer to receive. "Kevin Schmidt" [EMAIL PROTECTED] wrote: I want to send HTML enabled email with CFMAIL but I wan't to filter on whether the clients email browser accepts HTML email. Is there a way to do this with CF? I don't think there is. What about on the client side could they trigger an event with JS or VBS when they open the mail that detects whether or not their email browser can render HTML? Thanks for the help. Kevin Schmidt, Web Technology Manager Allaire Certified ColdFusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Hosting recommendations [KILL]
Nice shoo-in TeX! I use Atswebnet and am more than happy with their service. However, it kills me that that I have to wade thru 50 messages ever week about plugs for ISPs. And call me cynical, but I would not be surprised if the ISP posts the initial message asking for the recommendation ... so they can plug away. So be it. But please, why not use CF-Community where it will detract from Mad Cow Disease and Lords of the Ring and not from technical discussion held here. Moderator ... hello Sorry for the OT, Bill In a message dated 4/6/01 3:08:44 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: Bang! Bang! Bang! Bang! Bang! Bang! Bang! Bang! Bang! Bang! "He's dead, Jim!" ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Grouping Problem
You might be better served by doing something like this CFQUERY Name="queryName" SELECT DATEPART(day, DateColumn) AS 'GroupDate', DateColumn, OtherColumns ORDER BY DateColumn /CFQUERY CFOUTPUT Query="queryName" Group="GroupDate" #GroupDate# CFOUTPUT #OtherColumns# /CFOUTPUT /CFOUTPUT -- Chris Stoner -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 3:07 PM To: CF-Talk Subject: Grouping Problem I'm sure at least one of you people have had this problem, and i'm pulling my hair out of here I have a field which has a date/time value. ie : 4/3/2001 12:00:00 PM now there are tons of records for each day, but with different times. I am trying to output a list of the past 10 days. Grouped by the Day only, not the time. I've tried to actually format the date field in my [group] functions in the cfoutput like this... cfoutput query="information" group="DateFormat("#information.Date#", "m/d/")#" but this gives me an error saying that the information in the query does not match within the loop Can someone help me on this one? I feel as though there is a really simple answer, though i am clearly not seeing it Thanks. Kevin ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Grouping Problem
You'll need to have a computed column in your query which contains only the day value. In MS-SQL, you could use CONVERT(varchar(8),date,2) AS theDay Then you can use "theDay" as your group column. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 2:07 PM To: CF-Talk Subject: Grouping Problem I'm sure at least one of you people have had this problem, and i'm pulling my hair out of here I have a field which has a date/time value. ie : 4/3/2001 12:00:00 PM now there are tons of records for each day, but with different times. I am trying to output a list of the past 10 days. Grouped by the Day only, not the time. I've tried to actually format the date field in my [group] functions in the cfoutput like this... cfoutput query="information" group="DateFormat("#information.Date#", "m/d/")#" but this gives me an error saying that the information in the query does not match within the loop Can someone help me on this one? I feel as though there is a really simple answer, though i am clearly not seeing it Thanks. Kevin ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTML Email Detection
Well, maybe it's not quite the same, but I sort of took care of it on the back end. In my database, I placed a yes/no field to check if they had html email, the default setting was 'no', so any new person added to the database was automatically sent a 'welcome' mail when they were added letting them know that they've been added to a amiling list, and they will be recieving text based email newsletters. If the user has the ability to view html formatted emails, they simply click on a link which takes them to a page that switches that yes/no to 'yes', then generates a html confirmation email. That way it's all fairly automatic, and you don't have to do anything... Sound like it might work? on 4/6/01 4:09 PM, Kevin Schmidt at [EMAIL PROTECTED] wrote: I want to send HTML enabled email with CFMAIL but I wan't to filter on whether the clients email browser accepts HTML email. Is there a way to do this with CF? I don't think there is. What about on the client side could they trigger an event with JS or VBS when they open the mail that detects whether or not their email browser can render HTML? Thanks for the help. Kevin Schmidt, Web Technology Manager Allaire Certified ColdFusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTML Email Detection
Hi, There is no guarentee that the users email supports html even if their brower does. Lanny Udey Hofstra University [EMAIL PROTECTED] Friday, April 06, 2001 I want to send HTML enabled email with CFMAIL but I wan't to filter on whether the clients email browser accepts HTML email. Is there a way to do this with CF? I don't think there is. What about on the client side could they trigger an event with JS or VBS when they open the mail that detects whether or not their email browser can render HTML? Thanks for the help. Kevin Schmidt, Web Technology Manager Allaire Certified ColdFusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hosting recommendations
This reminds me of the time I developed a big CF website for this Head Hunter startup, worked day and night for a month to get it up on time (before Fusebox), and gave them a good development price thinking of long term hosting. After 3 months they moved it to another hosting company. One of the reasons they gave for moving was the new hosting company gave them a guarantee of 99% uptime. 2 days later (I'm slow) the meaning of 99% hit me and I called and thanked them for a great marketing scam (although I never used it). I told them 99% uptime was an average of 14.4 minutes downtime each day, and (1) I would consider such a server unstable, and (2) None of our servers had ever been down that much. best, paul At 03:00 PM 4/6/01 -0400, you wrote: Just FYI, 99.7% uptime means that there is over 26 hours of down time each year. Cheers! - Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTML Email Detection
All I have is a comma delimited list of email addresses from the client. - Original Message - From: "Semrau, Steven L Mr SRA" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 2:23 PM Subject: RE: HTML Email Detection First thought would be to ask that question on your form. If 'yes' then create the HTML enabled version, else create Plain Text. Steven Semrau SRA International, Inc. Senior Member, Professional Staff [EMAIL PROTECTED] [EMAIL PROTECTED] Com: (703) 805-1095 DSN: (703) 655-1095 -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 4:10 PM To: CF-Talk Subject: HTML Email Detection I want to send HTML enabled email with CFMAIL but I wan't to filter on whether the clients email browser accepts HTML email. Is there a way to do this with CF? I don't think there is. What about on the client side could they trigger an event with JS or VBS when they open the mail that detects whether or not their email browser can render HTML? Thanks for the help. Kevin Schmidt, Web Technology Manager Allaire Certified ColdFusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Bug in rereplace() function
Hi, I wanted to alert everyone that there is a bug (confirmed) in the rereplace() fuction in CF 5.0 AND also in 4.5.1 SP2. This bug caused us much greif in that it generated pcode errors and crashed our servers frequently. It seems to occur primarily when you are parsing large blocks in content with the ALL parameter. We were using it in a RemoveWhiteSpace tag removing whitespace from Spectra pages. The following are the bug report numbers for CF 5.0. "The rereplace( ) function has a known bug reported in bug #23110 and as a duplicate bug #23071" Once we stopped using this all our problems have cleared up. Currently there is not hotfix for it. Lanny Udey Associate Dean Learning and Information Technology Hofstra University ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HTML Email Detection
How do you send more than one format with mime encoded? Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 3:36 PM To: CF-Talk Subject: Re: HTML Email Detection This operation is basically the same as when you detect a client's web browser. Most modern email clients send a header (X-Mailer) indicating the email client type. Here's an example: X-Mailer: Microsoft Outlook Express 5.50.4133.2400 So, there are several caveats: 1 - you must have already received an email from the intended recipient 2 - you must have already parsed out the X-Mailer header 3 - you need a list of the capabilities of each type of mail client One way to attempt to satisfy most email clients (most but definitely not all) is to send the mail in both formats within the same MIME-encoded email message. Or - you can do this the old-fashioned way - ask the user what format they wish to receive mail in and keep a database of their preferences. 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: "Kevin Schmidt" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 4:09 PM Subject: HTML Email Detection I want to send HTML enabled email with CFMAIL but I wan't to filter on whether the clients email browser accepts HTML email. Is there a way to do this with CF? I don't think there is. What about on the client side could they trigger an event with JS or VBS when they open the mail that detects whether or not their email browser can render HTML? Thanks for the help. Kevin Schmidt, Web Technology Manager Allaire Certified ColdFusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Recommended JSP IDE on linux?
It is my understanding that Kawa is a visual tool for beans and servlets. Jrun Studio is the bells and whistles Allaire JSP editor, but sadly, they have no intention at this time of porting any visual tools to Linux. James -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 3:38 PM To: CF-Talk Subject: Re: Recommended JSP IDE on linux? Check out Kawa from Allaire. I don't think it runs on Linux but then again, your server may be the only thing that needs to run Linux. Rey Bango... - Original Message - From: "James Milks" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 2:54 PM Subject: OT: Recommended JSP IDE on linux? Hi all, I am leaving the CF world for a while to do a JSP project over the summer. It will be on linux. The company has Visual Age, but say I can use any IDE I want. I have read that Visual Age does not have great JSP support. Does anyone have a good recommendation? Thanks James Milks Noncubicle Corporation www.noncubicle.com [EMAIL PROTECTED] (613) 560-9855 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists