I need count records, please helpme!

[seidel]

hello! I need count records selected after make this command

sql = "SELECT * FROM table Where ID = " + cstr(idinput)


how count selected records?

vbscript

thanks

 

[rtshort]

Use the RecordSet.RecordCount function.

Count = rs.RecordCount Rob
Just my $.02.

 

[seidel]

Many thansk fo ryour advice but .recordcount count ALL records in my database.... not count selected records....

example: my database have 100 records when make a sql call I selected 45(example) records, how count this records?

thanks

 

[fleckingerre]

Hi!

Perform another Query and read out the value:

sql = "SELECT COUNT(*) FROM table Where ID = " + cstr(idinput)

Greetings
Remo

 

[seidel]

Many thanks! for your advice!

 

[seidel]

Many thanks for your help to my question! i solved!, opne my database in the correct form and these methos run ok!

thanks again!