Using the provided instructions, I constructed a SQL statement in a List Autocomplete Field using [USER_ID]. I turned on the "List values from SQL query" field (i.e. set it to Yes) and placed the SQL statement in the "SQL query" field. On the front end, the form doesn't display and it instead throws a 404 error, with a debug statement as follows:
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 '[USER_ID]' at line 2 SQL=SELECT ... AS id, CONCAT('Name: ', ...) AS text FROM ... WHERE user_id = [USER_ID]
(I intentionally removed the table and field names.)
It appears Cobalt 8 is not converting placeholders such as [USER_ID].
Problem
Announcement
Conversation
Idea
Praise
Question
Open
Using the provided instructions, I constructed a SQL statement in a List Autocomplete Field using [USER_ID]. I turned on the "List values from SQL query" field (i.e. set it to Yes) and placed the SQL statement in the "SQL query" field. On the front end, the form doesn't display and it instead throws a 404 error, with a debug statement as follows:
(I intentionally removed the table and field names.)
It appears Cobalt 8 is not converting placeholders such as [USER_ID].