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 protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
