Chris Denman wrote:
>
> I get problems with the single quote character. Double quotes are fine, and
> seem to be handled automatically by the system.
>
> e.g. INSERT INTO row (ref,text) VALUES ('1','This is,'some text that', will
> probably mess things up')
>
> Any ideas?Use the quote method ot better still use placeholders - see Placeholders and Bind Values in the DBI docs. -- Simon Oliver
