[TYPO3-dev] flexform config type select itemsProcFunc

[Peter Russ]

--- Original Nachricht ---
Absender:   Steffen Kamper
Datum:       16.02.2009 18:43:
> Hi,
> 
> Peter Russ schrieb:
>> May be that there is a solution that I don't know for now:
>>
>> Due to the fact that there is no method in flexform (TCA?) to make use 
>> of a field value to query values for an other field (i.e. can not use
>> <foreign_table_where>whereField={FIELD:myfield}</foreign_table_where>)
>> I have to use itemsProcFunc.
>>
>>
>> So far so good. BUT: I can't figure out a way how to preserve the 
>> order of the selected records.
>>
>> Example:
>> List of Uids: 1,2,3,4,5,6
>> Selected: 4,2,5,6
>>
>> Now I want to display the records in the same order as in selected. 
>> From FF I can receive the selected items and query using
>> 'where uid in (4,2,5,6)' but the order gets lost.
>>
>> Any idea or trick how to get records in the same order as in a 
>> selected item list?
>>
>> Thanks in advance.
>>
>> Please ask if my decription is not clear to you!!!
>>
>> Peter.
>>
>>
>>
> 
> 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.

-- 
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