rob wrote:
>
> your using table.attrib like '%' to match everything except nulls
> right?
>
> use table.attribute IS NOT NULL instead.
No, it's the web interface to our hotel-db. People can search for eg.
City but may leave this field blank.
So % is always appended (sometimes also prepended).
I didn't know that it doesn't match NULL, but fortunately the attributes
are all NOT NULL.
thx
cu
--
Nabil Sayegh
GPG-Key available at http://www.sayegh.de
(see http://www.gnupg.org for details)
