![]() |
#2
hmhz2007-11-15 00:28
|
这个是检查用户名是否注册的代码
里面a是在javascript里定义的,,如何传值到下面的sql语句里面呢!
<script language="javascript">
var a
a=document.form1.t1.value
</script>
<% dim sqlcheck,rscheck,conncheck
connckeck="driver={microsoft access driver (*.mdb)};dbq="&server.MapPath("db.mdb")
set rscheck=server.CreateObject("adodb.recordset")
sqlcheck="select count(*) as bb from user where S_name=a"
rsckeck.open sqlcheck,connckeck,1,1
if rsckeck("bb")>0 then
msg"用户己注册"
end if
%>