错了,一个小于号写错了.应该是大于号.
ww="230"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Select * From table2 where 重量min <"&ww&" and 重量max >"&ww&"", conn,3,3
response.write rs("倍率")*conn.execute("Select 基本费率 from [table1 ] where id="&rs("类型"))(0)
ww="230"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Select * From table2 where 重量min<"&ww&" and 重量max<"&ww&"", conn,3,3
response.write rs("倍率")*conn.execute("Select 基本费率 from [table1 ] where id="&rs("类型"))(0)