Re: How well does CF run with mySQL?
How well does CF run with mySQL? Is it better to go with SQL7 or Oracle 8i? I am doing a prototype app with Access but now need to port to a stronger database program. Any suggestions? I understand Cold Fusion 4.5 still does not have direct native support for mySQL, true or false? Thanks for your help. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Oracle 8i and WebDB
Does anyone know what WebDB is all about? Is it the visual equivalent of Cold Fusion Enterprise and the Cold Fusion Studio? Anyone have any good working experience with that tool, would appreciate any working experience feedback. Thanks in advance, Pardee. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Can CF be run on a Cobalt RAQ 3?
Can a Linux version of Cold Fusion be run on a Cobalt RAQ 3 (512 megs of RAM)? Is it advisable? Are there advantages going this route vs. an NT machine? Thanks for your help. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: javaScripts And ColdFusion
shai pete, :~~ : From: Pete Freitag [EMAIL PROTECTED] : : You would have to use javascript to post the information : to another page, you could do this with a hidden frame, : or an iFrame so the use wouldn't notice it. : : script : hiddenfrm.document.location = "logmyvars.cfm?colorDepth=" + : window.screen.colorDepth "whatever=" + whatever; : /script :~~ or you could call a cf template in an IMG tag too. SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript" !-- var tracker = 'colordepth=' + screen.colordepth + 'height=' + screen.height; document.write('IMG SRC="tracker.cfm?' + stats + '" HEIGHT="1" WIDTH="1" BORDER="0"'); // -- /SCRIPT good luck, .jeff name://jeff.howden game://web.development http://www.evolt.org/ mailto:[EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
really slow website
I have just added another site to my server (running IIS4 on NT4) and for some strange reason this site takes ages to load. The site is just basic html pages, NO CF yet, not even large graphics. I have deleted it, re-made it, used different IP's, ports, swapped a working site with this ones home directory, nothing I try will get this site to behave correctly. The server is not under any stress, there are 10 odd sites, most of which have minimal traffic, I even tried shutting some of them down to see if it made a difference. Yet viewed from any other server it works fine. Here is a temporary URL on the live serrver, see how slow it is. http://212.36.131.132:8080 here it is redirected to my development machine, and it loads fine: www.9to5cafe.com Any light that you can shed on this would be great. Satachi Internet Development -- Tel/Fax: 0870 787 3610 Mobile: 07050 648684 http://www.satachi.com email: [EMAIL PROTECTED] -- To join the Satachi-news mailing list send a blank e-mail to mailto:[EMAIL PROTECTED][EMAIL PROTECTED] or visit http://www.satachi.listbot.comsatachi.listbot.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Session Variables
Use an application.cfm file on both virtual sites, with the same name in the cfapplication tag and the variables will be visible to both. Maybe not the most elegant solution, but it works. DC - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 11, 2000 05:02 Subject: Session Variables Is there a way to pass a session variable from one domain name to another when on the same physical server? I have a session variable that is made via the QueryNew function and need to use the info contained in that variable on a processing page that my user gets to via a form. The processing page however is on a different domain name. Currently the best solution I can come up with would be to insert the information into the db and then pull/view it from my processing page. Please cc me on any replies. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Stock ticker
if the owner of the content does not specifically allow syndication, then it's theft! -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Monday, April 10, 2000 4:13 PM To: [EMAIL PROTECTED] Subject: RE: Stock ticker Also illegal if it grabs from yahoo or something. Why is this illegal? I didn't write the tag, but I just wondered. Are all tags that syndicate content via CFHTTP illegal (ie. accuweather, Dilbert, etc...)?? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Stock ticker
Yahoo PAYED for their stock market feed. By stealing the content from their site, you're taking money from both their pockets, and whoever they get their feed from.. -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Monday, April 10, 2000 4:30 PM To: [EMAIL PROTECTED] Subject: RE: Stock ticker Yes, but in the case of Stock Quotes, they are not Yahoo's content. Yahoo is syndicating this information from the stock market. I understand the line of thinking here, but I just want to play devil's advocate for a minute. Who owns the rights to stock market quotes? In the end, all sights are syndicating the data. If I pulled Yahoo's financial forecast for the future of a particular stock, I could see how that might be an infringement, but just the latest stock prices? I'd be interested in the legal argument here... -Original Message- From: Raymond K. Camden [mailto:[EMAIL PROTECTED]] Sent: Monday, April 10, 2000 4:21 PM To: [EMAIL PROTECTED] Subject: RE: Stock ticker I would assume that any tag that takes content and repurposes for another web site w/o permission of the original web site would be illegal. Of course, this reminds of the conversation about discovering someone stealing your graphics by using IMG SRC="http://www.yourserver.com" and replacing the graphic with something a bit embarassing. You could do the same thing here if you find that someone is syndicating your content w/o your approval. CF_Disclaimer Of course, I'm not a lawyer. /CF_Disclaimer === Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com) Allaire Certified Instructor and Member of Team Allaire Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Monday, April 10, 2000 4:13 PM To: [EMAIL PROTECTED] Subject: RE: Stock ticker Also illegal if it grabs from yahoo or something. Why is this illegal? I didn't write the tag, but I just wondered. Are all tags that syndicate content via CFHTTP illegal (ie. accuweather, Dilbert, etc...)?? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: WDDX , prefilling forms
Justin, That's me. Here's the URL: http://www.oacfug.org/users/dswitzer/forms/ -Dan ++---+ | name | Dan G. Switzer, II| |company | PengoWorks.com| |www | http://www.pengoworks.com | | mailto | [EMAIL PROTECTED] | ++---+ -Original Message- From: Justin MacCarthy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 6:42 AM To: [EMAIL PROTECTED] Subject: WDDX , prefilling forms Hi people, a vague question I remember someone on the list has done a tag, which allows users to go forward / back in a series of forms, by saving the contents in a wddx packet, I think it is on one of the CFUG sites ... Can anyone point me in the right direction??? TIA ~Justin -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Oracle 8i and WebDB
WebDB is an Oracle product. We are just starting to evaluate it here - so far it seems to be good for oracle table creation and rapid prototyping but we already know we won't be switching from coldfusion as my boss thought last month. it will probably have certain uses for us, but oracle also has a m$$ type licensing scheme stuck to it regarding having a license for each end user of an ap built with it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 3:17 AM To: [EMAIL PROTECTED] Subject: Re: Oracle 8i and WebDB Does anyone know what WebDB is all about? Is it the visual equivalent of Cold Fusion Enterprise and the Cold Fusion Studio? Anyone have any good working experience with that tool, would appreciate any working experience feedback. Thanks in advance, Pardee. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: really slow website
On 4/11/00, Russ Michaels penned: Here is a temporary URL on the live serrver, see how slow it is. http://212.36.131.132:8080 here it is redirected to my development machine, and it loads fine: www.9to5cafe.com Any light that you can shed on this would be great. Dismal. I take it this is your own server? Do the other sites load OK? I don't know if and/or why this would make a difference, but the image shim.gif which is called several times doesn't appear to be on the server. Could IIS be taking an inordinate amount of time trying to find it? Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: really slow website
Check your graphic http://212.36.131.132:8080/shim.gif this image ends in error. Your server is having problems serving this image. Note: the background html code is different on each domain. try posting the www.9to5cafe.com html code on your live server david -Original Message- From: Russ Michaels [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 5:19 AM To: [EMAIL PROTECTED] Subject: really slow website I have just added another site to my server (running IIS4 on NT4) and for some strange reason this site takes ages to load. The site is just basic html pages, NO CF yet, not even large graphics. I have deleted it, re-made it, used different IP's, ports, swapped a working site with this ones home directory, nothing I try will get this site to behave correctly. The server is not under any stress, there are 10 odd sites, most of which have minimal traffic, I even tried shutting some of them down to see if it made a difference. Yet viewed from any other server it works fine. Here is a temporary URL on the live serrver, see how slow it is. http://212.36.131.132:8080 here it is redirected to my development machine, and it loads fine: www.9to5cafe.com Any light that you can shed on this would be great. Satachi Internet Development -- Tel/Fax: 0870 787 3610 Mobile: 07050 648684 http://www.satachi.com email: [EMAIL PROTECTED] -- To join the Satachi-news mailing list send a blank e-mail to mailto:[EMAIL PROTECTED][EMAIL PROTECTED] or visit http://www.satachi.listbot.comsatachi.listbot.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
pre-selecting items in a multiple list box
I'm using a CF template that attempts to pre-select several items in a list box based on values returned from 2 queries. If a match occurs, that entry in the list box should be selected. There will almost always be more than one match. Specifically, the list box should list all possible delivery locations (from the get_del_locn query) and highlight/pre-select those locations that a user has a record returned for in get_usr_del_locn. What the code below produces *almost* works - all possible delivery locations are in the list box, but only *one* of the user's specific locations is selected even though they might have 4 or 5 locations tied to their usr_id. So... Why doesn't this code work? !--- get a user's specific delivery locations --- cfquery datasource="centsup_dev" name="get_user_del_locn" debug="yes" select user_del.dlo_id from del_locn, user_del where del_locn.dlo_id = user_del.dlo_id and user_del.usr_id = #usr_id# /cfquery !--- get all possible delivery locations --- cfquery datasource="centsup_dev" name="get_del_locn" debug="yes" select dlo_id, dlo_locn from del_locn order by dlo_locn /cfquery !--- create the list box; attempt to pre-select user's location(s) --- select name="dlo_id" size =5 width=150 multiple cfoutput query="get_del_locn" cfif #get_user_del_locn.dlo_id# is #get_del_locn.dlo_id# option value=#get_del_locn.dlo_id# selected#get_del_locn.dlo_locn# cfelse option value=#get_del_locn.dlo_id##get_del_locn.dlo_locn# /cfif /cfoutput /select Ricq Pattay [EMAIL PROTECTED] Univ of MN College of Veterinary Medicine -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: About changing the oldest one
Supposing that there are no problems with the code itself... Why don't you use CreateODBCDateTime instead of CreateODBCDate in your code? At least in that way you will store date information with greater detail... if the DB is prepared to accept a date/time object for that field. Also... i had lots of problems once because i used "Date" as the name for one of my fields in a table. I would recommend you to change it. It could be reserved and/or confuse the database manager. Francisco J. Montes-Mantero Web Developer QSP Financial Information Systems [EMAIL PROTECTED] ICQ: 23816813 - Original Message - From: "Juan Manuel Tapiola" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 11, 2000 2:12 PM Subject: About changing the oldest one Hello, I have a database composed of 4 items per category which I want to replace from the oldest one with new products. I do this instruction then: !--- I FIND THE OLDEST ITEM --- CFQUERY DATASOURCE="principal" QUERY="oldest" SELECT MIN(date) AS oldest FROM recomendadas WHERE category = #form.category# /CFQUERY !--- I REPLACE --- CFQUERY DATASOURCE="principal" UPDATE recomendadas SET cod = #form.cod# titulo = #form.titulo# WHERE category = #form.category# CFOUTPUT QUERY="oldest" AND date = #createODBCdate(oldest)# /CFOUTPUT /CFQUERY The problem with this is that it just replaces the item if it is 2 days old. What should I do if I just want to replace the oldest one, no matter if it is older by a minute? As an additional data, I made a DB with one minute difference between items an isolates perfectly the oldest item with this function: CreateODBCdateTime(oldest) But I don't know why it does not do it in the above query. Could anybody help me in this? I appretiate it a lot Manuel Tapiola www.ciudadvideo.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: DISPLAY QUESTION
snip however, the looping seems to be more accurate. when i specify 400, for instance, the looping returns 399 words while the other way returns just 370. i'm not sure why that is (btw, i just took the resultant output and did a word count on them in word) but you should be aware of it. ...just thought it was interesting -emily That is interesting indeed. Thanks for the research! - Sean Sean Daniels Manager, Engineering DealStream.com [EMAIL PROTECTED] http://www.dealstream.com tel: 207.439.6030 cel: 978.764.0779 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: how well does CF run with mySQL
How well does CF run with mySQL? Is it better to go with SQL7 or Oracle 8i? I use mySQL and SQL Server 7 with Cold Fusion 4 on NT and they both run fine. The thing you need to be aware about mySQL is that it does not enforce Foreign Keys. This means you cannot have the database itself enforce data integrity. For example, you might have a person table and a phone table like so: Person Table PersonID Name Age Phone Table PhoneTypeID ( work, home, day, night, mobile ) PersonID Number In SQL Server, Oracle and other relational databases, you can have it setup so that you cannot insert a PersonID into the Phone table unless it exists in the Person Table. In mySQL, there is no way to enforce this except by first checking the Person table with your application, then inserting into the Phone table. mySQL also does not have stored procedures. But mySQL is very, very *fast* because it is missing these features. It was made this way on purpose. There are some surprisingly large sites that use mySQL, none of which I can remember at the moment. I know several start ups that are using mySQL and are very happy. Eventually they'll make the move to SQL Server or Oracle, but for now mySQL does the job well. Roy. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Slightly OT: DHTML and z-index
Can anyone tell me how I can make a div go ontop of a form element using z-indexs. I don't seem to be able to do this. Cheers Mark [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Date: Tue, 11 Apr 2000 09:46:39 -0400
WebDB is a framework of Oracle Packages written in PL/SQL which allows for the construction of web-based applications using your existing Oracle DB's and PL/SQL Packages that you create. It can supposedly leverage Java code stored in the Oracle DB and run via the internal JVM. As stated before, it seems best for quick prototyping of query/report apps but, does not provide anywhere near the available functionality in CF/ASP/JSP. Also, it only works with Oracle. To make full use of the product you need to have a development team that knows how to "program" in PL/SQL. Steve -Original Message- From: Janssen Dolores Y (Contractor) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 8:34 AM To: '[EMAIL PROTECTED]' Subject: RE: Oracle 8i and WebDB WebDB is an Oracle product. We are just starting to evaluate it here - so far it seems to be good for oracle table creation and rapid prototyping but we already know we won't be switching from coldfusion as my boss thought last month. it will probably have certain uses for us, but oracle also has a m$$ type licensing scheme stuck to it regarding having a license for each end user of an ap built with it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 3:17 AM To: [EMAIL PROTECTED] Subject: Re: Oracle 8i and WebDB Does anyone know what WebDB is all about? Is it the visual equivalent of Cold Fusion Enterprise and the Cold Fusion Studio? Anyone have any good working experience with that tool, would appreciate any working experience feedback. Thanks in advance, Pardee. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Determining Efficency.
A great way to determine the actual efficiency of a piece of code is to put it in a loop. Looping over the code multiple times makes the actual numbers more meaningful by ruling out time associated with connections and CF administrative overhead. Specific things to look for include using CFSWITCH for anything more than 3 comparisons, using CFSCRIPT for multiple cfsets (but not loops or comparisons), caching queries and/or creating customized structures for commonly accessed information. More efficient code is more of an art than a series of recipes. Good luck! Sharon At 02:12 PM 4/11/2000 +0100, Ben Lowndes wrote: Hi, I'm trying to make some of my scripts as efficent as possible. The script contains quite a few conditions and nests down to about 4 levels in most places. I've tried swapping if-else statements for nested sitch-case. Then repeatedly running the same query a number of times. Watching the Execution time useing switch-case averages about 250milliseconds where as if-else averages about 270milliseconds. Is there a more "scientific" way of evaluating code efficeny and are there any resources with tips about writing the most efficent code? For example would it be better for me not to cfinclude pages if I'm more concerned about efficency than code reusability or readability?? Thanks Ben -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: cfmail question (sorry about no subject before)
is there any way for cfusion to detect failed email, and automatically remove that address from a database? from what I understand mail servers generally queue mails before sending them out, so they only error you can possible receive is a connection error if the mail server is down. We're facing similar problems here and I do believe we're going to handle it by mailing any failed mails to a user we create and parse those emails for errors. I believe you should do similar thing, parse the emails for bad users and delete from your database. Roy. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: pre-selecting items in a multiple list box
Hi Ricq Your code is comparing only the first value returned from the "get_user_del_locn" query with all the others from "get_del_locn" and thus... only one match can happen... if that. I didn't think much of a solution though but... how about building only one query that intersects user locations with all avaliable locations? That will give you a list of only the locations you really need. Francisco J. Montes-Mantero Web Developer QSP Financial Information Systems [EMAIL PROTECTED] (0191) 4023491 ICQ: 23816813 - Original Message - From: "Ricq Pattay" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 11, 2000 2:33 PM Subject: pre-selecting items in a multiple list box I'm using a CF template that attempts to pre-select several items in a list box based on values returned from 2 queries. If a match occurs, that entry in the list box should be selected. There will almost always be more than one match. Specifically, the list box should list all possible delivery locations (from the get_del_locn query) and highlight/pre-select those locations that a user has a record returned for in get_usr_del_locn. What the code below produces *almost* works - all possible delivery locations are in the list box, but only *one* of the user's specific locations is selected even though they might have 4 or 5 locations tied to their usr_id. So... Why doesn't this code work? !--- get a user's specific delivery locations --- cfquery datasource="centsup_dev" name="get_user_del_locn" debug="yes" select user_del.dlo_id from del_locn, user_del where del_locn.dlo_id = user_del.dlo_id and user_del.usr_id = #usr_id# /cfquery !--- get all possible delivery locations --- cfquery datasource="centsup_dev" name="get_del_locn" debug="yes" select dlo_id, dlo_locn from del_locn order by dlo_locn /cfquery !--- create the list box; attempt to pre-select user's location(s) --- select name="dlo_id" size =5 width=150 multiple cfoutput query="get_del_locn" cfif #get_user_del_locn.dlo_id# is #get_del_locn.dlo_id# option value=#get_del_locn.dlo_id# selected#get_del_locn.dlo_locn# cfelse option value=#get_del_locn.dlo_id##get_del_locn.dlo_locn# /cfif /cfoutput /select Ricq Pattay [EMAIL PROTECTED] Univ of MN College of Veterinary Medicine -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Integer?
Hopefully someone can shed some light on this. I've got a field where I'm looking for an integer. I then need to verify that this field is in an increment of 100: cfif form.myField Mod 100 It's not an increment of 100! /cfif Alrighty, that works fine, unless I enter a non-integer in the field (i.e. "01234567890", even though CFFORM validates this as an integer!) My first thought here is to use the Int() function to round this to the nearest integer: cfif Int(form.myField) Mod 100 It's not an increment of 100! /cfif BUT NO! This does not work as advertised. I'm still getting a "Cannot convert to integer" from the Mod operator. Is anyone out there dealing with validating a user's input as an integer? Suggestions? Jason Stiefel Applications Developer iXL, Inc. 1930 Camden Road, Suite 2070 Charlotte, NC 28203 tel. 704.943.7000 fax. 704.943.7001 [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: REM out CF codes
Use this: !--- cftag --- Notice the three dashes on each side (as opposed to the html comment tag which uses 2 dashes). Mike Murry Web Developer [EMAIL PROTECTED] 214.599.5290 -Original Message- From: Michel Gagnon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 8:43 AM To: [EMAIL PROTECTED] Subject: REM out CF codes This is a multi-part message in MIME format. --=_NextPart_000_00AB_01BFA3A2.C5C2F160 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi! Is there a way to temporarily REM out CF tags=20 so that the server doesn't execute them? --=_NextPart_000_00AB_01BFA3A2.C5C2F160 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi!/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Is there a way to temporarily REM out = CF tags=20 /FONT/DIV DIVFONT face=3DArial size=3D2so that the server doesn't execute=20 them?/FONT/DIV DIVnbsp;/DIV DIVnbsp;/DIV/BODY/HTML --=_NextPart_000_00AB_01BFA3A2.C5C2F160-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE:CF/Javascript
HI, I'm a cf newbie (about 3 months) and I was given the task of putting a link on the bottom of every page in a cf site to a) pull the url off the page they are on b) send the user and the url to a form to email that url to a friend. My first impulse was to use the onrequestend.cfm and use the cgi variable to pull the url off the page. The problem is that half the pages in the site are static html pages so the onrequestend.cfm won't work for the site. So now I think I need a way to do this in Javascript (pull the url off the page) and then send them and the url to the email form which will be a cf template. Any suggestions on how to do this (example code)? You really should ask the question on a javascript group, but here's the answer. Use the location object. A HREF="#" ONCLICK="self.location.href = 'emailform.cfm?MyURL=' + scape( location.href )"go to my email form/A There you go. Of course you still face the issue of no javascript on the person's browser. In that case you would print out the above in javascript too. This way people without javascript or who have it turned off won't even see the option. Of course if you're using something like IIS or Netscape, you can use the other server-side scripting available to you. Roy. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Slightly OT: DHTML and z-index
Mark, The odds are you can't. Netscape doesn't like to display any layers on top of the form fields. IE will place a layer on top of everything but an IFRAME or TEXTAREA box (I believe that's all, there may be others.) Supposedly IE v5.5 will fix the layer over IFRAMEs and form fields issue. Not sure how Netscape 6 will deal with it. It's definitely an annoying "feature." :) -Dan ++---+ | name | Dan G. Switzer, II| |company | PengoWorks.com| |www | http://www.pengoworks.com | | mailto | [EMAIL PROTECTED] | ++---+ -Original Message- From: Mark Jones [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 9:27 AM To: '[EMAIL PROTECTED]' Subject: Slightly OT: DHTML and z-index Can anyone tell me how I can make a div go ontop of a form element using z-indexs. I don't seem to be able to do this. Cheers Mark [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: REM out CF codes
!--- cf_tag --- That? Todd Ashworth Hi! Is there a way to temporarily REM out CF tags=20 so that the server doesn't execute them? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: REM out CF codes
Use the C/Java style "//" to comment a line in CFSCRIPT. -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 9:53 AM To: [EMAIL PROTECTED] Subject: Re: REM out CF codes similar to HTML remarks, however, they are slightly different !--- (opens a CF comment) --- (closes a Cf comment). Note the 3 dashes. Note that these style comments do not work in CFSCRIPT, unless you comment out the whole CFSCRIPT block. Dc - Original Message - From: Michel Gagnon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 11, 2000 13:43 Subject: REM out CF codes This is a multi-part message in MIME format. --=_NextPart_000_00AB_01BFA3A2.C5C2F160 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi! Is there a way to temporarily REM out CF tags=20 so that the server doesn't execute them? --=_NextPart_000_00AB_01BFA3A2.C5C2F160 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi!/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Is there a way to temporarily REM out = CF tags=20 /FONT/DIV DIVFONT face=3DArial size=3D2so that the server doesn't execute=20 them?/FONT/DIV DIVnbsp;/DIV DIVnbsp;/DIV/BODY/HTML --=_NextPart_000_00AB_01BFA3A2.C5C2F160-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Problem populating certain fields thru update template
This is a multi-part message in MIME format. --=_NextPart_000_0051_01BFA398.27FB4B80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I've made an update template which needs to be populated with data = previously entered into the database. However, fields referenced by the = following code are turning up empty: 1. TEXTAREA COLS=3D25 ROWS=3D4 NAME=3D"PartDescription" REQUIRED=3D"Yes" MESSAGE=3D"Please enter a description of the part = you require" VALUE=3D"#Trim(PartDescription)#" /TEXTAREA 2. SELECT NAME=3D"make"option = value=3D"Make"OPTIONNissanOPTIONFiat/SELECT Please advise me what changes to make. Thanks. Sincerely, --- Hubert Earl ICQ#: 16199853 I develop maintain web sites internationally. I also build web = applications using CGI scripts written in Perl. I accept subcontracting = work. **Personal web site: http://www.geocities.com/SiliconValley/Peaks/8702/ (please remember to view this with a sense of humour!) **Business web page: http://home.talkcity.com/MigrationPath/hearl/ --=_NextPart_000_0051_01BFA398.27FB4B80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2I've made an update template which = needs to be=20 populated with data previously entered into the database.nbsp; However, = fields=20 referenced by the following code are turning up empty:/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D21.nbsp;lt;TEXTAREA COLS=3D25 ROWS=3D4 = NAME=3D"PartDescription"BRnbsp;nbsp;nbsp;nbsp;nbsp;REQUIRED=3D"Yes= "=20 MESSAGE=3D"Please enter a description of the part you=20 require"BRnbsp;nbsp;nbsp;=20 VALUE=3D"#Trim(PartDescription)#"gt;BRnbsp;nbsp;nbsp;=20 lt;/TEXTAREAgt;/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D22. lt;SELECT = NAME=3D"make"gt;lt;option=20 value=3D"Make"gt;lt;OPTIONgt;Nissanlt;OPTIONgt;Fiatlt;/SELECTgt;/= FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Please advise me what changes to = make.nbsp;=20 Thanks./FONT/DIV DIVnbsp;/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Sincerely,/FONT/DIV DIVFONT face=3DArial size=3D2---BRHubert EarlBRICQ#:nbsp;=20 16199853/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2I develop amp; maintain web sites=20 internationally.nbsp; I also build web applications using CGI scripts = written=20 in Perl.nbsp; I accept subcontracting work./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2**Personal web site:nbsp; A=20 href=3D"http://www.geocities.com/SiliconValley/Peaks/8702/"http://www.ge= ocities.com/SiliconValley/Peaks/8702//ABR(please=20 remember to view this with a sense of humour!)/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2**Business web page:nbsp; A=20 href=3D"http://home.talkcity.com/MigrationPath/hearl/"http://home.talkci= ty.com/MigrationPath/hearl//A/FONT/DIV/BODY/HTML --=_NextPart_000_0051_01BFA398.27FB4B80-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Integer?
Well, "01234567890" _is_ an integer, unless the rules have changed. Maybe it's too big for the mod function, though; CF can't handle large numbers (I don't remember exactly what "large" is). How about either val(form.myField) MOD 100 or cfif len(form.myfield) LT 6 !---maybe not six, try yourself --- cfif form.myfield MOD 100 ... /cfif -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 9:56 AM To: [EMAIL PROTECTED] Subject: Integer? Hopefully someone can shed some light on this. I've got a field where I'm looking for an integer. I then need to verify that this field is in an increment of 100: cfif form.myField Mod 100 It's not an increment of 100! /cfif Alrighty, that works fine, unless I enter a non-integer in the field (i.e. "01234567890", even though CFFORM validates this as an integer!) -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
AW: cfmail question (sorry about no subject before)
If you use cfmail you can go to \cfusion\mail\Log\errors.log. Check it for "550" Or "User unknown". Between these two texts is the wrong email stored. Armin -Ursprüngliche Nachricht- Von: Roy Rim [mailto:[EMAIL PROTECTED]] Gesendet am: Dienstag, 11. April 2000 18:48 An: [EMAIL PROTECTED] Betreff: RE: cfmail question (sorry about no subject before) is there any way for cfusion to detect failed email, and automatically remove that address from a database? from what I understand mail servers generally queue mails before sending them out, so they only error you can possible receive is a connection error if the mail server is down. We're facing similar problems here and I do believe we're going to handle it by mailing any failed mails to a user we create and parse those emails for errors. I believe you should do similar thing, parse the emails for bad users and delete from your database. Roy. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Slightly OT: DHTML and z-index
The 'higher' the index, the 'closer' the element is to the users' eyes. If you are simply using on 'layer' to place on top of your document, a z-index of 1 should suffice. If you need another element to 'layer' on that, move up 2, 3, 4, ... Hope this helps/ Tim -Original Message- From: Mark Jones [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 9:27 AM To: '[EMAIL PROTECTED]' Subject: Slightly OT: DHTML and z-index Can anyone tell me how I can make a div go ontop of a form element using z-indexs. I don't seem to be able to do this. Cheers Mark [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Integer?
Use the IsNumeric function to test for a number value, then perform your MOD stuff Hopefully someone can shed some light on this. I've got a field where I'm looking for an integer. I then need to verify that this field is in an increment of 100: cfif form.myField Mod 100 It's not an increment of 100! /cfif Alrighty, that works fine, unless I enter a non-integer in the field (i.e. "01234567890", even though CFFORM validates this as an integer!) My first thought here is to use the Int() function to round this to the nearest integer: cfif Int(form.myField) Mod 100 It's not an increment of 100! /cfif BUT NO! This does not work as advertised. I'm still getting a "Cannot convert to integer" from the Mod operator. Is anyone out there dealing with validating a user's input as an integer? Suggestions? Jason Stiefel Applications Developer iXL, Inc. 1930 Camden Road, Suite 2070 Charlotte, NC 28203 tel. 704.943.7000 fax. 704.943.7001 [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Custom DELL tag???
I'm writing a custom tag to retrieve the status of open orders from DELL. Has anyone written something like this that they would like to share. My tag seems to be working OK and I still need to handle the errors, but I'd like to see what else is out there. Thanks, Steve ~~ Steve Reich Backsoft Corporation 6960 Professional Parkway East Suite 100 Sarasota, Florida 34240 Toll Free: (888) 222-6047 Phone: (941) 907-6655 - Ext.1038 Fax: (941) 907-6643 email: [EMAIL PROTECTED] web: http://www.backsoft.com "Any sufficiently advanced technology is indistinguishable from magic." - Arthur C. Clarke ~~ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Integer?
Try this: CFIF IsNumeric(myformfield) CFSET newint = Int(myformfield) CFIF newint MOD 100 not an integer /CFIF /CFIF Taz - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 11, 2000 2:55 PM Subject: Integer? Hopefully someone can shed some light on this. I've got a field where I'm looking for an integer. I then need to verify that this field is in an increment of 100: cfif form.myField Mod 100 It's not an increment of 100! /cfif Alrighty, that works fine, unless I enter a non-integer in the field (i.e. "01234567890", even though CFFORM validates this as an integer!) My first thought here is to use the Int() function to round this to the nearest integer: cfif Int(form.myField) Mod 100 It's not an increment of 100! /cfif BUT NO! This does not work as advertised. I'm still getting a "Cannot convert to integer" from the Mod operator. Is anyone out there dealing with validating a user's input as an integer? Suggestions? Jason Stiefel Applications Developer iXL, Inc. 1930 Camden Road, Suite 2070 Charlotte, NC 28203 tel. 704.943.7000 fax. 704.943.7001 [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Starting the CF service on Solaris
All A Collegue of mine is attempting to restart cold fusion after the machine crashed and is getting this error message, can anyone shed some light as to the cause of the problem or likely solutions: It's running CF4 on Solaris 2.6 === ERROR: Unable to start the ColdFusion processes. Cause: The ColdFusion registry does not appear to be initialized. You can execute the following command to initialize the registry: cfexec -install cfdir -docroot docdir -register id === This is the error message that is being generated in the browser: === Error Occurred While Processing Request Error Diagnostic Information An error occurred while attempting to establish a connection to the server. The most likely cause of this problem is that the server is not currently running. Verify that the server is running and restart it if necessary. Unix error number 2 occurred: No such file or directory === TIA Steve Robson Consultant Planet Online T. 0113 207 6164 M. 07967 048865 F. 0113 207 6360 ICQ. 23832755 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Slightly OT: DHTML and z-index
In IE form elements will ALWAYS appear above your other div, regardless of z-index... Everyone chant with me now: "It's a feature, not a bug." -Original Message- From: Mike Murry [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 8:53 AM To: '[EMAIL PROTECTED]' Subject: RE: Slightly OT: DHTML and z-index Just make sure that your div's z-index number is higher than the block element containing the form. Example: style .formbox {position: absolute; z-index: 2} .otherdiv {position: absolute; z-index: 3} /style div class="formbox" form ...form elements... /form /div div class="otherdiv" ..blah, blah... /div Mike Murry Web Developer [EMAIL PROTECTED] 214.599.5290 -Original Message- From: Mark Jones [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 8:27 AM To: '[EMAIL PROTECTED]' Subject: Slightly OT: DHTML and z-index Can anyone tell me how I can make a div go ontop of a form element using z-indexs. I don't seem to be able to do this. Cheers Mark [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF/Javascript
Is anyone familiar with a Javascript group? Sherry Zeiss Infrastructure Support Services -Original Message- From: Roy Rim [SMTP:[EMAIL PROTECTED]] You really should ask the question on a javascript group, but here's the -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Integer?
How could a number "01234567890" be an integer? It's not even a real number! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 10:28 AM To: [EMAIL PROTECTED] Subject: RE: Integer? Well, "01234567890" _is_ an integer, unless the rules have changed. Maybe it's too big for the mod function, though; CF can't handle large numbers (I don't remember exactly what "large" is). How about either val(form.myField) MOD 100 or cfif len(form.myfield) LT 6 !---maybe not six, try yourself --- cfif form.myfield MOD 100 ... /cfif -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 9:56 AM To: [EMAIL PROTECTED] Subject: Integer? Hopefully someone can shed some light on this. I've got a field where I'm looking for an integer. I then need to verify that this field is in an increment of 100: cfif form.myField Mod 100 It's not an increment of 100! /cfif Alrighty, that works fine, unless I enter a non-integer in the field (i.e. "01234567890", even though CFFORM validates this as an integer!) -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
HTML Form Submit button troubles
Hi I'm new to ColdFusion and although I'm finding it generally easy going I'm having some troubles using CFINSERT to populate an Access database table. The trouble is that ColdFusion seems to be interpreting my Submit button as another form field in which it should be entering a value in the database table. Since I don't have a column in my database called 'SubmitForm' I'm getting the following error: Field name not found in the specified table. Table = 'DETAILS' Field = 'SUBMITFORM' The error occurred while processing an element with a general identifier of (CFINSERT). When I create a column for the sumbit button the actionpage works just fine. Does anyone know what I'm doing wrong? Chris Spencer Chris Spencer Learning Support Technician Cheltenham Gloucester College of H.E Pallas Villa, Park Campus Cheltenham, UK 01242 532967. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Starting the CF service on Solaris
From other postings I've seen, the problem is exactly what the error message says. The "registry" file in which CF stores config info (basically everything you set through CF admin) has gotten corrupted. He could look in /opt/coldfusion/registry for a backup version of cf.registry that might have been created by a text editor, etc. I believe all the "initialization" process does is copy cf.registry.template (in same dir) to cf.registry, but following the error message's instructions would be safer. This would be a good file to make backups of regularly :-). -Original Message- From: Steve Robson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 10:45 AM To: House of Fusion (E-mail) Subject: Starting the CF service on Solaris All A Collegue of mine is attempting to restart cold fusion after the machine crashed and is getting this error message, can anyone shed some light as to the cause of the problem or likely solutions: It's running CF4 on Solaris 2.6 === ERROR: Unable to start the ColdFusion processes. Cause: The ColdFusion registry does not appear to be initialized. You can execute the following command to initialize the registry: cfexec -install cfdir -docroot docdir -register id === -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF/Javascript
Is anyone familiar with a Javascript group js-jive.. by the same folks that run this list.. go to houseoffusion.com for info Billy Cravens [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Starting the CF service on Solaris
Try running ./stop -force to kill the registry daemon first. Then running ./start should work. Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Steve Robson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 10:45 AM To: House of Fusion (E-mail) Subject: Starting the CF service on Solaris All A Collegue of mine is attempting to restart cold fusion after the machine crashed and is getting this error message, can anyone shed some light as to the cause of the problem or likely solutions: It's running CF4 on Solaris 2.6 === ERROR: Unable to start the ColdFusion processes. Cause: The ColdFusion registry does not appear to be initialized. You can execute the following command to initialize the registry: cfexec -install cfdir -docroot docdir -register id === This is the error message that is being generated in the browser: === Error Occurred While Processing Request Error Diagnostic Information An error occurred while attempting to establish a connection to the server. The most likely cause of this problem is that the server is not currently running. Verify that the server is running and restart it if necessary. Unix error number 2 occurred: No such file or directory === TIA Steve Robson Consultant Planet Online T. 0113 207 6164 M. 07967 048865 F. 0113 207 6360 ICQ. 23832755 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Is there a CFUG in SE Wisconsin?
As a new developer in ColdFusion, I was wondering if there is a users group in Southeast Wisconsin? Thanks, Scott Scott Brader USAV Group 5485 South Westridge Drive PO Box 510620 New Berlin, WI 53151-0620 Phone: 262.814.2000 Fax: 262.814.2006 Amateurs Practice Until They Get It Right, Experts Practice Until They Can't Get It Wrong Any opinions expressed herein are mine and are not representative of USAV Communications Group. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT empty list items aren't counted?
One might ask why this is a problem? If you've got a need for null values, then use an array. A good developer knows when to use different datatypes. ;-) -Original Message- From: Douglas Blocker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 11:55 AM To: [EMAIL PROTECTED] Subject: RE: OT empty list items aren't counted? From CFML Language Reference 4.0, under CFLOOP, "Looping over a List": "Note that consecutive delimiters are treated as a single delimiter." What a feature! Douglas Blocker Web Applications Developer icma.org -Original Message- From: Jeff Johnson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 9:01 AM To: [EMAIL PROTECTED] Subject: OT empty list items aren't counted? Sorry for the OT post but CF-Talk says I'm not allowed to post for some reason... I'm working to get that fixed but in the meantime I thought maybe you'd have a response for this one... I'm stunned to see that in CF, lists like ",1,,2,3,,5" are equal to "1,2,3,5"!! Is this a bug, poor parsing code or intended behavior? Forgive me for being inflamatory but this is the dumbest thing I've seen in a while. Just in case this is a bug, I'm running CF 4.5 on Win 2000 for my development server. Has anyone else been bitten by this? CODE: cfset list=",1,,2,3,,5" cfoutput List="#list#"br ListLen=#ListLen(list)#br cfloop list="#list#" index="item" Item = #item#br /cfloop /cfoutput OUTPUTS: List=",1,,2,3,,5" ListLen=4 Item = 1 Item = 2 Item = 3 Item = 5 Thanks and again I'm sorry for the flame but this is really annoying, Jeff -- To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/fu sebox or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/fusebox or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Word document client-side
This is a multi-part message in MIME format. --=_NextPart_000_00A6_01BFA3A3.74F281F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I'm attempting to create a client-side only web-app to create proposals. I am going to use javascript array to hold data, and the goal is to = create word documents. We can require that the user runs IE 4 + if we'd like - but I need to = figure out how to create word documents using COM objects. I've tried = some stuff using VBScript without success. =20 No server will be used (CF or otherwise), so I must rely on current = client-side technology. Help someone? thx Tom Langer --=_NextPart_000_00A6_01BFA3A3.74F281F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT size=3D2I'm attempting to create a client-side only web-app = to create=20 proposals./FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2I am going to use javascript array to hold data, and = the goal=20 is to create word documents./FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2We can require that the user runs IE 4 + if we'd = like - but I=20 need to figure out how to create word documents using COM objects.nbsp; = I've=20 tried some stuff using VBScript without success.nbsp; /FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2No server will be used (CF or otherwise), so I must = rely=20 onnbsp;current client-side technology./FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2Help someone?/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2thx/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2Tom Langer/FONT/DIV/BODY/HTML --=_NextPart_000_00A6_01BFA3A3.74F281F0-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Debugger across multiple templates
Does anyone know if the debugger is capable of moving across multiple templates? For example I have form a that gathers user input and posts to form b. Form b is where I want to debug. I set my breakpoints there and start the debugging session from form a. When I post, template flow never stops at the breakpoints. This is being done in the internal Studio browser. Dan -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Any good way to maintain server variables?
In 4EC96B864C1CD211BBC500805FE6FDBC02B48B9E@TCEXCH1, Thompson, Ryan K (James Tower) ([EMAIL PROTECTED]) in a fit of unbridled passion, wrote: We are implementing a clustering solution that can do sticky session but it needs a unique value it either a cookie variable or URL variable per server. Rather that changing the code on each server I'd like to use a variable that would be unique on each server. Does anyone know of a good way to set and maintain a server or cgi variable to do this? Fine, so create a unique cookie for each server and have a many-to-many setup in your database reconciling those unique keys to whatever session settings you'd like to store. I suggest you make your unique server cookies very unique and not just an incrementing serial number. The domain name will not change in the HTTP header so we can't use that. I thought of putting a browser in the startup of each server to hit a page but when CF restarts that is gone. A scheduled task every minute but that may not be fast enough. You can't create a unique cookie name for each server? What about a single cookie that stores each of the server's unique keys in a text block that is parsed out by each server programmatically? Ryan Thompson James Tower Media Design Websites, Multimedia, Videos, Catalogs, e-Catalogs and more. http://www.jtmd.com mailto:[EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. r -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
HELP!! How to force Word Document to download?
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFA3CF.381F7B50 Content-Type: text/plain; charset="iso-8859-1" Hi, Does anyone know how to force a Word document (or any office document for that matter) to download in Internet Explorer?? If I use an CFM file that sends the file to the browser, it always opens Word in the browser. I want to force it to download, with the correct filename, as in "whatever.doc" instead of "download.cfm". I've seen other sites that can do this, such as www.hotoffice.com and www.xdrive.com, www.freedrive.com, etc... Any help would be greatly appreciated! Scott --_=_NextPart_001_01BFA3CF.381F7B50 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12" TITLEHELP!! How to force Word Document to download?/TITLE /HEAD BODY PFONT COLOR="#80" SIZE=2 FACE="Tahoma"Hi, Does anyone know how to force a Word document (or any officeBR document for that matter) to download in Internet Explorer?? IfBR I use an CFM file that sends the file to the browser, it alwaysBR opens Word in the browser.BR BR I want to force it to download, with the correct filename, asBR in quot;whatever.docquot; instead of quot;download.cfmquot;. I've seen otherBR sites that can do this, such as www.hotoffice.com andBR www.xdrive.com, www.freedrive.com, etc...BR BR Any help would be greatly appreciated!BR /FONT BRBFONT COLOR="#80" SIZE=2 FACE="Verdana"Scott/FONT/BI/II/I /P /BODY /HTML --_=_NextPart_001_01BFA3CF.381F7B50-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Performance and CFEXIT
I have been doing some testing with the performance time of CFEXIT in my applications and have found that it takes .25 seconds just to process the tag. While it doesn't look like much by itself, under load, this is a tremendous amount of time for a simple tag to execute. Can anybody give me insight as to why this tag would be so slow? By the way, I have stripped down the code in the custom tag I tested it with, which makes the overhead almost negligible. Thanks, Dave. __ Get Your Private, Free Email at http://www.hotmail.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Any good way to maintain server variables?
You could also just test in the application.cfm.. if the server variables are not defined, make one up! If you rely on a scheduled task, there will always be a chance that a page could execute before the variable is declared and trigger an error. Al he domain name will not change in the HTTP header so we can't use that. I thought of putting a browser in the startup of each server to hit a page but when CF restarts that is gone. A scheduled task every minute but that may not be fast enough. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF/Javascript
Yes... JS-Jive! Filled with lots of CFers too! Community email addresses: Post message: [EMAIL PROTECTED] Subscribe:[EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://www.onelist.com/community/JS-Jive HTH, Steve Reich -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 10:55 AM To: [EMAIL PROTECTED] Subject: RE: CF/Javascript Is anyone familiar with a Javascript group? Sherry Zeiss Infrastructure Support Services -Original Message- From: Roy Rim [SMTP:[EMAIL PROTECTED]] You really should ask the question on a javascript group, but here's the -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Integer?
Huh? Do you mean because of the leading zero? Most of the time computers can ignore that. What else makes it not an integer? If I write it as 1,234,567,890 is it an integer? Not wanting to fight, but curious.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 11:21 AM To: [EMAIL PROTECTED] Subject: RE: Integer? How could a number "01234567890" be an integer? It's not even a real number! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFMAIL Question
I have heard horror stories of CFMAIL overloading mail servers. The pb seems to be more that the CFMAIL SMTP client tends to pile up msgs in the CF send mail queue when there is a hiccup and has to be kicked to start sending again, or at least that seemed to be a frequently reported pb. It is possible for an SMTP client to look like a "thundering herd" to one SMTP server when delivering tons of mail to a one given server (assuming you sort destination address so all msgs for a destination can be delivered in one SMTP session, avoiding DNS lookups and session overheads), but if your CFMAIL delivery is sprayed over an assortment of SMTP servers, I wouldn't worry about that herd pb. The net tends to govern mail deliver speeds more than CFMAIL's sending capacity. But if your CFMAIL usage is going to dump all mail on a local SMTP server's ip address that will relay the mail to the net, then the pb might arise. This is a good approach that offloads delivery from CFMAIL quickly and reliably. 2000 mails a day is really peanuts, only 3 per minute per 10 hour day. yawn Len -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
search results produce everything in the table...
Hi, I have a simple search form on which you can search on three criteria. However when I type nothing in the form and hit submit it gives me everything in the table. I have tried to over-ride this to no effect. Can anyone point me in the right direction? Thanks, Richard .. In the results page I have something like: CFQUERY NAME="blahblah" DATASOURCE="blahblah" blahblah CFIF Trim(VariableOne) IS NOT "" AND FieldOne LIKE '%#Trim(Form.VariableOne)#%' /CFIF CFIF Trim(VariableTwo) IS NOT "" AND FieldTwo LIKE '%#Trim(Form.VariableTwo)#%' /CFIF CFIF Trim(VariableThree) IS NOT "" AND FieldThree LIKE '%#Trim(Form.VariableThree)#%' /CFIF balhblah /CFQUERY -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: HTML Form Submit button troubles
You can specify the list of formfields to be processed by the CFINSERT tag, using the FORMFIELDS attribute. However, in my opinion, reliance on CFINSERT can have unintended consequences. I recommend that you use a CFQUERY with the appropriate SQL statements instead. This gives you more flexibility and control in the long run. DC - Original Message - From: SPENCER, Chris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 11, 2000 15:40 Subject: HTML Form Submit button troubles Hi I'm new to ColdFusion and although I'm finding it generally easy going I'm having some troubles using CFINSERT to populate an Access database table. The trouble is that ColdFusion seems to be interpreting my Submit button as another form field in which it should be entering a value in the database table. Since I don't have a column in my database called 'SubmitForm' I'm getting the following error: Field name not found in the specified table. Table = 'DETAILS' Field = 'SUBMITFORM' The error occurred while processing an element with a general identifier of (CFINSERT). When I create a column for the sumbit button the actionpage works just fine. Does anyone know what I'm doing wrong? Chris Spencer Chris Spencer Learning Support Technician Cheltenham Gloucester College of H.E Pallas Villa, Park Campus Cheltenham, UK 01242 532967. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: HTML Form Submit button troubles
When I create a column for the sumbit button the actionpage works just fine. Does anyone know what I'm doing wrong? Do you have a "name" attribute specified for the submit button? If so, so you need it? This might be the problem although I haven't tested it out. Other than that, you could use a standard cfquery with the insert statement instead of using cfinsert. While cfinsert is somewhat useful, it's kind of clunky and generally I prefer cfquery (as do many others on this list I suspect). The latter also has the advantage of forcing you to learn SQL, which beleive me you'll end up having to do anyway. Good luck. - Sean Sean Daniels Manager, Engineering DealStream.com [EMAIL PROTECTED] http://www.dealstream.com tel: 207.439.6030 cel: 978.764.0779 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF/Javascript
js-jive.. by the same folks that run this list.. go to houseoffusion.com for info Billy Cravens [EMAIL PROTECTED] Just to clarify, JS-Jive is not affiliated in any way to the House of Fusion or the CF-Talk list. It was started by one of the members of CF-Talk (me) and does have a large CF community population. Here is the current information for subscribing (a real home page will be in place shortly): Community email addresses: Post message: [EMAIL PROTECTED] Subscribe:[EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://www.onelist.com/community/JS-Jive Thanks, Steve Reich -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: HTML Form Submit button troubles
I'm new to ColdFusion and although I'm finding it generally easy going I'm having some troubles using CFINSERT to populate an Access database table. The trouble is that ColdFusion seems to be interpreting my Submit button as another form field in which it should be entering a value in the database table. Since I don't have a column in my database called 'SubmitForm' I'm getting the following error: that's one of the limitations of using CFINSERT...all the fields in the form will be used in the insert statement. however, you could use the CFINSERT field's FORMFIELD attribute to explicitly name each field you want to insert. the general recommendation, however, is to use a CFQUERY tag with a SQL insert statement rather than using CFINSERT because the former is much much more flexible and is quicker. CFQUERY DATASOURCE="YourDSN" INSERT INTO TableName (field1, field2, field3) VALUES (#FORM.field1#, #Form.Field2#, #Form.Field3#) /CFQUERY just remember that string fields must have single quotes around them in the values. -emily -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: HTML Form Submit button troubles
Chris, Leave out "NAME="SubmitForm" in your INPUT TYPE="submit" tag. Or, better yet, don't use CFINSERT at all... write your own CFQUERY to add records to the database. Joy At 04:40 PM 4/11/00 +0100, you wrote: Hi I'm new to ColdFusion and although I'm finding it generally easy going I'm having some troubles using CFINSERT to populate an Access database table. The trouble is that ColdFusion seems to be interpreting my Submit button as another form field in which it should be entering a value in the database table. Since I don't have a column in my database called 'SubmitForm' I'm getting the following error: Field name not found in the specified table. Table = 'DETAILS' Field = 'SUBMITFORM' The error occurred while processing an element with a general identifier of (CFINSERT). When I create a column for the sumbit button the actionpage works just fine. Does anyone know what I'm doing wrong? Chris Spencer Chris Spencer Learning Support Technician Cheltenham Gloucester College of H.E Pallas Villa, Park Campus Cheltenham, UK 01242 532967. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: HTML Form Submit button troubles
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFA3D5.099BFC60 Content-Type: text/plain; charset="iso-8859-1" Just don't use the attribute NAME in your INPUT submit tag. Shawn Regan -Original Message- From: SPENCER, Chris [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 8:40 AM To: '[EMAIL PROTECTED]' Subject: HTML Form Submit button troubles Hi I'm new to ColdFusion and although I'm finding it generally easy going I'm having some troubles using CFINSERT to populate an Access database table. The trouble is that ColdFusion seems to be interpreting my Submit button as another form field in which it should be entering a value in the database table. Since I don't have a column in my database called 'SubmitForm' I'm getting the following error: Field name not found in the specified table. Table = 'DETAILS' Field = 'SUBMITFORM' The error occurred while processing an element with a general identifier of (CFINSERT). When I create a column for the sumbit button the actionpage works just fine. Does anyone know what I'm doing wrong? Chris Spencer Chris Spencer Learning Support Technician Cheltenham Gloucester College of H.E Pallas Villa, Park Campus Cheltenham, UK 01242 532967. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01BFA3D5.099BFC60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLERE: HTML Form Submit button troubles/TITLE /HEAD BODY PFONT SIZE=3D2Just don't use the attribute NAME in your = lt;INPUTgt; submit tag./FONT /P PFONT SIZE=3D2Shawn Regan/FONT /P PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: SPENCER, Chris [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/F= ONT BRFONT SIZE=3D2Sent: Tuesday, April 11, 2000 8:40 AM/FONT BRFONT SIZE=3D2To: '[EMAIL PROTECTED]'/FONT BRFONT SIZE=3D2Subject: HTML Form Submit button troubles/FONT /P BR PFONT SIZE=3D2Hi/FONT /P PFONT SIZE=3D2I'm new to ColdFusion and although I'm finding it = generally easy going I'm/FONT BRFONT SIZE=3D2having some troubles using CFINSERT to populate an = Access database table./FONT BRFONT SIZE=3D2The trouble is that ColdFusion seems to be = interpreting my Submit button as/FONT BRFONT SIZE=3D2another form field in which it should be entering a = value in the database/FONT BRFONT SIZE=3D2table. Since I don't have a column in my database = called 'SubmitForm' I'm/FONT BRFONT SIZE=3D2getting the following error:/FONT /P PFONT SIZE=3D2Field name not found in the specified table.nbsp; = Table =3D 'DETAILS' Field =3D/FONT BRFONT SIZE=3D2'SUBMITFORM'nbsp; The error occurred while = processing an element with a general/FONT BRFONT SIZE=3D2identifier of (CFINSERT)./FONT /P PFONT SIZE=3D2When I create a column for the sumbit button the = actionpage works just fine./FONT BRFONT SIZE=3D2Does anyone know what I'm doing wrong?/FONT /P PFONT SIZE=3D2Chris Spencernbsp;nbsp; /FONT /P BR BR BR PFONT SIZE=3D2Chris Spencer/FONT BRFONT SIZE=3D2Learning Support Technician/FONT BRFONT SIZE=3D2Cheltenham amp; Gloucester College of H.E/FONT BRFONT SIZE=3D2Pallas Villa, Park Campus/FONT BRFONT SIZE=3D2Cheltenham, UK/FONT BRFONT SIZE=3D201242 532967./FONT BRFONT = SIZE=3D2---= ---/FONT BRFONT SIZE=3D2Archives: A = HREF=3D"http://www.eGroups.com/list/cf-talk" = TARGET=3D"_blank"http://www.eGroups.com/list/cf-talk/A/FONT BRFONT SIZE=3D2To Unsubscribe visit A = HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dli= sts/cf_talk" = TARGET=3D"_blank"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= body=3Dlists/cf_talk/A or send a message to = [EMAIL PROTECTED] with 'unsubscribe' in the = body./FONT/P /BODY /HTML --_=_NextPart_001_01BFA3D5.099BFC60-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF tags for SAS
--F87DB1634D05711533B0B307 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I am very interested in this topic! Randy Hogg wrote: Does anyone know of any custom tags to work with SAS datasets, call SAS routines realtime, or any other interaction? Many thanks. Randy BTW Great list, I'm learning TONS! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --F87DB1634D05711533B0B307 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit !doctype html public "-//w3c//dtd html 4.0 transitional//en" html I am very interested in this topic! pRandy Hogg wrote: blockquote TYPE=CITEDoes anyone know of any custom tags to work with SAS datasets, call SAS brroutines realtime, or any other interaction?nbsp; Many thanks.nbsp; Randy brBTWnbsp; Great list, I'm learning TONS! p-- brArchives: a href="http://www.eGroups.com/list/cf-talk"http://www.eGroups.com/list/cf-talk/a brTo Unsubscribe visit a href="http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk"http://www.houseoffusion.com/index.cfm?sidebar=listsamp;body=lists/cf_talk/a or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body./blockquote /html --F87DB1634D05711533B0B307-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
sending and waiting for a file - COM object poss?
Hi, I'm looking for a bit of advice here. I need to send a file across a that contains the contents of a CF query network and then wait for a return file and present the contents of this file to the users browser. No problem with writing the file, simply use CFFILE. The thing is how can I get it to send it across the network, then wait for the response. My first instinct is that CF probably isn't the appropriate tool for this kind of a job as it would have to sit in a loop waiting for a file to read whilst maintaining a browser connection. So I thought maybe a COM object which CF can communicate with would be better, but I know nothing about COM objects - any advice. Alternatively I thought about writing a file which refreshes itself every 5 seconds, displaying a please wait message to the user and checks the directory for the file, if it does this 10 times it displays an error to the user. Is there a better way to do this?? Thanks Ben, -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Protecting email links on web pages from spam bots?
Simple instead of using [EMAIL PROTECTED], use the Character entity for it So in this case you'd use whatever#64;company#046;com HTH, larry -- Larry C. Lyons EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- "Reuben King" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Some time ago, I heard of a way to thwart spam bots from extracting email addresses from web pages but I forgot. Anyone know? Thanks, -RK -- Reuben King mailto:[EMAIL PROTECTED] Senior Web Consultant Stonebridge Technologies http://www.sbti.com/ Phone: (512) 488-8885 x3332 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Integer?
it appears that coldFusion can't handle very large integer. one work around solution is to check for the last two digits being "00". if they are, the integer is divisible (or increment of) by 100. here's the fix: cfif isNumeric(form.myField) cfset rightTwoDigits = right(form.myField, 2) cfif rightTwoDigits IS NOT "00" It's not an increment of 100! cfelse yes, it is /cfif /cfif -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 6:56 AM To: [EMAIL PROTECTED] Subject: Integer? Hopefully someone can shed some light on this. I've got a field where I'm looking for an integer. I then need to verify that this field is in an increment of 100: cfif form.myField Mod 100 It's not an increment of 100! /cfif Alrighty, that works fine, unless I enter a non-integer in the field (i.e. "01234567890", even though CFFORM validates this as an integer!) My first thought here is to use the Int() function to round this to the nearest integer: cfif Int(form.myField) Mod 100 It's not an increment of 100! /cfif BUT NO! This does not work as advertised. I'm still getting a "Cannot convert to integer" from the Mod operator. Is anyone out there dealing with validating a user's input as an integer? Suggestions? Jason Stiefel Applications Developer iXL, Inc. 1930 Camden Road, Suite 2070 Charlotte, NC 28203 tel. 704.943.7000 fax. 704.943.7001 [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Protecting email links on web pages from spam bots?
Will this work for the mailto: url inside an a href as well as the display? In [EMAIL PROTECTED], Larry C. Lyons ([EMAIL PROTECTED]) in a fit of unbridled passion, wrote: Simple instead of using [EMAIL PROTECTED], use the Character entity for it So in this case you'd use whatever#64;company#046;com HTH, larry -- Larry C. Lyons EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- "Reuben King" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Some time ago, I heard of a way to thwart spam bots from extracting email addresses from web pages but I forgot. Anyone know? Thanks, -RK -- Reuben King mailto:[EMAIL PROTECTED] Senior Web Consultant Stonebridge Technologies http://www.sbti.com/ Phone: (512) 488-8885 x3332 -- Reuben King mailto:[EMAIL PROTECTED] Senior Web Consultant Stonebridge Technologies http://www.sbti.com/ Phone: (512) 488-8885 x3332 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Integer?
In [EMAIL PROTECTED], [EMAIL PROTECTED] ([EMAIL PROTECTED]) in a fit of unbridled passion, wrote: Huh? Do you mean because of the leading zero? Most of the time computers can ignore that. What else makes it not an integer? If I write it as 1,234,567,890 is it an integer? Not wanting to fight, but curious.. The previous poster is incorrect. "01234567890" is indeed an integer. The computer of course ignores the leading 0. CF's precision will only go up to (12 digits) and then it starts using scientific notation.. (1.23456789012E+012). So, if you want to handle numbers over a trillion precisely, you'll have to do some creative programming. Also, beware the commas. Strip them out before using val() or integer (). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 11:21 AM To: [EMAIL PROTECTED] Subject: RE: Integer? How could a number "01234567890" be an integer? It's not even a real number! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Reuben King mailto:[EMAIL PROTECTED] Senior Web Consultant Stonebridge Technologies http://www.sbti.com/ Phone: (512) 488-8885 x3332 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
No Subject
I have a field with numbers ranging from 1-5 that I would like my users to be able to use as a search criteria. If the user wishes to search by 3, for example, I would like to return anything that was 3 or greater. Can this be done? Thanks, Tim -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Is 4.5.1 Solid
At 09:02 AM 4/10/00 -0700, you wrote: Hi Dick, We upgraded to 4.51 and it seemed to cure quite a few ills. So far no damage. We had previously installed the hot fixes for CFHTTP and CFMAIL and had switched some CFMAIL calls off to another machine so we didn't have many problems there. It now does allow the 20,000,000 AOL users that couldn't complete our pages do so...seems really strange to me that they would allow such crap to be issued as a release in the first place as an 'upgrade' ;) You can't really mean that. The problem is on AOL's end. CF Server now accommodates the problems on AOL's end. Do you honestly want Allaire to get accounts with every major ISP so they can check to see if the ISP's stupid procedures mess up the sites? I used to work at a hosting company and the focus was on video hosting. Every time we had a broadcast, we would get inundated with tech support calls from AOL users asking us why our site was broken. You can't imagine how many times I had to explain to people exactly why they needed to get a real ISP. AOL uses cached proxy servers and it is bad bad bad. The really funny calls were the AOL users who said "What do you mean you don't do tech support for AOL? You're the Internet, right?" The ISP who hosts many of my client's sites is considering switching to 4.5.1 as the active CF platform. There have been lots of threads re problems with various 4.5 versions... I am especially concerned with: CFHTTP regexps CFMAIL Anyone know of outstanding problems with 4.5.1? Any killer incompatibilities between 4.0 4.5 1? TIA Dick -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: search results produce everything in the table...
Since the search is only restricted to what you type in, if you leave it blank the search is not restricted. Hence the entire table is returned. What would you like to have happen instead? -Original Message- From: Richard Hart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 12:23 PM To: House of Fusion Subject: search results produce everything in the table... Hi, I have a simple search form on which you can search on three criteria. However when I type nothing in the form and hit submit it gives me everything in the table. I have tried to over-ride this to no effect. Can anyone point me in the right direction? Thanks, Richard .. In the results page I have something like: CFQUERY NAME="blahblah" DATASOURCE="blahblah" blahblah CFIF Trim(VariableOne) IS NOT "" AND FieldOne LIKE '%#Trim(Form.VariableOne)#%' /CFIF CFIF Trim(VariableTwo) IS NOT "" AND FieldTwo LIKE '%#Trim(Form.VariableTwo)#%' /CFIF CFIF Trim(VariableThree) IS NOT "" AND FieldThree LIKE '%#Trim(Form.VariableThree)#%' /CFIF balhblah /CFQUERY -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Can CF be run on a Cobalt RAQ 3?
Can a Linux version of Cold Fusion be run on a Cobalt RAQ 3 (512 megs of RAM)? Is it advisable? Are there advantages going this route vs. an NT machine? Thanks for your help. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Oracle 8i and WebDB
Does anyone know what WebDB is all about? Is it the visual equivalent of Cold Fusion Enterprise and the Cold Fusion Studio? Anyone have any good working experience with that tool, would appreciate any working experience feedback. Thanks in advance, Pardee. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFmail and CRLF!!!
I am using Que Mail and Cf 4.5 for linux. If I send a mail message with more than one line my mail server will not send it because it is sending bare LF. read: http://cr.yp.to/docs/smtplf.html After an attempt to send a message with a bare LF, Cfmail will no longer even try to send mail until the service is restated. Has anyone experienced this before? Is there a fix?? Grr -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Protecting email links on web pages from spam bots?
Will this work for the mailto: url inside an a href as well as the display? If you just try it, you'll see that it does. Great tip, Larry! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Performance Question
cfinclude At 10:29 AM 11/04/00 -0700, you wrote: Hi Folks, I was wondering about something when it comes to performance: Which is faster, a custom tag (CF_mytag not CFX_mytag) or using a CFINCLUDE to include the code that is being called? Thanks, Doug -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF-hosting in New Zealand
Hi Try www.2day.com based in Auckland - automated online setups and good CF knowledge. We have had sites with them for around 18mths with few hiccups. cheers Lawrence Smith The Chief Cabbage See a profile of our work at: http://www.cabbagetree.co.nz/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: about updating with CFSCHEDULE
I am not sure what the original message is about exactly, but it kicked my mind into a question: I output the result of the scheduled tasks to a file. Say I want to keep a log (either appending to that file or in a database preferred).. how would I go about that? Right now it simply overwrites the last file in there, so I get one week's worth of results. My only thoughts were to make another schedule item to rename the file according to the date it was last done (to keep a list of files with results) but that is no ideal. Scott M. Berry -- College of the Canyons Web Design 661.259.7800 x3630 http://www.coc.cc.ca.us - Original Message - From: "Sharon DiOrio" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; "CF-Talk-HouseOfFusion" [EMAIL PROTECTED] Sent: Tuesday, April 11, 2000 8:33 AM Subject: Re: about updating with CFSCHEDULE Well, if you are going to update a template, you will need something to update it with. Usually, people store this in a database, and it will need to be retrieved with a query. Could you explain more what you are trying to do? Sharon At 11:05 AM 4/11/2000 -0300, Juan Manuel Tapiola wrote: Hello, I want to keep updated every day a template but I don't want this to depend on a query. Instead of that, I want to have a scheduling task to update this template every day. How do I do it? Is it a way to create application variables? Is it the best way? Thank you a lot in advance, Manuel Tapiola www.ciudadvideo.com --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarstsbodysts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Is 4.5.1 Solid
Not only do they use cached proxy servers, but they severely filter content. Wise words: "bad bad bad" =) Scott M. Berry -- College of the Canyons Web Design 661.259.7800 x3630 http://www.coc.cc.ca.us - Original Message - From: "Jennifer" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 11, 2000 10:59 AM Subject: Re: Is 4.5.1 Solid At 09:02 AM 4/10/00 -0700, you wrote: Hi Dick, We upgraded to 4.51 and it seemed to cure quite a few ills. So far no damage. We had previously installed the hot fixes for CFHTTP and CFMAIL and had switched some CFMAIL calls off to another machine so we didn't have many problems there. It now does allow the 20,000,000 AOL users that couldn't complete our pages do so...seems really strange to me that they would allow such crap to be issued as a release in the first place as an 'upgrade' ;) You can't really mean that. The problem is on AOL's end. CF Server now accommodates the problems on AOL's end. Do you honestly want Allaire to get accounts with every major ISP so they can check to see if the ISP's stupid procedures mess up the sites? I used to work at a hosting company and the focus was on video hosting. Every time we had a broadcast, we would get inundated with tech support calls from AOL users asking us why our site was broken. You can't imagine how many times I had to explain to people exactly why they needed to get a real ISP. AOL uses cached proxy servers and it is bad bad bad. The really funny calls were the AOL users who said "What do you mean you don't do tech support for AOL? You're the Internet, right?" The ISP who hosts many of my client's sites is considering switching to 4.5.1 as the active CF platform. There have been lots of threads re problems with various 4.5 versions... I am especially concerned with: CFHTTP regexps CFMAIL Anyone know of outstanding problems with 4.5.1? Any killer incompatibilities between 4.0 4.5 1? TIA Dick -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF RDS and WINDOWS 2000 Permissions
I can't speak for configuring FTP services using MS FTP under Win2k, I haven't tried it. As you say, all the FTP servers I have experience with allow for default directories to be stipulated on a per user or group basis. I am guessing that this is the same for Win2k otherwise no one will use the product. As for CF/RDS, yes, you can configure default directories per user but, you have to enable and configure Advanced Security to do so. It's a little thick for me to explain here, I'd say start by reading up on Advanced Security and RDS in the CF docs and KB (knowledge base). Regards, Steve -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 2:06 PM To: [EMAIL PROTECTED] Subject: CF RDS and WINDOWS 2000 Permissions I hope someone can help me, because I have goten no response from the NT lists. All I want to do is be able to assign directories that users are routed to when they ftp into my box. In NT 4.0 there was a setting in the actual user configuration where you specified the folder they log in to. I am guessing this is Home Folders in 2000, but I cannot seem to get it to work. I can ftp into my box using the admin username and password, and anonomously, but cannot get a user to ftp in. Can someone explain to me how to: a) set a user up in 2000 so they can ftp in using thier user name and password b) are directed to the assigned folder when they ftp in. Also is there a way in CF Server to allow someone to only RDS into specific folders? Right now it seems you just need the admin password and that gives you everything. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re:
In your SQL WHERE statement you handle that: WHERE someField = '#FORM.fieldNumber#' Dave = "Always Drink Upstream From The Herd!" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 - Original Message - From: Tim Bahlke [EMAIL PROTECTED] To: CFTalk [EMAIL PROTECTED] Sent: Tuesday, April 11, 2000 12:46 PM I have a field with numbers ranging from 1-5 that I would like my users to be able to use as a search criteria. If the user wishes to search by 3, for example, I would like to return anything that was 3 or greater. Can this be done? Thanks, Tim -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Is 4.5.1 Solid
-Original Message- From: Jennifer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 1:59 PM To: [EMAIL PROTECTED] Subject: Re: Is 4.5.1 Solid At 09:02 AM 4/10/00 -0700, you wrote: snip The really funny calls were the AOL users who said "What do you mean you don't do tech support for AOL? You're the Internet, right?" /snip Our users are always asking us to speed up the internet for them. Like we have a speed knob back here. Heh.. If we did, you can bet we'd have it cranked all the way up. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF RDS and WINDOWS 2000 Permissions
Sean, In NT 4.0, you didn't actually deal with User Manager for the FTP stuff you are talking about. I haven't tried this on 2000, but this is what you do on NT 4. 1) Create an FTP root. Set no access for all users to this folder. 2) Create a folder for each user that you want to have FTP access to using Windows Explorer. 3) Create a virtual FTP directory for each user using the MMC. 4) Assign read/change whatever permissions to each user's directory depending on what you want them to do When people login to ftp.yourdomain.com they'll be automatically routed to the folder you set up for them. They won't be able to CDUP because they don't have permissions any where else. That should work. Aaron -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 11:06 AM To: [EMAIL PROTECTED] Subject: CF RDS and WINDOWS 2000 Permissions I hope someone can help me, because I have goten no response from the NT lists. All I want to do is be able to assign directories that users are routed to when they ftp into my box. In NT 4.0 there was a setting in the actual user configuration where you specified the folder they log in to. I am guessing this is Home Folders in 2000, but I cannot seem to get it to work. I can ftp into my box using the admin username and password, and anonomously, but cannot get a user to ftp in. Can someone explain to me how to: a) set a user up in 2000 so they can ftp in using thier user name and password b) are directed to the assigned folder when they ftp in. Also is there a way in CF Server to allow someone to only RDS into specific folders? Right now it seems you just need the admin password and that gives you everything. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: search results produce everything in the table...
Try this: Check to see if your form fields are submitted: if not, then stop them and give an error message. CFIF NOT IsDefined("FORM.FieldNames") STOP AND GO BACK! CFABORT /CFIF = "Always Drink Upstream From The Herd!" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 - Original Message - From: Jeff Shepler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 11, 2000 1:14 PM Subject: RE: search results produce everything in the table... Since the search is only restricted to what you type in, if you leave it blank the search is not restricted. Hence the entire table is returned. What would you like to have happen instead? -Original Message- From: Richard Hart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 12:23 PM To: House of Fusion Subject: search results produce everything in the table... Hi, I have a simple search form on which you can search on three criteria. However when I type nothing in the form and hit submit it gives me everything in the table. I have tried to over-ride this to no effect. Can anyone point me in the right direction? Thanks, Richard ... In the results page I have something like: CFQUERY NAME="blahblah" DATASOURCE="blahblah" blahblah CFIF Trim(VariableOne) IS NOT "" AND FieldOne LIKE '%#Trim(Form.VariableOne)#%' /CFIF CFIF Trim(VariableTwo) IS NOT "" AND FieldTwo LIKE '%#Trim(Form.VariableTwo)#%' /CFIF CFIF Trim(VariableThree) IS NOT "" AND FieldThree LIKE '%#Trim(Form.VariableThree)#%' /CFIF balhblah /CFQUERY -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE:
[search.cfm] ... input type=text name=someField ... [/search.cfm] [results.cfm] ... cfquery bla bla bla select yada yada yada fromwhatever WHERE someField = #FORM.someField# /cfquery ... [/results.cfm] Something like that?? -Original Message- From: Tim Bahlke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 1:46 PM To: CFTalk Subject: I have a field with numbers ranging from 1-5 that I would like my users to be able to use as a search criteria. If the user wishes to search by 3, for example, I would like to return anything that was 3 or greater. Can this be done? Thanks, Tim -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Integer?
I'm going to lay out what numbers are what. For programming purposes these definitions vary. All Numbers Imaginary: Numbers that do not exist for practical purposes. They have real value in some engineering fields, and in mathematics. What number, when multiplied with itself gives you a negative result. That would be an imaginary number. Real: All numbers that are either negative or positive. No imaginary numbers are real numbers. Rational: All numbers that can be put in fraction form. Irrational All numbers that cannot be put in fraction form. Integers: All numbers that do not contain a decimal point Whole: All numbers that are integers and are not negative Natural: All numbers that are integers and are not negative and are not zero. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Is 4.5.1 Solid
Hi Jennifer, At 09:02 AM 4/10/00 -0700, you wrote: Hi Dick, We upgraded to 4.51 and it seemed to cure quite a few ills. So far no damage. We had previously installed the hot fixes for CFHTTP and CFMAIL and had switched some CFMAIL calls off to another machine so we didn't have many problems there. It now does allow the 20,000,000 AOL users that couldn't complete our pages do so...seems really strange to me that they would allow such crap to be issued as a release in the first place as an 'upgrade' ;) You can't really mean that. The problem is on AOL's end. CF Server now Oh yes...I really can mean it ;)...and the problem was with CFServer with O'Reilly's Website OR AOL fixed the problem as we were installing 4.51 ;) accommodates the problems on AOL's end. Do you honestly want Allaire to get accounts with every major ISP so they can check to see if the ISP's stupid procedures mess up the sites? I used to work at a hosting company and the Of course not...but I would think that they would test it on the LARGEST modem community in the world...duh! focus was on video hosting. Every time we had a broadcast, we would get inundated with tech support calls from AOL users asking us why our site was broken. You can't imagine how many times I had to explain to people exactly why they needed to get a real ISP. AOL uses cached proxy servers and it is bad bad bad. I also do tech support and know just how lame AOL users can be and have used that same explaination as you did ;), however, that doesn't cover the fact that submit buttons or graphics buttons or verity searches wouldn't work using an AOL account until we upgraded to 4.51 (they worked fine with 1.5, 2.0, 2.5, 3.0, 3.1, 4.0 and 4.1) from 4.5 The really funny calls were the AOL users who said "What do you mean you don't do tech support for AOL? You're the Internet, right?" I understand...we have several hundred customers that use our lines to connect to their AOL accounts and it's tough to explain to them why their AOL mail doesn't work ;) -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to do
I did this with java script: function chkData() { if((document.frmname.radiobuttonname.checked)(document.frmName.RadioButtonName.value.length = 0)) { alert("If you checked 'Other' for question 8, please describe."); return false; } else { return true; } } I called this function in the form tag: form name="frmName" action="Page4.cfm" method="POST" onSubmit="return chkData()" hth miriam -Original Message- From: Sumeet Khanna [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 2:34 PM To: '[EMAIL PROTECTED]' Subject: How to do Can anyone please tell me how to do radio button validation ,if I want to use the check "if radio button "Other" is clicked then only enter Other option text in text box" Sumee -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF Talk, calculating elapsed time
Unfortunately, you cannot tell when a client leaves your site. This makes it hard to know when to stop timing. Unless you have them click a logoff button, of course, but you are not guaranteed that they will do so (we all know how users are). Couple of different ways you can try to do this. 1. Hidden Frame You can have a hidden frame that refreshes itself every minute. Each refresh, you update the database. Once the user leaves your site, that frame will (hopefully) stop refreshing itself. Problem with this is Netscape doesn't like hidden frames. 2. Weird things in application.cfm In your application.cfm file, you have a client variable - we'll call it HOLDTIME for lack of something else. Every time application.cfm is loaded, set a TEMP variable to Now(), calculate the difference between TEMP and HOLDTIME and update the database, set HOLDTIME to TEMP, finish the page. The problem here is at the end of the client's visit. Since application.cfm will not be loaded after they leave, you lose whatever time they spent on the last page. 3. If you want to use a logoff button, you can just take a timestamp when they login and compare it to the timestamp when they logoff and update the database. Again, you are not guaranteed that they will use the logoff button. Check the archives. The topic of knowing when a client leaves your site comes up every so often. I don't remember anything off hand, but you should be able to find it in the archives. -Original Message- From: rkern - Prolynx [mailto:[EMAIL PROTECTED]] Sent: Monday, April 10, 2000 1:55 PM To: CF-Talk Subject: CF Talk, calculating elapsed time To all, I'm looking for some ideas on how to implement a timer that tracks customer time on site. Situation - customer logs in, goes to study pages, at the point of login I start the timer. After a ten minute increment the 10 minutes are added to the totaltime in the user database. posting may be automatic or through submit button. if user leaves during the next 10 minute increment, nothing is posted to the database. approaches to date include: serveral forms of cfset Client.ETHours = Abs(DateDiff("h",Client.TimeCreated, Client.LastVisit)) the problem is that 'timecreated' gives a start date but is a static value that will allow for total time from when the account is generated. 'lastvisit' appears to be updated everytime the user comes back to the page rather than just at login. Have also considered client session variable storage. The variables appear in the database but are all in one field separated by # signs. I am looking for something cleaner. Need - idea that allows a timer function to kick off at login and then continue to run as long as they are on site in ten minute increments. The timer is not the issue (I can use a simple loop ), where to establish it is and how to use it accross the entire session and site is. any comments would be appreciated Thanks Richard -- The Prince - Niccollo Machiavelli (1532) Has some advice to his prince on engaging mercenaries. Mercenaries are into it for the money and will run at the first sign of trouble. Hire men who will die for you. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFmail and CRLF!!!
At 11:29 AM 4/11/00 -0700, you wrote: I am using Que Mail and Cf 4.5 for linux. If I send a mail message with more than one line my mail server will not send it because it is sending bare LF. read: http://cr.yp.to/docs/smtplf.html After an attempt to send a message with a bare LF, Cfmail will no longer even try to send mail until the service is restated. Has anyone experienced this before? Is there a fix?? Grr I'm not familiar with the problem, but if you are really running 4.5, you might want to upgrade to 4.5.1, which was released late last week. If there is a fix, it would probably be included. Evaluation download: http://www.allaire.com/download -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to do
Ok, let's assume that your radio button field is named FOO and your text box is named BAR. Instead of doing a cfinsert, you will have to do this one "by hand": cfquery name="doInsert" datasource="whatever" INSERT INTO someTable (Answer) VALUES ('#iif(FORM.FOO EQ "Other", DE("#FORM.BAR#"), DE("#FORM.FOO#"))#') /cfquery It might be DE(FORM.FOO) and DE(FORM.BAR), but I always get confused with the DE() function. Try both forms and see which one works. I'll probably get flamed for using nested pounds.. *shrug* -Original Message- From: Sumeet Khanna [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 2:34 PM To: '[EMAIL PROTECTED]' Subject: How to do Can anyone please tell me how to do radio button validation ,if I want to use the check "if radio button "Other" is clicked then only enter Other option text in text box" Sumee -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF tags for SAS
Randy: You might also try posting to [EMAIL PROTECTED], the SAS programming list. The people at Trilogy Consulting have done some work with SAS CF. -Gerry Gerard T. Pauline Mgt, Internet/DB Applications Computer Systems, DoIT Pace University Randy Hogg wrote: Does anyone know of any custom tags to work with SAS datasets, call SAS routines realtime, or any other interaction? Many thanks. Randy BTW Great list, I'm learning TONS! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Source Control
In 058501bfa3e4$872b8330$[EMAIL PROTECTED], Greg Czechowicz ([EMAIL PROTECTED]) in a fit of unbridled passion, wrote: We are currently using Visual Source Safe to implement source control on our site. Could someone please email me their prior experiences regarding source control. We currently use Sourcesafe and frankly it stinks. I've used PVCS in the past.. I think SourceSafe is cool in the fact that it integrates well with CF Studio. I've yet to see a killer source control system.. they all have crappy interfaces, imo. -- Reuben King mailto:[EMAIL PROTECTED] Senior Web Consultant Stonebridge Technologies http://www.sbti.com/ Phone: (512) 502-3332 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Integer?
I have CF 4.5.1 and this statement simply isn't true. IsNumeric() returns a true no matter how many 0's prepend a number, as long as the number is a number. Maybe in earlier versions of CF it returned a false, but if it did I am not aware of it. In D09A1A0FB7FDD211A92D00805FBBD8A1A578A3@CLTNTSXCHANGE, [EMAIL PROTECTED] ([EMAIL PROTECTED]) in a fit of unbridled passion, wrote: An integer is a range of "real numbers", usually with a limit around 999 million or so (depends on the language, C defines a smallint as 1-37,000 for example.) I can't find any documentation stating ColdFusion's limits with integers. ColdFusion doesn't see a number with a leading 0 as a number, thus it can't be an integer... Anyone know what the maximum size for an integer in CF is? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 12:15 PM To: [EMAIL PROTECTED] Subject: RE: Integer? Huh? Do you mean because of the leading zero? Most of the time computers can ignore that. What else makes it not an integer? If I write it as 1,234,567,890 is it an integer? Not wanting to fight, but curious.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 11:21 AM To: [EMAIL PROTECTED] Subject: RE: Integer? How could a number "01234567890" be an integer? It's not even a real number! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Reuben King mailto:[EMAIL PROTECTED] Senior Web Consultant Stonebridge Technologies http://www.sbti.com/ Phone: (512) 502-3332 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
File Archive Application
Our intranet needs a file archive application, where items such as PDF files, Excel spreadsheets, Powerpoint presentations, Word documents, and just about anything else imaginable can be stored and retrieved. In some cases, access to certain files and groups of files must be limited to specific groups of users. We'd like to maintain a parallel database file that would allow file creators to upload their files, as well as enter descriptions or comments about the file. I'm concerned about allowing this to get out of hand, in terms of the number of users and groups of users for which security permissions must be tracked. I'd like to solicit the mailing list's reactions on how best to set up and administer such a system, and what security model might be workable. JGB === Jeffrey G. Brown Intranet Webmaster Milacron, Inc. Voice: 513-841-8655 Fax: 513-841-7345 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Can CF be run on a Cobalt RAQ 3?
- Original Message - From: "Mike Sheldon" [EMAIL PROTECTED] Sent: Tuesday, April 11, 2000 8:34 PM Given the choice right now, I'd prefer to run the Linux version of CF. I've tested CF Linux and have been very happy with its behavior. What database are you using? Anyone using "mySQL"? How well does an NT CF application port to Linux? Thanks as always. Adrian Cooper. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Is there a CFUG in SE Wisconsin?
!-- From: [EMAIL PROTECTED] (Scott J. Brader) !-- Subject: Is there a CFUG in SE Wisconsin? Nothing has been formalized but myself and another individual working at WEPCO have met and discussed the issue and have remained in touch every now and then. I've offered to host the group's website but there is nothing to host. Yet. Contact [EMAIL PROTECTED] and Amy Brooks of Allaire via [EMAIL PROTECTED] to get in the loop. !--- Clinton Gallagher http://home.att.net/~csgallagher/ http://www.metromilwaukee.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: How well does CF run with mySQL?
How well does CF run with mySQL? Is it better to go with SQL7 or Oracle 8i? I am doing a prototype app with Access but now need to port to a stronger database program. Any suggestions? I understand Cold Fusion 4.5 still does not have direct native support for mySQL, true or false? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Is 4.5.1 Solid
WBB, Your trashing of AOL rather bothers me. AOL is just an ISP like any other and if your application breaks when someone from AOL attempts to use it, then I would suggest the problem lies flatly on your end for your failure to support even the most basic of cross-browser compatibilities. Furthermore, your insinuation that AOL'ers are all stupid, silly, ignorant, and what-not is way off base. AOL has its share of newbies, but lots of professionals use it too. AOL has millions of users. This is quite a large target customer base. I suggest you show them a bit more respect. Specific notes on your post follow: In 036c01bfa3f1$e3fcbae0$[EMAIL PROTECTED], WBB ([EMAIL PROTECTED]) in a fit of unbridled passion, wrote: [snip] OR AOL fixed the problem as we were installing 4.51 ;) CFMAIL is an SMTP interface for CF on the server side. How does it have anything to do whatsoever with AOL? accommodates the problems on AOL's end. Do you honestly want Allaire to get accounts with every major ISP so they can check to see if the ISP's stupid procedures mess up the sites? I used to work at a hosting company and the Of course not...but I would think that they would test it on the LARGEST modem community in the world...duh! Why? CF is a server-extension and has nothing to do with browsers or ISP's. focus was on video hosting. Every time we had a broadcast, we would get inundated with tech support calls from AOL users asking us why our site was broken. You can't imagine how many times I had to explain to people exactly why they needed to get a real ISP. AOL uses cached proxy servers and it is bad bad bad. I also do tech support and know just how lame AOL users can be and have used that same explaination as you did ;), however, that doesn't cover the fact that submit buttons or graphics buttons or verity searches wouldn't work using an AOL account until we upgraded to 4.51 (they worked fine with 1.5, 2.0, 2.5, 3.0, 3.1, 4.0 and 4.1) from 4.5 Sounds to me like a problem with your developer's skillset or lack thereof. The really funny calls were the AOL users who said "What do you mean you don't do tech support for AOL? You're the Internet, right?" I understand...we have several hundred customers that use our lines to connect to their AOL accounts and it's tough to explain to them why their AOL mail doesn't work ;) AOL works fine over TCP/IP. -- Reuben King mailto:[EMAIL PROTECTED] Senior Web Consultant Stonebridge Technologies http://www.sbti.com/ Phone: (512) 502-3332 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Does anyone have a CFMAIL problem where '=' are added to message
Hi everyone! We just applied the hot fix from allaire that addresses the CFMAIL problem. This was for the smtp.dll. With the hot fix, I see an '=' character added to the end of certain lines in the body of an email sent with cfmail. The equals sign only appears when there are spaces just before a carriage return/newline. When I back out the hot fix, and go back to the "official" 4.5 version of smtp.dll, the problem goes away. Has anyone seen this before? Is there a fix for it? Thanks! --steve nelson [EMAIL PROTECTED] www.mercurymarine.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Missing primary key error message
This is a multi-part message in MIME format. --=_NextPart_000_0121_01BFA3D7.0EE44400 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I'm working on an application which should allow data to be added to a = database, and afterwards updated. The application works up to the point = where I try to submit the updated data, at which point I get the = following error message: "Primary key field CustomerID not found.=20 The field CustomerID was not found in the Form input. This field is = required in order to do an UPDATE because it is part of the primary key = for the Parts table. The error occurred while processing an element with a general identifier = of (CFUPDATE), occupying document position (1:1) to (1:51)."=20 =20 When I checked the database, the primary key was there. The CFUPDATE = tag in the update template appears to be normal, and had worked prior to = some changes I made to the update form. Could it be possible that = changes to display tags on the update form could affect the functioning = of the update template? I'm quite puzzled, and I'd appreciate some = advice. Sincerely, --- Hubert Earl ICQ#: 16199853 I develop maintain web sites internationally. I also build web = applications using CGI scripts written in Perl. I accept subcontracting = work. **Personal web site: http://www.geocities.com/SiliconValley/Peaks/8702/ (please remember to view this with a sense of humour!) **Business web page: http://home.talkcity.com/MigrationPath/hearl/ --=_NextPart_000_0121_01BFA3D7.0EE44400 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2 DIVFONT face=3DArial size=3D2Hi,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2I'm working on an application which = should allow=20 data to be added to a database, and afterwards updated.nbsp; The = application=20 works up to the point where I try to submit the updated data, at which = point I=20 get the following error message:/FONT/DIV DIVnbsp;/DIVFONT face=3DArial size=3D2 DIV"Primary key field CustomerID not found. /DIV DIVnbsp;/DIV DIVThe field CustomerID was not found in the Form input. This field is = required in order to do an UPDATE because it is part of the primary key = for the=20 Parts table./DIV DIVnbsp;/DIV DIVThe error occurred while processing an element with a general = identifier of=20 (CFUPDATE), occupying document position (1:1) to (1:51)." /DIV DIV/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2When I checked the database, the = primary key was=20 there.nbsp; The CFUPDATE tag in the update template appears to be = normal, and=20 had worked prior to some changes I made to the update form.nbsp;Could = it be=20 possible that changes to display tags on the update form could affect = the=20 functioning of thenbsp;update template? I'm quite puzzled, and I'd = appreciate=20 some advice./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Sincerely,/FONT/DIV/FONT/DIV DIVFONT face=3DArial size=3D2---BRHubert EarlBRICQ#:nbsp;=20 16199853/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2I develop amp; maintain web sites=20 internationally.nbsp; I also build web applications using CGI scripts = written=20 in Perl.nbsp; I accept subcontracting work./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2**Personal web site:nbsp; A=20 href=3D"http://www.geocities.com/SiliconValley/Peaks/8702/"http://www.ge= ocities.com/SiliconValley/Peaks/8702//ABR(please=20 remember to view this with a sense of humour!)/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2**Business web page:nbsp; A=20 href=3D"http://home.talkcity.com/MigrationPath/hearl/"http://home.talkci= ty.com/MigrationPath/hearl//A/FONT/DIV/BODY/HTML --=_NextPart_000_0121_01BFA3D7.0EE44400-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFmail and CRLF!!!
In [EMAIL PROTECTED], Jennifer ([EMAIL PROTECTED]) in a fit of unbridled passion, wrote: At 11:29 AM 4/11/00 -0700, you wrote: I am using Que Mail and Cf 4.5 for linux. If I send a mail message with more than one line my mail server will not send it because it is sending bare LF. read: http://cr.yp.to/docs/smtplf.html After an attempt to send a message with a bare LF, Cfmail will no longer even try to send mail until the service is restated. Has anyone experienced this before? Is there a fix?? Grr I'm not familiar with the problem, but if you are really running 4.5, you might want to upgrade to 4.5.1, which was released late last week. If there is a fix, it would probably be included. I don't have a solution for this fellow's problem, but I should mention that there is no 4.5.1 update for Linux available. -- Reuben King mailto:[EMAIL PROTECTED] Senior Web Consultant Stonebridge Technologies http://www.sbti.com/ Phone: (512) 502-3332 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.