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

2019-08-03 Thread mostwanted
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

2019-08-03 Thread Val K
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

2019-08-03 Thread Val K
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

2019-08-03 Thread Dave S


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

2019-08-03 Thread Val K
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?

2019-08-03 Thread Константин Комков
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

2019-08-03 Thread Joseph Aulisi
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

2019-08-03 Thread Ryan
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.