.Hello Sir,
i am a developer and im working on real estate website development. The real estate company works on projects of houses construction and community establishment. Each project involves a lot of product that are to be sold to customers. I therefore came out with two database tables linked through a one-to-many relation.There is the migration of the primary project key from its original table to the products tables. The relation is configured in the Multi table settings interface and the custom code i placed in the "body" part of the Front end list settings intends to publish each project name followec by the corresponding products. This is the custom code :
where proj is the model id of the table project
and produit is the model id of the table product
BUT at runtime the system retrieves all the projects table's attribute without getting any from the products table
this is what the debug mode looks like :
Please how can i fix the problem .
I have additional two problems :
1. I am trying to display my database content via the syntax that considers each database table as an array with the model id considered to be the name of the array. But it is not working . This the syntax
2. i am also trying to display data that proceed from joint tables in one-to-many relationship. How do we do that ?
The last point is a remark about the $MyRow-> fieldname tip you have given on the forum's front end .I have tried it on my Chronoconnectivity but it has not displayed the table's field.
i am a developer and im working on real estate website development. The real estate company works on projects of houses construction and community establishment. Each project involves a lot of product that are to be sold to customers. I therefore came out with two database tables linked through a one-to-many relation.There is the migration of the primary project key from its original table to the products tables. The relation is configured in the Multi table settings interface and the custom code i placed in the "body" part of the Front end list settings intends to publish each project name followec by the corresponding products. This is the custom code :
{proj.nom}
{proj.produit.nom}
where proj is the model id of the table project
and produit is the model id of the table product
BUT at runtime the system retrieves all the projects table's attribute without getting any from the products table
this is what the debug mode looks like :
Array
(
[Approx_Memory_Usage] => 775680
[Approx_Time] => 0.044912099838257
[SQL] => Array
(
[0] => SELECT `proj`.`cf_id` AS `proj.cf_id`, `proj`.`nom` AS `proj.nom`, `proj`.`superficie` AS `proj.superficie`, `proj`.`datedispo` AS `proj.datedispo`, `proj`.`description` AS `proj.description` FROM `jcv8j_chronoforms_data_formulaire_projet` AS `proj` ORDER BY `proj`.`cf_id` LIMIT 0,5
[1] => SELECT `produit`.`cf_id` AS `produit.cf_id`, `produit`.`nom` AS `produit.nom` FROM `jcv8j_chronoforms_data_formulaire_produit` AS `produit` WHERE `produit`.`idprojet` IN ('1','2','3','4','5')
)
[data] => Array
(
[0] => Array
(
[proj] => Array
(
[cf_id] => 1
[nom] => Kribi premium
[superficie] => 10000
[datedispo] => 2014-08-23
[description] =>
Ce projet est un projet des projets de communauté aménagée.Il est localisé à Kribi et incorpore d'innombrables produits commandable de façon composite ou en agrégation ou même encore de façon atomique.Ce projet est un projet des projets de communauté aménagée.Il est localisé à Kribi et incorpore d'innombrables produits commandable de façon composite ou en agrégation ou même encore de façon atomique.
)
[produit] => Array
(
)
)
[1] => Array
(
[proj] => Array
(
[cf_id] => 2
[nom] => sdqfsdf
[superficie] => 10000
[datedispo] => 2014-08-17
[description] =>
Description détaillée du projet
)
[produit] => Array
(
)
)
Please how can i fix the problem .
I have additional two problems :
1. I am trying to display my database content via the syntax that considers each database table as an array with the model id considered to be the name of the array. But it is not working . This the syntax
<?php echo $proj['nom'] ?>
2. i am also trying to display data that proceed from joint tables in one-to-many relationship. How do we do that ?
The last point is a remark about the $MyRow-> fieldname tip you have given on the forum's front end .I have tried it on my Chronoconnectivity but it has not displayed the table's field.
Hi Chris,
Sorry for not replying sooner!
What's the status of this issue ? and did you try using v5 ?
Regards,
Max
Sorry for not replying sooner!
What's the status of this issue ? and did you try using v5 ?
Regards,
Max
This topic is locked and no more replies can be posted.