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"

I just looked it up an IP does not appear in the list, so it seems it is
not reserved.
Open your database in Access, create a new query in design view, switch
to SQL View and paste in the above statement. Does it run?

--
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)