XML Export of HTML in fields?

[Duane]

I would like to enter some HTML into a field in my database. Then export using XML/XSLT to produce a web page. Unfortunately, the export escapes all the HTML tags.

Is there any way to turn this off during the XML export so that I get the actual characters?

Any suggestions on alternative ways of doing this? (i.e. Inventing a new syntax and transforming that syntax. Oh fun.)

[Garry Claridge]

You could have the XSLT generate the HTML, rather than store it.

Good Luck.

Garry

[h2o.be]

Using

disable-output-escaping="yes"

the HTML tags will not be escaped.

[Duane]

Thank you for the suggestions.

> You could have the XSLT generate the HTML, rather than store it.

That would be extremally difficult. Every record is different. I am preparing a FAQ database. Custom formatting of the fields is necesary to presnet the data properly.

> Using

> disable-output-escaping="yes"

>the HTML tags will not be escaped.

This only works in the XSLT, unfortunatelly FileMaker has already escaped the tags before I see them. That's what I was asking about turningit off in FileMaker.

Thanks for the ideas.

Still looking for suggestions.

[h2o.be]

This only works in the XSLT, unfortunatelly FileMaker has already escaped the tags before I see them. That's what I was asking about turningit off in FileMaker.

In attachment, I put 3 files :

1. a FMPRO 6 file "forfilemakerforum.fp5" with one single record and one field "html"

2. a xsl file "fmproxmlexport.xsl"

3. a html file "forfilemakerforum.html" whose the result of the transformation of the XML export.

In the (my) result, the html tags are NOT escaped !

forfilemakerforum.zip

[Duane]

Thank you Jean-Marie!! I understand the process better now.

FileMaker is not escaping anything. The "default" xslt process is doing the escaping because that's what it does if you tell it to do nothing.

I adapted your xslt file to the DSO output format and it worked fine.

Thank you, this will save me a lot of headache.

[h2o.be]

Just one thing more ...

In FileMaker Pro 7, the DSO grammar has been deprecated

[cjaeger]

... but still works. It's a lot more useful than fmpxml, and since it is easy to convert between the two syntaxes, don't worry about future compatability. Just run it thru fmpxml2dso.xsl before processing.

[h2o.be]

fmpxml2dso.xsl ?

I do not find it on filemaker.com, fmforums, nor google.

Where can I find this stylesheet ?