Hi alec,
I use quote();
$abc = "abc'xyz'123'other\nstuff\r789";
$sql = "insert into tblStuff (clob) values ('".$dbh->quote($abc),"') ";
...seems to also work on cr/lf chars too- dunno how tho.
HTH
K.C
On Fri, 18 Feb 2005 14:31:37 -0500, Alec Brecher
<[EMAIL PROTECTED]> wrote:
> I am wondering if someone could help with insertion of line breaks into an
> Access Memo (clob) field.
>
> Is there a DBD::ADO option which allows \r\n to be seen in Access as line
> break?
>
> Currently "foo\r\nbar" looks like "foo[][]bar", where [] is a sqare box.
>
> Thank you.
>
> Alec Brecher
> E Research Resources
> office 802 253-8908
> www.eresearchresources.com
>
>
