Hello everyone…. is it possible to have a multiple queries editing's box where I can have selects where to choose ID which will be saved in the main table edit box's based?….
Precisely I mean, I know there's the edittype thing with editoptions… but I'd like to know if I can pass a SELECT id, field1 FROM table in the editoptions?
This because I have a table with some id references; let's suppose:
SELECT id, description FROM table1
SELECT id, ref_id_table1, other FROM table2
and I'd like to put in the editing box a select which has the first SQL sentence so I can pass the appropriate ID to the ref_id_table1….
I hope my question is more clear now…and I'm asking if maybe someone knows a trick to allow that since in the PDF documentation I haven't found anything 🙂
You can not pass direct a SELECT statement, but when you construct the grid by example with PHP you can construct queries so that the result can be set in the colModel.
you mean something like creating an xmlhttprequest to a PHP file where to elaborate queries to database then returning a JSON array to split into colModel, right?…
.
