SQLite Select an id which is smaller than a number

Question

Hi,

I am trying to only select the objects where the id is smaller than an int value.

e.g.: i have 3 objects -> id = 1, id = 2, id = 3 Now I want to only get the objects with the id smaller than the variable i = 2;

How can I manage this?

sql = "SELECT id FROM table_name WHERE id <= i";

Thanks ;-)

Answer 1

SQLite supports standard SQL syntax for parameterized queries, so one of the following will be useful:

SELECT id FROM table_name WHERE id <= ?
SELECT id FROM table_name WHERE id <= :i

The first uses a positional parameter (the ?) and the second a named parameter (i). How those are bound in your host language we can't tell you; we don't know what lang you are using!

Answer 2

I am using SQLite3 on iPhone OS. When I do:

SELECT id FROM table_name WHERE id <= 2

it works... but the problem is the variable i!