[TYPO3-english] ext_tables.php - Order by

rovell74 rovell74 at gmail.com
Fri Aug 10 20:09:26 CEST 2012


Hi

I have a problem with an ext_tables.php file that look like this

<?php
if (!defined ('TYPO3_MODE')) {
        die ('Access denied.');
}
$tempColumns = array (
       'tx_home_adress' => array (
                       'exclude' => 1,
                        'label' => '..........'
                        'config' => array (
                                'type' => 'select',
                                'foreign_table' => 'user_home_adress',
                                'foreign_table_where' => 'AND
user_home_adress.hidden=0  AND user_home_adress.deleted=0 AND
user_home_adress.pid=70 ORDER BY user_home_adress.nome ASC',
                                'size' => 1,
                                'minitems' => 0,
                                'maxitems' => 6,
                                'renderMode' => 'checkbox',
                                )

        ),
....

I've logged mysql and i see that the query for the select is without order
by

  select *  from user_home_adress where 1=1 AND user_home_adress.hidden=0
AND user_home_adress.deleted=0 AND user_home_adress.pid=70

How can i fix this problem?

Thanks a lot
Francesco


More information about the TYPO3-english mailing list