Using Dreamweaver/Vb/Access. Wanting to count how many times a user has made an entry to a forum and since the page is dynamic I have to do the count based on user session (id)
"sunitabeck" suggested I created a stored procedure with a parameter (such as @UserId) and then call that stored procedure from the client code, passing in the userId of the user who is viewing the page.
Only problem is I'm quite new to SQL. Thinking I have to call it in the WHERE clause, just not sure how.
I'm trying to twist my head around this but I can't get it to work. Thought it might be easier. Dreamweaver is throwing all kinds of errors and that is probably because I've never created a SP before and used it later in a recordset.
What is the absolute easiest way to do this? Have to start at the bottom on build my way up in order to understand.