majidmir
پنج شنبه 14 خرداد 1388, 11:02 صبح
سلام
كد زير رو واسه ثبت نام كاربر گذاشتم ولي موقعي كه submit ميزنم تا توي بانك ذخيره بشه با خطا مواجهه ميشم ( همون كادر open , save cancel ) مياد ؟
<html dir="rtl">
<head>
<!-- #include virtual="/adovbs.inc"-->
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
</head>
<body>
<%
dim adocon,rs,stsql
set adocon=server.createobject("adodb.connection")
adocon.open "dsn=JOB"
set rs=server.createobject("adodb.recordset")
strsql="select * from KARJO"
rs.locktype=3
rs.open strsql,adocon
rs.addnew
rs.fields("name")=request.form("NAME")
rs.fields("FAMILY")=request.form("FAMILY")
rs.fields("FATHER")=request.form("FATHER")
rs.fields("birthday")=request.form("birthday")
rs.fields("CODE")=request.form("CODE")
rs.fields("LOCALbirth")=request.form("LOCALbirth")
rs.fields("GENDER")=request.form("GENDER")
rs.fields("LASTacademic")=request.form("LASTacademic")
rs.fields("academicNAME")=request.form("academicNAME")
rs.fields("UNIVERSITYNAME")=request.form("UNIVERSITYNAME")
rs.fields("AVG")=request.form("AVG")
rs.fields("CITY")=request.form("CITY")
rs.fields("TEL")=request.form("TEL")
rs.fields("STATUSmarried")=request.form("STATUSmarried")
rs.fields("STATUSCARD")=request.form("STATUSCARD")
rs.fields("USERNAME")=request.form("USERNAME")
rs.fields("PASSWORD")=request.form("PASSWORD")
rs.fields("EMAIL")=request.form("EMAIL")
rs.update
rs.close
SET RS=NOTHING
SET ADOCON=NOTHING
response.redirect(OKREGESTRY.html)
%>
</body>
</html>
كد زير رو واسه ثبت نام كاربر گذاشتم ولي موقعي كه submit ميزنم تا توي بانك ذخيره بشه با خطا مواجهه ميشم ( همون كادر open , save cancel ) مياد ؟
<html dir="rtl">
<head>
<!-- #include virtual="/adovbs.inc"-->
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
</head>
<body>
<%
dim adocon,rs,stsql
set adocon=server.createobject("adodb.connection")
adocon.open "dsn=JOB"
set rs=server.createobject("adodb.recordset")
strsql="select * from KARJO"
rs.locktype=3
rs.open strsql,adocon
rs.addnew
rs.fields("name")=request.form("NAME")
rs.fields("FAMILY")=request.form("FAMILY")
rs.fields("FATHER")=request.form("FATHER")
rs.fields("birthday")=request.form("birthday")
rs.fields("CODE")=request.form("CODE")
rs.fields("LOCALbirth")=request.form("LOCALbirth")
rs.fields("GENDER")=request.form("GENDER")
rs.fields("LASTacademic")=request.form("LASTacademic")
rs.fields("academicNAME")=request.form("academicNAME")
rs.fields("UNIVERSITYNAME")=request.form("UNIVERSITYNAME")
rs.fields("AVG")=request.form("AVG")
rs.fields("CITY")=request.form("CITY")
rs.fields("TEL")=request.form("TEL")
rs.fields("STATUSmarried")=request.form("STATUSmarried")
rs.fields("STATUSCARD")=request.form("STATUSCARD")
rs.fields("USERNAME")=request.form("USERNAME")
rs.fields("PASSWORD")=request.form("PASSWORD")
rs.fields("EMAIL")=request.form("EMAIL")
rs.update
rs.close
SET RS=NOTHING
SET ADOCON=NOTHING
response.redirect(OKREGESTRY.html)
%>
</body>
</html>