[web2py] Re: Query results from 2 children tables from same parent ordered by date

2012-12-21 Thread Mamisoa Andriantafika
I actually need to display those coalesce dates out of SQLTABLE that I use in view. To be precise, I need to show in LI(date, LI(all parameters)). --

Re: [web2py] Possible bug in JSONRPC in v2.3.2

2012-12-21 Thread Bruno Rocha
On Sat, Dec 22, 2012 at 3:57 AM, Mike D wrote: > s = methods[method](**params) I guess it should be s = methods[method](*args, **params) to be more flexible --

[web2py] Possible bug in JSONRPC in v2.3.2

2012-12-21 Thread Mike D
Hi, I recently updated to v2.3.2 and noticed that my JSONRPC calls were failing with a message of "argument after ** must be a mapping, not str". After investigating some changes in the versions I noticed that in tools.py, in the serve_jsonrpc() function, the following line changed from: s = m

Re: [web2py] Interesting - Brython (python to javascript)

2012-12-21 Thread Massimo Di Pierro
Thanks for letting us know. Are you one of the brython developers? On Friday, 21 December 2012 15:20:28 UTC-6, Francois Dion wrote: > > If you have had issues with these, you should report the bugs, because It > does support string interpolation, modules and scope. List comprehension > and the t

Re: [web2py] How to check if plain text password matches with encrypted password in auth_user.password?

2012-12-21 Thread Jonathan Lundell
On 21 Dec 2012, at 5:37 PM, Pearu Peterson wrote: > Thanks for the hint! > > The following expression works for me: > > db.auth_user.password.validate(plain_password) == > (db(db.auth_user.id==auth.user_id).select ().first ().password, None) Good. There's probably a shortcut in Auth, too, th

Re: [web2py][outsource] Need a plugin that integrate jsTree or other tree plugin with closure table app

2012-12-21 Thread Richard Vézina
I try it, it works, but I am not sure if the JsTree is fully supported. I will, investigate on this in near future (in next 2 mounths maybe). Richard On Fri, Dec 21, 2012 at 3:10 PM, wwwgong wrote: > ch is based on Nested Set --

[web2py] Cron every 5 seconds.

2012-12-21 Thread FERNANDO VILLARROEL
Dear. I need refresh my index every 5 seconds. I think to use cron, so how i can call a controller (controller/myfunction) every 5 seconds? Regards. Fernando. --

Re: [web2py] How to check if plain text password matches with encrypted password in auth_user.password?

2012-12-21 Thread Pearu Peterson
Thanks for the hint! The following expression works for me: db.auth_user.password.validate(plain_password) == (db(db.auth_user.id==auth.user_id).select ().first ().password, None) Thanks again, Pearu On Saturday, December 22, 2012 3:25:00 AM UTC+2, Jonathan Lundell wrote: > > On 21 Dec 2012

Re: [web2py] How to check if plain text password matches with encrypted password in auth_user.password?

2012-12-21 Thread Jonathan Lundell
On 21 Dec 2012, at 5:12 PM, Pearu Peterson wrote: > Hi, > > I have a password in plain text and I want to check if it matches with the > crypted password in auth_user.password field. > > I have tried comparing auth_user.password with > str(db.auth_user.password.validate(plain_password)[0]) wit

[web2py] How to check if plain text password matches with encrypted password in auth_user.password?

2012-12-21 Thread Pearu Peterson
Hi, I have a password in plain text and I want to check if it matches with the crypted password in auth_user.password field. I have tried comparing auth_user.password with str(db.auth_user.password.validate(plain_password)[0]) with no success even when I know that the passwords match exactly.

[web2py] Re: 2.2.1 left joins broken?

2012-12-21 Thread Massimo Di Pierro
It is correct in the sense it is what I intended it to be. You are proposing a change of behavior. I see where you are coming from. Please open a ticket about this. I would like to have some more opinions about this. Should None in is_active be treated as True? On Friday, 21 December 2012 14:

Re: [web2py] Interesting - Brython (python to javascript)

2012-12-21 Thread Francois Dion
If you have had issues with these, you should report the bugs, because It does support string interpolation, modules and scope. List comprehension and the ternary operator have been added earlier this week. Classes is the main thing left. I started using brython in a limited deployment. I think

[web2py] smartgrid button placement 'left' 'right', 'both'

2012-12-21 Thread joe smith
I am trying to set the button placement of the "View", "Edit", "Delete" buttons in the smartgrid table to be 'left'. I am using: button_placement = 'left' in my controller when I set a smartgrid. It works in web2py 2.3.2 on my local machine, but won't work in 2.2.1 on our server. Is that setting

