my code as under
------------------
it edit ring routine
<%if session("granted") = false then
response.redirect("unauth.htm")
else
end if
dim objRS
set objRS = Server.CreateObject("ADODB.Recordset")
objRS.open ("Select * from tblRings "), conn,1,3
%>
<html>
<head>
<title>Epza Admin</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<Script language="JavaScript">
function checkData(){
if (document.frm.item_id.value == "" ||document.frm.item_id.value=="0") {
alert("Please Select the Ring Name")
document.frm.item_id.focus()
return false}
}
</Script>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="784" border="0">
<tr>
<td><b>Edit
Ring</b></td>
</tr>
</table>
<form action="./info_ring.asp" method="post" name="frm" id="frm" onSubmit="return checkData()">
<table width="44%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="35%"><strong>Ring
Name </strong></td>
<td width="65%"> <strong>
<strong>
<select name="item_id">
<option value="0" selected>Select Ring Name</option>
<%
while objRS.eof <> true
%>
<option value="<%=objRS("item-id")%>"><%=objRS("name")%></option>
<%
objRS.movenext()
wend
%>
</select></strong>
</strong></td>
</tr>
<tr>
<td><input type="submit" value="Select" name="Submit"></td>
</tr>
</table>
</form>
</body>
</html>
<%
objRS.close
conn.close
%>
----------------------------------
it is info_ring routine
<%if session("granted") = false then
response.redirect("unauth.htm")
else
end if
itemid=request("item_id")
set objRS = Server.CreateoBject("Adodb.Recordset")
objRS.open ("select * from tblRings where item-id = " &cint(itemid) ), conn,1,3
%>
<html>
<head>
<title>Epza Admin</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_validateForm() { //v4.0
var i,p,q,nm,test,num,min,max,errors='',args=MM_valida teForm.arguments;
for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=MM_findObj(args[i]);
if (val) { nm=val.name; if ((val=val.value)!="") {
if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');
if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n';
} else if (test!='R') { num = parseFloat(val);
if (isNaN(val)) errors+='- '+nm+' must contain a number.\n';
if (test.indexOf('inRange') != -1) { p=test.indexOf(':');
min=test.substring(8,p); max=test.substring(p+1);
if (num<min || max<num) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n';
} } } else if (test.charAt(0) == 'R') errors += '- '+nm+' is required.\n'; }
} if (errors) alert('The following error(s) occurred:\n'+errors);
document.MM_returnValue = (errors == '');
}
//-->
</script>
<Script language="JavaScript">
function checkData(){
if (document.addprd.memid.value == "" ||document.addprd.memid.value=="0") {
alert("Please Select the Messers Name")
document.addprd.memid.focus()
return false}
if (document.addprd.product_name.value == "" ||document.addprd.product_name.value=="0") {
alert("Please Select the Product Name")
document.addprd.product_name.focus()
return false}
}
</Script>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="784" border="0">
<tr>
<td><b>Edit
Product</b></td>
</tr>
</table>
<form action="updateproduct.asp" method="post" name="addprd" id="addprd" onsubmit="return checkData()">
<table width="478" border="0">
<tr>
<td width="82"><b>Ring
Name </b> </td>
<td width="386"><input name="ring_name" type="text" value="<% = objRS("name")%>"></td>
</tr>
<tr>
<td><b> Description</b></td>
<td><textarea name="desc" id="textarea"><%=objRS("desc")%></textarea></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td><input name="Submit" type="submit" class="gy" style="BACKGROUND-COLOR: #98BADC; BORDER-BOTTOM-COLOR: #69f; BORDER-BOTTOM-STYLE: outset; BORDER-LEFT-COLOR: #69a; BORDER-LEFT-STYLE: outset; BORDER-RIGHT-COLOR: #69f; BORDER-RIGHT-STYLE: outset; BORDER-TOP-COLOR: #69f; BORDER-TOP-STYLE: outset; COLOR: #fff; FONT-WEIGHT: bold" onClick="MM_validateForm('messer_name','','R','ema il_address','','NisEmail','Representative_name','' ,'R','location','','R');return document.MM_returnValue" value="Update"></td>
</tr>
</table>
</form>
<p> </p>
</body>
</html>
<%
objRS.close
conn.close
set obj.RS = nothing
set conn = nothing
%>
--------------------------
the data is properly post but error shown
whats wrong pls help me
Microsoft JET Database Engine (0x80040E10)
Strive for Perfection