Checking

I want to do a checking before the user is allowed into the page. I did a Request.QueryString("id") and want to take this value to do a Select statment but no idea how to do it.

eg.
Select cust_id from m_customer
where cust_id = Request.QueryString("id")

Pls Help!

write a stored proc with the userid as the parameter

create sp_check_user(
@user_id int
)
as set
nocount on
select cust_id
from m_customer
where user_id = @user_id

go

u can pass the "Request.QueryString("id") " value as user_id