PostgerSQL possible?

[steinm]

Thanks for your reply, but that makes me think: Why is there an abstraction layer being used, if only one type of database is used?
As I just read, AdoDB requires one to use Portable SQL as described on ( http://phplens.com/lens/adodb/tips_portable_sql.htm ), there might be a more update version showing wich standart is implemented in the current parser. I suppose for using innodb in mysql there is a setting within the AdoDB object. So, in my opinion it would be useful to rewrite all the SQL statements to a Portable SQL eqivalent and using the library the "right way". I'm not shure, if that already is the case, but from all the other perspectives LetoDMS looks very nice to me.

I will take a look at the SQL statements now, and hopefully get an overview of how many statements are affected.

Is there any specific reason, why the SQL dialetct being used is MYSQL and not ANSI SQL(I suppose that is Portable SQL)?

Thank you in advance

I have to admit that adodb has more methods for portable sql than I thought. The reason they are not used in letodms are out of my scope. It's probably unawareness of the problem or adodb just didn't have it when it was first used.

Anyway, there are still limits that can't be handled by an abstraction layer. Some of the sql statements in letodms use concat_ws() which is (as far as I know) only available in mysql.

I'd be very happy to make it more portable.

Uwe