Getting CF to display value, not variable
For the app I am working on, the "power users" are given a maintenance screen. From this screen, they can build a free-form description. But, they need to be able to include dynamic data in the description. They are entering variable names in the description wrapped in # signs. But, I cannot figure out how to get CF to realize that the data inside the variable needs to be evaluated as well as the data itself. I tried using the Evaluate function, but it blew up when it hit the # sign. Sorry if this is a simple question, but I only get to do CF part time, and appreciate any help. Thanks, Steve ----- Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. http://www.mscdirect.com - This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any copies of it. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Issue with text database on Unix
Yup. Still treated is as numeric. I wound up having to put a dummy row in the file with text in those columns to force the driver to treat them as text. Ugly, but it works. Steve -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 7:10 PM To: CF-Talk Subject: Re: Issue with text database on Unix have you tried saving the CSV file with double quotes (") around the text column? Dick On Tuesday, August 27, 2002, at 12:55 PM, Steven Monaghan wrote: > I configured a data source, and can now query any csv file I drop into > a > directory. The only issue I am having, is that sometimes, a "text" > column > only has numeric data. The driver assumes that since the column only > contains numeric data, that the column is numeric. So, any reference > to > this column as a string (ie DESCRIPTION NE '') fails on a datatype > error. > > Does anyone know how to tell CF/Merant ODBC Text driver that this > column is > a text column? > > TIA, > Steve Monaghan > > - > Steven Monaghan > Oracle DBA / Cold Fusion Developer > MSC Industrial Direct Co., Inc. > http://www.mscdirect.com > - > > > This e-mail is intended for the use of the addressee(s) only and may > contain > privileged, confidential, or proprietary information that is exempt > from > disclosure under law. If you are not the intended recipient, please > do not > read, copy, use or disclose the contents of this communication to > others. > Please notify the sender that you have received this e-mail in error by > replying to the e-mail. Please then delete the e-mail and destroy any > copies of it. Thank you. > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Issue with text database on Unix
I configured a data source, and can now query any csv file I drop into a directory. The only issue I am having, is that sometimes, a "text" column only has numeric data. The driver assumes that since the column only contains numeric data, that the column is numeric. So, any reference to this column as a string (ie DESCRIPTION NE '') fails on a datatype error. Does anyone know how to tell CF/Merant ODBC Text driver that this column is a text column? TIA, Steve Monaghan ----- Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. http://www.mscdirect.com - This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any copies of it. Thank you. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem writing query result to file
Nevermind... The process is to be run by only one person, so it doesn't protect against multiple people running at the same time. The person double-clicked the link, causing the process to run twice simultaneously, creating the issue. If it continues to happen, I'll use unique file names to eliminate the problem. Thanks again, Steve ----- Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. http://www.mscdirect.com - -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 6:00 PM To: CF-Talk Subject: RE: Problem writing query result to file I think you'd have two choices... 1. CFLOCK the tag (not recommended) 2. build up a string in the CFOUTPUT then do a single Both options will fix your problem, but the second one will be MUCH faster (assuming you are not memory constrained) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis -Original Message- From: Steven Monaghan [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 2:28 PM To: CF-Talk Subject: Problem writing query result to file I am using CFFILE to create a file using "write" and then append about 10,000 lines to the file by using cfoutput over a set of query results. Sporadically in the file, it puts two sets of data on the same line, and leaves the next line blank. It happens a few dozen times in this 10,000 line file, so I can't ignore it. Has anyone ever seen this behavior? Any remedies? I am running CF5 on Solaris. Thanks, Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. http://www.mscdirect.com - This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any copies of it. Thank you. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problem writing query result to file
I am using CFFILE to create a file using "write" and then append about 10,000 lines to the file by using cfoutput over a set of query results. Sporadically in the file, it puts two sets of data on the same line, and leaves the next line blank. It happens a few dozen times in this 10,000 line file, so I can't ignore it. Has anyone ever seen this behavior? Any remedies? I am running CF5 on Solaris. Thanks, Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. http://www.mscdirect.com - This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any copies of it. Thank you. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Oracle version of TOP
What version are you on? In 8.1 (8i) and above, you can do the following: SELECT Empno, Ename, Job, Mgr, Hiredate, Sal FROM (SELECT Empno, Ename, Job, Mgr, Hiredate, Sal FROM Emp ORDER BY NVL(Sal, 0) DESC) WHERE ROWNUM < 6; For 8.0 and below, you cannot do an order by in a nested select, but you can cheat by doing the following: SELECT Empno, Ename, Job, Mgr, Hiredate, Sal FROM (SELECT Empno, Ename, Job, Mgr, Hiredate, Sal FROM Emp union SELECT 1,2,3,4,5,6 from dual where 1=2) WHERE ROWNUM < 6; The union forces a sort (in ascending order only!) and tricks oracle into sorting. Here's a link that should help... http://www.jlcomp.demon.co.uk/faq/top_sql.html Steve --------- Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. http://www.mscdirect.com - -Original Message- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 2:31 PM To: CF-Talk Subject: Re: OT: Oracle version of TOP VAN VLIET, SCOTT E (SBCSI) wrote: >Sorry for the OT, but do any of you know the Oracle function for selecting >the top n records. (ie. SELECT TOP 10 * FROM TABLE - in SQL). > >Thanks! > >Scott > rowcount is similar but my oracle skills have bit rotted :-( i think :-) z __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Meet my tables
If you are using Oracle, there is the CONNECT BY clause that is designed for use with Hierarchical data. I'm not sure if there is corresponding functionality in your database, but this may give you a starting point... Steve - Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. http://www.mscdirect.com - -Original Message- From: Jason Davis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 3:20 PM To: CF-Talk Subject: Meet my tables Meet my Products table: CREATE TABLE [Products] ( [Product_id] [int] NOT NULL , [Product_title] [varchar] (200) NULL , [Category_id] [int] NOT NULL , ) Each product has a category, meet my categories table: CREATE TABLE [Categories] ( [Category_id] [int] NOT NULL , [Category_parent] [int] NULL , [Category_title] [varchar] (200) NULL , [Category_count] [int] NULL DEFAULT (0) ) As you can see, each category has a Category_parent which symbolize the above category (categories are sorted hirarchly). Can I do some kind of a loop that will run for each Category_id, and store in Category_count the number of Products available in that category, and all of the hirearchy categories beneath? i.e - if I have the following categories: (1) Printers (2) Laser (category_parent=1) (3) Ink (category_parent=1) and the following products: HP LaserJet (category_id = 2) HP Deskjet (category_id = 3) Canon BJ200D (Category_id = 3) category count will be: (1) Printers => 3 (1+2) (2) Laser => 1 (3) Ink => 2 Help!? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL indexing
The answer is a definite maybe. I'm Oracle familiar, not SQL Server, but if the data is skewed in any of those columns(90%=0 10%=1) then you may get some benefit when selecting the smaller value. Also, Oracle has special indexes for columns with low cardinality called bitmap indexes. These are amazing for static data, but can really slow down inserts and updates on these tables. You might want to see if SQL Server has something similar. HTH, Steve - Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. http://www.mscdirect.com - -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 17, 2002 2:26 PM To: CF-Talk Subject: OT: SQL indexing Is there any benefit to indexing a "tinyint" field that is used as a boolean (either 1 or 0)? I have four fields that work this way and I use them heavily in queries for reporting. They are used in aggregate functions (count and sum) as well as in the where clauses for various queries. I know I could play with the indexes and test the timing, but I only have a live database to work with and don't want to disrupt anything until I feel there will be some significant benefit. Also, along the same lines, I report by grouping output (in SQL - not CF's group=) using the DAY, HOUR and MONTH parts of a datetime stamp. Will indexing help when using portions of a datetime field in this way, as opposed to considering the entire field? BTW - this is using SQL Server 2000 (and I guess the same theory would apply to SQL 7). Thanks! Jeff __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Complete lack of locking...
I inherited an application that uses session variables and has no CFLOCK tags in it at all! All session variables have a CFPARAM in the Application.cfm, but even there it isn't inside a cflock. I was reading the docs and even if I set the locking to "Automatic Read Locking", I don't think I'm protected from potential locking problems. Am I understanding things correctly? Do I need to go through every bit of code, find where a session variable is referenced and put it in a ReadOnly lock, and find where a session variable is updated and put it in a Exclusive lock? TIA, Steve ----- Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Cold Fusion Error on Solaris
We have just taken over hosting of a Cold Fusion website in-house. We are running on Solaris and have been live for just over 2 days without any problems. All of a sudden, everyone trying to connect to the site received the following error: Unix error number 24 occurred: Too many open files This was displayed in a standard Cold Fusion error format. My Sysadmin stopped and started the webserver running on the box, and the problem was resolved. Anyone else had a similar problem and willing to offer some guidance? Thanks, Steve - Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle Help
The Cold Fusion documentation has some good stuff on connecting to an oracle database. You really need to read through the entire section, since depending on your platform there are some very specific issues that must be addressed. http://www.houseoffusion.com/cfdocs1/Administering_the_App_Server/3_Managing _Data_Sources/admin03.htm Steve -Original Message- From: Simon Whittaker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 12:20 PM To: CF-Talk Subject: Oracle Help Hello there, I need some help with Oracle - I am not able to connect to my oracle dbase from within cf administrator - it simply gives the not verified message. The trouble is I am not entirely sure what the host string is supposed to look like in the input box - is it dbasename/username@hostname or nothing like the above? I hope someone can help with this. Cheers Simon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT - move Oracle database from Solaris to Intel
Create an empty database there, along with tablespaces whose names match the ones on your Solaris box. Then, export/import should work fine, unless I'm forgetting something... - Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - -Original Message- From: Mike Amburn [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 1:33 PM To: CF-Talk Subject: OT - move Oracle database from Solaris to Intel Suppose I have a large Oracle database running on a Solaris box. If I had an Intel box that run the same version of Oracle, what would be necessary to move the database over and running it there? In other words, is it just a simple export or would I need to do a lot of modifying and converting? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Still need a little help
Use this for a Microsoft database... update tbl_users set fullname = firstname & " " & lastname where firstname = '#Trim(form.firstname)#' and lastname = '#Trim(form.lastname)#' ----- Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 1:24 PM To: CF-Talk Subject: Still need a little help As stated before, i was thinking insert when i should have been thinking update. still have not got it working just right. want to merge two populated fields into a third field. in this case take FIRSTNAME and LASTNAME which are separate fields and merge them into a new column FULLNAME. update tbl_users set fullname = '#firstname# #lastname#' where firstname = '#Trim(form.firstname)#' and lastname = '#Trim(form.lastname)#' ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE:
Would this work? SELECT db1_email as email_field, FROMdb1 union SELECT db2_email as email_field, FROMdb2 union SELECT db3_email as email_field, FROMdb3 body - Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 11:12 AM To: CF-Talk Subject: Hello, I am querying 3 tables that all contain email addresses. What I want to do is send an email using all the email addresses. I just want to make sure there aren't duplicate e-mail when i sent the email. I need some advice on how to remove duplicates. --- i've got the cfquery ... SELECT db1_email, db2_email, db3_email FROMdb1, db2, db3, -- I need some advice on how to remove dupplicates -- I've got the beginning of the cfloop/cfmail ... body ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL quicky
Try: select "(" & left(Str(telephone), 3) & ") " & mid(Str(telephone), 4, 3) & "-" & right(Str(telephone), 4) from ... Just coding off of the top of my head, so definitely no guarantees. The idea is that the Str function will eliminate the decimal point. If if doesn't ,try: select "(" & left(Str(telephone), 3) & ") " & mid(Str(telephone), 4, 3) & "-" & mid(Str(telephone), 7,4) from ... Steve - Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 12:54 PM To: CF-Talk Subject: RE: SQL quicky Yes I am trying to format a phone number (it's kept in the database as 1234567890) for an output form. The problem is that the usual formatting ()won't work for this output so I'm trying to move the formatting to inside the sql query. This formats fine: Gives the result: (123)456-7890 #TELEPHONE# BUT I need it to loop through a 2ndary query and this does not work: Gives result 1234567890.0 #TELEPHONE# Someone sent me the code (#insert("-",foo,6)# but this just gives me a result of (123456-7890.0 and I'm not sure how to get the other ) and how to get rid of the decimal Anyways I find it all kind of weird that that is the only formatting that is screwy- all the others (ie: city, state zip) etc are fine. Any ideas? -Original Message- From: Stephen Hait [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 3:16 PM To: CF-Talk Subject: RE: SQL quicky Sorry, I don't understand what you're trying to accomplish here. Are you trying to output a value obtained from a query to a web page or add formatted data to a database table or something else? > That's what I had originally. It works fine for my forms that pull > up individual records. However, upon doing the bulk records I needed > to change how my queries sat. All the related queries are a QUERY> within a query.( QUERY2> ) And for some reason the > formatting of telephone now will not I'm not sure why, > so I thought I'd try to format it within the sql statement instead. > > -Original Message- > From: Stephen Hait [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 03, 2001 2:14 PM > To: CF-Talk > Subject: RE: SQL quicky > > > This is not exactly within a cf sql statement, but... > > If you can be sure that your phone numbers are 10 digit strings you > can format your output like this: > > > > tel=(#left(tel,3)#) > #mid(tel,4,3)#-#right(tel,4)# > > The output would look like this: > tel=(800) 555-1212 > > > How do I format a phone number (###) ###- within my cf sql > > statement? My backend is sql 2000. Thanks in advance. > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Important - For a project -- please help
The order of your statements is incorrect. It should be... SELECT count(t.File) as file3, g.File, t.File FROM tblfile t, gilway12 g WHERE t.File=g.File GROUP BY g.File Steve - Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - -Original Message- From: Julia Green [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 10:30 AM To: CF-Talk Subject: Important - For a project -- please help Can you use counts with joined tables and a where statement? This seems like a dumb question... Goto: http://www.cheshiregroup.com/gilway/subcount3.cfm My client wants the count of each separate number...next to the number preferably... This is tricky because there is 2 tables, one that takes the input of the form with the customer's number(tblfile), and the other that has all the valid numbers (gilway12). I got just the valid numbers to come up on subcount3.cfm, by using aliases and a where statement and joining tables. Then he said he wanted a count and I can't get it to work with the code... Below is the sql code for the statement using File in both tables... I keep getting errors around the WHERE statement when it worked in subcount3.cfm... SELECT count(t.File) as file3, g.File, t.File FROM tblfile t, gilway12 g GROUP BY g.File WHERE t.File=g.File produces the incorrect code. SELECT count(File) AS file2 FROM tblfile SELECT t.File, g.File FROM tblfile t, gilway12 g WHERE t.File=g.File ORDER BY t.File DESC produces subcount3.cfm From: "Mark Stewart" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, October 04, 2001 10:17 AM Subject: Stored Procedure Question > All, > > I've been using stored procedures for a while now but I've never really > needed to create one that returned multiple result sets. My question is, > how do you do that? Would someone be kind enough to show me a little > pseudo code or a snippet of code on how to accomplish this? > > I assume in cf, I would build my cfstoredproc like this: > > > > > > > But I draw a blank when it comes to building the stored proc in SQL > Server where it would return multiple results. I assume the following: > > create procedure [procedure] as > > select ... from ... where... > > select ... from... where... > > How do I specify what query goes with what result? > > Thanks for your help! > > Mark > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strangest Problem in a long time
What about creating a database view with the corrected name? This way, you don't have to change your Cold Fusion generated SQL, except for the table/view name or the actual database layout. Steve - Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - -Original Message- From: Leon Oosterwijk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 6:08 PM To: CF-Talk Subject: RE: Strangest Problem in a long time Dave, I'm using this in a large site where the SQL is generated based on the fieldname. fieldnameXXcolumnname is translated into: Insert into fieldname (columname) values ('#fieldnameXXcolumname#'); I will have to come up with an extra conversion step to change the name of these fields and then change them back. What a bummer. Leon -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 4:57 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: Strangest Problem in a long time > Because of the database_design I cannot change the name of my > fields. Is there any way I can turn this feature off? No, you can't turn the feature off, but you can certainly change the names of your form fields - there's no reason that they have to be identical in name to the database fields. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: oracle help
Try... Where open_date > to_date('01-JAN'||to_char(sysdate, ''), 'DD-MON-') This will give you midnight of the current year. HTH, Steve ----- Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 3:44 PM To: CF-Talk Subject: oracle help I have a DTS package on my sql server that pulls from an oracle database. There is a column called open_Date and I want it to pull the data starting with the year 2001 till it is no longer needed. Then in 2002 I need it to do the same thing start pulling all records in 2002 till current. I was trying sysdate but I cant make it do the dynamic stuff like that. I looked at the date column oracle command but am not sure on it. Please help if you can and if you need more info then email me. Thanks in advance. Joshua Tipton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Query Quandary
Assuming you have not listed any amenities more than once for a property: select propertyid, count(*) from property_amenities where amenityid in (#amenity_list#) having count(*) = #the_number_of_items_in_amenity_list# Steve - Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 2:56 PM To: CF-Talk Subject: SQL Query Quandary I've got three tables describing lodging properties and their amenities, as shown below. If a lodging property has more than one amenity (for example, hot tub, min-ibar, fireplace, etc) then there are multiple records for that property in the property_amenities table. Pretty basic stuff. properties - propertyid autonumber propertynametext amenities - amenityid autonumber amenitydescription text property_amenities - property_amenityid autonumber propertyid number amenityid number I need to form a search for all properties that meet the criteria of having all of the amenities that a user asks for. Not an OR, but, logically an AND - all properties that have ALL of the amenities ask for. The user interface is a form with check boxes, so that when the form is submitted I have a comma delimited list of amenityid's to work with. Given the above table structure, I have no idea how to form this query. Thanks for any assistance, Jim ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: AND & OR placement in SQL
My suggestion when mixing AND & OR is to wrap everything in parentheses. This way there can be no confusion. SELECT left(subject,20) as newsubject, * FROM advert_details WHERE ( town = '#form.towny#' OR ( natpaid = Yes AND nationwide = Yes ) ) AND category = '#form.category#' Is that the correct grouping? Steve ----- Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 1:28 PM To: CF-Talk Subject: AND & OR placement in SQL Hi, Bit confused on the placement of AND & OR operators in the same query. SELECT left(subject,20) as newsubject, * FROM advert_details WHERE town = '#form.towny#' OR (natpaid = Yes AND nationwide = Yes) AND category = '#form.category#' Before form.category is defined, the query works as I want it to. But once form.category is defined, will the addition of an AND operator muck up the query? Thanks Will ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Monitoring of Cold Fusion logs
I am a new Cold Fusion Developer/Administrator and was wondering if anyone has any suggestions on what to check my logs for. I'm running on Solaris, and I have a pretty generic log monitoring script that I can use, but I'm not sure what to look for, meaning which messages are critical, and which are informational. Any guidance would be appreciated. Thanks in advance, Steve ----- Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL - Oracle Functions
Not one function, but a combination of two should serve your purpose... select A.event_id, to_char(A.event_date,'mm/dd/ hh24:mi:ss'), A.event_type, A.event, B.name, B.description from table_a A, table_b B where upper(B.name) = substr(upper(a.event), instr(a.event, '.', -1), 2) A quick explanation, substr(string, start position, length) We know the field and the length, so now we need the start position instr(string, field to find, start position) Putting a start position of -1 tells oracle to work from the end of the list. Hope this works, since I don't have your data to test. If you still have problems, let me know. Steve ----- Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 10:46 AM To: CF-Talk Subject: SQL - Oracle Functions Let me see if I can explain this clearly...I am trying to join 2 tables, using a field from table A to match just a part of a field in table B (re-working of my tables and what I store will fix this, but I want to see if it can be done in my current setup) select A.event_id, to_char(A.event_date,'mm/dd/ hh24:mi:ss'), A.event_type, A.event, B.name, B.description from table_a A, table_b B where B.name = "a part of A.event" A.event is a long string of data, stored from a system log, which I can parse out the name for display purposes with the following cf code: #Ucase(ListLast(GetToken(event, 2, chr(10)), '.'))# select A.event_id, to_char(A.event_date,'mm/dd/ hh24:mi:ss'), A.event_type, A.event, B.name, B.description from table_a A, table_b B where upper(B.name) = '#Ucase(ListLast(GetToken(A.event, 2, chr(10)), '.'))#' The above does not work, since it does not know the value of A.event. Are there any Oracle functions that can achieve this result? If not I will just rework the table to parse out the name prior to insertion and store it in table A to do a straight join (A.name = B.name) Thanks, Scott ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Find in-coming form fields
I have a situation where I need to accept a form, but I don't know the names of the form fields that are set. I can't access the posting form, since it's hidden in someone else's app, so I can't find the names that way. I want to build a simple page where I can accept the post, then dump out all of the values in memory into an e-mail. I looked at the tag, but that requires the variable name. I'm new to Cold Fusion, so please indulge me if this is a simple task. Thanks for any help, Steve ----- Steven Monaghan Oracle DBA / Cold Fusion Developer MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RE: Mystery:Code dissappears/changes on Unix Server
Here's a possible suggestion: case of the file name. On Unix, the file names are case sensitive. So, maybe a piece of code has the wrong case in a link. Or when you deploy the file to your server, you are putting it in the wrong case, since MS doesn't care about case you may just be putting a second file out instead of overwriting the original file. I haven't had the specific problems you guys are reporting, but have had file name case problems before on my Unix box. Steve --------- Steven Monaghan Oracle DBA MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 11:08 AM To: CF-Talk Subject: Re:RE: Mystery:Code dissappears/changes on Unix Server EC, would love to but there is absolutely no consistency in the errors. Could be a what looks like a typing error, could be a line of code, could be what looks like reversion to the prior code, or it could be code that looks like somebody else (highly unlikely) touched it -- causing the "Who did this" reaction. It is never the same .cfm and has happened across programs. It is not every day or week or month. It is occassional and can always be corrected although finding out what the problem is takes time especially when the program was working the night before. I know this sounds like going to a car mechanic and saying occasionally, sporadically, I hear a "boink" and asking them to fix it. And, in my lifetime, only once and very recently, I sheepishly made this crazy kind of report to my mechanic, expecting the usual -- if it happens again call me -- and, to my complete and utter surprise, it turned out to be something very specific for which they had a fix. So, I'm hoping that is true in this case too! Carol Carol L. Bluestein Senior Programmer NYS Office of Real Property 518-486-6335 [EMAIL PROTECTED] Reply Separator Subject:RE: Mystery:Code dissappears/changes on Unix Server Author: [EMAIL PROTECTED] Date: 9/14/01 11:51 AM More information is probably needed to make any good suggestion. Senarios? Error messages? Examples? :) EC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 11:04 AM To: CF-Talk Subject: Mystery:Code dissappears/changes on Unix Server Hi all. We have been experiencing code problems on our Unix server. Pages that are working on day 1 are NOT working on day 2. It is NOT multiple developers hitting the same code at the same time as far as we can track. It is NOT that changes are not being received by the server, we can see the effects of changed code. We are working on an NT platform with our data stored on SYBASE IQ12 and ColdFusion on a UNIX platform. Any and all possible solutions would be appreciated and will be explored. Thanks, Carol Carol L. Bluestein Senior Programmer NYS Office of Real Property 518-486-6335 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Recall: REGEX to strip special characters
Steven Monaghan would like to recall the message, "REGEX to strip special characters". This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: REGEX to strip special characters
Here's what I did... Steve - Steven Monaghan Oracle DBA MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 13, 2001 3:34 PM To: CF-Talk Subject: Re: REGEX to strip special characters try x=ReReplaceNoCase(x, "[^a-z0-9]", "", "All"> hth dick At 1:32 PM -0400 9/13/01, Joshua Miller wrote: >Anyone know of a REGEX to strip special characters from a string? > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF_BOOLSEARCH tag
Thanks for the help. I did indeed find the tag. I was looking for a file named cf_boolsearch.cfm, not boolsearch.cfm. Also, thanks for the link to the tag source. I was modifying the source to work with an Oracle database (which is case sensitive, unlike the Sql Server db that was being used). If anyone wants a copy of the modified tag, please let me know. Steve - Steven Monaghan Oracle DBA MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 13, 2001 10:41 AM To: CF-Talk Subject: Re: CF_BOOLSEARCH tag Go to this URL: http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3476C7-2830-11D4-AA 9700508B94F380&method=Full Here you will find this tag as well as an explanation as to what it does. - Original Message - From: "Steven Monaghan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 13, 2001 9:26 AM Subject: CF_BOOLSEARCH tag > I am new to Cold Fusion have inherited an application written by outside > consultants that is being brought in-house. In the code I see a tag > CF_BOOLSEARCH. I have not installed any custom tags, so I don't think it is > one, yet I can't find any documentation/information on this tag. > > Can anyone help? > > Steve > - > Steven Monaghan > Oracle DBA > MSC Industrial Direct Co., Inc. > Melville, NY > [EMAIL PROTECTED] > http://www.mscdirect.com > - > > > This e-mail is intended for the use of the addressee(s) only and may contain > privileged, confidential, or proprietary information that is exempt from > disclosure under law. If you are not the intended recipient, please do not > read, copy, use or disclose the contents of this communication to others. > Please notify the sender that you have received this e-mail in error by > replying to the e-mail. Please then delete the e-mail and destroy any > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF_BOOLSEARCH tag
I am new to Cold Fusion have inherited an application written by outside consultants that is being brought in-house. In the code I see a tag CF_BOOLSEARCH. I have not installed any custom tags, so I don't think it is one, yet I can't find any documentation/information on this tag. Can anyone help? Steve ----- Steven Monaghan Oracle DBA MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Verity search of PDF's
Yes it can...Just did it here a few weeks ago. Steve - Steven Monaghan Oracle DBA MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - -Original Message- From: Brian Scott Barnett [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 4:57 PM To: CF-Talk Subject: Verity search of PDF's I just got CF 5. Does anyone know if the verity search engine in it can be configured to search PDF documents via text search? FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL help for a brain that's not awake yet
What about using UNION? select count(*) from ( SELECT * as Total FROM Cycles WHERE BrandNameID1_1=#LoopIndex#) union SELECT * as Total FROM Cycles WHERE BrandNameID2_1=#LoopIndex#) union . . . Steve - Steven Monaghan Oracle DBA MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - -Original Message- From: Brian Ferrigno [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 11:52 AM To: CF-Talk Subject: SQL help for a brain that's not awake yet I know the answer to my problem is easy I just can't seem to get my brain functioning today. My problem is that I want to get the number of times an integer ID appears in a list of columns for every row in a table. The integer ID is from an outer SQL statement that I am looping through. An example Current ID = 1 DBColumn 1 DBColumn 2 1 1 2 1 1 1 The result should be 5. The second time I loop through the outer sql statement the ID would be 2 and the result should = 1 Here is what the current SQL statement looks like: SELECT Count(*) as Total FROM Cycles WHERE (BrandNameID1_1=#LoopIndex# OR BrandNameID2_1=#LoopIndex# OR BrandNameID3_1=#LoopIndex# OR BrandNameID1_2=#LoopIndex# OR BrandNameID2_2=#LoopIndex# OR BrandNameID3_2=#LoopIndex# OR BrandNameID1_3=#LoopIndex# OR BrandNameID2_3=#LoopIndex# OR BrandNameID3_3=#LoopIndex#) This however returns only the number of rows that have the loop index in it. I know there is probably an easy solution to this but for the life of me I can't think straight today. Any help would be greatly appreciated. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problem with re-direct to other site.
All, We are in the process of trying to bring a website currently hosted externally in-house. As part of the process, I removed all hard-coded references to the URL in the code and set up a web server. Instead of using the DNS, I am testing using IP:port. In my development environment, it appears that any reference to the root directory of the web goes to production. For example, a link that references /index.htm will not go to http://1.1.1.1:80/index.htm. Instead, it will go to http://www.production-site.com/index.htm. This makes it impossible to test. I took a quick look at the both the Netscape and the Cold Fusion administration applications, but don't see any settings that would control the root being something other than the server itself. Does anyone have an idea where to look? I already reviewed all of the code, and there are no references to the other address in the code. HELP!!! Thanks in advance, - Steven Monaghan Oracle DBA MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists