Welcome, Guest
Please Login or Register.    Lost Password?
Tools JX
Card View JX
Suggestions

Support for line breaks in MySQL longtext field?
(1 viewing) (1) Guest
Go to bottom
Post Reply
Post New Topic
Page: 1
TOPIC: Support for line breaks in MySQL longtext field?
#469
Support for line breaks in MySQL longtext field? 1 Year, 9 Months ago Karma: 0
Hello again,

Can you help with yet another query please? When I view some of my data via mysqladmin, I can see there are line breaks in some of my longtext fields.

When I view the same record via the table grid, the line breaks are ignored and the paragraphs of data appear as one block of text.

Is there any way I can preserve the formatting in my longtext fields?

Thank you
David
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
djb
Junior Boarder
Posts: 20
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#479
Re:Support for line breaks in MySQL longtext field? 1 Year, 9 Months ago Karma: 5
Hi,

Add this code to components/com_grid/layouts/GridView.php, line 268. (If you are using the newest version of Table JX)

Code:
$podatek=nl2br($podatek);


Regards,
Tomaž
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
tomaz
Moderator
Posts: 282
graph
User Offline Click here to see the profile of this user
Reply Quote
 
#484
Re:Support for line breaks in MySQL longtext field? 1 Year, 9 Months ago Karma: 0
Tomaž,

That worked a treat. Many thanks
David
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
djb
Junior Boarder
Posts: 20
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
Go to top
Post Reply
Post New Topic
Page: 1
Tools JX
Card View JX
Suggestions
Moderators: tomaz
Powered by Kunenaget the latest posts directly to your desktop
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting