[web2py] Re: request.args and special character

2016-05-24 Thread Dave S
On Tuesday, May 24, 2016 at 1:49:30 PM UTC-7, Ivan Gazzola wrote: > > I've tried an URI like this "app/controller/function/1%C2%B0%20Classe" for > sending the "1° Classe" value > > If in my function i call > > request.args(0) > > I get "1__Classe" > > If I call > > request.url.split('/')[-1]

[web2py] Re: (More complex) Aggregations in web2py and using SQLFORM.grid (DAL vs. SQL vs. pandas vs. ???)

2016-05-24 Thread villas
So why can't you do something like this... db.define_table('prop', Field('name','string'), Field('price','integer'), ) if not db(db.prop.id>0).count(): db.prop.insert(name="aaa", price=10) db.prop.insert(name="bbb", price=15)

Re: [web2py] Re: web2py and python3

2016-05-24 Thread Dave S
On Tuesday, May 24, 2016 at 1:42:35 PM UTC-7, Sayth Renshaw wrote: > > Of course though as Massimo cited all education institutions are teaching > Python 3 and have for a time meaning all the new developers are starting > there. If they write new code bases it will be 3, every dev deals with

[web2py] Re: "requires distutils, but not installed" error Web2Py_Win 64bit

2016-05-24 Thread Niphlod
deployment on openshit needs the source version PLUS gitpython installed and available. You can't use the binary. On Tuesday, May 24, 2016 at 10:42:34 PM UTC+2, Vignesh M wrote: > > Hi Team, > > I am using Python2.7 and Web2Py_Win.exe. I am getting "requires distutils, > but not installed"

[web2py] Re: how to set fast ordering datetime field [now without typos and subject]

2016-05-24 Thread Niphlod
duplicate, answered on https://groups.google.com/d/msg/web2py/aIg2t3ZlyKY/dnU5YYOPAAAJ On Tuesday, May 24, 2016 at 10:42:34 PM UTC+2, Matt Bee wrote: > > I have a table with a huge amount of records. There are aprox 3*10^6 > registers and counting. > > I need via scheduler delete the older

[web2py] Re:

