I currently have a table with 'scores' as one of the fields, with the field
type 'double'.
When I go to fetch a row (ordered by scores) and print the scores, they
come back sorted as if they were strings.
I use the following:
rows = db(db.song_table).select(orderby = db.song_table.scores)
for x in rows:
print x.scores
this prints out the following:
-15.0
-16.0
-17.0
-2.0
-20.0
-34.0
0.0
0.0
15.0
2.0
20.0
The scores are ordered as if they were strings, not numbers. However, when
you fetch a score, it is still a float, not a string.
Is this intended behavior, or a bug with field type 'double'?
I am aware that for field type 'integer', the scores are sorted properly,
but I will have decimals in my scores.
--
