SQL Count(*)

Results 1 to 2 of 2

Thread: SQL Count(*)

  1. #1
    Madhav Guest

    Default SQL Count(*)

    i need to get count (*) from a sql database using asp Page<BR><BR>How to get it<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Count(*)

    &#060;% <BR>Set conn = Server.CreateObject("ADODB.Connection")<BR>conn.Op en "...the connection string to your db..."<BR>Set RS = conn.Execute( "SELECT Count(*) FROM someTable" )<BR>theCount = RS(0)<BR>RS.Close<BR>...<BR>%&#062;<BR>

Posting Permissions

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