So here is where I'm stuck.
Expand|Select|Wrap|Line Numbers
- <%
- Dim myTable=request.querystring("Table")
- Dim myField=request.querystring("Field")
- Dim mySchTxt=request.querystring("schTxt")
- '-- Create object and open database
- Set DataConnection = Server.CreateObject("ADODB.Connection")
- DataConnection.Open ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="& Server.MapPath("/DMS/ISDAssetsDatabase3_be.mdb"))
- Set cmdDC = Server.CreateObject("ADODB.Command")
- cmdDC.ActiveConnection = DataConnection
- '-- default SQL
- SQL = "SELECT * FROM myTable"
- '-- RecordToEdit SQL
- If mySchTxt <> "" Then
- SQL = "SELECT myTable.myfield, myTable.* FROM myTable WHERE (((myTable.myfield)=" & myScrTxt & "));"
- End If
- cmdDC.CommandText = SQL
- Set RecordSet = Server.CreateObject("ADODB.Recordset")
- if myTable= "[Maintenance History]" Then