On Wed, Nov 15, 2000 at 09:16:37PM -0700, some SMTP stream spewed forth:
> Hello,
>
*snip*
> A snippet from this code is as follows:
>
> ...
> $where = 'true';
> if ($form->{number}) {
> $callback .= "&number=$form->{number}";
> $where .= " AND number ~* '$form->{number}'";
> }
> if ($form->{description}) {
> $callback .= "&description=$form->{description}";
> $where .= " AND description ~* '$form->{description}'";
> }
>
> $query = qq|SELECT id, number, description, onhand, unit, sellprice
> FROM parts
> WHERE $where
> ORDER BY $form->{sort}
> |;
> ...
>
> Now if the two 'if' conditionals are false, the query becomes:
>
> SELECT id, number, description, onhand, unit, sellprice
> FROM parts
> WHERE true
> ORDER BY number
>
>
> What does it mean here for the WHERE to be true? What is being tested
> for true? Is this just a 'place holder', if you will, for the WHERE
> field in case the two 'if' conditionals are false and so the WHERE field
> is not blank?
>
Er, I hope this helps.
< http://www.postgresql.org/docs/user/sql-select.htm#SQL-WHERE >
It looks like the 'true' is just in there to ensure that all rows are
returned.
I can't think of why someone wolud do that..
G'luck and
cheers
gh
> Thanks,
> Murrah Boswell
>
