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，但实际是有记录的，不知为什么？

谢谢指导。