topic Re: [resolved] URGENT: please help How can I write a query with double quote? in Talend Studio https://community.qlik.com/t5/Talend-Studio/resolved-URGENT-please-help-How-can-I-write-a-query-with-double/m-p/2236661#M25324 You have to escape the double quote in the SQL Query with \ (\") Wed, 23 Jun 2010 08:21:59 GMT Anonymous 2010-06-23T08:21:59Z [resolved] URGENT: please help How can I write a query with double quote? https://community.qlik.com/t5/Talend-Studio/resolved-URGENT-please-help-How-can-I-write-a-query-with-double/m-p/2236660#M25323 Hi, <BR />I had an OracleInput which I had the following query: <BR />"SELECT "+context.oracle_Schema+".tablea"+".ID, <BR />"+"REGEXP_SUBSTR(REGEXP_SUBSTR("+context.oracle_Schema+".tablea"+".linkdesc,'+',1,1),'+',1,2) linkdesc" <BR />+"FROM "+context.oracle_Schema+".tablea" <BR />I encountered the following errors: <BR />Multiple markers at this line <BR /> - Syntax error on token ""+"", delete this token <BR /> - Syntax error on token ""+"", delete this token <BR /> - Syntax error, insert ";" to complete Statement <BR /> - Syntax error, insert ")" to complete MethodInvocation <BR /> - Syntax error, insert "AssignmentOperator Expression" to complete <BR /> Assignment <BR /> - Syntax error, insert ";" to complete Statement <BR /> - Syntax error, insert "AssignmentOperator Expression" to complete <BR /> Assignment <BR /> - Syntax error, insert ";" to complete Statement <BR /> - Syntax error on token ""+"", ) expected <BR /> - Syntax error on token ""+"", delete this token <BR />I am wondering how can I have a query with double quotes? <BR />Any help is really really appreciated! <BR />Thanks in advance! Sat, 16 Nov 2024 13:22:50 GMT https://community.qlik.com/t5/Talend-Studio/resolved-URGENT-please-help-How-can-I-write-a-query-with-double/m-p/2236660#M25323 Anonymous 2024-11-16T13:22:50Z Re: [resolved] URGENT: please help How can I write a query with double quote? https://community.qlik.com/t5/Talend-Studio/resolved-URGENT-please-help-How-can-I-write-a-query-with-double/m-p/2236661#M25324 You have to escape the double quote in the SQL Query with \ (\") Wed, 23 Jun 2010 08:21:59 GMT https://community.qlik.com/t5/Talend-Studio/resolved-URGENT-please-help-How-can-I-write-a-query-with-double/m-p/2236661#M25324 Anonymous 2010-06-23T08:21:59Z