sql count()

Results 1 to 2 of 2

Thread: sql count()

  1. #1
    Join Date
    Dec 1969
    Posts
    373

    Default sql count()

    how can i implimet the sql&#039;s count() in the in my sql statement?<BR>thanx.<BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    2,437

    Default RE: sql count()

    set connect = server.createobject("adodb.connection")<BR>connect .open dsn<BR>sql = "select count(*) as numberOfRows from ogrish"<BR><BR>set rs = connect.execute(sql)<BR>response.write "Number of rows: " & rs("numberOfRows") & "<BR>"<BR>rs.close<BR>connect.close

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •