I just wanna ask help on this code
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/pang/view_station.asp, line 14
which is "myrec.Open sql"
i did all suggestion from the net but still i can't solve it.
Any help is higly appreciated.
thanks
Meynard
Expand|Select|Wrap|Line Numbers
- <%
- Session("GB_DATABASE") = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("_db/links.mdb")
- Set Conn = Server.CreateObject("ADODB.Connection")
- Conn.Mode = 3
- Conn.Open Session("GB_DATABASE")
- %>
- <%
- Set myrec = Server.CreateObject ("ADODB.Recordset")
- Set myrec.ActiveConnection = conn
- Dim sql
- sql = "select * from station WHERE name =" & Request.QueryString("neym")
- myrec.CursorType = 3
- myrec.Open sql
- %>