RE: [ADodb-general] Using ADODB with text blobs

[Paul T. <Pa...@gu...>]

To save the data

=20

            $record =3D array();

=20

            $record["COMP_NOTE"] =3D $_POST['comp_notes'];

            Add other $record items

            $acc_id =3D $_POST['comp_id'];

            $sql =3D "SELECT * FROM COMPANY WHERE COMP_ID =3D ".$acc_id;

            $rs =3D $conn->Execute($sql);

            $SQLtext =3D $conn->GetUpdateSQL($rs, $record,
$forceUpdate=3Dfalse,$magicq=3Dfalse);

$conn->Execute($SQLtext);

=20

To retreive the data

=20

$sql =3D 'select * from COMPANY where COMP_ID =3D '.$COMPANY;

$recordSet =3D $conn->Execute($sql);

=20

while ($arr =3D $recordSet->FetchRow()) {   $TEMPLATE['header']=3D$arr; =
}

=20

To display the data, a textarea control is placed on the html page with
its initial value set to {val header/12}

=20

=20

________________________________

From: Alfredo Yong [mailto:alf...@gm...]=20
Sent: 22 September 2005 15:32
To: Paul Tugwell
Subject: Re: [ADodb-general] Using ADODB with text blobs

=20

please insert the code=20

On 9/22/05, Paul Tugwell <Pa...@gu...> wrote:=20

In a text area on a web page I type three line, pressing the Enter key=20
at the end of each line

Line1
Line2=20
Line3

I then save this using adodb to a firebird text blob field.
If I use a database utility to view the data in the database, it=20
appears as I have typed it, but when I retrieve the data, and display=20
it again in a web page text area I get=20

Line1<br />
Line2<br />
Line3=20

Any ideas why?

=20




--=20
Alfredo Yong
Sistemas web=20