RE: Help with Regular expression

,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

Help with Regular expression

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

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

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

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

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

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:

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

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

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

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

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

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

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

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()

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

RE: Coldfusion Training IN SoCal

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

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:

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

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,

using cf_stockdata, is this legal?

/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

RE: ODBC Error Code = 08001

: 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

RE: ODBC Error Code = 08001

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

RE: File Size limit with CFFile?

: 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

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

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

ODBC Error Code = 08001

) [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

RE: ODBC Error Code = 08001

] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Thanh Nguyen [EMAIL

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

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

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

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:

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

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

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 =

RE: list of items with quotes

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

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

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;

RE: Javascript: onKeydown event

| +--+---+ -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

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

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

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:

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

RE: OT: SQL Server Connection

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

RE: SQL Order by clause

, 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

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.

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.

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:

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

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

RE: CFMail does not send email externally

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

RE: Returning IDs off a query...

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

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...

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

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

RE: Insert a list into a table - help!!!

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

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

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

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

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

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

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

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

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.

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:

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

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

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

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:

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

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

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 ~~

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

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

RE: SQL question help

ECTED],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

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

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

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

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

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

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

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

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