sql查询语句问题

wenhao 发布于 2008-01-04 11:09， 690 次点击

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

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

7 回复

hangxj2008-01-04 11:17

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

2、search_text2 < search_text3

wenhao2008-01-04 11:24

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

wenhao2008-01-04 11:25

笔误不好意思

没有写上 where

hangxj2008-01-04 11:25

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

wenhao2008-01-04 11:28

是这个吗

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

hangxj2008-01-04 11:30

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

wenhao2008-01-04 11:33

好了,谢谢,

哈哈,

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