Record count

[justynb]

I have created a stored procedure called pCountMail which returns me a count of the number of matching records:

CREATE PROCEDURE pCountMail @InboxID numeric(9) AS
SELECT COUNT (*) FROM scmessage where categoryid = @InboxID

This procedure works fine when I run it in Query Analyzer. I can't work out how I request this count from my ASP page so I can output the value to the bowser?

TIA

Justyn