% Set rs = Server.CreateObject("ADODB.Recordset") sql="select Manpower from Market" rs.open sql,conn,1,1 %>