Re: EOAndQualifier order

2007-07-11 Thread Q
On 12/07/2007, at 3:03 PM, Sam Barnum wrote: I seem to recall reading something similar on the mysql lists. I am quite certain that the order of the fields in an index is critical, particularaly if you're sorting or grouping results. Just got done optimizing some queries, so I'll just pas

Re: EOAttribute.validateValue question

2007-07-11 Thread Sam Barnum
And if you're considering rolling your own CSV parser, I'd recommend using this instead: http://opencsv.sourceforge.net/ It handles the escaping of quotes correctly, and commas inside quoted values. I've had good luck with it, except from a client who can't seem to reliably generate a cor

Re: EOAndQualifier order

2007-07-11 Thread Chuck Hill
Yes, the order of fields in an index is critical to optimization. But we are getting away from the original issue which was EOF generating SELECT * FROM foo WHERE firstName='Bob' AND lastName='Smith' when Miguel was expecting: SELECT * FROM foo WHERE lastName='Smith' AND firstName='Bob' I wou

Re: EOAndQualifier order

2007-07-11 Thread Sam Barnum
I seem to recall reading something similar on the mysql lists. I am quite certain that the order of the fields in an index is critical, particularaly if you're sorting or grouping results. Just got done optimizing some queries, so I'll just paste some notes in here: When a query includes a

Re: EOAttribute.validateValue question

2007-07-11 Thread Kieran Kelleher
Chuck/Francis, This is one approach I had been considering, so since you are both right, I'll now definitely choose that approach! I just needed to make sure I was not missing some more generic elegant way in eof. I already have a DataMapping helper class that maps between target eo

Re: EOAttribute.validateValue question

2007-07-11 Thread Chuck Hill
On Jul 11, 2007, at 7:50 PM, Kieran Kelleher wrote: Chuck/Francis, This is one approach I had been considering, so since you are both right, I'll now definitely choose that approach! I just needed to make sure I was not missing some more generic elegant way in eof. I already have a

Re: EOAttribute.validateValue question

2007-07-11 Thread Chuck Hill
On Jul 11, 2007, at 5:35 PM, Francis Labrie wrote: Hi, Kieran Kelleher wrote: As we know this EOAttribute.validateValue(...) gets called before custom eo validate methods and it uses the class description to validate and/or do basic conversion. What are the alternatives to find an elegan

Re: EOAttribute.validateValue question

2007-07-11 Thread Francis Labrie
Hi, Kieran Kelleher wrote: As we know this EOAttribute.validateValue(...) gets called before custom eo validate methods and it uses the class description to validate and/or do basic conversion. What are the alternatives to find an elegant way to call my custom validate first or is there n

Re: EOAndQualifier order

2007-07-11 Thread Q
On 12/07/2007, at 7:29 AM, Miguel Arroz wrote: Hi! I'm looking and the generated SQL from an EOAndQualifier, and it looks like the order of the "anded" stuff is the inverse one I write on the code. If I write a qualifier like "bananas = %@ and apples = %@ and oranges = %@", the generat

EOAttribute.validateValue question

2007-07-11 Thread Kieran Kelleher
Hi All, (quiet list last 2 days?) As we know this EOAttribute.validateValue(...) gets called before custom eo validate methods and it uses the class description to validate and/or do basic conversion. What are the alternatives to find an elegant way to call my custom validate first or is

Re: EOAndQualifier order

2007-07-11 Thread Chuck Hill
On Jul 11, 2007, at 4:27 PM, Francis Labrie wrote: Hi Miguel! Miguel Arroz wrote: I'm looking and the generated SQL from an EOAndQualifier, and it looks like the order of the "anded" stuff is the inverse one I write on the code. If I write a qualifier like "bananas = %@ and apples = %

Re: EOAndQualifier order

2007-07-11 Thread Francis Labrie
Hi Miguel! Miguel Arroz wrote: I'm looking and the generated SQL from an EOAndQualifier, and it looks like the order of the "anded" stuff is the inverse one I write on the code. If I write a qualifier like "bananas = %@ and apples = %@ and oranges = %@", the generated SQL will be the r

