[transfer-dev] Keys with mismatched datatype

Hello, I was in the process of retrofitting Transfer ORM to a set of existing tables. There was a onetomany link in the query and the system ran but gave the following error. SQLState: 42000 ErrorCode: 907 Position: 792 Error: ORA-01790: expression must have same datatype as corresponding

[transfer-dev] Order case sensitivity

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

[transfer-dev] Re: Order case sensitivity

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