Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Expand|Select|Wrap|Line Numbers
- <%
- Set objconn = Server.CreateObject("ADODB.Connection")
- objconn.ConnectionString = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath('mypath")
- objconn.Open
- %>
- <%
- Dim qryDisplayRiskRef__MMColParam
- qryDisplayRiskRef__MMColParam = "1"
- If (Request.QueryString("RiskRef") <> "") Then
- qryDisplayRiskRef__MMColParam = Request.QueryString("RiskRef")
- End If
- %>
- <%
- Dim qryDisplayRiskRef
- Dim qryDisplayRiskRef_numRows
- Set qryDisplayRiskRef = Server.CreateObject("ADODB.Recordset")
- qryDisplayRiskRef.ActiveConnection = objconn
- qryDisplayRiskRef.Source = "SELECT * FROM QueryDisplayFields WHERE RiskRef = '" + Replace(qryDisplayRiskRef__MMColParam, "'", "''") + "'"
- qryDisplayRiskRef.CursorType = 0
- qryDisplayRiskRef.CursorLocation = 2
- qryDisplayRiskRef.LockType = 1
- qryDisplayRiskRef.Open()
- qryDisplayRiskRef_numRows = 0
- %>