Re: SqlFieldsQuery With Variable Number of Arguments

[akorensh]

Hi,
  Take a look at this example:
https://github.com/apache/ignite/blob/master/examples/src/main/java/org/apache/ignite/examples/sql/SqlQueriesExample.java
   
Use this as a template:

        String sql = "select * from Person where salary > ? and salary <=
?";

        // Execute queries for salary ranges.
        print("People with salaries between 0 and 1000 (queried with SQL
query): ",
            cache.query(new SqlFieldsQuery(sql).setArgs(0, 1000)).getAll());

        print("People with salaries between 1000 and 2000 (queried with SQL
query): ",
            cache.query(new SqlFieldsQuery(sql).setArgs(1000,
2000)).getAll());

Thanks, Alex



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/