I have just made a IP baner for my site, and I was wondering if this was a good methode of doing it...
SQL_config_ipban="SELECT table_config_ipban.* FROM table_config_ipban WHERE db_ipban_number='" & set_user_IP & "';"
site_record.Open SQL_config_ipban, site_data_base
if not site_record.EOF then
if site_record("db_ipban_ID") > 0 then
response.redirect "error.asp"
end if
end if
site_record.close
This works well, but I want to know if this could cause any problems, or if there is a better way of doing it.