Matching to an array

[struth]

I have different administrative sections which can be allocated to more than one member. These member/admin rights are held in a table (sectionAdmin):

sectionID | memberID
----------+----------
1 | 23
----------+----------
2 | 23
----------+----------
1 | 14
----------+----------

I want to check if these match as members navigate through the sections and then, if they do, open up the admin rights.

eg
if rsSectionAdmin("sectionID&quot=thisSectionID then
adminRights=true
end if

I have tried setting up an array using GetRows and although I think I am on the right track I can't get it to work.

I'd be grateful if you could help me out here.

TIA

"Away from the actual ... everything is virtual"

 

[mwolf00]

adminRights = false
set rs = cn.execute("select count(*) from myTable where memberID = " & session("memberID&quot & " and sectionID = 2&quot
if rs(0) > 0 then adminRights = true

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

 

[vbkris]

i need some more ingo:

if rsSectionAdmin("sectionID&quot=thisSectionID then
adminRights=true
end if

on what basis is this check stmt? who is the admin user?

Known is handfull, Unknown is worldfull

 

[struth]

Count ....of course! Duh!

Thanks



"Away from the actual ... everything is virtual"