ssql= "select * from products where " & field & " like ' * " & value & " * ' " 就算value的值与相应的一样也是返回零行;
换成
ssql= "select * from products where " & field & " = ' " & value & " ' " 什么毛病都没有...
请问问题出在哪里?
------解决方案--------------------
ssql= "select * from products where " & field & " like '% " & value & "% ' "
------解决方案--------------------
ssql= "select * from products where " & field & " like '% " & value & "% ' "
------解决方案--------------------
2楼正解