I want to remove the quotes from the return value, [image] From: "(null, null, , 0, Defect is adjusted on the site, 1, Sharp Edge / Uneven Edge, , )" To: (null, null, , 0, Defect is adjusted on the site, 1, Sharp Edge / Uneven Edge, , ) I need to use that return value in sql for insertion.

I didn't want to use the option of prepared statements. So, I switched back to traditional method. Writing a general SQL statment and using JS with additionalScope to trigger it as required. Working Fine!

How to remove quotes from return value of a js

💬 Queries and Resources

Tess July 8, 2024, 5:32pm 3

Hi @khatanaashish,

Agreed with @emmulator

For your SQL query, could you share the resource type, screenshot of the query, & current error message?

In the meantime, this post might be helpful

Topic		Replies	Views
Using Output from one SQL Query in a different SQL Query 💬 Queries and Resources javascript , sql	11	7574	August 2, 2023
Javascript not compiling inside of MYSQL Resource Query 💬 Queries and Resources javascript , sql	2	260	July 15, 2024
How do i remove "" from a query 💬 Queries and Resources	3	265	July 5, 2024
JS Transformer Comma Separated String without Double Quotes 💬 Queries and Resources javascript , sql	6	1172	February 22, 2024
Creating dynamic queries / parameterized queries 💬 Queries and Resources	4	870	September 27, 2023

How to remove quotes from return value of a js

Related topics