ordering by an int has strange behaviour...

[Aaron Vegh]

Hi there,
I've got a database table where I want to order items by an arbitrary
index called sortorder, which is an int.

When I run the standard query to output the rows and sort by
sortorder, I get some strange results: instead of sorting 1, 2, 3,
etc., it sorts 1, 10, 11, 12, 1, 2, 3, etc. -- it's a 12-item list in
this case.

Any idea why this might be happening? I'm not sure what code to include for you.

Thanks,
Aaron.

[Joel]

Hi Aaron,

in your object class, find the function

CompareXXXBySortOrder

change the function from
return strcmp(strtolower($xxx1->sortOrder),
strtolower($xxx2->sortOrder));

to

return ($service1->sortOrder > $service2->sortOrder);

This is one of the issues right now that occur because the object
doesn't have an internal knowledge of the types of its attributes, but
since 1.6 has this attribute=>type map, this should not occur in 1.6.

Hope this helps
joel

[Joel]

return ($service1->sortOrder > $service2->sortOrder);

should read the following instead. sorry for the typo

return ($xxx1->sortOrder > $xxx2->sortOrder);

[Aaron Vegh]

Awesome, awesome awesome! That worked Joel, thanks very much!

Yet another reason (did we need one?) to look forward to 1.6. I'll be
one of your guinea pigs, no worries. :-)

Cheers,
Aaron.