帮忙看看这个SQL语句的错误~~~~~~~~先谢谢了！

[fluterheart]

SQL字段类型是datetime型，表的字段是submit_time我在前台提供了时间段查询，但页面显示错误：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
/efy/delator/admin/sch.asp, 第 61 行---------这个行是：


zrs.open"SELECT * FROM informations where jbbm='"&jbbm&"' and xianshi='否' and submit_time between #date1# and #date2# ORDER BY submit_time desc ",zcon,1,1


我在前台是这样得到的时间串实现的：

jbbm = session("jbbm")
date1 = request.Form("y1")&"-"&request.Form("y2")&"-"&request.Form("y3")
date2 = request.Form("y3")&"-"&request.Form("y4")&"-"&request.Form("y5")
if jbbm <> "" then
zrs.open"SELECT * FROM informations where jbbm='"&jbbm&"' and xianshi='否' and submit_time between #date1# and #date2# ORDER BY submit_time desc ",zcon,1,1



帮忙分析错误，请改正

[ling_l]

你把字段改date

[ttt2]

jbbm = session("jbbm")
date1 = request.Form("y1")&"-"&request.Form("y2")&"-"&request.Form("y3")
date2 = request.Form("y3")&"-"&request.Form("y4")&"-"&request.Form("y5")
if jbbm <> "" then
zrs.open"SELECT * FROM informations where jbbm='"&jbbm&"' and xianshi='否' and submit_time between '"&date1&' and '"&date2&"' ORDER BY submit_time desc ",zcon,1,1

[wesheng]

目前取得的date1,date2是字符类型的.你可以试试将其转化为DATE类型

[angelheavens]

jbbm = session("jbbm")
'转换时确保各参数值是数字,否则出错
date1 = CDate(request.Form("y1")&"-"&request.Form("y2")&"-"&request.Form("y3"))
date2 = CDate(request.Form("y3")&"-"&request.Form("y4")&"-"&request.Form("y5"))
if jbbm <> "" then
zrs.open "SELECT * FROM informations where jbbm='"&jbbm&"' and xianshi='否' and DateDiff('d',submit_time,'"&date1&"')>=0 and DateDiff('d',submit_time,'"&date2&"')<=0 ORDER BY submit_time desc ",zcon,1,1

[amadou]

date1 = cdate(request.Form("y1")&"-"&request.Form("y2")&"-"&request.Form("y3"))
date2 = cdate(request.Form("y3")&"-"&request.Form("y4")&"-"&request.Form("y5"))

[叮咚叮咚叮叮咚]

同意楼上

[QCB181]

SELECT * FROM informations where jbbm='"&jbbm&"' and xianshi='否' and submit_time > #date1# and submit_time<#date2# ORDER BY submit_time desc

[weige250]

顶

[cxty]

不要＃号