Re: SqlFieldsQuery With Variable Number of Arguments

[akorensh]

Nargesh,
  If you need to use an array then the following works:

          SqlFieldsQuery query = new SqlFieldsQuery(
                "select concat(firstName, ' ', lastName) from Person where
firstName = ? and lastName = ? and salary >= ?");

        Object[] args = new Object[] { "John", "Doe", 1000};
        query.setArgs(args);

        // Execute query to get names of all employees.
        QueryCursor<List&lt;?>> cursor = cache.query(query);


     In your case, define an array for each distinct use case , fill it
w/arguments as appropriate, instantiate
   a SqlFieldsQuery object and query the cache. 

    
Thanks, Alex



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