Adobe Campaign Classic API - Javascript sqlGetString function not working | Community
Skip to main content
A
AquaticAds
November 6, 2020
Solved

Adobe Campaign Classic API - Javascript sqlGetString function not working

  • November 6, 2020
  • 2 replies
  • 1735 views

Hi Adobe Community,

 

I've have been attempting to use the 'sqlGetString' function available within the Adobe Campaign Classic API to test whether a value exists (and return it) within the recipient table. Unfortunately I seem unable to get it to work. Below is the Javascript function as it stands:

 

function checkIfValueExists(str){ try { var val = sqlGetString("SELECT sText2 From NmsRecipient WHERE sText2 = $(sz) LIMIT 1", str); return val.toString(); } catch (e){ return e.toString(); } }

 

  If I change the SQL query to:

 

var val = sqlGetString("SELECT sText2 From NmsRecipient WHERE sText2 = 'ETFX2K' LIMIT 1", str);

 

I seem to the error: 'Error: SCR-160021 Function 'sqlGetString': too many arguments (2 instead of 1).'

 

According to the documentation found here, it should accept two parameters. Maybe i'm going wrong somewhere within my SQL syntax. Would you know what might be causing this? 

Thanks for any help you can offer.

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

Hi,

 

If possible, use xtk instead of sql.

The arity of the sqlGet* functions is determined by the number of bind variables in the query, +1 for the query itself.

In the second example there are zero bind vars so it expects 1 arg.

 

Thanks,

-Jon

2 replies

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
November 9, 2020

Hi,

 

If possible, use xtk instead of sql.

The arity of the sqlGet* functions is determined by the number of bind variables in the query, +1 for the query itself.

In the second example there are zero bind vars so it expects 1 arg.

 

Thanks,

-Jon

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    November 17, 2020

    Hi @aquaticads,

    Was the given solution helpful to resolve your query? Do let us know.

    Thanks!

    Sukrity Wadhwa
    Terms & ConditionsAccessibility statement

    Loading footer...