I 'd like to use MySQL Aggregate Functions like SUM() or MAX() etc. Is it possible in a CF7- read_data_action? Or has anybody an example with a CF-7-sql-action.
Thanks to colnem , he posted a tutorial: Using SQL DATABASE action in CF7 ->https://www.chronoengine.com/forums/topics/view/110663/tuto-using-sql-database-in-cf7#p401242
It works with CF7.0.10 an MySQL 5.7
with MariaDB 10.6 it throws an error:"Call to undefined method Joomla\Database\Mysql\MysqlDriver::query()"
Thanks to colnem , he posted a tutorial: Using SQL DATABASE action in CF7 ->https://www.chronoengine.com/forums/topics/view/110663/tuto-using-sql-database-in-cf7#p401242
It works with CF7.0.10 an MySQL 5.7
with MariaDB 10.6 it throws an error:"Call to undefined method Joomla\Database\Mysql\MysqlDriver::query()"
I would say just build your query using PHP and use the CF functions to grab the form fields values you need, let me know if you need help with the code
You need to login to be able to post a reply.