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

 

[Quehay]

The IN is a test for membership--you can't sort on the test function. If you use

ORDER BY [items_id]

you'll get what you want--items id is the field that will hold the results returned from the test.

O sea que una vez determinada la lista, despues de la prueba "IN," puedes ordenarla por medio de ORDER BY los resultados :-}

 

[miguel11]

gracias por tu consejo quehay pero lo que yo deseo es
mantener el orden de la cadena items_id_list, o sea que si
en la cadena esta 3,9,1,13 el orden del recordset sea el mismo o sea primero el 3, segundo el 9 y asi.
Aun trabajando en ello
Miguel

 

[Quehay]

What determines the original order? Is there a date of entry or something similar? If the order of the items is meaningful there must be a way of indicating their sequence, even if that means putting a "TimeEntered" field in the table with a default value of Now().