[TYPO3-english] Problem with ORDER BY

[Morten Hagh]

Hi Francois,

Thanks for your answer! I found a solution where I used the standard TYPO3
DB stuff in that function and that works as intended! :)


/Morten Hagh

-----Oprindelig meddelelse-----
Fra: typo3-english-bounces at lists.typo3.org
[mailto:typo3-english-bounces at lists.typo3.org] På vegne af François Suter
Sendt: 30. marts 2012 09:37
Til: typo3-english at lists.typo3.org
Emne: Re: [TYPO3-english] Problem with ORDER BY

Hi Morten,

> I am using the tx_overlays extension and I select the product / prices
with:
>
> $prices = tx_overlays::getAllRecordsForTable('*', 'tx_rttag_tagsten',
> '', '', 'price');

With "overlays" I tried to provide a library that helps with handling
language and version overlays in TYPO3, but it doesn't do everything
either, unfortunately. Sorting is obviously very difficult, since you
can't sort the translation right from the database (because you're
actually fetching the default language and overlaying it afterwards).

There's no easy solution. In this case I would advise you to implement
your own sorting function after the call to "overlays", when not in
default language.

HTH