Re: [Phpgroupware-developers] Searching the addressbook

[Alex Borges]

El dom, 29-02-2004 a las 22:13, Bob Crandell escribió:
> Sorry, Alex.
> 
> I've set up a cron job to pull down the latest CVS at 4 every morning.
> 
> My main addressbook shows Full name, Home phone, Office phone

BTW, great job @ testing....:)

Um... here is the thing. We commited a patch last week that makes it so
you choose what kind of data are you searching for (adds a drop down box
to the index page). This reduces the complexity a lot and is also
standard in all the addressbooks ive checked (from outlook to mozilla,
to any ldap based front end).

If youre not seeing this extra combo in the index, then sopmething went
wrong in your update... (cause im seeing it here)...

Please report back on this asap... 

> 
> Database error: Invalid SQL: SELECT count(person_id) AS count_persons FROM
> phpgw_contact AS contact_central INNER JOIN phpgw_contact_person AS
> contact_person ON contact_person.person_id = contact_central.contact_id WHERE
> (( ((contact_central.access = 'public' AND contact_central.owner IN
> (595483,599437,599438,599443,599444,599449,599454,599441,599450,599456,599439))
> OR contact_central.owner = 599438) AND ( (contact_central.cat_id = '8' OR
> UPPER(contact_central.cat_id) LIKE '%,8,%') OR (contact_central.cat_id = '19'
> OR UPPER(contact_central.cat_id) LIKE '%,19,%') OR (contact_central.cat_id =
> '20' OR UPPER(contact_central.cat_id) LIKE '%,20,%') )) AND
> (UPPER(contact_person.per_full_name) LIKE '%robin%' OR
> UPPER(contact_person.prefix) LIKE '%robin%' OR UPPER(contact_person.suffix)
> LIKE '%robin%' OR UPPER(contact_person.birthday) LIKE '%robin%' OR
> UPPER(contact_person.pubkey) LIKE '%robin%' OR UPPER(contact_person.title)
> LIKE '%robin%' OR UPPER(contact_person.department) LIKE '%robin%' OR
> UPPER(contact_person.initials) LIKE '%robin%' OR UPPER(contact_person.sound)
> LIKE '%robin%' OR UPPER(contact_person.active) LIKE '%robin%'))
> MySQL Error: 1054 (Unknown column 'contact_person.per_full_name' in 'where
> clause')
> 
> File: /home/web/htdocs/phpgroupware/phpgwapi/inc/class.contacts_sql.inc.php
> Line: 1339
> 
> Session halted.
> 
> Is the data I sent you helping at all?
> 
> I just thought of something.  Did the changes you make require a visit to
> Setup?  I'll check as soon as I hit Send.
> 
> Thanks
> Bob
> 
> Alex Borges (address@hidden) wrote:
> >
> > I hope this catches you....
> > Monday will be too late, we release saturday!
> >
> > El vie, 27-02-2004 a las 12:26, Bob Crandell escribió:
> > > Alex,
> > >
> > > I'm on my way out of town now.  I'll let you know Monday when I get back.
> > >
> > > Thanks
> > >
> > >
> > > Alex Borges (address@hidden) wrote:
> > > >
> > > > Update from cvs... let me know about what you think....
> > > >
> > > > El jue, 26-02-2004 a las 22:33, Bob Crandell escribió:
> > > > > Hi Alex,
> > > > >
> > > > > You asked what search I was using.  I'm answering here 'cause I don't 
> > > > > know
> > > > > better.
> > > > >
> > > > > I entered susan in the search field.
> > > > >
> > > > > There are more than on susan in the list.
> > > > >
> > > > > Thanks
> > > > > Bob
> > > > >
> > > > > --
> > > > > Assured Computing, Inc.
> > > > > When you need to be sure.
> > > > > http://www.assuredcomp.com/
> > > > > P.O. Box 40814
> > > > > Eugene, OR 97404
> > > > > Voice - 541-868-0331
> > > > > FAX - 541-463-1627
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > _______________________________________________
> > > > > Phpgroupware-developers mailing list
> > > > > address@hidden
> > > > > http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
> > > > >
> > > >
> > > >
> > > >
> > > > _______________________________________________
> > > > Phpgroupware-developers mailing list
> > > > address@hidden
> > > > http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
> > > >
> > >
> > > --
> > > Assured Computing, Inc.
> > > When you need to be sure.
> > > http://www.assuredcomp.com/
> > > P.O. Box 40814
> > > Eugene, OR 97404
> > > Voice - 541-868-0331
> > > FAX - 541-463-1627
> > >
> > >
> > >
> > >
> > > _______________________________________________
> > > Phpgroupware-developers mailing list
> > > address@hidden
> > > http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
> > >
> >
> >
> >
> > _______________________________________________
> > Phpgroupware-developers mailing list
> > address@hidden
> > http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
> >
> 
> --
> Assured Computing, Inc.
> When you need to be sure.
> http://www.assuredcomp.com/
> P.O. Box 40814
> Eugene, OR 97404
> Voice - 541-868-0331
> FAX - 541-463-1627
> 
> 
> 
> 
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>