Thanks Mark!
I was thinking on using views, but I'd have to duplicate the text fields I want to sort by, with a small case version... :( Oh, well, Thanks for your great software! Pedro. On Aug 12, 11:49 pm, Mark Mandel <[email protected]> wrote: > 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 <[email protected]> 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: [email protected] > 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
