I have an AMFPHP service class wich opens an access database table, runs over
the rows and puts them in an array. Just like I do in mysql situation.
[h]
function getUsers () {
//$db = realpath("d:/www/rive.be/database/rive.mdb");
$db = realpath("D:\\websites\\2006-Rive(V)\\database\\rive.mdb");
$dbc = new COM('ADODB.Connection');
@$dbc->Open("DRIVER={Microsoft Access Driver (*.mdb)};DBQ=$db");
//return a list of all the users
$rs = $dbc->Execute("SELECT * FROM tblMapCountries");
while( !$rs->EOF ) {
$ArrayOfUsers[] = $rs;
//$id = $rs->Fields['id'];
$rs->MoveNext( );
}
if($rs){$rs->Close();}
if($dbc){$dbc->Close();}
return( $ArrayOfUsers );
}[/h]
But my amfphp service browser displays 1big array with 16 arrays inside
containing each explicitType -> variant
But no column names to see with my data like usual happens, if I use amfphp
with mysql database. Has anyone a working AMFPHP-access-flash data connection?
And wants to give me a push?
Palides from Riga/Latvia
verbruggher - 07 Jun 2007 11:16 GMT
Nobody who has ever connected an MS Access database, amfphp and flash? And could give me a short hand?