Also make sure that the query is exactly what you want/expect by printing it in tg-admin:
print Vt1.select(orderBy=(Vt1.q.vesselname)) -Ian On 4/12/07, Andrew Grover <[EMAIL PROTECTED]> wrote: > > On 4/12/07, DarkBlue <[EMAIL PROTECTED]> wrote: > > Firebird 2.0 > > If I use following query > > dshp = Vt1.select(orderBy=(Vt1.q.vesselname)) > > for ve in dshp: > > print ve.vesselname > > The output maybe something like: > > > > MV. CSHIP > > MV. DSHIP > > MV. ZSHIP > > MV. ASHIP > > MV. GSHIP > > > > Obviously the orderBy clause is ignored. > [..] > > Am I doing something wrong or is SO flawed ? > > The database is responsible for sorting the returned items. Could > there be extra spaces or encoding issues that are causing Firebird to > not sort the way you want? > > Turning on database debug statements may also shed some light. > > Regards -- Andy > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [EMAIL PROTECTED] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
