I have a data object that I'm looking to re-use elsewhere in my project. The original use works fine. It has a dynamic criteria added in the page's onBeforeDataObjectExecuteEvent and goes off without a hitch. So, elsewhere, I grab a handle to it, clear values, clear dynamic criteria, set my new criteria and fire. Problem is I only get one row returned. The log reveals an unrequested restriction of "max rows=1". When I'm processing the results, my debug code confirms this. I do indeed only get one row in my result table. Does anyone know where this restriction is being picked up? The property for max rows in the studio was originally set to 0. I reset it to 100 to see if it would make a difference and it didn't. Here is the pertinent log output. 07/27/99 09:22.26 (134 970001c0 933085346369) [javaCP] (H) CSpZephyr.receiveMessage: 'WEB_EVENT' 07/27/99 09:22.26 (134 970001c1 933085346369) [javaCP] (H) CSpider.connectionStart: 07/27/99 09:22.26 (134 970001c1 933085346379) [javaCP] (H) spider.session.CSpPEZephyr.doGetSession: Session Id=(_sessionIndex=9912,timeStamp=933080797875,lockId=-1,creationTime=9330843 97000), Number of bytes=1765 07/27/99 09:22.26 (134 970001c1 933085346409) [javaCP] (H) illustrate.doDisplayCol.execute: executing 'doDisplayCol' (first row=0, max rows=1, from the BEGINNING). SQL query=|SELECT ALL DISPLAY_COL.COL_CODE, DISPLAY_COL.COL_NAME, DISPLAY_COL.MAND_FL, DISPLAY_COL.DEF_FL, DISPLAY_COL.COL_ORDER, DISPLAY_COL.ILLUS_TYPE_CODE FROM illustrate.DISPLAY_COL DISPLAY_COL WHERE (DISPLAY_COL.ILLUS_TYPE_CODE = 'VA') ORDER BY DISPLAY_COL.COL_ORDER ASC| 07/27/99 09:22.26 (131 970001c1 933085346429) [ndServer] (H) Use existing database connection ORACLEillustrateillustrate 07/27/99 09:22.26 (131 970001c1 933085346429) [ndServer] (H) scrolling cursor capability already disabled 07/27/99 09:22.26 (131 970001c1 933085346439) [ndServer] (H) obtained valid sequential cursor 07/27/99 09:22.26 (131 970001c1 933085346439) [ndServer] (H) aborting transaction 07/27/99 09:22.26 (134 970001c1 933085346449) [javaCP] (H) illustrate.doDisplayCol.execute: 'doDisplayCol' executed SUCCESSFULLY (rows=1) 07/27/99 09:22.26 (134 970001c1 933085346449) [javaCP] (H) illustrate.pgWelcome.numOfRows = 1 07/27/99 09:22.26 (134 970001c1 933085346449) [javaCP] (H) illustrate.pgWelcome.for i = 0 07/27/99 09:22.26 (134 970001c1 933085346449) [javaCP] (H) illustrate.pgWelcome.code/name/man/def = ST_DATE/Date/T/T Thanks Paul Gentile Consultant - Cardinal Group International. Inc. [EMAIL PROTECTED] (508) 620-9119 x170 _________________________________________________________________________ For help in using, subscribing, and unsubscribing to the discussion forums, please go to: http://www.netdynamics.com/support/visitdevfor.html For dire need help, email: [EMAIL PROTECTED] Paul Gentile Consultant - Cardinal Group International. Inc. [EMAIL PROTECTED] (508) 620-9119 x170 _________________________________________________________________________ For help in using, subscribing, and unsubscribing to the discussion forums, please go to: http://www.netdynamics.com/support/visitdevfor.html For dire need help, email: [EMAIL PROTECTED]
