access2000文本字段不能用in('aaa,'bbb')?
做了个查询城市编号的小程序,可什么也没显示。
city="北京,广州,上海,深圳,南京,杭州,重庆,成都,西安,天津,无锡,苏州,珠海,宁波,汕头,温州,厦门,神州,长春,长沙,哈尔滨,武汉,沈阳,大连"
city2=split(city,",")
for i=0 to ubound(city2)
str=str&"'"&city2(i)&"',"
next
str=left(str,len(str)-1)'去掉结尾的逗号
sql="select * from city where city_name in ("&str&")"
set rs=cnn.execute(sql,,adcmdtext)
While (not rs.eof)
Response.Write rs("city_name")&":"&rs("city_id")&"<br>"
rs.movenext
Wend