ASPÅжÏÎÊÌâ¡£

HTML code:
sql = "select top 1 * from cm_info where lm2='"&lm2&"' and (name='"&Request("name")&"' or haoma='"&Request("haoma")&"' or fenji='"&Request("fenji")&"')"
'response.write sql
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open sql,conn,1,2

if not(rs.bof and rs.eof) then
goexit "1.»úÖ÷Ãû»òÊÖ»úºÅÒÑ´æÔÚ;\n\n2.·Ö»úʶ±ðÂëÖظ´;\n\n¶Ô²»Æð£¬Çë·µ»ØÖØÌ"
response.end
end if

rs.addnew
¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£


ÉÏÃæwhereµÄÌõ¼þ£¬ÎÒÏë·Åµ½ÏÂÃæÀ´£¬²»ÔÚÓï¾äÀïÅжϣ¬Óï·¨ÊÇʲôÑùµÄ£¨Â鷳д³öÀ´£©

---

ÓÃÕâ¸öÌá½»Ò³ÃæµÄÓжà¸öµØ·½£¬¶¼Í¬ÓÃÕâÒ»Ò³£¬ÁíÍâÓеĵط½²»ÐèÒªÑéÖ¤nameÖظ´£¬ÎÒ¸ÃÔõôд£¿Â鷳Ҳд³öÀ´¡£

---

°Ñ(name='"&Request("name")&"'È¥µô²»¾ÍºÃÁË¡£¡£¡£»¹ÊÇÎÒÀí½â´íÁË£¿
sql = "select top 1 * from cm_info where lm2='"&lm2&"' and  haoma='"&Request("haoma")&"' or fenji='"&Request("fenji")&"')"
'response.write sql
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open sql,conn,1,2

    if not(rs.bof and rs.eof) then
        goexit &qu