adodb und postgres mit Select from where

tylerdurden78

Hi,

habe folgendes Problem. Ich muss aus einer Postgres DB einzelne Werte auslesen. Z.B ergibt

SELECT COUNT(*) as result
FROM game_players, players
WHERE game_players.player_id = players.player_id AND
screen_name like 'Donkey'

in pgAdmin den Output
"result"
4824

Nun hab ich ein Problem damit, diese 4824 in autoit als String zu speichern. Soweit bin ich mittlerweile:

$oConn = ObjCreate("ADODB.Connection")
$oRS = ObjCreate("ADODB.Recordset")

$oConn.Open("DRIVER={PostgreSQL Unicode};DATABASE=xyz;" & _
"SERVER=localhost;PORT=5432;Uid=postgres;" & _
"Pwd=xyz;" & _
"A0=0;A1=6.4;A2=0;A3=0;A4=0;A5=0;A6=;A7=100;A8=4096;A9=0;" & _
"B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_")

$oConn.execute ("SELECT COUNT(*) as result FROM game_players, players WHERE game_players.player_id = players.player_id AND screen_name like 'Donkey'")

MsgBox(0, "Anzahl", $oRS.Fields("result").Value)

Aber ich bekomme nur einen -1 error. Scheinbar werfe ich etwas mit Recordset und Connection oder Fieldsnamen durcheinander?

tylerdurden78

ok habs hinbekommen

Code

Func _postgres_query()


    $oConn = ObjCreate("ADODB.Connection")
    $oRS = ObjCreate("ADODB.Recordset")


    $db_Settings = "DRIVER={PostgreSQL Unicode};DATABASE=bla;" & _
            "SERVER=localhost;PORT=5432;Uid=postgres;" & _
            "Pwd=bla;" & _
            "A0=0;A1=6.4;A2=0;A3=0;A4=0;A5=0;A6=;A7=100;A8=4096;A9=0;" & _
            "B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_"


    $oConn.Open($db_Settings)
    $oRS.Open("SELECT (case when (count(*)!=0) then ( cast(sum(pre_flop_raise_n) as real) / cast(count(*) as real) ) else (-1) end) as result FROM game_players, players WHERE game_players.player_id = players.player_id AND screen_name like 'donkey'", $oConn, 1, 3)
    $oRS.MoveFirst


    For $iIndex = 1 To $oRS.RecordCount
        $pt_pfr = $oRS.Fields("result" ).value
        $oRS.MoveNext
    Next


    $oConn.Close
    Return $pt_pfr


EndFunc  ;==>_postgres_query


$var = _postgres_query()
MsgBox(0, "player pfr", $var)

Alles anzeigen