nekdonekje

Works now, thanks

How can I count the number of data in a DB?For example table1:name------- entry1entry2entry3entry4entry5entry6How to count the number of entrys?Tried the COUNT but it seems I must be doing something wrong:set i = MyConnection.Execute("SELECT Count('name') AS [Not Null] FROM table1;")response.write(i)