ASP에서 maxmind GEOIP 사용하기

프로그래밍/ASP, Javascript

멍멍대왕 2012. 11. 9. 10:14

Dim iparr : iparr = Split(IPADDRESS,".")

caltot = (iparr(0)*16777216)+(iparr(1)*65536)+(iparr(2)*256)+iparr(3)

SQL = "SELECT top 1 CountryCode, CountryNumber FROM GEOIP with(nolock) WHERE StartNumber<=" & caltot & " and EndNumber>=" & caltot

set rs = ConDB.Execute(SQL)

if not rs.EOF Then

CountryCode = rs("CountryCode")

CountryNumber = rs("CountryNumber")

Else

CountryCode = ""

CountryNumber = ""

End If