[ÇóÖú]Çë½Ì¸ßÊÖ

ÊÍ·ÅѹÁ¦

ÈçºÎÓÃÕâÌõ strSQL="Select * from CustomerInfo Where  gzlx='"& strlx & "'" ²éѯ´úÂë²éÕÒACCESSÊý¾Ý¿âÖÐÀàÐÍΪgzlxµÄÊý¾Ý¡£
<%
strUSN=Session("usn")
strPWD=Session("pwd")
strisAdmin=Session("isadmin")
strBB=Trim(Request.QueryString("BB"))
strSE=Trim(Request.QueryString("SE"))
strFS=Trim(Request.QueryString("fs"))
strLX=Request.QueryString("LX")
strMP=Trim(Request.QueryString("MP"))
'Response.Write strMP
pageNo=Trim(Request.QueryString("pageNo"))
if pageNo="" then
pageNo=1
else
  if isnumeric(pageNo) then
  if pageNo<=strMP then
  pageNo=Cint(pageNo)
  else
  pageNo=1
  end if
  else
  pageNo=1
  end if
end if
%>
<!--#include file="main.asp"-->
<form action="queryinfo.asp">
<table width=100% cellpadding=0 bordercolordark='#FFFFFF' cellspacing=0 cellpadding=1 border=1 bordercolorlight=darkblue>
<tr bgcolor=#000099>
<td align=center><font size=2 color=white>񅧏</font></td>
<td align=center colspan=2><font size=2 color=white>¹æÕÂÃû³Æ</font></td>
<td align=center><font size=2 color=white>Õ½Ú</font></td>
<td align=center><font size=2 color=white>ÌõÄ¿</font></td>
<td align=center><font size=2 color=white>¹Ø¼ü×Ö</font></td>

<%
  if strisAdmin="T" then
%>
<td align=center colspan=3><font size=2 color=white>²Ù×÷</font></td>
<%
end if
%>
</tr>
<%
if strUSN<>"" and strPWD<>"" then
'=============================================
if strLX="JG" then
   if strlx<>"" then
     strSQL="Select * from CustomerInfo Where  gzlx='"& strlx & "'"
   end if
else
if strlx="XG" then
   if strlx<>"" then
     strSQL="Select * from CustomerInfo Where gzlx='"& strlx & "'"
   else
     strSQL="Select * from CustomerInfo"
   end if
End if

´ó½ÖíÍ·

ACCESSÊý¾Ý¿âÖÐ×Ö¶ÎÃûΪgzlx¡£(gzlxÖÐÓиֱÊ\Ǧ±Ê\ÏðƤµÈ)LX ÊÇÉÏÒ»Ò³±íµ¥ÖÐÃû³Æ
strLX=Request.QueryString("LX")
ÓÃÕâÌõ strSQL="Select * from CustomerInfo Where  gzlx='"& strlx & "'" ²éѯ´úÂë²éÕÒACCESSÊý¾Ý¿âÖÐÀàÐÍΪgzlxµÄÊý¾Ý¡£

±ß×ß¡è±ß°®

˵µÄ¾ßÌåÒ»µãºÃÂð?