Il giorno giovedì 24 gennaio 2013 18:56:59 UTC+1, Massimo Di Pierro ha scritto:
> > db.Relation.name.widget=SQLFORM.widgets.autocomplete(request,db.Person,id_field= > db.Person.id <http://db.person.id/>) > > db.Relation.contact.widget=SQLFORM.widgetsre.autocomplete(request,db.Person,id_field= > db.Person.id <http://db.person.id/>) > > should be > > > db.Relation.name.widget=SQLFORM.widgets.autocomplete(request,db.Person,name,id_field= > db.Person.id <http://db.person.id/>) > db.Relation.contact.widget=SQLFORM.widgets.autocomplete(request, > db.Person.name,id_field=db.Person.id <http://db.person.id/>) > > I forgot to write "name" in previus post but the model was ok. Really my model is more complex: db.define_table('Nominativi', Field('nome',notnull=True, represent=lambda nome:nome.title()), Field('categoria',db.Categorie_Nominativi,default='1'), Field('sesso',requires=IS_NULL_OR(IS_IN_SET(['maschio','femmina']))), Field('mail',requires=IS_NULL_OR(IS_EMAIL(error_message=T('Inserire Una Mail Valida')))), Field('indirizzo'), Field('localita', label='Località '), Field('cap',requires=IS_NULL_OR(IS_LENGTH(5,5, error_message=T('Inserire Un CAP valido')))), Field('provincia',requires=IS_NULL_OR(IS_IN_SET(Elenco_Province, zero=T('Selezionare una Provincia')))), Field('codice_fiscale',length=20), Field('partita_iva',length=20), Field('data_di_nascita','date'), Field('professione'), Field('padre'), Field('madre'), Field('inviato_da'), Field('id_precendente','integer'), format=lambda r:r.nome.title()+'-->'+db.Categorie_Nominativi(r.categoria)['categoria']) db.Nominativi.categoria.requires=IS_IN_DB(db,'Categorie_Nominativi.id','%(categoria)s',zero=None) db.Nominativi.categoria.represent = lambda id,row: row.categoria db.Nominativi.nome.represent = lambda nome,row: nome.title() db.Nominativi.inviato_da.widget=SQLFORM.widgets.autocomplete(request,db.Nominativi.nome) db.define_table('Relazioni', Field('nominativo',db.Nomiantivi,required=True), Field('referente',db.Nominativi,required=True)) db.Relazioni.nominativo.widget=SQLFORM.widgets.autocomplete(request,db.Nominativi.nome,id_field=db.Nominativi.id) db.Relazioni.referente.widget=SQLFORM.widgets.autocomplete(request,db.Nominativi.nome,id_field=db.Nominativi.id) The error log: <type 'exceptions.ValueError'> invalid literal for int() with base 10: 'Pippo Pippo' and 'pippo pippo' was the value of 'referente'. If i try a simplified model like that i posted before, i can insert the new record but the 'contact' value is stored in 'name' field and 'contact' field is always '0'. db.define_table('Person', Field('name'), format='%(name)s') db.define_table('Relation', Field('name',db.Person), ('contact',db.Person)) db.Relation.name.widget=SQLFORM.widgets.autocomplete(request,db.Person.name,id_field= db.Person.id <http://db.person.id/>) db.Relation.contact.widget=SQLFORM.widgets.autocomplete(request,db.Person.name,id_field= db.Person.id <http://db.person.id/>) I suppose that ajax request lose some data, it would store only the last call to table Person ... --
