Thank you Philip for pointing that out. Obviously I failed to read the
entire chapter and didn't realise that mysql wasn't another type of
single key lookup. I dont think any additions to the manual is necessary
as on review not only is it BIG but it is also in RED.
Thanx also to Mark.
Using partial with lsearch provided me with the ability to match
sub-domains as well. Is there any way using mysql to achieve something
similar without using sql wildcards ? eg if I ban ilovehotmail.com it will
get matched by hotmail.com whereas partial wouldn't of.
Im currently considering running a script to export the sql table to a
flat file and return to partial-lsearch. Ultimately however I would
prefer to just have it in the sql server.
Any help is highly appreciated.
T
-----Original Message-----
From: Philip Hazel <ph10@???>
To: Tom Bell <Tom@???>
Date: Fri, 9 Aug 2002 11:38:14 +0100 (BST)
Subject: RE: [Exim] partial-mysql query question
> On Fri, 9 Aug 2002, Tom Bell wrote:
>
> > I under stand that, my problem is that I dont want SQL to do the
> > matching. To quote the exim manual at exim.org
> >
> > Partial matching is implemented by doing a series of separate lookups
> > using keys constructed by modifying the original subject key. This
> means
> > that it can be used with any of the single-key lookup types, provided
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>
> > Well it seems that this is not working with partial-mysql.
>
> No, it won't. You've overlooked one vital statement in the manual. The
> title of that section is:
>
> 9.5 Partial matching in single-key lookups
> ^^^^^^^^^^^^^^^^^^^^^
>
> > So my question is probably more like is partial-mysql meant to work ?
>
> No. Partial matching works only in single-key lookups, where Exim has a
> simple key string to look up. I will put a more prominent warning into
> the next edition of the manual.
>
> --
> Philip Hazel University of Cambridge Computing Service,
> ph10@??? Cambridge, England. Phone: +44 1223 334714.
>
>
> --
>
> ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim
> details at http://www.exim.org/ ##
>
