I would like to use the frontpage dataview web part on a WSS page to pick up
the username (not the domain\username) bit of the current user and query the
Sql profile database to pull up extra infomation (name, Date of birth etc)
and show that in the Dataview webpart. I have created the database connection
and the queryand I have created the filter 'Username equals [Current user]'
.Username is a field name that contain username (without the domain name
attached) in the database. The dataview webpart returns no records found even
though the users have information in the database. Change the filter to a
known username, the DVWP returns the user's record ok It does not seem to
pick up and compare the logged on user's username and that in the database
well. Any help.