Hi I am trying to count the number of records in a table I have two tables
tbl_posts with Post_ID as primary key and another table called tbl_replies with
Post_ID as a foreign key. On the web page there is a hidden field which
contains the Post_ID as its value. I have a SQL statment as follows: SELECT
COUNT (Post_ID) AS Counter FROM tbl_reples WHERE Post_ID = 'Whatever is in the
Hidden Field' How do i get it to match against whats in the hidden filed, ie
what variables do i have to decalre the advanced record set menu I am using
SQL Server and ASP. Any help would be great Thanks AJ