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
