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

[Asbjørn Morell]

Hello

you are right. Sorry I don't know how I managed to mess that up. :)

Thanks!

Best regards.
Asbjørn Morell.



"Jerome Schneider" <j.schneider at ameos.com> wrote in message 
news:mailman.1.1179603139.449.typo3-project-formidable at lists.netfielders.de...
> 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.