--
--On Sunday, December 21, 2003 19:49:09 -0500 Eli <eli@???>
wrote:
> You might be able to do this very easily using the LIKE search function in
> SQL.
>
> When you run your check on $domain, rather than doing something like:
>
> "select .... where domain = '${quote_pgsql:$domain}'"
>
> Use instead:
>
> "select .... where domain like '%${quote_pgsql:$domain}'"
The problem is the $domain I get from exim is too long, and I need
to really SHORTEN it, not LENGTHEN it, which is what you suggest here.
Thanks for the reply, however.
LER
>
> Hope that helps, might put a little burden on the SQL server, but it might
> be the easiest/cleanest way of doing it :)
>
> Eli.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@???
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
--
[ Content of type application/pgp-signature deleted ]
--
