Nico, Thanks for your response. The tables were already joined in the query definition inside the controller. query = ((db2.STATUSPOINT.POINTNUMBER < 100)&\ (db2.STATUSPOINT.POINTACCESSAREA == db2.AOR.AOR))
I feel quite certain that the problem is associated with the extra SQL required to do pagination on an Oracle database. I have tested this theory to the extent that I successfully implemented the same controller, model, and data on a mysql database, and everything worked perfectly. I've included the models as you suggested: db2 = DAL('oracle://******/********@*****', migrate=False) db2.define_table('AOR', Field('AOR','integer',writable=False), Field('REFERENCENAME','string',writable=False), Field('ACCESSAREAASSIGNMENT','integer',writable=False), Field('ACCESSZONEASSIGNMENT','integer,writable=False'), primarykey=['AOR'], migrate=False ) db2.define_table('STATUSPOINT', Field('POINTNUMBER', 'integer',writable=False), Field('POINTNAME', 'string',writable=False), Field('LOGPARTITION', 'integer',writable=False), Field('POINTACCESSAREA', 'integer',writable=False), Field('ALTERNATEMENUINFORMATIONAREA', 'integer',writable=False), Field('LOGICALDISPLAYREFERENCE', 'string',writable=False), Field('STATION', 'integer',writable=False), Field('GROUPINHERITANCE', 'integer',writable=False), Field('TRIGGERS', 'integer',writable=False), Field('INITIALVALUE', 'integer',writable=False), Field('PROPAGATEINITIALVALUE', 'string',writable=False), Field('SETNONUPDATE', 'string',writable=False), Field('MANUALOVERRIDE', 'string',writable=False), Field('MANUALENTRY', 'string',writable=False), Field('EVENTS', 'string',writable=False), Field('MAPBOARDGROUPNUMBER', 'integer',writable=False), Field('DATADIVISION', 'integer',writable=False), Field('ANALOGDEMANDSCAN', 'string',writable=False), Field('STATEFEATURES', 'integer',writable=False), Field('STATECALCULATOR', 'integer',writable=False), Field('CONTROL', 'integer',writable=False), Field('INDICATION', 'integer',writable=False), Field('ALTDATASOURCELIST', 'integer',writable=False), Field('ALTDATASOURCEUSAGELIST', 'integer',writable=False), Field('ALTDATASOURCEPROC', 'integer',writable=False), Field('ASSOCDEVICESETNUMBER', 'integer',writable=False), Field('ASSETID', 'string',writable=False), Field('PICOLLECTION', 'string',writable=False), Field('PIVALUETAG', 'string',writable=False), Field('PIQUALITYSTORAGE', 'string',writable=False), Field('PIQUALITYTAG', 'string',writable=False), Field('COLLECTTOHISTORICAL', 'integer',writable=False), Field('POINTURLS', 'integer',writable=False), Field('ACTIONDESCRIPTIONSET', 'integer',writable=False), Field('CIRCUITLABELNUMBER', 'integer',writable=False), Field('SUBSTATIONNUMBER', 'integer',writable=False), Field('DEVICETYPENUMBER', 'integer',writable=False), Field('LONGNAMENUMBER', 'integer',writable=False), Field('TOGGLERELEASETHRESHOLD', 'integer',writable=False), Field('TOGGLEINHIBITTHRESHOLD', 'integer',writable=False), Field('CONTROLWARNING', 'integer',writable=False), Field('EDNACOLLECTION', 'string',writable=False), Field('EDNAEXTIDENTIFIER', 'string',writable=False), Field('EDNAQUALITYSTORAGE', 'string',writable=False), Field('EDNASECURITYGROUP', 'integer',writable=False), Field('DOG1REF', 'integer',writable=False), Field('DOG2REF', 'integer',writable=False), Field('DOG3REF', 'integer',writable=False), Field('DOG4REF', 'integer',writable=False), Field('DH_READ_REFERENCE', 'integer',writable=False), Field('PI_DIGITAL_SET_NUMBER', 'integer',writable=False), Field('DOG_ASSIGNMENT_FKO', 'integer',writable=False), Field('DOM', 'string',writable=False), Field('OPCSERVERITEM', 'integer',writable=False), Field('SCADAGROUP_FKO', 'integer',writable=False), Field('TRANSIENTSTATEDELAY', 'integer',writable=False), Field('TRIPPEDBREAKERSUMMARY', 'string',writable=False), primarykey=['POINTNUMBER'], migrate=False ) - Tom On Tuesday, September 6, 2016 at 12:20:42 AM UTC-6, Nico de Groot wrote: > > Hi Tom, > I think you need to specify the join between the two tables in the query, > otherwise you get the full product of the two tables. Please check the > Web2py book at > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Inner-joins > > > Please show the model files if you need more help. > > Nico de Groot > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.