[web2py:25468] Exception: cursor already closed

Hi everyone I'm encapsulating a couple of classes into a file under myapp/modules and initialize some of them with "db" object. The weired thing is that after one successful query I got "cursor already closed" exception later on. Any suggestions? --~--~-~--~~~---~--~--

[web2py:25467] Re: If...else ...if versus if...elif...else

Yarko, > Does this help clarify? Yes, thank you very much. > But you can keep the form you have. Among other things, with Python this > uses short circuit evaluation, so it's more efficient. The form was my biggest worry. Although the truth tables did not proof me wrong, I started to doubt th

[web2py:25466] Re: Pages showing up blank.

Are you sure you did not edit routes.py? On Jul 1, 10:20 pm, Jason Brower wrote: > I will look into that one.  For now I am running a strait copy of my > program. > Regards, > Jason > > On Thu, 2009-07-02 at 00:07 -0300, Álvaro Justen [Turicas] wrote: > > On Wed, Jul 1, 2009 at 23:31, Jason Brow

[web2py:25465] Re: web2py on apache with fastcgi

Did the method work on Windows? I've just rechecked the url http://wiki.dreamhost.com/Web2py and it loaded fine for me. You you still can't get it loaded, let me know, and I will send you a copy. On Wed, Jul 1, 2009 at 9:01 PM, giohappy wrote: > > Thanks Alexei for sharing your method. > I alre

[web2py:25464] Re: Feature IDEA: Auto Deploy Web2py Apps

I don't know exactly what you're asking for, but I have to say that MY server won't ever expose FTP on an open port. And restarting my server is a *big* deal since it terminates all processes (of which web server is only one) so I try to never do it unless I must. I love to use SSH because it's

[web2py:25463] Re: Pages showing up blank.

I will look into that one. For now I am running a strait copy of my program. Regards, Jason On Thu, 2009-07-02 at 00:07 -0300, Álvaro Justen [Turicas] wrote: > On Wed, Jul 1, 2009 at 23:31, Jason Brower wrote: > > I have started to deploy my applicaton. > > I donwloaded the latest web2py extrac

[web2py:25462] Re: routes.py question

Thank you ceej. This will be for a single app install. I found this in the manual just now (I swear I looked before posting!): routes_in=( ('/(?P.*)','/init/\g'), ) routes_out=( ('/init/(?P.*)','/\g'), ) It seems to be working as advertised. Any drawbacks compared to your method? On Jul 1, 9:5

[web2py:25461] Re: Pages showing up blank.

On Wed, Jul 1, 2009 at 23:31, Jason Brower wrote: > I have started to deploy my applicaton. > I donwloaded the latest web2py extracted it and it's working. > No on my personally computer I packaged my app and sent it to the > server.  Now I have it installed, all the data is there, but all I get >

[web2py:25460] Re: routes.py question

in your routes.py file, just add to routes.example.py and rename to routes.py. On Jul 1, 9:51 pm, "mr.freeze" wrote: > Can I use routes.py to make my application run from:http://myserver > instead of:http://myserver/myapp > > If not, can it be done another way?  My domain name and app are the >

[web2py:25459] Re: routes.py question

