RE: Help with Regular expression
Thanks, I figured it out. Thanh. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 7:38 PM To: CF-Talk Subject: RE: Help with Regular _expression_ Why not simply use replaceList(). Str = replaceList(str, .,1st,2nd,3rd,4th,5th,6th,7th,8th,9th,10th,, ,first,second,third,fourth,fifth,sixth,seventh,eighth,ninth,tenth, and ) then str = reReplaceNoCase(str, ^The[[:space:]], ) then str = reReplace(str, [^[:alnum:][:space:]], , all) _ From: Thanh Nguyen [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 May 2004 1:35 p.m. To: CF-Talk Subject: Help with Regular _expression_ Hi All, I tried to do this regular _expression_, but having a hard time getting the result I want. So any help would be appreciated. Here's what I tried to achieve. 1. remove The from in at the beginning of the string. 2. replace period with space. 3. Numerals are treated as though spelled out. 4. the string '1st' through '10th' are treated as if spelled out (e.g first, second..) 5. Ampersands are treated asthough spelled out as and and put spaces between the words and ampersands. 6. Remove nonalphanumeric characters. Thanh Nguyen _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Help with Regular expression
Hi All, I tried to do this regular _expression_, but having a hard time getting the result I want. So any help would be appreciated. Here's what I tried to achieve. 1. remove The from in at the beginning of the string. 2. replace period with space. 3. Numerals are treated as though spelled out. 4. the string '1st' through '10th' are treated as if spelled out (e.g first, second..) 5. Ampersands are treated asthough spelled out as and and put spaces between the words and ampersands. 6. Remove nonalphanumeric characters. Thanh Nguyen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Repost: Recommendation for Job Posting system
I'm looking for a career center, or job posting application. Anybody have a recommendation? Thanks. Thanh Nguyen -Original Message- From: Thanh Nguyen [mailto:[EMAIL PROTECTED] Sent: Friday, August 15, 2003 3:20 PM To: CF-Talk Subject: Recommendation for Job Posting system Anyone have a recommendation for jobs posting, jobs search system? Thanh Nguyen ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Recommendation for Job Posting system
Anyone have a recommendation for jobs posting, jobs search system? Thanh Nguyen ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Regex help
Can someone assist me in writing a regex to remove all common words such as inc., corp., llc., ltd. from a company name field. Thanks Thanh Nguyen ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Webtrends and fusebox
Can someone point me to an article/webpage that shows how to set up webtrends with fusebox applications? Thanks. Thanh Nguyen Ext: 590 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Reset CFMX Admin Password
Hi all, How do I reset the Admin Password for CFMX? Thanks. Thanh ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Reset CFMX Admin Password
Thanks a lot. Thanh -Original Message- From: Jeffry Houser [mailto:jeff;farcryfly.com] Sent: Friday, November 08, 2002 12:01 PM To: CF-Talk Subject: Re: Reset CFMX Admin Password Open up the neo-security.xml file. Look for the line (something like this): var name='admin.security.enabled' boolean value='true'/ /var Change true to false. Restart CF Server. You can change the password normally ( cfide/administrator/security/cfadminpassword.cfm ) At 11:34 AM 11/8/2002 -0800, you wrote: Hi all, How do I reset the Admin Password for CFMX? Thanks. Thanh ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Inserting Unique Values
You can do this in Access. right click on table 2, click on copy. now right click anywhere within the table tab. then click on paste. type in the name of your table1. and select append data to existing table. if you set the email field in table1 as primary key. this will take of of the duplicate emails for you. -Original Message- From: CF- Student [mailto:mail;extralligence.com] Sent: Friday, October 18, 2002 8:20 AM To: CF-Talk Subject: Inserting Unique Values Hi Everyone, Need help with this query. I am trying to add data from one table to another.(Same DB) Table 1 contains the following fields: id, emailaddress, company, details. Table 2 contains id, emailaddress, company. emailaddress field is the primary key in both the tables. Table 1 has 5000 rows of records. Table 2 has 9000. I want to add the email addresses from Table 2 TO the email addresses in Table 1. The problem is that there are some records (at least 2000) in Table 2 which are already present in Table1. I want to add only those rows from Table 2 to Table 1 which are not present in Table 1. That is the email addresses should be unique. I do not want Table 1 to have duplicate records. Can someone help me with the CF syntax please. I am absolutely new to DataBases and CF. I am using Access 2000 and CF5. Many Thanks in Advance, Ben (CF-STUDENT) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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: CF 5 not starting
I got the same problem at home. I gave me this error cannot Init xmlparser.dll. when I tried to start CF 5 Service manually. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 1:47 PM To: CF-Talk Subject: CF 5 not starting I've got a new machine at home and I installed CF 5 on it. I then installed CFMX over it so I can have both versions for testing. Something has gone terribly wrong. The CF 5 service will not start. It continues to throw an error 1067 (service terminated unexpectedly). I've uninstalled MX, repaired CF 5, uninstalled CF 5, reinstalled it, etc. No dice. Anyone have a clue as to what was added to the system by CFMX that could have killed CF 5 so? Some file or registry entry? Thanks. Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Macromedia - oops!
I sometimes got this error on my site. Anybody knows how to fix it? -Original Message- From: SFN Development [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 7:42 PM To: CF-Talk Subject: Macromedia - oops! Error Diagnostic Information ODBC Error Code = 08001 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found. SQL = select * from objects where objectid = '7A4DB8DA-D55A-11D6-840C00508B94F85A' Data Source = WEBCONTENT The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (99:2) to (99:61) in the template file C:\PROGRAM FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\OBJECTSTORE\CFA_CONTENTOBJECTG ET.CFM. Date/Time: 10/01/02 22:29:08 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
How to prevent multiple logins?
How do I prevent multiple users loggin in a a same time using the same account? I'm using session variables to track auth users. Thanks. Thanh __ 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: Can't use UNION
Thanh Nguyen would like to recall the message, Can't use UNION. __ 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
RE: Can't use UNION
remove order by. -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 2:55 PM To: CF-Talk Subject: OT: Can't use UNION I am putting together an application and I canot use UNION, here is my query that I have used in the past, does anyone have a solution that would not use UNION? SELECT state, state_abv FROM #request.taxStateTable# UNION ALL SELECT province AS state, province_abv AS state_abv FROM #request.taxCanadaTable# ORDER BY 1 Thank you Paul Giesenhagen QuillDesign __ 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: Wierd Form Error
can you see it using form variable? form.due_date -Original Message- From: John Gedeon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 2:27 PM To: CF-Talk Subject: Wierd Form Error i am using cf_formurl2attributs call I have a javascript function: function mkdate() { monBox = document.trf.month; dayBox = document.trf.day; yearBox = document.trf.year; var month = monBox.options[monBox.selectedIndex].value; var day = dayBox.options[dayBox.selectedIndex].value; var year = yearBox.options[yearBox.selectedIndex].value; var ddate = month + - + day + - + year; document.trf.due_date.value = ddate; } and select boxes select name=month onchange=mkdate(); option value=0 selectedMon option value=1Jan option value=2Feb option value=3Mar option value=4Apr option value=5May option value=6Jun option value=7Jul option value=8Aug option value=9Sep option value=10Oct option value=11Nov option value=12Dec /select select name=day onchange=mkdate(); . /select select name=year onchange=mkdate(); . /select input type=hidden name=due_date value= And so on the submit I try to access attributes.due_date like any other form or url variable and it tells me it doesnt exist. In the cf debug info due_date is listed as a form field but it is not included in the form fieldnames variable. When I changed the name from due_date to ddate it worked anyone know why? John Proverbs 3:5 Trust in the Lord with all your heart and lean not on your own understanding; __ 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: CF encrypt() and SQL
What are the parameters of the key? Min/max length? characters? -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 1:30 PM To: CF-Talk Subject: Re: CF encrypt() and SQL I don't remember where I got this... some generous person on this list perhaps, but I have been using it with much success. ENCRYPT: cfset encrypted=encrypt(form.pwd,key) cfset encrypted=tobase64(encrypted) store in database DECRYPT: query database cfset decrypted=tobinary(qResults.pwd) cfset decrypted=tostring(decrypted) cfoutput#decrypt(decrypted,'key')#/cfoutput At 10:26 AM 9/10/02, you wrote: Ok here's what's going on: I'm using the encrypt() function to encrypt data as it goes into my database. Like this: cfquery datasource=#application.dsn# name=insertencrypteddata UPDATE mytable SET myvalue= '#encrypt(#FORM.myvalue#,mykey)#' WHERE id = #FORM.id /cfquery Some of you probably already know what my problem is. Sometimes this works fine. Other times the encrypted values have characters in them that (like single-quote) that break my query. Anybody been through this? Solutions? Thanks in advance Willy - Willy Ray Web Applications Developer Certified Advanced ColdFusion Developer Westminster College __ 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
RE: Coldfusion Training IN SoCal
Doug, After an hour searching the web, I found one. here's the link if you 're interested. http://www.roundpeg.com/home.cfm?main=trainingaction=classinfoclassid=109; locid=29 Thanh. -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 12:11 PM To: CF-Talk Subject: Re: Coldfusion Training IN SoCal I have looked also, and do not know of any. There are several that offer the certs and such, but no luck on the actual training aspect. I live in Orange and have checked Irvine, Anaheim, Santa Ana and a few other areas. Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Thanh Nguyen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 11:02 AM Subject: OT: Coldfusion Training IN SoCal Are there any ColdFusion training schools in Southern California? Thanh __ 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
OT: Coldfusion Training IN SoCal
Are there any ColdFusion training schools in Southern California? Thanh __ 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: Error message in logs
I also get this error. ODBC Error Code = 01000 (General warning)P [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send()) Thanks, Thanh Nguyen -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 28, 2002 5:17 AM To: CF-Talk Subject: Error message in logs Hey everyone, Can someone give me some more insight into this error message? It looks to me like the connection is being dropped but can't find anything on MM's site about this specific message. I am seeing this in my log files on a daily basis about 40-50 occurances of this error. Here is the error message. ODBC Error Code = 01000 (General warning)P [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()). Thanks, Ben __ 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: Large file uploads
Check the archive for answer. I asked this questions before. Basically. It has to do with How much RAM you have on the server. The more RAM you have the larger files you can upload. Thanh. -Original Message- From: chris.alvarado [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 12:04 PM To: CF-Talk Subject: Large file uploads How is everyone dealing with large file uploads? I have a page where a user can use the standard browse upload functionality on a lot of sites. Behind the scenes I am just using the cffile tag etc. However, over a certain file size (seems to be about 10MB) there seems to be a huge bottleneck. The server will then of course start responding slow etc, and ultimately the page may time out or never respond back. There is even the extreme need of being able to upload even larger files, say 50MB+. Does anyone have any suggestions? Thanks for any and all help, -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com -- I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world, because they'd never expect it. -- Jack Handy __ 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
using cf_stockdata, is this legal?
I've been using stockdata custom tag on our website for a long time. Yesterday, my colleague just told me that it's illegal to use it. Is this true? if yes, Is there another way of getting stock info check out this page http://help.yahoo.com/help/us/fin/fin-03.html http://help.yahoo.com/help/us/fin/fin-03.html Thanh Nguyen __ 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
RE: ODBC Error Code = 08001
Yeah. We have a firewall. the webserver is set up as an IP forwarding. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 5:53 PM To: CF-Talk Subject: RE: ODBC Error Code = 08001 Do you have a firewall? -Original Message- From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] Sent: mercredi 3 juillet 2002 12:44 To: CF-Talk Subject: RE: ODBC Error Code = 08001 Could it be a network problem? I have another website connecting to the same server with no problems. Thanks Thanh -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 4:23 PM To: CF-Talk Subject: RE: ODBC Error Code = 08001 That error could also be caused by an over worked sql server and because that query processor cannot grab the query string then the cf server thinks that either the sql server is not running or access was denied. Josh -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 7:15 PM To: CF-Talk Subject: Re: ODBC Error Code = 08001 mabye check the username and password associated with the failing DSN connection Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Thanh Nguyen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 4:08 PM Subject: ODBC Error Code = 08001 Hi all, I've been getting this error on our website. But can't figure out what caused it. have anybody seen this error or knows what could have caused it. This error only occurs once in a while. Error Diagnostic Information ODBC Error Code = 08001 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (74:2) to (74:51). Thanks, Thanh Nguyen __ 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: ODBC Error Code = 08001
Josh, that's what I thought to, I'm running a trace right now. Thanks Thanh -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 7:17 PM To: CF-Talk Subject: RE: ODBC Error Code = 08001 Could be a network problem. The web server is able to get to the sql server but the query processor is either not available or kicking connection. Possibly a bad packet. The first thing I would do would be to run a trace on that db all day then run the index tunning wizard. Then I would start checking my sql dump logs and the regular sql logs just to see if sql is screaming something. -Original Message- From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 8:44 PM To: CF-Talk Subject: RE: ODBC Error Code = 08001 Could it be a network problem? I have another website connecting to the same server with no problems. Thanks Thanh -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 4:23 PM To: CF-Talk Subject: RE: ODBC Error Code = 08001 That error could also be caused by an over worked sql server and because that query processor cannot grab the query string then the cf server thinks that either the sql server is not running or access was denied. Josh -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 7:15 PM To: CF-Talk Subject: Re: ODBC Error Code = 08001 mabye check the username and password associated with the failing DSN connection Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Thanh Nguyen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 4:08 PM Subject: ODBC Error Code = 08001 Hi all, I've been getting this error on our website. But can't figure out what caused it. have anybody seen this error or knows what could have caused it. This error only occurs once in a while. Error Diagnostic Information ODBC Error Code = 08001 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (74:2) to (74:51). Thanks, Thanh Nguyen __ 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: File Size limit with CFFile?
Matt, That's an interesting way to do it. I'll look into that. Thanks. Thanh -Original Message- From: MW [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 4:08 PM To: CF-Talk Subject: RE: File Size limit with CFFile? We had a terrible time with CFFile and uploads. We got not only the memory spike, but an unbelievable spiking of CPU's to 100% for the full duration of the transfer, in our development and production environments, and in test code to isolate the problem. The side effect was that it slowed transfer rates down by a large amount because the CPU's were too busy. The solution was to use a single .asp page with a COM that handles this well with IIS. After the transfer the .asp page does a redirect to a cfm page. Transfer rates are way up, CPU and memory way down. A waste of time and a few bucks (~$150 for the COM), but it solved the problem. I sure hope this is fixed in MX, but I suppose it is a limit to ISAPI and not a poor implementation on the MM side. Matt -Original Message- From: Tony Gruen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 5:26 PM To: CF-Talk Subject: RE: File Size limit with CFFile? Thanh, The restriction is primary available system memory on the server (RAM). CFFILE moves the uploaded file into available system RAM BEFORE writing it to the hard drive. If you're running Windows you will probably see an error 1450 come up if the file is too large. Tony Gruen -Original Message- From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 3:18 PM To: CF-Talk Subject: File Size limit with CFFile? Is there a limit on the file size using CFFILE? I have a simple program that helps clients upload files to our server, but they can't upload files that's over 30 MB. Is this a browser issue or server issue? Thanks, Thanh Nguyen __ 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
OT: MDAC version
Just wondering what version of MDAC should I be using? What's the latest version. Thanks, Thanh Nguyen __ 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
File Size limit with CFFile?
Is there a limit on the file size using CFFILE? I have a simple program that helps clients upload files to our server, but they can't upload files that's over 30 MB. Is this a browser issue or server issue? Thanks, Thanh Nguyen __ 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
ODBC Error Code = 08001
Hi all, I've been getting this error on our website. But can't figure out what caused it. have anybody seen this error or knows what could have caused it. This error only occurs once in a while. Error Diagnostic Information ODBC Error Code = 08001 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (74:2) to (74:51). Thanks, Thanh Nguyen __ 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: ODBC Error Code = 08001
Could it be a network problem? I have another website connecting to the same server with no problems. Thanks Thanh -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 4:23 PM To: CF-Talk Subject: RE: ODBC Error Code = 08001 That error could also be caused by an over worked sql server and because that query processor cannot grab the query string then the cf server thinks that either the sql server is not running or access was denied. Josh -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 7:15 PM To: CF-Talk Subject: Re: ODBC Error Code = 08001 mabye check the username and password associated with the failing DSN connection Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Thanh Nguyen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 4:08 PM Subject: ODBC Error Code = 08001 Hi all, I've been getting this error on our website. But can't figure out what caused it. have anybody seen this error or knows what could have caused it. This error only occurs once in a while. Error Diagnostic Information ODBC Error Code = 08001 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (74:2) to (74:51). Thanks, Thanh Nguyen __ 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
Page cannot be display
Hi, For last 2 days, my website is getting the page canot be display error every time a user goes to a new page. but when they click on refresh, or go back and click on the link again, the page got loaded correctly. Does Anybody know what might have caused this error? Thanks, Thanh Nguyen __ 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
setup an odbc connection from a webserver on the DMZ
I'm trying to setup an odbc connection from a webserver on the DMZ to one of our SQL servers(2kSP1) but cant, I can ping and telnet into SQL Server from the webserver. Please help... Thanks, Thanh Nguyen __ 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
FW: Repost: CFFTP 500 Invalid PORT Command.
My setting are very basic. The Web server is IIS on Win2k The FTP server is the built-in FTP Server of IIS. I keep all the default settings. (didn't change anything). I was able to connect to the server but when trying to list all files/directories, I got that error. any advice? thanks -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 3:25 AM To: CF-Talk Subject: RE: Repost: CFFTP 500 Invalid PORT Command. Does anybody know what causes Error 500 invalid port Command using CFFTP? Which web server are you CFFTPing to Some don't allow FTP access unless it's got the proper header information Also, CFFTP requires a certain amount of responses to work, so if it's a limited FTP server, then it might be causing problems Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
Repost: CFFTP 500 Invalid PORT Command.
Does anybody know what causes Error 500 invalid port Command using CFFTP? Thanks. Thanh __ 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
CFFTP 500 Invalid PORT Command.
Does anybody knows what this error mean? I'ved searched the Allaire forum already but couldnot find solution for this error. It worked fine on our Dev server. but does not work on the Prod server. and I'm using CF 5.0 on Win2k Can someone help please? Thanks Thanh __ 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
list of items with quotes
Help Please How can I convert a list like this list1 = 'CA, NV, AZ, OR, UT'; TO list2 = ' 'CA', 'NV', 'AZ', 'OR', 'UT' ' Thanks __ 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: list of items with quotes
Thanks, Critz. ;) Thanh -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 5:13 PM To: CF-Talk Subject: Re: list of items with quotes oi Thanh!! // function to quote a List function quoteList(lst){ var retList = ; for(i=1;i LTE listLen(lst);i=i+1){ retList = listAppend(retList,' listGetAt(lst,i) '); } return retList; } -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Monday, May 6, 2002, 8:10:32 PM, you wrote: TN Help Please TN How can I convert a list like this TN list1 = 'CA, NV, AZ, OR, UT'; TN TO TN list2 = ' 'CA', 'NV', 'AZ', 'OR', 'UT' ' TN Thanks TN __ 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: list of items with quotes
ahh.. lisfqualify... I totally forgot about the listqualify function. ;) Thanks all, Thanh -Original Message- From: Jared Clinton [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 5:20 PM To: CF-Talk Subject: RE: list of items with quotes Thanh, To do this you can use the 'ListQualify' function. Look in the help references. Jared Clinton NEC Australia -Original Message- From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 7 May 2002 10:11 AM To: CF-Talk Subject: list of items with quotes Help Please How can I convert a list like this list1 = 'CA, NV, AZ, OR, UT'; TO list2 = ' 'CA', 'NV', 'AZ', 'OR', 'UT' ' Thanks __ 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
File Upload using CFFTP
One quick question about CFFTP. How do I get the local file name in the input tag so that the uploaded file will the same name as the local file? Thanks. __ 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
Javascript: onKeydown event
Hi all, Anybody know if Netscape 4.X support onKeydown event? I have the following script, It works in IE and Netscape 6.2 but it doesn't seem to work in Netscape 4.7 script language=JavaScript!-- function handler(e) { var key = (navigator.appName == Netscape) ? e.which : e.keyCode; if (key == 13 || key == 46 || (key 47 key 58)) return true; else return false; } //--/script form input type=text onKeyDown=return handler(event) onKeydown=return handler(event) /form Any Ideas why it doesn't work? Thanks __ 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: Javascript: onKeydown event
Scott, It's a typo. In my template there's only one onKeyDown event. -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 2:09 PM To: CF-Talk Subject: RE: Javascript: onKeydown event Is there any reason you have two onKeyDown events, or is that just a typo? If that is the case (that you have two), NN 6.x and IE are very forgiving when having duplicate attributes, however NN 4.x might be crapping out because of this. HTH +--+---+ | SCOTT VAN VLIET | SBC SERVICES, INC.| | Senior Analyst | ITO Enterprise Tools | | Tel: 858.886.3878| 7337 Trade St. Room 4000 | | Pgr: 858.536.0070| San Diego, CA 92121 | | Email: [EMAIL PROTECTED]| http://www.sbc.com| +--+---+ -Original Message- From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 1:39 PM To: CF-Talk Subject: Javascript: onKeydown event Hi all, Anybody know if Netscape 4.X support onKeydown event? I have the following script, It works in IE and Netscape 6.2 but it doesn't seem to work in Netscape 4.7 script language=JavaScript!-- function handler(e) { var key = (navigator.appName == Netscape) ? e.which : e.keyCode; if (key == 13 || key == 46 || (key 47 key 58)) return true; else return false; } //--/script form input type=text onKeyDown=return handler(event) onKeydown=return handler(event) /form Any Ideas why it doesn't work? Thanks __ 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: Javascript: onKeydown event
worked great !!! thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 2:14 PM To: CF-Talk Subject: Re: Javascript: onKeydown event http://developer.irt.org/script/1214.htm - Original Message - From: Thanh Nguyen [EMAIL PROTECTED] Date: Thursday, April 18, 2002 2:39 pm Subject: Javascript: onKeydown event Hi all, Anybody know if Netscape 4.X support onKeydown event? I have the following script, It works in IE and Netscape 6.2 but it doesn't seem to work in Netscape 4.7 script language=JavaScript!-- function handler(e) { var key = (navigator.appName == Netscape) ? e.which : e.keyCode; if (key == 13 || key == 46 || (key 47 key 58)) return true; else return false; } //--/script form input type=text onKeyDown=return handler(event) onKeydown=return handler(event) /form Any Ideas why it doesn't work? Thanks __ 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
JS: remove an option from the select
How do I remove a selected option from the select list using javascript? anybody knows how to do this? thanks Thanh __ 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
Javascript - Remove an option from the select
How do I remove a selected option from the select list using javascript? anybody knows how to do this? thanks Thanh __ 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
FW: OT: SQL Server Connection
Hi all, I have a website that's accessing a sql database on the same network. Starting next week, I'd have to move my website to an ISP. My Question is how should I set up the connection to my SQL server database which will stay in-house? I can't'move the database because we also have other in-house applications connecting to the same database. What's the best way to do this? Should I create a duplicate database on the ISP server just for the website. and sync it with our main database here? any potential problems with doing this? Any advice would be appreciated. Thanks. __ 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
RE: OT: SQL Server Connection
Nope, don't have public IP. -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 12:15 PM To: CF-Talk Subject: RE: OT: SQL Server Connection does the database server have a publicly acessible IP address? if so, just crate the ODBC source on the ISP for the site, and point it to that IP. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 3:11 PM To: CF-Talk Subject: FW: OT: SQL Server Connection Hi all, I have a website that's accessing a sql database on the same network. Starting next week, I'd have to move my website to an ISP. My Question is how should I set up the connection to my SQL server database which will stay in-house? I can't'move the database because we also have other in-house applications connecting to the same database. What's the best way to do this? Should I create a duplicate database on the ISP server just for the website. and sync it with our main database here? any potential problems with doing this? Any advice would be appreciated. Thanks. __ 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
RE: SQL Order by clause
this would not do it. wat i weant was ordering a column starting with, for example,letter E, instead of A. -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 7:26 AM To: CF-Talk Subject: RE: SQL Order by clause ORDER BY Left(fieldname, 1) christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 7:52 PM To: CF-Talk Subject: OT: SQL Order by clause Hi all, How do I do an order by clause start with an alphabet letter. ? Is that possible ? Thanks Thanh __ 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
OT: SQL Order by clause
Hi all, How do I do an order by clause start with an alphabet letter. ? Is that possible ? Thanks Thanh __ 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
OT: SQL Order by clause
Hi all, How do I do an order by clause start with an alphabet letter. ? Is that possible ? Thanks Thanh __ 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
join tables from 2 different databases
Hi all, just a quick question. how do i join 2 tables from 2 different databases? , thanks. __ 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: join tables from 2 different databases
please Ignore this... I already got it. -Original Message- From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 4:18 PM To: CF-Talk Subject: join tables from 2 different databases Hi all, just a quick question. how do i join 2 tables from 2 different databases? , thanks. __ 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
CFMail does not send email externally
Hi all, I'm trying to set up an CFMail Tag in my app to send email to users. the mail setting in CF admin is properly set up. I was able to send email to myself and email with the company but when sending to an external email address, it failed. I check the mail log and the failed message is relaying is prohibited here's the message. Error,1000,03/26/02,13:59:54,,Failed to send the spooled mail file, C:\CFusion\Mail\spool\125D.cfmail. SMTP server replied Relaying is prohibited Moved file to C:\CFusion\Mail\undelivr\125F.cfmail. anyboby knows what this means? thanks Thanh __ 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: CFMail does not send email externally
Thanks, Thanh -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 2:33 PM To: CF-Talk Subject: Re: CFMail does not send email externally Your mail server doesn't allow relaying (which is a good thing, trust me). It will send mail externally, but the FROM needs to be a valid email address or valid host on the mail server. Look at your mail server and read about the relaying ... If someone outside gets ahold of your mail server and you allow relaying they will relay all kinds of spam through your mail server and possibly get your banned... Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder - Original Message - From: Thanh Nguyen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 4:28 PM Subject: CFMail does not send email externally Hi all, I'm trying to set up an CFMail Tag in my app to send email to users. the mail setting in CF admin is properly set up. I was able to send email to myself and email with the company but when sending to an external email address, it failed. I check the mail log and the failed message is relaying is prohibited here's the message. Error,1000,03/26/02,13:59:54,,Failed to send the spooled mail file, C:\CFusion\Mail\spool\125D.cfmail. SMTP server replied Relaying is prohibited Moved file to C:\CFusion\Mail\undelivr\125F.cfmail. anyboby knows what this means? thanks Thanh __ 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: Returning IDs off a query...
I played with it a little bit and figured that out already. Thanks anyway. Thanh -Original Message- From: Tyler M. Fitch [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 12:57 PM To: CF-Talk Subject: RE: Returning IDs off a query... Thanh, If you use a trigger that inserts new records into associated tables, the @@IDENTITY won't work. Those new records defined in the trigger will change the @@IDENTITY to an incorrect value. t ** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ** -Original Message- From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 3:27 PM To: CF-Talk Subject: RE: Returning IDs off a query... What if I have an Insert trigger, will the SELECT @@IDENTITY work? Are there any problems with using this with triggers? -Original Message- From: Tyler M. Fitch [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 1:41 PM To: CF-Talk Subject: RE: Returning IDs off a query... If you have no triggers being fired by your table on inserts then the SELECT @@IDENTITY will work just fine. You don't have to wrap it in cftransaction either. Once a CFQUERY is executed in a page the connection is left open for more DB actions until the page is done processing, since it's a single connection, that is what allows for the use of @@IDENTITY. If your DBMS supports it I'd use it instead of a SELECT MAX(). Cheers, t ** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 1:27 PM To: CF-Talk Subject: Re: Returning IDs off a query... I always use SELECT MAX(id) FROM tbl_name after the insert. I do wrap it in cftransaction though just in case. That way, I can be confident that the last entry was mine and not someone else that submitted at the same time. HTH Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 - Original Message - From: Tyler Silcox To: CF-Talk Sent: Thursday, December 20, 2001 2:30 PM Subject: Returning IDs off a query... I've been saving this question for a rainy day, and while it's not rainy, it could be getting a little stormy...what is the best way to return a freshly submitted ID from a cfquery? Should I use a getMax SQL function with cftransaction tag pair around the insert and select queries or should I retrieve the @@identity in a separate cfquery statement? Any takers? Tyler __ Get Your Own Dedicated Windows 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=coldfusionb 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: Returning IDs off a query...
What if I have an Insert trigger, will the SELECT @@IDENTITY work? Are there any problems with using this with triggers? -Original Message- From: Tyler M. Fitch [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 1:41 PM To: CF-Talk Subject: RE: Returning IDs off a query... If you have no triggers being fired by your table on inserts then the SELECT @@IDENTITY will work just fine. You don't have to wrap it in cftransaction either. Once a CFQUERY is executed in a page the connection is left open for more DB actions until the page is done processing, since it's a single connection, that is what allows for the use of @@IDENTITY. If your DBMS supports it I'd use it instead of a SELECT MAX(). Cheers, t ** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 1:27 PM To: CF-Talk Subject: Re: Returning IDs off a query... I always use SELECT MAX(id) FROM tbl_name after the insert. I do wrap it in cftransaction though just in case. That way, I can be confident that the last entry was mine and not someone else that submitted at the same time. HTH Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 - Original Message - From: Tyler Silcox To: CF-Talk Sent: Thursday, December 20, 2001 2:30 PM Subject: Returning IDs off a query... I've been saving this question for a rainy day, and while it's not rainy, it could be getting a little stormy...what is the best way to return a freshly submitted ID from a cfquery? Should I use a getMax SQL function with cftransaction tag pair around the insert and select queries or should I retrieve the @@identity in a separate cfquery statement? Any takers? Tyler __ 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
Quick help PLease!!! Stored Procedure Errors
I have a stored procedure that runs OK in MSSQL Query analyzer but when run in Cold fusion CFSTOREDPROC I got this message. ODBC Error Code = 22003 (Numeric value out of range) [Microsoft][ODBC SQL Server Driver]Numeric value out of range SQL = p_SUPPLIER_LISTING My stored procedure is just a collection of 3 select statements. Any ideas why? __ 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
Insert a list into a table - help!!!
I have a list with at least 3 items. And I want to insert it into table. right now, I'm looping through the list to insert them into db, but this is like writing multiple cfquery's. and what happens if my list has 20 items. cfloop index=index list=#mylist# cfquery insert into my_table (id, itemName) values (#ID#,'#index#' ) /cfquery /cfloop Is there a better way to do this? __ Dedicated Windows 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=coldfusiona 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: Insert a list into a table - help!!!
MSSQL -Original Message- From: Garza, Jeff [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 12:24 PM To: CF-Talk Subject: RE: Insert a list into a table - help!!! What database are you using? Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 1:20 PM To: CF-Talk Subject: Insert a list into a table - help!!! I have a list with at least 3 items. And I want to insert it into table. right now, I'm looping through the list to insert them into db, but this is like writing multiple cfquery's. and what happens if my list has 20 items. cfloop index=index list=#mylist# cfquery insert into my_table (id, itemName) values (#ID#,'#index#' ) /cfquery /cfloop Is there a better way to do this? __ Get Your Own Dedicated Windows 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=coldfusionb 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 Server Union statement
I was using the Enterprise Manager. Apparently, It does not let you create a view with union select statement. I wrote the view in query analyzer and it worked. Thanks -Original Message- From: Bob Imperial [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 5:41 AM To: CF-Talk Subject: RE: SQL Server Union statement How about CREATE VIEW AS SELECT FROM? I haven't failed, I've found 10,000 ways that don't work. --Ben Franklin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 17, 2001 5:45 PM To: CF-Talk Subject: OT: SQL Server Union statement Hi all, I have an union statement that puts 2 cust tables together. I want to but I could not save it as a view in SQL Server for other pages.. Is there some other way to save it in SQL ? Thanh __ 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
OT: SQL Server Union statement
Hi all, I have an union statement that puts 2 cust tables together. I want to but I could not save it as a view in SQL Server for other pages.. Is there some other way to save it in SQL ? Thanh 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
Passing form field data
Hi, I have a very long form which i have broken down into 5 pages. My question is what's the best way to store and pass form fields from each page to the last page where all field data will be sent to a database. thanks ~~ 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: Passing form field data
thanks, the second option sounds interesting. I'll try that. -Original Message- From: Tyler M. Fitch [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 10:29 AM To: CF-Talk Subject: RE: Passing form field data You're going to have two options. 1) Use session variables. On the action for each page loop over FORM.fieldnames and append those fields and values to your session.st5stepProcess - Sessions are the easiest, but they and locking are avoidable if you want to try the next method. 2) Use WDDX. The trick with using WDDX in this fashion is that you're going to end up with WDDX inside other WDDX. The first pages info will be inside a field of the second pages WDDX fields, the second inside the third and so on. So you'll need to convert the WDDX using the xmlformat() function. If you try to deserialize a WDDX packet with another inside you'll get an error. The progression is like this First page - Your normal form In the second page - cfwddx action=CFML2WDDX input=#FORM# output=wstPage1 form input type=hidden name=wstPage1 value=#wstPage1# In the third page - the part where you have to start paying attention cfset FORM.wstPage1 = xmlformat(FORM.wstPage1) !--- now all the are lt; etc... --- cfwddx action=CFML2WDDX input=#FORM# output=wstPage2 form input type=hidden name=wstPage2 value=#wstPage2# Then when you want to pull it all out cfwddx action=WDDX2CFML input=#FORM.wstPage2# output=variables.wstPage2 cfwddx action=WDDX2CFML input=#variables.wstPage2.wstPage1# output=variables.wstPage1 This will then give you a couple of different structs to play with that then contain all your data. I haven't pushed it past three pages, but I'm pretty sure if you keep up the progression of WDDX and xmlformat it will keep working. I ended up using CFDUMP quite a bit to make sure things were getting passed properly. It'll help a great deal. HTH, t ** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 9:50 AM To: CF-Talk Subject: Passing form field data Hi, I have a very long form which i have broken down into 5 pages. My question is what's the best way to store and pass form fields from each page to the last page where all field data will be sent to a database. thanks ~~ 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
javascript variables help!
Hi all, In one of my pages, I have a javascript array. How do I pass it to the next page to do some calculation using both Coldfusion and javascript? TIA, Thanh ~~ 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: OnSelect Javascript code
I used this CFWDDX ACTION=CFML2JS INPUT=#getProd_list# TOPLEVELVARIABLE=getProd_list function partlist(thisInfo){ document.all.PartList.options.length = 0; var olen = 0; for (var i=0;i getProd_list.p_num.length; i++) { if (getProd_list.m_mscode[i] == thisInfo.options[thisInfo.selectedIndex].value){ NewOpt = new Option; NewOpt.value = getProd_list.p_num[i]; NewOpt.text = '(' + getProd_list.p_num[i] + ') '+ getProd_list.p_name[i] ; document.all.PartList.options[olen++] = NewOpt; } } } the partlist function is called when a product is selected. It will loop through the list and get all the parts for that product. Hope this help! Thanh -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 11:31 AM To: CF-Talk Subject: OnSelect Javascript code I am looking for a onSelect javascript code that has the same type of ability as the popular CFTwoRelatedSelects Custom Tag. Basically I want field 2 to change dynamically from the selection of field 1. Both fields are being populated from the database. Anybody got something like that? James ~~ 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: Three Selects Related Custom Tag
It should be in allaire's Developer's Exchange. I downloaded from there. -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 12:55 PM To: CF-Talk Subject: Three Selects Related Custom Tag Does anybody have Nate Weiss's Three Selects Related Custom Tag. He is reworking his site and I need to download it. Thanks, James ~~ 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: If anyone else needs zip codes just speak up.
Can I have a copy please? TIA Thanh -Original Message- From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 1:39 PM To: CF-Talk Subject: If anyone else needs zip codes just speak up. Just though I would share the zip codes with whoever might need them. Just let me know CF_SIGNATURE NAME=Douglas L. Brown EMAIL=[EMAIL PROTECTED] PHONE=714.538.6611 WEB=http://www.carnivorepc.com; ~~ 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
Random passwords
Does Anybody know how to generate random passwords for new users? ~~ 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: Random passwords
thanks all.. I got it. ;) -Original Message- From: Joseph DeVore [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 11:06 AM To: CF-Talk Subject: RE: Random passwords sorry, cf-talk chopped the code from last email: http://cftags.veloxweb.com/passwords.cfm It's a custom tag called CF_RandomPassword written by Rob Bilson ([EMAIL PROTECTED]) HTH, Joseph DeVore VeloxWeb Technologies -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 10:56 AM To: CF-Talk Subject: RE: Random passwords uh what code would that be? :) seems to have gotten cut off -Original Message- From: Joseph DeVore [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 1:52 PM To: CF-Talk Subject: RE: Random passwords This code will generate mixed case passwords: ! ~~ 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
Display result pages menu
Hi, I'm sure someone has written this. I'm looking for a custom tag to display result pages menu that list the pages like back 1 2 3 4 5 ...8 9 10 next. Can someone help me with this? TIA ~~ 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
Capitalize first characters
Hi all, I'm just starting to learn coldfusion and I'm looking for a function or a way to capitalize the first character of words in a string. Can this be done? Can someone help me with this? Thanks ~~ 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
Test-Please Ignore!!!
this is a test ~~ 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: Capitalize first characters
Thanks all. I got it. :) -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 13, 2001 11:21 AM To: CF-Talk Subject: RE: Capitalize first characters cfset newname = #Ucase(left(old_name,1))# #mid(old_name,2,len(old_name)-1)# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 13, 2001 1:21 PM To: CF-Talk Subject: Capitalize first characters Hi all, I'm just starting to learn coldfusion and I'm looking for a function or a way to capitalize the first character of words in a string. Can this be done? Can someone help me with this? Thanks ~~ 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
automatic loading files to server
hello all, every day I have to upload files manually to one of our client website using netscape or explorer, I go to their website, click on a link, and it prompt for user name and passowrd, after that i have to enter some information like name, and then choose to file on my local machine and click uploaded. I just want to know if I can automatically upload the files ussing cold fusion or other programming tools, if yes, how what tags i should use, thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQLOLEDB questions
I set up the sqlledb in the cf administration sucessfully and I tried to write the CFQuery and CFSTOREDPROC, but some how it doesn't work, when i load up the page, it takes forever, if someone have any examples codes so i can follow thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC error
if anyone knows why this happened so strange, I checked everything seems to work fine, i can log in (using database table) the page, some how when i run query it gives errors, I verify the datasource in the cold fusion administration it looked OK Please help ODBC Error Code = 08001 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (31:1) to (31:71). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Fax customed tag
I know it's been posted before, but i could not find it, I would like to know with fax software that supports cold fusion tag, maybe Facsys.. please help. thanks _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL question help
thanks David, it worked From: "Hayes, David" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: SQL question help Date: Tue, 7 Nov 2000 12:40:51 -0600 When you are having trouble with a dynamic sql statement, output the statement to the page to see what is actually being sent to the db. Try replacing tableB.email NOT IN ('#ValueList(getremovelist.email)#') with tableB.email NOT IN (#QuotedValueList(getremovelist.email)#) Your SQL statement currently looks something like NOT IN ('[EMAIL PROTECTED],[EMAIL PROTECTED],etc.') and you want NOT IN ('[EMAIL PROTECTED]','[EMAIL PROTECTED]',etc.) -Original Message----- From: thanh nguyen [mailto:[EMAIL PROTECTED]] Sent: Monday, November 06, 2000 3:56 PM To: CF-Talk Subject: SQL question help I want to do a filter , but somehow it does not the way i want it I have a table that have email field , and onther table with a field email who wants to remove from the list, cfquery name="getremovelist" datasource="remove" dbtype="ODBC" select email from wantoremove /cfquery cfquery name="gettheList" datasource="BBB" SELECT DISTINCT firstname, email FROM tableB WHERE tableB.email NOT IN ('#ValueList(getremovelist.email)#') /cfquery Somehow when i output the GettheList query , it still showing the emails from the GetRemoveList query. and datatype for email fields are varchar 100 please help thanks _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
mailmerge witth sql server database
helllo everyone, I would like to know if someone has done mailmerge with sql server database, I have mailmerge word document and would like to retrieve the data from the sql server database. can i use cold fusion do the job, thanks _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
SQL question help
I want to do a filter , but somehow it does not the way i want it I have a table that have email field , and onther table with a field email who wants to remove from the list, cfquery name="getremovelist" datasource="remove" dbtype="ODBC" select email from wantoremove /cfquery cfquery name="gettheList" datasource="BBB" SELECT DISTINCT firstname, email FROM tableB WHERE tableB.email NOT IN ('#ValueList(getremovelist.email)#') /cfquery Somehow when i output the GettheList query , it still showing the emails from the GetRemoveList query. and datatype for email fields are varchar 100 please help thanks _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
stripping all white space, CR, Tab and put into one line
hello everyone, I have a textarea box asking user to type in and, sometimes user types carriage return, tab, new line, then I insert it into sql server, when I retrieve the information and want to write it into a text file. sometimes if the user did not hit any return key or tab, so i write into text file it is on coutinous one line, if the user hit return key or tab then the text file show the multiple rows of characters, what I want to do now is some how in one coutinous line without tab or Carriage Return character.I have use StripCF() but it did not work thanks for any suggestion _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
double quotes
can anyone show me how to write to a file from result query, with doble quotes around the field name, for example somthing like this "ID","Price","date","sent" "123","23.4",12/12/00","12/12/00" _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
double quotes
can anyone show me how to write to a file from result query, with doble quotes around the field name, for example somthing like this "ID","Price","date","sent" "123","23.4",12/12/00","12/12/00" _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Tele check processing using CF
Is there any custom tag or information about tele check payment processing from Verisign , please give me some suggestion thanks _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
go back to previou s page
I have different pages go to the same page and i want to know know how if I go to that page and click done it go back to previous page where I come from thanks Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
in one query refers to 2 different odbc sources
I have 2 databases located on the 2 different NT servers, Is there any way i can write one query that refers to different odbc sources, if yes, how and the syntax, thanks Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.