求助
大虾.哪出的问题... 错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 '@@IDNETITY' 中。
/mysite/result.asp, 第 47 行
原代码
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.
<!-- #include file="db.inc.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>注册结果</title>
<style type="text/css">
<!-
body {
margin-top: 0px;
margin-bottom: 0px;
background-image: url();
background-repeat: no-repeat;
}
-->
</style></head>
<body>
<table width="800" border="0" align="center" cellspacing="0">
<tr>
<td width="218" height="72"> </td>
<td width="376"> </td>
<td width="200"> </td>
</tr>
<tr>
<td> </td>
<td align="center" valign="middle">
<%
set rst=server.CreateObject("ADODB.recordset")
rst.open "select * from user where u_user='"&request.Form("f-user")&"'",conn,1,1
if rst.recordcount>0 then
'如果用户名存在，对用户进行提示
response.Write("用户名"&request.Form("f_user")&"已经被占用，请点击后退返回上一页！")
rst.close
set rst=nothing
conn.close
set conn=nothing
response.end
else
rst.close
rst.open "user",conn,1,3
rst.addnew
rst("u_user")=request.Form("f_user")
rst("u_code")=request.Form("f_code")
rst.update
rst.close
set rst1=conn.execute("SELECT @@IDNETITY AS uid")
uid=rst1("uid")
rst.open
rst.addnew
rst("i_uid")=uid
rst("i_name")=request.Form("f_name")
rst("i_age")=request.Form("f_age")
rst("i_sex")=request.Form("f_sex")
rst("i_vip")=false
rst.update
rst.close
end if
%>
<img src="img/zcsb.jpg" width="355" height="240" /><br>
<img src="img/zccg.jpg" width="357" height="229" /></td>
<td> </td>
</tr>
<tr>
<td height="154"> </td>
<td> </td>
<td> </td>
</tr>
</table>
<%
set rst=nothing
conn.close
set conn=nothing
%>
</body>
</html>
高手们...
