I am having a small problem with using structured text. Specifically I have a form with a text area form element that gathers entered text, i.e. <textarea name="body" cols=60 rows=5></textarea> and enters it along with some other arguments into an MySQL database using an sql method, like so : INSERT INTO announcements (announceID, course, timestamp, body, posted_by, date) VALUES (NULL, <!--#sqlvar course type=int-->, NULL, <!--#sqlvar body type=string-->, <!--#sqlvar posted_by type=string-->, <!--#sqlvar date type=string-->); I then display the text in another file like this : <!--#var body fmt=structured-text--> I can get every structured text element to work (including *italics*, **bold**, _underlined_ etc...) but the paragraph and lists are not working. e.g. this text : - test - test will be rendered as : - test - test The carriage returns are being entered into the database, and are still here when I get the text out, but the fmt=structured-text doesn't seem to be recognizing the carriage returns or any of the list 'tags'. This is SQL query I use to get the data back out : select timestamp,date,body,posted_by from announcements where <!--#sqltest course column=course type=int--> order by timestamp DESC; any pointers on what I am doing wrong or missing ? thanks in advance, Darcy -- --------------------------------------------------- Ph: (734) 764 3377 Email: darcyc@engin.umich.edu URL: http://www-personal.engin.umich.edu/~darcyc/ --------------------------------------------------- 'If you're not part of the solution, you're part of the precipitate' ..... Steven Wright
participants (1)
-
Darcy Clark