_sql.au3 help

[Jaboowaki]

I am trying to get _ArrayToString to work or find way to get the variable(name of company) out of array ($aData).

<autoit>Local $aData,$iRows,$iColumns;Variables to store the array data in to and the row count and the column count

$iRval = _SQL_GetTable2D(-1,"SELECT Address FROM CUSTOMER WHERE CompanyName = '"&$compname&"';",$aData,$iRows,$iColumns)

If $iRval = $SQL_OK then _arrayDisplay($aData,"2D (" & $iRows & " Rows) (" & $iColumns & " Columns)" )

Local $str

If Not IsArray($aData) Then SetError(1)

If @error = 1 Then

MsgBox(0,"@error","NOT ARRAY")

EndIf

$str = _ArrayToString($aData,"",0,0)

MsgBox(0, "$str", $str)</autoit>

This returns blank.

[jchd]

With your SELECT, you can only expect to grab the address not hte name, but you know thename already, don't you?

Now look again at _ArrayToString in help file, and more precisely at @error return values (specially when it is 3). OK ? This function only works for 1D arrays.

Why use this function anyway, you don't need it. The data you're after is probably in $aData[1][0] if the first row contains the column names. You just displayed the array contents, where the data is should be clear!

[Jaboowaki]

Thank you for solving this for me. You were right on!