% sql="select * from user where menu='sale' order by id" Set rs= Server.CreateObject("ADODB.Recordset") rs.open sql,conn,1,1 %>