RE: Order Problem

[Neil Tompkins]

Perfect.  It worked just how I wanted.
 
Thanks for your help.
 
Neil



> Date: Wed, 7 May 2008 19:54:39 +0200> To: neildtompkins@stripped> Subject:
> Re: Order Problem> From: leannonn@stripped> > Hi,> > You should look at
> the `FIND_IN_SET` function here: >
> http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_find-in-set> >
> Your query could look like:> SELECT ProductID FROM Products WHERE Enabled= ' Yes' AND
> ProductID > IN(varProductID) ORDER BY FIND_IN_SET(ProductID, varProductID);> >
> Haven't tested it, though...> > > Take care,> Aleksandar
_________________________________________________________________

Discover and Win with Live Search

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