<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Parametrized query issue: Error: SCR-160021 Function 'query': too many arguments (X instead of 1). in Adobe Campaign Classic Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/parametrized-query-issue-error-scr-160021-function-query-too/m-p/460081#M15633</link>
    <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="17546941"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Outside the error, why are you using JavaScript and not a Query activity within a Workflow?&lt;/P&gt;&lt;P&gt;In JavaScript, you would use queryDef object (&lt;A href="https://experienceleague.adobe.com/developer/campaign-api/api/sm-queryDef-BuildQuery.html" target="_blank"&gt;https://experienceleague.adobe.com/developer/campaign-api/api/sm-queryDef-BuildQuery.html&lt;/A&gt;)&lt;/P&gt;&lt;P&gt;I would not recommend to use the DBEngine, you're exposing yourself to trouble down the line....&lt;/P&gt;&lt;P&gt;In your use case, why queryDef would work or Query activity in a workflow?&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;Denis&lt;/P&gt;</description>
    <pubDate>Fri, 08 Jul 2022 09:00:27 GMT</pubDate>
    <dc:creator>Denis_Bozonnet</dc:creator>
    <dc:date>2022-07-08T09:00:27Z</dc:date>
    <item>
      <title>Parametrized query issue: Error: SCR-160021 Function 'query': too many arguments (X instead of 1).</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/parametrized-query-issue-error-scr-160021-function-query-too/m-p/456526#M15396</link>
      <description>&lt;P&gt;Dear Community,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am trying to use DBEngine &lt;STRONG&gt;query()&lt;/STRONG&gt; command to select data from MSSQL database and I need to pass parameter/s to my query. I am following this tech spec -&amp;nbsp;&lt;A href="https://experienceleague.adobe.com/developer/campaign-api/api/m-DBEngine-query.html" target="_blank" rel="noopener"&gt;DBEngine.query() documentation&lt;/A&gt;.&lt;/P&gt;&lt;P&gt;There is an example showing how to pass a param - to do this use $(l), $(sz) as a param-holder/s (depending on param type), then pass param value/s separated by comma. Easy.&lt;/P&gt;&lt;P&gt;However, when I do so I get an exception:&amp;nbsp;&lt;FONT color="#FF0000"&gt;&lt;EM&gt;Error: SCR-160021 Function 'query': too many arguments (X instead of 1).&lt;/EM&gt;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;Where X is 2 if I pass a single param. It's 3 if I pass two params. And so on. Only query text is possible to pass as a single allowed function argument.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;This is my code lines:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="javascript"&gt;var conn = application.getConnection();
result_Select = conn.query('SELECT 12345 as Col1, \'John Doe\') as Col2 WHERE 1 = $(l);', 1);&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;This is the exception:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;Error: SCR-160021 Function 'query': too many arguments (2 instead of 1).&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P data-unlink="true"&gt;ACC v7.0 19.1 build 9032@d3b4522f&amp;nbsp;of 01/07/2021.&lt;/P&gt;&lt;P data-unlink="true"&gt;&amp;nbsp;&lt;/P&gt;&lt;P data-unlink="true"&gt;Btw, the same problem for &lt;A href="https://experienceleague.adobe.com/developer/campaign-api/api/m-DBEngine-execute.html" target="_blank" rel="noopener"&gt;DBEngine.execute()&lt;/A&gt;&amp;nbsp;command.&lt;/P&gt;&lt;P data-unlink="true"&gt;&amp;nbsp;&lt;/P&gt;&lt;P data-unlink="true"&gt;Is this a problem? Or I do something wrong?&lt;/P&gt;&lt;P data-unlink="true"&gt;Please help.&lt;/P&gt;&lt;P data-unlink="true"&gt;&amp;nbsp;&lt;/P&gt;&lt;P data-unlink="true"&gt;Thanks!&lt;/P&gt;</description>
      <pubDate>Thu, 16 Jun 2022 07:11:23 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/parametrized-query-issue-error-scr-160021-function-query-too/m-p/456526#M15396</guid>
      <dc:creator>igorku</dc:creator>
      <dc:date>2022-06-16T07:11:23Z</dc:date>
    </item>
    <item>
      <title>Re: Parametrized query issue: Error: SCR-160021 Function 'query': too many arguments (X instead of 1).</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/parametrized-query-issue-error-scr-160021-function-query-too/m-p/456534#M15398</link>
      <description>&lt;P&gt;Hello&amp;nbsp;&lt;LI-USER uid="17546941"&gt;&lt;/LI-USER&gt;&amp;nbsp;,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;There is issue in your query as highlighted below:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Parvesh_Parmar_0-1655368463579.png" style="width: 999px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/41913i36961FC32BEEA17A/image-size/large/is-moderation-mode/true?v=v2&amp;amp;px=999" role="button" title="Parvesh_Parmar_0-1655368463579.png" alt="Parvesh_Parmar_0-1655368463579.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;When I run the below query then it executed.&lt;/P&gt;&lt;P&gt;var cnx = application.getConnection()&lt;BR /&gt;result_Select = cnx.query('SELECT 12345 as Col1, \'John Doe\' as Col2 WHERE 1 = $(l);', 1);&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks.&lt;/P&gt;&lt;P&gt;Parvesh.&lt;/P&gt;</description>
      <pubDate>Thu, 16 Jun 2022 08:35:31 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/parametrized-query-issue-error-scr-160021-function-query-too/m-p/456534#M15398</guid>
      <dc:creator>Parvesh_Parmar</dc:creator>
      <dc:date>2022-06-16T08:35:31Z</dc:date>
    </item>
    <item>
      <title>Re: Parametrized query issue: Error: SCR-160021 Function 'query': too many arguments (X instead of 1).</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/parametrized-query-issue-error-scr-160021-function-query-too/m-p/456749#M15407</link>
      <description>&lt;P&gt;Hello Parvesh,&lt;/P&gt;&lt;P&gt;Thank you for detecting extra symbol, but actually I don't have it in my code. Not sure what's the problem on my end but this is what I am seeing.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="igorku_1-1655465313425.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/41969i0F87F8F760077945/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="igorku_1-1655465313425.png" alt="igorku_1-1655465313425.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;On front is a Javascript code window. On back is a browser where I see the exception.&lt;/P&gt;&lt;P&gt;Any ideas?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;</description>
      <pubDate>Fri, 17 Jun 2022 11:28:44 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/parametrized-query-issue-error-scr-160021-function-query-too/m-p/456749#M15407</guid>
      <dc:creator>igorku</dc:creator>
      <dc:date>2022-06-17T11:28:44Z</dc:date>
    </item>
    <item>
      <title>Re: Parametrized query issue: Error: SCR-160021 Function 'query': too many arguments (X instead of 1).</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/parametrized-query-issue-error-scr-160021-function-query-too/m-p/460081#M15633</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="17546941"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Outside the error, why are you using JavaScript and not a Query activity within a Workflow?&lt;/P&gt;&lt;P&gt;In JavaScript, you would use queryDef object (&lt;A href="https://experienceleague.adobe.com/developer/campaign-api/api/sm-queryDef-BuildQuery.html" target="_blank"&gt;https://experienceleague.adobe.com/developer/campaign-api/api/sm-queryDef-BuildQuery.html&lt;/A&gt;)&lt;/P&gt;&lt;P&gt;I would not recommend to use the DBEngine, you're exposing yourself to trouble down the line....&lt;/P&gt;&lt;P&gt;In your use case, why queryDef would work or Query activity in a workflow?&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;Denis&lt;/P&gt;</description>
      <pubDate>Fri, 08 Jul 2022 09:00:27 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/parametrized-query-issue-error-scr-160021-function-query-too/m-p/460081#M15633</guid>
      <dc:creator>Denis_Bozonnet</dc:creator>
      <dc:date>2022-07-08T09:00:27Z</dc:date>
    </item>
    <item>
      <title>Re: Parametrized query issue: Error: SCR-160021 Function 'query': too many arguments (X instead of 1).</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/parametrized-query-issue-error-scr-160021-function-query-too/m-p/542469#M15960</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="17546941"&gt;&lt;/LI-USER&gt;,&lt;/P&gt;
&lt;P&gt;Were you able to resolve this query or do you still need more help here? Do let us know.&lt;/P&gt;
&lt;P&gt;Thanks!&lt;/P&gt;</description>
      <pubDate>Wed, 24 Aug 2022 06:42:38 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/parametrized-query-issue-error-scr-160021-function-query-too/m-p/542469#M15960</guid>
      <dc:creator>Sukrity_Wadhwa</dc:creator>
      <dc:date>2022-08-24T06:42:38Z</dc:date>
    </item>
  </channel>
</rss>

