SELECT COL3 FROM GeoIPA where COL1>1064096512 AND COL2 <1064096512;
SELECT COL3 FROM GeoIPA where COL1>'1064096512' AND COL2 <'1064096512';
Func _ResolvGeoIP_AS($IP,$State)
$AS_Is = "Unknown"
Switch $State
case '0'
_SQLite_Startup()
If @error Then
MsgBox($MB_SYSTEMMODAL, "SQLite Error", "SQLite.dll Can't be Loaded!")
Exit -1
EndIf
_SQLite_Open(@WorkingDir & '\' & 'geoip_as.sqlite3') ; Open a :memory: database
If @error Then
MsgBox($MB_SYSTEMMODAL, "SQLite Error", "Can't Load Database!")
Exit -1
EndIf
case '1'
$temp=StringSplit($IP,'.')
$decIP = '"' & ($temp[1]*256*256*256)+($temp[2]*256*256)+($temp[3]*256)+$temp[4] & '"'
$QuerySingleRow = 'SELECT COL3 FROM GeoIPA WHERE COL1 >= ' & $decIP & ' AND ' & ' COL2 < ' & $decIP & ';'
_SQLite_QuerySingleRow(-1, $QuerySingleRow, $AS_Is)
MsgBox($MB_SYSTEMMODAL, "SQLite Error: ", $QuerySingleRow & ' '& $decIP & ' '& $AS_Is)
case '2'
_SQLite_Close ()
_SQLite_Shutdown ()
EndSwitch
Return $AS_Is
EndFunc
Структура базы данных какая? (имена колонок, типы данных в них и т.д.)Имею созданную из CVS файла базу данных geoip_as.sqlite3
Имен колонкам не присваивал.madmasles сказал(а):Структура базы данных какая? (имена колонок, типы данных в них и т.д.)
madmasles сказал(а):SQLite и определяет числа как текст и ничего не находит.
SELECT COL3 FROM GeoIPA where COL1>"1064096512" AND COL2 <"1064096512";
$QuerySingleRow = 'SELECT COL3 FROM GeoIPA WHERE COL1 >= ' & $decIP & ' AND ' & ' COL2 < ' & $decIP & ';'
_SQLite_QuerySingleRow(-1, $QuerySingleRow, $AS_Is)
MsgBox(64, "QuerySingleRow ", $QuerySingleRow &' '& $AS_Is )
#include<SQLite.au3>
Local $sIP = '195.122.250.12', $hQuery, $aRow, $sMsg, $AS_Is = "Unknown"
_SQLite_Startup()
_SQLite_Open(@ScriptDir & '\geoip_as.sqlite3')
$aTmp = StringSplit($sIP,'.')
$iDecIP = ($aTmp[1]*256*256*256)+($aTmp[2]*256*256)+($aTmp[3]*256)+$aTmp[4]
_SQLite_Query(-1, "SELECT COL3 FROM GeoIPA where COL1>'"& $iDecIP &"' AND COL2 <'"& $iDecIP &"';", $hQuery)
While _SQLite_FetchData($hQuery, $aRow) = $SQLITE_OK
$sMsg &= StringFormat('%s\n', $aRow[0])
WEnd
MsgBox(0, "Answer", $sMsg)
_SQLite_Close ()
_SQLite_Shutdown ()
_SQLite_Query(-1, "SELECT COL3 FROM GeoIPA where COL1<'"& $iDecIP &"' AND COL2 >'"& $iDecIP &"';", $hQuery)
_SQLite_Query(-1, "SELECT asystem FROM GeoIP_AS where ip_start<" & $iDecIP & " AND ip_end >" & $iDecIP & " LIMIT 1;", $hQuery)
$iDecIP_start = $iDecIP+1
$iDecIP_end = $iDecIP-1
_SQLite_Query(-1, "SELECT asystem FROM GeoIP_AS where ip_start<" & $iDecIP_start & " AND ip_end >" & $iDecIP_end & " LIMIT 1;", $hQuery)
ip_start<" & $iDecIP_start & " AND ip_end >" & $iDecIP_end
asystem FROM GeoIP_AS
ip_start<" & $iDecIP_start & " AND ip_end >" & $iDecIP_end
asystem FROM GeoIP_AS
ip_start<" & $iDecIP_start & " AND ip_end >" & $iDecIP_end
asystem FROM GeoIP_AS
ip_start<" & $iDecIP_start & " AND ip_end >" & $iDecIP_end
asystem FROM GeoIP_AS