Question
Need some starter fluid
Login Procedure
1. User comes to site
2. Site asks for cookie, if no cookie, determines user is "guest" (if
cookie, uses old username)
3. Pulls up userID from username, feeds to tblGroupMembership
4. tblGroupMembership holds userID, groupID, and groupClearance
5. Take all groupID's and groupClearance associated with username
6. Split groupID's into admin and member and feed into two arrays, mcGroupA
and mcGroupM (admin/member).
This is all complete and working fine. I've hit a trouble spot right now -
brains a bit fried, i guess I forgot my yellow pill.
7. Feed GroupIDs from Array into tblNews and retrieve articles based on
this (for both admin and member, I plan on having two recordsets). At this
point, I really only need to have the *number* of articles to edit, but the
recordset must be pulled regardless.
The problem I'm having is this: I'm having a hard time figuring out how to
create a recordset in DW that is updated by multiple variables. IE - I need
to 'cycle' through a recordset or just feed it comma separated values, but
I'm not sure the syntax needed for this.
For example, my mcGroupA (group admin array) might contain 4,1. So I will
need to look for articles with the GroupID of 4 AND 1.
So I guess I might need to either switch from an array (i'd hate to do that)
to a string or convert the array's data into a string and append AND in
between them?
Somebody help! ;O)
TIA,
Jon
1. User comes to site
2. Site asks for cookie, if no cookie, determines user is "guest" (if
cookie, uses old username)
3. Pulls up userID from username, feeds to tblGroupMembership
4. tblGroupMembership holds userID, groupID, and groupClearance
5. Take all groupID's and groupClearance associated with username
6. Split groupID's into admin and member and feed into two arrays, mcGroupA
and mcGroupM (admin/member).
This is all complete and working fine. I've hit a trouble spot right now -
brains a bit fried, i guess I forgot my yellow pill.
7. Feed GroupIDs from Array into tblNews and retrieve articles based on
this (for both admin and member, I plan on having two recordsets). At this
point, I really only need to have the *number* of articles to edit, but the
recordset must be pulled regardless.
The problem I'm having is this: I'm having a hard time figuring out how to
create a recordset in DW that is updated by multiple variables. IE - I need
to 'cycle' through a recordset or just feed it comma separated values, but
I'm not sure the syntax needed for this.
For example, my mcGroupA (group admin array) might contain 4,1. So I will
need to look for articles with the GroupID of 4 AND 1.
So I guess I might need to either switch from an array (i'd hate to do that)
to a string or convert the array's data into a string and append AND in
between them?
Somebody help! ;O)
TIA,
Jon
