This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / In my ASP page, I use sql to count the records of a table.sqlstring="SELECT COUNT(group_id) FROM table WHERE *** "
Then I want to display the result (the number of the records) on web page, what syntax to use? Please give me hand. THANKS !
-waokool(waokool);
2002-8-25
{191}
(#712338@0)
-
"SELECT COUNT(group_id) as total FROM table WHERE *** "
>>>>>>
rs("total")
-nice2002(floater);
2002-8-25
(#712340@0)
-
Great ! It works. Thank you very much.
-waokool(waokool);
2002-8-25
(#712349@0)
-
count(*) will work and move the condition to its proper positon.
-henhen(哼哼~~,找工ing~~~~);
2002-8-25
(#712341@0)