Hi all,
Does anyone know why I can't build an arbitrarily complex qualifier
with EOF?
The following code
CCGGregorianCalendar now = new CCGGregorianCalendar();
now.setMonth(now.getMonth() + 3);
args.addObject(now.timestamp());
args.addObject(new NSTimestamp());
String qualString = "(POW((69.1 * ( location.longitude - " +
zipCode.longitude()
+ " ) * cos( " + zipCode.latitude() +
" / 57.3)), 2) + "
+ "POW((69.1 * ( location.latitude -
" + zipCode.latitude()
+ ")), 2)) < "
+ _selectedMileageOption.intValue() *
_selectedMileageOption.intValue()
+ " and bidCloseDate <= %@ and
bidCloseDate > %@";
EOQualifier qual = EOQualifier.qualifierWithQualifierFormat
(qualString, args);
Produces
[2007-07-04 14:52:56 EDT] <WorkerThread6>
com.webobjects.foundation.NSForwardException for
com.webobjects.eocontrol._private.ParseException: Encountered "(" at
line 1, column 5.
Was expecting one of:
<IDENTIFIER> ...
<ARGUMENT_PATH> ...
"=" ...
">=" ...
"<=" ...
"=<" ...
"<>" ...
"!=" ...
"=>" ...
">" ...
"<" ...
at
com.webobjects.eocontrol._private._EOQualifierParser.generateParseExcept
ion(_EOQualifierParser.java:1044)
at
com.webobjects.eocontrol._private._EOQualifierParser.jj_consume_token
(_EOQualifierParser.java:980)
at
com.webobjects.eocontrol._private._EOQualifierParser.parseOperatorList
(_EOQualifierParser.java:562)
at
com.webobjects.eocontrol._private._EOQualifierParser.RelOpExpression
(_EOQualifierParser.java:638)
at com.webobjects.eocontrol._private._EOQualifierParser.Expression
(_EOQualifierParser.java:594)
at
com.webobjects.eocontrol._private._EOQualifierParser.parseLogicalExpress
ion(_EOQualifierParser.java:872)
at
com.webobjects.eocontrol._private._EOQualifierParser.ParenExpression
(_EOQualifierParser.java:616)
at com.webobjects.eocontrol._private._EOQualifierParser.Expression
(_EOQualifierParser.java:598)
at
com.webobjects.eocontrol._private._EOQualifierParser.parseLogicalExpress
ion(_EOQualifierParser.java:872)
at com.webobjects.eocontrol.EOQualifier.qualifierWithQualifierFormat
(EOQualifier.java:941)
...
Do I just give up here and fetch raw rows with a pre-build SQL
string, and then use the PK to fetch in the EO when I need it? It's
seems super lame to me that EOQualifier can't parse something with
parentheses, but maybe I'm missing something obvious.
Mark
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
