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 add sql query data from another table to hidden field

PJNO 08 Feb, 2017
Hi,
I working with chronoconnectivity v5.
I trying to build an application, where I use Selector and hidden fields in rows. Now I should get a latest Id from another table to all these hidden fields. Then it is possible to select rows and update these where I want to add relation to another table.

I have already did sql query and I get latest id informatio from another table. But the problem is that how could I add this latest id info from sql to hidden fields ?

This sql query it is in pre processing display window. Is it right place?

I'm newbie here, so sorry perhaps stupid questions.

-Paul
Max_admin 10 Feb, 2017
Hi Paul,

If you have a custom list display then you can find the matching row from your custom query results and add it, alternatively you can use Connectivity v6 and get the latest id value using a "hasMany" relation, that should be easier, adding the fact that v6 is better and has more features.

Best regards,
Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
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