Forums

MySQL Aggregate Functions

Eddi Bournell 06 Jan, 2024
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()"
Max_admin 19 Jan, 2024
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
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
You need to login to be able to post a reply.