写入栏目失败，提示数据库语法错误？？？
先看看代码吧
- VBScript code
<% response.charset = "GBK" if session("Admin") = "" then call sussLoctionHref("非法登录","admin_login.asp") end if%><!--#include file="../Include/function.asp"--><!--#include file="../Data/conn.asp"--><% '添加栏目 if request.form("send") = "添加栏目" then dim nav,rs,sql nav = request.form("nav") if len(nav) < 2 or len(nav) > 5 then call errorHistoryBack("栏目不得少于2位大于5位") end if '新增之前验证是否重复 set rs = server.createobject("adodb.recordset") sql = "select * from Nav where NavName='"&nav&"'" rs.open sql,conn,1,1 if not rs.eof then call errorHistoryBack("此栏目已存在，无须添加") call close_rs call close_conn end if call close_rs '关闭销毁表 '新增 sql = "insert into Nav (NavName,Date) values ('"&nav&"',now())" conn.execute(sql) call close_conn '关闭销毁数据库 call sussLoctionHref("栏目新增成功","admin_nav.asp") end if %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>菲戈--栏目添加</title><link rel="stylesheet" type="text/css" href="css/login.css" /></head><body><div class="nav_col">栏目添加</div><div class="nav_show">栏目显示</div><div class="path"><a href="admin_nav.asp"><font color='#FF0000'>返回栏目管理</font></a></div><form id="form_nav_add" method="post" action="admin_nav_add.asp"> 栏目名称：<input type="text" name="nav" class="text" /> <input type="submit" name="send" value="添加栏目" class="submit" /></form></body></html>===================================================================================================
错误代码提示：
技术信息（用于支持人员）
错误类型：
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
/admin/admin_nav_add.asp, 第 34 行
浏览器类型：
Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; .NET CLR 2.0.50727; .NET4.0C; .NET4.0E; KB974488)
网页：
POST 58 ??? /admin/admin_nav_add.asp
POST Data:
nav=%B9%FA%C4%DA%D0%C2%CE%C5&send=%CC%ED%BC%D3%C0%B8%C4%BF
===============================================================================
数据库中的表就2个字段
NavName和Date
====================================================
貌似我觉得我这个没有写错，求解答
[解决办法]
Date是access的关键字，要用[]扩起
- VBScript code
'sql = "insert into Nav (NavName,Date) values ('"&nav&"',now())" sql = "insert into Nav (NavName,[Date]) values ('"&nav&"',now())"
[解决办法]
建议如下
sql = "insert into Nav (NavName,[Date]) values ('"&nav&"','"&now()&"')"