[web2py] Alternative to reCaptcha?

2014-03-25 Thread Marco Mansilla
Hi, I've been looking for some alternative to *Captcha, and so far I haven't found somethig original... until now, this[0] looks interesting, and seems not to be hard to use. Any ideas about if is possible to integrate it with SQLFORM? [0] https://github.com/josscrowcroft/MotionCAPTCHA Thanks in

[web2py] Re: Tree stuctured layout problem

2014-03-25 Thread Massimo Di Pierro
I cannot reproduce it. There is a {{block head}}{{end}} just before in 2.9.5. Could you email me a minimalist app to reproduce it? On Tuesday, 25 March 2014 21:49:35 UTC-5, Joe Barnhart wrote: > > Web2py's tree structured layout seems to fall short in one area. I do not > know if this is a bug

[web2py] Re: Session.forget(response) with apache2

2014-03-25 Thread Massimo Di Pierro
can you explain what you mean by it is not working? On Tuesday, 25 March 2014 16:11:59 UTC-5, Sushma K wrote: > > Hi > i am experiencing problem with session.forget(response). It is working > perfectly with default web2py server on ajax calls. However it is not > working with ubuntu+web2py+apac

[web2py] Re: boolean field type in a query.

2014-03-25 Thread Tim Richardson
I'm a little bit rusty on booleans, but I think from memory: a) exactly what value is stored in the field depends on the backend, but the DAL always works with True and False but b) you can also end up with NULL if you're not careful, and NULL is not necessarily the same as False. so make sure y

[web2py] Remove query db field

2014-03-25 Thread xgp . latino
Hi all. As mostly may know, when doing a select query the result will show a db field title for each column. How do i remove or change this db field title for some nice header as use with smartgrid.? Thanks. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http:

[web2py] Re: Can I query muliitple legacy databases?

2014-03-25 Thread Brian M
Please be sure to read the DAL section of the online web2py book it will explain a lot of this. When you use executesql you can choose how to see the results the as_dict means you can address fields/columns as dict keys or you can also use the fields & colnames options to get objects just like

[web2py] Re: Can I query muliitple legacy databases?

2014-03-25 Thread learning
Thanks. But if I do that doesn't that mean I can't use the results as "objects"? Isn't that the reason for the DAL and ORM (does it have an ORM)? How do I handle the values? I'd also have to insert data. For a select, you have, from the docs, as_dict=True. I'm new to Python. Can you show

[web2py] Session.forget(response) with apache2

2014-03-25 Thread sushma . amul098
Hi i am experiencing problem with session.forget(response). It is working perfectly with default web2py server on ajax calls. However it is not working with ubuntu+web2py+apache2+mod_wsgi. Can you please help me to resolve this. Thanks -- Resources: - http://web2py.com - http://web2py.com/bo

[web2py] Re: Virtual Fields and Smartgrid not working as expected

2014-03-25 Thread Carlos Alba
Hello, I am working with *2.9.5-stable+timestamp.2014.03.16.02.35.39* and getting > Query Not Supported: 'str' object is not callable message I wonder if this issue is fixed or I am missing something. BTW, I am just starting my web2py process. King regards to all web2py community. On Thurs

[web2py] Tree stuctured layout problem

2014-03-25 Thread Joe Barnhart
Web2py's tree structured layout seems to fall short in one area. I do not know if this is a bug, or if it is "working as designed"... I'm trying to bring order to the chaos that is my layout.html file. I wanted to break it into reasonable sections so I could manage each separately instead of

[web2py] Re: janrain and web2py

2014-03-25 Thread Joe Barnhart
To be honest, the price model of Janrain is way too prohibitive. If my site gets popular I'll be spending hundreds on the Janrain service -- it would become my most expensive service besides merchant services (a.k.a. credit card fees)! The free version is limited to 2500 users, which I will b

[web2py] Re: boolean field type in a query.

2014-03-25 Thread 黄祥
i think you can achieve it with true (1) or false (0) value e.g. my_tests_list = db((db.t_tests.created_by == auth.user.id) & (db.t_tests.f_test_is_a_clone == 0) ).select() best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2p

[web2py] boolean field type in a query.

