Re: Microsoft JET Database Engine error '80040e10'

TonnyD wrote:
the error I get now is

SELECT * FROM tblIP WHERE IP = '71.229.200.204' AND pollID=3286
Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/asppoll/vote.asp, line 15


Also I dont think the field names are wrong. This is what the tables
and field names are that are mentioned in this script.

Table "tblIP" field names "IP" "PollID"
Table "tblCount" field names "Count1" "Count2" "Count3" "Count4"

IP may be a reserved keyword. Try enclosing it in brackets - [IP]

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: Microsoft JET Database Engine error 80040e10
    ... Microsoft JET Database Engine error '80040e10' ... No value given for one or more required parameters. ... Also I dont think the field names are wrong. ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: Newbie needs help with "yes/no" field
    ... Microsoft JET Database Engine error '80040e10' ... No value given for one or more required parameters. ... >> Dim objConn ...
    (microsoft.public.inetserver.asp.db)
  • Re: insert into error
    ... > Microsoft JET Database Engine ... > I've done a response.write with the SQL statement and I get this ... it's silly to be forced to worry about delimiters (let alone ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Im baffled...
    ... > Microsoft JET Database Engine error '80040e10' ... > No value given for one or more required parameters. ... Why haven't you shown us the SQL statement? ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Redirect with variable
    ... > Microsoft JET Database Engine error '80040e14' ... sSQL = sSQL & StrRecid ... need something other than the default, server-side, forward-only cursor. ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)