because in your example minmax = db(...).select(...)
is SQLRows minmax[0] is a row and minmax[0].codemin is a field variable. On Apr 9, 5:19 am, jmverm...@xs4all.nl wrote: > Denes, > > Problem solved: > > minimum=int(minmax.codemin) > maximum=int(minmax.codemax) > > Should read: > > minimum=int(minmax[0].codemin) > maximum=int(minmax[0].codemax) > > Why? > > > > db.define_table('zipcoderegions', > > > SQLField('region', type=integer, default='',notnull=True), > > > SQLField('codemin', type=integer, default='', notnull=True), > > > SQLField('codemax', type=integer,, default='', notnull=True), > > > migrate=False) > > > SQLField type definitions are strings: type='integer' > > > So even though I set the type to integer, when I get the value from > > the interface I have to cast it to an integer, as in Java. > > Kind regards, > > Annet --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---