Forums

This topic is locked

Can a rs be filtered using avalue from another rs?

Posted 13 Aug 2001 11:25:19
1
has voted
13 Aug 2001 11:25:19 Shaun Brazier posted:
Or am I barking up the wrong tree!

I am using the MM Login which creates a session named MM_Username

I need to filter a recordset using the MembersID. How would I do this.

Changing the database to hold username instead of ID?

Thanks for any suggestions

Shaun

Replies

Replied 14 Aug 2001 10:09:03
14 Aug 2001 10:09:03 e site replied:
Hi there,

depending on what fields you use for the Login,
you could just filter the other rs using "WHERE 'Field' = Session("MM_username"
(e.g. 'Username' = MM_Username)

you needn't have to change your DBAse...
hope this helps...

e_site

Reply to this topic