日期的语法错误

[yh235]

我想把用户选择的日期 以日期的形式存到数据库里
这是SQL语句
sql = "Insert Into [zhanhui](title,img,shuoming,shijian,didian,riqi) Values('" & title & "','" & img & "','" & nei & "',#" & shijian & "#,'" & didian & "',#" & now() & "#)"
但是它却报错

Microsoft JET Database Engine '80040e07'
日期的语法错误 在查询表达式 '##' 中。
\wwwroot\bzj110\Info_upload.asp, line 31
========================================
是shijian那里的问题 我那怎么写错了?
该怎么写才对? 数据库里的是日期格式啊

[班门弄斧]

TO:xie_yanke(谢烟客)
now()是直接从access数据库取时间
但是SQL语句是这样写的吗?

[pzhuyy]

不要#

[班门弄斧]

sql = "Insert Into [zhanhui](title,img,shuoming,shijian,didian,riqi) Values('" & title & "','" & img & "','" & nei & "','" & shijian & "','" & didian & "','" & now() & "')"
注意:你取回的时间是否为空?你需要做检查,建议为空置上一默认的时间,如:1900-1-1

[hymxtang]

去掉所有的#

[yh235]

如果不加#的话会提示类型不匹配
jsnt_rd(C#ing...) 说的可能对 怎样才能知道是否为空?这是我全部的代码
<%
Set myrequest=new UpLoadClass
myrequest.open
img=session("fname")
If img="" Then img="wu"
title=replace(myrequest.Form("title"),"'","")
title=replace(title,"<","")
title=replace(title,">","")

shijian=replace(myrequest.Form("shijian"),"'","")
shijian=replace(shijian,"<","")
shijian=replace(shijian,">","")
nian=replace(myrequest.Form("nian"),"'","")
yue=replace(myrequest.Form("yue"),"'","")
ri=replace(myrequest.Form("ri"),"'","")

didian=replace(myrequest.Form("didian"),"'","")
didian=replace(didian,"<","")
didian=replace(didian,">","")

nei=replace(myrequest.Form("nei"),"'","")
if nei="" then nei="暂无内容"
%>
<!--#Include File="Conn.asp"-->
<%
sql = "Insert Into [zhanhui](title,img,shuoming,shijian,didian,riqi) Values('" & title & "','" & img & "','" & nei & "',#" & shijian & "#,'" & didian & "',#" & now() & "#)"
Conn.Execute(sql)
Conn.Close : Set Conn = Nothing
Session("fname")=""
Response.Write "<script>alert('添加成功!');location.href='Info_manage.asp'</script>"
%>

[xie_yanke]

在sql语句前写:

if isdate(shijian) then
shijian = cdate(shijian)
else
response.write "Error!" : response.End
end if

sql = "Insert Into [zhanhui](title,img,shuoming,shijian,didian,riqi) Values('" & title & "','" & img & "','" & nei & "','" & shijian & "','" & didian & "', " & now() & ")"

[xie_yanke]

不好意思,上面sql应该为:

sql = "Insert Into [zhanhui](title,img,shuoming,shijian,didian,riqi) Values('" & title & "','" & img & "','" & nei & "','" & shijian & "','" & didian & "', now())

now()直接从access数据库取时间.不必在程序外取时间.

[xie_yanke]

access可以直接这么写sql语句
sql = "Insert Into [zhanhui](title,img,shuoming,shijian,didian,riqi) Values('" & title & "','" & img & "','" & nei & "','" & shijian & "','" & didian & "', now())"
sql server 可以改写now()为getdate()