Re: [web2py] Re: user registration flash message not returned

2016-02-04 Thread Vid Ogris
I have a login form on my first index page. Could that be the problem. No matter what I cannot get the session.flash message to be presented. 2016-02-04 9:20 GMT+01:00 Vid Ogris : > DO you suggest I change my controller completely ? > > where do I set

[web2py] format Date Time

2016-02-04 Thread Charles tenorio
Hi I'm using DataStore to save my data, and the date format is -MM-DD HH: MM: SS, the problem is that my application runs in a navgador with my Portuguese language, in time to save this erro : "month out of range', becouse in Brazilian DateTime is DD / MM / Y, how do I fix it? --

[web2py] task stuck in queue?

2016-02-04 Thread Dave S
I have a task stuck in the queue. I've tried manually advancing the start time in scheduler_task, using PICK in scheduler_worker, and waiting an hour or so (see thread at ) I haven't yet tried waiting 24 hours. What can I

[web2py] Re: Compilation & distribute app as binaries

2016-02-04 Thread Anthony
On Thursday, February 4, 2016 at 1:30:22 PM UTC-5, Hermann Tchehoun wrote: > > Hello Everyone ! > > I used web2py from source (2.13.4-stable+timestamp.2015.12.26.04.59.39), > python 2.7.11 and reportlab (to generate pdf) to built my app. > If you were running web2py from source, then presumably

[web2py] Re: smartgrid and selectable

2016-02-04 Thread Anthony
> > Also every time I click "Send IDs to another function" button, i do > new_function and go back to my_grid function, but the checkboxes I marked > at the beginning are not ticked any more. How to make sure that i do > new_function and go back to my_grid and see ticked checkboxes? > The

[web2py] Re: smartgrid and selectable

2016-02-04 Thread Anthony
I cannot reproduce the problem. When I try the same, the in new_function, the value of request.vars.id is a list of record IDs (from those selected in the grid). Also, note that when you use groupby, it will collapse over multiple records that share the same value on field1, so you will only

[web2py] response.flash in custom view

2016-02-04 Thread Joe
If I am not using {{extend 'layout.html'}} how can I make the response.flash working in my template? Thanks. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues)

[web2py] Rows not releasing all the memory back

2016-02-04 Thread Jitun John
My application, basically parses log files and presents that using web2py So each flat file is read line by line and inserted to a sqlite file. I use a global variable rows to read complete sqlite files later and do various filters and present data. So after creating rows as a global variable,

[web2py] Form submit scrolls to top of the page when error

2016-02-04 Thread Joe
My form is in the bottom of the page. When I submit the form, if there is an error, the error msg *(Enter Value*) works as expected but after submission the user is sent back to the top of the page so he can't see the error msgs. How can I keep the page where it is when the form is submitted if

[web2py] Re: why do certain queries give exception error

2016-02-04 Thread Anthony
See http://stackoverflow.com/a/35159596/440323. You're using "and" instead of "&". Anthony On Thursday, February 4, 2016 at 12:38:59 PM UTC-5, Valdeck Rowe wrote: > > Hi, > Just getting into web2py, but I've been having this issue. > > Why does the following query: > > query =

[web2py] Re: task stuck in queue?

2016-02-04 Thread Dave S
On Thursday, February 4, 2016 at 2:19:57 PM UTC-8, Dave S wrote: > > I have a task stuck in the queue. I've tried manually advancing the start > time in scheduler_task, using PICK in scheduler_worker, and waiting an hour > or so > (see thread at

[web2py] Q4web2py

2016-02-04 Thread Henk huisman
As we are left to right readers in the western hemisphere, I want to build a form grid with variables as rows and e.g. dates as columns. This kind of representation is very common and usefull in for example medical applications where you want to see the longitudinal results of a test. Patient

[web2py] Re: Q4web2py

2016-02-04 Thread Dave S
On Thursday, February 4, 2016 at 4:42:15 PM UTC-8, Henk huisman wrote: > > As we are left to right readers in the western hemisphere, I want to build > a form grid with variables as rows and e.g. dates as columns. > This kind of representation is very common and usefull in for example > medical

[web2py] conditional statement in view doesn't prevent "not defined" error

2016-02-04 Thread Alex Glaros
I'm trying to avoid an extra DB hit by first checking for records in controller. I set a "yes" or "no" type flag But the conditional in the view doesn't care if flag is set to no, it still raises error stating that the set within the conditional as undefined. Is the only way to get around

[web2py] Re: conditional statement in view doesn't prevent "not defined" error

2016-02-04 Thread Anthony
Please check the value of does_user_have_admin_roles -- it must be True when you think it isn't. Anyway, an alternative is: {{if 'admin_roles' in globals():}} Even better, just initialize admin_roles to an empty list and do: {{for r in admin_roles:}} The loop will not be executed if the list

[web2py] Re: Have listener return unaltered message?

2016-02-04 Thread Anthony
What is the nature of the message and how has it been altered in request.vars. By what means are you supposed to "send it back"? On Thursday, February 4, 2016 at 12:39:03 PM UTC-5, Martin wrote: > > I'm trying to construct an instant payment notification listener in > web2py. This requires me

