 |
 |
Hey all- for a new search tool I'm writing, I'm thinking it might be prudent to use XML transformations to convert between some various query formats. Is anyone out there aware of an XML schema that could represent a SQL select statement? You know, something like this <select> <what-list> <what-element>a.*</what-element> <from-list> <from-element> <table>asset</table> <alias>a</alias> </from-element> </from-list> <where-list> <where-element>a.asset_id = 500</where-element> </where-list> </select> But with support for hierarchical queries, joins, and other nasty business. Thanks much! Rafe Rosen Software Developer / System Administrator Macaulay Library Cornell Lab of Ornithology Ithaca, NY (607) 254 2132 [log in to unmask]