我初学asp,菜鸟一只,这段代码的目的是想提交前先检查数据库里有没有同名的记录,如果有的话提示是否覆盖,用户确认后再添加,如果没有就直接添加。浏览器老是提示缺少对象,请高手看看到底哪里出问题了,先谢谢了
<HTML>
<HEAD>
<script language="javascript">
function addUser(id,stuName)
{ var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Driver={SQL server};Server=.;UID=sa;Password=1234;DATABASE=mydb;");
var rs=new ActiveXObject("ADODB.Recordset");
var sql="select * from stu where sname='"+stuName+"'";
rs.open(sql,conn);
if(!rs.EOF){
if(confirm(stuName+"用户已存在,确认覆盖吗?")){form1.submit();return true;}else return false;
else form1.submit();}
rs.close();
rs = null;
conn.close();
conn = null;
}
</script>
</HEAD><BODY>
<form action="2.asp?action=saveadd" method="post" name="form1" id="form1"><table width=100 border=1>
<tr bgcolor='#f4f4f4'>
<td>编号</td>
<td>姓名</td>
</tr>
<tr>
<td><input id="stuId" /></td>
<td><input id="stuName"/></td>
</tr>
</table>
<input name="1" type="button" value="添加" onClick="addUser(stuId.value,stuName.value)"/>
</form>
</BODY>
</HTML>
<HTML>
<HEAD>
<script language="javascript">
function addUser(id,stuName)
{ var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Driver={SQL server};Server=.;UID=sa;Password=1234;DATABASE=mydb;");
var rs=new ActiveXObject("ADODB.Recordset");
var sql="select * from stu where sname='"+stuName+"'";
rs.open(sql,conn);
if(!rs.EOF){
if(confirm(stuName+"用户已存在,确认覆盖吗?")){form1.submit();return true;}else return false;
else form1.submit();}
rs.close();
rs = null;
conn.close();
conn = null;
}
</script>
</HEAD><BODY>
<form action="2.asp?action=saveadd" method="post" name="form1" id="form1"><table width=100 border=1>
<tr bgcolor='#f4f4f4'>
<td>编号</td>
<td>姓名</td>
</tr>
<tr>
<td><input id="stuId" /></td>
<td><input id="stuName"/></td>
</tr>
</table>
<input name="1" type="button" value="添加" onClick="addUser(stuId.value,stuName.value)"/>
</form>
</BODY>
</HTML>
另外缺少对象提示在哪一行?
<script language="javascript" runat="server">
你看一下具体报的哪一行找不到对象