Hi

I'm designing a site, that involves a lot of user input, which is all going to be stored in a database. SQL 7

I have used MX Authentication and MX Login User. So am using session variable mm_username in site.

Have split user information to be entered in several tables, with username as the primary key and then as the foreign key in the other tables.

Have tried everything I can think of to be able to update user information in the tables with username as the foreign key, but have not managed to get it going.

Keep getting 'recordset is either at EOF or BOF', whatever I try. Could someone please tell me the correct procedure is, or point me in the direction of some good article etc.

Yours hopefully Keith

I would personally have used a unique numeric id for each user (this is the standard way but not necessarily the only way).

You should also check as I thought the variable you are after is mm_Username no mm_username (not sure if this makes any difference.

If it is not too late go back and set up a unique key.



Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting