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 <[EMAIL PROTECTED]> 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?
_______________________________________________
Phpgroupware-developers mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/phpgroupware-developers
