Need some starter fluid

Report · May 23, 2006

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

Report · May 23, 2006

"crash" <crash@bcdcdigital.com> wrote in message
news:e4vqko$8m4$1@forums.macromedia.com...
> 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.

WHERE GroupID IN (4,1)

This won't fail when there's only one value, so no worries.

Report · May 23, 2006

lol - that's great that it's just that simple.

)

Thanks Lion. I didn't want to test five ways that wouldn't work.

Jon

"Lionstone" <HIDElionstone@HIDEhushmail.com> wrote in message
news:e4vrjm$9ua$1@forums.macromedia.com...
>
> "crash" <crash@bcdcdigital.com> wrote in message
> news:e4vqko$8m4$1@forums.macromedia.com...
>> 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.
>
> WHERE GroupID IN (4,1)
>
> This won't fail when there's only one value, so no worries.
>