Re: select where true, or select where input = '$var'

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