javascript从数据库取出数据后赋给变量出现问题,急需解决...
var strMusicName = "";
var nMusicId = 0;
var DataSet=new ActiveXObject("ADODB.Recordset");
DataSet.ActiveConnection=Connection;
DataSet.Open( "Select Top 1 MusicId, MusicName From Db_MusicList Order By MusicId" );
if ( !DataSet.EOF )
{
nMusicId = DataSet( "MusicId" );
strMusicName = DataSet( "MusicName" );
document.write( strMusicName & "<br>" );
DataSet.Close();
document.write( strMusicName );
}else{
DataSet.Close();
}
这样输出的值居然不一样,如果
D:\MP3\独自去偷欢.mp3(正确的值)
undefined
结论是,只要DataSet一关闭,它所赋值的变量的值也失效了,但我想保留它的值,该怎么办?