Forums

DB Read has no WHERE

RamboRon 19 Jul, 2014
If I'm pulling database information why would there be no where clause? V4 had it, why make something more complicated instead of improving it. Do I need to go back to v4? Was v5 released too early? Seems like as I read the answers for v5 that a lot of stuff is not implemented yet or has issues. Registration of users was a big one that worked in v4 but now not in v5. And why ne versions all the time. If a product works well, why not just secure it and improve it? Especially since we keep paying for new licenses. Unlike big software companies that need new versions to bring in income because they are supporting an old product that brings in no income. Every time I add your software to a site it brings you income it doesn't matter the version. Now I have to retrain a whole staff on how your new stuff does not work like your old stuff. 😟
GreyHead 20 Jul, 2014
Hi RamboRon,

In the CFv5 DB Read you want the Conditions box (I have no idea why it's called that). Please see this FAQ for some info on using it.

Bob

PS I'm inclined to agree with you that many of the changes in CFv5 are a pain in the proverbial - though I don't think that you need new licenses to upgrade existing sites from CFv4 to CFv5 (though I'd probably leave them on CFv4 anyhow).
RamboRon 30 Jul, 2014
If it improves I will certainly be buying licenses as I buy and test on a regular basis.
RamboRon 19 Aug, 2014
So is there a way to do joins and use a token to reload the information with the DB Read?
Max_admin 19 Aug, 2014
Hi,

Token usage can be done this way:

<?php
return array('model_id.column' => $form->data('field'));
?>


Joins setup in v4 was a bit confusing, so an improved setup is needed, until this is ready, you can do it with code, which is easy using the new CF framework:
http://www.chronoengine.com/faqs/70-cfv5/5231-building-complex-db-queries-using-the-gcore-framework.html

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.