asp+access多字段查询

来源：百度知道 编辑：UC知道 时间：2024/05/17 02:10:02
select * from beijin where jf=true and userid='"&userid&

ACCESS-表beijin字段miyun值kh
想在筛选时增加一个筛选项要求符合字段miyun值kh
如何解决?
试了如下方法-也不行_恳请高手解答...
select * from beijin where jf=true and miyun=kh and userid='"&userid&

select * from beijin where jf=true and miyun='kh' and userid='"&userid&

miyun='kh'应该是字符类型吧，加上引号

select * from beijin where jf=true and miyun='kh' and userid='"&userid& & "'"

加单引号在后面.
另外,jf如果是字符型,就要改为这样:
select * from beijin where jf='true' and miyun='kh' and userid='"&userid& & "'"

你怎么用=号呢？

用like

select * from beijin where jf=true and miyun=kh and userid like '"&userid&