You can either check for the existence of the ' and replace it with its
chr(039) equiv or you could replace it with the ReplaceList() function on
the form variable being passed.... another option would be to
PreserveSingleQuotes() on it. I believe the latter would be your best
approach to correct just the single quote issue. Without seeing one of the
strings in question, it'd be tought to hazard a guess....
IMHO
Heath
-----Original Message-----
From: Adam Reynolds [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 18, 2001 10:37 AM
To: CF-Talk
Subject: Inserting HTML into a database.
I'm using EZEdit (awesome tag!) to enable a user to paste in excel tables
etc as HTML.
I'm having problems if the spreadsheet pasted in is too big. Is this a
known problem?
Also could somebody tell me how I get around the user using the '
character.
Thanks.
Best Regards,
Adam Reynolds
ColdFusion Web Developer
ISMG Development, Unilever
London
( +44 20 7822 x5450
m: +44 7973 386620
* [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
