cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "HuiSion Teh" <huis...@magix.com.sg>
Subject XML content in Db field?
Date Tue, 05 Sep 2000 16:42:26 GMT
hi
How do I use SQL logicsheet to extract db field that contains XML text?

For example in my database I have a field "spec" that is a varchar() that
stores XML content such as
	<spec>
		<height>1.72</height>
		<weight>64</weight>
	</spec>

In my XML file I have a section that would need to extract the above content
before passing it to XSL producer:

	<product>
		sql code to extract the whole of "spec" XML content from db
	</product>

In my XSL file I would have template matching "height" and "weight".

I have tried but could not get it right. The < and > characters in the
"spec" content would become &lt; and &gt; before it reaches the XSL
producer.

Pls help..thanks



Mime
View raw message