I would like to know how to parameterized SQL Commands for PostgreGIS

Permanently deleted user

16 April 2021 16:39

In a server Workflow I tried different syntax in the "Command Text" like @, $ and ? to set the parameters but nothing works. Is it possible?

Thanks in advance!

0

• 

  Permanently deleted user

  16 April 2021 17:03

  Hi @Victor Catalan Diaz? , as discussed on our call, the following syntax should work for the Run SQL Query activity. If using the ODBC Provider and a PostgreSQL connection string, the following should work:

   

  Command Text:

  SELECT id, x, y FROM table WHERE city= ? AND type = ?

   

  Parameters:

  ={

  city: "Victoria",

  type: "Valve"

  }

   

  *Please note, the actual names of the parameters don't matter. The ? placeholder in the Command Text just refers to the order of the parameters. 

   

  Additional information can be found at:

  https://docs.microsoft.com/en-us/sql/odbc/reference/develop-app/binding-parameters-odbc?view=sql-server-ver15

   

  0
• 

  Permanently deleted user

  16 April 2021 17:07

  Thanks 😊

  0

Du måste logga in om du vill lämna en kommentar.