Not sure where to post this on this site so figured this looked best. I am trying to follow a tutorial you had posted a while back and cannot get it to work.
Basically I need someone to choose a value from a drop down list (which is pulling from an oracle db). Then based on that drop down I want it to populate other fields on the screen. Right now I have 2 fields on the screen ZZ_CODE and ZZ_DESC. When they choose ZZ_CODE I want it to populate ZZ_DESC.
Here is my script:

—– form1.#subform[0].Body.ZZ_CODE::change: - (FormCalc, client) ———————————

var sCODE = xfa.event.newText
var sZZ_CODE = $.boundItem(sCODE)
var oDataConn = Ref(xfa.sourceSet.AbraData)

oDataConn.#command.query.commandType=“text”

oDataConn.#command.query.select = Concat(“Select distinct ZZ_DESC from PS_ZZ_HRTABLES Where ZZ_CODE = “, sZZ_CODE,””)

oDataConn.open()
oDataConn.first()
AbraSub.presence=”visible”
AbraSub.ZZ_DESC = sCODE

I get an Script Failed error - Error: syntax error near token ”

If I can get this working I would then like to be able to take multiple fields into my where clause to populate the other fields on the form. For example, i will have a country code and a state code which will drive combined the data that shows on the form. So where clause like so ” Where state = “, sZZ_State,” and country = “,sZZ_COUNT,””)

Any help would be greatly appreciated. In fact I could even fax you a beer! :)

Stefan,
I have completed mutilated my code since i posted. So now I have done this below going by what I found in Adobe documentation:
I now do not get an error but my other fields are not updating. My drop down list is populating correctly but when I choose something nothing else changes on the screen.
I am also getting an Oracle error listener could not resolve SERVICE_NAME. This error is odd because I can login through the Data View and it pulls back the tables but when I
preview I get the Oracle error - weird…I will have to buy more beer for this one!

—– form1.#subform[0].ZZ_EEID::initialize: - (JavaScript, client) ——————————–

var sDataConnectionName = “AbraData”;
var sColHiddenValue = “ZZ_EEID”;
var sColDisplayText = “ZZ_EEID”;
// 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).clone(1);
oDB.open();
oDB.first();
// Search node with the class name “command”
nIndex = 0;
while(oDB.nodes.item(nIndex).className != “command”)
{
nIndex++;
}
// Need to set BOF and EOF to stay
oDB.nodes.item(nIndex).query.recordSet.setAttribute(“stayBOF”, “bofAction”);
oDB.nodes.item(nIndex).query.recordSet.setAttribute(“stayEOF”, “eofAction”);

// Search for the record node with the matching Data Connection name
nIndex = 0;
while(xfa.record.nodes.item(nIndex).name != sDataConnectionName)
{
nIndex++;
}
var oRecord = xfa.record.nodes.item(nIndex);
// Find the value node
var oValueNode = null;
var oTextNode = null;
for(var nColIndex = 0; nColIndex

Hope this works I tried another time and it still cut it off.
Thanks for all your help. So Stefan are you available for consulting?

—– form1.#subform[0].ZZ_EEID::initialize: - (JavaScript, client) ——————————–

var sDataConnectionName = “AbraData”;
var sColHiddenValue = “ZZ_EEID”;
var sColDisplayText = “ZZ_EEID”;
// 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).clone(1);
oDB.open();
oDB.first();
// Search node with the class name “command”
nIndex = 0;
while(oDB.nodes.item(nIndex).className != “command”)
{
nIndex++;
}
// Need to set BOF and EOF to stay
oDB.nodes.item(nIndex).query.recordSet.setAttribute(“stayBOF”, “bofAction”);
oDB.nodes.item(nIndex).query.recordSet.setAttribute(“stayEOF”, “eofAction”);

// Search for the record node with the matching Data Connection name
nIndex = 0;
while(xfa.record.nodes.item(nIndex).name != sDataConnectionName)
{
nIndex++;
}
var oRecord = xfa.record.nodes.item(nIndex);
// Find the value node
var oValueNode = null;
var oTextNode = null;
for(var nColIndex = 0; nColIndex &lt oRecord.nodes.length; nColIndex++)
{
if(oRecord.nodes.item(nColIndex).name == sColHiddenValue)
{
o
ValueNode = oRecord.nodes.item(nColIndex);
}
else if(oRecord.nodes.item(nColIndex).name == sColDisplayText)
{
o
TextNode = oRecord.nodes.item(nColIndex);
}
}
while(!oDB.isEOF())
{
this.addItem(oValueNode.value, oValueNode.value);
//IDList.addItem(oValueNode.value, oTextNode.value);
oDB.next();
}
// Close connection
oDB.close();

—– form1.#subform[0].ZZ_EEID::change: - (FormCalc, client) ————————————–

var sZZ_EEID = xfa.event.newText
var oDataConn = Ref(xfa.sourceSet.AbraData)

oDataConn.#command.query.commandType=”text”

oDataConn.#command.query.select = Concat(”Select * from SYSADM.PS_ZZ_RATING Where ZZ_EEID = “, Ltrim(Rtrim(sZZ_EEID)))

Greg Blodgett,

As far as I can tell, you Initialize script looks OK. As for your Change script, based on what you posted, you’re missing the following statements after you set the data connection’s select statement:

oDataConn.open()
oDataConn.first()

That should explain why fields bound to the second data connection remain blank after you select an item in the drop down list.

Also, if you are editing this form with Designer 8.0 and have saved is as an Acrobat 8 PDF (XFA 2.5) form, then you also have another problem with your Change script: You’ll first need to clone the data connection before you set its commandType and select properties. Otherwise, you’ll get a security error.

Please give these tips a try and let me know if you get your form working.