Re: [web2py] Re: sqlform.grid search widget

2012-07-20 Thread peter
I think that there is an argument for incorporating my solution into the standard sqlform grid and having a flag for switching between the query system or my simple text search. If the table is being presented in a web application for the great web public then they are going to expect searches

[web2py] Admin infinite loop on latest trunk

2012-07-20 Thread Alec Taylor
Just grabbed the latest trunk from Google Code, and got quite an annoying problem, which I'm guessing was due to the added CSRF checks (http://code.google.com/p/web2py/source/detail?r=26be4b6bb1b607fda73219c93ee3e72f4eecd681). Basically I try to login to the admin panel, and it asks for my passwor

[web2py] Re: two references from one table to another.

2012-07-20 Thread Cliff Kachinske
Let's say your table name is from_to. Then you have something like arbitrary_last_name = 'Smith' # make this assignment at run time query = ( (db.auth_user.last_name==arbitrary_last_name) & (db.auth_user.id==db.from_to.from_user) & (db.from_to.to_user==db.auth_user.id) ) db(query).select(db

Re: [web2py] Admin infinite loop on latest trunk

2012-07-20 Thread Vladyslav Kozlovskyy
in gluon/validators.py replace line 2582: OLD: key = self.crypt.key.split(':')[1] if ':' in self.crypt.key else '' NEW: key = self.crypt.key.split(':')[1] if self.crypt.key and ':' in self.crypt.key else '' and restart web2py With the best regards, Vladyslav Kozlovskyy (Ukraine) 20.07.12 13:

[web2py] Re: two references from one table to another.

2012-07-20 Thread Ashraf Mansour
> > Thank you for your time. > But unfortunately, I don't understand. maybe the question is not clear enough. the query will be like *( db.from_to.from_user == db.auth_user.id ) & ( db.from_to.to_user == db.auth_user.id )* How to select the two names? both are * db.auth_user.name* --

[web2py] Re: A Web2py CMS like Joomla ?

2012-07-20 Thread Gour
On Thu, 19 Jul 2012 13:06:09 -0300 Bruno Rocha wrote: > Sorry community, but we do not have to expect a ready-to-use solution > if nobody contributes with running code! Both projects are open > source in github or bitbicket. get the source, propose patches, send > pull requests. I understand th

[web2py] Re: A Web2py CMS like Joomla ?

2012-07-20 Thread Gour
On Thu, 19 Jul 2012 18:03:19 -0300 Bruno Rocha wrote: > > IMHO the real question is *what is the cause of plugins little > > usage?* > The misunderstanding of plugin system, to be honest I think the web2py > plugin system is not good. Can you shed some more light on it, please? > Now with modu

[web2py] Making minor changes to auth.navbar()

2012-07-20 Thread Matt Newton
Is there a simple way to make changes to the auth.navbar() helper object? For example, the default for a logged in user is: "Welcome {First Name} Logout| Profile

Re: [web2py] Re: x509 authentication

2012-07-20 Thread tiadobatima
Thanks guys! I'm using nginx too, and I followed roughly the same steps but using uwsgi. Michelle, I know you wrote the code, but I believe X509Account should be replaced with X509Auth, no? from gluon.contrib.login_methods.x509_auth import X509Auth auth.settings.actions_disabled=['regis

Re: [web2py] Re: x509 authentication

2012-07-20 Thread Michele Comitini
> Michelle, I know you wrote the code, but I believe X509Account should be > replaced with X509Auth, no? Ahem... I stand corrected, you are right I just copied a comment in the code. The comment must be fixed. mic 2012/7/20 tiadobatima : > Thanks guys! > > I'm using nginx too, and I followed

Re: [web2py] Re: sqlform.grid search widget

2012-07-20 Thread Richard Vézina
Maybe open a issue and summit a patch or your code... http://code.google.com/p/web2py/issues/list Richard On Fri, Jul 20, 2012 at 4:29 AM, peter wrote: > I think that there is an argument for incorporating my solution into the > standard sqlform grid and having a flag for switching between the

[web2py] Re: how to compare date time in web2py?

2012-07-20 Thread Andrew
I'm not sure if web2py has something built-in to do this calculation but for other similar issues in the past I've just converted my dates to epoch and done the necessary math to see the difference between the two date-times. On Thursday, July 19, 2012 4:05:41 AM UTC-5, Amit wrote: > > Hi, > I

