Forums

Hi,

Using ChronoConnectivity to display text field from database, it displays all on one line.

Ex: Suppose to be like this:
1. line 1
2. line 2
3. line 3

BUT it displays like this: 1. line 1 2. line 2 3. line 3

Open phpMyAdmin and see that it displays correctly with multi-lines. Search all over the forum but not found solution. Please help! I'm using latest version of CC

Hi emdep3000,

The easiest way to display data is to use html to create a table. Put the <table> and header rows in the header box, the footer row and </table> in the footer box and create a <tr><td>data</td>. . .</tr> row in the body box.

Bob

Thanks for your response!

I think you mis-understand what I want to ask. What I want to say is when I want to display the data from textarea field (only one field) and the format suppose to be multiline but it displays all in one line (no break to next line format).

Ex: Suppose like this (and phpMyAdmin also displays format like this)
01/19/2009 --> James Bond

Testing add new notes

Line two start here

BUT when using Chrono Connectivity to display that textarea field, it displays like this:
01/19/2009 --> James Bond Testing add new notes Line two start here



Thanks for your help!

Hi emdep3000,

Ah - that is trickier. I think that the question has come up before - but I don't remember if it was in this context.

Check in the databse exactly what is being saved or recovered. Adding the PHP command nl2br({field_name} may help (from memory so I may not have the exact function name).

Bob