Re: SQL
Re: SQL
- Subject: Re: SQL
- From: Ron X <email@hidden>
- Date: Fri, 13 Apr 2012 11:19:15 +0300
@Override
public WOActionResults defaultAction() {
NSArray<Chart> result = EOUtilities.rawRowsForSQL(session().defaultEditingContext(), Chart.ENTITY_NAME, "SELECT count(*), sum(size)");
return pageWithName(Main.class);
}
ERROR 47.15 MB used/33.91 MB free [WorkerThread0] (ERD2WDirectAction.java:480) (Error) - Error with action default:com.webobjects.eoaccess.EOObjectNotAvailableException: databaseContextForModelNamed: cannot find model named Chart associated with this EOEditingContext, formValues:{}
EOObjectNotAvailableException: databaseContextForModelNamed: cannot find model named Chart associated with this EOEditingContext
at com.webobjects.eoaccess.EOUtilities.databaseContextForModelNamed(EOUtilities.java:812)
at com.webobjects.eoaccess.EOUtilities.rawRowsForSQL(EOUtilities.java:585)
at com.webobjects.eoaccess.EOUtilities.rawRowsForSQL(EOUtilities.java:561)
at com.legalsounds.DirectAction.defaultAction(DirectAction.java:34)
... skipped 4 stack elements
at com.webobjects.appserver.WODirectAction.performActionNamed(WODirectAction.java:144)
at er.extensions.appserver.ERXDirectAction.performActionNamed(ERXDirectAction.java:401)
at er.directtoweb.ERD2WDirectAction.performActionNamed(ERD2WDirectAction.java:463)
at com.ronx.DirectAction.performActionNamed(DirectAction.java:88)
... skipped 9 stack elements
i don't understand what does this exception mean
12 апреля 2012 г. 17:24 пользователь John Huss
<email@hidden> написал:
EOUtilities.rawRowsForSQL
2012/4/12 Ron X
<email@hidden>
but how can i do COUNT() and SUM() in ONE query?
aggregateFunctionWithQualifier - name of the function - just one (count/sum), but i need two (count & sum)
11 апреля 2012 г. 19:17 пользователь Ramsey Gurley
<email@hidden> написал:
ERXEOControlUtilities.aggregateFunctionWithQualifier
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (
email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to
email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
- Follow-Ups:
- Re: SQL
- From: Henrique Gomes <email@hidden>
| References: | |
| | >SQL (From: Ron X <email@hidden>) |
| | >Re: SQL (From: David LeBer <email@hidden>) |
| | >Re: SQL (From: Ron X <email@hidden>) |
| | >Re: SQL (From: Ramsey Gurley <email@hidden>) |
| | >Re: SQL (From: Ron X <email@hidden>) |
| | >Re: SQL (From: John Huss <email@hidden>) |