Which database are you using ?
Jacques
From: "Roberto Cosenza" <[EMAIL PROTECTED]>
Well...it just doesn't!
Altough I could speculate on why it doesn't, it will not help me. It
would be easier to instruct ofbiz not to use upper.
Or maybe the correct approach is not to use the "performFind" (which
would make my work harder...) ?
Thanks for any suggestions
/r
On Mar 13, 2008, at 3:57 PM, Adrian Crum wrote:
It would be preferable to do some research to find out why your
database doesn't support the SQL UPPER function.
OFBiz generates generic ANSI SQL, so usually if you run into
problems it's because the database or the JDBC driver is not
compliant.
-Adrian
Roberto Cosenza wrote:
Hi.
Could you please give me a pointer in how to customize the
generated sql code?
I'm for instance using a "performFind" service call which generates
some sql which is not valid for my database (in this specific case
it uses "UPPER" to convert the search string into uppercase)
Regards
/Roberto
