Re: ERXBatchingDisplayGroup - qualifier variable '$acctId' is unbound
Re: ERXBatchingDisplayGroup - qualifier variable '$acctId' is unbound
- Subject: Re: ERXBatchingDisplayGroup - qualifier variable '$acctId' is unbound
- From: Baiss Eric Magnusson <email@hidden>
- Date: Mon, 22 Mar 2010 08:42:52 -0700
By removing fetch on load I was able to catch the problem, but I don't know how to fix it.
It works with both WODisplayGroup and ERXDisplayGroup and if I code around the problem it occurs on another WODisplayGroup on another page.
Whatever practice I am using that is flagged as an error I am using a LOT of times on a LOT of pages.
Caused by: com.webobjects.foundation.NSForwardException [java.lang.IllegalStateException] sqlStringForKeyValueQualifier:
attempt to generate SQL for com.webobjects.eocontrol.EOKeyValueQualifier (acctId = $acctId) failed because the qualifier variable '$acctId' is unbound.
at com.webobjects.jdbcadaptor.FrontbasePlugIn$FrontbaseExpression.sqlStringForKeyValueQualifier(FrontbasePlugIn.java:1351)
...
at com.webobjects.eoaccess.EOQualifierSQLGeneration$_KeyValueQualifierSupport.sqlStringForSQLExpression(EOQualifierSQLGeneration.java:463)
at er.extensions.ERXExtensions$KeyValueQualifierSQLGenerationSupport.sqlStringForSQLExpression(ERXExtensions.java:312)
at com.webobjects.eoaccess.EOQualifierSQLGeneration$Support._sqlStringForSQLExpression(EOQualifierSQLGeneration.java:165)
at com.webobjects.eoaccess.EOSQLExpression.prepareSelectExpressionWithAttributes(EOSQLExpression.java:997)
at com.webobjects.jdbcadaptor.JDBCExpression.prepareSelectExpressionWithAttributes(JDBCExpression.java:146)
at com.webobjects.eoaccess.EOSQLExpressionFactory.selectStatementForAttributes(EOSQLExpressionFactory.java:225)
at er.extensions.jdbc.ERXSQLHelper.sqlExpressionForFetchSpecification(ERXSQLHelper.java:635)
at er.extensions.jdbc.ERXSQLHelper.sqlExpressionForFetchSpecification(ERXSQLHelper.java:569)
at er.extensions.jdbc.ERXSQLHelper.rowCountForFetchSpecification(ERXSQLHelper.java:1110)
at er.extensions.eof.ERXEOAccessUtilities.rowCountForFetchSpecification(ERXEOAccessUtilities.java:428)
at er.extensions.batching.ERXBatchingDisplayGroup.rowCount(ERXBatchingDisplayGroup.java:279)
at er.extensions.batching.ERXBatchingDisplayGroup.refetch(ERXBatchingDisplayGroup.java:384)
at er.extensions.batching.ERXBatchingDisplayGroup.fetch(ERXBatchingDisplayGroup.java:460)
at com.webobjects.appserver.WODisplayGroup.qualifyDataSource(WODisplayGroup.java:2455)
at Components.CurrentSit.<init>(CurrentSit.java:65) ... 45 more
> On Mar 18, 2010, at 6:20 PM, Chuck Hill wrote:
> Yes. And it has been done and it is called ERXBatchingDisplayGroup. :-)
>
Now <acctId> is a foreign key to the <owner>.
And I could do <owner.accounts()> and get what I want except unsorted.
----
Baiss Eric Magnusson
http://www.CascadeWebDesign.com
_______________________________________________
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