%set us=server.createobject("adodb.recordset") us.open "select * from product_type",cn,1,1 Set Rs=Server.CreateObject("Adodb.Recordset") Rs.Open"Select * from product where bnew='是'",cn,1,1 response.write rs("name") response.end %>