日期:2014-05-17  浏览次数:20893 次

高手帮我看这段加记录的代码哪里错了,怎么写不到数据库里
<%
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