This may seem a little newbieish but how would you loop through a block of text to find special characters? Once you've found them, how would you replace them? Are there any examples or tutorials out there of routines that will do that?
-----Original Message-----
From: [mailto:[EMAIL PROTECTED]]
Sent: July 10, 2002 8:31 AM
To: [EMAIL PROTECTED]
Subject: Re: RE: [CFTALKTor] Freaking Quotationsdid it go from ASP on NT to CF on unix/linux or something like that?I know when I switch platforms, the special characters from word, for example, get messed up in different programs, and do appear as "boxes." Most annoying are word characters such as "curly quotes", en-dashes, etc., as well as foreign language characters (e-accent-aigue, etc.)If you want the database cleaned up, you may have to write a little CF database routine that will loop through ALL the text fields in your database and replace the "box" character (copy-paste it) and with the appropriate html-safe character (quote, etc.)Or, if you can (or want to) keep the database as is, you can write a little routine that goes between your database pull and your display to do the same thing: find any funny characters and replace them with their corresponding normal character.hope that helps.carina----- Original Message -----From: Jeremy OuditSent: 7/10/2002 10:37:20 AMTo: [EMAIL PROTECTED]Subject: RE: [CFTALKTor] Freaking Quotationslove to post the ASP but it's 54 pages worth of spaghetti code in one document. here is the CF
#text#
#text#
#paragraphformat(text)#
#list#
#text#-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: July 10, 2002 7:27 AM
To: [EMAIL PROTECTED]
Subject: re: [CFTALKTor] Freaking Quotations
post both the asp and the cf code..
Dave Seddon (p) 997-1803
Internet Software Support Specialist
Workplace Information Directorate, HRDC-DRHC
e-mail: [EMAIL PROTECTED]
Web: http://labour.hrdc-drhc.gc.ca---------- Original Text ----------
From: "Jeremy Oudit" <[EMAIL PROTECTED]>, on 2002-07-10 10:22 AM:
I'm in the process of redoing a website that was previously made in ASP into
Cold fusion. Things are progressing really smoothly. EXCEPT FOR THIS:
Anything content that is pulled from the database displays quotations or
apostrophes as a box. WHY FOR THE LOVE OF GOD WHY???? This drives me nuts.
Quotes display fine in the ASP version and I haven't changed any of the
content in the data base itself. Any ideas. Why does CF do this?
-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: [EMAIL PROTECTED]
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)
