[ILUG] RE it must exist more...

[Anton Whalley]

To explain it further...

SELECT 
	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:template select="/b/ROW/@*">
	
	<xsl:if test="substring(., 1 ,3) = 'lnk'">
	<a> <attribute name="href">
			http:name/location?id=<xsl:value-of="." />
		</attribute>
	</a> 
	</xsl:if>
</xsl:template> 

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
co-operation.