Re: [web2py] raspberry pi

2012-12-21 Thread Francois Dion
Kids are definitely jumping on this (and hackers and researchers etc - GPIO are easily interfaced with the RPi.GPIO module.). The response is really impressive, thanks in large part to the fact that people think of Python as the platform language. As From this article: http://www.raspberrypi

[web2py] Re: Query results from 2 children tables from same parent ordered by date

2012-12-21 Thread Derek
If you only need one date, why not display just one date? On Friday, December 21, 2012 2:01:59 PM UTC-7, Mamisoa Andriantafika wrote: > > I have pb to show the coalesce date in view. > I tried; > > exams_mutex['COALESCE(dataset1.date,dataset1.date)'] > > but it is not working? > > Le jeudi 20 dé

Re: [web2py] Re: session.flash not working?

2012-12-21 Thread Jonathan Lundell
On 21 Dec 2012, at 2:13 PM, Luca wrote: > I searched the code base, and I cannot find any place where an assignment > like: response.flash = session.flash appears. > Is this broken? It's in Session.connect: if self.flash: (response.flash, self.flash) = (self.flash, None)

[web2py] Re: session.flash not working?

2012-12-21 Thread Luca
I searched the code base, and I cannot find any place where an assignment like: response.flash = session.flash appears. Is this broken? On Friday, December 21, 2012 1:53:21 PM UTC-8, Luca wrote: > > I have this very simple code: > > session.flash = T('The contest is still open to subm

[web2py] session.flash not working?

2012-12-21 Thread Luca
I have this very simple code: session.flash = T('The contest is still open to submissions.') session.foo = T('pooh') logger.debug('contest still open to submissions') redirect(URL('default', 'index')) on the default/index controller, I can see that session.foo is

[web2py] Re: Beware auth.enable_record_versioning

2012-12-21 Thread Cliff Kachinske
It appears to be fixed in trunk. I copied my entire app into a new directory. created a copy of the original db, data included. used appadmin to do fake migrates on all tables. commented out the enable_record_versioning in all model files. Turned off fake migrate. stopped and restarted the serve

[web2py] Re: Query results from 2 children tables from same parent ordered by date

2012-12-21 Thread Mamisoa Andriantafika
I have pb to show the coalesce date in view. I tried; exams_mutex['COALESCE(dataset1.date,dataset1.date)'] but it is not working? Le jeudi 20 décembre 2012 23:40:15 UTC+1, Mamisoa Andriantafika a écrit : > > I finally found the solution using COALESCE to merge and order date > columns: > > exa

[web2py] Re: Problem with fields option of SQLFORM.grid

2012-12-21 Thread Luca
Ok, I figured it out, I can include db.submission.contest_id among the fields, and before calling SQLGRID.form, do db.submission.contest_id.readable = False Luca On Friday, December 21, 2012 12:42:37 PM UTC-8, Luca wrote: > > I have a problem using SQLFORM.grid and its fields option. > fields=

Re: [web2py] Re: DB insert confusion

2012-12-21 Thread Kurt Grutzmacher
Yeah, yeah, yeah.. My on-the-fly testing code wasn't correct. ;) Checking with isinstance() is good but fails if params is just a string due to the data.get('params', '') a few lines up. Changing that to data.get('params', []) will resolve this or just drop elif isinstance(params, list): and chan

[web2py] Problem with fields option of SQLFORM.grid

2012-12-21 Thread Luca
I have a problem using SQLFORM.grid and its fields option. fields= enables me to specify which fields to retrieve from the db, and those fields are then displayed to the user. The problem is, I would like to read from the database also some additional fields, which are NOT displayed to the user

Re: [web2py][outsource] Need a plugin that integrate jsTree or other tree plugin with closure table app

2012-12-21 Thread wwwgong
I am interested in tree widget too, have you evaluated 1) http://dev.s-cubism.com/plugin_jstree 2) http://dev.s-cubism.com/plugin_mptt which is based on Nested Set W On Thursday, September 20, 2012 3:21:14 PM UTC-4, Richard wrote: > > 1) > Users are defining information into simple form where i

[web2py] Re: 2.2.1 left joins broken?

2012-12-21 Thread Cliff Kachinske
SQL is incorrect. is: "AND supplier_contacts.is_active = 'T'" should be "AND (supplier_contacts.is_active = 'T' OR supplier_contacts.is_active IS NULL)" On Friday, December 21, 2012 1:05:16 PM UTC-5, Massimo Di Pierro wrote: > > It looks to be the generated SQL is correct. It is possible you

