[Zope] structured text : paras and lists not working ?

[Darcy Clark]

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