[web2py] DAL syntax for sub-selects?

2010-02-02 Thread Guido Kollerie
Hi, Is web2py's DAL syntax rich enough to express sub-selects of the following form? select * from table_1, table_2, (select col_1 from some_table where ... group by col_1) as table_2 where -- Guido -- You received this message because you are subscri

[web2py] Re: immediate web2py job opening

2010-02-02 Thread weheh
I just want to note that my post is not an exaggeration. The enterprise which I represent is routinely visited by top supermodels and movie stars and is in the same building as a top modeling agency. Not that that would make any difference to a serious web2py coder, now would it? -- You received

[web2py] Changing redirect for @auth.requires_login()

2010-02-02 Thread Dane
Hey all, I've been using the @auth.requires_login() decorator and I love the simplicity. It was also pretty easily to hook it into google account authentication after a bit of searching on this group. My only problem with it is I don't want users redirected to the index after logging in, I'd like t

[web2py] trying to get email to work

2010-02-02 Thread weheh
I'm trying to get the email module to work. In my model I say: #model mail.settings.server='localhost'# your SMTP server mail.settings.login=None# your credentials mail.settings.sender='no-re...@foobar.com' # your email #controller "admin.py" def email_blast():

[web2py] Re: web2py rocks!

2010-02-02 Thread johntynan
Thanks! Here is some additional information: http://opensourcebroadcasting.blogspot.com/2010/02/introducing-pledge-drive-tracker.html Also, between us here on the web2py group, here is the link to create an account and set up your own pledge drive: http://opensourcebroadcasting.appspot.com/pled

Re: [web2py] Re: hg export tip on fresh hg clone

2010-02-02 Thread Wes James
Thx Thadeus and Massimo for the info. I am just learning hg and it's like learning a new language :) hg commit "add username on appadmin ;)" -wes On Tue, Feb 2, 2010 at 8:34 PM, mdipierro wrote: > If you see it in diff that means I committed it. It is not in stable > yet but will be soon. I pl

[web2py] Re: hg export tip on fresh hg clone

2010-02-02 Thread mdipierro
If you see it in diff that means I committed it. It is not in stable yet but will be soon. I plan to release 1.74.10 tomorrow. Massimo On Feb 2, 9:15 pm, Wes James wrote: > I just download web2py: hg clone > > without doing anything if I do "hg export tip" it shows a diff : > > # HG changeset pa

Re: [web2py] hg export tip on fresh hg clone

2010-02-02 Thread Thadeus Burgess
The act of exporting a changeset generates an augmented patch file that describes the change. A Mercurial patch file contains some metadata and a traditional unified diff. Once a changeset has been exported from one repository, it can be imported into another. The actual command is hg export W

[web2py] hg export tip on fresh hg clone

2010-02-02 Thread Wes James
I just download web2py: hg clone without doing anything if I do "hg export tip" it shows a diff : # HG changeset patch # User mdipie...@massimo-di-pierros-macbook.local # Date 1265154799 21600 # Node ID a40f484a4627a4d4373ce305d381e97842830148 # Parent 4e6959c4eaddd53eb314032f741e961a53a50bb8 fi

Re: [web2py] Re: dal.py

2010-02-02 Thread Thadeus Burgess
sql.py is what we are using right now. (1.7*.* branch) dal.py is a rewrite of sql.py but in a much more modular manner. It will make adding new database back ends easier, and make the dal much more maintainable. -Thadeus On Tue, Feb 2, 2010 at 6:20 PM, Richard wrote: > I'm confused about th

[web2py] Re: admin access from remote machine

2010-02-02 Thread Richard
if you are OK with changing the admin code it is quite easy - have a look at the start of admin/models/access.py and remove some of the checks. You also need to do the same in controllers/appadmin.py On Feb 2, 9:00 pm, Al wrote: > Hi, > > I have just started to learn web2py recently. I have inst

[web2py] Re: upgrade flag missing

2010-02-02 Thread Richard
ah OK. It's hard to keep track of all the discussion here, so it will be great when the next manual version is released with all these updates. On Feb 3, 10:58 am, mdipierro wrote: > It is done automatically when you start recent web2py. This was > discussed and turned out many people wanted th

