Re: [web2py] Web2py / Pydal Time Fields

I ended up converting to Decimal and then working from there. On Tue, Nov 10, 2015 at 1:18 AM, Manuele Pesenti wrote: > Il 05/11/15 06:53, Mark Graves ha scritto: > > Hey everyone, > > > > I find myself in the need for microsecond level precision for time > > fields where I am querying over thos

[web2py] Re: Admin plus plugin github page not found

There also many problem in http://www.web2pyslices.com/..many plugin don't have the online demo and this is danger because the user can't work on a plugin for example 30 minutes only for see if is a good plugin or not On Saturday, 7 November 2015 11:51:00 UTC+1, Alessio Varalta wrote: > > Hi, I

[web2py] Field set the default value +1 on insert

Hello web2py freaks, In my first try to make an application with web2py i have a little struggle how to accomplish as what is would like to see. In db1.py i created a field like this: db.define_table('jobticket', Field('ticket', 'integer', default = +1) # ticket needs to be tick

Re: [web2py] Web2py / Pydal Time Fields

Il 10/11/15 10:39, Mark Graves ha scritto: > I ended up converting to Decimal and then working from there. ok, not so far from my approach... you don't need to manage timezone I guess. Cheers M. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/w

Re: [web2py] Web2py / Pydal Time Fields

No, thankfully everything was done in one timezone =) On Tue, Nov 10, 2015 at 8:53 AM, Manuele Pesenti wrote: > Il 10/11/15 10:39, Mark Graves ha scritto: > > I ended up converting to Decimal and then working from there. > ok, not so far from my approach... you don't need to manage timezone I >

[web2py] Re: REST service POST responses

Thanks for your help, I got the GET and POST methods working. PUT for updating and DELETE don't seem to work though. I changed my API on your suggestion to wrap dict() around the DAL calls: @request.restful() def secapi(): response.view = 'generic.'+request.extension print "args ",reque

[web2py] Routes problem?

Hello all. All applications in the same web2py installation works fine. https://mydomain.com/myapp1 https://mydomain.com/myapp2 https://mydomain.com/myapp3 But now I don't know why all new apps goes on the welcome app. For app "myapp4" instead of https://mydomain.com/myapp4 I have: https://mydoma

[web2py] Re: Routes problem?

Dit you also press the button reload routes after the change? -- 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 su

[web2py] Re: Routes problem?

I don't know why but this button have never works in my both web2py installations. I restart the server for reloading the routes.py file. And yes I've done it. Il giorno martedì 10 novembre 2015 16:45:53 UTC+1, Bart van Berkel ha scritto: > > Dit you also press the button reload routes after th

[web2py] Re: Field set the default value +1 on insert

if you want to have a number that strictly: - is incremental (no gaps, always sequential, etc) - the first two digits are the year I'd suggest to have a "last_tickets" table (year(int) , ticket_no(int)) holding the current ticket. then, you can use _before_insert callback on the "tickets"

[web2py] Re: REST service POST responses

> def POST(table_name,**vars): > return dict(db[table_name].validate_and_insert(**vars)) > Just to be more explicit (and not so dependent on the magic in the generic.json view), I would instead recommend: db[table_name].validate_and_insert(**vars).as_dict() def PUT(table_name

[web2py] Scheduler not reassigning task after restart

I am running on a windows server 2008. I have nssm setup which manages my 4 worker nodes. The workers appear to be working correctly in the sense that the heartbeat is consistently updating. However, the tasks are stuck in the QUEUE status assigned to old worker nodes that do not exist. Is ther

[web2py] Re: Grabbing form data from one page to another and saving it to excel file

Thank you, that makes much more sense. I really appreciate it! Also, in regards to the redirect..are you suggesting I may not want to do that for this application? Because I was intending on making that a confirmation page with the submitted information, I thought redirect would be the best for t

[web2py] stepofweb theme layouts?

I'm coming over from PHP where I was using the "Smarty" theme template from stepofweb . I'd like to build this into my web2py site. Has someone already done this? Or is there a best practice for implementation? For example, should I try and create a "

[web2py] Re: Oracle perfomance issues with version 2.12.3

Thanks for the suggestion. I started a web2py session from the command line, and ran a simple DAL select from there. python web2py.py -M -S myapplication result = db2(db2.soe_tdb.pointnumber>0).select(db2.soe_tdb.ALL,limitby=(0,10)) print db2._timings [("ALTER SESSION SET NLS_DATE_FORMAT = '

[web2py] sqlform.grid csv export set delimiter

Hello Is it possible to set the delimiter (tab delimited) for csv export from SQLform.grid? also if I want to export some rows but do not want to show them in grid, what is the syntax to use (I want to hide a column db.workers.id, but i want to export it)? thank you -- Resources: - http://

[web2py] Re: sqlform.grid csv export set delimiter

I think you want the tsv_with_hidden_cols option: http://web2py.com/books/default/chapter/29/07/forms-and-validators?search=tsv_with_hidden_cols See the surrounding documentation for details on how to control/customize the download options (if you don't see an option that suits your needs, you

[web2py] blocking all access but america

hey everyone, what if i wanted to block all users except those originating from one country, say america. i know i can download a IP file of all america IP addresses and have iptables deny all others. but how about a web2py method. any ideas, not necessarily IP based? thanx in advance, luca

[web2py] TypeError: an integer is required

Hi, I am using the follow to highlight a date field where the date is greater then the current date. db.stock_task.ESI_withhold_until_date.represent = lambda v,row: SPAN(datetime.date(v),_class='withhold' if v >datetime.date.today() else None) db.stock_task.ESI_withhold_until_date.represent = l