Subject | How to use a an integer parameter to fetch parameter = "N" or all rows. |
---|---|
Author | mlq97 |
Post date | 2007-05-30T07:32:11Z |
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
Thanks
Mitch
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
Thanks
Mitch