Hi,
I try to read data from one table via the condition of a second table - but I cannot manage to put the mysql query into that structure of DB Read Event. Which is in such a case main table, which the related second? Whatever I tried, I got errors such as "there is no model.column in tableX".
How would a query like this one be set into work in CF?
SELECT tableA.created, tableA.title FROM tableA LEFT JOIN tableB ON tableA.id = tableB.itemid WHERE tableB.catid = 11 ORDER BY tableA.created DESC LIMIT 1;
I am somehow stuck and so thankful for any advice.
Herbert
I try to read data from one table via the condition of a second table - but I cannot manage to put the mysql query into that structure of DB Read Event. Which is in such a case main table, which the related second? Whatever I tried, I got errors such as "there is no model.column in tableX".
How would a query like this one be set into work in CF?
SELECT tableA.created, tableA.title FROM tableA LEFT JOIN tableB ON tableA.id = tableB.itemid WHERE tableB.catid = 11 ORDER BY tableA.created DESC LIMIT 1;
I am somehow stuck and so thankful for any advice.
Herbert
Hello HerKle,
You better use v7 which can be installed with v5 on the same website, the relations are easier to setup and there is a SQL data action where you can just write your own SQL code
You better use v7 which can be installed with v5 on the same website, the relations are easier to setup and there is a SQL data action where you can just write your own SQL code
Thanks Max, for your opinion, but aren't there any other possibilities than buying an entire new system - just for one single item?
Btw: The installation of CFv7 failed on https://drogenfreie-erziehung.de - any idea why? "Could'nt find installation package"
Btw: The installation of CFv7 failed on https://drogenfreie-erziehung.de - any idea why? "Could'nt find installation package"
you download and install or you do it through the joomla installer ?
v7 has better functionality and more features!
v7 has better functionality and more features!
try to clear your website's tmp and cache folders!
You need to login to be able to post a reply.
