Eeep! Sounds like you are going to have to use some regular SQL for that one.
Mark On Thu, Aug 13, 2009 at 12:20 AM, pedrobl <pe...@bezunartea.net> wrote: > > > Hi! > > I'm using transfer with Oracle as the data backend, and I've come > across an annoying problem when sorting. I have a few text fields > defined in a table, and I'd like to sort by those fields but with case > in-sensitivity. An example: > > Current order: > MARS ATTACKS > MORE DATA > Mars attacks > man on the moon > > Desired order: > man on the moon > MARS ATTACKS > Mars attacks > MORE DATA > > Usually this is accomplished by issuing an ORDER BY LOWER(title) in > SQL, but that's not available in TQL > > Any ideas, recommendations. I can solve this by adding a view, but > it'd be perfect if transfer has something available on this. > > TIA, > > Pedro. > > > > -- E: mark.man...@gmail.com T: http://www.twitter.com/neurotic W: www.compoundtheory.com --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to transfer-dev@googlegroups.com To unsubscribe from this group, send email to transfer-dev-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---