RE: [PHP-DB] Oracle CLOBs and carriage returns
| From: | Brian Dunworth | Date: | Thu, 09 Aug 2001 18:21:22 +0000 |
| Subject: | RE: [PHP-DB] Oracle CLOBs and carriage returns | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-11198@lists.php.net to get a copy of this message | ||
On Thursday, August 09, 2001 at 2:09 PM, Tom Tsongas said:
> Here is the code I am using:
>
> $sql_comments = OCIParse($connection,"SELECT COMMENTS FROM INCIDENT
> WHERE INCIDENT='$incident'");
> OCIExecute($sql_comments);
> while ( OCIFetchInto($sql_comments, $row,
> OCI_ASSOC+OCI_RETURN_NULLS)) {
>
> $lob_data = $row["COMMENTS"]->load();
> echo $lob_data;
> }
>
> I know the information is stored correctly since a SQL query from the
> command line works properly and all formatting is displayed.
>
> Any thoughts?
echo nl2br($lob_data);
- Brian
-----------------------------------
Brian S. Dunworth
Sr. Software Development Engineer
Oracle Database Administrator
The Printing House, Ltd.
(850) 875-1500 x225
-----------------------------------