if Len(number)<>11 then Response.Write " 手机号应该为11位! " else numbe = Left(number,7) db="zhangwocn.mdb" Set conn = Server.CreateObject("ADODB.Connection") connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"") conn.Open connstr set rs=server.CreateObject("adodb.recordset") rs.Open "select * from [mobile] where "&numbe&">=number1 and "&numbe&"<=number2 " ,conn,1,1 if rs.recordcount = 0 then Response.Write "对不起,没有你要查询的号码!" else sm=rs("sm") dm=rs("dm") qh=rs("qh") jg=rs("jg") rs.close set rs=nothing conn.close set conn=nothing %> 你查询的手机号: