>
> How can I easily query an integer column to get the rows matching
> an integer or also allow all rows to be fetched? EG:
>
> Item.Project (integer)
> Item.Location (integer)
>
> (Case 1)
> Select * from Item where
> Project = :ProjectID and Location = LocationID
>
> (Case 2)
> Select * from Item where
> Project = :ProjectID and Location = all locations
>

select * from Item where
Project = :ProjectId and (Location = :LocationID or :all_locations = 1)

case 1: set :all_location to 0
case 2: set :all_location to 1

Or, you can dynamically build a query and skip " and Location = ..."

Sasha