[TYPO3-english] Problem with ORDER BY

Markus Klein klein.t3 at mfc-linz.at
Fri Mar 30 11:43:57 CEST 2012


Hi Morten,

and that solution is?
It would be nice if you always post the solutions too. (for the ensuing ages :-))

Thanks
Markus

> -----Original Message-----
> From: typo3-english-bounces at lists.typo3.org [mailto:typo3-english-bounces at lists.typo3.org] On Behalf Of Morten Hagh
> Sent: Friday, March 30, 2012 9:52 AM
> To: TYPO3-english at lists.typo3.org
> Subject: Re: [TYPO3-english] Problem with ORDER BY
> 
> 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
> 
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english



More information about the TYPO3-english mailing list