ChronoEngine.com homepage

Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

how to read data from two tables into 1 form ?

pachf11 07 Oct, 2017
When I used Database/Read Data and create first model, everything is ok. It load data from table, but I can't config second model with another table (the same database). There is no errors but debugger shows only data from first model. Could you help me? I attach debugger and config:

Array
(
[option] => com_chronoforms6
[chronoform] => returns-form
[language] => pl-PL
[Itemid] =>
[lang] => pl-PL
[ark_inine_enabled] =>
[arkoption] => com_chronoforms6
)
Array
(
[read_data9] => Array
(
[log] => Array
(
[0] => SELECT COUNT(`VMUSERINFOSMODEL`.`virtuemart_userinfo_id`) AS `VMUSERINFOSMODEL.count` FROM `joom_virtuemart_userinfos` AS `VMUSERINFOSMODEL` LEFT JOIN `joom_users` AS `USERSMODEL` ON `VMUSERINFOSMODEL`.`virtuemart_user_id` = `USERSMODEL`.`id` WHERE `VMUSERINFOSMODEL`.`virtuemart_user_id` = '907';
[1] => SELECT `VMUSERINFOSMODEL`.`title` AS `VMUSERINFOSMODEL.title`, `VMUSERINFOSMODEL`.`first_name` AS `VMUSERINFOSMODEL.first_name`, `VMUSERINFOSMODEL`.`last_name` AS `VMUSERINFOSMODEL.last_name`, `VMUSERINFOSMODEL`.`address_1` AS `VMUSERINFOSMODEL.address_1`, `VMUSERINFOSMODEL`.`zip` AS `VMUSERINFOSMODEL.zip`, `VMUSERINFOSMODEL`.`city` AS `VMUSERINFOSMODEL.city`, `VMUSERINFOSMODEL`.`phone_1` AS `VMUSERINFOSMODEL.phone_1`, `VMUSERINFOSMODEL`.`address_type` AS `VMUSERINFOSMODEL.address_type`, `VMUSERINFOSMODEL`.`virtuemart_user_id` AS `VMUSERINFOSMODEL.virtuemart_user_id` FROM `joom_virtuemart_userinfos` AS `VMUSERINFOSMODEL` LEFT JOIN `joom_users` AS `USERSMODEL` ON `VMUSERINFOSMODEL`.`virtuemart_user_id` = `USERSMODEL`.`id` WHERE `VMUSERINFOSMODEL`.`virtuemart_user_id` = '907' ORDER BY `VMUSERINFOSMODEL.address_type` DESC LIMIT 30;
)

[var] => Array
(
[VMUSERINFOSMODEL] => Array
(
[title] => Mr
[first_name] => Paweł
[last_name] => Chojaczyk
[address_1] => Juszkowo Łąkowa
[zip] => 83-000
[city] => Pruszcz Gdański
[phone_1] => 781427556
[address_type] => BT
[virtuemart_user_id] => 907
)

)

)

)
darrenhallinan 01 Dec, 2018
I am having this issue ... something simple im sure just can not figure it out
healyhatman 03 Dec, 2018
Probably going to need a little bit more information sorry. Please drag a debug action after your save data action or at the end of your event and paste here what the output shows. Also be helpful if you add a screenshot of your save data action.
This topic is locked and no more replies can be posted.

2Checkout.com

2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for goods and services provided by ChronoEngine.com