Read Data action CF 8.0.24

Resolve WHERE condition parameter quoting conflict in ChronoForms Read Data action.

Overview

The issue occurs because the Read Data action now automatically quotes data parameters, which conflicts with manually quoted parameters in the WHERE condition.
Remove the manual quote method from your parameter in the WHERE condition, as the system now handles quoting automatically.

Answered
ChronoForms v8
si simelas 13 Nov, 2024

Hi Max,

in the very last update CF 8.0.24  in the read data  WHERE condition,    field_name={data.quote:param-name} does not function while  field_name={data:param-name} works.

Best,

Max_admin Max_admin 13 Nov, 2024
Answer

correct, the read data will try to auto quote data parameters used in the WHERE or SQL code now, this causes a conflict if the quote method is used, I will try to release a new update ASAP

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.