query and _arrayAdd

[silvano]

hi,

can i add my elaborated query result in to array?

and can i count total records in the query result?

$q.execute( "select COUNTRY_NAME from countries WHERE COUNTRY_ID='UK'", $conn )

While not $q.EOF

    MsgBox(0, "Result", "COUNTRY = " & $adors.Fields("COUNTRY_NAME") .Value)

; elaborate the result
; add to array

    $q.MoveNext
WEnd
$conn.close

_arrayDisplay()

than you

[Zedna]

As far as I know Execute is for stored procedures.

Try to use $adors.Open()

[silvano]

As far as I know Execute is for stored procedures.

Try to use $adors.Open()

adors.open don't work...

execute work very good, but my problem is to return # of filed and _arrayAdd value

[silvano]

up please

[Will66]

hi,

can i add my elaborated query result in to array?

and can i count total records in the query result?

$q.execute( "select COUNTRY_NAME from countries WHERE COUNTRY_ID='UK'", $conn )

While not $q.EOF

    MsgBox(0, "Result", "COUNTRY = " & $adors.Fields("COUNTRY_NAME") .Value)

; elaborate the result
; add to array

    $q.MoveNext
WEnd
$conn.close

_arrayDisplay()

than you

can i add my elaborated query result in to array?

you need to create a recordset:

$Rec = ObjCreate("ADODB.Recordset");

$SQL = "select COUNTRY_NAME from countries WHERE COUNTRY_ID='UK'"

$Rec.Open( $SQL, $conn );

$myNew2DimensionalArray = $Rec.GetRows()

and can i count total records in the query result?

$recCount =$Rec.RecordCount