OOPS, I really need to read closer. Assuming rst is the field names,
and rst1 is the values:
(Also, assuming classic asp. If it's .net, i can post that code too.)
<%
rst.open "SELECT FIELDNAMES",connection
rst1.open "SELECT FIELD VALUES", connection
response.write "<Table>"
response.write "<tr>"
do until rst.eof
response.write "<td>" & rst(0) & "</td>"
rst.movenext
loop
response.write "</tr>"
response.write "<tr>"
do until rst.eof
rst.movenext
loop
Okay, i'm not sure of the format. How are you linking the fields?
Looking at your data, is there a record with a blank to delineate the
data? I guess I'm not sure how that would work. Could you give more
info on the values?
Chris
On Feb 28, 4:39 pm, "chris.nebin...@gmail.com"
<chris.nebin...@gmail.comwrote:
Quote:
You could do:
>
<%
rst.open SQLSTATEMENT, CONNECTION
%>
<table>
<tr>
<%
For i = 0 to rst.fields.count-1
response.write "<th>" & rst.fields(i).Name & "</th>"
Next
%>
</tr>
<%
Do until rst.eof
response.write "<tr>"
For i = 0 to rst.fields.count-1
response.write "<td>" & rst.fields(i).Value& "</td>"
Next
response.write "</tr>"
rst.movenext
loop
%>
>
Chris Nebinger
>
On Feb 28, 11:12 am, "Larry Linson" <boun...@localhost.notwrote:
>
>
> Quote:
This newsgroup is for questions, answers, and discussions of Microsoft
Access database software, and your question does not deal with that
software. You "got lucky" and received one (very good and accurate)
response, but you'll have better luck getting useful responses if you post
ASP-with-SQL-Server questions in a newsgroup dealing with that subject.
Good luck.
| > Quote:
Larry Linson
Microsoft Access MVP
| > Quote: |
"Nitin" <nitinro...@gmail.comwrote
| > Quote: Quote: |
I have two resultset in asp as follows
| | > Quote: Quote: |
database is sql- Hide quoted text -
| | >
- Show quoted text -
|
Asp query (SQL Related) 
