set rs=server.CreateObject("adodb.recordset") sql="select * from nzcms_zb where day(dateandtime)="&request.querystring("xq")&"order by id desc" rs.open sql,conn,1,1