læsning af Felt NAVN i acces ..
Jeg har følgende Source kode :<!-- #include virtual=\"/adovbs.inc\" -->
<% Const DSN_NAME = \"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=D:\\Inetpub\\wwwroot\\kls\\test.mdb\"
Sub OpenConnection
Set objDC = Server.CreateObject(\"ADODB.Connection\")
objDC.ConnectionTimeout = 15
objDC.CommandTimeout = 30
objDC.Open DSN_NAME
End Sub
Sub OpenRecordset(sType)
Dim sSqlString, sCritOperator, sCritDelimiter
Set objRS = Server.CreateObject(\"ADODB.Recordset\")
Select Case sType
Case \"ListTables\"
Set objRS = objDC.OpenSchema(adSchemaTables)
Case \"ViewTable\"
Set tableview = Server.CreateObject(\"ADODB.Recordset\")
tableview.Open \"[\" & sTableName & \"]\", objDC, adOpenForwardOnly, adLockReadOnly
Set tableview = Server.CreateObject(\"ADODB.Recordset\")
sSqlString = \"SELECT * FROM [\" & sTableName & \"]\"
If sSortOrder <> \"none\" Then
sSqlString = sSqlString & \" ORDER BY [\" & sSortField & \"] \" & sSortOrder
End If
sSqlString = sSqlString & \";\"
tableview.Open sSqlString, objDC, adOpenForwardOnly, adLockReadOnly
End Select
End Sub
Sub WriteTableCell(bCellIsTitle, sContents)
Response.Write vbTab & \"<tr><TD>\"
If bCellIsTitle Then Response.Write \"<B>\"
Response.Write sContents
If bCellIsTitle Then Response.Write \"</B>\"
Response.Write \"</TD></tr>\" & vbCrLf
End Sub
Dim objDC, objRS, I, strTemp, tableview
Dim sAction, sTableName, sSortField, sSortOrder, sCritFiel, sCritValue, iCritDataType
sAction = Request.QueryString(\"action\")
If sAction = \"\" Then sAction = \"ListTables\"
sTableName = Request.QueryString(\"tablename\")
Select Case LCase(Request.QueryString(\"so\"))
Case \"asc\"
sSortOrder = \"ASC\"
Case \"desc\"
sSortOrder = \"DESC\"
Case Else
sSortOrder = \"none\"
End Select
Call OpenConnection
Call OpenRecordset(sAction)
Select Case sAction
Case \"ListTables\"
If Not objRS.EOF Then objRS.MoveFirst
Response.Write \"<TABLE BORDER=0>\" & vbCrLf
Do While Not objRS.EOF
If objRS.Fields(\"TABLE_TYPE\") = \"TABLE\" AND Left(objRS.Fields(\"TABLE_NAME\"), 4) <> \"MSys\" Then
Response.Write \"<TR>\" & vbCrLf
Call WriteTableCell(False, \"<A HREF=\"\"default.asp?action=ViewTable&tablename=\" & Server.URLEncode(objRS.Fields(\"TABLE_NAME\")) & \"\"\">\" & objRS.Fields(\"TABLE_NAME\") & \"</A>\")
Response.Write \"</TR>\" & vbCrLf
End If
objRS.MoveNext
Loop
Response.Write \"</TABLE>\" & vbCrLf
Case \"ViewTable\"
If Not tableview.EOF Then tableview.MoveFirst
Response.Write \"<TABLE BORDER=0 cellspacing=0 cellpadding=0>\" & vbCrLf
Response.Write \"<TR>\" & vbCrLf
For I = 0 to tableview.Fields.Count - 1
strTemp = tableview.Fields(I).Name
Call WriteTableCell(False, strTemp)
Next
Response.Write \"</TR>\" & vbCrLf
Response.Write \"</TABLE>\" & vbCrLf
End Select
objRS.Close
Set objRS = Nothing
objDC.Close
Set objDC = Nothing
%>
skal nu bare havde det til at vise resultatet på første side sådanne :
Tabelnavn
|-- FELTNAVN1_1
|-- FELTNAVN1_2
|-- FELTNAVN1_3
|-- FELTNAVN1_4
|-- FELTNAVN1_5
Tabelnavn1
|-- FELTNAVN2_1
|-- FELTNAVN2_2
|-- FELTNAVN2_3
|-- FELTNAVN2_4
|-- FELTNAVN2_5
