Re: [PATCH] include destination into dlr lookup

Enver ALTIN <[email protected]>
Newsgroups gmane.comp.mobile.kannel.devel
Organization Parkyeri
Message-ID <[email protected]>
Hi,

On Sun, 2004-09-26 at 17:07 +0200, Alexander Malysh wrote:
> > I believe avoiding use of `like` in SQL statements is better.
> 
> it's impossible to avoid `like` by indirect lookup... if it's
> possible, please teach me ;)

Walking upstairs from subway this morning, I remembered this and thought
that storing everything stripped and making strict comparison with
stripped data would work.

So we would INSERT a DLR record with stripped destination and
UPDATE/DELETE/SELECT would get a stripped destination for WHERE clause.

What do you think?
-- 
Enver ALTIN                   |        http://skyblue.gen.tr/
Software developer @ Parkyeri |      http://www.parkyeri.com/
signature.asc (application/pgp-signature, 189 B)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)

iD8DBQBBV/TqZCB2FZvqK0sRArT7AJ4sMcC81QDylYHlNQKKBZ8+adEtfgCeMWu4
hDOgdbuSSREx4yOsoiWrwPo=
=6LNV
-----END PGP SIGNATURE-----
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.