HELP PLEASE RECORDSET DEFAULT VALU

[GTN1707]

Hi, i've got a major problem, probably quite a simple fix, but i'm not to
sure - I'm developing an ASP SQL Application, i have a log in page and am
using session variables to pass the registerred user from one page to the
next. On most of the of the pages there are recordsets that return dynamic
data specific to the data. I'm basing this on the email address ( SQL column
is emailaddress) being equal to the session variable user1 which takes it's
value from the username text box on the login page. Most of the recordsets
are built in the advanced rercordset view due to other variables, therefore
i'm using the line - WHERE emailAddress = MMColParam. Where the run-time
value is Session("user1") however i'm unsure as to what the Default Value
should be, as if i set it as emailAddress it returns all records but
defaults to the first user, regardless of login details - for instance when
i login as BrianTnash it should return a page with a header that says
Welcome back Brian, and a number of other dynamic areas that are specific to
Brian, however it comes back with Welcome back Gareth (First record on the
database). If i set the default value to anything else it does take me
through to the correct page, but shows me the show if recordset is empty
region (based on the recordset that produces some of the dynamic data. The
quiestion i guess is what form should the default value take. (i've attached
the query below -) Thanks for your help.
GTN

SELECT CandidateId, FirstName, LastName, emailAddress
FROM dbo.tbcandidateone
WHERE emailAddress = 'MMColParam'

Name = MMColParam Default Value = ???? Run-Time value = Session ("user1")