Error Message: Rowset does not support fetching backward.

[briancostea]

I am not sure why I keep getting this message. I set the Lock and CursorTypes to 3. Any help would be appreciated.

Set rsAdd = Server.CreateObject("ADODB.Recordset")
rsAdd.LockType = 3
rsAdd.CursorLocation = 3
rsAdd.CursorType = 3
Set rsAdd = adoAdd.Execute(strSQL)

If Not rsAdd.EOF Then
rsAdd.MoveLast
End If

Thanks - Bri

 

[guitardave78]

you need to open the recordset rther than execute it in this case
so it would look like

Set rsAdd = Server.CreateObject("ADODB.Recordset")
rsAdd.LockType = 3
rsAdd.CursorLocation = 3
rsAdd.CursorType = 3
rsAdd.open strSQL


}...the bane of my life!

http://www.fuzzyd.co.uk