Use htmlEditFormat()
However, I don't recommend using this function when you're
inserting/updating data to the database. Rather, use it when you are
display data to the browser.
----- Original Message -----
From: "Shawn Regan" <[EMAIL PROTECTED]>
To: "CF-Community" <[EMAIL PROTECTED]>
Sent: Friday, August 17, 2001 1:19 PM
Subject: Large chunks of data in a DB and special characters
> What is the best way to handle input of data into a DB field that may have
> special characters like so:
>
> " ' & % !
>
> is there a SQL or CF function to wrap the data while inserting it so SQL
> doesn't take it as its syntax?
>
> TIA
>
> Shawn Regan
> Applications Developer
> Pacific Technology Solutions
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
