Forums
This topic is locked
Error Type: (0x80040E14)
Posted 13 May 2002 15:44:45
1
has voted
13 May 2002 15:44:45 Capuleto Smith posted:
I´m getting this error from now on.. the querys in the server look fine..any help¿?
The code that crashes the script is:
set rsDisp=server.CreateObject("ADODB.Recordset"
Edic=Request.form("Edi"
rsDisp.CursorType=adOpenStatic
rsDisp.Open "select * FROM qryHorari where IdFEdi = '" & Edic & "' AND IdCodiHor NOT IN (SELECT IdCodiHor FROM qryAgenda WHERE IdFServAg = "& Edic &"
", conex Regards,
Juan
TC
Edited by - capuleto on 13 May 2002 15:47:55
Replies
Replied 16 May 2002 13:07:39
16 May 2002 13:07:39 johannes nel replied:
some info from the msdn:
SYMPTOMS
When you browse to an Active Server Page (ASP) created from Microsoft Access 2000, you may receive an error message similar to the following:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/nwweb/MainQuery.ASP, line 22
CAUSE
You may receive this error message when there is a parameter that is not in the top-level query. Microsoft Access does not check below the top-level to see if a parameter exists when exporting the query.
RESOLUTION
To prevent this error message, do not include parameters on any query other than the top-level query.
SYMPTOMS
When you browse to an Active Server Page (ASP) created from Microsoft Access 2000, you may receive an error message similar to the following:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/nwweb/MainQuery.ASP, line 22
CAUSE
You may receive this error message when there is a parameter that is not in the top-level query. Microsoft Access does not check below the top-level to see if a parameter exists when exporting the query.
RESOLUTION
To prevent this error message, do not include parameters on any query other than the top-level query.