[imp] does expand name have to search whole addressbook?

nlin@newton.berkeley.edu nlin@newton.berkeley.edu
Wed, 31 Oct 2001 14:53:51 -0800


Yes.  I do have the latest.

I've figured out why it's doing it.  Here's my set up.  My local addressbook is 
set to search both email and name field.  And here's the query:

 SELECT object_id, owner_id, object_name, object_email, object_homeAddress,
object_workAddress, object_homePhone, object_workPhone, object_cellPhone, 
object_fax, object_title,
object_company, object_notes FROM turba_objects WHERE LOWER(object_name) LIKE
LOWER('%bill%') OR LOWER(object_email) LIKE LOWER('%bill%') AND owner_id = 
'nlin'

The problem is that there's no parenthesis between the main search of fields 
(which is ORed), and the limiting by owner_id.  It should be

where ( field like blah or field like blah) and owner_id = 'me'.

nancy



Quoting Jan Schneider <jan@horde.org>:

> Did you make sure to have the latest code from cvs? We had a bug causing this
> 
> lately but it should be fixed now.
> 
> Jan.
> 
> Zitat von nlin@newton.berkeley.edu:
> 
> > 
> > Oops.  that's the problem w/ using tab in "compose".  Sorry.
> > 
> > I have two addressbooks, one is marked as public and one private.  I'm
> sure
> > 
> > those settings are correct.  
> > 
> > And I don't see the same problem when searching through turba.  Did I 
> > configure prefs wrong somewhere?
> > 
> > nancy
> > 
> > Quoting Chuck Hagenbuch <chuck@horde.org>:
> > 
> > > 
> > > No, it's not. Is the addressbook marked as public or private? Do you
> see
> > > the 
> > > same thing searching in Turba?
> > > 
> > > -chuck
> > > 
> > > --
> > > Charles Hagenbuch, <chuck@horde.org>
> > > "What was and what may be, lie, like children whose faces we cannot
> see,
> > > in the
> > > arms of silence. All we ever have is here, now." - Ursula K. Le Guin
> > > 
> > > -- 
> > > IMP mailing list: http://horde.org/imp/
> > > Archive: http://marc.theaimsgroup.com/?l=imp&r=1&w=2
> > > Frequently Asked Questions: http://horde.org/faq/
> > > To unsubscribe, mail: imp-unsubscribe@lists.horde.org
> > > 
> > 
> > -- 
> > IMP mailing list: http://horde.org/imp/
> > Archive: http://marc.theaimsgroup.com/?l=imp&r=1&w=2
> > Frequently Asked Questions: http://horde.org/faq/
> > To unsubscribe, mail: imp-unsubscribe@lists.horde.org
> > 
> > 
> 
> 
> :::::::::::::::::::::::::::::::::::::::: 
> AMMMa AG - discover your knowledge
> :::::::::::::::::::::::::::
> Detmolder Str. 25-33 :: D-33604 Bielefeld
> fon +49.521.96878-0 :: fax  +49.521.96878-20
> http://www.ammma.de
> ::::::::::::::::::::::::::::::::::::::::::::::
> 
> -- 
> IMP mailing list: http://horde.org/imp/
> Archive: http://marc.theaimsgroup.com/?l=imp&r=1&w=2
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org
>