Tutorial :SQLite Select an id which is smaller than a number



Question:

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 ;-)


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!


Solution: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!


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »