"count" is not working. I want to learn the data number

[evgin]

my code is:

alltable = "select count(*) As Toplam FROM haftalik_tablo"
Set rs = Baglanti.Execute(alltable)

ToplamKayit = rs("Toplam")
Response.Write ToplamKayit

But I am getting error. How can I get the ROW NUMBER of the database, I mean howmany data have been saved

[karlmcauley]

Is it a connection error?

Is it connecting fine but displaying an error in the returned results?

Post the error here then we can proceed from there.

Cheers

[evgin]

thank you very much , I have just solved