Populate Fields from a database

After reading more I have now done this below and it is still not working nor is my drop down working anymore. I am trying to have the user choose data from a drop down and then that drop down populates the rest of the fields on the form from the oracle db - Please Help:
----- form1.Screen.ZZ_EEID::initialize: - (JavaScript, client) -------------------------------------
 
var sDataConnectionName = "AbraData";
var sColHiddenValue = "ZZ_EEID";
 
var nIndex = 0;
while(xfa.sourceSet.nodes.item(nIndex).name != sDataConnectionName)
{
nIndex++;
}
var oDB = xfa.sourceSet.nodes.item(nIndex);
oDB.open();
oDB.first();
 
var nDBIndex = 0;
while(oDB.nodes.item(nDBIndex).className != "command")
{
nDBIndex++;
}
 
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");
 
this.clearItems();
 
nIndex = 0;
while(xfa.record.nodes.item(nIndex).name != sDataConnectionName)
{
nIndex++;
}
var oRecord = xfa.record.nodes.item(nIndex);
 
var oValueNode = null;
var oTextNode = null;
 
for(var nColIndex = 0; nColIndex < oRecord.nodes.length; nColIndex++) { if(oRecord.nodes.item(nColIndex).name == sColHiddenValue) { oValueNode = oRecord.nodes.item(nColIndex); } }
 
while(!oDB.isEOF())
{
this.addItem(oValueNode.value);
oDB.next();
}
 
oDB.nodes.item(nDBIndex).query.recordSet.setAttribute(sBOFBackup,"bofAction");
oDB.,nodes.item(nDBIndex).query.recordSet.setAttribute(sEOFBackup,"eofAction");
 
oDB.close();
 
----- form1.Screen.Button1::click: - (FormCalc, client) --------------------------------------------
 
if (HasValue(ZZ_EEID)) then
$sourceSet.AbraData.#command.query.commandType = "text"
var sqlString = Concat("Select ZZ_EEID, ZZ_RISK_RT, ZZ_MATRIX_RT, ZZ_CONTRIB_RT, ZZ_OVERALL_RT From PS_ZZ_RATING Where ZZ_EEID = '",
Ltrim(Rtrim(ZZ_EEID.rawValue)),"'")
$sourceSet.AbraData.#command.query.select.sqlString
$sourceSet.AbraData.open()
endif