form field initial value

[JohnD]

I posted a queston earlier and didn't do a good job of explaining what I
need. I thought I would elaborate a little more on my problem. I have
searched help for an answer to this as well as the knowledge base.

I have setup several secure pages on my site with the help of a login
manager program called Isecure. I add new users to my database table called
tblUsers. I would like three fields from the tblUsers table to autofill into
another form I have created on the site. This form then posts it's data to a
table called tblListings. I was wondering if there is a string I could put
into the initial value of the form field that could autofill the correct data
from the tblUsers table for the user that is currently logged in.

 

[Jens Peter Karlsen[FP MVP]]

Not a string.
You would have to write an ASP or PHP solution to fill the fields from
the Database.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

 

[Mike Mueller]

John,
I am unfamiliar with Isecure, so I do not know its
capabilities or how it works. From the information you have
provided though there are some possible solutions for you.
They would all have to be custom scripted. Here is a basic
flowchart of what would need to be done

1. Retrieve the information you want from tblUsers, and
assign to variables. I'll call these variables fld1, fld2,
& fld3
2. In the form itself create your text boxes, we will call
them txt1, txt2, & txt3
3. Switch to code view on the form. Modify the text boxes
to add the value from the variable. Add a read-only tag if
so desired

Mike
********************************
JohnD wrote:
: I posted a queston earlier and didn't do a good job of
: explaining what I need. I thought I would elaborate a
: little more on my problem. I have searched help for an
: answer to this as well as the knowledge base.
:
: I have setup several secure pages on my site with the
: help of a login manager program called Isecure. I add
: new users to my database table called tblUsers. I would
: like three fields from the tblUsers table to autofill
: into another form I have created on the site. This form
: then posts it's data to a table called tblListings. I
: was wondering if there is a string I could put into the
: initial value of the form field that could autofill the
: correct data from the tblUsers table for the user that is
: currently logged in.