Displaying elements of XML text from SQL

[gregas]

Thanks in advance for the response!

Here's the situation: I have an XML string being stored in a SQL 7 database that I would like certain parts (elements) of to be displayed on a web page. Essentially, I'd like parse the string and get some info out of it.

The exact design of the column is XMLRequest (datatype = text, size = 16).

The data stored in the column looks something like:

<ReportRequest PersonID=&quot;99999&quot; ReportGroupID=&quot;99&quot; OutputFormat=&quot;3&quot;>
<ReportParameters>
<ReportParameter ReportParameterID=&quot;5&quot; Value=&quot;99999&quot;>

By getting the personID/ReportID/etc, I look up the person's name, report they were requesting, etc etc.

Whether the solution is an .xml document or and .asp is of no matter to me.

Any help is much appreciated!

thanks,
asg