A voir également:
- Utiliser un recordset lors d'un évènement
- Comment utiliser netbeans - Conseils pratiques -Java
- Créer un utilisateur mysql - Conseils pratiques -PHP
- Utiliser access - Conseils pratiques -Visual Basic / VB.NET
- Le grand événement france ioi correction ✓ - Forum Java
- Recordset vba ✓ - Forum Visual Basic
1 réponse
C'est possible à condition d'avoir transformé ton recordset en tableau Javascript (array).
Code provenant de chez Microsoft :
//*****************************************************************
// function RecordSetAsArray(rsADO,includeHeaderRow)
// A helper function to convert an ADO recordset into a
// jscript array. Optionally may include the field names
// as the first row of the array by setting includeHeaderRow
// parameter to true.
//
//*****************************************************************
function RecordSetAsArray(rsADO,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;
}
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;
}
8-)
Code provenant de chez Microsoft :
//*****************************************************************
// function RecordSetAsArray(rsADO,includeHeaderRow)
// A helper function to convert an ADO recordset into a
// jscript array. Optionally may include the field names
// as the first row of the array by setting includeHeaderRow
// parameter to true.
//
//*****************************************************************
function RecordSetAsArray(rsADO,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;
}
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;
}
8-)
