[TYPO3-project-formidable] Formidable questions
Jerome Schneider
typo3dev at ameos.com
Wed Jul 23 09:52:46 CEST 2008
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>/
More information about the TYPO3-project-formidable
mailing list