婚礼女方代表致辞:ASP中怎么样在ACCESS中查找COSTID大于等于Request.form("aa"),小于等于Request.form("bb")的记录?

来源:百度文库 编辑:中科新闻网 时间:2024/07/03 10:47:46
希望能把具体的ASP语句写出来,拜托了...
以上各项都是整型的....比如查找(100~200)之间的所有数据

select * from tablename where costid between "&request.form("aa")&" and "&request.form("bb")

OR

select * from tablename where costid >="&request.form("aa")&" and costid<="&request.form("bb")