Jump to content

nekdonekje

Members
 View Profile  See their activity

  • Posts

    2

  • Joined

  • Last visited

 Content Type 

Posts posted by nekdonekje

    Counting data in a DB

    in ASP

    Posted

    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)

×
×
  • Create New...