[web2py] set of rows as input to smart grid

2015-06-24 Thread Michael Beller
You can pass a list of fields using the 'fields' arg of smartgrid -- 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 ar

Re: [web2py] Re: sending email

2015-06-24 Thread Michael Beller
If you have two factor auth enabled in gmail you need to authorize app and generate unique password -- 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 r

[web2py] Re: empy string from csv for integer for integer field

2015-06-24 Thread Dave S
On Wednesday, June 24, 2015 at 2:34:40 PM UTC-7, goome wrote: > > > Or changing the validator to provide the NULL. > > how could it be done? in the model? > I believe so, but I've only played around a little with validators. The other suggestions may be simpler for you. Or you can search for c

[web2py] Re: empy string from csv for integer for integer field

2015-06-24 Thread 黄祥
they suggest to change your csv that have '' empty or null value for the field that have integer type. another way around is to set default = 0 in your table definition in models for that table. best regards, stifan > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation

[web2py] Re: empy string from csv for integer for integer field

2015-06-24 Thread goome
> Or changing the validator to provide the NULL. how could it be done? in the model? 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 re

[web2py] Re: How do I check of the version of pysimplesoap in web2py.

2015-06-24 Thread Limedrop
SOAP can really be a world of pain. I spent hours trying to connect to a SOAP service and the best I could get was a "400 Bad Request". It turned out that they were using wsHttpBinding - which seems to only be supported by .NET clients. The work-around is to manually inject the WS-Security h

[web2py] Re: empy string from csv for integer for integer field

2015-06-24 Thread Dave S
On Wednesday, June 24, 2015 at 11:43:46 AM UTC-7, Dave S wrote: But hey, Niphlod beat me to it. > On Wednesday, June 24, 2015 at 10:28:21 AM UTC-7, goome wrote: >> >> Hello >> i have a table with integer field. >> i populated thhe db from a csv (created from other then me). >> it sometimes h

[web2py] Re: empy string from csv for integer for integer field

2015-06-24 Thread Dave S
On Wednesday, June 24, 2015 at 10:28:21 AM UTC-7, goome wrote: > > Hello > i have a table with integer field. > i populated thhe db from a csv (created from other then me). > it sometimes has empty value for the integers fields. > So when i try to get a list of the records of the table, i got: >

[web2py] Re: empy string from csv for integer for integer field

2015-06-24 Thread Niphlod
an integer can't be ''. set them to null of to 0 at import time :D On Wednesday, June 24, 2015 at 7:28:21 PM UTC+2, goome wrote: > > Hello > i have a table with integer field. > i populated thhe db from a csv (created from other then me). > it sometimes has empty value for the integers fields. > S

[web2py] Re: How do I check of the version of pysimplesoap in web2py.

2015-06-24 Thread Dave S
On Wednesday, June 24, 2015 at 4:39:57 AM UTC-7, Encompass solutions wrote: > > Found it. it's in the init.py file in gluon/contrib/pysimplesoap/ > It's version 1.11 which is a little behind, but there are some regression > as of last year, we should check before bumping up the version. > > FWI

[web2py] set of rows as input to smart grid

2015-06-24 Thread Davy Jacops
Typically, smartgrid takes a query as argument. But what if that query is the result of a join where some fields may not be displayed in the smart grid? Example: q = ((db.t1.f1 == db.t2.f21) & (db.t2.f22 == db.t3.f3)) grid=SQLFORM.smartgrid(db.t1, constraints = dict(t1=query)) return locals()

[web2py] Re: Ajax and table with queried values

2015-06-24 Thread Dave S
On Wednesday, June 24, 2015 at 4:16:01 AM UTC-7, 黄祥 wrote: > > please see the book : > > http://web2py.com/books/default/chapter/29/11/jquery-and-ajax#The-ajax-function > or web2py appliances (posonlinestore and estore) for example > http://www.web2py.com/appliances > > Note that the technique in

[web2py] empy string from csv for integer for integer field

2015-06-24 Thread goome
Hello i have a table with integer field. i populated thhe db from a csv (created from other then me). it sometimes has empty value for the integers fields. So when i try to get a list of the records of the table, i got: type 'exceptions.ValueError'> invalid literal for long() with base 10: '' from

Re: [web2py] Re: does every controller function require a view?

2015-06-24 Thread Fabiano Almeida
or init function name with double underscore: def __test(): pass the __ make function usable in your code, but not visible in browser. Fabiano. 2015-06-23 15:30 GMT-03:00 Niphlod : > if you plan to use functions in controllers that MAY NOT be seen by users, > just define them with a parame

Re: [web2py] Re: Plain Text and HTML Email with auth.messages.verify_email

