This key is already associated with an element of this collection

[dalberon]

I am getting this error message with the following piece of code.

sqlSelect = "Select * from UserPermissions where UserID = " & UserID &
";"
set tbl = GetRecordset(sqlSelect, false)
while not tbl.eof
response.write ("<br>key: " & tbl("SectionID"))
Permissions.add tbl("SectionID"), 1
tbl.movenext
wend

The screen displays
key: 1
key: 2

I've been staring at this problem for two hours now..any suggestions
would be appreciated.

[Ray at]

What is Permissions? A dictionary object? If so, this means that you have
duplicate values in your SectionID column and as such, you cannot use those
values as a key in your dictionary object.

Ray at work

"dalberon" <co********@hotmail.com> wrote in message
news:4c**************************@posting.google.c om...

I am getting this error message with the following piece of code.

sqlSelect = "Select * from UserPermissions where UserID = " & UserID &
";"
set tbl = GetRecordset(sqlSelect, false)
while not tbl.eof
response.write ("<br>key: " & tbl("SectionID"))
Permissions.add tbl("SectionID"), 1
tbl.movenext
wend

The screen displays
key: 1
key: 2

I've been staring at this problem for two hours now..any suggestions
would be appreciated.

[Aaron Bertrand [MVP]]

http://www.aspfaq.com/2485


"dalberon" <co********@hotmail.com> wrote in message
news:4c**************************@posting.google.c om...

I am getting this error message with the following piece of code.

sqlSelect = "Select * from UserPermissions where UserID = " & UserID &
";"
set tbl = GetRecordset(sqlSelect, false)
while not tbl.eof
response.write ("<br>key: " & tbl("SectionID"))
Permissions.add tbl("SectionID"), 1
tbl.movenext
wend

The screen displays
key: 1
key: 2

I've been staring at this problem for two hours now..any suggestions
would be appreciated.