Re: [web2py] Re: user registration flash message not returned

2016-02-04 Thread Richard Vézina
Did you upgrade recently? Did you try to have a look at your layouts and change in class="flash" -> class="w2p_flash" I had problem with flash message display when I upgrade recently and that was the cause of it. Richard On Thu, Feb 4, 2016 at 4:51 AM, Vid Ogris wrote: >

[web2py] Re: one select form multiple table

2016-02-04 Thread Imre
AttributeError: 'SQLFORM' object has no attribute 'search' 2016. február 1., hétfő 18:49:20 UTC+1 időpontban Alfonso Serra a következőt írta: > > I want to make a form which can search in multiple db tables. The tables >> has a same structure. >> > > the form is only one since your inputs

[web2py] Re: Duplicate entries in Auth_user DB table upon sign in

2016-02-04 Thread Richard
Hello Michael, Which version of web2py are you using and which version of python interpreter?? Thanks Richard Le mardi 2 février 2016 10:46:02 UTC-5, Michael Messmer a écrit : > > Yes it does. Submitted: https://github.com/web2py/web2py/issues/1178 > > On Wednesday, January 27, 2016 at

[web2py] web2py UnicodeDecodeError: 'utf8' codec can't decode byte 0xc7 in position 15: invalid continuation

2016-02-04 Thread Fábio Filho
I'm using a firebird legacy database and when I make this query: dbFb.INVENTORY.CODE==3 i got this output error: UnicodeDecodeError: 'utf8' codec can't decode byte 0xc7 in position 15: invalid continuation *there is a field called 'name', and when dbFb.INVENTORY.CODE==3,* *the field name

[web2py] Re: web2py star rating

2016-02-04 Thread Ron Chatterjee
Since I am getting an response I am guessing it doesn't work! lol. On Wednesday, January 27, 2016 at 6:42:23 PM UTC-5, Ron Chatterjee wrote: > > *I have the model defined as :* > > db.define_table('song', > Field('title'), > Field('rating')) > > Note*: rating is in the field. > >

Re: [web2py] Re: user registration flash message not returned

2016-02-04 Thread Anthony
On Thursday, February 4, 2016 at 3:21:02 AM UTC-5, Yebach wrote: > > DO you suggest I change my controller completely ? > I don't know about "completely," but at least fix the incorrect part. > where do I set auth.settings_register_onaccept? in db.py? > Anywhere after Auth has been defined

[web2py] Re: one select form multiple table

2016-02-04 Thread Anthony
It would be form.vars.search, but don't construct a raw SQL statement like that using user input, as you will be open to a SQL injection attack. Anthony On Thursday, February 4, 2016 at 10:00:41 AM UTC-5, Imre wrote: > > AttributeError: 'SQLFORM' object has no attribute 'search' > > > 2016.

[web2py] smartgrid and selectable

