在线的朋友过来看看。一个ｓｑｌ语句的问题。速战速决。ｏｋ？
sql=sql&" and (datediff(s,begin_time,#"&begin_time1&"#)>0 and datediff(s,end_time,#"&begin_time1&"#)<0) or (datediff(s,begin_time,#"&end_time1&"#)>0 and datediff(s,end_time,#"&end_time1&"#)<0)" 问题点数：20、回复次数：8Top
1 楼beyond_xiruo（CorruptionException）回复于 2001-12-23 16:39:16 得分 10
sql=sql&" and ((datediff(s,begin_time,#"&begin_time1&"#)>0 and datediff(s,end_time,#"&begin_time1&"#)<0) or (datediff(s,begin_time,#"&end_time1&"#)>0 and datediff(s,end_time,#"&end_time1&"#)<0))"
少了一对括号！
括号太多了……Top
2 楼xiaoshi（累）回复于 2001-12-23 16:45:02 得分 0
不行
不是括号的问题
我改过了
还是那个样子
OLE DB Provider for ODBC Drivers 错误 '80040e21'
Top
3 楼xiaoshi（累）回复于 2001-12-23 16:47:43 得分 0
这个是access数据库
datediff(s, begin_time, #"&begin_time1&"#)>
解释： 数据库字段 字符串
Top
4 楼xiaoshi（累）回复于 2001-12-23 16:58:13 得分 0
等待Top
5 楼25475360（说的容易做来难）回复于 2001-12-23 18:49:26 得分 10
前面的字符窜有没有问题呀Top
6 楼xiaoshi（累）回复于 2001-12-23 18:51:11 得分 0
是不是因为access不支持这个阿Top
7 楼25475360（说的容易做来难）回复于 2001-12-23 18:54:31 得分 0
能否详细一点给我看,我以前看过这样的贴子Top
8 楼xiaoshi（累）回复于 2001-12-23 19:09:10 得分 0
set rs=server.createobject("adodb.recordset")
sql="select * from room where 1=1 "
if trim(request("hotel"))<>"" then sql=sql&" and id_hotel='"&request("hotel")&"'"
if trim(star)<>"" then sql=sql&" and (star='"&star&"')"
if trim(price)<>"" then
if trim(price)=1 then sql=sql&" and m_price <'100'"
if trim(price)=2 then sql=sql&" and m_price >='100' and m_price <='200'"
if trim(price)=3 then sql=sql&" and m_price >'200' and m_price <='300'"
if trim(price)=4 then sql=sql&" and m_price >'300' and m_price <='400'"
if trim(price)=5 then sql=sql&" and m_price >'400' and m_price <='500'"
if trim(price)=6 then sql=sql&" and m_price >'500' and m_price <='600'"
if trim(price)=7 then sql=sql&" and m_price >'600' and m_price <='800'"
if trim(price)=8 then sql=sql&" and m_price >'800' "
else
sql=sql&""
end if
if trim(begin_time1)<>"" and trim(end_time1)<>"" then
'sql=sql & " and (begin_time between '#" & begin_time1 & "#' and '#" & end_time1 & "#') or (end_time between '#" & begin_time1 & "#' and '#" & end_time1 & "#') "
'sql=sql&" and (datediff(s,begin_time,#"&begin_time1&"#)>0 and datediff(s,end_time,#"&begin_time1&"#)<0) or (datediff(s,begin_time,#"&end_time1&"#)>0 and datediff(s,end_time,#"&end_time1&"#)<0 ))"
'sql=sql&" and ((datediff(dd,begin_time,#"&begin_time1&"#)> 0 and datediff(dd,end_time,#"&begin_time1&"#) < 0) or ( datediff(dd,begin_time,#"&end_time1&"#) > 0 and datediff(dd,end_time,#"&end_time1&"#) < 0 ))"
'sql=sql&" and ((datediff(s,#"&begin_time1&"#,begin_time)> 0 and datediff(s,#"&begin_time1&"#,end_time) < 0) or ( datediff(s,#"&end_time1&"#,begin_time) > 0 and datediff(s,#"&end_time1&"#,end_time) < 0 ))"
sql=sql&" and (('#"&begin_time1&"#'>=begin_time and '#"&begin_time1&"#'<=end_time) or ('#"&end_time1&"#'>=begin_time and '#"&end_time1&"#'<=end_time)) "
end if
sql=sql&" order by updatetime desc"
response.write sql
rs.open sql,conn,1Top