[web2py] Re: 2.2.1 left joins broken?

2012-12-21 Thread Massimo Di Pierro
It looks to be the generated SQL is correct. It is possible you enabled record versioning and that added the common_filter is_active==True. Yet perhaps you have records with is_active=None and therefore they showed up before and not now. On Friday, 21 December 2012 10:50:13 UTC-6, Cliff Kachins

[web2py] 2.2.1 left joins broken?

2012-12-21 Thread Cliff Kachinske
Salient details from two tables: db.define_table( 'suppliers', Field('name', length=256, required=True, notnull=True), db.define_table( 'supplier_contacts', Field('supplier_id', db.suppliers), Field('first_name', length=32, required=True, notnull=True), The code b

[web2py] Re: Beware auth.enable_record_versioning

2012-12-21 Thread Cliff Kachinske
Yes, but I don't think it will be today. On Friday, December 21, 2012 1:20:03 AM UTC-5, Massimo Di Pierro wrote: > > This helped me a lot understand the problem. I believe I have a fix in > trunk. Can you please check if the problem is indeed solved? > > On Thursday, December 20, 2012 1:21:21 PM

[web2py] Direct Client Opening for Position : Java Developer Location : Topeka KS

2012-12-21 Thread ankit rane
Hi, *Do quick response at ank...@eruditionweb.com*, Please review the below Job Description and let me know if you are comfortable, Position : Java Developer Location : Topeka KS Duration : Long Term Project Description : We are currently e

Re: [web2py] Re: json service

2012-12-21 Thread Massimo Di Pierro
yes. never return a list unless it is a list of strings you want to stream or a generator of strings. On Friday, 21 December 2012 07:27:41 UTC-6, Manuele wrote: > > Il 20/12/12 20:11, Massimo Di Pierro ha scritto: > > yes. > > > > You are not supposed to return an iterable (in your case a list

[web2py] Re: radio widget styling.

2012-12-21 Thread Massimo Di Pierro
widget=lambda k,v: SQLFORM.widgets.radio.widget(k,v,_style='ul') On Friday, 21 December 2012 03:19:16 UTC-6, Annet wrote: > > I defined the following field: > > Field('moduleID',type='integer',requires=IS_EMPTY_OR(IS_IN_SET([ABOUTGROUPID,CALENDARGROUPID],labels=['About','Kalender'])),widget=SQLFOR

Re: [web2py] Re: json service

2012-12-21 Thread Manuele Pesenti
Il 20/12/12 20:11, Massimo Di Pierro ha scritto: yes. You are not supposed to return an iterable (in your case a list). web2py thinks you want to do streaming and will start looping over the iterable. This should change in web3py not we cannot change it in web2py. Massimo Thanks Massimo, so

Re: [web2py] Re: Question about SQLFORM.grid - process a column before show it

2012-12-21 Thread Christian Espinoza
Wow!! Thanks Niphlod, this tip worked like a charm!! El jueves, 20 de diciembre de 2012 20:53:14 UTC-3, Niphlod escribió: > > my bad, sorry Christian. > > myset = { 0:'Quiet',1:'Running',2:'Fail'} > > Field('action', 'integer', > requires=IS_IN_SET(myset), > represent=lamb

[web2py] radio widget styling.

2012-12-21 Thread Annet
I defined the following field: Field('moduleID',type='integer',requires=IS_EMPTY_OR(IS_IN_SET([ABOUTGROUPID,CALENDARGROUPID],labels=['About','Kalender'])),widget=SQLFORM.widgets.radio.widget,label='Module * '), In the form the radio widget is rendered as a table with the label beneath the inp

Re: [web2py] Web2Py and Ajax

2012-12-21 Thread Martijn Hermans
Thanks for your quick response. Op vrijdag 21 december 2012 06:14:25 UTC+1 schreef rochacbruno het volgende: > > if not request.ajax: > response.menu = _menu() > > On Thu, Dec 20, 2012 at 1:52 PM, Martijn Hermans > > > wrote: > >> When I handle a request in Web2Py it builds a menu in models/

[web2py] Re: Web2Py and Ajax

2012-12-21 Thread Martijn Hermans
Thanks for your quick response. Op vrijdag 21 december 2012 07:14:32 UTC+1 schreef Massimo Di Pierro het volgende: > > if not request.ajax: > > On Thursday, December 20, 2012 9:35:02 AM UTC-6, Martijn Hermans wrote: >> >> I've just started using web2py and have a question about ajax calls. >