sql count

Results 1 to 3 of 3

Thread: sql count

  1. #1
    ASP man Guest

    Default sql count

    Can I view the number that represents the count of the sql query?<BR>CODE:<BR><BR>strSQL = "SELECT Count(&#039pkLogEntryID&#039) FROM TLogEntries WHERE kSessionID=&#039 202&#039"<BR><BR>Dim objRS<BR>Set objRS = Server.CreateObject("ADODB.Recordset") <BR>objRS.Open strSQL, Conn, adOpenForwardOnly, adLockReadOnly <BR> <BR>Response.Write objRS("pkLogEntryID")

  2. #2
    Join Date
    Dec 1969

    Default RE: sql count

    Response.write "value for count:" & objRS(0)You could also have used an alias name and then referenced that.
    Reviews of vaporizers
    Last edited by Jay; 04-16-2011 at 01:38 AM.

  3. #3
    ASP man Guest

    Default RE: sql count

    Yeah thanks.<BR>It worked.<BR>Stupid of me.<BR>It&#039s simple

Posting Permissions

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