sql="select a, b from table where 1=1"
sql=sql&" and a like '%"&keyword1&"%' " '条件1
if b<>"文字" then sql=sql&" and a like '%"&keyword2&"%' " '条件2(当table.b不等于"文字"时所满足的条件),运行报错,"无效字符"
望高手帮忙看看?
...全文
461打赏收藏
数据库条件检索问题
sql="select a, b from table where 1=1" sql=sql&" and a like '%"&keyword1&"%' " '条件1 if b"文字" then sql=sql&" and a like '%"&keyword2&"%' " '条件2(当table.b不等于"文字"时所满足的条件),运行报错,"无效字符" 望高手帮忙看看?