2014-03-25 Thread Avi A
Hi, i have a table with a boolean field: Field('f_test_is_a_clone', type='boolean', label=T('Test is a clone')), And this is the query, where I don't want to return cloned tests: my_tests_list = db((db.t_tests.created_by == auth.user.id) & (not db.t_tests .f_test_is_a_clone)).select()

Re: [web2py] Re: Ckeditor plugin - Update ckeditor

2014-03-25 Thread Tim Richardson
try this https://github.com/timrichardson/web2py_ckeditor4/releases/download/R-0.3/web2py.plugin.ckeditor.w2p -- 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: Ckeditor plugin - Update ckeditor

2014-03-25 Thread Tim Richardson
I think I am seeing all plugins ... that's my screen shot above (although I had to delete my browser cache before it would display properly). That's with the "full"

Re: [web2py] Re: janrain and web2py

2014-03-25 Thread Michele Comitini
Quint has done all the hard work for web2py: https://code.google.com/p/w2p-social-auth/ 2014-03-25 22:24 GMT+01:00 Michele Comitini : > I think we should switch to this: https://github.com/omab/python-social-auth > > > 2014-03-25 21:37 GMT+01:00 Anthony : >> Janrain + Google seems to work fine o

Re: [web2py] Re: janrain and web2py

2014-03-25 Thread Michele Comitini
I think we should switch to this: https://github.com/omab/python-social-auth 2014-03-25 21:37 GMT+01:00 Anthony : > Janrain + Google seems to work fine on web2py 2.5.1. I am having a different > problem with Janrain, though. In IE 10 and 11 on Windows 8.1, login doesn't > work with any provider.

[web2py] Re: janrain and web2py

2014-03-25 Thread Anthony
Janrain + Google seems to work fine on web2py 2.5.1. I am having a different problem with Janrain, though. In IE 10 and 11 on Windows 8.1, login doesn't work with any provider. When the pop-up window goes to a URL like this: https://appname.rpxnow.com/xdcomm#opener;0:%7B%22stat%22:%20%22ok%22,%

Re: [web2py] janrain and web2py

2014-03-25 Thread Albert Abril
In my case, I didn't used it. In case I needed to use oauth, I used https://github.com/r4bugento/web2social with some custom modifications, (because in the cases I needed oauth, I was asked to avoid third-party services for login). On 25 March 2014 18:30, Massimo Di Pierro wrote: > Any janrain u

[web2py] Re: How to use AJAX within a SQLFORM.grid 'add' form

2014-03-25 Thread backseat
> > Bump...is is possible to use AJAX in a SQLFORM.grid Add form? > -- 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

Re: [web2py] Re: Ckeditor plugin - Update ckeditor

2014-03-25 Thread Tim Richardson
Hi, did you get the .w2p file from github? https://github.com/timrichardson/web2py_ckeditor4/releases/download/R-0.2/web2py.plugin.ckeditor.w2p I just a second ago updated web2py slices with the new version. On Tuesday, 25 March 2014 20:45:07 UTC+11, Gael Princivalle wrote: > > Well I've tried

[web2py] janrain and web2py

2014-03-25 Thread Massimo Di Pierro
Any janrain users? Some users have reported that janrain no longer works with google login. I have experience the same problem. In December (version 2.9.x) we moved to the new Janrain API. I looked into this and the and the new API require a different and more complex configuration on the janra

[web2py] Re: response.toolbar() does not show statistics for some tables

2014-03-25 Thread Maciej S
I found the reason. It was because of my own caching mechanism, which prevented executesql from executing. Thanks for help! W dniu poniedziałek, 24 marca 2014 18:45:59 UTC+1 użytkownik Massimo Di Pierro napisał: > > Please submit a bug report. It is possible executesql does not log it. > > On Mo

[web2py] Convert Mysql query with subquery to DAL.

2014-03-25 Thread brahama von
Hi guys, Trying to convert this select t.id, t.gp_pro_id, t.gp_historicdate from course t where t.gp_historicdate = (select MAX(a.gp_historicdate) from course a where a.id = t.id) Any help is appreciated. Thanks! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - h

Re: [web2py] Re: before_update callback and sheduler

2014-03-25 Thread Carlos Cesar Caballero Díaz
Thank you!! thats why I was thinking that callback was not called, I check and the index is growing, but search functions allways return a null query. El 24/03/14 18:13, Niphlod escribió: Working fine here: steps to reproduce: - install whoosh - create a fresh app - overwrite fresh app wit

