Results 1 to 3 of 3

Thread: Count

  1. #1
    E Guest

    Default Count

    When you say: "select count(*) from tablename" and you set:<BR><BR>rs = conn.execute(sql)<BR><BR>How do you retrieve the answer? rs("count") doesn&#039;t work...<BR><BR>Thanks!

  2. #2
    Join Date
    Dec 1969

    Default for ease of use...

    do "select count(*) as acount from tablename" instead so you can have rs("acount") to retrieve it, there is another way however --rs(0)--, but when i do multiple counts on the same page, i just us the "as" clause...hope this helps!!

  3. #3
    Join Date
    Dec 1969

    Default Thanks...

    Thanks! That&#039;s perfect!

Posting Permissions

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