[web2py] Re: pygal and SQL.form

Hi Try separate function for form & chart and in the view/form.html you can use function {{ =LOAD('chart', ...) }} or You can embedded python chart code into form.html for example: {{ import pygal from pygal.style import DefaultStyle from pygal import Config config = Config()

[web2py] Re: Dynamic Search

Hi what I mean is to have results so they can be either emailed or printed? On Thursday, 21 January 2016 08:48:08 UTC+11, Anthony wrote: > > What do you mean by "have the results to be a post"? > > On Sunday, January 17, 2016 at 3:16:11 PM UTC-5, Anthony Smith wrote: >> >> Hi All, >> >> I am

Re: [web2py] Virtual field in SQLFORM.grid

I could make it work. Changed the virtual field from: Field.Virtual('total', lambda row: row.trabalho.konsulta.count()), To: Field.Virtual('total', lambda row: db((db.konsulta.trabalho_id== row.trabalho.id)).count()) Both fields work in the shell, but just the second works in the grid... Can

[web2py] Why are the fields not hiding when using ajax for the forms? Look below.

Anthony I can sense your presence. Please help me asap. -- 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

[web2py] Re: Why are the fields not hiding when using ajax for the forms? Look below.

Hard to say. Is there in fact a "user_id" field in the db.bottle table? If so, is it the auto-incrementing id field for the table? If not, then it shouldn't be appearing at all, as it is not in your "fields" list. Please show your table definition and make sure the code you are showing is the

[web2py] Re: charts on web2py

Try pygal.org very easy. เมื่อ วันพุธที่ 20 มกราคม ค.ศ. 2016 23 นาฬิกา 04 นาที 43 วินาที UTC+7, Diego Tostes เขียนว่า: > > Hi, > > anyone can indicate a good solution to create charts using web2py? > > rgds > > diego > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation)

Re: [web2py] charts on web2py

Do you know that plotly was open sourced : https://plot.ly/ I it one of your best choice if you want something dynamic... There is D3.js, but I remember having read that most of it is included in the plotly stack... Richard On Wed, Jan 20, 2016 at 11:04 AM, Diego Tostes

Re: [web2py] Virtual field in SQLFORM.grid

In other words... Is there a way to show a total of the child table in each row of the master table (grid) ?? Thanks On Tuesday, January 19, 2016 at 5:52:51 PM UTC-2, Marcello wrote: > > Yes. I can see the tables... > And yes... I can call the function.. It's working OK... > > Thanks... > >

Re: [web2py] Re: Deploying in Windows server and SSL (no IIS)

Don't use self-signed certificate, walk the extra mile of creating your own Certificate Authority, which will be self signed, then sign you certificate... That way you will get rid of all browser warning... You can then push by GPO a pk12 file so your user don't even have to handle the certificate

[web2py] charts on web2py

Hi, anyone can indicate a good solution to create charts using web2py? rgds diego -- 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

[web2py] Re: Why my snippet for new button from the controller not working?

URL('default', 'index', extension=None) On Wednesday, January 20, 2016 at 3:15:17 PM UTC+1, aston...@gmail.com wrote: > > it takes me to default/index.load which is wrong. I should be going to > default/index. > :( > > On Wednesday, January 20, 2016 at 7:31:47 PM UTC+5:30, Niphlod wrote: >> >>

Re: [web2py] charts on web2py

Hi For simple charts you can use google chart, exist plugin for integrate this http://www.web2pyslices.com/slice/show/1721/google-charts-plugin On Wed, Jan 20, 2016 at 3:09 PM, Richard Vézina wrote: > Do you know that plotly was open sourced : https://plot.ly/

Re: [web2py] charts on web2py

Also matplotlib, of course... Richard On Wed, Jan 20, 2016 at 2:02 PM, Javier Pepe wrote: > Hi > > For simple charts you can use google chart, exist plugin for integrate this > > http://www.web2pyslices.com/slice/show/1721/google-charts-plugin > > > > On Wed, Jan 20, 2016

[web2py] Re: Deploying in Windows server and SSL (no IIS)

if you followed that guide, python will be started automatically by IIS. That's part of the beauty of it. On Wednesday, January 20, 2016 at 6:45:55 PM UTC+1, José Eloy wrote: > > Then, How I should run web2py? > > python web2py.py -a 'yourpassword' -i IP > > without port? > > > Regards > --

[web2py] Get return value from controller function via ajax

I'm trying to use ajax calls to update the data for a chart dynamically. I don't want to make the chart a component that refreshes, I just want to get the controller return value back to the javascript in the view, so that I can update the chart via javascript. But web2py's ajax function seems

[web2py] Re: Get return value from controller function via ajax

from gluon.serializers import json def uh(): return json(blablabla) On Wednesday, January 20, 2016 at 8:45:55 PM UTC+1, Ian W. Scott wrote: > > I'm trying to use ajax calls to update the data for a chart dynamically. I > don't want to make the chart a component that refreshes, I just want

[web2py] Re: Dynamic Search

Hi All, I am guessing this cant be done or I have asked a stupid question Cheers Anthony On Monday, 18 January 2016 07:16:11 UTC+11, Anthony Smith wrote: > > Hi All, > > I am using the dynamic search ( > http://www.web2pyslices.com/slice/show/1403/dynamic-search), is it > possible to have

Re: [web2py] charts on web2py

Richard, any workable example that you know of matplotlib? On Wednesday, January 20, 2016 at 2:14:10 PM UTC-5, Richard wrote: > > Also matplotlib, of course... > > Richard > > On Wed, Jan 20, 2016 at 2:02 PM, Javier Pepe > wrote: > >> Hi >> >> For simple charts you can use

[web2py] Re: Scheduler Tasks show TICKER: error assigningt task (0) and task never start

all of the sudden or you just started it ? On Wednesday, January 20, 2016 at 9:38:11 PM UTC+1, Marcelo Huerta wrote: > > I'm having the same issue with a PostgreSQL 9.4 backend on Windows 7. >> > > Python 2.7.10 (32 bits) > web2py: Version 2.13.4-stable+timestamp.2015.12.26.04.59.39 > > >

Re: [web2py] charts on web2py

Not try but : http://www.web2pyslices.com/slice/show/1357/matplotlib-howto It's basically just a matter of streaming the content of a file generated by you matplotlib python script, this is not a big deal... Richard On Wed, Jan 20, 2016 at 3:12 PM, Ron Chatterjee

Re: [web2py] Re: Get return value from controller function via ajax

Simone, Since simplejson have be exit, and standard lib json it reputed multifold time slower what are you suggesting as a remedy? Richard On Wed, Jan 20, 2016 at 2:50 PM, Niphlod wrote: > from gluon.serializers import json > > def uh(): > return json(blablabla) > > >

Re: [web2py] Scheduler Tasks show TICKER: error assigningt task (0) and task never start

well, don't know what to say without seeing your app's code. The thing is, that kind of error is pretty "down the line" and usually is given by a wrong table structure or a completely locked down database. if you use another DAL connection (e.g., just to try, sqlite) does it raise the same

Re: [web2py] Re: Get return value from controller function via ajax

I suggest a good pair of goggles . https://github.com/web2py/web2py/tree/R-2.13.4/gluon/contrib/simplejson On Wednesday, January 20, 2016 at 10:05:17 PM UTC+1, Richard wrote: > > To my knowlege simplejson contrib was there because of standard json lib > was too slow... > > Richard > > On

Re: [web2py] Re: Get return value from controller function via ajax

https://groups.google.com/d/msg/web2py-developers/2U-4hnwjc60/9LvGVn_P2VYJ You are right I am having it... I guess I shouldn't believe everything what I read... :) Thanks to clarify that... I should check my code since the issue I was having get solved by another concurrent change which may was

Re: [web2py] Scheduler Tasks show TICKER: error assigningt task (0) and task never start

Niphlod decía, en el mensaje "[web2py] Re: Scheduler Tasks show TICKER: error assigningt task (0) and task never start" del 20/1/2016 17:42:40: > all of the sudden or you just started it ? No, I just incorporated the Scheduler to my application. Previously I wasn't using it. It never worked from

Re: [web2py] Re: Get return value from controller function via ajax

I really don't know what you meant (ontopic or offtopic) On Wednesday, January 20, 2016 at 9:49:58 PM UTC+1, Richard wrote: > > again what, off topic, ever!! > > :) > > Richard > > On Wed, Jan 20, 2016 at 3:43 PM, Niphlod > wrote: > >> ehm.. what again ? >> >> On

Re: [web2py] Re: Get return value from controller function via ajax

I mean, before in gluon/contrib there were simplejson, but I notice it had been removed in 2.10.x if I remember because it was not py3 compliant... I discover it hadly when my production app shown some strange behavior in some search field or autocomplete field where I was using it... I did't

Re: [web2py] Re: Dynamic Search

To my knowledge crud.search() does just that with all the overhead... Richard On Wed, Jan 20, 2016 at 3:09 PM, Anthony Smith wrote: > Hi All, > > I am guessing this cant be done or I have asked a stupid question > > Cheers > > Anthony > > > On Monday, 18 January

[web2py] Re: Get return value from controller function via ajax

Thanks. So to clarify, if I serialize the return value as json in the controller, then I can use it in javascript. It looks like I still have to parse the json on the javascript end (like $.parseJSON(mydata)) but it works like a charm. Ian On Wednesday, January 20, 2016 at 2:50:35 PM UTC-5,

Re: [web2py] Re: Get return value from controller function via ajax

Yes always better to parse it... On Wed, Jan 20, 2016 at 4:20 PM, Ian W. Scott wrote: > Thanks. So to clarify, if I serialize the return value as json in the > controller, then I can use it in javascript. It looks like I still have to > parse the json on the javascript end

[web2py] Re: Scheduler Tasks show TICKER: error assigningt task (0) and task never start

> > I'm having the same issue with a PostgreSQL 9.4 backend on Windows 7. > Python 2.7.10 (32 bits) web2py: Version 2.13.4-stable+timestamp.2015.12.26.04.59.39 2016-01-20 17:34:33,809 - web2py.scheduler.RALF#2436 - ERROR - TICKER: error assigning tasks (0) 2016-01-20 17:34:34,312 -

Re: [web2py] Re: Get return value from controller function via ajax

ehm.. what again ? On Wednesday, January 20, 2016 at 9:36:01 PM UTC+1, Richard wrote: > > Simone, > > Since simplejson have be exit, and standard lib json it reputed multifold > time slower what are you suggesting as a remedy? > > Richard > > On Wed, Jan 20, 2016 at 2:50 PM, Niphlod

Re: [web2py] Re: Get return value from controller function via ajax

again what, off topic, ever!! :) Richard On Wed, Jan 20, 2016 at 3:43 PM, Niphlod wrote: > ehm.. what again ? > > On Wednesday, January 20, 2016 at 9:36:01 PM UTC+1, Richard wrote: >> >> Simone, >> >> Since simplejson have be exit, and standard lib json it reputed

Re: [web2py] Re: Get return value from controller function via ajax

To my knowlege simplejson contrib was there because of standard json lib was too slow... Richard On Wed, Jan 20, 2016 at 4:04 PM, Richard Vézina wrote: > I mean, before in gluon/contrib there were simplejson, but I notice it had > been removed in 2.10.x if I

[web2py] Re: Get return value from controller function via ajax

the deal is basically that if you return a dict, web2py is compelled to pass it to the corresponding view, which in turns in most of cases returns html. There's nothing wrong in returning a dict and then having a generic "json" view that serializes that dict, and as a matter of fact,

[web2py] Re: Dynamic Search

What do you mean by "have the results to be a post"? On Sunday, January 17, 2016 at 3:16:11 PM UTC-5, Anthony Smith wrote: > > Hi All, > > I am using the dynamic search ( > http://www.web2pyslices.com/slice/show/1403/dynamic-search), is it > possible to have the results to be a post, if so do I

Re: [web2py] charts on web2py

I agree. Thank you!:-) On Wednesday, January 20, 2016 at 3:31:49 PM UTC-5, Richard wrote: > > Not try but : http://www.web2pyslices.com/slice/show/1357/matplotlib-howto > > It's basically just a matter of streaming the content of a file generated > by you matplotlib python script, this is not a

[web2py] Re: Deploying in Windows server and SSL (no IIS)

Then, How I should run web2py? python web2py.py -a 'yourpassword' -i IP without port? Regards -- 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

[web2py] Re: Get return value from controller function via ajax

Additionally, if you still want to use the ajax() function, the third argument can be ":eval", in which case, you can return some Javascript code to be executed when the response is returned. Alternatively, the third argument can be an actual Javascript function, in which case, the returned

[web2py] Re: Deploying in Windows server and SSL (no IIS)

Niphlod: You are right! IIS is now serving my web2py pages! Thanks! A question: If I create a directory under wwwroot (let's say web2pyapps) and move my web2py app, I readed the manual and say this: - move the code to a subfolder named web2pyapps - create a routes.py file with routers =

[web2py] Re: Deploying in Windows server and SSL (no IIS)

Richard: Could you show me how to generate my own Certificate Authority and my own certificate? Regards -- 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) ---

Re: [web2py] Re: server function not triggered in some cases

The issues solved with a great help of Niphlod. I answered my own question on stackoverflow. please correct if it is not correct http://stackoverflow.com/questions/34661782/web2py-function-not-triggered-on-user-request/34895532#34895532 Thank you On Monday, January 18, 2016 at 1:54:48 PM

[web2py] Re: DAL calls fail after first stored procedure call

I have exactly the same issue. Call a procedure once and works. Call another procedure again, returns None and from this point on, simple db(..).select() are broken. Its definetly a DAL issue since using mysql connector does works well. This is an example: Download mysql connectors

[web2py] Re: Edit form style

I made the necessary changes to the "formstyle_bootstrap3_inline_factory" function in sqlhtml.py but they are not applied to the form when it is presented to in the browser. What am I missing here? Thank you. On Monday, January 18, 2016 at 10:36:51 AM UTC+2, desta wrote: > > Denes, indeed that

[web2py] Re: DAL calls fail after first stored procedure call

Ive solved it by creating a function as: def callproc(name, args): cur = db._adapter.cursor cur.callproc(name, args) if hasattr(cur, "stored_results"): for r in cur.stored_results(): return r.fetchall() else: return cur.fetchall() Im not sure if its

[web2py] Re: Deploying in Windows server and SSL (no IIS)

if you followed the manual (http://web2py.com/books/default/chapter/29/13/deployment-recipes#IIS) for deploying web2py behind iis, your app is served by IIS directly on whichever port IIS is configured to listen on. If that port is set to be ssl protected (usually the *:443 binding) then you

[web2py] Re: web3py

All option are good, the important is to have python 3 compatibility!! Il giorno giovedì 14 gennaio 2016 06:35:36 UTC+1, Massimo Di Pierro ha scritto: > > It is another experiment. > > It is a rewrite of some of the web2py modules and supports 90% of the > current web2py syntax at 2.5x the

Re: [web2py] Encoding while reading postgres data

In this case I get the list of string users = [u'Ga\u0161peri\u010d', u'GovednikK', u'Jam\u0161ek', u'Jurejev\u010di\u010d', u'Kati\u0107', u'Kostelec', u'Ko\u0161ele', u'Male\u0161i\u010d', u'Muhi\u010d', u'Re\u017eek', u'Sitar', u'Toma\u017ei\u010d', u'Viktorovski', u'Vuk\u0161ini\u010dD',

[web2py] nginx/uwsgi problem on Debian

The combination uwsgi/nginx has been recommended often on this list. After an upgrade from wheezy to jessy the nginx, uswgi-combination does not play nicely together. We have also tried to move the socket to tmp, but that did not change anything in as far as the refused connection is concerned.

[web2py] Why my snippet for new button from the controller not working?

cancel=INPUT(_type='button' , _value='Cancel' , _onclick= URL('default','index')) -- 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

Re: [web2py] Re: Web2py Integration with Sentry

James, Massimo, is there any news over a possible patch for sentry with web2py i.e. WSGI middleware? Op donderdag 16 januari 2014 19:00:13 UTC+1 schreef James Q: > > Great. I won't be able to get to this soon, but I assume the standard > process: git clone, make change and make a pull request?

Re: [web2py] Re: server function not triggered in some cases

perfect. Glad that everything is working fine. On Wednesday, January 20, 2016 at 10:02:04 AM UTC+1, Yebach wrote: > > The issues solved with a great help of Niphlod. I answered my own question > on stackoverflow. > > please correct if it is not correct > > >

[web2py] Re: Why my snippet for new button from the controller not working?

_onclick should be at the very least a piece of javascript. You're just passing an URL. On Wednesday, January 20, 2016 at 1:50:11 PM UTC+1, aston...@gmail.com wrote: > > > cancel=INPUT(_type='button' , _value='Cancel' , _onclick= > URL('default','index')) > -- Resources: - http://web2py.com

[web2py] Re: How do I make my web2py app able to use the device hardwares like camera?

For camera try opencv, it has a nice python library Il giorno domenica 17 gennaio 2016 18:05:50 UTC+1, henryj...@gmail.com ha scritto: > > also how to make it able to use some other apps on the device? > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

Re: [web2py] Re: nginx/uwsgi problem on Debian

As Simone says, it seems clear that it come from permission... Which user is regular "web" user under debian, www-data? Even if it not the main issue, I would rather start debuging and make work the 80 port before trying 443... First link if I google the bind() error :

Re: [web2py] Encoding while reading postgres data

Solved the problem I posted on stackoverflow.com http://stackoverflow.com/questions/34596573/javascript-string-encoding-on-client vote up or correct if it is not ok On Wednesday, January 20, 2016 at 3:41:13 PM UTC+1, Richard wrote: > > You need XML() web2py helper when you pass python string

Re: [web2py] Encoding while reading postgres data

You need XML() web2py helper when you pass python string or generate js code from python you need it... In the view : {{=XML(python_var_containing_text_or_js_code}} Richard On Wed, Jan 20, 2016 at 4:52 AM, Yebach wrote: > In this case I get the list of string > > users =

[web2py] Re: Why my snippet for new button from the controller not working?

Well thanks for pointing out that Niphlod. So how should I correct it? On Wednesday, January 20, 2016 at 6:57:57 PM UTC+5:30, Niphlod wrote: > > _onclick should be at the very least a piece of javascript. You're just > passing an URL. > > On Wednesday, January 20, 2016 at 1:50:11 PM UTC+1,

[web2py] Why are the fields not hiding when using ajax for the forms? Look below.

this is what my controller reads: def index(): return locals() def add_bottle(): form=SQLFORM(db.bottle, 3 , deletable=True, fields = ['request_expiryDate']).process() return locals() this is what my default/index.html reads: {{extend 'layout.html'}} {{=LOAD('default',

[web2py] pygal and SQL.form

Hi Guys, I try to use pygal to draw some charts and it works fine. I used example from: http://www.web2pyslices.com/slice/show/1634/beauty-graphics-and-charts-with-pygal However i don't know how to display SQL.form and pygal chart in one view. My code def form_and_chart(): chart =

[web2py] Re: nginx/uwsgi problem on Debian

apart from being a clear "not-even-close-to-web2py" error, until you can get rid of uwsgi socket 0 bound to UNIX address /var/uwsgi/app/web2py/socket fd 3 bind(): Permission denied [core/socket.c line 227] you'll never going to solve the problem. Make sure you create a valid dir with the

[web2py] Re: Web2py Integration with Sentry

Sorry, I ended up not using web2py so I never got to this :( On Monday, January 6, 2014 at 10:14:46 PM UTC-5, James Q wrote: > > Has anyone ever integrated web2py an Sentry ( > https://github.com/getsentry/sentry)? I would like it if all web2py > generated exceptions generate a ticket like

[web2py] Re: Why my snippet for new button from the controller not working?

uhm. maybe window.location='%s' % URL('default', 'index') ? On Wednesday, January 20, 2016 at 2:37:26 PM UTC+1, aston...@gmail.com wrote: > > Well thanks for pointing out that Niphlod. So how should I correct it? > > On Wednesday, January 20, 2016 at 6:57:57 PM UTC+5:30, Niphlod wrote: >> >>

[web2py] Re: Why my snippet for new button from the controller not working?

it takes me to default/index.load which is wrong. I should be going to default/index. :( On Wednesday, January 20, 2016 at 7:31:47 PM UTC+5:30, Niphlod wrote: > > uhm. maybe > > window.location='%s' % URL('default', 'index') > > ? > > On Wednesday, January 20, 2016 at 2:37:26 PM UTC+1,