if multiple records have the same sequenceId then a sort of those will be returned as a group ie
blue = 2 black = 1 pink = 3 brown = 1 purple = 3 orange = 2 navy = 1 lime = 3 red = 2 will return Black Brown Navy Blue Orange Red Pink Purple Lime --- "Alex D. Fleming" <[EMAIL PROTECTED]> wrote: > Thx for the reply Chris. > But sometime its been seen that all the sequence no > are set to only 1 or any > single value. > Is that wrong data or something else ?? > > BTW your explaination was very nice. > > On 11/11/06, Chris Howe <[EMAIL PROTECTED]> > wrote: > > > > It allows a way to sort the results of a query so > that > > they are returned in an order that is beneficial. > > > > For instance, if you had a list: > > Low > > Medium > > High > > > > and had no sequenceId > > > > the only way you could sort them would be by: > > alphabetical order - High, Low, Medium or Medium, > > Low, High > > > > and > > > > character Length order - Low, High, Medium or > Medium, > > High, Low > > > > entering a sequence gives you: > > Low - 1 > > Medium - 2 > > High - 3 > > lets you sort by 1,2,3 or 3,2,1 which results in > Low, > > Medium, High or High, Low, Medium this is an order > > that makes sense. > > > > --- "Alex D. Fleming" <[EMAIL PROTECTED]> > > wrote: > > > > > Hi, > > > > > > What is the significance of SequenceId field in > the > > > database ?? > > > Like we use 1,2,5 and other values for sequence > > > field. > > > For example see in the Catalog --> Store --> > OFBiz > > > E-Commerce Store [9000] > > > -- > Promos > > > > > > -- > > > Regards > > > Alex D. Fleming > > > > > > > > > > -- > Regards > Alex D. Fleming >
