Goal: I want to send an update to the DB every time a cell is edited. I use a dynamic query that looks like this: UPDATE table SET "{{table13.selectedCell.columnId}}" = '{{table13.selectedCell.value}}' WHERE id = {{table13.selectedRow.id}}; The Retool editor popup says that the query would like l…

Thank you! I ended up using the GUI to do th query in the end, and it worked.

SQL query to postgres DB failing when using dynamic values

MiguelOrtiz September 12, 2024, 10:50am 2

You may find answers to what you're facing here, and a potential solution here.

Hope this helps!

1 Like

Topic		Replies	Views
FROM database_name as db >>> FROM {{select_table.value}} as db 💬 Queries and Resources	8	1325	August 3, 2023
How do I write a SQL UPDATE with dynamic columns 💬 Queries and Resources sql , syntax-error	2	15283	July 11, 2022
Insert/Update for Retool database table does not work in SQL mode 💬 Queries and Resources sql , table , postgresql	7	2719	June 21, 2023
How to create a dynamic query without changing resource settings? 💬 Queries and Resources sql	10	7043	August 3, 2023
Updating jsonb column 💬 Queries and Resources postgres , postgresql	8	8888	December 28, 2023