[TYPO3-dev] flexform config type select itemsProcFunc

[Peter Russ]

--- Original Nachricht ---
Absender:   Steffen Kamper
Datum:       16.02.2009 19:26:
> Hi,
> 
>>>
>>> you can use the list for order too
>>>
>>> ORDER BY FIND_IN_SET(uid, '4,2,5,6')
>>>
>>> vg Steffen
>>
>> Thanks Steffen, I'll try.
>>
> 
> the better usage is
> 
> ORDER BY FIELD(uid, '4,2,5,6')

This gives an reversed order: 6,5,2,4
So to fix, you have to quote each uid:
ORDER BY FIELD(uid,'4','2','5','6')
does the job.
Thank you again.

Regs. Peter.

-- 
Fiat lux!
Docendo discimus.
http://www.gidf.de

_____________________________
4Many� Services
uon GbR

XING:	http://www.xing.com/profile/Peter_Russ
	https://www.xing.com/go/invita/360052
	http://www.xing.com/go/privatemessage/Peter_Russ