Re: [web2py] Re: Using T with IS_IN_DB

2011-07-17 Thread Kenneth Lundström
> how about: > db.t_status.f_name.represent=lambda f_name: T(f_name) Didn't do anything. Where should I put the row? I tried putting it before and after this line in controller: db.t_ticket.f_status.requires = IS_EMPTY_OR(IS_IN_DB(db(db.t_status.f_company == company_id), 't_status.id', '%(f_st

Re: [web2py] Re: Good jQuery UI Library

2011-07-17 Thread Phyo Arkar
Please do. Put it on Web2pyslice. I haven't play well it with either still hanging on with JQUI. On 7/17/11, pbreit wrote: > Getting back to the original question, it would be nice to figure out a good > option or two for more functional UI elements. JqUI seems like the obvious > choice but I am

[web2py] jquery problem with focus events

2011-07-17 Thread apple
This is a jquery question rather than a web2py question but I would be really grateful if someone could help with a problem that is driving me crazy. I have two forms. I want to submit a form automatically when it loses focus. I am doing this by capturing the focusin event and calling triggerHandl

[web2py] web2py_ajax.js - jQuery().html v DOM innerHTML issue

2011-07-17 Thread Paul Gerrard
Hi, Today, I upgraded my web2py version from 191.6 to 1.97.1 - all went well except where I had used the autocomplete jquery plugin on jquery dialog boxes. (I do thsi lots of times). Let me explain. 1. I create a dialog box using jquere dialog plug in 2. Then I use Web2py ajax to populate the div

Re: [web2py] Re: Getting a reproducible web2py internal error

2011-07-17 Thread ron_m
You should probably check permissions and ACLs all the way up the directory tree to the root of the drive. It is possible to apply an ACL in an upper level directory and with a check box option cause that permission to apply recursively to the whole file tree below.

[web2py] Re: web2py_ajax.js - jQuery().html v DOM innerHTML issue

2011-07-17 Thread Paul Gerrard
It now appears the ajax routine won't for me at all in some cases. It looks like it's not passing the value of the field in the second parameter to the POST to the server. Any ideas? Paul. On Jul 17, 4:24 pm, Paul Gerrard wrote: > Hi, > > Today, I upgraded my web2py version from 191.6 to 1.97.1

Re: [web2py] New python web framework: Brubeck

2011-07-17 Thread Phyo Arkar
Interesting but no thanks.. It have so many dependencies ... Mongrel2 = C , ZeroMQ = C Not portable anymore. On 7/17/11, Luther Goh Lu Feng wrote: > From the website http://brubeck.io/: > > Brubeck is a flexible Python web framework that aims to make the > process of building scalable web servi

[web2py] keeping focus after ajax response

2011-07-17 Thread apple
I can do everything ten times faster in web2py but then jquery seems to soak up all the time saved! I have two forms on a page loaded via "LOAD". I capture a change in focus from form1 to form2 and submit form1 via ajax. When the ajax response is received then form1 is replaced by the new version

[web2py] DAL: query sorted by calculated column ?

2011-07-17 Thread Sebastian E. Ovide
Hi All, is it possible to do something like this ? select num_yes, num_no, num_yes-num_no as tot from table order by tot thanks -- Sebastian E. Ovide

Re: [web2py] New python web framework: Brubeck

2011-07-17 Thread Vasile Ermicioi
> > Mongrel2: lean & fast, asynchronous web serving > Eventlet: non-blocking I/O & coroutines > ZeroMQ: fast messaging & supports most languages > DictShield: data modeling & validation with no database opinions > Mongrel2 = C , ZeroMQ = C I prefer *gevent *over *eventlet*, and I have my own

[web2py] Inner join on subselect

2011-07-17 Thread Álvaro J . Iradier
Hi, I have a table with a record of values read from a device. Table has a parameter ID, the record date, and the parameter value: db.define_table('param_values', Field('param', db.dev_parameter, required=True, notnull=True), Field('date', 'datetime', required=True, notnull=True), Fiel

[web2py] Re: New python web framework: Brubeck

2011-07-17 Thread Massimo Di Pierro
Is this different than the anyserver.py that ships with web2py and supports gevent? Did you try? If, necessary, can you send me a patch? On Jul 17, 3:22 pm, Vasile Ermicioi wrote: > > Mongrel2: lean & fast, asynchronous web serving > > Eventlet: non-blocking I/O & coroutines > > ZeroMQ: fast mess

[web2py] Re: Inner join on subselect

2011-07-17 Thread Álvaro J . Iradier
Sorry, the previous query was wrong, the "GROUP BY device" was left from a previous more complex example. So, I want to get an equivalent to: > SELECT p.param, p.date, p.value FROM param_values p INNER JOIN > (SELECT param, max(date) maxdate from param_values GROUP BY > param) m > ON m.param = p.p

[web2py] Re: DAL: query sorted by calculated column ?

2011-07-17 Thread howesc
i see 2 options: db.define_table('tabletest', Field('yes', 'integer'), Field('no', 'integer'), Field('tot', 'integer', compute=lambda r:r.yes-r.no)) will compute the value upon write and store it in the db, sort like any other field. or db.define_table('tabletest', Field('yes', 'integer'),

Re: [web2py] Re: New python web framework: Brubeck

2011-07-17 Thread Vasile Ermicioi
from gevent import pywsgi ("""A WSGI server based on :class:`StreamServer` that supports HTTPS.""") instead of from gevent import wsgi gevent.wsgi doesn't support streaming and ssl and I use an option spawn=Pool(96), it allows to limit the number of connections parser.add_option('-w',

Re: [web2py] Re: Inner join on subselect

2011-07-17 Thread Vasile Ermicioi
you can do that with only one query SELECT param, max(date) , value FROM param_values GROUP BY param HAVING date=max(date) _max_date = db.param_values.date.max() rows = db(db.param_values).select(db.param_values.param,_max_date, db.param_values.value, groupby=db.param_values.param, having=db.par

[web2py] Re: New python web framework: Brubeck

2011-07-17 Thread Massimo Di Pierro
:-) On Jul 17, 4:59 pm, Vasile Ermicioi wrote: > from gevent import pywsgi  ("""A WSGI server based on :class:`StreamServer` > that supports HTTPS.""") > instead of > from gevent import wsgi > > gevent.wsgi doesn't support streaming and ssl > > and I use an option spawn=Pool(96), > it allows to l

[web2py] Re: New python web framework: Brubeck

2011-07-17 Thread pbreit
Is there a benefit to using this sort of stuff instead of nginx + uwsgi.

Re: [web2py] Re: New python web framework: Brubeck

2011-07-17 Thread Vasile Ermicioi
uwsgi doesn't work on windows, gevent does and you can take advantage of greenthreads (greenlets, tasklets, microthreads) I use gevent for a crawler that runs on a windows machine and as a server for web2py to expose those data but on Linux I think uwsgi is the best option with whatever server yo

[web2py] multiselect widget not working in component.

2011-07-17 Thread Martin Barnard
I'm having problems displaying the multiselect widget inside components. I have two actions which do the same thing, basically give us a list of tags, with which to select our multiple tags: ### Model staff_tags=['this', 'is', 'a', 'tag'] db.define_table('test_tagging', Field('tags', 'li

[web2py] Load view or controllers without load

2011-07-17 Thread Roberto Perdomo
Hi, i have problems loading powertables with LOAD and I wonder if there is a way to get from one view to another controller without using LOAD or view as hereby POWERTABLES tables do not work properly. Mainly I like to charge two or three tables from a controller in a view. thanks in advance

Re: [web2py] Load view or controllers without load

2011-07-17 Thread Bruno Rocha
I guess I can help you with this. In this case powertable needs to load java script via response.js Can you send a code or an app as example to reproduce the problem? http://zerp.ly/rochacbruno Em 17/07/2011 23:31, "Roberto Perdomo" escreveu: > Hi, i have problems loading powertables with LOAD a

[web2py] Re: Inner join on subselect

2011-07-17 Thread Álvaro J . Iradier
At first I thought this was exactly what I was looking for... but after trying, sorry, but this query doesn't work for me... it returns 0 records, while the previous one is returning the right number. It looks like the GROUP BY selects one of the dates (the first record found) for the grouping, the