Re: [web2py] Re: A Web2py CMS like Joomla ?

2012-07-20 Thread Martín Mulone
Yes I was a bit disappear cause personal problems, I know there are some bugs reported, I'm a little busy at the moment but I have in mind to make changes to instant press. As bruno said I didn't get any contribution from the project, but is open source feel free to merge /fork or whatever. 2012/7

Re: [web2py] Re: how to compare date time in web2py?

2012-07-20 Thread Jonathan Lundell
On 20 Jul 2012, at 6:19 AM, Andrew wrote: > I'm not sure if web2py has something built-in to do this calculation but for > other similar issues in the past I've just converted my dates to epoch and > done the necessary math to see the difference between the two date-times. web2py ordinarily dea

Re: [web2py] Admin infinite loop on latest trunk

2012-07-20 Thread Alec Taylor
Thanks, seems Massimo just fixed it also So thanks to both of you :) On Fri, Jul 20, 2012 at 9:39 PM, Vladyslav Kozlovskyy wrote: > in gluon/validators.py replace line 2582: > > OLD: key = self.crypt.key.split(':')[1] if ':' in self.crypt.key else '' > NEW: key = self.crypt.key.split(':')[1] if

[web2py] Question about an xml file in use with a JS(jquery) Mappicker in web2py ...

2012-07-20 Thread Don_X
Hello everyone ... I am trying to intergrate a jquery mappicker within my web2py app ! One of the js file calls upon an xml file containing the text information related to the location clicked on the map shown on screen ! the js function goes like this : ... ... ... $.ajax({ type: 'G

Re: [web2py] Re: Routing broke between 2012-06-18 and 2012-07-10

2012-07-20 Thread Alec Taylor
On Fri, Jul 13, 2012 at 4:32 AM, Anthony wrote: >> Hmm, I added that line (`auth.navbar(referrer_actions=['register', >> 'profile', 'login'])`) below `auth.settings.login_next = >> URL(f='profile')` in db.py, and it changed the way the problem occurs. > > > No, you don't want 'login' to be one of

Re: [web2py] Admin infinite loop on latest trunk

2012-07-20 Thread Vladyslav Kozlovskyy
you are welcome! :) 20.07.12 17:02, Alec Taylor написав(ла): Thanks, seems Massimo just fixed it also So thanks to both of you :) On Fri, Jul 20, 2012 at 9:39 PM, Vladyslav Kozlovskyy wrote: in gluon/validators.py replace line 2582: OLD: key = self.crypt.key.split(':')[1] if ':' in self.cry

[web2py] http://www.web2pyslices.com/ is down

2012-07-20 Thread Richard Vézina
http://www.web2pyslices.com/ is down Richard --

[web2py] Re: Question about an xml file in use with a JS(jquery) Mappicker in web2py ...

2012-07-20 Thread Don_X
Sorry .. it is not called a mappicker but an " interactive map " --

[web2py] Re: Making minor changes to auth.navbar()

2012-07-20 Thread Anthony
Unfortunately, the navbar isn't very flexible. However, it returns an HTML helper object (a SPAN with several components), so you can manipulate it after creation. The part after "Welcome" is the second component of the span, so: navbar = auth.navbar() if auth.user: navbar[1] = auth.user.em

[web2py] Re: A Web2py CMS like Joomla ?

2012-07-20 Thread Anthony
> > > Sorry community, but we do not have to expect a ready-to-use solution > > if nobody contributes with running code! Both projects are open > > source in github or bitbicket. get the source, propose patches, send > > pull requests. > > I understand the point, but as user of PHP CMS-es want

[web2py] Re: Unable to login to admin in trunk

2012-07-20 Thread Massimo Di Pierro
can you please try again? On Thursday, 19 July 2012 18:17:11 UTC-5, JohnB wrote: > > Using Version 2.00.0 (2012-07-19 16:56:40) dev > > $python web2py.py > Enter pw and start server. > Starts up OK in welcome app. > Click on goto admin button and get login screen. > Enter pw and get admin error t

Re: [web2py] Re: x509 authentication

2012-07-20 Thread Massimo Di Pierro
I'll wait for the patch. On Friday, 20 July 2012 07:51:37 UTC-5, Michele Comitini wrote: > > > Michelle, I know you wrote the code, but I believe X509Account should be > > replaced with X509Auth, no? > > Ahem... I stand corrected, you are right I just copied a comment in > the code. The comme

