passing 2 params to execSQL in dbParamValues

, ,
1

Let’s say you have a sql query that has a where clause that need 2 params ( between ? and ?)

How do you supply 2 params to wm.db.execSql in * $dbParamValues

2

Why not create your SQL statement by embedding variable names in the string and having the “Perform Variable Substition” switched on.

e.g.

“SELECT * from tab1 where col1 = ‘%var1%’ and col2 = '%var2%”