[web2py] Re: G-event vs. Redis (?)

2014-03-25 Thread Arnon Marcus
Update : So, I did a little further testing - turns out that if I *don't use chaussette*, and instead call *anyserve.py* directly, then everything works smoothly with both g-event and redis: [watcher:gevent] > working_dir = /srv/web2py > cmd = python anyserver.py -s gevent However, I then loos

[web2py] Re: jQuery load no longer working

2014-03-25 Thread horridohobbyist
Sorry, bad transcription. The original code had the correct parentheses. Anyway, I found out what was wrong. I was trying to incorporate colorbox (a variation of jQuery's lightbox) and I included a different jquery.min.js. Apparently, this conflicted with web2py's jQuery. On Tuesday, 25 March

Re: [web2py] Free web2py hosting for a free software web2py application

2014-03-25 Thread Philip Kilner
Hi Pablo, On 25/03/14 11:14, Pablo Angulo wrote: > I tried pythonanywhere and it could work, but I'd have to write code to > mold into the limitations of that hosting and accept that a few things > wouldn't work: do you still offer your spare hosting space? You'd need > to install the following pa

[web2py] Re: Problem with compute field

2014-03-25 Thread Joe Barnhart
Found it. It was an "open circuit" between the keyboard and chair, as usual. The lambda computes the year of the swim meet, offset by 122 days (because their seasons begin on Sept 1 instead of Jan 1). However in my haste I typed "date" as the last method called, not "year". Oops. Datetime.y

Re: [web2py] Free web2py hosting for a free software web2py application

2014-03-25 Thread Pablo Angulo
Dear Philip: I tried pythonanywhere and it could work, but I'd have to write code to mold into the limitations of that hosting and accept that a few things wouldn't work: do you still offer your spare hosting space? You'd need to install the following packages. |sudo apt-get install latex-xco

[web2py] Re: default value in Options Widget

2014-03-25 Thread Prem
Hi Stifan, When we set using zero='opt1' it adds 'opt1' as default text and when we look at the options in the form loaded it has ['opt1','opt1','opt2','opt3'] I am looking for more like setting 'opt1' as selected On Tuesday, 25 March 2014 13:06:13 UTC+11, 黄祥 wrote: > > had you already tri

Re: [web2py] Re: .json in url does not like "contruções"

2014-03-25 Thread António Ramos
done json.dumps({'name': var*.decode('utf8')*[:18], 'value': 1}) 2014-03-24 14:58 GMT+00:00 Iuri Guilherme dos Santos Martins < aindatenhoco...@gmail.com>: > My guess is that the function is probably receiving this string: "FOPIC > - Constru\\u" > > When it tries to convert the unicode charac

Re: [web2py] Re: Ckeditor plugin - Update ckeditor

2014-03-25 Thread Gael Princivalle
Well I've tried now on another computer with Chrome/IE/Firefox and the problem still the same, a lot of plugins are not displayed: [image: Immagine in linea 1] For example the text color picker. 2014-03-25 9:37 GMT+01:00 Tim Richardson : > Actually, I just came back here to ask you to try to ne

[web2py] G-event vs. Redis (?)

2014-03-25 Thread Arnon Marcus
So, we came to the conclusion that combining the use of G-event as the server, and redis for caching, injects instabilities, with random hangings and crashing requests: I ruled-out the factor of using 0.13.x versions of G-event vs. the 1.x release - it happens in both cases. I ruled-out using re

[web2py] Re: Ckeditor plugin - Update ckeditor

2014-03-25 Thread Tim Richardson
Actually, I just came back here to ask you to try to new release. I commented out that javascript, it seems to work now but you may need to reload your browser cache -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - ht

[web2py] auth.wiki Tagcloud show only the first 20 items

2014-03-25 Thread Oli
In the auth.wiki Tagcloud only the first 20 items displayed. Is there a possibility to change the value? -- 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) -

[web2py] custom auth table that work in earlier version but not in recent version

2014-03-25 Thread 黄祥
hi, i have custom auth table that work in earlier version but not in recent version. e.g. create new application and then add this code *models/db.py* db._common_fields.append(auth.signature) # work if commented # create table : bank db.define_table('bank', Field('bank'), format = '%(bank)s')