<%dim da,daurl,xiao1,xiao2,xiao3,xiao4,xiao5,xiao6,xiao7,xiao8,xiao1url,xiao2url,xiao3url,xiao4url,xiao5url,xiao6url,xiao7url,xiao8url,piao1,piao2,piao3,piao1url,piao2url,piao3url set rs=server.CreateObject("adodb.recordset") rs.open "select * from BJX_guanggao",conn,1,1 '左边广告 zuo1=trim(rs("458")) zuo1url=trim(rs("458url")) zuo2=trim(rs("1603")) zuo2url=trim(rs("1603url")) zuo3=trim(rs("1604")) zuo3url=trim(rs("1604url")) zuo4=trim(rs("1605")) zuo4url=trim(rs("1605url")) zuo5=trim(rs("2541")) zuo5url=trim(rs("2541url")) zuo6=trim(rs("2542")) zuo6url=trim(rs("2542url")) '中间广告 zhong1=trim(rs("2543")) zhong1url=trim(rs("2543url")) zhong2=trim(rs("1441")) zhong2url=trim(rs("1441url")) '右边广告 you1=trim(rs("1442")) you1url=trim(rs("1442url")) you2=trim(rs("1443")) you2url=trim(rs("1443url")) you3=trim(rs("1601")) you3url=trim(rs("1601url")) rs.close set rs=nothing %>