Unkown characters included in insert query execution string

[rich1]

im not sure why the error string includes backslashes in the date when there is no sign of them in the string being submitted.

the same query will run if i explicitly set the values but obviously that doesnt do me any good.

i have tried every combination of playing around with the formatting of the string but no luck. has anyone seen this before?

[Tess]

Hey @rich1 Thanks for joining office hours as well!

[Tess]

As we chatted about in office hours, this is related to Retool's prepared statements

Some options are:

• Using Gui mode whenever possible
• Converting the bulk insert into a single insert & using JS to loop through your records to insert
• Disabling prepared statements (Disabling prepared statements can break other queries, and it has security risks. If you choose this option, we recommend making a copy of your resource where one still has prepared statements enabled so that your other queries continue to work and you can limit the risk)

Here's some related posts:

Prepared statement setting alternative solution?

I would probably try to do this as a loop with where as much of the query as possible is hardcoded (inserting one record at a time if needed) [image]

Insert into resource using SQL mode

Hi @flyinghedgehogs Thanks for reaching out! We are tracking a feature request for this use case internally. I'll post back here when we're able to ship a feature for dynamic sql table names in GUI mode. In the meantime, my best recommendation is to make a GUI mode query for each table and call the queries dynamically based on the user input. Working with SQL mode in this way can be fairly tricky, as articulated in this community post For example, I was able to get this hacky code working, wit…

Bulk insert SQL mode. Is it possible?

Bit of an old thread, but you can bulk insert with SQL mode queries in order to return the created IDs back to the app if the resource doesn't have the prepared statement setting enabled. You essentially need to craft the values part of the SQL query with JS (specifics will depend on your array and DB structure), and then reference that in your insert query set to return whatever created record data. [screenshot-4BN9dwLT@2x]