Hello Marcin, Thanks, it works well. Because I use HtmlArea for input, I can modify it to make xhtml.
Sunday 14 March 2004 11.56 d�tummal Marcin Okraszewski ezt �rta: > > My database (postgresql) contains text fields which has html tags. > > In esql result I tried to use > > esql:get-string, esql:get-ascii but it converts <> to <> > > If I tried to use esql:get-xml it has an empty result. > > > > So, how can I disable this converting? > > I think the only solution is to store XHTML in your DB - this is how I > do it. > > The reason of the empty result from esql:get-xml may be: > - malformed xml in db (I mean html without closed tags, etc); common > problem is which is not understood by XML parser - use   > instead - far I remember, the xml *must* have a root element; so if you > have fragment like "some <b>html</b> fragment" it might not work; you can > wrap the content into some element like this: > <esql:get-xml column="html_column" > root="p" > root-ns="http://www.w3.org/1999/xhtml"/> > you can also omit root-ns or add root-prefix if you want to prefix the > root. > > Regards, > Marcin Okraszewski > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -- thx, ---------------------------------------------------- Zoltan Zidarics programmer PTE University Pecs, Hungary icq: 43288694 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