2016-02-04 Thread kecajkecaj123
Hi Guys, I use below controller function: def my_grid(): query = (db.table.id > 0) fields=(db.table.id,db.table.field1) selectable=[('Send IDs to another function', lambda ids: redirect(URL( 'default','new_function',vars=dict(ids=ids] grid =

[web2py] hide dropdown menu in reference field

2016-02-04 Thread Pierre
hi everyone this doesn't work db.define_table('person', Field('name', unique=True, requires=IS_NOT_IN_DB(db,'person.name')), Field('country'), Field('age','integer'), format='%(name)s') db.define_table('thing',

[web2py] Re: hide dropdown menu in reference field

2016-02-04 Thread Massimo Di Pierro
Can we see the controller? the problem is probably related to using string widget for a reference field. On Thursday, 4 February 2016 11:26:54 UTC-6, Pierre wrote: > > hi everyone > > this doesn't work > > db.define_table('person', > Field('name', unique=True,

[web2py] How to get a referenced field display as a dropdown on a crud form?

2016-02-04 Thread Natalie Asquith
I'm very new to web2py so sorry if this is a silly question... I have the following two tables defined. The problem stems from Field('game_id', 'reference game') , which I would expect to display as a dropdown on a crud form, like Field('student_id', 'reference auth_user') does. Instead

[web2py] Using web2py with Existing Python 3 Code

2016-02-04 Thread Grady Imel
Hello, I learned Python a little over a year ago and since then have developed an extensive ETL code base in Python 3 (I had no legacy issues) that parses various raw file input into a database and produces Excel-based reports. I would now like to put a web front end on it and web2py looks

[web2py] why do certain queries give exception error

2016-02-04 Thread Valdeck Rowe
Hi, Just getting into web2py, but I've been having this issue. Why does the following query: query = db.bids.job_id == job_id and db.bids.confirmed=='No' and db.bids.delivered=='No' on this table structure: db.define_table('bids', Field('body', 'text',

[web2py] Re: problem with PostgreSQL database

2016-02-04 Thread bogumil . g
Hello, I've the same problem with my app did you found any solution for this ERROR? my psycopg2 version is 2.4.5 tried it with 2.6.1 same problem appears. On Tuesday, January 12, 2016 at 4:27:24 AM UTC+1, Júlia Rizza wrote: > > I have an web2py app connected with a PostgreSQL database and it's

[web2py] Yellow box on screen following update

2016-02-04 Thread M Bailey
Hi All I just updated web2py today on my ubuntu box and I now get a yellow box on the screen in the admin area, which wasn't appearing before (screen shot attached). It's like an information dialog which isn't displaying anything and it only affects the admin area. The applications themselves

[web2py] Re: problem with PostgreSQL database

2016-02-04 Thread bogumil . g
I've found a solution For this problem. The problem was that for the version Web2py 2.13.4 the newrelic wasnt working. after the i removed the newrelic it worked for me. On Thursday, February 4, 2016 at 6:39:03 PM UTC+1, bogu...@gmail.com wrote: > > Hello, > I've the same problem with my app

[web2py] Have listener return unaltered message?

2016-02-04 Thread Martin
I'm trying to construct an instant payment notification listener in web2py. This requires me to receive a message from the other party and send it back unaltered. But I only have access to the request.vars which is a Storage object and already altered? How would I go about doing this? Hope you

[web2py] The connection could be established sorry

2016-02-04 Thread eric cuver
Hi, everybody ,since the last update I've often this message when I want to go on one of the controller's page "The connection could be established sorry Return" -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Duplicate entries in Auth_user DB table upon sign in

2016-02-04 Thread Michael Messmer
2.13.2-stable+timestamp.2015.12.18.11.00.46 (Running on Unknown, Python 2.7.5) On Thursday, February 4, 2016 at 7:20:06 AM UTC-8, Richard wrote: > > Hello Michael, > > Which version of web2py are you using and which version of python > interpreter?? > > Thanks > > Richard > > Le mardi 2 février

[web2py] Re: examples using ADFS

2016-02-04 Thread Massimo Di Pierro
There is this https://github.com/web2py/web2py/blob/master/gluon/contrib/login_methods/saml2_auth.py (docs in code) and this (unrelated) http://www.web2pyslices.com/slice/show/2038/web2py-saml2-sp On Monday, 1 February 2016 12:25:12 UTC-6, Jason Solack wrote: > > Is there any documentation

[web2py] Re: Need method for authenticating on multiple fields

2016-02-04 Thread Massimo Di Pierro
Ah! No. Never thought about that. Please open a ticket. On Tuesday, 2 February 2016 21:11:55 UTC-6, Cody Landry wrote: > > I'm experimenting with this approach and cannot find a way to allow users > that belong to different tenants to have the same username. Is this > possible? > > On

[web2py] Re: hide dropdown menu in reference field

2016-02-04 Thread Pierre
hello Massimo, here I use appadmin to insert records so no controller/function another 'refuznik': db.define_table('person', Field('name', unique=True, requires=IS_NOT_IN_DB(db,'person.name')), Field('country'), Field('age','integer'),

[web2py] Compilation & distribute app as binaries

2016-02-04 Thread Hermann Tchehoun
Hello Everyone ! I used web2py from source (2.13.4-stable+timestamp.2015.12.26.04.59.39), python 2.7.11 and reportlab (to generate pdf) to built my app. I follow the process described in manual "How to distribute your applications as binaries" in "Other recipes" to have binaries of my app while

[web2py] Re: format Date Time

2016-02-04 Thread Dave S
On Thursday, February 4, 2016 at 2:28:57 AM UTC-8, Charles tenorio wrote: > > Hi > I'm using DataStore to save my data, and the date format is -MM-DD HH: > MM: SS, the problem is that my application runs in a navgador with my > Portuguese language, in time to save this erro : "month out

[web2py] Re: smartgrid and selectable

2016-02-04 Thread Dave S
On Thursday, February 4, 2016 at 5:15:51 AM UTC-8, kecajk...@gmail.com wrote: > > [...] > Also every time I click "Send IDs to another function" button, i do > new_function and go back to my_grid function, but the checkboxes I marked > at the beginning are not ticked any more. How to make

Re: [web2py] Re: Changing Bootstrap Navbar to light background colour

2016-02-04 Thread Dan
FWIW... 1. layout.html - delete the navbar-inverse that makes the background color black/dark 2. menu.py - modify the text and link for the logo (which will be now too light colored on a white background) 3. web2py-bootstrap3.css - modify the colors of the logo and the footer

[web2py] how to upgrade web2py on turnkey linux

2016-02-04 Thread xmarx
i install web2py on hub.turnkeylinux.org. web2py version is 2.12.3. when i upgrade web2py application admin gives an error but i can't see error page. from then, i can't do anything with web2py admin interface. i message to turnkeylinux support center but they haven't reply yet. so i have few

Re: [web2py] Re: user registration flash message not returned

2016-02-04 Thread Vid Ogris
DO you suggest I change my controller completely ? where do I set auth.settings_register_onaccept? in db.py? 2016-02-03 17:16 GMT+01:00 Anthony : > If you do: > > form = auth() > > then you cannot call form.process(), as auth() automatically calls > .process() itself. Also,