I created the below javascript to check whether the given email id is already exixt in ms access database and getting the below error. Could anyone please help me to get rid of this. Thanks in advance...
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
<html>
<head>
<script>
function fnchk()
{
var eid = document.f1.t1.value;
var cn = new ActiveXObject("ADODB.Connection");
var rs = new ActiveXObject("ADODB.Recordset");
cn.open("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=/\dth.accdb;");
var qry = "select * from reg where email = '"+ eid +"'";
rs.open(qry,cn,1,3);
if(eid == rs.fields("email").value)
{
alert("Email exists");
}
else
{
alert("Email not exist");
}
rs.close();
cn.close();
}
</script>
</head>
<body>
<form name="f1">
<input type="text" name="t1">
<input type="button" value="ok" onclick="fnchk();">
</form>
</body>
</html>
I myself got resolved the issue by updating the script below: Thanks everyone..!