Forum
18:17
18/07/2014
Hi all
thanks for this great tool.
sorry, I tried to solve my problem reading the other posts but I can't get this working.
Example:
Mysql DB Table
tbl_local (idtbl_local; Description) values (1,Ombro; 2,Cotovelo; 3,Braco....)
tbl_classf(idtbl_classf; Description; id_local) values (2,'Classificação 102', 1; 3,'Classificação 6',1)
relationship: tbl.tbl_classf.id_local<->tbl_local.idtbl_local
I'm using a view to upload the values from database to jqgrid:
CREATE VIEW `ortodb`.`view_classf_local` AS select `a`.`idtbl_classf` AS `ID`,`a`.`description` AS `Description`,`a`.`id_local` AS `id_local`,`b`.`idtbl_local` AS `id_join_local`,`b`.`Description` AS `Local_Description` from (`ortodb`.`tbl_classf` `a` left join `ortodb`.`tbl_local` `b` on((`a`.`id_local` = `b`.`idtbl_local`)))
I try to use jqgrid to edit/add the tbl_classf populating the edit form with the select "local" (tbl_local.Description) and update the id_local from tbl_classf
Â
I need help to create a select option with all 'local' options, but showing the default value selected.
and finally update and add to database.
thanks in advance.
sorry by my bad english.
I'm Portuguese.
11:23
Moderators
30/10/2007
Hello,
See the docs for how to build select.
Also in editoptions there is a option defaultValue. You just need to look into the docs - see editing.
Kind Regards
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:
46 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