高手帮我看这段加记录的代码哪里错了,怎么写不到数据库里
<%
if Request.Cookies(gghh_Sys)( "Username ") <> " " then
set rsc=server.CreateObject( "adodb.recordset ")
sql= "select * from xiaoxi "
rsc.open sql,conn,1,3
rsc.addnew
rsc( "fjr ")=Request.Cookies(Gaobei_Sys)( "truename ")
rsc( "sjr ")=request.form( "select ")
rsc( "biaoti ")=request.form( "T1 ")
rsc( "zhenwen ")=request.form( "s1 ")
rsc( "time ")=now
rsc.update
rsc.close
set rs=nothing
response.write " <script> alert( '提交成功! ') </script> "
else
response.write " <script> alert( '你还未登录! ') </script> "
end if
%>
------解决方案--------------------rsc( "time ")=now
改成
rsc( "time ")=now()
------解决方案--------------------rsc( "time ")=now
in access user now()
in sql user getdate()
------解决方案--------------------基本没有问题,除了
rsc( "time ")=now
改成
rsc( "time ")=now()
还有set rs=nothing改成set rsc=nothing