Capturing user name in forms in FP 2003

[Michelle]

I am sending my form information to an Access Database
(which is working) BUT it's not capturing the user name.
This is for a form to only be used internally and want to
capture the current logged in user without asking them to
provide that information. Any pointers to how to's or
suggestions would be greatly appreciated.

Thanks!
Michelle

 

[MD WebsUnlimited.com]

Hi Michelle,

The intrinsic form handlers in FP will not work for this case. What you'll
need to do is modify the DIW form to access and store the environment
variable to the database.

 

[Rich Palarea]

Mike:

How is that done? I tried to do the following in a similar form within DIW:

FP_SaveFieldToDB fp_rs, Request.ServerVariables("LOGON_USER"), "UID"

Where:
"LOGON_USER" was originally set by the form properties in FP to
"REMOTE_USER"
"UID" is the dB column value in Access for my username
I use an include file in this page that checks to see if there is a session
for this user already. If not, it sends them to my login page.

When I check the results of the form submission, the UID column in Access is
blank (no data is being saved, but the rest of the form data does get saved)

Any ideas?

Thanks,
Rich

 

[Jim Cheshire]

You need to make sure that the user is authenticated. If the user is
browsing anonymously, LOGON_USER will contain an empty string.

--
Jim Cheshire
Jimco Add-ins
http://www.jimcoaddins.com
===================================
Co-author of Special Edition
Using Microsoft FrontPage 2003
Order it today!
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=2UELLO8CHO&isbn=0789729547&itm=7

 

[Rich Palarea]

Jim

Thanks - I figured that would be the case. Although, I'm testing this form
after the user has logged in. This is being verified by using a
response.write command for the LOGON_USER variable and I can see that the
output is correct. The form, however, won't send the variable pair to the
database into my "UID" column.

Still a mystery to me...

Rich

 

[Michelle]

Thanks guys. Looks like I'm not the only one that wants
this functionality to work. If I collect the info in a
text file I get it just fine but I would really like it
in the database. I'm having the same problems that Rich
is having. I might actually rethink the design a little
and try using WSS with Exchange and see if I can get it
through the information store via cdo.

Thanks - Michelle