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
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
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
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
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
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
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
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
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
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
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 = %
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
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
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
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
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
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
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
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
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
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
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
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
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
24 matches
Mail list logo