Database Results Wizard

[daviddenver303]

Hi There - I am creating a simple website with a database. The first page a visitor will come to is a single (no frames page) where I have inserted a database results search field (search an Access database).

If the results are found, I want the results to be displayed at the top of every page of my web during that persons visit to my web site.

In other words, what I'm doing is creating a "log in" page for my web site using MS Access to store the users information. If it is the persons first time to my website, they can click a link on the first page to enter their information (sign up) (which writes the info to the MS Access database).

The database has four fields: 1) First Name 2) Last Name 3) User ID 4) Password. Once the user signs up, the info. is written to the MS Access database.

As I mentioned, I have everything in place but have one dilema. After the user enters his User ID and password on the first page (which is actually the MS Access Search form), if the database matches the info, I want the user's first name (which is also stored in the database) to be displayed on all pages of my website, at the top right corner. Sort of a "Welcome, first name" type message.

After I've set up the database results and have them set to POST to the second page (which is index2.asp in this example), I can't get the database results to post to other, subsequent pages.

Does anyone know a way to do this?

Thanks for your help!
David

 

[pancake]

I have noticed that if you display database results as a column value, you can't then pass that field as a parameter onto another page. As you describe.

The only way I have found around this is to display it as a text box, which can then be passed ok, then format the text box so it doesn't appear as a text box, but just appears as text. i.e. remove the box

Messy I know, and not a real solution, but would welcome anyone else's suggestions

Vik