Problem with FormBuilder links
| From: | Lilian BRUN | Date: | Tue, 13 Apr 2004 07:38:58 +0000 |
| Subject: | Problem with FormBuilder links | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-11804@lists.php.net to get a copy of this message | ||
I don't know why but when i use this, sometimes the "magic select menu"
function works, and sometimes not.
(i've downladed the CVS last version)
I've not seen in the documentation what are all prerequies between mys
database.links.ini file and the database itself to let the Formbuilder
autogenerate the select box. (i actually use the proposed Frontend tool to
validate my settings)
In my example, the administration of the "descriptor_value_date" works fine,
with 3 select box,
but for the "attribut_l_param" table, i've got no select box, even if in the
"Frontend" application, it displays "attribut" and "parametre" as
linked
tables.
So what are prerequies, or were's my mistake ?
Thanks for your help.
here's my example scripts :
dataObject.ini :
[DB_DataObject_FormBuilder]
follow_links = 2
select_display_field = LIBELLE
select_order_field = ID
database.links.ini :
[parametre]
ID_TYPE_PARAM = type_parametre:ID
ID_EST_GENERIQUE = booleen:ID
[attribut_l_param]
ID_ATTRIBUT = attribut:ID
ID_PARAM = parametre:ID
[attribut]
ID_ATTRIBUT_PERE = attribut:ID
[descriptor_value_date]
ID_OBJET = objet:ID
ID_ATTRIBUT = attribut:ID
ID_PARAM = parametre:ID
Create table script :
create table DESCRIPTOR_VALUE_DATE
(
ID int not null,
ID_OBJET int,
ID_ATTRIBUT int,
ID_PARAM int,
META_DATA date,
primary key (ID)
);
create table ATTRIBUT
(
ID int not null,
ID_ATTRIBUT_PERE int,
CODE char(30),
LIBELLE char(255),
DESCRIPTION tinytext,
primary key (ID)
);
create table PARAMETRE
(
ID int not null,
ID_TYPE_PARAM int,
CODE char(30),
LIBELLE char(255),
DESCRIPTION tinytext,
ID_EST_GENERIQUE int,
primary key (ID)
);
create table ATTRIBUT_L_PARAM
(
ID int not null,
ID_ATTRIBUT int not null,
ID_PARAM int not null,
primary key (ID)
);