ADODC SQL question

[b][red]This message was edited by snoburnssb at 2005-5-9 21:1:25[/red][/b][hr]ok, so i finally get how to do mysql with adodc, but is there any way to get the results of a query directly from the adodc control in array form? like:

Comments

: [b][red]This message was edited by snoburnssb at 2005-5-9 21:1:25[/red][/b][hr]: ok, so i finally get how to do mysql with adodc, but is there any way to get the results of a query directly from the adodc control in array form? like:: : adodc.recordsource = "SELECT * FROM table WHERE '1'": for n = 1 to adodc.recordset.recordcount: results(n) = adodc.recordset(n): next n: : *** if you are familiar with PHP, like:: $query = "SELECT * FROM table WHERE '1'";: $results = mysql_query($query);: $results2 = mysql_fetch_array($results);

No, Recordset objects are like cursors in a database. You have to use the .MoveFirst, .MovePrevious, .MoveNext, and .MoveLast methods to navigate them.