ASP Database Query and Strings!!!

[istreet]

I have script that searches a database and returns several recordsets based upon a unique id, and presents them on a page(as below):

name : address : email:

The results can range from a single row to multiple rows depending upon the id number what i want to do is turn all the results into a string any ideas? Thanks.

 

[npf]

Give this a go it'll give you a csv style string
<%
dim mystr

do

mystr=mystr & rst.fields(&quot;FIELDNAME&quot.value & &quot;,&quot; &
_ rst2.fields(&quot;FIELDNAME&quot.value & &quot;,&quot; &
_ rst3fields(&quot;FIELDNAME&quot.value & &quot;,&quot;
rst.movenext
rst2.movenext
rst3.movenext
loop until rst.eof or rst2.eof or rst3.eof
%>

 

[culshaja]

If its SQL Server 2000 why not bring the results set back as XML and hen apply an XSLT. It would be much fatser and easier to maintain.

James James Culshaw
jculshaw@miniaturereview.co.uk

http://www.miniaturereview.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305