[web2py] Re: A Web2py CMS like Joomla ?

2012-07-20 Thread Gour
On Fri, 20 Jul 2012 08:07:50 -0700 (PDT) Anthony wrote: > I guess that's the problem. You want others to contribute and > generate some traction before getting involved yourself. That's > perfectly reasonable, but of course, if everyone feels that way, > nothing will happen. Well, I'm noob and n

[web2py] Re: A Web2py CMS like Joomla ?

2012-07-20 Thread Gour
On Fri, 20 Jul 2012 10:32:21 -0300 Martín Mulone wrote: > Yes I was a bit disappear cause personal problems, I know there are > some bugs reported, I'm a little busy at the moment but I have in > mind to make changes to instant press. I'm sorry hearing about your problems hoping you will resolv

[web2py] Re: Question about an xml file in use with a JS(jquery) Mappicker in web2py ...

2012-07-20 Thread Derek
As far as I know, web2py does not work directly with XML. It can output to xml automatically, and serializes, but as far as working with xml as data, I don't think it has anything like that. You should be able to use the python standard libraries for that. I prefer xml.dom.minidom, but I've hear

[web2py] web2py.com offline

2012-07-20 Thread Dave
can't get to the website today. --

[web2py] Dreadful IE trick spewing out lots of 'x' chars when raising HTTP(4xx)

2012-07-20 Thread tiadobatima
Hi guys, Raising a 4xx exception is printing extra 512 'x' characters in the body. This seems to be the culprit (HTTP.py): if len(body)<512 and self.headers['Content-Type'].startswith( 'text/html'): body += '' % ('x'*512) ### trick IE Is there any easy way of not pr

[web2py] Unions and select from tables

2012-07-20 Thread Andrew Evans
I am trying to work in Web2py's union method and am wondering a few things if I have a query *db( (db.sample.id>0) and (db.example.id>0) and (db.random.id>0)).select()* I would like to know how to orderby the latest ids as well when I am displaying a page link *

[web2py] Re: Unable to login to admin in trunk

2012-07-20 Thread JohnB
~/web2py$ python web2py.py --nogui web2py Web Framework Created by Massimo Di Pierro, Copyright 2007-2011 Version 2.00.0 (2012-07-20 10:31:02) dev Database drivers available: SQLite3, pymysql, pg8000, IMAP choose a password: please visit: http://127.0.0.1:8000 use "kill -SIGTERM 20312" to shutdown

Re: [web2py] How do we check the number of users in the new google groups?

2012-07-20 Thread Brian
How about when you're a group owner? The groups that I started don't allow me to see the number of subscribers...thoughts? On Friday, March 30, 2012 10:17:39 AM UTC-4, Anthony wrote: > How do we check the number of users in the new google groups? >> Everything is so complicated compared to the o

[web2py] Re: Question about an xml file in use with a JS(jquery) Mappicker in web2py ...

2012-07-20 Thread Don_X
More information regarding this initiative : the scripts used for the interactive map is the one found at : http://codecanyon.net/item/interactive-svg-canada-map/2355460 It is said to be XML driven and i wish to port it to my web2py app. . But i am hitting a wall with this ! ... the xml

[web2py] Re: Unable to login to admin in trunk

2012-07-20 Thread Daniel Aguayo
Hi, It's still not resolved El viernes, 20 de julio de 2012 12:22:01 UTC-4, Massimo Di Pierro escribió: > > can you please try again? > > Traceback (most recent call last): File "web2py.py", line 25, in gluon.widget.start(cron=True) File "/home/dantoac/web2py_git/gluon/widget.py", line 10

Re: [web2py] Re: Unable to login to admin in trunk

2012-07-20 Thread Jonathan Lundell
On 20 Jul 2012, at 11:03 AM, Daniel Aguayo wrote: > Hi, It's still not resolved Yeah, that was just for diagnostic purposes. Find where you're specifying 'sh512' and change it to 'sha512'. > > El viernes, 20 de julio de 2012 12:22:01 UTC-4, Massimo Di Pierro escribió: > can you please try again

[web2py] Routing by SLUG with default controller?

2012-07-20 Thread Alec Taylor
I've got a system with users, groups and group-events. Preferably I would like the following routing schemes: localhost/groupSLUGhere/ localhost/groupSLUGhere/eventIDhere localhost/profile/usernameHere How would I go about setting this up? Currently the system is very fiddly, even for doing sim

