"IN" and "NOT IN" statements Error

oc

octav 27 Oct, 2020

Hello,
Please advise why i cannot us "NOT IN" and "IN" conditions (available in conditions dropdown). When using them i get error like in image.
Thanks

Max_admin 27 Oct, 2020

Answer

use the array syntax:

{value:[1,2,3]}

Or better use v7 which has a multi select for this!

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

oc

octav 29 Oct, 2020

I would prefer to continue using v6 for a while. I have tried the above syntax and still error.
Actually i need this condition to in the read_data action:
Model.metakey IN ({var:list})
(where the list var is an array from a php action).
Any ideas how can i achieve this considering that IN and NOT IN conditions are not working in v6.

Max_admin 29 Oct, 2020

if the value is an array then it should work, what does the debug show ?

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

we

webcrea 09 Nov, 2020

Hi,
I have the same issue
I tried
{value:(var:[tableau])} where tableau is an array
{value:(var:tableau)} where tableau is an array
And Itried {value:(var:chaine)} where chaine is like 47,48,49
All give an error
[h1]1064[/h1][h2]You
have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near
''(var:tableau)'' at line 1 [/h2]

Notice that with directly the value like {value:[47,49,48]} it works.
The fact is how to pass a var in this condition?
Thanks
ps : in mysql the query works.
Chris

Max_admin 10 Nov, 2020

1 Likes

what about {var:tableau} ?

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

we

webcrea 10 Nov, 2020

Very nice, that's work well
Thanks Max