[Phpgroupware-developers] Re: [phpgw-ct] class.acl + mysql

[Sigurd Nes]

How about putting something like this (from 'property') some central
place in the api?

if ($GLOBALS['phpgw_info']['server']['db_type']=='pgsql')
{
  $this->join = "JOIN";
  $this->like = "ILIKE";
}
else
{
  $this->join = "INNER JOIN";
  $this->like = "LIKE";
}

Regards

Sigurd


aeb wrote:
> On Thu, 13 Apr 2006, Chris Weiss wrote:
>
> > mysql is picky, that should be LEFT JOIN or INNER JOIN or even LEFT
> > INNER JOIN, for some reason mysql doens't assume LEFT INNER like other
> > rdbms do
>
> yes, it works with left join in mysql, but not in psql. i got that prob in
> projects years ago and ended up switching the sql statement for
> mysql -> left join /postgres -> join
>
> > On 4/13/06, aeb <address@hidden> wrote:
> > > hey,
> > >
> > > phpgw head - acl:
> > > the join statement (attached file) doesn't work with mysql 3.23.55.
> > > whats the smallest mysql version phpgw supports?