At 8:53 AM -0800 3/6/06, Phil M wrote:
I would think that the NULL character (0x00) might cause problems, and possibly the backslash character (\).
Ed said this data was coming from an EditField; I don't believe you can get a null character from there.
As for backslashes, there's nothing in the SQL standard that makes them special -- in fact the ONLY special character in standard SQL is the single-quote. But if you're using some nonstandard SQL implementation that treats the backslash as special, then you'll probably want to replace each "\" with "\\" as well.
Best, - Joe -- Joseph J. Strout [EMAIL PROTECTED] _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