[web2py] Re: dal.py

2010-02-02 Thread Richard
I'm confused about this - dal2.py is the new version but what is the difference between sql.py and dal.py? On Feb 3, 7:05 am, Thadeus Burgess wrote: > belay that :) > > was using sql.py's Field with dal.py's DAL > > -Thadeus > > On Tue, Feb 2, 2010 at 11:53 AM, Thadeus Burgess > wrote: > > mig

[web2py] Re: The state of the wiki and documentation in general

2010-02-02 Thread Richard
HAHA! Another reason is they have a licensing deal with Apress that allows them to put a version of their book online: http://www.djangobook.com/ This online version lets people comment about missing content, new features, etc, which keeps the documentation updated. It would be awesome if web2py

[web2py] Re: upgrade flag missing

2010-02-02 Thread mdipierro
It is done automatically when you start recent web2py. This was discussed and turned out many people wanted this. On Feb 2, 4:52 pm, Richard wrote: > After downloading a new web2py version I used to use the upgrade flag > to override the default apps, but now that seems to be missing: > > $ pytho

[web2py] Re: immediate web2py job opening

2010-02-02 Thread mdipierro
I love this post. I am sure you will get what you find. On a related note. A friend of mine from Milan who works in a Java shop told me that in Milan Python seems to be popular with web designer in the fashion industry. Can anybody confirm? Massimo On Feb 2, 4:20 pm, weheh wrote: > I have an im

[web2py] Re: Lulu sale

2010-02-02 Thread mdipierro
I remind high school students and residents from low income countries can have it for free. Just email me. (as long as I can deal with it). Massimo On Feb 2, 4:13 pm, Jonathan Lundell wrote: > In case anyone is about to buy a copy of the manual from Lulu, there's a 15% > discount through tomorr

[web2py] Re: module problem

2010-02-02 Thread mdipierro
Yes. My bad. reaload=True On Feb 2, 1:17 pm, DenesL wrote: > On Feb 2, 9:52 am, mdipierro wrote: > > > I suspect the problem is that you hardcoded a filename and if a second > > requests arrives it conflicts with the previous one. You may need file > > locking or using tempfile or stringio. This

[web2py] Re: web2py rocks!

2010-02-02 Thread mdipierro
Congratulations! any link we can look at? On Feb 2, 11:29 am, johntynan wrote: > We just had a successful launch of my first web2py app on Google App > Engine! > > KUNC, a public radio station in Greeley, Colorado, was the first > client to use the app, and they offered a lot of suggestions and >

Re: [web2py] new spanish user group created

2010-02-02 Thread Albert Abril
Gràcies!! Me agrego también! :) On Tue, Feb 2, 2010 at 11:29 PM, Andres Vargas - zodman wrote: > agregandome :> > > On Tue, Feb 2, 2010 at 9:14 AM, Gibran Rodriguez > wrote: > > > > > > On Tue, Feb 2, 2010 at 10:11 AM, DenesL wrote: > >> > >> New spanish speaking web2py user group created: > >

[web2py] Re: rows.response

2010-02-02 Thread mdipierro
Try this: {{db[table].id.represent=lambda id: A(id,_href=URL(r=request, c='default',f='data_clienti',args=id,vars={'table':table})})) {{=SQLTABLE(rows,_class='sortable',headers=dict([(rows.colnames[i],c) for (i,c) in enumerate(colonne)]))}} On Feb 2, 11:13 am, carlo wrote: > thank you Massimo,

[web2py] Re: New "Internal Error" page?

2010-02-02 Thread Jon Romero
sorry my bad (routes_onerror) On Feb 3, 1:30 am, Jon Romero wrote: > Is there an easy way to change the default error page to something > else? -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googleg

[web2py] New "Internal Error" page?

2010-02-02 Thread Jon Romero
Is there an easy way to change the default error page to something else? -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr

[web2py] Re: how to restore corrupted .table files?

