[web2py] Re: Why is my if/else statement not working

2019-09-15 Thread Paco Bernal
El viernes, 13 de septiembre de 2019, 9:31:23 (UTC+2), mostwanted escribió: > > This conditional statement should be simple & execute without any issues, > I have created a point of Sale system, in a view it shows all the items & > their available quantities, what i want is that when a product'

[web2py] Re: Determinign what information get displayed based on their content

2019-09-15 Thread Paco Bernal
* Is there a way i could choose what gets displayed in the view & what > doesn't get displayed from the database table based on its content using > only python??* > > {{for p in products:}} {{=p.whatever}} {{pass}} -- Resources: - http://web2py.com - http://web2py.com/book (Documentati

[web2py] Re: Determinign what information get displayed based on their content

2019-09-15 Thread Paco Bernal
*Is there a way i could choose what gets displayed in the view & what doesn't get displayed from the database table based on its content using only python??* {{for p in products:}} {{if p.Quantity>0:}} {{=p.whatever}} {{pass}} {{pass}} Two ways for doing that :) -- Resources: - http://web

[web2py] Re: py4web has now a grid ...

2019-09-15 Thread Massimo Di Pierro
what bowser? any console error? what do you see in the page source? On Saturday, 14 September 2019 15:15:18 UTC-7, isi_jca wrote: > > Hi Massimo: > > When I try the example I only watch a page blank. Why? > > Best Regards > > El jueves, 12 de septiembre de 2019, 3:31:36 (UTC-3), Massimo Di Pierro

[web2py] Re: 1215 Cannot add foreign key constraint

2019-09-15 Thread Dave S
On Friday, September 13, 2019 at 9:41:57 AM UTC-7, Steve wrote: > > Hi Dave, > > Finally i got to the root of the problem :-) > Turns out to be a builders error ... yes, my own error. > > > In the very first table there is a reference to a logged in user which > does not exist when trying to

Re: [web2py] Why is my if/else statement not working

2019-09-15 Thread Dave S
On Fri, Sep 13, 2019 at 2:31 PM mostwanted > > wrote: > >> This conditional statement should be simple & execute without any issues, >> I have created a point of Sale system, in a view it shows all the items & >> their available quantities, what i want is that when a product's quantity >> goe

[web2py] Select records NOT in a set

2019-09-15 Thread backseat
I have a list of members that I want to schedule for certain duties. One table lists the people: db.define_table( 'members', Field('fullname', type='string', label='Name'), [...] ) I select members from that table according to certain criteria, but I want to not select them if they

[web2py] py4web grid syntax - needs testers

2019-09-15 Thread Massimo Di Pierro
I just pushed some changes to the new py4web grid (aka mtable aka publisher). It requires the latest pydal. There is an example in http://127.0.0.1:8000/examples But as of today it works like this: 0) make sure you have apps/{yourapp}/static/components/mtable.js and mtable.html (copy them from

[web2py] Re: mongoengine.org: can this work with web2py?

2019-09-15 Thread Massimo Di Pierro
It depends on what you need. I think it is usable in production. authentication with SAML/PAM/LDAP are not tested. The grid is not as fully featured as the web2py's grid but it works. The main things it that I cannot promise stability of the Auth and Grid API. It is possible they will change a lit

[web2py] Re: Help understanding memory use and selects

2019-09-15 Thread Massimo Di Pierro
I would rewrite p_here = [p for p in cpaths if loc_id in db.steps[int(p['steps'][0])]. > locations] > > as ids = [int(p['steps][0]) for p in p in cpaths]) rpaths = db(db.steps.id.belongs(ids)(db.steps.locations.contains(loc_id)).select(db.steps.id) p_here = [p for p in cpaths if int(p['steps']

Re: [web2py] Why is my if/else statement not working

2019-09-15 Thread mostwanted
Hey Dave, the $(document).ready(function(){}) statement is repeated as many times as as allowed by the for loop, I checked with the Firefox Web Developer-Debugger plugin, its repeated as per the number of elements in the for loop,its just not respecting the the rules of the condition i don't kn

[web2py] Re: Why is my if/else statement not working

2019-09-15 Thread mostwanted
Thank you so much Paco Bernal, I should be thinking the way you do. Your solution solved my problem, I just defined the "show" and "hidden" classes in my css for the refill class because initially the refill span was just appearing regardless of the condition the I realized the hidden class we

[web2py] Re: Determinign what information get displayed based on their content

2019-09-15 Thread mostwanted
Thanks again Paco Bernal, I can finally move on to other things. Regards; Mostwanted On Sunday, September 15, 2019 at 1:01:02 PM UTC+2, Paco Bernal wrote: > > > > * Is there a way i could choose what gets displayed in the view & what >> doesn't get displayed from the database table based on it