Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
Form edit options.
19/07/2014
18:17
Avatar
Jorge
New Member
Members
Forum Posts: 1
Member Since:
18/07/2014
sp_UserOfflineSmall Offline

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`)))

 localImage Enlarger

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

 

local2Image Enlarger

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.

21/07/2014
11:23
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline

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.

Forum Timezone: Europe/Sofia

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

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information