SQL语句

我要查询fromTime和Totime在数据库中是否已经存在,我写的SQL是这样的:


sTm = "Select * from tableBook Where TableName='" & lstSite.List(xTmp) & "' And ExpireDate='" &dtpExpireDate.Value & "' and  fromTime between '" & Format(DTPicker1.Value, "hh:mm:00") & "' and '" & Format(DTPicker2.Value, "hh:mm:00") & "'
or ToTime between '" & Format(DTPicker1.Value, "hh:mm:00") & "' and '" & Format(DTPicker2.Value, "hh:mm:00") & "' And DatePart=" & cmbDatePart.ListIndex + 1

估计是红色的那段有错.

---

access数据库吗？access数据库中，如果是日期时间类型应该用#
VB code:
" and fromTime between #" & Format(DTPicker1.Value, "hh:mm:00") & "# and #" & Format(DTPicker2.Value, "hh:mm:00") & "# "

---

最讨厌这种写法了.

sTm = "Select * from tableBook Where TableName=? And ExpireDate=? and  fromTime between ? and ? or ToTime between ? and ? And DatePart=?"

这样写不就清楚了。
然后用ADO的COMMAND对象把参数值赋进去。

---

lz应该说明是哪方面问题

vb语法问题？