标题:求高手指点!!!ASP条件判断的问题
取消只看楼主
hancycrystal
Rank: 2
等 级:论坛游民
帖 子:8
专家分:10
注 册:2010-8-31
结帖率:50%
已结贴  问题点数:20 回复次数:2 
求高手指点!!!ASP条件判断的问题
<%Dim strName ,strSynopsis ,srtTime , strAddressID
    strName = trim(Request.Form("name"))
    strSynopsis = trim(Request.Form("Synopsis"))
    strTime = trim(Request.Form("time"))
    strAddress = trim(Request.Form("Address"))

    Dim rs ,sql
    Set rs = Server.CreateObject("ADODB.Recordset")
    sql = "SELECT * FROM sms "
    rs.open strSql,conn,1,1
    If Not rs.EOF Then
        If rs("name") = strName and rs("starttime") = strTime and rs("Address") <> strAdress Then
        Response.Write("时间冲突!")
        ElseIf rs("name") <> strName and rs("time") = strTime and rs("Address") = strAdress Then
        Response.Write("课程冲突!")
        ElseIf rs("name") = strName and rs("time") <> strTime and rs("Address") = strAdress Then
        Response.Write("地点冲突!")
    Else
    rs.Close
    sl = "INSERT INTO sms (name,Synopsis,time,Address) Values('"& strName &"','"& strSynopsis &"','"& strTime &"','"& strAddress &"')"
    rs.open sql,conn,3,1
    Response.Write("<br><br><br><div align=center>添加成功!</div>")
    End If%>但是一直报错,请问还如何处理?
搜索更多相关主题的帖子: sql 条件 
2012-05-23 19:14
hancycrystal
Rank: 2
等 级:论坛游民
帖 子:8
专家分:10
注 册:2010-8-31
得分:0 
别沉了……
2012-05-23 20:16
hancycrystal
Rank: 2
等 级:论坛游民
帖 子:8
专家分:10
注 册:2010-8-31
得分:0 
回复 3楼 wangjy500
缺少End
2012-05-24 16:40



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-367932-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 1.825534 second(s), 8 queries.
Copyright©2004-2025, BCCN.NET, All Rights Reserved