[web2py:10544] Re: Lost some work tonite

2008-10-23 Thread Keith Edmunds
On Wed, 22 Oct 2008 23:12:24 -0700 (PDT), [EMAIL PROTECTED] said: This is one reason why many people don't trust web editors -- they are too prone to lose work. Whilst I agree with the basic point you make about somehow saving the context of the editing if possible, if you don't trust web

[web2py:10545] Re: pycon2009

2008-10-23 Thread Steve Shepherd
Massimo After 20mins testing I ran into only a few probs. 1. The google map key is wrong. Refer to the png attached. 2. You probably need to include a check box toggling image so that people know they should click one or many of the categories. see the pic attached. 3. The URl

[web2py:10550] Re: How to implement RESTful requests? A proposal

2008-10-23 Thread Timothy Farrell
I like this a lot. If Massimo agrees this could be the official recommendation for CRUD operations via a RESTful URL interface. Such concepts would have been helpful for me whenever I started into web development since it would show me how to look at data manipulation. Thanks for your effort

[web2py:10552] Re: joining three tables.

2008-10-23 Thread Timothy Farrell
I can't comment for the rest of stuff, but the last zero means to return the first item in the list. The select() call returns an SQLSet instance (which is an iterateable(sp?) type). The [0] grabs the first SQLRow out of that set. -tim annet wrote: I have rebuilt the function from scratch:

[web2py:10551] Re: joining three tables.

2008-10-23 Thread annet
I have rebuilt the function from scratch: def byplace(): records=db((db.company.id==db.address.company)(db.company.id==db.companyLOB.company)) \ .select(db.company.companyName,db.company.ranking,db.address.streetName,db.companyLOB.lineOfBusiness, \

[web2py:10554] Re: pycon2009

2008-10-23 Thread mdipierro
Thank you Steve. On Oct 23, 2:35 am, Steve Shepherd [EMAIL PROTECTED] wrote: Massimo After 20mins testing I ran into only a few probs. 1. The google map key is wrong. Refer to the png attached. 2. You probably need to include a check box toggling image so that people know they should

[web2py:10553] Re: joining three tables.

2008-10-23 Thread DenesL
Your syntax error comes from a missing closing parenthesis ')' just before the return: orderby=db.company.ranking|db.company.companyName) ) # --- On Oct 23, 5:22 am, annet [EMAIL PROTECTED] wrote: I have got the following SQL query which I need to rewrite as a web2py function: SELECT

[web2py:10555] Re: Lost some work tonite

2008-10-23 Thread mdipierro
I know but once you are aware of this problem it is gone because you have the options to: 1) edit the admin/models/0.py file and increase the expiration time 2) you can edit the files without the web based interface using any other editor you like Massimo On Oct 23, 4:59 am, Phyo Arkar [EMAIL

[web2py:10556] Re: Lost some work tonite

2008-10-23 Thread mdipierro
And you can always use the browser to go [back] and retrieve work at any previous stage (works for me with firefox). Massimo On Oct 23, 8:58 am, mdipierro [EMAIL PROTECTED] wrote: I know but once you are aware of this problem it is gone because you have the options to: 1) edit the

[web2py:10559] Re: joining three tables.

2008-10-23 Thread Timothy Farrell
That's fine, I (obviously) didn't look at the code. =) DenesL wrote: On Oct 23, 9:45 am, Timothy Farrell [EMAIL PROTECTED] wrote: The select() call returns an SQLSet instance (which is an iterateable(sp?) type). Tim, sorry to nitpick here but actually select() is a method of a

[web2py:10560] Re: pycon2009

2008-10-23 Thread Robin B
The poor performance is not a configuration problem, web2py must be modified to cache the compiled code of models, views and controllers instead of reading, parsing and compiling them on every request. But, there is a configuration problem with the static files config in app.yaml. - url:

[web2py:10562] Re: joining three tables.

2008-10-23 Thread mdipierro
No. db(query).select(*fields,**parameters) query is just the WHERE. If the query involves more than one table, web2py interprets it as an INNER JOIN. query can be None (or nothing) if fields are specified. If you want a LEFT OUTER JOIN

[web2py:10571] Re: pycon2009

2008-10-23 Thread mdipierro
Can you elaborate on 2). I do nor understand. Massimo On Oct 23, 2:35 am, Steve Shepherd [EMAIL PROTECTED] wrote: Massimo After 20mins testing I ran into only a few probs. 1. The google map key is wrong. Refer to the png attached. 2. You probably need to include a check box toggling

[web2py:10576] Re: Lost some work tonite

2008-10-23 Thread mdipierro
T2 it does that already. admin does it too. It is post/get vars that are lost. Massimo On Oct 23, 4:43 pm, achipa [EMAIL PROTECTED] wrote: Massimo, what do you think about the login (esp in T2) remembering the landing URL/FORM and redirecting/submitting to it again after a successful login ?

[web2py:10577] Re: How to implement RESTful requests? A proposal

2008-10-23 Thread billf
Voltron I have read through the threads you referenced again and I think I can see where you are coming from. I think that part of the problem is that examples of REST rarely seem to include the parts of the user interaction where the user requests an HTML form to be used to