[求助]请教高手
如何用这条 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
End if
