Hi Peter,
the $where parameter in select only allows to use column names as keys,
as eg. the type get’s automatic determined.
What you want to archived can be done easily by using:
$where[] = ‘p.archived IS NULL’;
as it requires no quoting at all.
Ralf
Peter Guhl schrieb:
Hello all
name_quote() in class.egw_db.inc.php is quoting everything containing a
".".
Therefore my query:
array(‘p.archived’=>null)
ends up as:
WHERE p.archived IS NULL
Unfortunately this leads to:
mysql Error: 1054 (Unknown column ‘p.archived’ in ‘where clause’)
If I copy the query and remove the quotes everything is fine.
I am running MySQL Server 5.0.27-community-nt
The productive environment is a PostgreSQL. I don’t know if that one’s
liking the quoting as much as MySQL…
Do you know if I can fix that without changing name_quote() itself? Or
is that already fixed? My eGroupWare Version is (still) 1.4.001.
Regards
Peter
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
