[TYPO3-project-formidable] <datahandler:LISTER><search> = Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource

[Asbjørn Morell]

Hey

When I add a filter to my <datahandler:LISTER> I get no result back:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result 
resource in 
/mounted-storage/home48a/sub001/sc30931-BJFS/www/typo3/typo3_src-4.1.1/t3lib/class.t3lib_db.php 
on line 987

Formidable : Mayday
DATAHANDLER LISTER configuration isn't correct


<control>

   <tablename>tx_myart_art</tablename>
   <keyname>uid</keyname>
   <labelname>title</labelname>

  <datahandler:LISTER>

   <search>
    <sql>
     <query>SELECT * FROM `tx_myart_art` WHERE `uid` = 6</query>
    </sql>
   </search>

  </datahandler:LISTER>

 </control>

I also tried this: (no go)

<!-- ... -->
<compiledatasource>
  <view>
  <select><![CDATA[
  SELECT * FROM tx_myart_art WHERE uid = 6
  ]]></select>
  </view>
</compiledatasource>
<!-- ... -->
</datahandler:LISTER>



I haven been playing around with this the whole day but just can't get the 
syntax right :(

Any suggestions?


Best regards.
Asbjørn Morell.