I am using count(*) in my sql and it returns me the count how should I print it out on my web page.....syntex help
Select Count(*) as cnt from Table<BR><BR><%= rs("cnt") %>
select count(*) as the_number ......<BR><BR>obj_rec.open ...<BR><BR>response.write obj_rec.fields("the_number") <---- here is ..<BR><BR>HTH
This bit of code helped me with a little problem I had. Quick question, is there a way to count records in multiple columns with one SQL statement? Something where you would end up with the_number, the_number1, the_number2, etc.
mind give me a example?<BR><BR>I confused. The rec number should be the same in one rec? right?