Microsoft JET Database Engine error '80040e10'
- From: TonnyD <tt_chatter@xxxxxxxxxxx>
- Date: Tue, 27 Nov 2007 19:47:43 -0800 (PST)
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"-->
.
- Follow-Ups:
- Re: Microsoft JET Database Engine error '80040e10'
- From: Daniel Crichton
- Re: Microsoft JET Database Engine error '80040e10'
- Prev by Date: Re: Huge memory comsumption of ADODB Connection object
- Next by Date: Microsoft JET Database Engine error '80040e10'
- Previous by thread: Re: Huge memory comsumption of ADODB Connection object
- Next by thread: Re: Microsoft JET Database Engine error '80040e10'
- Index(es):