hi,

I am totally new in asp

I am using a data link to connect to my database (mySQL).
rs.open "" & strsql & "","FILE NAME=c:\Inetpub\wwwroot\machine.udl"

However, I cant used recordcount & absoluteposition in my application. It always return '-1' to me. I am wondering what's wrong in my code??

advanced thanks for those who able to help.

Hi cici,

The reason you get the return of -1 is because you have not set your cursor and by default you will have the minimium cursor adForwardOnly. to count records you would need to set atleast adOpenStatic.

Kens got some good info @ http://www.adopenstatic.com/faq/jetcursortypes.asp

Good Luck

Tim

TDA

thanks a lot. it really works!!