[web2py] Re: response menu

2018-07-22 Thread 'Annet' via web2py-users
Hi Stavros, I think this'll solve your problem: {{=MENU(response.menu, _class='web2py-menu', li_class='dropdown', ul_class='dropdown-menu')}} Best, Annet -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code

[web2py] Re: Dealing with reserved keywords when you change or upgrade your database from SQLite to POSTGRES

2018-07-22 Thread Rahul
Hey everyone, Any clues on this one? OR should I start updating the application and the models with unused field names? Please let me know Thank you, *Rahul* On Friday, July 20, 2018 at 12:40:04 PM UTC+5:30, Rahul wrote: > > Hello All, >I am migrating my proj

Re: [web2py] Re: error: cannot switch to a different thread

2018-07-22 Thread Alvin Ang
Not really, I'm using Apache as web server. Best Regards, Alvin On Mon, Jul 23, 2018 at 6:56 AM 黄祥 wrote: > seems it's related with gevent > ref: > https://github.com/miguelgrinberg/Flask-SocketIO/issues/65 > > did you use apache as a reverse proxy and gevent as a web server? > > best regards,

[web2py] Re: error: cannot switch to a different thread

2018-07-22 Thread 黄祥
seems it's related with gevent ref: https://github.com/miguelgrinberg/Flask-SocketIO/issues/65 did you use apache as a reverse proxy and gevent as a web server? best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Sou

[web2py] error: cannot switch to a different thread

2018-07-22 Thread Alvin Ang
Deployed web2py to production lately, keep getting an intermittent error *"error: cannot switch to a different thread"*. Please help. - CentOS Linux release 7.4.1708 - web2py Version 2.16.1-stable+timestamp.2017.11.14.05.54.25 - Apache Version 2.4.33 - MySQL Version 10.1.30-MariaDB

Re: [web2py] Deleting a db table row

2018-07-22 Thread Anthony
On Sunday, July 22, 2018 at 7:13:13 AM UTC-4, Maurice Waka wrote: > > I have tried this example but I get this error below: > > > db(query).delete() > > Show the code for "query". Looks like it might include a Set object where a field or value is expected. > DELETE FROM post WHERE id IN(SELECT

[web2py] SQLFORM keepvalues

2018-07-22 Thread Artem
Dear All ! Is anyway to keepvalues only for particular fields with SQLFORM after form accepted ? For now i'm using mysqlform.process(keepvalues=True) , and after form loaded clear all not needed fields with JS ,and as i have many forms with many fields , is real headache . -- Resources: - htt

Re: [web2py] Re: Updated script for 'Moving your data from one database to another' recipe

2018-07-22 Thread Gualter Portella
Thanks, Anthony. I could create the authentication tables with the modifications you suggested. I wrote a script to transfer the rest of the data to the other tables. Thanks again, 2018-07-22 0:59 GMT-03:00 Anthony : > I assume you're getting this from the "web2py Application Development > Coo

Re: [web2py] Deleting a db table row

2018-07-22 Thread Maurice Waka
Sorry. I got it. Regards On Sun, 22 Jul 2018, 14:33 sandeep patel wrote: > You can delete row this way!! > db((db.table.id==id_s)&(db.table.created_by == auth.user.id)).delete() > if you want delete rows upto a certain limit so you can you put this > quarry under for loop. > Best, > > On Sun, Ju

Re: [web2py] Deleting a db table row

2018-07-22 Thread Maurice Waka
What's id_s? Am getting error that id_s not defined On Sun, 22 Jul 2018, 14:33 sandeep patel wrote: > You can delete row this way!! > db((db.table.id==id_s)&(db.table.created_by == auth.user.id)).delete() > if you want delete rows upto a certain limit so you can you put this > quarry under for l

Re: [web2py] Deleting a db table row

2018-07-22 Thread sandeep patel
You can delete row this way!! db((db.table.id==id_s)&(db.table.created_by == auth.user.id)).delete() if you want delete rows upto a certain limit so you can you put this quarry under for loop. Best, On Sun, Jul 22, 2018 at 4:43 PM Maurice Waka wrote: > I have tried this example but I get this er

Re: [web2py] Deleting a db table row

2018-07-22 Thread Maurice Waka
I have tried this example but I get this error below: db(query).delete() File "/usr/local/lib/python2.7/dist-packages/pydal/objects.py", line 2277, in delete ret = db._adapter.delete(table, self.query) File "/usr/local/lib/python2.7/dist-packages/pydal/adapters/sqlite.py", line 86, in delete