2010-02-02 Thread Richard
my solution was to temporarily modify sql.py:_create() to always use fake_migrate=True. I found it is also necessary to set migrate=True or the .table files will not be generated so you get the same error again as soon as fake_migrate is set back to False. On Feb 3, 10:15 am, Richard wrote: > I

Re: [web2py] feature request: appadmin login - add a username

2010-02-02 Thread Wes James
Thx for this. I've been playing a bit with this to learn it. So in case someone else needs to start here is how I did it. 1. Get a fresh copy of web2py hg clone https://web2py.googlecode.com/hg/ web2py 2. make changes to a file (edit and save) 3. cd web2py 4. hg commit -m 'my commit' 5. hg

Re: [web2py] Re: how to restore corrupted .table files?

2010-02-02 Thread Jonathan Lundell
On Feb 2, 2010, at 3:09 PM, Richard wrote: > hmm, can't find "make_migrate" anywhere, even in trunk...although I > saw it discussed in another thread. It's fake_migrate. > > > On Feb 3, 1:42 am, mdipierro wrote: >> Do you have a custom auth_table? >> >> If so you can do: >> >> db.define_t

[web2py] Re: how to restore corrupted .table files?

2010-02-02 Thread Richard
I have a custom auth_user table but the rest are standard. I have added fake_migrate=True to my tables but web2py still complains about auth_group, etc. Is there a way to apply settings to these generated auth tables? On Feb 3, 1:42 am, mdipierro wrote: > Do you have a custom auth_table? > > If

[web2py] Re: how to restore corrupted .table files?

2010-02-02 Thread Richard
oh did you mean "fake_migrate"? You wrote "make_migrate" a few times in the forum, but the DAL uses "fake_migrate" On Feb 3, 10:09 am, Richard wrote: > hmm, can't find "make_migrate" anywhere, even in trunk...although I > saw it discussed in another thread. > > On Feb 3, 1:42 am, mdipierro wrot

[web2py] Re: how to restore corrupted .table files?

2010-02-02 Thread Richard
hmm, can't find "make_migrate" anywhere, even in trunk...although I saw it discussed in another thread. On Feb 3, 1:42 am, mdipierro wrote: > Do you have a custom auth_table? > > If so you can do: > >   db.define_table('auth_table',,migarte=False,make_migrate=True) > > Then you have to check

[web2py] upgrade flag missing

2010-02-02 Thread Richard
After downloading a new web2py version I used to use the upgrade flag to override the default apps, but now that seems to be missing: $ python web2py.py --upgrade=yes Usage: python web2py.py web2py.py: error: no such option: --upgrade This is documented in the manual on p309. How do I override t

[web2py] Re: DAL migration problem

2010-02-02 Thread Richard
This is awesome - thanks Thadeus! I develop with sqlite but deploy on postgres/GAE and almost always get caught by this. On Feb 3, 9:10 am, Jonathan Lundell wrote: > On Feb 2, 2010, at 1:19 PM, Thadeus Burgess wrote: > > > 1. Its only in two places. Once for tablename, and once for fieldname. >

Re: [web2py] Re: Newbie Question: Intellisense for Web2Py?

2010-02-02 Thread Thadeus Burgess
Have you tried it? -Thadeus On Tue, Feb 2, 2010 at 4:31 PM, DL wrote: > Are you sure?  I thought '__all__' was made for cases like this.. > > On Jan 21, 7:03 am, Thadeus Burgess wrote: >> It is not, it will not pull in the imports of other files. >> >> You have to specifically declare all m

[web2py] Re: Newbie Question: Intellisense for Web2Py?

2010-02-02 Thread DL
Are you sure? I thought '__all__' was made for cases like this.. On Jan 21, 7:03 am, Thadeus Burgess wrote: > It is not, it will not pull in the imports of other files. > > You have to specifically declare all modules that are imported that > you want available in the file that you want code com

Re: [web2py] new spanish user group created

