[TYPO3-english] Problem with ORDER BY
Morten Hagh
morten at hagh.dk
Thu Mar 29 14:48:12 CEST 2012
Hi list,
I have an extremely weird problem with an ORDER BY and different languages.
I have a table with a list of products and their price(s). I sort them
ascending by price.
When I am in the default language the sorting works without any problems.
But when I am in another language the sorting messes a little bit up as
the prices aren't sorted in the right order.
I am using the tx_overlays extension and I select the product / prices with:
$prices = tx_overlays::getAllRecordsForTable('*', 'tx_rttag_tagsten', '',
'', 'price');
I have two fields with prices (price1 and price2) in the default language
both fields a filled in, but in the other languages only price1 is filled
in. Can that have an effect?
Hope someone is able to help.
/Morten Hagh
More information about the TYPO3-english
mailing list