Forum


06:01

25/10/2008

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
06:50

Moderators
30/10/2007

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
For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.
Most Users Ever Online: 715
Currently Online:
56 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66