Hi, a few years ago I got eGroupWare (www.egroupware.org) running with MaxDB. Now one release later there are a few problems, I could not solve:
SELECT * FROM egw_addressbook WHERE contact_tid='n' AND (egw_addressbook.contact_owner=7 OR contact_private=0 AND egw_addressbook.contact_owner IN (7,0) OR egw_addressbook.contact_owner IS NULL) ORDER BY n_family<>'' DESC,n_family ASC,n_given ASC,org_name ASC maxdb Error: 37000 ([unixODBC][SAP AG][LIBSQLOD SO][MaxDB] Syntax error or access violation;-3008 POS(214) Invalid keyword or missing delimiter) That query show the addressbook sorted by family-name (placing the contacts without family name at the end). I also tried: SELECT *,n_family<>'' AS others FROM egw_addressbook ... ORDER BY others DESC,n_familiy ASC,n_given ASC,org_name ASC But that gives the same error :-) n_family, n_given and org_name are varchar(40), contact_owner, contact_private are int columns. I also noticed a strainge behavior of the odbc driver. Under openSUSE 10.2 (I think the same is true for all SuSE versions) the odbc.ini is usually in /etc/unixODBC. Placing it there does not work with MaxDB. It only works if I symlink /etc/odbc.ini to /etc/unixODBC/odbc.ini. Took me quite a while to find out ... Ralf -- 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 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
