Hmmm... Seems that $dbh->quote( $abc ) is doing something unintended.
$abc = "abcxy123other \r\n stuff \r\n 789";
$sql = "insert into tblStuff (clob) values (".$dbh->quote($abc).") ";
memo field looks like: "abcxy123other [][] stuff [][] 789"
However:
$abc = "abcxy123other \r\n stuff \r\n 789";
$sql = "insert into tblStuff (clob) values ('$abc') ";
memo field looks like:
"abcxy123other
stuff
789"
-Alec
-----Original Message-----
From: Kevin Carothers [mailto:[EMAIL PROTECTED]
Sent: Friday, February 18, 2005 3:08 PM
To: Alec Brecher
Cc: [email protected]
Subject: Re: DBD::ADO line breaks
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
>
>
