正确语句:

  if not conn.execute("select id from ks_comment where infoid=" & infoid & " and channelid=" & channelid & " and username='" & AnounName & "'").eof then

  response.write "你已发表过了!" :response.end

 end if

看来是没人管了.呵呵.

还是不行.

发过评论还能继续发.呵呵.

再给琢磨一下.谢谢.

试试以下修改方式

if not conn.execute("select id from ks_comment where infoid=" & infoid & " and channelid=" & channelid & " and username='" & username & "'").eof then

  response.write "<script>alert('你已发表过了!');</script>" :response.end

 end if

加了代码后,新增的文章都不能评论了.

一生有你,麻烦你再看看代码,看怎么再改一下.谢谢了.

谢谢了.

有你真好!

plus/comment.asp,500多行

Set RS=Server.CreateObject("ADODB.RECORDSET")

   if not conn.execute("select count(id) from ks_comment where infoid=" & infoid & " and channelid=" & channelid & " and username='" & username & "'").eof then

  response.write "<script>alert('你已发表过了!');</script>" :response.end

 end if

    if KS.C_S(Channelid,12)=1 Or KS.C_S(ChannelID,12)=3 then
   verific=0
    else
   verific=1
    end if