问个复杂查询的问题？

[kilter]

写了段查询的语句，如下：

ssp01=request.form("ssp01")
ssp02=request.form("ssp02")
ssp03=request.form("ssp03")
rq=request.form("yzpk")
bsxz=request.form("bsxz")

set rs1=server.CreateObject("adodb.recordset")
rs1.Source="select * from match "
rs1.Open rs1.Source,conn,1,1
if not rs1.EOF then
j=1
while rs1("o"&j&"a")<>ssp01 and rs1("o"&j&"b")<>ssp02 and rs1("o"&j&"c")<>ssp03
sql=" select * from match where oja='" & ssp01 & "' and ojb='" & ssp02 & "' and ojc='" & ssp03 & "' "
wend
end if
else
sql=" select * from match where o1a='" & ssp01 & "' and o1b='" & ssp02 & "' and o1c='" & ssp03 & "' and rq='" & rq & "' "
end if
select case bsxz
case "01"
case "02"
sql=sql & " and match_name='name01'"
case "03"
sql=sql & " and match_name='name02'"
case "04"
sql=sql & " and match_name='name03'"
case "05"
sql=sql & " and match_name='name04'"
case "06"
sql=sql & " and match_name='name05'"
case "07"
sql=sql & " and match_name='name06' "
end select
end if
If sql = "" Then
Response.write"无该信息!"
End If
set rs=server.CreateObject ("ADODB.RecordSet")
RS.CursorLocation=adUseClient
RS.Open sql, Conn,adOpenKeyset

------------------------------------------------
主要的问题是，从前from得到的ssp01，ssp02，ssp03要跟数据库中的oia，oib，oic（i是从1到9）的比较相等，找到为之。然后建立sql语句，但是我这样写，调试的时候加入死循环，不对？请问怎么改？

[kilter]

re:

[kilter]

re::