Keeping the text format

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
Dixie
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 1336
Joined: Sun Jul 12, 2009 10:53 am

Keeping the text format

Post by Dixie » Mon Jan 18, 2010 10:34 am

I have no problems getting text in and out of a MySQL db.... Could someone tell me though how to put in 'formatted' text... ie I want to put in say, three paragraphs, and when I get it out of the db it still is in the paragraph form, to coin a phrase..

thanks

Dixie

Klaus
Posts: 14206
Joined: Sat Apr 08, 2006 8:41 am
Contact:

Re: Keeping the text format

Post by Klaus » Mon Jan 18, 2010 12:30 pm

Hi Dixie,

I would store "the htmltext of fld xyz" into the database and restore it back later.
This way, all the formatting will be preserved!


Best

Klaus

Dixie
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 1336
Joined: Sun Jul 12, 2009 10:53 am

Re: Keeping the text format

Post by Dixie » Tue Jan 19, 2010 11:15 am

Klaus...

Thanks for the reply... I had been looking at 'HTMLtext'... but thought that there might be another way...I have been lazy just inputting the text via NaviCat... Still, whipping up a little stack to use 'HTMLText', to make the entries should be no problem... (I'll let the cat have a go!)

be well

Dixie

Post Reply