Is there anyway to display the contents of a database table without knowing the field names? Ian Hall
Multimedia Designer
Multimedia Designer
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
dispalying database without know field names?
- Thread starter brown
- Start date
Sure Ian,
var rs = Server.CreateObject("ADODB.Recordset"
;
rs.Open("select * from mytable", ....);
Response.Write("<table border=1>"
while (!rs.EOF){
Response.Write("<tr>\r\n"
for( nCol=0; nCol<rs.Fields.Count; nCol++){
Response.Write("<td>" + rs(nCol) + "</td>\r\n"
}
Response.Write("</tr>"
}
Response.Write("</table>"
Good luck
-pete
var rs = Server.CreateObject("ADODB.Recordset"
;rs.Open("select * from mytable", ....);
Response.Write("<table border=1>"
;while (!rs.EOF){
Response.Write("<tr>\r\n"
;for( nCol=0; nCol<rs.Fields.Count; nCol++){
Response.Write("<td>" + rs(nCol) + "</td>\r\n"
;}
Response.Write("</tr>"
;}
Response.Write("</table>"
;Good luck
-pete
More...
Append this block after "while..." and you will show field names
Response.Write "<TR>\r\n"
For i = 1 To rs.Fields.Count
Response.Write "<TD>"
Response.Write rs.Fields(i - 1).Name
Response.Write "</TD>\r\n"
Next
Response.Write "</TR>"
Best regards,
Ilguizar Rizaev
Append this block after "while..." and you will show field names
Response.Write "<TR>\r\n"
For i = 1 To rs.Fields.Count
Response.Write "<TD>"
Response.Write rs.Fields(i - 1).Name
Response.Write "</TD>\r\n"
Next
Response.Write "</TR>"
Best regards,
Ilguizar Rizaev
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question