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!!!

re: Getting Username to write to different database by Jim

Jim
Thu Jul 15 15:44:17 CDT 2004

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)
|/---------------------------------------------------
*----------------------------------------------------



>-----Original Message-----
>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!!!
>.
>

re: Getting Username to write to different database by anonymous

anonymous
Fri Jul 16 11:32:23 CDT 2004

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
>-----Original Message-----
>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)
>|/---------------------------------------------------
>*----------------------------------------------------
>
>
>
>>-----Original Message-----
>>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!!!
>>.
>>
>.
>

Re: Getting Username to write to different database by news

news
Sat Jul 17 15:36:02 CDT 2004

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)
|/---------------------------------------------------
*----------------------------------------------------


<anonymous@discussions.microsoft.com> wrote in message news:<2ecd401c46b52$79456da0$a301280a@phx.gbl>...
> 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
> >-----Original Message-----
> >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)
> >|/---------------------------------------------------
> >*----------------------------------------------------
> >
> >
> >
> >>-----Original Message-----
> >>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!!!
> >>.
> >>
> >.
> >