[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: xml from ms-sql ... how can I display data with *.asp???
- From: "Thomas B. Passin" <email@example.com>
- To: firstname.lastname@example.org
- 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
> 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>'
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.