[TYPO3-project-formidable] Formidable + DBAL - currently not working

[Raphael GEYER]

Hi Christian,

Ameos didn't use FORMidable with DBAL yet. The lister should be the only 
component which uses MySQL specific queries, this was needed to improve 
performance while managing big tables.
We are currently very loaded and we can't integrate DBAL for you currently, 
but we can give you all needed support, and we can modify FORMidable with 
your help in order to manage DBAL in next releases.

Regards,

Raphael GEYER
http://www.ameos.com


"Christian Trabold" <christian.trabold at dkd.de> a écrit dans le message de 
news: 
mailman.1.1193243175.2031.typo3-project-formidable at lists.netfielders.de...
> Hi!
>
> Has anybody used Formidable with DBAL yet?
>
>
> I'm running Postgres 8.1.9 + Formidable 0.7.131 with DBAL and ran into 
> several blockers eg. with this example:
>
> <datasources>
>   <datasource:DB name="pages">
>     <sql><![CDATA[
>       SELECT uid, title, tstamp, crdate from pages WHERE pid = 1
>     ]]></sql>
>   </datasource:DB>
> </datasources>
>
>
>
> The whole form rendering crashes saying "SQL QUERY IS NOT VALID". :(
>
>
> I checked the code and found some MySQL-specific SQL-Queries like:
>
> *class.tx_dhlister.php*
>
> 133: FOUND_ROWS
> 708: SQL_CALC_FOUND_ROWS
> 761: SQL_CALC_FOUND_ROWS
>
>
> which could be the problem. I'm not shure, if DBAL can handle this and if 
> *this* is the reason for the errors...
>
>
>
> Another strange thing I encountered:
>
> In my DBAL-Environment a debug() in "class.tx_dhdb.php" on "function 
> _watchOutDB" throws
>
>
> 8< - - - - - - - - - - - - - - - - - - - - - - - -
>
> stdClass Object
> (
>     [TYPO3_DBAL_handlerType] => adodb
> )
>
> - - - - - - - - - - - - - - - - - - - - - - - - >8
>
>
> while a native MySQL-Installation throws only
>
> 8< - - - - - - - - - - - - - - - - - - - - - - - -
>
> Resource id #137
>
> - - - - - - - - - - - - - - - - - - - - - - - - >8
>
>
> So where's the problem? Is it DBAL or Formidable or both together?
>
> Are there any plans to get it work with DBAL?
>
>
> If anybody is willing to investigate this with me, it would be very 
> nice... otherways I have to say "au revoir" to formidable for now.
>
>
>
> Greetings,
>
> Christian