物件導向的asp編程之四--一些常用的函數

function RecordSetAsArray(rsADO,includeHeaderRow)
//把ado.recordset中的資料存放到一個數組裡
//當includeHeaderRow為真時產生欄位標題列，當為假時不產生
{
?var rsArray = new Array;
?var nFields = rsADO.Fields.Count;
?if (nFields)
?{
??var n = 0;
??if (includeHeaderRow)
??{?// include first row as header of field names
???var rsRow = new Array(nFields);
???for (var i=0; i < nFields; i++)
????rsRow[i] = rsADO(i).name;
???rsArray[n++] = rsRow;
??}
??? if (!(rsADO.EOF&&rsADO.Bof))
????? rsADO.MoveFirst()??
??while (!rsADO.EOF)
??{?// add each record to array
???rsRow = new Array(nFields);
???for (var i=0; i < nFields; i++)
????rsRow[i] = rsADO(i).value;
???rsArray[n++] = rsRow;
???rsADO.MoveNext();
??}
?}
?return rsArray;
}
function RecordSetAsDSO(rsADO)
//把ado.recordset中的資料放到一個表格中，返回這個表格的html代碼
{
?var htmlDSO = '';
?var nFields = rsADO.Fields.Count;
?if (nFields)
?{
??var n = 0;
??htmlDSO += '<' + 'table>';???
??while (!rsADO.EOF)
??{?// add each record to table
???htmlDSO += '<' + 'tr>';???
???for (var i=0; i < nFields; i++)
???{
????htmlDSO += '<' + 'td id=' + rsADO(i).name + '>' + rsADO(i).value + '<' + '/td>';
???}
???htmlDSO += '<' + '/tr>';???
???rsADO.MoveNext();
??}
??htmlDSO += '<' + '/table>';???
?}
?return htmlDSO;
}
function RecordSetAsList(rsADO,field)
//把ado.recordset中的某個欄位的資料放到數組中
{
?var rsArray = new Array;
?var nFields = rsADO.Fields.Count;
?if (nFields)
?{
??var n = 0;
??if (!(rsADO.EOF&&rsADO.Bof))
????? rsADO.MoveFirst()?
??while (!rsADO.EOF)
??{?// add each value of field into array
???rsArray[n++] = rsADO(field).value;
???rsADO.MoveNext();