How to get info. from more one table after login success?

[faiz2000]

Dear sir..

I have page mypage.asp if login success and it appear user informations.

What I have to do if I need to appear information from other table related The UserID in the same page after user he success to login?

Please your help ASAP.

[DwFAQ]

Create a filtered recordset where session variable user_id == user_id of the other table.

[faiz2000]

Thankyou for your reply.

it igives me this errore :

Microsoft VBScript runtime error '800a01a8'

Object required

Please your help.

[faiz2000]

Please your help???

[bregent]

Please post the script including the sql select statement.

[faiz2000]

Dear Sir...

I attached the file please your reply ASAP.

Regards;

[faiz2000]

Dear Sir...

I attached the file please your reply ASAP.

Regards;

[faiz2000]

Please your help ASAP; it is very important for me.

Regards;

[faiz2000]

Dear Sir...

I tested session value, but it did not give me any information, without error?

Please your help.

Thank you,