2016-05-24 Thread Niphlod
index support is on the way but for the time being just stick an index manually. a CREATE INDEX ix_foo_foo_date on foo (foo_date) should suffice. on further iterations, you should consider how much you'd like to be exact showing the last 10 registers: you can't really expect to scale (index

[web2py] request.args and special character

2016-05-24 Thread Ivan Gazzola
I've tried an URI like this "app/controller/function/1%C2%B0%20Classe" for sending the "1° Classe" value If in my function i call request.args(0) I get "1__Classe" If I call request.url.split('/')[-1] I get "1° Classe" Why? I've tried to find the source code for args assignment but I

[web2py] Re: Front end design help

2016-05-24 Thread Ron Chatterjee
I would suggest just use container, row and column within a 12 grid system. And in one of the column insert a bootstrap form. style the column and then replace that form using SQLFORM or custom form. On Tuesday, May 24, 2016 at 4:34:27 PM UTC-4, Andre Kozaczka wrote: > > Thanks for the input

[web2py] "requires distutils, but not installed" error Web2Py_Win 64bit

2016-05-24 Thread Vignesh M
Hi Team, I am using Python2.7 and Web2Py_Win.exe. I am getting "requires distutils, but not installed" error message while pressing the [Deploy to OpenShift] button. Please help me solve this issue. Thanks. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: No module named appname.modules.funtions

2016-05-24 Thread 'Hi Toni' via web2py-users
It seems that you are missing an (empty) file*: * web2py/applications/appname/modules/*__init__.py* https://docs.python.org/2/tutorial/modules.html#packages Am Sonntag, 22. Mai 2016 14:28:38 UTC+2 schrieb BlueShadow: > > Hi, > Something is very wrong with my web2py. I finally got the newest

Re: [web2py] Re: web2py and python3

2016-05-24 Thread Sayth Renshaw
Of course though as Massimo cited all education institutions are teaching Python 3 and have for a time meaning all the new developers are starting there. If they write new code bases it will be 3, every dev deals with legacy code but is that really the strongest position to take? On Tuesday,

[web2py] Re: web2py resources

2016-05-24 Thread ahujaamaan
maybe you all want to know some easy steps to protect from phishing On Tuesday, May 1, 2012 at 1:19:41 AM UTC+5:30, Anthony wrote: > > Most web2py resources can be found on web2py.com, but here are some > Google

[web2py] how to set fast ordering datetime field [now without typos and subject]

2016-05-24 Thread MAbeeTT
I have a table with a huge amount of records. There are aprox 3*10^6 registers and counting. I need via scheduler delete the older registers, but the criteria of old register is determined by a datetime field: db.define_table('foo', Field('foo_file', 'upload', required=True, notnull=True,

[web2py]

2016-05-24 Thread MAbeeTT
I have a table with a huge amount of records. There are aprox 3*10^6 registers and counting. I need via scheduler delete the olders, bit the criteria of old register is determined by a datetime filed: db.define_table('foo', Field('foo_file', 'upload', required=True, notnull=True,

[web2py] Re: Front end design help

2016-05-24 Thread Andre Kozaczka
Thanks for the input guys. I'll probably end up purchasing a theme BUT I think I'm still going to need some help with the main part of the website which is a "report" that the site generates. The report has a very specific layout that is grouped, includes checkboxes/button that would need to

[web2py] Re: Front end design help

2016-05-24 Thread Ron Chatterjee
I would add to what anthony proposed. Check out pingendo and layoutit. May have to go back and forth between two to get the full swing of it. If its a boostrap3 theme you can use them in it to custom create the design. On Tuesday, May 24, 2016 at 2:42:54 PM UTC-4, Anthony wrote: > > Not

[web2py] Re: Front end design help

2016-05-24 Thread Anthony
Not discouraging you from seeking help, but depending on your needs, you might also find you can get started by purchasing a decent theme from someplace like http://themeforest.net/ or https://wrapbootstrap.com/. You can still hire someone to help customize and tweak, but that could be a lot

[web2py] Front end design help

2016-05-24 Thread Andre Kozaczka
Hi - I've built a website using web2py (obviously!) but I'm terrible at front end design (html & javascript) and I'm looking for help. Ideally it's someone familiar with web2py. Anyone have good experiences and could recommend a person/company? Right now I'm looking at bunch of different

[web2py] Re: SQLFORM.grid and fields: suppress columns in the grid

2016-05-24 Thread Martin Weissenboeck
Thank you, Anthony! I have found the same solution after reading the source code. Maybe this tip is worth making mention of it in the book? 2016-05-24 17:16 GMT+02:00 Anthony : > Rather than using the "fields" argument, to suppress a field in the grid, > just set its

[web2py] Re: web2py and Spatial / GIS support

2016-05-24 Thread 'DenesL' via web2py-users
I believe the original web2py GIS sponsor (http://sahanafoundation.org/) uses it in their products, which are production ready. Expanding it depends on: - existence of desired functionality in the supported databases - desirability of said functions for the community - willingness to contribute,

[web2py] Re: Is auth.settings.login_onfail a documented callback?

2016-05-24 Thread Antonio Salazar
I was more worried about its stability. If it's not documented it could be subject to change. On Monday, May 23, 2016 at 7:23:10 PM UTC-5, Anthony wrote: > > As you have observed, it is not documented. If you're asking whether it is > supported, yes -- I think the lack of documentation is just

[web2py] Re: Is auth.settings.login_onfail a documented callback?

2016-05-24 Thread Antonio Salazar
Thank you. I actually got it working too, but I was worried it might change in later versions of web2py. On Monday, May 23, 2016 at 8:12:25 PM UTC-5, 黄祥 wrote: > > perhaps an example can speak thousand words : > e.g. > def login_onfail(form): > email = request.vars.email > row =

[web2py] Re: SQLFORM.grid and fields: suppress columns in the grid

2016-05-24 Thread Anthony
Rather than using the "fields" argument, to suppress a field in the grid, just set its "readable" attribute to False (before creating the grid): db.t1.bb.readable = False grid = SQLFORM.grid(db.t1) Anthony On Tuesday, May 24, 2016 at 8:44:53 AM UTC-4, mweissen wrote: > > Let's say I have table

[web2py] Re: (More complex) Aggregations in web2py and using SQLFORM.grid (DAL vs. SQL vs. pandas vs. ???)

2016-05-24 Thread stex76
Hi villas, thanks for your comment and the links (especially the second one). Since I want to learn if you can show me a better solution in SQL I would highly appreciate it. Normally I prefer do write my SQL "stepwise" so I don't have to read inside out. Here's a small SQLite setup: -- setup

[web2py] Re: web2py and Spatial / GIS support

2016-05-24 Thread Pierre
too bad do you think the existing implementation is still usable in a production context or is it too dangerous / unstable ? there's a python package called *pyproj* that might offer some workarounds to transform points coordinatesand "stay in touch" with the dal -- Resources: -

[web2py] Re: I think I can make websites now with web2py but is there any scope for freelancing?

2016-05-24 Thread Alessio Varalta
I started to use web2py for a collaboration with public organisation that use web2py..After in these months I have realized my first web2py application for a client https://barometro.ethicalsoftware.net/coop...But in my region there isn't at this moment work like web2py developer, there is

[web2py] Re: [Solved] "file inaccessible" on GAE for error handlers

2016-05-24 Thread Mathieu Clabaut
Oups, I posted the solution a bit too quickly. It indeeds work on the local dev_appserver, but it failed when being uploaded : Error 400: --- begin server output --- Could not compile RE "/(.+?)/static/_(\\d+\\.\\d+\\.\\d+)\\/(?!error_handlers)(.+)": invalid perl operator: (?! If anybody

[web2py] SQLFORM.grid and fields: suppress columns in the grid

2016-05-24 Thread Martin Weissenboeck
Let's say I have table with two integer fields and one virtual field: db.define_table('t1', Field('aa','integer'), Field('bb','integer'), Field.Virtual('ab', lambda row: row.t1.aa+row.t1.bb), ) The SQLFORM.grid works fine: def ab(): grid=SQLFORM.grid(db.t1,

[web2py] I think I can make websites now with web2py but is there any scope for freelancing?

2016-05-24 Thread Steve Joe
I see everyone wants php -- 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] [Solved] "file inaccessible" on GAE for error handlers

2016-05-24 Thread Mathieu Clabaut
Hello, I had some difficulties to set up some "routes_onerror" files on GAE. It worked perfectly on a local instance, but each time an HTTP exception was raised, GAE issued a "file inaccessible" error (status 500). The problem comes from the fact that static files are treated specially on GAE

[web2py] Re: web2py and Spatial / GIS support

2016-05-24 Thread Niphlod
nobody pushed GIS and frankly the support for it is scattered. There hasn't been an holistic approach in the implementation. IMHO you should not rely on anyone but yourself to add support on pydal. On Tuesday, May 24, 2016 at 9:57:52 AM UTC+2, Pierre wrote: > > nobody knows or nobody wants to

[web2py] Re: web2py and Spatial / GIS support

2016-05-24 Thread Pierre
nobody knows or nobody wants to answer...? well that's not encouraging for people interested in GIS... and it might cause an unpleasant feeling that this GIS-thing is down..correct me if this is a false assumption am sorry if i did ask the wrong question or if i hurted someone's