注册 登录
编程论坛 ASP技术论坛

请问如何实现模糊查询以下代码

skygg 发布于 2012-02-02 14:52, 477 次点击
    '//工单查询
    Sub BWS_chaxun()
    response.write "<div align=center>"
    response.write "<table width=60% height=50 border=0 align=center cellpadding=0 cellspacing=0>"
    response.write "<form name=form1 method=post action=index.asp?T=gdshow>"
    response.write "<tr><td width='30%' height='30'></td><td></td><td width='10%'></td></tr>"   
    response.write "<tr><td width='30%'>请输入维修部门:</td><td><input name=gdid type=text id=gdid like'*BX*' size=30></td><td width='10%'><input type=submit name=Submit value=查询></td></tr>"
    response.write "<tr><td width='30%' height='10'></td><td></td><td> width='10%'></td></tr>"
    response.write "</form>"
    response.write "</table>"
    response.write "</div>"
    end Sub
比如查询BX20120202093748
3 回复
#2
yms1232012-02-02 16:29
gdid like '%BX%'
模糊查询的通配符是%不是*号
#3
skygg2012-02-03 09:15
以下是引用yms123在2012-2-2 16:29:23的发言:

gdid like '%BX%'
模糊查询的通配符是%不是*号
'//工单查询
    Sub BWS_chaxun()
    response.write "<div align=center>"
    response.write "<table width=60% height=50 border=0 align=center cellpadding=0  
cellspacing=0>"
    response.write "<form name=form1 method=post action=index.asp?T=gdshow>"
    response.write "<tr><td width='30%' height='30'></td><td></td><td  
width='10%'></td></tr>"   
    response.write "<tr><td width='30%'>请输入维修部门:</td><td><input name=gdid type=text  
id=gdid like '%BX%' size=30></td><td width='10%'><input type=submit name=Submit value=查询
></td></tr>"
    response.write "<tr><td width='30%' height='10'></td><td></td><td>  
width='10%'></td></tr>"
    response.write "</form>"
    response.write "</table>"
    response.write "</div>"
    end Sub
还是查不到BX20120202093748
#4
skygg2012-02-03 09:50
    '//工单详情
    Sub BWS_gdshow(g)
    If Not post_chk() Then
     Response.write "不许外部提交数据!"
     else
    response.write "<div align=center>"
    Set rs = Server.CreateObject("ADODB.Recordset")
    sql="select * from baoxiu where bxid='"&g&"'"
    set rs=conn.execute(sql)
    if rs.eof and rs.bof then
    Response.Write("没有此工单,请检查!")
1