Getting recordset count

Results 1 to 2 of 2

Thread: Getting recordset count

  1. #1
    Join Date
    Dec 1969

    Default Getting recordset count

    Hello,<BR><BR> Qwik Question: How do I write out the result of this count.. see below, what do i put where " *****WhatDoIPutHere?***** " is?<BR><BR>strSQL= "select Count(*) from smcldeals where AdId = "&strAdId<BR> Set smclrs = smcldataconn.execute(strSQL)<BR> Response.Write *****WhatDoIPutHere?*****

  2. #2
    Join Date
    Dec 1969

    Default RE: Getting recordset count

    &#039;Wite the query as <BR>strSQL= "select Count(*) AS Reccnt from smcldeals where AdId = "&strAdId<BR>Set smclrs = smcldataconn.execute(strSQL)<BR>&#039;And then here<BR>Response.Write smclrs.fields("Reccnt")

Posting Permissions

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