Martijn Houtman <[EMAIL PROTECTED]> wrote: > The behaviour of max depends now on support of the databaselayer. I > reported the bug as medium, but I think it should be high (I try to change > it but it is not allowed). Lots of things that depend on max do not work > anymore with mysql. Editwizards, images with templates and I believe also > daymarks are not working well. It should be easy to include the old > behaviour when the databaselayer does not support limiting of the number > of records. > > I can switch to SQL 2000 that does support it, but I found no support in > MMBase for it (probably because it is from Microsoft).
I think the problem occors because somewhy 'BasicSqlHandler' is triggered for mysql, while it should use 'MySqlSqlHandler'. It should go better if in mmbaseroot.xml is this: <property name="storagemanagerfactory">org.mmbase.storage.implementation.database.DatabaseStorageManagerFactory</property> and the 'database' property is removed. Somewhy 'mysql' used to be named 'relational'. The trouble is that 'max' is not standard SQL so it is not impelemntend in BasicSqlHandler. But is _is_ implementend in MySql, and MySqlSqlHandler. Michiel -- Michiel Meeuwissen Mediapark C101 Hilversum +31 (0)35 6772979 nl_NL eo_XX en_US mihxil' [] ()
