Re: [web2py] Re: Speeding up IS_IN_DB

2011-02-24 Thread Richard Vézina
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 wrote: > > See http://web2py.com/book/default/chapter/07#Autocomplete-Widget > > On Feb 23, 10:23 pm, Richard Vézina > wrote: > > I try this : requires

Re: [web2py] Re: Speeding up IS_IN_DB

2011-02-23 Thread Richard Vézina
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: > > re

Re: [web2py] Re: Speeding up IS_IN_DB

2011-01-30 Thread Johann Spies
Maybe this is related - I have not noticed it before: In the terminal from where I started web2py the following appeared: Uncaught RangeError: Maximum call stack size exceeded Regards Johann -- May grace and peace be yours in abundance through the full knowledge of God and of Jesus our Lord!

Re: [web2py] Re: Speeding up IS_IN_DB

2011-01-30 Thread Johann Spies
On 28 January 2011 19:54, Massimo Di Pierro wrote: > Something else is wrong. If you have requires=[...] it should not > query the db for the possible references and it should not make the > dropdown. > > Can we see the entire model? > > I have posted the model for this table in an earlier message

Re: [web2py] Re: Speeding up IS_IN_DB

2011-01-28 Thread Johann Spies
On 28 January 2011 15:48, DenesL wrote: > > According to your model you have two references: > 1) joernaal.id (with autocomplete) > 2) article.ouid (without) > There are also two other fields with list_references. There are about 137000 records in article and 8200 in joernaal. Regards Johann -

Re: [web2py] Re: Speeding up IS_IN_DB

2011-01-28 Thread Johann Spies
On 28 January 2011 16:45, Massimo Di Pierro 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 an