RE: Microsoft JET Database Engine error '80040e10'

Hi TonnyD

'No value given for one or more required parameters.' - this means your
table field name is not matching with your calling procedure


"TonnyD" wrote:

Im not to knowledgeable about asp script so I need a little help. Im
trying to install asppoll and im getting this error;

Microsoft JET Database Engine error '80040e10'


No value given for one or more required parameters.


/asppoll/vote.asp, line 14



This is the script.<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<


<!--#include file="dbconnection.inc"-->
<!--#include file="header.inc"-->
<%

ID = Clng(Request.querystring("ID"))


strSQL = "SELECT * FROM tblIP WHERE IP = '" &
request.servervariables("remote_addr") & "' AND pollID=" & ID
SET rsPoll = adoCon.execute(strSQL)


IF rsPoll.EOF Then


rsPoll.close
strSQL="UPDATE tblCount SET " & Request.Form("txtOption") & "
= " & Request.Form("txtOption") & " + 1 WHERE ID = " & ID
SET rsPoll=adoCon.execute(strSQL)
<<<<<<<<<<<<<<<<<[Line 14]>>>>>>>>>>>>
strSQL="INSERT INTO tblIP (IP, pollID) VALUES('" &
Request.Servervariables("REMOTE_ADDR") & "','" & ID & "')"
SET rsPoll=adoCon.execute(strSQL)
Response.Redirect
Request.ServerVariables("http_referer")


ELSE
rsPoll.close
Response.Write "This IP has already voted for this Survey!
<br><a
href=javascript:history.go(-1)><img src=images/back.gif border=0></
a>"
END IF


SET rsPoll = Nothing
adoCon.close
SET adoCon = Nothing


%>
<center><table><tr><td><a href=http://www.toddwoolums.com/
asppoll.asp
target=_new><img src=images/poweredby.gif alt='Powered By ASP Poll'
border=0></a></td></tr></table></center>
<!--#include file="footer.inc"-->



.