OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Order Problem

From: Neil Tompkins (neildtompkinshotmail.com)
Date: Wed May 07 2008 - 12:24:36 CDT

Hi All,
 
I've the following query :SELECT ProductID FROM Products WHERE Enabled= ' Yes' AND ProductID IN(varProductID)
 
This query works fine. However the query result is in a different order to what I passed in varProductID.
 
How can I order the results based on my list like
 
varProductID = "1000,2500,1500"
 
At the moment the result is
 
1000
1500
2500
 
But I want
 
1000
2500
1500
 
Thanks,
Neil
 
 
_________________________________________________________________

Discover and Win with Live Search

http://clk.atdmt.com/UKM/go/msnnkmgl0010000007ukm/direct/01/