Strict field checking

Jon Parise jon@csh.rit.edu
Sat, 2 Jun 2001 19:24:56 -0400
Previous message: [turba] Turba status
Next message: [turba] Strict field checking
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
In lib/Source.php, it looks like strict field checking is enabled
for the primary key whenever we search a non-public source:

    $strict_fields = array();
    if (!$this->public) {
        $search_criteria['__owner'] = Auth::getAuth();
        $strict_fields = array_keys($this->toDriverKeys(array('__owner' => '')));
    }

Why?  It makes it a little harder to search for names (using SQL)
because the search becomes case-sensitive when strict fields are
used.

-- 
Jon Parise (jon@csh.rit.edu)  .  Rochester Inst. of Technology
http://www.csh.rit.edu/~jon/  :  Computer Science House Member


>From chuck@horde.org Date: Sun,  3 Jun 2001 00:13:41 -0400
Return-Path: <chuck@horde.org>
Mailing-List: contact turba-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list turba@lists.horde.org
Received: (qmail 18524 invoked from network); 3 Jun 2001 04:15:01 -0000
Received: from 208-59-250-206.c3-0.smr-ubr1.sbo-smr.ma.cable.rcn.com (HELO marina.horde.org) (208.59.250.206)
  by horde.org with SMTP; 3 Jun 2001 04:15:01 -0000
Received: by marina.horde.org (Postfix, from userid 33)
	id DD28939F2; Sun,  3 Jun 2001 00:13:41 -0400 (EDT)
Received: from 192.168.0.104 ( [192.168.0.104])
	as user chuck@localhost by marina.horde.org with HTTP;
	Sun,  3 Jun 2001 00:13:41 -0400
Message-ID: <991541621.3b19b975c4884@marina.horde.org>
Date: Sun,  3 Jun 2001 00:13:41 -0400
From: Chuck Hagenbuch <chuck@horde.org>
To: turba@lists.horde.org
References: <20010602192456.B20478@csh.rit.edu>
In-Reply-To: <20010602192456.B20478@csh.rit.edu>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
Subject: Re: [turba] Strict field checking

Quoting Jon Parise <jon@csh.rit.edu>:

> In lib/Source.php, it looks like strict field checking is enabled
> for the primary key whenever we search a non-public source:
> 
>     $strict_fields = array();
>     if (!$this->public) {
>         $search_criteria['__owner'] = Auth::getAuth();
>         $strict_fields = array_keys($this->toDriverKeys(array('__owner'
> => '')));
>     }
> 
> Why?  It makes it a little harder to search for names (using SQL)
> because the search becomes case-sensitive when strict fields are
> used.

That's for the owner field, not the key. It ensures that user 'smith' won't be 
able to access contacts owned by user 'smithfield'. It shouldn't affect looking 
for names at all...

-chuck

--
Charles Hagenbuch, <chuck@horde.org>
Black and white and grey, all the shades of truth.


>From chuck@horde.org Date: Sun,  3 Jun 2001 00:14:12 -0400
Return-Path: <chuck@horde.org>
Mailing-List: contact turba-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list turba@lists.horde.org
Received: (qmail 18903 invoked from network); 3 Jun 2001 04:15:32 -0000
Received: from 208-59-250-206.c3-0.smr-ubr1.sbo-smr.ma.cable.rcn.com (HELO marina.horde.org) (208.59.250.206)
  by horde.org with SMTP; 3 Jun 2001 04:15:32 -0000
Received: by marina.horde.org (Postfix, from userid 33)
	id 67D3139F8; Sun,  3 Jun 2001 00:14:12 -0400 (EDT)
Received: from 192.168.0.104 ( [192.168.0.104])
	as user chuck@localhost by marina.horde.org with HTTP;
	Sun,  3 Jun 2001 00:14:12 -0400
Message-ID: <991541652.3b19b9944f2e3@marina.horde.org>
Date: Sun,  3 Jun 2001 00:14:12 -0400
From: Chuck Hagenbuch <chuck@horde.org>
To: turba@lists.horde.org
References: <Pine.LNX.4.30.0106021546540.19768-100000@ariseth.lib.ci.phoenix.az.us>
In-Reply-To: <Pine.LNX.4.30.0106021546540.19768-100000@ariseth.lib.ci.phoenix.az.us>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
Subject: Re: [turba] Turba status

Quoting Paul Hancock <phancock@lib.ci.phoenix.az.us>:

> At this stage, is it possible for each user to maintain their own contact
> lists?  I did not get the impression that art was ready, yet.

With SQL, yes. LDAP, it might work, but it might be a bit hairy.

-chuck

--
Charles Hagenbuch, <chuck@horde.org>
Black and white and grey, all the shades of truth.


>From chuck@horde.org Date: Sun,  3 Jun 2001 00:15:13 -0400
Return-Path: <chuck@horde.org>
Mailing-List: contact turba-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list turba@lists.horde.org
Received: (qmail 19683 invoked from network); 3 Jun 2001 04:16:34 -0000
Received: from 208-59-250-206.c3-0.smr-ubr1.sbo-smr.ma.cable.rcn.com (HELO marina.horde.org) (208.59.250.206)
  by horde.org with SMTP; 3 Jun 2001 04:16:34 -0000
Received: by marina.horde.org (Postfix, from userid 33)
	id B2DA939F9; Sun,  3 Jun 2001 00:15:13 -0400 (EDT)
Received: from 192.168.0.104 ( [192.168.0.104])
	as user chuck@localhost by marina.horde.org with HTTP;
	Sun,  3 Jun 2001 00:15:13 -0400
Message-ID: <991541713.3b19b9d1981d4@marina.horde.org>
Date: Sun,  3 Jun 2001 00:15:13 -0400
From: Chuck Hagenbuch <chuck@horde.org>
To: turba@lists.horde.org
References: <NCEMLCJBJDBDADHPBAEPGEAPCPAA.rbp@netcanvas.com>
In-Reply-To: <NCEMLCJBJDBDADHPBAEPGEAPCPAA.rbp@netcanvas.com>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
Subject: RE: [turba] Integration with IMP

Quoting Rodrigo Borges Pereira <rbp@netcanvas.com>:

> well, after creating the turba table, i go to imp..
> contacts..add..save...
> 
> Fatal error: Call to undefined function: quotestring() in
> /var/www/html/horde/turba/lib/Driver/sql.php on line 143

This could mean that your database connection isn't set up correctly, also.

-chuck

--
Charles Hagenbuch, <chuck@horde.org>
Black and white and grey, all the shades of truth.
Previous message: [turba] Turba status
Next message: [turba] Strict field checking
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]