Problem med RecordCount i ASP

Fra http://www.eksperten.dk/spm/204974

Du skal bruge adOpenStatic i stedet for adOpenForwardOnly.

i stedet for set rs = con.execute(sql), kan du gøre sådan her:

set rs = server.createobject("adodb.recordset")
rs.open sql, cn, adOpenStatic, adLockReadOnly, adCmdText

//akj

set rs = Server.CreateObject("ADODB.Recordset")
rs.Open SQL, dbConn, adOpenKeySet, adLockReadOnly

Do While Not rs.EOF   
Set recordCount = dbConn.Execute(SQL)
osv.