I'm trying to login users with username and password, and I want to open a different document for each user. I tried putting the urls in the database table against the relavent username and password, and then creating a recordset and putting the hyperlink field code as the redirect page but it doesn't work, and ideas

Hey, have you tried having a basic refresh on the page after they login in?

something like:

<meta http-equiv="refresh" content="0;URL="<%= Server.HTMLEncode((rs_whatever.Fields.Item("weblink".Value)) %> />

never done this before but this is something I have to do by next week so this post will be interesting

This would be my first guess

I am not sure if this can help you out but:

I use the Log In User server behaviour from Dreamweaver which works fine for me, you can categorize people to a certain AccessGroupID. Here you can build a login for page 1 and if access is not granted forward to page 2. On page 2 you do the same, access is granted or forward to page 3.

Cheers,
H@ns

Another quick suggestion!

I'm on here trying to figure out include files which I just realised is a similar problem to yours.

I want a user to login and have a customised file appear before them.

Basically a menu style the choose must be included once they log in!

Have you thought of trying the include route?

Just to let you know I solved the problem by downloading the Dreamweaver Server Behaviour 'Login User Dynamic Redirect' - works easy.

www.adobe.com/cfusion/exchange/index.cfm?view=sn120#loc=en_us&view=sn120&viewName=Adobe%20Exchange&avm=1

<%

strSQL = "SELECT redirect_URL From Users WHERE user_ID = " & intUserID & " "

'### using an open database function to grab the info, and put it into the recordset (rsData)

getFromDatabase(strSQL, rsData) '### pre-coded function to get suff from the db

If NOT rsData.EOF Then '### do the following only if we find a record

redirectToURL = rsData("redirect_URL"

closeDatabase(rsData) '### pre-coded function to close the db

response.redirect redirectToURL

%>

Something like that should work