Re: Model Cloning

2007-07-11 Thread Chuck Hill
On Jul 11, 2007, at 3:18 PM, Andrew Lindesay wrote: Hello; I'm doing; 1) fully-load model A 2) set the JDBC config for model A 3) re-load clone model into a new EOModel called B from A's URL 4) rename B's entities and the model with a suffix "RO". 5) ma

Model Cloning

2007-07-11 Thread Andrew Lindesay
Hello; I'm doing; 1) fully-load model A 2) set the JDBC config for model A 3) re-load clone model into a new EOModel called B from A's URL 4) rename B's entities and the model with a suffix "RO". 5) make B's entities read-only 6) insert B into the

Re: EOAndQualifier order

2007-07-11 Thread Robert Walker
Miguel, Yes, it can make a difference and it's not just PostgreSQL that's affected. I recently did some testing with MySQL. I had a case where I had an index spanning three fields. I found that it made a huge difference which field was at the beginning of the index due to string compar

EOAndQualifier order

2007-07-11 Thread Miguel Arroz
Hi! I'm looking and the generated SQL from an EOAndQualifier, and it looks like the order of the "anded" stuff is the inverse one I write on the code. If I write a qualifier like "bananas = %@ and apples = % @ and oranges = %@", the generated SQL will be the reverse (t0.oranges = (...) A

Re: WOBuilder bug?

2007-07-11 Thread John Larson
Thanks Simon, I tried cleaning eveything and restarting Eclipse to no avail. I looked at my build path and everything looked fine, and the app ran and debugged fine so I assume it was "really" okay. The error was coming from the builder module, so I assumed it was a builder problem. I t

Re: WOBuilder bug?

2007-07-11 Thread Simon McLean
These kind of errors are normally build-path related. Try cleaning all your projects and an Eclipse reboot won't hurt (I believe Eclipse only loads the classpath at boot and doesn't pick up any changes to it thereafter). As a last resort I would edit your build path and just shuffle the o

WOBuilder bug?

2007-07-11 Thread John Larson
Mike, I wanted to remember that you were the contact on WOBuilder for Eclipse. If I'm wrong, let me know and I'll pass this along to the right person. First, I can't thank you all for all the work you do with Wonder and Eclipse. I wish I had enough talent to contribute too. In my workp

Re: future of wocode.com

2007-07-11 Thread Gordon Belray
Hi Simon, I've written to James O'Loughlin but haven't heard anything back yet. Perhaps you can contact him as well with the offer. thanks, Gordon On 11-Jul-07, at 10:14 AM, Simon McLean wrote: My vote would be for it's content to be transferred into the wiki. How about a "sample code" se

Re: WOWODC recording

2007-07-11 Thread Ken Anderson
I'm hopeful as well! On Jul 11, 2007, at 9:06 AM, Johann Werner wrote: Hi Pascal, did you got to check the recordings? I think a lot of us on the list are eagerly waiting for any (good?) news on them. jw Am 15.06.2007 um 20:05 schrieb Pascal Robert: Hi, a lot of people wants to know wh

Re: future of wocode.com

2007-07-11 Thread Simon McLean
My vote would be for it's content to be transferred into the wiki. How about a "sample code" section on the wiki ? (the wiki being the object style hosted one) I'll volunteer some man hours to shift the content across - we would need the wocode administrator to get the site running again to

Re: WOWODC recording

2007-07-11 Thread Johann Werner
Hi Pascal, did you got to check the recordings? I think a lot of us on the list are eagerly waiting for any (good?) news on them. jw Am 15.06.2007 um 20:05 schrieb Pascal Robert: Hi, a lot of people wants to know what's the deal with the WOWODC recording. Like Chuck said a couple of da

future of wocode.com

2007-07-11 Thread Gordon Belray
Hi, does anyone know if there are plans for wocode.com beyond its current moribund state? I see mention of it on the Announced Initiatives on the wiki but it would be good if it was available again. cheers, Gordon Gordon Belray Information Architect and Imaging System Manager Information T