09. oktober 2000 - 15:10
Der er
9 kommentarer og
1 løsning
Hente selve felt navn i acces database ..
U det jeg vil hente i en acces database er Eks. Rs(\"Dettenavn\") og ikke værdien i \"Dettenavn\". Er der nogen der ved hvordan man gør dette ..
Der er 100 point til den med den rigtige løsning. Og 200 point hvis det er inden for 10 minutter fra oprettelses tidspunkt ...
09. oktober 2000 - 15:17
#2
Jeg tror du kan finde det du skal bruge i dette kode...
Option Explicit
Dim DBFileName$
Dim dbs$
Private Sub GetStructure()
\'loop variablerne
Dim i, j
\'Database objekter
Dim db As Database
Dim rs As Recordset
Dim td As TableDef
Dim fd As Field
\'Åben databasen
Set db = Workspaces(0).OpenDatabase(DBFileName$)
dbs$ = \"Database: \" & db.Name & vbCrLf
\'Process each table
For i = 0 To db.TableDefs.Count - 1
Set td = db.TableDefs(i)
If Left$(td.Name, 4) <> \"MSys\" Then
\'Tabel navn
dbs$ = dbs$ & Space$(3) & \"Table: \"
dbs = dbs$ & td.Name & vbCrLf
\'Kør alle felterne igennem i tabel
For j = 0 To td.Fields.Count - 1
Set fd = td.Fields(j)
\'Fields navn
dbs$ = dbs$ & Space$(6) & \"Field: \"
dbs$ = dbs$ & fd.Name & vbCrLf
\'Feltets datatype
dbs$ = dbs$ & Space(9) & \"Type: \"
Select Case fd.Type
Case dbBoolean
dbs$ = dbs$ & \"Boolean\" & vbCrLf
Case dbByte
dbs$ = dbs$ & \"Byte\" & vbCrLf
Case dbLong
dbs$ = dbs$ & \"Long\" & vbCrLf
Case dbCurrency
dbs$ = dbs$ & \"Currency\" & vbCrLf
Case dbSingle
dbs$ = dbs$ & \"Single\" & vbCrLf
Case dbDouble
dbs$ = dbs$ & \"Double\" & vbCrLf
Case dbDate
dbs$ = dbs$ & \"Date\" & vbCrLf
Case dbText
dbs$ = dbs$ & \"Text\" & vbCrLf
Case dbLongBinary
dbs$ = dbs$ & \"LongBinary\" & vbCrLf
Case dbMemo
dbs$ = dbs$ & \"Memo\" & vbCrLf
Case Else
dbs$ = dbs$ & \"(unknown)\" & vbCrLf
End Select
\'Størelse af felt i bytes
If fd.Type <> dbLongBinary And fd.Type <> dbMemo Then
dbs$ = dbs$ & Space$(9) & \"Size: \"
dbs$ = dbs$ & fd.Size & vbCrLf
End If
Next j
End If
Next i
\'Luk database
db.Close
End Sub
Private Sub Form_Load()
\'Centrering
Left = (Screen.Width - Width) \\ 2
Top = (Screen.Height - Top) \\ 2
\'Prompt til bruger databasen
cdlOne.DialogTitle = \"Vælg en database\"
cdlOne.Filter = \"Database(*.mdb)|*.mdb\"
cdlOne.CancelError = True
\'Tjek af Cancel
On Error Resume Next
cdlOne.ShowOpen
If Err = cdlCancel Then End
\'Forbered analyse af database
DBFileName$ = cdlOne.FileName
Me.Caption = \"Datadump - \" & DBFileName$
GetStructure
End Sub
Private Sub form_Paint()
\'Sæt størelsen på textbox
txtDB.Move 0, 0, ScaleWidth, ScaleHeight
\'Vis analyse i textbox
txtDB.Text = dbs$
End Sub
09. oktober 2000 - 15:18
#3
Du kan bruge det her :
<!-- #include file=\"adovbs.inc\" -->
<% set conn = Server.CreateObject(\"ADODB.Connection\")
conn.CursorLocation = adUseClient
conn.Open \"NAVN_PAA_ODBC_FORBINDELSEN\"
set rs = Server.CreateObject(\"ADODB.Recordset\")
set rs = conn.OpenSchema(adSchemaTables)
%>
<HTML>
<HEAD>
<TITLE></TITLE>
</HEAD>
<BODY>
<%
Do Until rs.EOF %>
Table name: <%=rs(\"TABLE_NAME\") %><br>
Table type: <%=rs(\"TABLE_TYPE\") %><br>
<% rs.MoveNext
Loop
%>
</BODY>
</HTML>
10. oktober 2000 - 22:00
#10
Du kan også bare se på dette lille eksempel som jeg har findet - så kan du se, hvordan man evt. kunne gøre :)
<!-- #INCLUDE FILE=\"adovbs.inc\" -->
<%
Const DSN_NAME = \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\"STI TIL DATABASEN!;\"
Const DSN_USER = \"\"
Const DSN_PASS = \"\"
Sub OpenConnection
Set objDC = Server.CreateObject(\"ADODB.Connection\")
objDC.ConnectionTimeout = 15
objDC.CommandTimeout = 30
objDC.Open DSN_NAME, DSN_USER, DSN_PASS
End Sub
Sub OpenRecordset(sType)
Dim sSqlString
Dim sCritOperator
Dim sCritDelimiter
Set objRS = Server.CreateObject(\"ADODB.Recordset\")
Select Case sType
Case \"ListTables\"
Set objRS = objDC.OpenSchema(adSchemaTables)
Case \"ViewTable\"
Set objRS = Server.CreateObject(\"ADODB.Recordset\")
objRS.Open \"[\" & sTableName & \"]\", objDC, adOpenForwardOnly, adLockReadOnly
Case \"DrillDown\"
Set objRS = Server.CreateObject(\"ADODB.Recordset\")
sSqlString = \"SELECT * FROM [\" & sTableName & \"]\"
If sCritField <> \"\" Then
Select Case iCritDataType
Case adSmallInt, adInteger, adSingle, adDouble, adDecimal, adTinyInt, adUnsignedTinyInt, adUnsignedSmallInt, adUnsignedInt, adBigInt, adUnsignedBigInt, adBinary, adNumeric, adVarBinary, adLongVarBinary, adCurrency, adBoolean
sCritOperator = \"=\"
sCritDelimiter = \"\"
Case adDate, adDBDate, adDBTime, adDBTimeStamp
sCritOperator = \"=\"
sCritDelimiter = \"#\"
Case adBSTR, adChar, adWChar, adVarChar, adLongVarChar, adVarWChar, adLongVarWChar
sCritOperator = \"LIKE\"
sCritDelimiter = \"\'\"
End Select
sSqlString = sSqlString & \" WHERE [\" & sCritField & \"] \" & sCritOperator & \" \" & sCritDelimiter & sCritValue & sCritDelimiter
End If
If sSortOrder <> \"none\" Then
sSqlString = sSqlString & \" ORDER BY [\" & sSortField & \"] \" & sSortOrder
End If
sSqlString = sSqlString & \";\"
objRS.Open sSqlString, objDC, adOpenForwardOnly, adLockReadOnly
End Select
End Sub
Sub CloseRecordset
objRS.Close
Set objRS = Nothing
End Sub
Sub CloseConnection
objDC.Close
Set objDC = Nothing
End Sub
Sub WriteTitle(sTitle)
Response.Write \"<H2>\" & sTitle & \"</H2>\" & vbCrLf
End Sub
Sub WriteTableHeader
Response.Write \"<TABLE BORDER=1>\" & vbCrLf
End Sub
Sub WriteTableRowOpen
Response.Write \"<TR>\" & vbCrLf
End Sub
Sub WriteTableCell(bCellIsTitle, sContents)
Response.Write vbTab & \"<TD>\"
If bCellIsTitle Then Response.Write \"<B>\"
Response.Write sContents
If bCellIsTitle Then Response.Write \"</B>\"
Response.Write \"</TD>\" & vbCrLf
End Sub
Sub WriteTableRowClose
Response.Write \"</TR>\" & vbCrLf
End Sub
Sub WriteTableFooter
Response.Write \"</TABLE>\" & vbCrLf
End Sub
Dim objDC, objRS
Dim I
Dim strTemp
Dim sAction
Dim sTableName
Dim sSortField
Dim sSortOrder
Dim sCritFiel
Dim sCritValue
Dim iCritDataType
sAction = Request.QueryString(\"action\")
If sAction = \"\" Then sAction = \"ListTables\"
sTableName = Request.QueryString(\"tablename\")
sSortField = Request.QueryString(\"sf\")
Select Case LCase(Request.QueryString(\"so\"))
Case \"asc\"
sSortOrder = \"ASC\"
Case \"desc\"
sSortOrder = \"DESC\"
Case Else
sSortOrder = \"none\"
End Select
sCritField = Request.QueryString(\"cf\")
If Len(sCritField) = 0 Then sCritField = \"\"
sCritValue = Request.QueryString(\"cv\")
iCritDataType = Request.QueryString(\"cdt\")
If Len(iCritDataType) <> 0 And IsNumeric(iCritDataType) Then iCritDataType = CInt(iCritDataType)
Call OpenConnection
Call OpenRecordset(sAction)
Select Case sAction
Case \"ShowDataConnectionProperties\" \' Cool to look at but not really part of the sample!
OpenRecordset(\"ListTables\")
For I = 0 to objDC.Properties.Count - 1
Response.Write I & \" \" & objDC.Properties(i).Name & \": \" & objDC.Properties(I) & \"<BR>\" & vbCrLf
Next
Case \"ListTables\"
Call WriteTitle(\"Tables\")
If Not objRS.EOF Then objRS.MoveFirst
Call WriteTableHeader
Call WriteTableRowOpen
Call WriteTableCell(True, \"Table Name\")
Call WriteTableRowClose
Do While Not objRS.EOF
If objRS.Fields(\"TABLE_TYPE\") = \"TABLE\" AND Left(objRS.Fields(\"TABLE_NAME\"), 4) <> \"MSys\" Then
Call WriteTableRowOpen
Call WriteTableCell(False, \"<A HREF=\"\"./db_dsn.asp?action=ViewTable&tablename=\" & Server.URLEncode(objRS.Fields(\"TABLE_NAME\")) & \"\"\">\" & objRS.Fields(\"TABLE_NAME\") & \"</A>\")
Call WriteTableRowClose
End If
objRS.MoveNext
Loop
Call WriteTableFooter
Case \"ViewTable\", \"DrillDown\"
Call WriteTitle(sTableName)
If Not objRS.EOF Then objRS.MoveFirst
Call WriteTableHeader
Call WriteTableRowOpen
For I = 0 to objRS.Fields.Count - 1
strTemp = objRS.Fields(I).Name
strTemp = strTemp & \" (<A HREF=\"\"./db_dsn.asp\"
strTemp = strTemp & \"?action=DrillDown\"
strTemp = strTemp & \"&tablename=\" & Server.URLEncode(sTableName)
strTemp = strTemp & \"&cf=\" & Server.URLEncode(sCritField)
strTemp = strTemp & \"&cv=\" & Server.URLEncode(sCritValue)
strTemp = strTemp & \"&cdt=\" & iCritDataType
strTemp = strTemp & \"&sf=\" & Server.URLEncode(objRS.Fields(I).Name)
strTemp = strTemp & \"&so=asc\"\">+</A>\"
strTemp = strTemp & \"/<A HREF=\"\"./db_dsn.asp\"
strTemp = strTemp & \"?action=DrillDown\"
strTemp = strTemp & \"&tablename=\" & Server.URLEncode(sTableName)
strTemp = strTemp & \"&cf=\" & Server.URLEncode(sCritField)
strTemp = strTemp & \"&cv=\" & Server.URLEncode(sCritValue)
strTemp = strTemp & \"&cdt=\" & iCritDataType
strTemp = strTemp & \"&sf=\" & Server.URLEncode(objRS.Fields(I).Name)
strTemp = strTemp & \"&so=desc\"\">-</A>)\"
Call WriteTableCell(True, strTemp)
Next
Call WriteTableRowClose
Do While Not objRS.EOF
Call WriteTableRowOpen
For I = 0 to objRS.Fields.Count - 1
If IsNull(objRS.Fields(I).Value) Or objRS.Fields(I).Value = \"\" Or VarType(objRS.Fields(I).Value)= vbNull Then
strTemp = \" \"
Else
strTemp = \"<A HREF=\"\"./db_dsn.asp\"
strTemp = strTemp & \"?action=DrillDown\"
strTemp = strTemp & \"&tablename=\" & Server.URLEncode(sTableName)
strTemp = strTemp & \"&cf=\" & Server.URLEncode(objRS.Fields(I).Name)
strTemp = strTemp & \"&cv=\" & Server.URLEncode(objRS.Fields(I).Value)
strTemp = strTemp & \"&cdt=\" & objRS.Fields(I).Type
strTemp = strTemp & \"&sf=\" & Server.URLEncode(sSortField)
strTemp = strTemp & \"&so=\" & sSortOrder & \"\"\">\"
strTemp = strTemp & objRS.Fields(I).Value
strTemp = strTemp & \"</A>\"
End If
Call WriteTableCell(False, strTemp)
Next
Call WriteTableRowClose
objRS.MoveNext
Loop
Call WriteTableFooter
End Select
Call CloseRecordset
Call CloseConnection
%>
<BR>
<A HREF=\"./db_dsn.asp\">Back to the Table List</A>