Check to see if IP is in Database Table SQL VBScript ACCESS
Posted on 2008-06-20
Hi, this is very simple...
I am trying to find out if an IP address (that was saved in a table) is in a particular column called IP and if that is so...return a result
I just need the SQL to get it done
ADO connection here to whatever .mdb
i need the sql to determine whether or not the value is in the table or not...or at least how to find out ... evaluate and send a result bsed on that
i will take the result and then redirect all IP's in the list to a page prohibiting them from entering the site...
basically i just need a snipplet of how to check if the IP in already in the DB or not