[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-db
Subject:    [PHP-DB] Re: Retrieve text from Oracle Text
From:       61.68.208.242
Date:       2006-10-17 4:52:54
Message-ID: 57.3C.04054.3DE54354 () pb1 ! pair ! com
[Download RAW message or body]

Choy, Wai Yew wrote:

> Hi,
> 
>  
> 
> My company have a Oracle9i database ...One of the field (text) in this
> database is a text file (VARCHAR2) with a length of 100
> characters.....The text inside this field is "carriage return" return.
> 
>  
> 
> When we retrieve this field (select text from db.text_field), it only
> shows the first line. The second and the rest of the line does not show
> up. Can I know how to I retrieve all the lines in this field?
> 
>  
> 
> Thanks..

You probably are retrieving all the lines in the field; if you are then
outputting the contents direct to the browser, the browser will ignore the
newlines - View Source should confirm that this is the case. You should use
nl2br() on the retrieved data before passing it to the browser.



Cheers
-- 
David Robley

"Buy me something to drink?" said Tom drily.
Today is Setting Orange, the 71st day of Bureaucracy in the YOLD 3172. 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[prev in list] [next in list] [prev in thread] [next in thread]