SELECT COUNT(*)...[SELECT COUNT(*) AS totale...]

[master87tm]

Ciao a tutti,

Tra le due query quale conviene usare?

1.

Sql_uno= "SELECT COUNT(*) FROM messaggi WHERE utente= 'master87tm' "
Set objRS= adoCon.Execute(Sql_uno)
tot_img= objRS(0)
totali = Clng(tot_img)
set objRS = nothing

2.

SQLcount = "SELECT COUNT(*) AS totale FROM messaggi WHERE utente= 'master87tm' " 
Set adoRstCount=adoCon.Execute(SQLcount)
totali = Clng(adoRstCount("totale"))
adoRstCount.Close
Set adoRstCount=Nothing

grazie,

ciao

roby