On 2/19/2015 12:39 PM, zach cruise wrote:
> i want to select based on input, but if input is not provided or if
> input is empty, then i want to select all rows.
(metalanguage) if input is provided, then query("SELECT stuff FROM
table WHERE whatever = $INPUT")
else, query("SELECT stuff
FROM table")
in other words, make the decision as to what query to execute OUTSIDE of
sql by invoking different queries based on your application's 'input'.
--
john r pierce 37N 122W
somewhere on the middle of the left coast