Re: [web2py] http://www.web2pyslices.com/ is down

2012-07-20 Thread Bruno Rocha
Yeah, sorry. I have to upgrade my Linode, also, bots from google and baidu are eating my server. I need to solve some sessions problems. I will upgrade the Linode for webslices and also I will put a bigger "donate", "sponsor" link in web2pyslices website, I am paying backups and hosting by my own

Re: [web2py] web2py.com offline

2012-07-20 Thread Bruno Rocha
Well, I think web2py.com and web2pyslices.com needs a better hosting solution. On Fri, Jul 20, 2012 at 2:22 PM, Dave wrote: > can't get to the website today. > > -- > > > > --

Re: [web2py] Routing by SLUG with default controller?

2012-07-20 Thread Jonathan Lundell
On 20 Jul 2012, at 11:38 AM, Alec Taylor wrote: > > I've got a system with users, groups and group-events. > > Preferably I would like the following routing schemes: > > localhost/groupSLUGhere/ > localhost/groupSLUGhere/eventIDhere > localhost/profile/usernameHere Where do you want these URLs

[web2py] Re: Unions and select from tables

2012-07-20 Thread Massimo Di Pierro
I see what you are doing and I like it. I think it may be tricky to implement but I look forward to see what you come up to. I think: *db( (db.sample.id>0) and (db.example.id>0) and (db.random.id>0)).select()* * * should be * * *db( (db.sample.id>0) & (db.example.id>0) & (db.random.id>0)).select(

Re: [web2py] Routing by SLUG with default controller?

2012-07-20 Thread Alec Taylor
On Sat, Jul 21, 2012 at 4:41 AM, Jonathan Lundell wrote: > On 20 Jul 2012, at 11:38 AM, Alec Taylor wrote: >> >> I've got a system with users, groups and group-events. >> >> Preferably I would like the following routing schemes: >> >> localhost/groupSLUGhere/ controllers/groups.py >> localhost/g

Re: [web2py] Re: Unable to login to admin in trunk

2012-07-20 Thread Daniel Aguayo
El viernes, 20 de julio de 2012 14:24:01 UTC-4, Jonathan Lundell escribió: > > On 20 Jul 2012, at 11:03 AM, Daniel Aguayo wrote: > > Hi, It's still not resolved > > > Yeah, that was just for diagnostic purposes. Find where you're specifying > 'sh512' and change it to 'sha512'. > > Hi Jonathan I

Re: [web2py] web2py.com offline

2012-07-20 Thread Massimo Di Pierro
By removing the online book, there are no more confidential information on web2py.com This will make it easier to move it and to create mirrors. I will move it next week. After that we will create mirrors. massimo On Friday, 20 July 2012 13:40:53 UTC-5, rochacbruno wrote: > > > Well, I think we

[web2py] Re: Dreadful IE trick spewing out lots of 'x' chars when raising HTTP(4xx)

2012-07-20 Thread Massimo Di Pierro
The rest about should not have: self.headers['Content-Type'].startswith('text/html') If they do you need the extra comment else IE will not display the rest of the error message. On Friday, 20 July 2012 12:22:50 UTC-5, tiadobatima wrote: > > > Hi guys, > > Raising a 4xx exception is printing ext

[web2py] Re: Unable to login to admin in trunk

2012-07-20 Thread Massimo Di Pierro
my bad. fixed. On Friday, 20 July 2012 13:03:36 UTC-5, Daniel Aguayo wrote: > > Hi, It's still not resolved > > El viernes, 20 de julio de 2012 12:22:01 UTC-4, Massimo Di Pierro escribió: >> >> can you please try again? >> >> > Traceback (most recent call last): > File "web2py.py", line 25, in

Re: [web2py] web2py.com offline

2012-07-20 Thread Dave
Its working now, thanks! On Friday, 20 July 2012 12:48:09 UTC-6, Massimo Di Pierro wrote: > > By removing the online book, there are no more confidential information on > web2py.com > This will make it easier to move it and to create mirrors. I will move it > next week. After that we will crea

Re: [web2py] Routing by SLUG with default controller?

2012-07-20 Thread Jonathan Lundell
On 20 Jul 2012, at 11:45 AM, Alec Taylor wrote: > > On Sat, Jul 21, 2012 at 4:41 AM, Jonathan Lundell wrote: >> On 20 Jul 2012, at 11:38 AM, Alec Taylor wrote: >>> >>> I've got a system with users, groups and group-events. >>> >>> Preferably I would like the following routing schemes: >>> >>>

Re: [web2py] web2py.com offline

2012-07-20 Thread Massimo Di Pierro
Anyway, considering they have different hosting it is suspicious they went down at the same time. In web2py.com apache was not running but was not able to restart because could not bind to 0.0.0.0:80. I had to reboot. I have not seen this problem before. I was always able to simply restart apac

Re: [web2py] web2py.com offline

2012-07-20 Thread Bruno Rocha
I could not be able to restart NGINX/UWSGI, I am waiting my backups to finish and I will need to restart my Linode. The same problem :/ On Fri, Jul 20, 2012 at 3:58 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Anyway, considering they have different hosting it is suspicious they w

[web2py] Re: Unions and select from tables

2012-07-20 Thread Andrew
Does that mean sample, example, random have to have identical structures ? What if I just want the id and name columns ? How do I select just those in a union scenario? I know massimo doesn't like unions, but they are required sometimes. I am visualizing object relationships in a graph (pictu

Re: [web2py] Routing by SLUG with default controller?

2012-07-20 Thread Bruno Rocha
I dont know if it is a bug or feature (but I like it), you can do it in models! models/0_routing.py if request.controller in MYLISTOFGROUPS: groupslug = str(request.controller) # here you can use deep copy or just str() request.controller = 'group' request.function = 'show' reques

Re: [web2py] Routing by SLUG with default controller?

2012-07-20 Thread Jonathan Lundell
On 20 Jul 2012, at 12:03 PM, Bruno Rocha wrote: > I dont know if it is a bug or feature (but I like it), you can do it in > models! That works too, but you need be careful in your generation of outgoing URLs. It might be best to check request.controller for known controllers (default, profile,

Re: [web2py] Routing by SLUG with default controller?

2012-07-20 Thread Alec Taylor
Thanks, but I'm a little uncertain how to get the list of groups, I tried `if request.controller in db(db.group_of_events).select(orderby=db.group_of_events.group_name)`, but that didn't work. Here's an extremely simplified version of my tables (if that's of help): db.define_table( 'group_of_

Re: [web2py] Routing by SLUG with default controller?

2012-07-20 Thread Jonathan Lundell
On 20 Jul 2012, at 12:11 PM, Alec Taylor wrote: > > Thanks, but I'm a little uncertain how to get the list of groups, I > tried `if request.controller in > db(db.group_of_events).select(orderby=db.group_of_events.group_name)`, > but that didn't work. You need to specify a field in the select, bef

Re: [web2py] Routing by SLUG with default controller?

2012-07-20 Thread Alec Taylor
On Sat, Jul 21, 2012 at 5:15 AM, Jonathan Lundell wrote: > On 20 Jul 2012, at 12:11 PM, Alec Taylor wrote: >> >> Thanks, but I'm a little uncertain how to get the list of groups, I >> tried `if request.controller in >> db(db.group_of_events).select(orderby=db.group_of_events.group_name)`, >> but t

Re: [web2py] Routing by SLUG with default controller?

2012-07-20 Thread Jonathan Lundell
On 20 Jul 2012, at 12:19 PM, Alec Taylor wrote: > > On Sat, Jul 21, 2012 at 5:15 AM, Jonathan Lundell wrote: >> On 20 Jul 2012, at 12:11 PM, Alec Taylor wrote: >>> >>> Thanks, but I'm a little uncertain how to get the list of groups, I >>> tried `if request.controller in >>> db(db.group_of_event

Re: [web2py] web2py.com offline

2012-07-20 Thread Derek
What, you removed the book? On Friday, July 20, 2012 11:48:09 AM UTC-7, Massimo Di Pierro wrote: > > By removing the online book, there are no more confidential information on > web2py.com > This will make it easier to move it and to create mirrors. I will move it > next week. After that we will

Re: [web2py] Routing by SLUG with default controller?

2012-07-20 Thread Alec Taylor
Thanks, I'll give that a go tomorrow. To confirm, I am adding that in a file located at the same level as `applications` in the `web2py` root folder, to a filename `router.py`? On Sat, Jul 21, 2012 at 5:30 AM, Jonathan Lundell wrote: > On 20 Jul 2012, at 12:19 PM, Alec Taylor wrote: >> >> On Sat

[web2py] Re: Dreadful IE trick spewing out lots of 'x' chars when raising HTTP(4xx)

2012-07-20 Thread tiadobatima
Hi Massimo, I see. But how do I set the Content-Type when raising HTTP(400)? I'm assuming this Content-Type set automatically when when the exception is raised. Do I have any control over it? Thanks :) g. On Friday, 20 July 2012 11:49:58 UTC-7, Massimo Di Pierro wrote: > > The rest about should

Re: [web2py] Re: x509 authentication

2012-07-20 Thread tiadobatima
I want to point out that the documentation is also using X509Account: http://web2py.com/books/default/chapter/29/9#Other-login-methods-and-login-forms Thanks guys, g. On Friday, 20 July 2012 09:25:36 UTC-7, Massimo Di Pierro wrote: > > I'll wait for the patch. > > On Friday, 20 July 2012 07:51:3

[web2py] Re: Foreign Key fields as null?

2012-07-20 Thread joe
That hasn't worked for me. When I try, I get the error: 'name' It points to the smartgrid I made, with this code: grid = SQLFORM .smartgrid(db.dog) Thanks! -Joe Peacock On Tuesday, July 17, 2012 6:22:53 PM UTC-5, Anthony wrote: > > You shou

Re: [web2py] web2py.com offline

2012-07-20 Thread vinicius...@gmail.com
Bruno, how many pageviews a day? On 07/20/2012 03:40 PM, Bruno Rocha wrote: Well, I think web2py.com and web2pyslices.com needs a better hosting solution. On Fri, Jul 20, 2012 at 2:22 PM, Dave mailto:davidramsayreinh...@gmail.com>> wrote: can

[web2py] Re: Question about an xml file in use with a JS(jquery) Mappicker in web2py ...

2012-07-20 Thread Derek
Yes, don... XML drive means it takes an XML file as source for the map. It appears the XML is handled client side via javascript. There are no arguments passed to the XML so it is a static file. You would put it in your STATIC folder. On Friday, July 20, 2012 10:58:13 AM UTC-7, Don_X wrote: > >

[web2py] Re: Foreign Key fields as null?

2012-07-20 Thread Anthony
Oh, right, since you allow empty values, you'll need to test for that before doing the query: represent=lambda id, row: db.person(id).name if id else 'Nobody owns this dog' Anthony On Friday, July 20, 2012 3:47:33 PM UTC-4, joe wrote: > > That hasn't worked for me. When I try, I get the error

[web2py] Re: Foreign Key fields as null?

2012-07-20 Thread Anthony
Actually, I would think that would have caused an AttributeError (trying to access an attribute of a NoneType object). Not sure where the KeyError is arising. Anthony On Friday, July 20, 2012 4:31:52 PM UTC-4, Anthony wrote: > > Oh, right, since you allow empty values, you'll need to test for t

[web2py] Re: Dreadful IE trick spewing out lots of 'x' chars when raising HTTP(4xx)

2012-07-20 Thread Massimo Di Pierro
You should be able to do HTTP(400,**{'Content-Type':'text/html'}) On Friday, 20 July 2012 14:41:19 UTC-5, tiadobatima wrote: > > Hi Massimo, > > I see. But how do I set the Content-Type when raising HTTP(400)? > I'm assuming this Content-Type set automatically when when the exception > is raised

Re: [web2py] How do we check the number of users in the new google groups?

2012-07-20 Thread Massimo Di Pierro
And the new google groups does not even seem to allow exporting members in CSV any more. Massimo On Friday, 20 July 2012 08:47:09 UTC-5, Brian wrote: > > How about when you're a group owner? The groups that I started don't allow > me to see the number of subscribers...thoughts? > > On Friday, M

Re: [web2py] Re: x509 authentication

2012-07-20 Thread Michele Comitini
@Massimo I have made a pull request on github. mic 2012/7/20 Massimo Di Pierro : > I'll wait for the patch. > > > On Friday, 20 July 2012 07:51:37 UTC-5, Michele Comitini wrote: >> >> > Michelle, I know you wrote the code, but I believe X509Account should be >> > replaced with X509Auth, no? >>

[web2py] Re: Unions and select from tables

2012-07-20 Thread Cliff Kachinske
You can avoid a union like so: rows = db(q).select(r).as_list() rows.extend(db(qq).select(rr).as_list() You have to access attributes dictionary fashion, not in dot notation. Could be a problem for SQLTABLE and descendants. Google 'sort list of dictionaries' to see how to sort it. On Friday

Re: [web2py] Re: sqlform.grid search widget

2012-07-20 Thread Elcimar
it works now =) thanks dude about the search query Found a hack somewhere in the here group telling to delete it directly like: del grid[0][2] Em sexta-feira, 20 de julho de 2012 05h29min27s UTC-3, peter escreveu: > > I think that there is an argument for incorporating my solution into the > s

[web2py] DAL/Postgres not creating a table

2012-07-20 Thread Marek Mollin
Hey, Problem is as follows. I start a clean db in psql. Test the connection + delete all the /databases files to fresh with remote db. When I launch index page tables start getting created then I get error regarding some table is missing. I check sql.log and it did not even start creating the ta

Re: [web2py] Re: how to compare date time in web2py?

2012-07-20 Thread Ovidio Marinho
Difference of Two Dates #- # Dates produce timedeltas when subtracted. diff = date2 - date1 diff = datetime.date(year1, month1, day1) - datetime.date(year2, month2, day2)#- bree = datetime.datetime(1981, 6, 16, 4, 35, 25) nat = datetime.date

Re: [web2py] DAL/Postgres not creating a table

2012-07-20 Thread Bruno Rocha
are you sure the migrate is not False in db = DAL(...) ? try including migrate=True in your define_table On Fri, Jul 20, 2012 at 6:17 PM, Marek Mollin wrote: > Hey, > Problem is as follows. > I start a clean db in psql. Test the connection + delete all the > /databases files to fresh with remot

Re: [web2py] DAL/Postgres not creating a table

2012-07-20 Thread Ovidio Marinho
Shows the Ticket? Ovidio Marinho Falcao Neto Web Developer ovidio...@gmail.com ovidiomari...@itjp.net.br ITJP - itjp.net.br 83 8826 9088 - Oi 83 9334 0266 - Claro Brasil

[web2py] Re: Unions and select from tables

2012-07-20 Thread Massimo Di Pierro
You can also to db=DAL()db.define_table('a',Field('name')) db.define_table('b',Field('name')) db.a.insert(name='Alex') db.a.insert(name='Max') db.a.insert(name='Tim') db.b.insert(name='John') db.b.insert(name='Jack') def union(x,y): y.colnames=x.colnames return x|y *rows = union(db().sele

[web2py] Re: two references from one table to another.

2012-07-20 Thread Ashraf Mansour
is the question too easy or too difficult ? > > Ashraf > --

Re: [web2py] web2py.com offline

2012-07-20 Thread Massimo Di Pierro
LOL. Sorry I meant the app to sell the pdf book, because it is now free in pdf. On Friday, 20 July 2012 14:30:55 UTC-5, Derek wrote: > > What, you removed the book? > > On Friday, July 20, 2012 11:48:09 AM UTC-7, Massimo Di Pierro wrote: >> >> By removing the online book, there are no more confid

Re: [web2py] Re: x509 authentication

2012-07-20 Thread Massimo Di Pierro
thanks for letting me kno.w github does not notify me of pull requests. On Friday, 20 July 2012 15:59:48 UTC-5, Michele Comitini wrote: > > @Massimo > > I have made a pull request on github. > > mic > > > 2012/7/20 Massimo Di Pierro : > > I'll wait for the patch. > > > > > > On Friday, 20 J

[web2py] Re: Question about an xml file in use with a JS(jquery) Mappicker in web2py ...

2012-07-20 Thread Don_X
thank you Derek However, If the data ( text, pics, sizes, tags. ... ) is in the xml file ( within the static folder ), I will not be able to provide translation for that information by using the web2py object T( ) for translation before viewing those informations ... so I was wandering if

Re: [web2py] Re: x509 authentication

2012-07-20 Thread Michele Comitini
Could be a problem here: https://github.com/settings/notifications I get notifications, but they come in burst at random... mic 2012/7/20 Massimo Di Pierro : > thanks for letting me kno.w github does not notify me of pull requests. > > > On Friday, 20 July 2012 15:59:48 UTC-5, Michele Comitini w

Re: [web2py] web2py.com offline

2012-07-20 Thread Michele Comitini
Massimo, How can we start mirroring? We should test for a while and then work on geodns or other redirection facility. mic 2012/7/20 Massimo Di Pierro > LOL. Sorry I meant the app to sell the pdf book, because it is now free in > pdf. > > > On Friday, 20 July 2012 14:30:55 UTC-5, Derek wrote

[web2py] Re: Dreadful IE trick spewing out lots of 'x' chars when raising HTTP(4xx)

2012-07-20 Thread tiadobatima
Very neat! Thanks Massimo! On Friday, 20 July 2012 13:45:01 UTC-7, Massimo Di Pierro wrote: > > You should be able to do > > HTTP(400,**{'Content-Type':'text/html'}) > > On Friday, 20 July 2012 14:41:19 UTC-5, tiadobatima wrote: >> >> Hi Massimo, >> >> I see. But how do I set the Content-Type whe

[web2py] Re: two references from one table to another.

2012-07-20 Thread Massimo Di Pierro
Sorry, it took me a while to understand your question. But you actually have a very good question. Here is how you do it: db=DAL() db.define_table('auth_user', Field('name')) db.define_table('message', Field('to_user',db.auth_user), Field('from_user

Re: [web2py] web2py.com offline

2012-07-20 Thread Massimo Di Pierro
The plan is I finish remove confidential info from the folder and then allow people access to folder so they can periodically rsync. On Friday, 20 July 2012 17:09:54 UTC-5, Michele Comitini wrote: > > Massimo, > > How can we start mirroring? We should test for a while and then work on > geodns

Re: [web2py] web2py.com offline

2012-07-20 Thread Michele Comitini
If there is nothing confidential left using github or whatever repository to sync would not be better? mic 2012/7/21 Massimo Di Pierro > The plan is I finish remove confidential info from the folder and then > allow people access to folder so they can periodically rsync. > > > On Friday, 20 Ju

[web2py] Re: Making minor changes to auth.navbar()

2012-07-20 Thread pbreit
I just write my own: def user_bar(): action = '/user' if auth.user: logout=A('logout', _href=action+'/logout') profile=A('profile', _href=action+'/profile') password=A('change password', _href=action+'/change_password') bar = SPAN(auth.user.email, ' | ', pro

[web2py] Re: two references from one table to another.

2012-07-20 Thread Ashraf Mansour
I love both, you and web2py. Regards, > >> Ashraf >> > --

[web2py] Contrib Index?

2012-07-20 Thread villas
There is some really cool stuff in contrib. However, I cannot remember what it is. Is there an index anywhere? I mean just a brief description of even one line for each item would be really helpful. Thanks. --

[web2py] Re: Contrib Index?

2012-07-20 Thread Massimo Di Pierro
You can look at the CHANGELOG file but not everything is described there. On Friday, 20 July 2012 21:07:15 UTC-5, villas wrote: > > There is some really cool stuff in contrib. However, I cannot remember > what it is. Is there an index anywhere? > I mean just a brief description of even one l

[web2py] Re: Contrib Index?

2012-07-20 Thread Anthony
And some are described here: http://web2py.com/books/default/chapter/29/4#Libraries On Friday, July 20, 2012 10:46:08 PM UTC-4, Massimo Di Pierro wrote: > > You can look at the CHANGELOG file but not everything is described there. > > On Friday, 20 July 2012 21:07:15 UTC-5, villas wrote: >> >> Th

[web2py] Re: Web2py expert needed for start-up

2012-07-20 Thread Ramkrishan Bhatt
Like if you search Ramkrishan bhatt you will get my detail over there or location wise if you want to search you can search developer as per your nearest location. I am interested in the project. you can contact me as ramkrishanbh...@zero-group.com . On Wednesday, 18 July 2012 15:12:48 UTC+5:3

[web2py] Builtin Editor not working in latest Trunk

2012-07-20 Thread JohnB
I just downloaded and ran the latest trunk: Version 2.0.0 (2012-07-20 17:37:48) dev The built-in editor seems to be in read-only mode. After seemingly editing either a new file or an existing file, hitting Ctrl-S does nothing and anything typed into the file is not saved. There is no flash veri

[web2py] Re: Builtin Editor not working in latest Trunk

2012-07-20 Thread JohnB
See discussion in https://groups.google.com/d/topic/web2py-developers/On6J9VJTn8M/discussion ACE editor not working. Editing admin/models/0.py as suggested in the quoted discussion reverts to previous editor which works as usual. On Friday, July 20, 2012 10:43:34 PM UTC-7, JohnB wrote: > > I ju