[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 line of code in my CSS file: .tab-content{ *display: none;* background: #ededed; padding: 15px; border: solid 1px black; border-radius:10px; } The highlighted part caused the databases to disappear because they are held inside a tab, i didn't realize this when i wrote that line, I changed the tab-content class name and my databases re-appeard. *This programming thing will kill us!!! I'm goign to bed now! I deserve it, i'll wake up after 2 days!* Regards; Mostwanted On Wednesday, July 31, 2019 at 6:43:18 PM UTC+2, mostwanted wrote: > > I have somehow suddenly lost my tables in appadmin, they have just > disappeared & i don't know where to!!! I can still save information, that > shows that the tables are still there, its just that they are not visible > in appadmin/index. How can i retrieve them & why have they disappeared?? > > Regards; > > Mostwanted > -- 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 "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/0d2ff8b7-6f27-4164-903e-e83adb6225a8%40googlegroups.com.
[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) - 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 "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/3f262dbb-290f-4cdf-bc41-54a3943b0ffb%40googlegroups.com.
[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 message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/2680fc94-db2a-4df3-83a3-1166abb83e80%40googlegroups.com.
[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 I put [sum] as the retrieval, I get "key error -- builtin object sum". When I use ["sum"], I get "key error -- 'sum'". I am not converting to JSON or dict, I just want the value as in the book example. /dps -- 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 "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/81c2f049-c681-4be2-807f-8aabb587f44c%40googlegroups.com.
[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 "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/79786fab-5892-4240-81e5-8539705372c1%40googlegroups.com.
[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) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/cfd66faa-7e43-49d9-bfac-fc2e8635949f%40googlegroups.com.
[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 these errors 15:33:58 listener-thread: err = -951: oserr = 0: errstr = web2py@x.x.x.x: Incorrect password or user web2py@x.x.x.x is not known on the database server. Why would the web2py user be trying to connect to the Informix server? Could this be uwsgi trying to make a database connection? -- 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 "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/17b4940f-ff3b-4660-906a-b49ffd6f54ed%40googlegroups.com.
[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) - 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 "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/17a7621b-7619-4bc3-ba9d-3abcc4937935%40googlegroups.com.