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

Reply via email to