dhtmlxCombo and Prepared Statements

Suite and Optimus Suite 5
#1

hello,

I’m not allowed to use string concatenation in our select sentences and I have to use sql prepared statements instead.
I’m reviewing the docs and examples of dhtmlxCombo but I am unable to find out how to make work the render with a prepared statement.
Of course I can call the sentence and manually assemble a xml string to feed the combo, but I would like to avoid using this…

Any suggestion welcome.

Regards.

JavierEME

#2

Hello,

combo data can be loaded using one of the following approaches:

  1. addOption method:

combo.addOption([[“value1”,“text1”],[“value2”,“text2”],…,[“valueN”,“textN”]]);

  1. loadXML - loads xml asynchronously:
    combo.loadXML(url) /url - path to server-side script that generates xml/

  2. loadXMLString adds options from xml string.

#3

Thanks a lot.

loadXML will do it.

Regards.

Javier