|
#2
gupiao1752010-08-26 19:44
request.Form("zhi")输出的值是什么？有认真看过没有，
按理说，如果request.Form("zhi")的值是TOYES ，那么即使查不到数据也不可能会查找到sun flower series  |
我用下面的模糊代码 怎么不能搜索到下面的 标题 比如我输入TOYES 搜索出的结果却是 sun flower series
set rss=server.createobject("adodb.recordset")
exec="select * from ejl where bt like '%"&request.Form("zhi")&"%'"
rss.open exec,conn,1,1
我的bt的内容是
PEONY SERIES
LOTUS SERIES
SUN FLOWER SERIES
BASKETBALL STAND SERIES
TABLE TENNIS TABLE SERIES
COMPETITION GAMES
CHILDREN'S COMBINATION
NAUGHTY CASTLE
TRAMPOLINE
TOYES
LEISURE BENCH
LEISURE LANDSCAPE
RUBBER TILE
TURF
FRAMEWORK FENCE
GROUND LIGHTING
LITTER BIN
ROAD FACILITIES