a question!~~~

[Neequ]

a question in database, please look at the program, how can i display the sql result?thanks a lot!~~~

db_name = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
db_name += getAdditionalFile("ip.mdb");
var conn = new ActiveXObject("ADODB.Connection");
isConn = false;
conn.ConnectComplete = function (err, status, cnt)
{
if (typeof err != "undefined")
{
trace(err.Description);

return;
}
else
{
trace("Connect complete!");
isConn = true;
}
}
conn.Open(db_name);

if (!isConn)
{
Dialogs.msgBox("Connect database faild!", "Error", 16);
return;
}

var record = new ActiveXObject("ADODB.Recordset");
record.Open("select * from student", conn, 1, 2);
record.MoveFirst();

function updateForm()
{
start = record.Fields(0).Value.toString();
end = record.Fields(1).Value.toString();
place = record.Fields(2).Value.toString();
}
updateForm();

var sql = "select place from student where place = 'usa'";
var xx = conn.Execute(sql);
trace(xx.RecordCount);// how can i display the sql result?

[Neequ]

;D

不好意思自己搞定了，原来是

var xxx = conn.Execute(sql);
trace(xxx.Fields["start"].Value.toString())