Ok I thought it had been changed and the only thing we have to do is what
was wrote...

Thanks

Richard

On Thu, Feb 24, 2011 at 9:09 AM, DenesL <denes1...@yahoo.ca> wrote:

>
> See http://web2py.com/book/default/chapter/07#Autocomplete-Widget
>
> On Feb 23, 10:23 pm, Richard Vézina <ml.richard.vez...@gmail.com>
> wrote:
> > I try this : requires = [IS_IN_DB(db, db.joernaal.id,'%(titel)s')]
> >
> > Don't getting the autocomplete... Is there something else to write
> somewhere
> > to make it works except the []??
> >
> > Thanks
> >
> > Richard
> >
> > On Fri, Jan 28, 2011 at 9:45 AM, Massimo Di Pierro <
> >
> > massimo.dipie...@gmail.com> wrote:
> > > This:
> >
> > > requires = IS_IN_DB(db, db.joernaal.id, '%(titel)s')
> >
> > > indicates you want to a select/options dropbox and it takes time to
> > > populate it.
> >
> > > Use instead:
> >
> > > requires = [IS_IN_DB(db, db.joernaal.id,'%(titel)s')]
> >
> > > so no dropbox and use autocomplete.
> >
> > > On Jan 28, 5:54 am, Johann Spies <johann.sp...@gmail.com> wrote:
> > > > On 28 January 2011 13:30, Lucas D'Avila <lucass...@gmail.com> wrote:
> >
> > > > > Hi !
> >
> > > > > You can be more specific? have any suggestions to improve this?
> >
> > > > OK. For the following model, calling DAL.create it takes 65 seconds
> to
> > > open
> > > > the form using web2py's own webserver and 35 seconds when using
> Apache +
> > > > WSGI.  Both too long:
> >
> > > > db.define_table("artikel",
> > > >                 Field("joernaal_id",
> > > >                       db.joernaal,
> > > >                       requires = IS_IN_DB(db, db.joernaal.id,
> > > >                                           '%(titel)s')),
> > > > #                      widget =SQLFORM.widgets.autcomplete),
> > > >                 Field("outeur_id", 'list:reference outeur'),
> > > >                 Field("instansie_id", 'list:reference instansie'),
> > > >                 Field("titel", "string", notnull=True),
> > > >                 Field("opsomming", "text", notnull=True),
> > > >                 Field("sleutelwoorde", "text", notnull=True),
> > > >                 Field("vakgebied", "string", default=None),
> > > >                 Field("publikasiejaar", "integer", default=None),
> > > >                 Field("begin_bladsy",  default=None),
> > > >                 Field("laaste_bladsy", default=None),
> > > >                 Field("volume", "string", default=None),
> > > >                 Field('uitgawe', default=None),
> > > >                 Field('pub_tipe', default = None),
> > > >                 Field("taal", "string",  default=None),
> > > >                 Field("isi_indeks", default = None),
> > > >                 Field("isap_indeks", default = None),
> > > >                 Field("scopus_verwysing",
> > > >                       requires=IS_EMPTY_OR(IS_URL())),
> > > >                 Field("dokument_tipe"),
> > > >                 Field('ouid', 'integer',
> > > >                       requires = IS_EMPTY_OR(IS_IN_DB(db,
> > > 'article.ouid'))),
> > > >                 signature)
> >
> > > > I don't know what is causing this.  I just  guess it may the
> reference
> > > > fields.
> >
> > > > Regards
> > > > Johann
> >
> > > > --
> > > >  May grace and peace be yours in abundance through the full knowledge
> of
> > > God
> > > > and of Jesus our Lord!  His divine power has given us everything we
> need
> > > for
> > > > life and godliness through the full knowledge of the one who called
> us by
> > > > his own glory and excellence.
> > > >                                                     2 Pet. 1:2b,3a
> >
> >
>

Reply via email to