Arrg!I'm no expert, but it looks like you need to iterate over the result set. Try something like
Do While Not rsBannedIPs.EOF
if rsBannedIPs.Fields.Item='BannedIP'
Reponse.Redirect 'http://www.whereever.com'
rsBannedIPs.MoveNext
Loop
(Do While Not rsBannedIPs.EOF
if rsBannedIPs.Fields.Item='BannedIP'
Reponse.Redirect 'http://www.whereever.com'
rsBannedIPs.MoveNext
Loop
UncleLewy,
Tue 18 Nov 2003, 18:45,
archived)