yes you can do: routes_in=( ('/admin(?P.*)', '/admin\g'), ('/login(?P.*)', '/myapp/auth/login\g'), ('/logout(?P.*)', '/myapp/auth/logout\g'), ('/register(?P.*)', '/myapp/auth/register\g'), ('/verify_email(?P.*)', '/myapp/auth/verify_email\g'), ('/change_password(?P.*)', '/myapp/auth/change_

[web2py:25458] routes.py question

Can I use routes.py to make my application run from: http://myserver instead of: http://myserver/myapp If not, can it be done another way? My domain name and app are the same name so it ends up looking weird: http://myweb2pyapp.com/myweb2pyapp (fake names but hopefully you get the idea) Thanks

[web2py:25457] Pages showing up blank.

I have started to deploy my applicaton. I donwloaded the latest web2py extracted it and it's working. No on my personally computer I packaged my app and sent it to the server. Now I have it installed, all the data is there, but all I get is the dark background from my CSS style sheet. Nothing el

[web2py:25456] Re: Report in pdf format

On Wed, Jul 1, 2009 at 17:20, __Kyo__ wrote: > I have been looking for ways to create reports in PDF using reportlab, > I can create pdf but I can not do to be saved. How can you do with an > RTF file or csv. Thanks in advance. Hi, in one of web systems that I'm creating am using Pisa (that uses

[web2py:25455] Feature IDEA: Auto Deploy Web2py Apps

I like the feature in tomcat, it's the only feature I like, that let's you take a complressed directory, WAR file, put it in a certain directory and after restarting tomcat it unpacks it and has it ready to do. I wonder if we could create something like this, as I have to login to a computer with

[web2py:25454] Re: XForms version of SQLFORM

SQLFORM was never meant to be the only option for form generation and processing. It was meant to be an example. It got so big because people kept submitting good patches. I hope to see alternatives to SQLFORM (XFORM?) with compatible syntax but different functionality. Not all options/aternative

[web2py:25453] Re: XForms version of SQLFORM

Another interesting XForms implementation seems to me http://www.orbeon.com/ I guess * 'fully interactive forms' without the need for writing form code/ AJAX/... see Form Builder * 'as-you-type-validation' * 'form submissions are handled for you' * 'no more struggling with AJAX/scripting language

[web2py:25452] Re: web2py 1.65.0 is out

On Jul 1, 6:04 pm, Dan wrote: > > new auth.settings.create_user_groups > > good! > > > tickets stored on datastore on GAE and also logged, (Hans and Alexey) > > great! This is something that will help me a lot. Mind that the tickets are stored but the piece in admin to retrieve them is still mis

[web2py:25451] Re: web2py 1.65.0 is out

> new auth.settings.create_user_groups good! > tickets stored on datastore on GAE and also logged, (Hans and Alexey) great! This is something that will help me a lot. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "

[web2py:25450] Re: Why new auth_group automatically created with new users?

In web2py 1.65.0 I try in Models : auth=Auth(globals(),db) # authentication/ authorization auth.settings.create_user_groups=False ... It works ! (for True too...) Thanks ++ for Ultra Speed Reactivity !! Jean-Marc --~--~-~--~~~---~--~~ You re

[web2py:25449] Re: External Libraries...

See also my recent reply to Xie on a recent thread: [web2py:25413] Re: confusion about web2py's MVC namespace On Wed, Jul 1, 2009 at 4:51 PM, mdipierro wrote: > > No app/modules and controllers folder are not in the paths > > try prin

[web2py:25448] Re: External Libraries...

No app/modules and controllers folder are not in the paths try print sys.path to be sure note: do not modify you sys.path in the web2py apps of you run into memory leaks and threading issues. If you really need to, paths should only be modified in web2py.py Massimo On Jul 1, 4:35 pm, JohnMc

[web2py:25447] Re: External Libraries...

Generally use source as the test box is a linux machine. But thanks for the tip. I'll go check my paths. That does bring up a followup question. For Web2Py is the search heirarchy == controller-->app/module/-->python path ? Thanks. JohnMc On Jul 1, 4:23 pm, mdipierro wrote: > You code below

[web2py:25446] Re: External Libraries...

You code below is correct, you just have to make sure the libraries are in the search path. If you use third party libraries you should run web2py from source else you may run into trouble because you would have two python interepreters (the one that ships with binaries and the one you used to ins

[web2py:25445] External Libraries...

I have a problem that has me stumped. Code snippet below. Attempting to import two external libraries that I built. I receive a ticket indicating module not found in app/module folder which is to be expected. I looked in the manual, AlterEgo and this group. There was a reference back in April to t

[web2py:25444] Report in pdf format

I have been looking for ways to create reports in PDF using reportlab, I can create pdf but I can not do to be saved. How can you do with an RTF file or csv. Thanks in advance. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google

[web2py:25443] Re: Maemo 2009

On 29 juin, 23:04, mdipierro wrote: > Here is the ppt of my 5 min lightening talk at pycon > > http://www.web2py.com/examples/static/lightening.ppt Thanks, that would be a good starting point... too bad the comments were in your head and not in the slide notes :-) --~--~-~--~~--

[web2py:25442] Re: confusion about web2py's MVC namespace

On Wed, Jul 1, 2009 at 9:19 AM, 小谢 wrote: .. > Thanks. It really helped. It's lucky that the project is still in its > early stage and we'll be refactoring the existing code with respect to > web2py's conventions. > Glad it helped. Of course, you do not need to import for every request (ov

[web2py:25441] Re: OperationalError is not defined at model creation time

No problem at all. A false alarm is better than a missing bug report. In fact the former gives us the possibility to run one more test and eventually fix one more bug sooner (if it is there). Massimo On Jul 1, 1:25 pm, MikeEllis wrote: > I think the test sequence below verifies that the proble

[web2py:25440] Re: OperationalError is not defined at model creation time

I think the test sequence below verifies that the problem was mine and not web2py's. Basically, I thought I had removed all the .table and storage files from version control, but it turns out I missed a few. This was causing all sorts of problems as I went back and forth between the development

[web2py:25439] Re: web2py 1.65.0 is out

No. Just personal time constraints. I will try to it tonight ro tomorrow. Sorry. Massimo On Jul 1, 1:17 pm, Markus Gritsch wrote: > Hi, > > is there any particular reason why this release does not use the > unicode-patched Windows binary distribution it was asked to build? > > Markus > > On Wed

[web2py:25438] Re: web2py 1.65.0 is out

Hi, is there any particular reason why this release does not use the unicode-patched Windows binary distribution it was asked to build? Markus On Wed, Jul 1, 2009 at 7:30 PM, mdipierro wrote: > > Please try it. > > reST complaint docstrings for Sphinx (Hans) > gluon/conrtib/login_methods/gae_g

[web2py:25437] Re: db.define_table on postgres

The only thing I can think of is that you are defining the same table twice. Massimo On Jul 1, 12:12 pm, haftish21 wrote: > I'm on page 137 of the manual... > > In[3]: db.define_table('person', SQLField('name')) > > Out[3]: Traceback (most recent call last): >   File "", line 1, in >   File "D

[web2py:25436] web2py 1.65.0 is out

Please try it. reST complaint docstrings for Sphinx (Hans) gluon/conrtib/login_methods/gae_google_account.py for google CAS login on GAE (Hans) fixed problem with Auth and Firebird 'password' issue new auth.settings.create_user_groups tickets stored on datastore on GAE and also logged, (Hans and

[web2py:25435] Re: XForms version of SQLFORM

right now you can do requires=IS_IN_DB(...) # options or requires=[IS_IN_DB(...)] # no options both cases validate the same serverside. I think the same may work with XForms On Jul 1, 11:36 am, Hans Donner wrote: > depending on the volume of the data the IS_IN_DB can be included (eg > data in

[web2py:25434] db.define_table on postgres

I'm on page 137 of the manual... In[3]: db.define_table('person', SQLField('name')) Out[3]: Traceback (most recent call last): File "", line 1, in File "D:\allWeb2py\web2pySource\gluon\sql.py", line 975, in define_table raise SyntaxError, 'invalid table name: %s' % tablename SyntaxErro

[web2py:25433] Re: Readable/writable fields and crud.read / SQLFORM readonly

Tested on trunk (r1090), works OK now. Thanks! -P On Jul 1, 5:03 pm, mdipierro wrote: > I think this is now fixed in trunkk, but give it a try. > > On Jul 1, 9:08 am, Peter wrote: > > > > but not show it in crud.read and SQLTABLEs > > > Exactly, that is what I would expect. > > > My point is t

[web2py:25432] Re: Options widget

On Wed, Jul 1, 2009 at 7:11 AM, annet wrote: > > Yarko, > > > the reason I am doing all this - I like to see how much can be > solved > > with structure, and thus minimize code (need for widget)... > > > > ... so first I'm trying to understand the kind of strucuture that is > > "natural" in

[web2py:25431] Re: XForms version of SQLFORM

depending on the volume of the data the IS_IN_DB can be included (eg data in javascript or so), so with jquery you can do some checking. in the end, validation must always be done on the server side 2009/7/1 mdipierro : > > this > >> IS_NOT_IN_DB = I don't see how to support this > > would only

[web2py:25430] Re: If...else ...if versus if...elif...else

On Wed, Jul 1, 2009 at 2:04 AM, annet wrote: > > > Back to the logic: > > not(p or q or r) is equivalent to: not p and not q and not r > (DeMorgans' theorem) > > Duvo said I should use not p *or* not q *or* not r instead of not (p or q > or r) This is incorrect; I think duvo made a type/mist

[web2py:25429] Re: XForms version of SQLFORM

this > IS_NOT_IN_DB = I don't see how to support this would only be serverside so nothing to do. On Jul 1, 10:56 am, Fran wrote: > On Jul 1, 4:39 pm, mdipierro wrote: > > > If XForms hanles select/options it must be possible to send the > > options. no? > > IS_IN_SET = no problem > IS_IN_DB

[web2py:25428] Re: Using auth function (Approval)

did not get it: mdipie...@cs.depaul.edu On Jul 1, 10:47 am, Rob Scheibel wrote: > Emailed. Thanks for looking at it for me! > > -rob > > On Jul 1, 9:45 am, mdipierro wrote: > > > can you please email me your db.py? > > > On Jul 1, 5:12 am, Rob Scheibel wrote: > > > > Thanks for the quick reply

[web2py:25427] Re: XForms version of SQLFORM

On Jul 1, 4:39 pm, mdipierro wrote: > If XForms hanles select/options it must be possible to send the > options. no? IS_IN_SET = no problem IS_IN_DB = ok, although we should continually refresh the form to see new data being added IS_NOT_IN_DB = I don't see how to support this The 'only show th

[web2py:25426] Re: Cron Gui

A few notes about such a potential gui: - take into account that different machines might share databases - the recommended place for job scripts is the 'cron' directory - the interface should support two way synch (so you still keep the crontab format) - the interface should support the web2py c

[web2py:25425] Re: Using auth function (Approval)

Emailed. Thanks for looking at it for me! -rob On Jul 1, 9:45 am, mdipierro wrote: > can you please email me your db.py? > > On Jul 1, 5:12 am, Rob Scheibel wrote: > > > Thanks for the quick reply! I added the line > > "auth.settings.table_user=db.siteuser" and I'm still getting the same > > e

[web2py:25424] Re: Forms formating funny...

By default SQLTABLE does a truncate on the contents (you can set this paramet to a higher value), and indeed the fully qulaified fieldnames (that is for normal fields including the tablename) are shown on top. To render it properly you have to render the table/form yourself in a view. 2009/7/1 Ja

[web2py:25423] Re: XForms version of SQLFORM

If XForms hanles select/options it must be possible to send the options. no? On Jul 1, 10:28 am, Fran wrote: > Whilst most stuff seems starightforward, the harder cases are things > like: > > db.budget_item.code.requires = IS_NOT_IN_DB(db, 'budget_item.code') > Obviously if working offline then

[web2py:25422] Re: Cron Gui

send me a prototype. we may need a few iterations on this one but it is a good idea. Massimo On Jul 1, 10:23 am, Angelo Compagnucci wrote: > Thanks for the great work Massimo! > > I could implement such featur if it's desired. > I'm managing a work in wich I've to schedule some jobs on a Solari

[web2py:25421] Re: XForms version of SQLFORM

Whilst most stuff seems starightforward, the harder cases are things like: db.budget_item.code.requires = IS_NOT_IN_DB(db, 'budget_item.code') Obviously if working offline then this referencedata isn't available - I guess we just have to ignore that within the XForm itself & handle it during form

[web2py:25420] Re: Cron Gui

Thanks for the great work Massimo! I could implement such featur if it's desired. I'm managing a work in wich I've to schedule some jobs on a Solaris 10 system and in the same time I have to retrive a job output via an html get. How cold this can be done? I'm thinking on a model for the job sch

[web2py:25419] Re: XForms version of SQLFORM

On Jul 1, 4:07 pm, mdipierro wrote: > Interesting. we should be able to support something like this. Can you > post some examples. I cannot find any on the docs. I'm working from: http://code.javarosa.org/wiki/buildxforms (This has example forms) So for a simple model: db.define_table(budget_it

[web2py:25418] Re: XForms version of SQLFORM

Interesting. we should be able to support something like this. Can you post some examples. I cannot find any on the docs. MAssimo On Jul 1, 8:42 am, Fran wrote: > I would like to be able to make use of JavaRosa[1] to input data on a > J2ME handheld & pass to a back-end Web2Py server. > This req

[web2py:25417] Forms formating funny...

I have a form like this... form=FORM(SQLTABLE(rows),INPUT(_type='submit')) if form.accepts(request.vars): for i in request.vars: if i.startswith("check"): tagID = i.replace("check", "") db.user_tags.insert(tag_id=tagID, user_id=auth.user.i

[web2py:25416] Re: Readable/writable fields and crud.read / SQLFORM readonly

I think this is now fixed in trunkk, but give it a try. On Jul 1, 9:08 am, Peter wrote: > > but not show it in crud.read and SQLTABLEs > > Exactly, that is what I would expect. > > My point is that even with the setting .readable=False (and .writable > True), the field IS shown in crud.read outp

[web2py:25415] Re: [Bump: email not working]

I luckily got it working with my gmail account. I have set up an account for the conference and it actually working fairly well. I have another question I have posted but it's not a part of this thread. Thank you very very much! Regards, Jason On Tue, 2009-06-30 at 21:10 -0700, mr.freeze wrote

[web2py:25413] Re: confusion about web2py's MVC namespace

On Jul 1, 1:09 pm, Yarko Tymciurak wrote: > Hi Xie - > > The reason this worked as you described: > > For each request to your application,  web2py runs, finds your (the request) > application, > executes each file in the models directory (since the connection needs to be > defined), > and then

[web2py:25414] Re: Readable/writable fields and crud.read / SQLFORM readonly

yes, there is a bug that is causing this. I will try fix it later today On Jul 1, 9:08 am, Peter wrote: > > but not show it in crud.read and SQLTABLEs > > Exactly, that is what I would expect. > > My point is that even with the setting .readable=False (and .writable > True), the field IS shown

[web2py:25412] Re: Readable/writable fields and crud.read / SQLFORM readonly

hoho... that is a bug then. Let me check! Massimo On Jul 1, 9:08 am, Peter wrote: > > but not show it in crud.read and SQLTABLEs > > Exactly, that is what I would expect. > > My point is that even with the setting .readable=False (and .writable > True), the field IS shown in crud.read output. >

[web2py:25411] Re: Readable/writable fields and crud.read / SQLFORM readonly

> but not show it in crud.read and SQLTABLEs Exactly, that is what I would expect. My point is that even with the setting .readable=False (and .writable True), the field IS shown in crud.read output. -P On Jul 1, 3:50 pm, mdipierro wrote: > This is the correct behaviours. It maens you can wan

[web2py:25410] Re: how can i write a PIL image object to response

You can do it like in django: from PIL import Image def image(): image = Image.new("RGB", (800, 600)) response.headers['Content-Type']="image/png" image.save(response.body, "PNG") return response.body.getvalue() response.body is a StringIO On Jul 1, 4:40 am, hywang wrote:

[web2py:25408] Re: Readable/writable fields and crud.read / SQLFORM readonly

This is the correct behaviours. It maens you can want to edit/update the field but not show it in crud.read and SQLTABLEs On Jul 1, 8:04 am, Peter wrote: > Given this controller: > def vread(): >     db.auth_user.something.readable=False >     db.auth_user.something.writable=True >     return di

[web2py:25409] how can i write a PIL image object to response

django do it like this: from django.utils.httpwrappers import HttpResponse from PIL import Image def image(request): image = Image.new("RGB", (800, 600)) response = HttpResponse(mimetype="image/png") image.save(response, "PNG") return response in web2py, I did it with a file, fi

[web2py:25407] Re: OperationalError is not defined at model creation time

Something got corrupted. try this: copy somewhere the sqlite file remove everything in databases set migrate=True run appadmin once copy your sqlite file back Massimo On Jul 1, 7:45 am, MikeEllis wrote: > I'm confused, too! > > Tables were created by web2py >     yes, they are sqlite tables >

[web2py:25406] Re: Using auth function (Approval)

can you please email me your db.py? On Jul 1, 5:12 am, Rob Scheibel wrote: > Thanks for the quick reply! I added the line > "auth.settings.table_user=db.siteuser" and I'm still getting the same > error. Here's the traceback: > > Traceback (most recent call last): >   File "/home/rob/Desktop/web2

[web2py:25405] Re: Cron Gui

no sorry On Jul 1, 4:27 am, Angelo Compagnucci wrote: > Hi list members! > > Is there any cron configuration gui for web2py? > Or a method to expose a cron configuration page to modify cron jobs from web? > > Thanks! --~--~-~--~~~---~--~~ You received this message

[web2py:25404] XForms version of SQLFORM

I would like to be able to make use of JavaRosa[1] to input data on a J2ME handheld & pass to a back-end Web2Py server. This requires the creation of XForms[2] on the handheld. It seems like it should be /reasonably/ easy to write an equivalent of sqlhtml.py to auto-generate these from the Model.

[web2py:25403] Re: [Bump: email not working]

On Jul 1, 1:59 pm, Jason Brower wrote: > I get the following error: > reply: '250 2.0.0 Ok: queued as B207C1FD5A\r\n' This doesn't seem like an error to me - your Postfix has accepted the mail delivered by Python. I guess you need help from a #postfix support group to see why Postfix isn't sendi

[web2py:25402] Readable/writable fields and crud.read / SQLFORM readonly

Given this controller: def vread(): db.auth_user.something.readable=False db.auth_user.something.writable=True return dict(form=crud.read(db.auth_user,auth.user.id)) I would expect the field to be suppressed in output. This is not the case, but when I set *.writable* to False as well

[web2py:25399] Re: [Bump: email not working]

I get the following error: From: encomp...@gmail.com To: encomp...@gmail.com Enter message, end with ^D (Unix) or ^Z (Windows): bla bla bla Message length is 65 send: 'ehlo [127.0.1.1]\r\n' reply: '250-essence\r\n' reply: '250-PIPELINING\r\n' reply: '250-SIZE 1024\r\n' reply: '250-VRFY\r\

[web2py:25401] Re: web2py on apache with fastcgi

Thanks Alexei for sharing your method. I already had found the cited AlterEgo page traces on google, but trying to access it result in an Internal Error. giovanni On 1 Lug, 07:16, Alexei Vinidiktov wrote: > Actually, it's already kind of on AlterEgo. > > I used the instructions for installing w

[web2py:25400] Re: [Bump: email not working]

I do have my google account. How do I set it up to use that? Regards, Jason On Tue, 2009-06-30 at 21:10 -0700, mr.freeze wrote: > You might try sending an email from the Python shell using the script > below. > (from http://docs.python.org/library/smtplib.html) It should at least > give you an

[web2py:25398] Re: OperationalError is not defined at model creation time

I'm confused, too! Tables were created by web2py yes, they are sqlite tables This is important for me to resolve, so I'm going to spend some time trying to reliably reproduce the problem in as few steps as possible. Thanks again for the help, web2py is a truly impressive product and I reall

[web2py:25397] Re: Options widget

Yarko, > the reason I am doing all this - I like to see how much can be solved > with structure, and thus minimize code (need for widget)... > > ... so first I'm trying to understand the kind of strucuture that is > "natural" in what you are dealing with... A mathematical approach (structur

[web2py:25396] Re: Using auth function (Approval)

Thanks for the quick reply! I added the line "auth.settings.table_user=db.siteuser" and I'm still getting the same error. Here's the traceback: Traceback (most recent call last): File "/home/rob/Desktop/web2py/gluon/restricted.py", line 107, in restricted exec ccode in environment File "/

[web2py:25395] Cron Gui

Hi list members! Is there any cron configuration gui for web2py? Or a method to expose a cron configuration page to modify cron jobs from web? Thanks! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Fra

[web2py:25394] grouping detail rows

Though I'd share it with you, made this one this morning during my train commute to work ad I need some grouping on GAE. It's now standalone, and not yet integrated into the DAL. #!/usr/bin/env python #coding=utf-8 import cPickle def group(detail_rows, detail_fields, key_fields=None): """

[web2py:25393] Re: If...else ...if versus if...elif...else

Massimo, So, the rewritten function is correct? Back to the logic: not(p or q or r) is equivalent to: not p and not q and not r (DeMorgans' theorem) Duvo said I should use not p or not q or not r instead of not (p or q or r) but in case not 1 or not 1 or not 1 this would result in 0 or 0 or