Denes, You are right, in the PostgreSQL documentation it says that LIKE only works on fields of type string.
I reconsidered the model: 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) and came to the conclusion that region doesn't necessarily have to be of type integer, so I changed it to type string, solving the auto- complete problem. I bookmarked the reference, up to now I used the w3c site for reference purposes. 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 -~----------~----~----~----~------~----~------~--~---