• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
RE: DisplayGroup/ERXFlickrBatchNavigation question
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: DisplayGroup/ERXFlickrBatchNavigation question

  • Subject: RE: DisplayGroup/ERXFlickrBatchNavigation question
  • From: "Andrew R. Kinnie" <email@hidden>
  • Date: Mon, 28 Dec 2009 11:13:13 -0500
I forgot to mention . . . The rows populated the displayGroup are from two possible paths, so there are 55 total rows matching, of which 23 are distinct.

So we have a batching displayGroup with batches of 20, and the navigation displays 3 pages for 55 matches, but the repetition which is populated by the displayedObjects shows 12 objects on the first page . . .  If I set the batch to 100, it shows 23 rows.  

I added fs.setUsesDistinct(true); to the method creating the displayGroup and got the following error as soon as I clicked "search":

Dec 28 11:06:00 MyApp[54258] (ERXNSLogLog4jBridge.java:46) DEBUG NSLog  -  === Rollback Internal Transaction
Dec 28 11:06:00 MyApp[54258] (ERXNSLogLog4jBridge.java:43) WARN  NSLog  - <er.ajax.AjaxRequestHandler>: Exception occurred while handling request:
ORA-01791: not a SELECTed _expression_
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:785)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:860)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3482)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1085)
at com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:265)
at com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:337)
at com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:296)
at com.webobjects.eoaccess.EODatabaseContext._fetchRawRowKeyPaths(EODatabaseContext.java:2965)
at com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3036)
at com.webobjects.eoaccess.EODatabaseContext.objectsWithFetchSpecification(EODatabaseContext.java:3195)
at com.webobjects.eocontrol.EOObjectStoreCoordinator.objectsWithFetchSpecification(EOObjectStoreCoordinator.java:488)
at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4069)
at er.extensions.eof.ERXEC.objectsWithFetchSpecification(ERXEC.java:1211)
at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4444)
at er.extensions.eof.ERXEOControlUtilities.primaryKeyValuesInRange(ERXEOControlUtilities.java:580)
at er.extensions.batching.ERXBatchingDisplayGroup.objectsInRange(ERXBatchingDisplayGroup.java:353)
at er.extensions.batching.ERXBatchingDisplayGroup.refetch(ERXBatchingDisplayGroup.java:421)
at er.extensions.batching.ERXBatchingDisplayGroup.fetch(ERXBatchingDisplayGroup.java:473)
. . . 
 _______________________________________________
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
  • Prev by Date: DisplayGroup/ERXFlickrBatchNavigation question
  • Next by Date: RE: DisplayGroup/ERXFlickrBatchNavigation question - Wonder bug?
  • Previous by thread: DisplayGroup/ERXFlickrBatchNavigation question
  • Next by thread: RE: DisplayGroup/ERXFlickrBatchNavigation question - Wonder bug?
  • Index(es):
    • Date
    • Thread