[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