jQuery Grid Plugin - jqGrid - Topic: editing box

Luigino on editing box

Tue, 09 Dec 2008 08:21:46 +0200

Hello Tony,

everything's ok there? 🙂

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?...

Ciao,
Luigi

tony on editing box

Tue, 09 Dec 2008 06:50:09 +0200

Hello,

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.

Regards

Tony

Luigino on editing box

Mon, 08 Dec 2008 06:01:20 +0200

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 🙂

Thanks,

Ciao!

Luigi

Luigino on editing box

Sun, 07 Dec 2008 15:07:48 +0200

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?....

thanks to everyone!

Ciao,

Luigi