Solved

Replace Typed Dashes in Paragraph with HTML

Posted on 2004-09-18
4
215 Views
Last Modified: 2013-12-24
Hi I have this in my Sql UPDATE statement:

Description='#Replace(form.Description, chr(13) & chr(10), "<br>","ALL",)#'

so that I can replace carriage returns in my <textarea> with <br> for input into the database.  I would also like to replace all dashes (-) typed into the textarea with the proper thing so that I won't get a little square in the paragraph on output.  How? I should mention these are not regular dashes but are the long ones--I don't know what they are called.
0
Comment
Question by:champ_010
  • 2
4 Comments
 
LVL 21

Expert Comment

by:pinaldave
ID: 12095714
okey they may be combination of many dashes... in world when there are two or three dashes toghether looks like big horizontal dashes... so you need to replace them with many dashes...
Tha ascii of dash will be &#150;
if due to some reason they are big dash then try this big dash ascii &#151;
hope this helps...
Regards,
---Pinal
0
 
LVL 17

Accepted Solution

by:
anandkp earned 100 total points
ID: 12099526
Why not use CFQueryParam to insert the text entered in textarea ... it shld allow u to insert things as entered by the user ...

UR Sql UPDATE statement wld be like :
Description = <CFQueryParam CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#form.Description#">

lemme know if this helps ...
0
 
LVL 1

Author Comment

by:champ_010
ID: 12114709
Thanks--learned something new again.
0
 
LVL 21

Expert Comment

by:pinaldave
ID: 12115054
I learn everytime from AnandKP :)
---Pinal
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question