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
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