[TYPO3-project-formidable] Formidable questions

[Luc Muller]

Hi Mack,

You should have a try with :

{starttime.debug()}

You can do this on every kind of renderlet.

This can be helpful ;)

Luc =:0)

Mack Sol a écrit :
> Hello Manuel, Hello Jerome, Hello list,
>
> Manuel, thanks for your help. Thanks to you my list is sorted at first display and I can use the sort column option :)
> About the DATE renderlet problem, I have found why it's not working. It's because of my template. Indeed I have tested my code with the default template and it's work.
> The line of my template :
> <td>{starttime.value}</td>
> <td>{endtime.value}</td>
> Give me 12148632000 & 1216850400
> But if I write :
> <td>{starttime}</td>
>
> <td>{endtime}</td>
> I have "Start 01 juillet 2008" and "End 24 
> juillet 2008 "
> Start and End are the labels. I don't want them to be displayed on all the lines but if I use starttime.value and endtime.value it's not working...
> Have you an idea how I can do ?
>
> Jerome, thanks to you too! Now my tiny looks good :) I really appreciate your help.
>
> If someone have an idea about my renderlet file question I still have the problem so it would be helpfull.
>
> Best regards
>
>
>   
>> From: typo3dev at ameos.com
>> Date: Wed, 23 Jul 2008 09:52:46 +0200
>> To: typo3-project-formidable at lists.netfielders.de
>> Subject: Re: [TYPO3-project-formidable] Formidable questions
>>
>> Hi,
>>
>> concerning TINYMCE, you can configure everything like this:
>>
>> <renderlet:TINYMCE name="tinymce" label="tinymce">
>>     <config
>>        width="400"
>>        height="200"
>>     />
>> </renderlet:TINYMCE>
>>
>> If you want all the buttons + toolbar on top
>>
>> <renderlet:TINYMCE name="tinymce" label="tinymce">
>>     <config
>>        width="400"
>>        height="200"
>>        theme="advanced"
>>        theme_advanced_toolbar_location="top"
>>     />
>> </renderlet:TINYMCE>
>>
>> If you want to choose wich buttons should be there:
>>
>> <renderlet:TINYMCE name="tinymce" label="tinymce">
>>     <config
>>        theme="advanced"
>>        width="400"
>>        height="200"
>>        theme_advanced_buttons1="bold,underline,bullist,link"
>>        theme_advanced_buttons2=""
>>        theme_advanced_buttons3=""
>>        theme_advanced_toolbar_location="top"
>>     />
>> </renderlet:TINYMCE>
>>
>>
>> All available configuration is described here:
>> http://wiki.moxiecode.com/index.php/TinyMCE:Configuration
>>
>>
>> Best regards,
>> Jerome Schneider
>>
>> Manuel Rego Casasnovas a écrit :
>>     
>>> Hello,
>>>
>>> Some quick answers:
>>>
>>>       
>>>> 2) SORT:
>>>> I would like to sort my lister at the first display on one of my database field. Fox example, fe_users table.
>>>> So, I have add an ORDER BY in my sql:
>>>> <datasource:DB name="fe_users">
>>>>   <sql><![CDATA[
>>>>     SELECT
>>>>       fe_users.username AS username
>>>>     FROM
>>>>       fe_users 
>>>>     WHERE 1
>>>>     ORDER BY fe_users.username
>>>>   ]]></sql>
>>>> </datasource:DB>
>>>> And it works. But the problem is that if I sort my lister by clicking on the column I have and
>>>> sql error because my request looks like this:
>>>> SELECT SQL_CALC_FOUND_ROWS 
>>>>   fe_users.username AS username
>>>> FROM
>>>>   fe_users 
>>>> WHERE 1
>>>> ORDER BY fe_users.username
>>>> ORDER BY  username ASC  LIMIT 0, 20
>>>> How can I do ?
>>>>         
>>> You can use something like:
>>> <renderlet:LISTER ...>
>>>    ...
>>>    <pager>
>>>       <sort column="username" direction="desc" />
>>>    </pager>
>>> </renderlet:LISTER>
>>>
>>> See an example at:
>>> http://formidable.typo3.ug/pastebin/snippet/45.html
>>>
>>>       
>>>> 3) RENDERLET DATE:
>>>> In my renderlet lister I want to display the starttime field of the table fe_users.
>>>> So I have done:
>>>> <column name="starttime" type="renderlet:DATE" listHeader="Date" label="Date" sort="true">
>>>>   <data>  
>>>>     <datetime format="%d %B %Y" />  
>>>>   </data>  
>>>> </column>
>>>> But it's not written like "DD/MM/AAAA" but "1216211380" (for example).
>>>> What's the problem in my code ?
>>>>         
>>> It works for me with table pages, my XML is:
>>> <column name="crdate" type="renderlet:DATE" listHeader="crdate">
>>>    <data>
>>>       <datetime format="%d %B %Y" />
>>>    </data>
>>> </column>
>>>
>>> I don't find any problem in your code.
>>>
>>>
>>> Best regards,
>>>    Rego
>>>
>>>       
>> -- 
>>
>>
>> *Jérôme Schneider*
>> /Developer/
>> /Formidable - Rapid Application Developpement Framework for Typo3
>> <http://formidable.typo3.ug>/
>> /Ameos <http://www.ameos.com>/
>> _______________________________________________
>> TYPO3-project-formidable mailing list
>> TYPO3-project-formidable at lists.netfielders.de
>> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-project-formidable
>>     
>
> _________________________________________________________________
> Pendant tout l'été, consultez vos emails Hotmail sur votre mobile !
> http://www.messengersurvotremobile.com/?d=hotmail


-- 

*Luc Muller*
/Web Developper/
/Formidable - Rapid Application Developpement Framework for Typo3 
<http://formidable.typo3.ug>/
/Typo3 Ameos <http://www.ameos.com>/