To explain it further...
b.id AS lnk_boxes_id,
b.room_id AS hid_room_id,
b.description AS txt_description
FROM boxes b
FOR XML RAW
<xsl:if test="substring(., 1 ,3) = 'lnk'">
<a> <attribute name="href">
You could then put your template in front of any select statement
with the fields that use the prefixes and you could also use the
template in front of any database you can get XML out of.
The template may not be correct but it is the sort of thing you need to do
Please note that we have moved office. Our new address is:
2nd Floor, International House, 20-22 Lwr Hatch St., Dublin 2.
This communication and any files transmitted with it may contain
information that is confidential, privileged and exempt from disclosure
under applicable law. It is intended solely for the use of the individual
or entity to which it is addressed. If you are not the intended recipient,
you are hereby notified that any use, dissemination or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify the sender. Thank you for your
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!