[TYPO3-project-formidable] Formidable questions

[Mack Sol]

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