SQL query to textbox

Suite and Optimus Suite 5
#1

So I have an SQL query where the result isn’t stored to a table.

The result is just displayed on the client side through the grid.

How can I put the result of the query to a textbox?

I tried using. form.setItemValue("textbox_name",form.load("some url"));
But it didn’t work. Please help me.

Sorry for my bad english.

#2

hi

  1. load data apart from form
    dhtmlxAjax.get(url, function®{
    // console.log(r.xmlDoc.responseText)
    // assuming server returns: {text: “select * from table”}
    var t=null;
    try {eval(“t=”+r.xmlDoc.responseText);} catch(e){};
    if (t != null) myForm.setItemValue(“item_name”, t.text);
    });

  2. load data using form’s load()
    myForm.load(url);
    demo dhtmlx.com/docs/products/dht … _load.html