[web2py] Re: Tables in Appadmin/index have disappeared

After thousands of hrs of not bathing looking at a computer monitor with blood-shot bulging eyes & going through hundreds & hundreds of lines of code pulling my hairs out at the same time I have finally figured out why my databases disappeared without a trace from appadmin/index. I had this lin

[web2py] Re: Accessing some sum

I just want to say that you can't retrieve sum from row using the string-key 'sum', you should use the object as in the book example. And it would be better if dal supports syntax like db.table.field.sum().as('mysum') -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Accessing some sum

and of course, if you convert result to json or list/dict you have to use '_extra' -- 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) --- You received this mess

[web2py] Re: Accessing some sum

On Saturday, August 3, 2019 at 12:53:02 AM UTC-7, Val K wrote: > > I just want to say that you can't retrieve sum from row using the > string-key 'sum', you should use the object as in the book example. And it > would be better if dal supports syntax like db.table.field.sum().as('mysum') When

[web2py] Re: Accessing some sum

Try db(db.test1).select(sum) -- 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) --- You received this message because you are subscribed to the Google Groups "w

[web2py] Re: How can I insert image in HTML from database?

Dave, I don't understand what means that string: blob = db[somethingsomething].[copyblobltotmpfile] Is your example only for '.jpeg' files or for another expansions too? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - h

[web2py] Web2py remote linux user trying to connect to Informix

We have Web2py 2.18.5-stable running on a RHEL 7 virtual machine with python 2.7.16, nginx 1.17.1, and uwsgi 2.0.x. Although web2py applications can connect to our Informix database server using the credentials specified in the DAL for each application, on the Informix server, we are seeing the

[web2py] How to add vertical Scroll bar to the table in SQLGORM.grid

Hi all, instead of having multiple page of table, i would like to have 1 table with vertical scroll bar in SQLFORM.grid so that the user can view all by scrolling up and down instead of go to multiple pages 1 2 3 Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation)