in

Resolve a MySQL syntax error when using the IN clause with a CF form value.

Overview

The error occurs because the form value is passed as a string array instead of a plain comma-separated list.
Ensure the form value is formatted correctly for the SQL query by adjusting the data submission method.

we webcrea 09 Nov, 2020

Hi,

When I use IN in mysql query (see image) I have an error :

in image 1

[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
''47,46,149,50'' at line 1 [/h2]

Does it works?
regards
Chris

we webcrea 09 Dec, 2020

Answer

{value:[1,2,3]}

This topic is locked and no more replies can be posted.