RecordsetToTable.asp
Upload User: loyalwww
Upload Date: 2007-08-12
Package Size: 933k
Code Size: 0k
Category:

ADO-ODBC

Development Platform:

Visual C++

  1. <%
  2. Function RecordsetToTable (oRec)
  3. Dim oFld
  4. Dim sTable
  5. DIM NBSPACE
  6. NBSPACE = Chr(160)
  7. sTable = "<TABLE BORDER=1><THEAD><TR>"
  8. For Each oFld In oRec.Fields
  9. sTable =  sTable & "<TD>" & oFld.Name & "</TD>"
  10. Next
  11. sTable =  sTable & "</TR></THEAD>" & _
  12. "<TBODY><TR><TD>" & _
  13. oRec.GetString (,,"</TD><TD>", "</TD></TR><TR><TD>", NBSPACE) & _
  14. "</TD></TR></TBODY></TABLE>"
  15. RecordsetToTable = sTable
  16. End Function
  17. %>