2010-02-02 Thread Andres Vargas - zodman
agregandome :> On Tue, Feb 2, 2010 at 9:14 AM, Gibran Rodriguez wrote: > > > On Tue, Feb 2, 2010 at 10:11 AM, DenesL wrote: >> >> New spanish speaking web2py user group created: >> >> http://groups.google.com/group/web2py-usuarios/topics > > gracias!! > > -- > Gibran Rodriguez > Maemo Developer

[web2py] Lulu sale

2010-02-02 Thread Jonathan Lundell
In case anyone is about to buy a copy of the manual from Lulu, there's a 15% discount through tomorrow. Coupon code SHADOW. -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubsc

[web2py] immediate web2py job opening

2010-02-02 Thread weheh
I have an immediate opening for a web2py-saavy user interface designer with proximity to the Flatiron District in NYC. You will be working with a very cool bunch of guys and there will be many sightings of movie stars and extremely beautiful women and men. If you're interested, email me privately f

Re: [web2py] Re: DAL migration problem

2010-02-02 Thread Jonathan Lundell
On Feb 2, 2010, at 1:19 PM, Thadeus Burgess wrote: > 1. Its only in two places. Once for tablename, and once for fieldname. > And then this needs to be done for sql.py just in case DRY > > 2. Yes very chatty. What about the following? > > DAL('sqlite', pool_size=1, check_reserve=None) > DA

[web2py] Re: The state of the wiki and documentation in general

2010-02-02 Thread Christopher Steel
{falling off chair} On Feb 1, 10:42 pm, Thadeus Burgess wrote: > Because the web2py community is made up of people who use python for > real world work and have real world jobs to make money. Django fanboys > have nothing better to do all day than write docs in their parents > basement:) > > -Tha

Re: [web2py] Re: DAL migration problem

