[TYPO3-dev] TCA question: problem sorting select box in frontend

[JoH asenau]

>>> In ext_tables.php of my extension I edited 'foreign_table_where' for
>>> my custom fields, to order them in the desired way. This works
>>> perfectly in the backend, but when I add the select box to a page in
>>> the frontend, all items are sorted by uid.
>>>
>>> How can I change the order in the frontend?
>>
>> It depends: How do you "add the select box to a page in the
>> frontend"?
>
> Like this:
>
> <!-- ###SUB_INCLUDED_FIELD_myfield### -->
> <dt><label for="tx-srfeuserregister-pi1-myfield">Select:</label></dt>
> <dd>
> <!-- ###SUB_ERROR_FIELD_myfield### -->
> <p
> class="tx-srfeuserregister-pi1-error">###EVAL_ERROR_FIELD_myfield###</p>
> <!-- ###SUB_ERROR_FIELD_myfield### --> <!--
> ###SUB_REQUIRED_FIELD_myfield### --> <p
> class="tx-srfeuserregister-pi1-error">###MISSING_myfield###</p> <!--
> ###SUB_REQUIRED_FIELD_myfield### --> ###TCA_INPUT_myfield###
> </dd>
> <!-- ###SUB_INCLUDED_FIELD_myfield### -->

Well - this doesn't look like "your" extension but like srfeuserregister.
So I guess it depends on how the pi1 is handling ###TCA_INPUT_myfield###.
If there is no foreign_table_where you will have to do something on your
own.

HTH

Joey

-- 
Wenn man keine Ahnung hat: Einfach mal Fresse halten!
(If you have no clues: simply shut your gob sometimes!)
Dieter Nuhr, German comedian
Xing: http://contact.cybercraft.de
Twitter: http://twitter.com/bunnyfield
TYPO3 cookbook (2nd edition): http://www.typo3experts.com