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

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

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

没有写上 where

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

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