Hello,

As far as I know QCubed does currently not allow that so easily. There are two things you can do, though:

Add a field in your database that holds the name upper case, add an update/insert trigger that keeps the field up to date, and use that for querying (Don't forget to rerun the codegen). Ugly but works.

If you don't like that idea you could e.g. add a comparison operator ULIKE in includes/qcubed/_core/framework/QQuery.class.php or allow passing a function into QQ:Like which Like will apply to the field. However, that would be a rather deep intrusion into the framework. Tell me if you need assistance with that.

I'd be happy to hear other suggestions as this is a quite common issue.

Cheers

Helge

thanx for your reply, but this doesn't help me much. It shouldn't be too difficult implementing this in the framework, and my current project doesn't need uppercase or something similar, but i hope this and similar options will be implemented in future versions as soon as possible.
Also, the SUM can't be used for great effect with QQuery. You can only get the sum value through the GetVirtualAttribute() function, as far as I know. You can't calculate ie SUM(field)*SUM(field2)...

I encourage you to explore SQL sub-clauses for QQuery, these might help.

If you find them insufficient, I welcome you to create a patch for the core framework that implements your desired functionality. Remember that QCubed is an open source framework - we are all busy engineers working on our own projects; nobody knows your requirements better than you. We of course can help with advice in the process.

ok. if i'll be needing extra functionality at some point i'll look into the source code and if i add some functionality i'll let u know. if i make any changes i'll contact you alex94040.