ADODC SQL question

Mon, 09 May 2005 21:00:38 -0700

This message was edited by snoburnssb at 2005-5-9 21:1:25

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);

Re: ADODC SQL question

Tue, 10 May 2005 08:02:41 -0700

: This message was edited by snoburnssb at 2005-5-9 21:1:25

: 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.

infidel

$ select * from users where clue > 0
no rows returned

'ADODC SQL question' Thread RSS Feed

ADODC SQL question

Re: ADODC SQL question