[Typo3-dev] DBAL Drivers

[Martin Ficzel]

Florian Schaeffer wrote:

> Only use standard-sql functions and avoid any DB-specific things like 
> the FIND_IN_SET or LIMIT BY - things.

when i found the FIND_IN_SET function i knew that it would cause trouble 
sometimes  :-( . does anybody know a reference of the sql standard,  and 
at all wich sql standard is used? i found at least three ( sql-86/sql, 
sql-92/sql2 , sql3 ) .. without that informations it is quite impossible 
to check whether a function is db-proprietary or not.

> I don't know the DBAL at the moment but in ADODb there are 
> meta-functions for that, so one can use a wrapper for let's say the 
> limit part of the query.

ok now i understand better ... you mean the datasources and the adodb 
extension ... i did'nt know they are able to support the typo3-core i 
only thought they would be usefull for extensions wich are using 
external databases.

regards Martin