[web2py:19605] Re: '%LIKE%' syntax.

2009-04-11 Thread mdipierro
I do not understand. Can you make an example? On Apr 11, 5:36 pm, AchipA wrote: > what would be the reverse of that ? if the field is the substring we > want to locate ? I have a solution but it's ugly/hackish so I'm open > to suggestions :) > > On Apr 10, 6:13 pm, mdipierro wrote: > > > db(db.

[web2py:19604] Re: GAE help

2009-04-11 Thread Robin B
I am not sure if that is true or not. To test for GAE, I would set 'is_gae' to True in gaehandler.py to achieve fool-proof detection. To detect production/debug on GAE, I use this in 0.py: response.debug = os.environ.get('SERVER_SOFTWARE','').startswith ('Devel') Robin On Apr 11, 2:59 pm, mdi

[web2py:19603] Re: Threaded Based discussion examples

2009-04-11 Thread murray3
Thanks but here is my attempt at reddish code on GAE: I have problems, any help appreciated. chrism model: db.define_table("prodj", SQLField("timestamp",'datetime',default=now), SQLField("uuid",length=128,writable=False,default=str(uuid.uuid4 ())), SQLField("active",'boolean',default

[web2py:19602] Re: '%LIKE%' syntax.

2009-04-11 Thread AchipA
what would be the reverse of that ? if the field is the substring we want to locate ? I have a solution but it's ugly/hackish so I'm open to suggestions :) On Apr 10, 6:13 pm, mdipierro wrote: > db(db.name.like('%alex%)).select() > > On Apr 10, 4:04 pm, "web2py <<>> technicalbloke.com" > > > >

[web2py:19601] Re: welcome to our friends from Brazil

2009-04-11 Thread pirata.dabaixada
Já entrei ! g-man escreveu: > Tudo bem! > > On Apr 11, 11:35 am, Álvaro Justen [Turicas] > wrote: > >> Para quem fala Português, entre agora mesmo na lista de usuários >> brasileiros do web2py. :-) >> Participe e chame seus amigos! >> >> --- >> >> I encourage other users to create local lists

[web2py:19600] Re: welcome to our friends from Brazil

2009-04-11 Thread g-man
Tudo bem! On Apr 11, 11:35 am, Álvaro Justen [Turicas] wrote: > Para quem fala Português, entre agora mesmo na lista de usuários > brasileiros do web2py. :-) > Participe e chame seus amigos! > > --- > > I encourage other users to create local lists in yours coutries, like > web2py-brazil-users.

[web2py:19599] GAE help

2009-04-11 Thread mdipierro
Is this still true on GAE? try: magic = imp.get_magic() except: is_gae = True else: is_gae = False If not. How can we fix it? If this not true any more it may be causing a major slow down on GAE. Massimo --~--~-~--~~~---~--~~ You received this message

[web2py:19598] Re: Migration Issues

2009-04-11 Thread TheDude
Yup here it is: http://paste.pocoo.org/show/guKnBZMTv6AIOHzjz6zd/ On Apr 11, 3:30 pm, mdipierro wrote: > can you show us the web2py model and the query? > > On Apr 11, 2:23 pm, TheDude wrote: > > > OK, so I had a migration issue with my DB some time ago, the easy fix > > was migrate=False on al

[web2py:19597] Re: Migration Issues

2009-04-11 Thread mdipierro
can you show us the web2py model and the query? On Apr 11, 2:23 pm, TheDude wrote: > OK, so I had a migration issue with my DB some time ago, the easy fix > was migrate=False on all of my tables. I knew this was a bad fix, > because it was a short-term solution. I get the error "Table feed > alr

[web2py:19596] Migration Issues

2009-04-11 Thread TheDude
OK, so I had a migration issue with my DB some time ago, the easy fix was migrate=False on all of my tables. I knew this was a bad fix, because it was a short-term solution. I get the error "Table feed already exists" now this is true, so instead of trying to create the table, skip the procedure o

[web2py:19595] Re: welcome to our friends from Brazil

2009-04-11 Thread Álvaro Justen [Turicas]
Para quem fala Português, entre agora mesmo na lista de usuários brasileiros do web2py. :-) Participe e chame seus amigos! --- I encourage other users to create local lists in yours coutries, like web2py-brazil-users. Local lists can save Massimo's time with helping users and help bringing new u

[web2py:19594] welcome to our friends from Brazil

2009-04-11 Thread mdipierro
http://groups.google.com/group/web2py-users-brazil --~--~-~--~~~---~--~~ 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

[web2py:19593] Re: Flow of execution

2009-04-11 Thread DenesL
On Apr 11, 3:03 am, jmverm...@xs4all.nl wrote: > And does exactly what I want it to do under all circumstances. Two > more questions though: > > When I remove clubs=[] an error ticket is issued telling me that clubs > is being used before being assigned a value. I haven't seen this: You are retur

[web2py:19592] Re: Threaded Based discussion examples

2009-04-11 Thread mdipierro
http://groups.google.com/group/web2py/browse_thread/thread/b6a67992b9b106ed# On Apr 11, 6:03 am, murray3 wrote: > Anyone created any threaded based discussion code similar to what we > are > using here now. I want to incorporate this into an Open source app I > am developing and > it needs to ru

[web2py:19591] Re: BETWEEN functionality

2009-04-11 Thread mdipierro
yes. On Apr 11, 2:04 am, jmverm...@xs4all.nl wrote: > I reread my functions, and came across this one: > > def details(): >     id=request.args[0] >     club=db(db.bedrijf.id==id).select() >     address=db((db.adres.bedrijf==id)& > (db.adres.adressoort=='vestigingsadres')).select() >     nfas=db(

[web2py:19590] Re: Idea

2009-04-11 Thread mdipierro
web2py does not allow this. It allows subselect in queries db(db.table.field.belongs(db()_select(db.othertable.otherfield)).select () # ALLOWED Massimo On Apr 11, 12:08 am, TheDude wrote: > Allow sub-queries to be performed within the DAL. How? This would be a > good example. > > db(db.table.f

[web2py:19589] Re: Flow of execution

2009-04-11 Thread Álvaro Justen [Turicas]
You have to set clubs because you use it in other place. Probably you you clubs in a view and it have to be defined (even with a blank list) - if you don't define, Python will raise an exception. You can define clubs = [] before if and not in elif and else. On 4/11/09, jmverm...@xs4all.nl wrote:

[web2py:19588] Threaded Based discussion examples

2009-04-11 Thread murray3
Anyone created any threaded based discussion code similar to what we are using here now. I want to incorporate this into an Open source app I am developing and it needs to run on GAE. I know Reddish did simething similar but it was not updated to work with latest version of web2py, so I am not sur

[web2py:19587] Streaming: advice needed

2009-04-11 Thread SergeyPo
Hello group! I want to mimic the behavior of console application through web interface: I invoke a process in web2py controller function and try to pipe its stdout to user's browser (no keyboard input is needed). These are time-consuming processes that print out their progress with simple python

[web2py:19586] Re: Flow of execution

2009-04-11 Thread jmvermeer
Denes and Alvaro, Thanks for your replies. The by place function now reads like: def byplace(): response.functionname=T('Club locator op plaats') response.image=URL(r=request,c='static',f='media/core/banner.png') form=form_factory(SQLField('plaats',requires=IS_NOT_EMPTY(),\ widg

[web2py:19585] Re: auto_complete

2009-04-11 Thread jmvermeer
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

[web2py:19584] Re: BETWEEN functionality

2009-04-11 Thread jmvermeer
I reread my functions, and came across this one: def details(): id=request.args[0] club=db(db.bedrijf.id==id).select() address=db((db.adres.bedrijf==id)& (db.adres.adressoort=='vestigingsadres')).select() nfas=db((db.bedrijfnfa.bedrijf==id)& (db.bedrijfnfa.nfatype==db.nfatype.id)