ASP结果集的记录数都是-1,但实际是有记录的,不知为什么?
dim Sql
Sql=“SELECT site_no as value,site_desc as name FROM dbo.产品类”
Set SITEds_cmd = Server.CreateObject (“ADODB.Command”)
SITEds_cmd.ActiveConnection = MM_xfydata_STRING
SITEds_cmd.CommandText = “SELECT site_no as value,site_desc as name FROM dbo.产品类”
SITEds_cmd.Prepared = true
Set rs = SITEds_cmd.Execute
response.Write rs.recordcount
结果都是-1,但实际是有记录的,不知为什么?
谢谢指导。