求助：rs.recordcount 返回值为 -1，怎么回事？

[zuida]

……
set rs=conn.execute("select gsname from tcinfor where gsname='"&gsname&"'")
if rs.recordcount>0 then
set rs=nothing
response.Write "<script language=JavaScript>{window.alert('同一记录不能重复添加!');window.location.href='admin_writeto.asp';}</script>"
response.End()
end if
set rs=nothing
……

我调试了好几次都没成功，好来发现　rs.recordcount返回值每次都是-1，这是怎么回事呢？

[zuida]

自己顶一下，大家帮帮我吧！～

[Mapleleaf123]

set rs=conn.execute...不支持recordcount
要
set rs = Server.CreateObject("adodb.recordset")

[chenguang79]

set rs = Server.CreateObject("adodb.recordset")
strsql = "select gsname from tcinfor where gsname='"&gsname&"'"
rs.open strsql conn 2,3

[DieGhost]

conn.CursorLocation=3
set rs=conn.execute("select gsname from tcinfor where gsname='"&gsname&"'")
if rs.recordcount>0 then
...

[zuida]

还是不行，我成　set rs = Server.CreateObject("adodb.recordset")……　这种方式了，还是返回-1

[Mapleleaf123]

贴多点代码出来看看

-------------------

set rs = Server.CreateObject("adodb.recordset")
rs.open "select gsname from tcinfor where gsname='"&gsname&"'",conn,1,1

[DieGhost]

Mapleleaf123() ( ) 信誉：100 Blog 2006-12-02 09:58:49 得分: 0


set rs=conn.execute...不支持recordcount
要
set rs = Server.CreateObject("adodb.recordset")


-----------------------------------------------
汗~~~~~~~~~~~~~~~~~

[zuida]

成功了，DieGhost(☆小过)　正解，非常感谢！～