%
Dim Conn,ConnStr,DBPath
Dim sql,Rs,arrRs
Dim arrRsNumS,arrRsNumI
DBPath = "love/love.asp"
ConnStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & Server.MapPath(DBPath)
On Error Resume Next
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open ConnStr
If Err Then
err.Clear
Set Conn = Nothing
Response.Write "数据库连接出错,请检查连接字串。"
Response.End
End If
sql = "Select top 15 cid,cdate,cauthor,left(ccontent,50),cbcolor,cfcolor from ccc_love order by cID DESC"
Set Rs = Conn.Execute(sql)
arrRs = Rs.GetRows
Rs.Close
Set Rs = Nothing
Conn.Close
Set Conn = Nothing
arrRsNumS = UBound(arrRs,2)
%>