KimSoft谢谢你,好历害啊。
如果数据库里面是这样存储的:
name explain
111 sony;vv;bb;cc;dd;001;002;ee;
222 dell:aa;dd;cc;dd;001;003;ee;
以下是我的程序,但什么也没显示:
sqla="select * from product where productsort=110 "
rsb.open sqla,conn,1,1
do while not rsb.eof
name=rsb("name")&".html"
explain=rsb("explain")
ArrayStr2=split(explain,";")
htmlcode=htmlcode&"<option value="&name&">"&ArrayStr2(1) & "</option>"
rsb.movenext
loop
rsb.close
response.write(htmlcode)