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't work...<BR><BR>Thanks!
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!!
Thanks! That's perfect!