Hi,

I have a pretty basic problem I think.

I have created a login connected to an Access Database. Now I want
the second page to contain (booking) information collected from the same database for that same user (which is the primary key in the database).

So what I want is basically for the second page automatically to fill up with the information in the database connected to that user (to keep the user "logged in").

Thankful for any help/
Thomas

Hi Thomas,

I am not sure I understand what you want or what your problem is. Can you describe your situation in more detail?

Also, how is this related to Dreamweaver?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Aerials by System Of A Down (Track 14 from the album: Toxicity ) What's This?

Hi,

I have created a login.asp page in Dreamweaver using "User Authentication>Log In User" which is connected to an Access database containing info like user id, password, name, address etc.

Now I want the second page (booking.asp) to contain the rest of the information in the database connected to that unique user that just logged in.

I have created a rs to retrieve that information. It only shows the first record in the database though. It does not change according to the user.

Thanks/
Thomas

Right, I see.

When you created the Login page, DW added some code to store the user's name in a Session variable. Something like:

Session("MM_UserName") = Some Value

(don't know the exact variable name / code right now)

You can use that same session variable to limit your database queries for that user. Simply add a WHERE clause to your SQL statement that uses Session("MM_UserName") to limit the number of records retrieved from the database.

If you're new to Dreamweaver and ASP, may I recommend: Beginning Dreamweaver MX 2004. This book deals a lot with these kind of issues....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Farewell and Goodnight by The Smashing Pumpkins (Track 14 from the album: Mellon Collie and the Infinite Sadness - Twilight to Starlight) What's This?