Not sure about SQL 7, but double or triple quotes work with most languages. Also try "
instead of '.
-brian
[EMAIL PROTECTED] wrote:
> Hi
>
> I'm working on an SQL 7 OLE database at the moment and am having trouble
> inserting strings into the db which contain quotes.
>
> For example:
>
> INSERT INTO mytable VALUES ('This is my 'quote' to insert')
>
> I'm sure there's an easy way to get around this problem, but can't for the
> life of me think what it is!
>
> Anyone with any ideas?
>
> TIA.
>
> Simon
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
