• From: "Thomas B. Passin" <tpassin@h...>
• To: xml-dev@l...
• Date: Sat, 07 Apr 2001 10:41:29 -0400

Danny Ayers said -

> I don't know .asp syntax, but if you can get your data into strings then
all
> you need to do is something along the lines of :
>
> outputToYourStream("<"+recordName+" "+fieldName1+" = "+fieldValue1+"/>")
>
Well, if you get right down to it, you can get xml for each row just with
your select statement:

select '<row><fname>'+ fname + '</fname><lname>'+lname+'</lname></row>'
from person

All you have to do is wrap the rows in a root element and you're done.  Not
too flexible, but it could do the job.  Any decent sql database will do this
job for you.

Cheers,

Tom P

• References:
  • RE: xml from ms-sql ... how can I display data with *.asp???
    • From: Danny Ayers <danny@p...>

• Prev by Date: RE: xml from ms-sql ... how can I display data with *.asp???
• Next by Date: Re: Linkbases, Topic Maps,and RDF Knowledge Bases -- help me understand, please
• Previous by thread: RE: xml from ms-sql ... how can I display data with *.asp???
• Next by thread: Re: xml from ms-sql ... how can I display data with *.asp???
• Index(es):
  • Date
  • Thread