Where on Read_data don't work

na nat22 13h ago

I have a problem with the where statement in read_data.

If I use filed_name={var:action_name}, CV8 creates a SQL statement without quotes, and the database throws an error because it interprets it as a field.

If I use filed_name={var.quote:action_name}, the SQL statement seems correct in Joomla

SELECT * FROM `wodn_erp_itemcolor` WHERE item = 'ZZZ001' 145μs1.3KB/libraries/chrono_lib/chrono.php: 1566 Copy

but then it gives me the error Joomla

"1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '13' at line 1."The problem doesn't seem to occur with {data:}.

Can you help me?

Thank you

Nathan

Joomla 6.1

CF 8.0.52

MariaDB database

Max_admin 12h ago

Hi Nathan

What is the full SQL giving the error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '13' at line 1.

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

Post a Reply