Oops! I should've checked previous posts carefully. I saw that you have a feature request in that sense... Can I help? I'd really like to see this implemented.
Pedro. On Apr 21, 2:03 am, pedrobl <[email protected]> wrote: > Hi all, > > First thing, the system: Coldfusion MX7, Oracle 10g, transfer 1.1. I > need searches not to be case sensitive. I've tried to walk around this > issue with different approaches, but each had its problems: > > - Changing the NLS settings in oracle. The problem: the data model > needs too many extra indices. Also, it turns out that setting the > session parameters to oracle's jdbc connection can have unexpected > results. > - Creating views in oracle with extra lower(columns) and extra > properties in their respective transfer objects. The problem: the data > model gets messy soon. > > I thought that it may be easier using transfer to solve the issue. The > idea is that, when translating from TQL to SQL using the LIKE > function, the column could be translated to 'LOWER(column_name)', > instead of just 'column_name', and searching for lcase('%query%'), > instead of just '%query%'. > > I've had a look at transfer's source code, as well as ANTLR and a hint > as to where to look would be greatly appreciated... or any other ideas > for that matter. Could I modify "conditionBasicClause" and the "like" > "OPERATOR" in the Tql.g file? I guess I probably should modify the SQL > part, not the TQL part... > > Thanks in advance, > > Pedro. -- Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer Try out the new Transfer ORM Custom Google Search: http://www.google.com/cse/home?cx=002375903941309441958:2s7wbd5ocb8 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
