rss.open "select *,(select goodname from Card_catelist where id=wooolid) as wname from mobile1 where "&c&"='"&key&"' order by id desc",conn,1,1
jl=rss.recordcount
if jl=0 then
%>
<tr>
<td bgcolor="#FFFFFF" colspan="8" align="center" style="color:#CC0000;">提示：没有找到订单</td>
</tr>
<%
else
do while not rss.eof
set rsd=server.CreateObject("adodb.recordset")
ee ="num23123"
rsd.open "select card_num,card_pwd,flag,price,wooolid,state5,port from mobile where num = '"&rss("num")&"' and state4=0",conn,1,1
if rsd.eof or rsd.bof then
语法 大概是这样的 '"&rss("num")&"' 是上面读取出来的 结果是 AAAAA-0 而 num 是AAAAA 是比'"&rss("num")&"' 后面少了 -0
如果需要他们两个对等 .我要如何修改 这句SQL？
rsd.open "select card_num,card_pwd,flag,price,wooolid,state5,port from mobile where num = '"&rss("num")&"' and state4=0",conn,1,1
if rsd.eof or rsd.bof then
------解决方案--------------------
"select card_num,card_pwd,flag,price,wooolid,state5,port from mobile where num = '" & split(rss("num"),"-")(0) & "' and state4=0"