Getting Username to write to different database

[Guest]

I have created a database (tblUsers) that users can signup
for the website & logon using their username and
password. Now - I've created a quiz that writes to a
database (quiz). What I want to do is get the Username
(UID) that they're logged in as, to write to the quiz
database. I'm able to see who I'm logged in at on the
page and it is a secure asp page, but I'm not sure how to
write that information to the database or where on the
page to put it.

Thanks in advance for any help!!!

 

[Jim Buyens]

How are you securing the Web page? For example, are you
using Windows authentication? A self-registration you
wrote yourself? A third-party self-registration system?
Something else?

How are you recording the quiz responses? The FrontPage
Save Results To Database feature? An ASP or ASP.NET page
you wrote yourself? Something else?

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Guest]

I'm using a self registration. I found it in Microsoft's
knowledge base. It's a simple access database. And yes
the results are going to a different access database by
using the Save Results to Database feature in Frontpage.

Thanks!
Heather

 

[Jim Buyens]

Does your self-registration system store the username in a Session variable?
If so, add a tag like this to your Save Results To Database form

<input type="hidden" name="username" value="<%=Session("username")%>">

where "username" in Session("username") is the name where your
self-registration system stores the user name.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------