search

DHTMLX / connector-php

PHP extension for the DHTMLX library
http://dhtmlx.com/docs/products/dhtmlxConnector/index.shtml
GNU General Public License v3.0
26 stars 29 forks source link

populating select from database : particular schema #4

Open casa10 opened 10 years ago

casa10 commented 10 years ago

Hye, I have this problem : 1rst table : agenda with columns (id, start_date, end_date, text) 2nd table : agenda_civilite with columns (idac, id, idcivilite) 3rd table : civilite with columns (idcivilite, code, libelle) I need to populating my view with the good 'idcivilite' and i used CrossOptionConnector because OptionsConnector needs that a column must be present on my first table. But me i have another table like 'agenda_civilite' and this, is one of my problem. I want to have 'select' and not 'multiselect' (Cf. infra)

In the view, with, my code is : scheduler.config.lightbox.sections = [
{ name: "idcivilitefrombdd", height: 21, map_to: "idcivilite", type: "multiselect",
options: scheduler.serverList("id_civilite"), script_url: 'chargeur/gerer_agenda'} ] In my controller, CrossoptionsConnector works with type "multiselect" in my view but with "select" it doesn't work and my 'idcivilite' is not associated to the good 'idcivilite' present in table "agenda_civilite". How can i have the good 'idcivilite' selected if i want to have type : "select" on the code (Cf. supra). With JSON component, type:"select" works !! but without JSON, i must use type :"multiselect" :( Thanks.

bigbase-nl commented 10 years ago

Maybe better to use forum.dhtmlx.com