[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