Re: XML Strategdy

<snip> Question is this. As a seasoned developer, my natural instinct is to just write a script(s) to access all the information that I need and write the appropriate information out to the file. Is there a better way to do this? Is there some type of application that has been developed that will take a select statement as input and automatically generate XML output? </snip> I have used php adodb (http://php.weblogs.com/ADODB) but I have never any of these to convert result sets to xml but they look like they will do the trick http://phplens.com/lens/lensforum/msgs.php?id=3430 and this pear package looks like it might do the trick http://pear.php.net/manual/en/package.xml.xml-sql2xml.php