2015-06-24 Thread Mark Li
Hey Falko, I went with plain text email at first, but now everything is HTML email. Sorry I can't really help you out here! On Sat, Jun 20, 2015 at 4:10 PM, Falko Delarue wrote: > how did you do it? could you please explain ┐(・。・┐) ♪ > > > On Saturday, September 15, 2012 at 1:17:50 AM UTC+2, c

[web2py] Re: views: {{include var}}

2015-06-24 Thread Dmitry Ermolaev
thanx - it work! in controller: spath = 'views/default/pages/' + cat.folder + '/' spath1 = '/' + request.application + '/default/stream/' + spath return dict(page=request.folder + spath + rec.file_, sp=spath1, h=h, f=f) and I add path to urls by

[web2py] Re: views: {{include var}}

2015-06-24 Thread Dmitry Ermolaev
if that variable [page] not in globals - error raised if [page] is setted - all work среда, 24 июня 2015 г., 15:42:56 UTC+3 пользователь Anthony написал: > > {{include}} and {{extend}} are template directives, not Python code. So, > even if the Python "if" statement evaluates to False, the {{incl

[web2py] Re: views: {{include var}}

2015-06-24 Thread Dmitry Ermolaev
solve: use response.render: in controller: from gluon.fileutils import read_file spath = 'static/pages/' + cat.folder + '/' spath1 = '/' + request.application + '/' + spath h += XML(response.render(request.folder + spath + rec.file_, dict(sp=spath1

[web2py] Re: views: {{include var}}

2015-06-24 Thread Anthony
{{include}} and {{extend}} are template directives, not Python code. So, even if the Python "if" statement evaluates to False, the {{include page}} will still remain in the template and get executed (though once the actual template code is included there, *that *code will not be executed). So,

[web2py] Re: How do I check of the version of pysimplesoap in web2py.

2015-06-24 Thread Encompass solutions
Found it. it's in the init.py file in gluon/contrib/pysimplesoap/ It's version 1.11 which is a little behind, but there are some regression as of last year, we should check before bumping up the version. On Wednesday, June 24, 2015 at 9:52:08 AM UTC+3, Encompass solutions wrote: > > I am trying

[web2py] Re: Ajax and table with queried values

2015-06-24 Thread 黄祥
please see the book : http://web2py.com/books/default/chapter/29/11/jquery-and-ajax#The-ajax-function or web2py appliances (posonlinestore and estore) for example http://www.web2py.com/appliances best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - ht

[web2py] Ajax and table with queried values

2015-06-24 Thread Carla Raquel
I'm having a bit of trouble figuring out how to add info to a bootstrap table in a panel, through ajax.This's a phone call register system and I have the following code in the html: resumoMensal.html   Extensions

[web2py] Re: IS_TIME format

2015-06-24 Thread Niphlod
if you need a cutsom widget with a custom format, and you already rewrote the widget, why don't you rewrite also the validator ?! On Wednesday, June 24, 2015 at 10:00:46 AM UTC+2, Annet wrote: > > I wrote a widget to format time: > > def timeplain(field, value): > if value == None: >

[web2py] IS_TIME format

2015-06-24 Thread Annet
I wrote a widget to format time: def timeplain(field, value): if value == None: value = '' elif 'strftime' in dir(value): value = value.strftime('%H:%M') id = '%s_%s' % (field._tablename, field.name) return INPUT(_type='text', _id=id, _class='form-control time_plain

[web2py] Re: how to use onupdate with grid

2015-06-24 Thread Niphlod
or just onupdate=updateAuthorizationStatus On Tuesday, June 23, 2015 at 9:41:39 PM UTC+2, Alex Glaros wrote: > > is this right? > > grid = SQLFORM.grid(db.AuthorizedInstance.id==request.get_vars. > specificAuthorizationID, editable=True, deletable=False, create=False, > searchable=False, detail

Re: [web2py] Re: does every controller function require a view?

2015-06-24 Thread Manuele Pesenti
Il 23/06/15 20:30, Niphlod ha scritto: > if you plan to use functions in controllers that MAY NOT be seen by > users, just define them with a parameter (a dummy one works fine) > > def this_function_is_accessible(): > pass > > def this_is_not_accessible(dummy=None): > pass Another way I lik

Re: [web2py] views: {{include var}}

2015-06-24 Thread Manuele Pesenti
Yes you need to pass a string in this way: {{include "page.html"}} Il 24/06/15 08:43, Dmitry Ermolaev ha scritto: > | > {{if 'page' in globals():}} > {{include page}} > {{else:}} > {{=list}} > {{pass}} > > | > erro - > File "C:\web2py-m\gluon\template.py", line 684, in parse > self.include(t