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

[Christian Trabold]

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