RE: DBD::ADO line breaks

From: Alec Brecher (alec_at_eresearchresources.com)
Date: 02/18/05 

To: "Kevin Carothers" <kevindotcar@gmail.com>
Date: Fri, 18 Feb 2005 15:25:03 -0500

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:kevindotcar@gmail.com]
Sent: Friday, February 18, 2005 3:08 PM
To: Alec Brecher
Cc: dbi-users@perl.org
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
<alec@eresearchresources.com> 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
>
>