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

[Jerome Schneider]

Hello,

actually the problem is that

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


should be placed *inside* the <datahandler:LISTER> tag ;)


Best regards,
jerome

Asbjørn Morell a écrit :
> 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.