IN () and ORDER by IN ()

[miguel11]

is it possible order by IN, how can I do it? each time I try this way, the order

is ascendent and ordered by items_id, I want It keeps the items_id_list order,
any idea?

"SELECT * FROM items WHERE items_id IN (" & items_ID_List & &quot ORDER BY IN (" &

items_ID_List & &quot"


thanks in advance

Miguel

 

[karluk]

Can you write a function to generate a sort sequence number, and then order by the sort sequence number?

create function items_id_list_order
{
logic to generate sort order here
}

SELECT *,items_id_list_order(items_id) as sort_order FROM items
WHERE items_id IN (" & items_ID_List & &quot
ORDER BY sort_order

 

[miguel11]

thanks for your idea and your time
working on it!! right now
thanks
Miguel