You can do it by writing a JavaScript script inspired from the custom Data List Box object provided in the Library.
This object provides a canned script to populate a list box from a table in a database (for which you've created a Data Connection in Adobe LiveCycle Designer using the Data View palette).
To have a look, simply drag a Data List Box from the Library palette's Custom tab onto your form and look at its Initialize script.
This canned script asks you to fill-in three variables, of which one is named
sDataConnectionName. The other two variables ask for the text and value table column names which you want to map to the list box's text and value values for the items the script will add to it.
You should be able to modify this script to obtain a record count simply by removing the excess stuff about the list box items and adding an item counter at the point where the script is looping through the records in the table and populating the list box with items.
The script could look like this (note: replace "<value>" with your data connection name):
var sDataConnectionName = "<value>"; // example - var sDataConnectionName = "MyDataConnection";
// Search for sourceSet node which matchs the DataConnection name
var nIndex = 0;
while(xfa.sourceSet.nodes.item(nIndex).name != sDataConnectionName)
{
nIndex++;
}
var oDB = xfa.sourceSet.nodes.item(nIndex);
oDB.open();
oDB.first();
// Search node with the class name "command"
var nDBIndex = 0;
while(oDB.nodes.item(nDBIndex).className != "command")
{
nDBIndex++;
}
// Backup the original settings before assigning BOF and EOF to stay
var sBOFBackup = oDB.nodes.item(nDBIndex).query.recordSet.getAttribute("bofAction");
var sEOFBackup = oDB.nodes.item(nDBIndex).query.recordSet.getAttribute("eofAction");
oDB.nodes.item(nDBIndex).query.recordSet.setAttribute("stayBOF", "bofAction");
oDB.nodes.item(nDBIndex).query.recordSet.setAttribute("stayEOF", "eofAction");
var itemCount = 0;
while(!oDB.isEOF())
{
itemCount++;
oDB.next();
}
// Restore the original settings
oDB.nodes.item(nDBIndex).query.recordSet.setAttribute(sBOFBackup, "bofAction");
oDB.nodes.item(nDBIndex).query.recordSet.setAttribute(sEOFBackup, "eofAction");
// Close connection
oDB.close();
this.rawValue = itemCount;
This example assumes the script is placed on a numeric field's Initialize event as a JavaScript script.
Stefan
Adobe Systems
