EASY: Counting records 2

[TheConeHead]

what is the sql command to count a number of records that are returned in a query?

 

[HomerJS]

select count(*)
from mytable
where mytable.field = 'something'

 

[TheConeHead]

thanks... this is a little OT for this forum but would anyone know how I would then refer to what is returned in an asp page? Like when I want to refer to a db field I say:
<%=rs(&quot;field&quot%>

How would I call the count that is returned?

 

[cmmrfrds]

Give the count a name and it will part of the fields collection just like any other field, otherwise, it will have some default name which you could lookup in the field collection if you wanted.


select count(*) as cnt
from mytable
where mytable.field = 'something'

<%=rs(&quot;cnt&quot%>

 

[TheConeHead]

excellent - thanks for the help...