2010-02-02 Thread Thadeus Burgess
1. Its only in two places. Once for tablename, and once for fieldname. And then this needs to be done for sql.py just in case 2. Yes very chatty. What about the following? DAL('sqlite', pool_size=1, check_reserve=None) DAL('sqlite', pool_size=1, check_reserve='common') DAL('sqlite', p

Re: [web2py] Re: DAL migration problem

2010-02-02 Thread Jonathan Lundell
On Feb 2, 2010, at 12:48 PM, Thadeus Burgess wrote: > You can view a proposed change, I have sent this to Massimo to look at. > > http://code.google.com/r/thadeusburgess-web2py/source/detail?r=e875496cc5978200fb6c0aa0f85a8df1a945df21 > > I'm not sure what keywords we really want to use or not, b

Re: [web2py] Re: DAL migration problem

2010-02-02 Thread Wes James
+1 ! On Tue, Feb 2, 2010 at 1:48 PM, Thadeus Burgess wrote: > You can view a proposed change, I have sent this to Massimo to look at. > > http://code.google.com/r/thadeusburgess-web2py/source/detail?r=e875496cc5978200fb6c0aa0f85a8df1a945df21 > > I'm not sure what keywords we really want to use or

Re: [web2py] Re: DAL migration problem

2010-02-02 Thread Thadeus Burgess
You can view a proposed change, I have sent this to Massimo to look at. http://code.google.com/r/thadeusburgess-web2py/source/detail?r=e875496cc5978200fb6c0aa0f85a8df1a945df21 I'm not sure what keywords we really want to use or not, but this is a starting point. I added two lists to BaseAdapter

Re: [web2py] Re: DAL migration problem

2010-02-02 Thread Jonathan Lundell
On Feb 2, 2010, at 9:31 AM, Thadeus Burgess wrote: > Actually, we can use the Adaptors to hold specific keywords. So in > DAL.__init__ can have for fields if fieldname in > self._adapter.KEYWORDS then raise SyntaxError It's be nice to have a way to take advantage of the keyword lists in Adapters

Re: [web2py] Re: DAL migration problem

2010-02-02 Thread Thadeus Burgess
just as a note. "role" is a sql keyword in ansi-sql, it will be a reserved word in the next version of Transact-SQL/Sql-server, the other databases should be fine, and is used in auth. "table_name" is a reserved keyword in postgresql - http://www.postgresql.org/docs/8.3/static/sql-keywords-append

Re: [web2py] feature request: appadmin login - add a username

2010-02-02 Thread Wes James
OK - thx Thadeus! -wes On Tue, Feb 2, 2010 at 1:15 PM, Thadeus Burgess wrote: > The best way is to use mercurial and make a clone of web2py. > > Make your changes, and the commit them to your local version. > > Then you can run > > hg export tip >> /path/to/a/file.diff > > That will create your

Re: [web2py] feature request: appadmin login - add a username

2010-02-02 Thread Thadeus Burgess
The best way is to use mercurial and make a clone of web2py. Make your changes, and the commit them to your local version. Then you can run hg export tip >> /path/to/a/file.diff That will create your diff file you can send to massimo. Then massimo can import that file and it will assign you as

[web2py] feature request: appadmin login - add a username

2010-02-02 Thread Wes James
I would like to request that a username be added to the appadmin login. It would be nice to have one more layer of security. Since I'm guessing you will ask for a patch ;) Will someone provide some tips on how to do this? Do I keep a copy of the original py file, make my changes, then run d

[web2py] Re: dal.py

2010-02-02 Thread Thadeus Burgess
belay that :) was using sql.py's Field with dal.py's DAL -Thadeus On Tue, Feb 2, 2010 at 11:53 AM, Thadeus Burgess wrote: > migrate=True > > self.db.define_table('settings', >            Field('key'), >            Field('name'), >            Field('value', 'text'), >            Field('descr

[web2py] Re: SQLTABLE: how to customise it?

2010-02-02 Thread DenesL
On Feb 2, 2:00 pm, Stefan wrote: > Is there a way to expand the amount of characters in a field? I've > noticed that SQLTABLE (or more specifically, gluon.html.TABLE) tends > to truncate the amount of visible text. I'm attempting to us the > plugin_datatable plugin to display data, but I can't s

[web2py] Typo in sql.py

2010-02-02 Thread Elcio Ferreira
http://bazaar.launchpad.net/~mdipierro/web2py/devel/annotate/head%3A/gluon/sql.py#L3180 It's typed filedname instead of fieldname. Thanks! Elcio http://visie.com.br/ http://elcio.com.br/ http://www.tableless.com.br/ -- You received this message because you are subscribed to the Google Groups

[web2py] New features not documented in Book (2nd ed.)

2010-02-02 Thread DenesL
New features not documented in Book (2nd edition) 1.74.9 * Fixes security hole that affects 1.74.8 and 1.74.7 http://groups.google.com/group/web2py/browse_thread/thread/23c04866d81fe57d# 1.74.8 *** UPGRADE TO 1.74.9 IMMEDIATELY! *** http://groups.google.com/group/web2py/browse_thread/thread/23c04

[web2py] Re: module problem

2010-02-02 Thread DenesL
On Feb 2, 9:52 am, mdipierro wrote: > I suspect the problem is that you hardcoded a filename and if a second > requests arrives it conflicts with the previous one. You may need file > locking or using tempfile or stringio. This > > > exec('from applications.%s.modules import updatexml as xml' % >

[web2py] Re: SQLTABLE: how to customise it?

2010-02-02 Thread Stefan
Is there a way to expand the amount of characters in a field? I've noticed that SQLTABLE (or more specifically, gluon.html.TABLE) tends to truncate the amount of visible text. I'm attempting to us the plugin_datatable plugin to display data, but I can't seem to show the full contents of the record.

[web2py] Re: web2py rocks!

2010-02-02 Thread mikech
Congratulations! Any chance that you'll have some version that we can see screenshots of? -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to

[web2py] Yet another Windows Editor

2010-02-02 Thread mikech
http://www.sublimetext.com/. T he author uses Python for his extension language: "If you’re building an application, then your users will get much more out of it if you given them a plugin API. For Sublime Text, I settled on Python as the extension language. In fact, I think you’d be mad to choose

[web2py] dal.py

2010-02-02 Thread Thadeus Burgess
migrate=True self.db.define_table('settings', Field('key'), Field('name'), Field('value', 'text'), Field('description', 'text'), migrate=migrate ) First error testing out new dal.py Traceback (most recent call last): File "/ho

Re: [web2py] Re: DAL migration problem

2010-02-02 Thread Thadeus Burgess
Actually, we can use the Adaptors to hold specific keywords. So in DAL.__init__ can have for fields if fieldname in self._adapter.KEYWORDS then raise SyntaxError -Thadeus On Tue, Feb 2, 2010 at 11:28 AM, Thadeus Burgess wrote: > Massimo, is there a better place (in dal.py) to place this chec

Re: [web2py] Re: DAL migration problem

2010-02-02 Thread Thadeus Burgess
Massimo, is there a better place (in dal.py) to place this check. The most logical I see is the Field.__init__ constructor. -Thadeus On Tue, Feb 2, 2010 at 11:27 AM, Thadeus Burgess wrote: > I am working on this, I am integrating a list of reserved words into > the Field() class. > > For now

[web2py] web2py rocks!

2010-02-02 Thread johntynan
We just had a successful launch of my first web2py app on Google App Engine! KUNC, a public radio station in Greeley, Colorado, was the first client to use the app, and they offered a lot of suggestions and refinements on the work. Using, GAE, it only cost us $8.50 to pound away at the app for fi

Re: [web2py] Re: DAL migration problem

2010-02-02 Thread Thadeus Burgess
I am working on this, I am integrating a list of reserved words into the Field() class. For now just the common SQL keywords, which I'm sure can be extended to include backend-specific keywords. -Thadeus On Tue, Feb 2, 2010 at 11:08 AM, baloan wrote: > Thanks David for the reference. > > Bt

[web2py] Re: rows.response

2010-02-02 Thread carlo
thank you Massimo, this is my code snippet: {{for c in colonne:}} {{=c}}{{pass}} {{for r in rows.response:}} {{for k in range(len(r)):}} {{if k==0:}} {{=r[k]}} {{else:}} {{=r[k]}} {{pass}} {{pass}} {{pass}} On 2 Feb, 16:53, mdipierro wrote: > There is no more rows.response. That was an int

[web2py] Re: DAL migration problem

2010-02-02 Thread baloan
Thanks David for the reference. Btw, DATE is not marked as a reserved keyword on PostgreSQL and I can create DATE columns using SQL or the admin tools (pgadmin). Consequently I was doubly confused as DATE appears as a web2py reserved word to me. @Massimo: in your leisure time ;-) you may conside

Re: [web2py] Re: Search function

2010-02-02 Thread Thadeus Burgess
Feel free to take a look at http://code.google.com/p/blogitizor/source/browse/src/controllers/search.py Note you will see w = utils.w ws = utils.ws They just append wild cards to the variable. Look in http://code.google.com/p/blogitizor/source/browse/src/modules/utils.py for these two function

Re: [web2py] Re: DAL migration problem

2010-02-02 Thread Thadeus Burgess
I see so many of those I would use on a daily basis :( -Thadeus On Tue, Feb 2, 2010 at 8:41 AM, villas wrote: > I get so frustrated when bitten by the "reserved words" problem. > Unfortunately so many people only avoid the ones for their own chosen > database, which is such a shame when it m

Re: [web2py] admin access from remote machine

2010-02-02 Thread Wes James
If w2p is running on port 8000 and you need someone to get to that port you need to make an exception in the firewall. Click Start then run type in firewall.cpl press enter click on Exceptions tab click on add port button in name box put web2py 8000 in port number put in 8000 click on ok Someone

[web2py] Re: admin access from remote machine

2010-02-02 Thread Al
I did try https but also with no success. Also querying the port of this server (using portqry) gives NOT LISTENING. If the web2py built- in server is running on port 8000, why does it say not listening? -- You received this message because you are subscribed to the Google Groups "web2py-users"

[web2py] Re: admin access from remote machine

2010-02-02 Thread mdipierro
Yes. Instead of 127.0.0.1:8000 you need 0.0.0.0:80 or the IP address of your own machine. On Feb 2, 9:49 am, Al wrote: > I have not "integrate" it with the w2k3 server, I just click the > web2py.exe and run the built-in server. Do I need to start the server > in a special way so that I can use ht

[web2py] Re: rows.response

2010-02-02 Thread mdipierro
There is no more rows.response. That was an internal variable. It is gone long ago. If you show us how you were using we can point to a simple fix. On Feb 2, 9:43 am, carlo wrote: > I must have missed something lately, so forgive my question if it is a > faq. > > I have an application where I use

[web2py] Re: format zero IS_IN_DB

2010-02-02 Thread DenesL
^bump^ -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http:

[web2py] Re: admin access from remote machine

2010-02-02 Thread Al
I have not "integrate" it with the w2k3 server, I just click the web2py.exe and run the built-in server. Do I need to start the server in a special way so that I can use https to gain admin access? Any setting I have to twist in this Cherry web server? Al -- You received this message because you

[web2py] rows.response

2010-02-02 Thread carlo
I must have missed something lately, so forgive my question if it is a faq. I have an application where I used rows.response in a view: it was ok until version 1.6.xx but it fails in the latest version, what is changed? thank you carlo -- You received this message because you are subscribed to

Re: [web2py] admin access from remote machine

2010-02-02 Thread Drapko Nitzhonot
I use HTTPS and I can access from any LAN machine without any problem. Follow http://www.web2py.com/AlterEgo/default/show/140 steps I start the server with: python web2py.py --nogui -c server.crt -k server.key -i 192.168.1.1 -p -a myserverpassword On Tue, Feb 2, 2010 at 4:27 PM, Timothy Farr

Re: [web2py] admin access from remote machine

2010-02-02 Thread Timothy Farrell
Al, I run a similar setup. But it matters which webserver you're using. If you don't know, then you're using the built-in webserver. If you can access the website from the server itself there are two things to check (this assumes the built-in webserver): 1) Did you configure web2py to serve

Re: [web2py] new spanish user group created

2010-02-02 Thread Gibran Rodriguez
On Tue, Feb 2, 2010 at 10:11 AM, DenesL wrote: > New spanish speaking web2py user group created: > > http://groups.google.com/group/web2py-usuarios/topics > gracias!! -- Gibran Rodriguez Maemo Developer and Quality Assurance Manager Mobengi (Mobile-Engineering) Helsinki, Finland email: gibran

[web2py] new spanish user group created

2010-02-02 Thread DenesL
New spanish speaking web2py user group created: http://groups.google.com/group/web2py-usuarios/topics -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group,

Re: [web2py] Re: compile app error

2010-02-02 Thread Wes James
I found the problem. When you do a compile you are adding a path on to the front of: {{extend '../../plugin_t2/views/layout.html'}} lines and this does not work when being compiled. During the data=parse_template in compile_views parse_template constructs a path: //applications/app/views/

[web2py] Re: module problem

2010-02-02 Thread mdipierro
I suspect the problem is that you hardcoded a filename and if a second requests arrives it conflicts with the previous one. You may need file locking or using tempfile or stringio. This > exec('from applications.%s.modules import updatexml as xml' % > request.application) > reload(xml) could also

[web2py] Re: Search function

2010-02-02 Thread mdipierro
Search is a complex issues how to implement really depends on the type of data, size of data and number of users. A simple minimalist solution is #view default/index.html {{=results}} #controller default.py def index(): keywords=[] if request.vars.keywords: keywords = [x for x i

[web2py] Re: admin access from remote machine

2010-02-02 Thread mdipierro
How did you integrate it with windows 003 server? Are you using it as a proxy? Are you sure you are not simply running the built-in web server on localhost? Massimo On Feb 2, 4:00 am, Al wrote: > Hi, > > I have just started to learn web2py recently. I have installed web2py > in a windows 2003 se

[web2py] Re: how to restore corrupted .table files?

2010-02-02 Thread mdipierro
Do you have a custom auth_table? If so you can do: db.define_table('auth_table',,migarte=False,make_migrate=True) Then you have to check in SQL that all columns you expect are there. massimo On Feb 2, 2:56 am, Richard wrote: > Some of my .table files have become corrupted, so that I get

[web2py] Re: DAL migration problem

2010-02-02 Thread villas
I get so frustrated when bitten by the "reserved words" problem. Unfortunately so many people only avoid the ones for their own chosen database, which is such a shame when it means their code is not portable. Anyway, this checklist is my favourite reference when I have a doubt: http://drupal.org/n

[web2py] Re: Decode field in one to many relation

2010-02-02 Thread ceriox
I resolve my problem with In the view display db.Storage[row.Object_id].Model for each row in rows thanks DenesL and mdipierro On 2 Feb, 15:08, ceriox wrote: > mysql > > On 1 Feb, 14:39, mdipierro wrote: > > > what db? The left=... only works on rdbms, not on GAE. -- You received this messag

[web2py] Re: Decode field in one to many relation

2010-02-02 Thread ceriox
mysql On 1 Feb, 14:39, mdipierro wrote: > what db? The left=... only works on rdbms, not on GAE. -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send

Re: [web2py] Re: Webgrid so strange!

2010-02-02 Thread Carlos Costa
Well, now it´s working again. The tip you gave was very valuable! I went to confirm what encoding I have been working with because recently I have changed from editor and was not sure. It´s utf8 rightnow but I changed from ascii yesterday. As it works now, I think that was actually the problem, m

[web2py] Re: Creating a new auth session

2010-02-02 Thread Jon Romero
But then how auth.user is updated? >All auth does on successful login is: >from gluon.storage import Storage >session.auth=Storage() >session.auth.user = db(db.auth_user.id==logged_in_user_id).select ().first() >session.auth.user_id = session.auth.user.id >session.auth.last_visit = request.now >

[web2py] module problem

2010-02-02 Thread Oguz Yarimtepe
In my application i have a updatexml.py under modules directory and at the controller i am calling it as exec('from applications.%s.modules import updatexml as xml' % request.application) reload(xml) result = ta.write() return result At the updatexml i have something like: import os def write

[web2py] Search function

2010-02-02 Thread Al
I am trying to incorporate a "Search" function into my web2py application. I have found similar thing in the sample appliance such as the KPAX and the C.R.M application, could someone detail how I could copy code from these apps. Is there a way to trace the relevant section of code for the search f

Re: [web2py] admin access from remote machine

2010-02-02 Thread tiago almeida
Have you tried accessing your server with https:// ? I think it should allow admin control over https. On Tue, Feb 2, 2010 at 10:00 AM, Al wrote: > Hi, > > I have just started to learn web2py recently. I have installed web2py > in a windows 2003 server and it runs OK, but I cannot access it fro

[web2py] admin access from remote machine

2010-02-02 Thread Al
Hi, I have just started to learn web2py recently. I have installed web2py in a windows 2003 server and it runs OK, but I cannot access it from any other machine. I have looked thru a few discussions which described using tunneling and proxy stuff, is there a simple way to disable such security - e

Re: [web2py] Re: The state of the wiki and documentation in general

2010-02-02 Thread tiago almeida
Ok. cool. Will keep an eye on the mailing list and see what I can do about the docstrings. Thanks, Tiago - (...) > > Personally, I could use help in fixing the docstrings and unittests so > that documentation would be automatically generated using Sphinx. This > is the only way to have docs t

[web2py] Re: Extra cron processes under Ubuntu 9.10 and Snow Leopard after upgrade to 1.74.9

2010-02-02 Thread AchipA
As Massimo says -N will disable cron. The two cron tasks you see should be expiring sessions to avoid piling up of files in the session dir. Note that if you use extcron, the web2py serving the pages is not the parent (so killing it does nothing to those started by the system cron) On Feb 1, 10:4

[web2py] how to restore corrupted .table files?

2010-02-02 Thread Richard
Some of my .table files have become corrupted, so that I get this error: Traceback (most recent call last): File "web2py/gluon/restricted.py", line 178, in restricted exec ccode in environment File "web2py/applications/studio09/models/db.py", line 165, in Field('video', db.media), F