Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pull data from database in correct format

Status
Not open for further replies.

Bartzilla

Technical User
Joined
Jul 16, 2004
Messages
15
Location
DE
I have a website that pulls data from an Access database. In one table, I have a field with large reviews in it. During inputting, when a user hits 'return', it is also stocked in the db. Iow, the data for that field is in the correct format. How can I pull this from the db in a way that shows the breaks and things like that? Right now, it just puts all my data in a row with no breaks.
Thanks in advance.
 
use a replace function

Assuming ASP
Code:
replace(dbField,"vbCrLf","<br>")

this will replace a return with a HTML line break.



Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
Nightclub counting systems

So long, and thanks for all the fish.
 
That should work. Thanks a lot!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top