[oceansummer]

HI,

I am having a problem with using My SQL database with SWFkit pro.

(01) I'm using swfkit with flash cs3, and I have attached swfkit project to my FLa project. Nothing wrong in it. database connection is ok too.. I can insert data into database as well. but it is possible to retrieve data from database as mentioned bellow?


var rs = new ActiveXObject("ADODB.Recordset");
rs.Open("SELECT MAX(playerID) FROM playerinfo", conn, 1, 2);
rs.moveFirst();

playerIDtext.text=rs.Fields(0).Value;



Note : in here what I'm trying to expect is to display the maxium value of playerID column in the playerinfo database.

this seems to be not working. Please help me on identifying the problem.



(02) If this is not the right method in "retrieving" data, what is the best method to retrive database data using swfkit inside flash?