ASP 高手请指导下

发布网友发布时间：2023-01-12 05:29

共2个回答

热心网友时间：2023-10-30 17:17

cn="王"

rsuser.Open "Select * from [TB_CHARACTER] where USER_idx="&Sp_CabalNum& And character_name '%"&cn&"%' order by CHARACTER_idx asc",conndb
要不就这样改
if leth(trim(rs("character_name"),1))="王" Then
do while NOT rsuser.EOF
CHARACTER_idx=rsuser("CHARACTER_idx")
PlayTime=rsuser("CHARACTER_PLAYTIME")
%>
<table width="100%" height="124" border="1" cellpadding="2" bordercolor="#CCCCCC" style="border-collapse: collapse" id="table21">
<tr>
<td align="right" width="16%" height="22">姓名：</td>
<td width="17%" height="22" align="center"><%=rsuser("character_name")%></td>
end IF

热心网友时间：2023-10-30 17:18

改变一下查询的条件
dim character_name = "王"
sql = "select * from [TB_CHARACTER] where USER_idx="&Sp_CabalNum&" and character_name not like '"&character_name&"%'order by CHARACTER_idx asc"
rsuser.open sql,conndb,1,1