BETWEEN AND 的应用


search_text2=cint(request("search_text2"))
search_text3=cint(request("search_text3"))

set rs=server.CreateObject("adodb.recordset")
sql="select * from product Buy BETWEEN "&search_text2&" AND "&search_text3&
sql=sql&" order by ID desc"
rs.open sql,conn,1,1

这句有误,该怎么写,谢谢

1、 sql="select * from product  Where Buy BETWEEN "&search_text2&" AND "&search_text3&

2、search_text2 < search_text3

对,经我给的条件是这样的的\

没有写上 where

麻烦LZ认真查看我写的第一点中与你给的有什么区别

where
?????????????

那你现在用了Where之后有什么提示？正确了没？

哈哈,
你的提醒,有点急,马虎了