[web2py:37200] problem with DAL in shell using 1.74.1

ql.py", line 887, in ProgrammingError: Cannot operate on a closed database. === I checked the mailing list, and i see no previous reference to this problem. Thanks a lot! Jake -- You received this message because you are subscribed to the Google Groups "web2py-users"

[web2py:37202] Re: problem with DAL in shell using 1.74.1

On Dec 14, 8:06 pm, mdipierro wrote: > Is this the web based shell? > Yes, on Windows XP served from localhost with the included web server. ty Jake -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, s

[web2py:37362] Re: web2py blog screencast

Hot tip: on Windows, download VLC player. Add some controls to step forward and backward, Change the speed as needed. Makes it much easier to play along at home vs QuickTime Player. Jake (More substantial comments to follow) -- You received this message because you are subscribed to the

[web2py:37406] web2py.gluon.dal vs. web2py.gluon.sql

Hi, Is the web2py.gluon.dal module a replacement for the web2py.gluon.sql module? If not, how do they relate? I see the same classes defined in both, and they both export DAL and Field. TY, Jake -- You received this message because you are subscribed to the Google Groups "web2py-

[web2py:37410] Re: web2py.gluon.dal vs. web2py.gluon.sql

dbs, and provide > additional functionality. It is 50% done. It is there so people can > look at it and perhaps help with testing. > > Massimo > > On Dec 16, 5:07 pm, Jake wrote: > > > Hi, > > > Is the web2py.gluon.dal module a replacement for the web2py.gluon.sql &g

[web2py:37515] Understanding the DAL

hat information do you have to send as parameters of the db() call, what information do you send as parameters of the .select() method, and why? Thank you very much, and please correct me if i'm wrong about something, which is very likely. Jake -- You received this message because you a

[web2py:37517] Re: Understanding the DAL

Thanks Mengu, it helps a lot. On Dec 18, 8:35 am, Mengu wrote: > Dear Jake > > the information goes between db() is the query. for example, > usersWithNameJake = (db.auth_user.first_name == "Jake") is a query > which you can use as db(usersWithNameJake). > > the

[web2py:37526] Re: web2py blog screencast

community! Jake -- 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 thi

[web2py:37527] Re: Understanding the DAL

pydocs, and yes, they've been very enlightening. On Dec 18, 9:36 am, DenesL wrote: > Jake, > > one of the things that helped me when I started with web2py was > running it in a shell from the command line and using python functions > like dir on the web2py objects, as

[web2py:37542] Re: Understanding the DAL

Thanks a lot Yarko. I downloaded ipython and watched one video. Very very cool. I think this will be very handy. As for WingIDE, i'm strictly open source. Not because I have principles, i'm just poor :) Jake On Dec 18, 11:56 am, Yarko Tymciurak wrote: > One more tip:  if you

[web2py:37574] Re: question

added my 2 cents :) Go web2py! On Dec 19, 3:20 pm, Massimo Di Pierro wrote: > http://groups.google.com/group/comp.lang.python/browse_thread/thread/... -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...

[web2py:37629] Re: Documentation

d when looking "under the hood". I've found the source of web2py extremely comprehensible and enlightening. That being said, buy the book :) Jake On Dec 21, 5:05 pm, sveinh wrote: > Hi Massimo > > I'm new to web2py and I'm very impress with what I've seen so

[web2py:38113] Re: roadmap?!

Here's a link to the wiki for future convenience: http://code.google.com/p/web2py/w/list Jake On Dec 30, 9:42 pm, mdipierro wrote: > Here it is. I added a few more desirable plugins. It would be nice if > people where to take responsibility for some of them so we know who to >

[web2py:38114] Re: LOL

Good luck with that On Dec 30, 11:27 pm, Massimo Di Pierro wrote: > http://london.craigslist.co.uk/stp/1531016430.html -- 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

[web2py:38157] Re: Scalability of Web2py

I, for one, have no idea. There are a large number of stress testing tools available. Give it a try, and let us know :) On Dec 31 2009, 10:00 pm, vvk wrote: > Hi all, > > I've to write a portal for my college in next semester. I want to > discuss regarding scalabilty of web2py. > > Configurati

[web2py:38180] Re: plagiarism

h, nasty! On Jan 1, 5:08 pm, Massimo Di Pierro wrote: > This guyhttp://stores.lulu.com/williambookplagiarizes books by other   > authors and sells them on lulu, including the web2py book. This is   > bad. Lulu.com has been contacted two days ago but no action so far. -- You received this me

[web2py:38328] Re: UliPad as IDE for web2py

oo... OO That's slick! Thanks for the tip! Jake On Jan 4, 11:23 am, Oleg wrote: > Have you tried "It's All Text" Firefox > extension?https://addons.mozilla.org/en-US/firefox/addon/4125 > > On Jan 3, 5:03 pm, werner wrote: > > > > > I thi

[web2py:38393] Re: UliPad as IDE for web2py

but it does give the developer a convenient way to use their preferred editor. And that's what everyone wants anyway, its just better than anyone can expect. Jake On Jan 5, 4:43 pm, Thadeus Burgess wrote: > > if you say "open a shell" they say "open > > what?&qu

[web2py] jQuery 1.4 out

http://jquery14.com/day-01/jquery-14 cool! -- 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

[web2py] Re: Activerecord for web2py - version 0.1

Very cool man! Good work. Can't wait to see where this goes! Jake -- 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] Re: python vs haskel vs erlang benchmarks

O.o Wow. I would not have not predicted these results at all. Very interesting- thanks for the tip. In the immortal words of flavor flav: DON'T- DON'T DON'T- DON'T DON'T- DON'T BELIEVE THE HYPE! Jake On Jan 17, 1:39 pm, mdipierro wrote: > http://www.codexon.c

Re: [web2py] Re: Web2Py on OpenShift

This is really fantastic! Just went to an OpenShift demo and the first thing I wondered was whether web2py was taking advantage of this service. Just tested it out and works great! Thanks, - Jake On Tue, Jul 3, 2012 at 10:15 PM, Massimo Di Pierro wrote: > > Thank you. This is great.

[web2py] Using AJAX with web2py tutorials

Hi group, AJAX seems to be pretty popular with web2py. Are there any tutorials you'd recommend to get started with AJAX? -- Jake

[web2py] Problem with difficult query

Thanks for a great framework. I'm loving web2py, but I just encountered a difficult query One query generates a list of people. Each of those persons has 0 to many reports filed about them. I wanted to see only the newest report on each person AND I want to see Null or None if no reports have b

[web2py] Re: Problem with difficult query

If it helps, here is how I can get the desired result in raw SQL: SELECT * FROM benchmark_targets t2 LEFT JOIN (SELECT * from lobby_report GROUP BY KPID ORDER BY datetime DESC)t1 ON t2.KPID = t1.KPID; Now how to do it in DAL? -- --- You received this message because you are subscribed to th

[web2py] Re: Problem with difficult query

Forgot the WHERE in my SQL statement. Should be: SELECT * FROM benchmark_targets t2 LEFT JOIN (SELECT * from lobby_report GROUP BY KPID ORDER BY datetime DESC)t1 ON t2.KPID = t1.KPID WHERE t2.benchmark = 10; -- --- You received this message because you are subscribed to the Google Groups

[web2py] Re: Problem with difficult query

I'm only talking to myself here, but the notes are helpful... This is how I get the desired result in web2py using the executesql command: foo = db.executesql('SELECT * FROM benchmark_targets AS t2 LEFT JOIN (SELECT * from lobby_report GROUP BY KPID ORDER BY datetime DESC) AS t1 ON t2.KPID = t1

[web2py] Re: Problem with difficult query

Solved: It was a dumb mistake.. I was trying to group by a field in the left join table.. so of course it was eliminating all records not found in the second table. I switched the group by to a first table field and all is well. Final working query was: foo = db(db.benchmark_targets.benchmar

[web2py] Is it possible to use grid style search to filter records before handing off to another function?

I like the way that SQLFORM.grid search works. Once I've searched for records and come up with the set I want, How can I pass that set off to another function to do work just on those filtered records? Or in other words.. if I have 100 records, and I use the grid search to narrow it down to 1

[web2py] Re: Is it possible to use grid style search to filter records before handing off to another function?

ld('district_ks_house','string',writable=False), Field('district_ks_senate','string',writable=False), ) def search_test(): search = SQLFORM.search_ment([db.members.district_ks_house, db.members.district_ks_senate]) return locals() On Sunday, M

[web2py] Re: Is it possible to use grid style search to filter records before handing off to another function?

Thanks Anthony for your excellent advice. I've decided to use a standard grid for the search and display but to use your suggested combo of request.vars.keywords + SQLFORM.build_query() to get at the selected records. I appreciate the help! Jake On Sunday, March 31, 2013 11:22:10 AM

[web2py] scheduler on webfaction

Hi. I have web2py installed on webfaction as my production server. I followed the web2py documentation on it's scheduler function and built an app where everything works as anticipated. (very cool!) In order to run the scheduler though I need to SSH into the server and run this command: "python

[web2py] Re: scheduler on webfaction

Simultaneously with Niphlod's reply also came this from webfaction customer support: You can use the nohup command at the start of this command to make it immunte to hangups, like when you are exiting your ssh session. http://linux.die.net/man/1/nohup Or you can use disown to disassociate the

[web2py] web admin interface doesn't see my app

living in the same directory as all the other applications, namely web2py/applications/name-of-app . How do I get web admin interface to recognize this app? -- Jake

Re: [web2py] web admin interface doesn't see my app

I have restarted the server a couple times... in the meanwhile, I created an app and copied and pasted all the files, but that was annoying. There has to be an easier way. -- Jake On Fri, Feb 24, 2012 at 9:17 PM, Bruce Wade wrote: > Did you try restarting the server? I found a few times

Re: [web2py] Re: web admin interface doesn't see my app

I just have my git repos on Dropbox, I set up as it is here.Then I went to web2py/applications and did git clone ~/Dropbox/git-repos/name-of-app.git The web interface didn't see it that way so I created the app from the web interface, deleted all the files and

Re: [web2py] Re: Cookbook - No indentation ??

Has a solution been found to get this in an ebook format with the correct indentation? On Sat, Mar 17, 2012 at 2:34 PM, Jonathan Lundell wrote: > On Mar 17, 2012, at 11:22 AM, Marcello wrote: > > I screwed with nobody. > I just pointed a fact. > > I have many Python eBooks(ePub) and ALL of them h

[web2py] smartgrid orderby descending

In a normal grid the orderby descending works just fine: grid = SQLFORM.grid(db.meetings, orderby=~db.meetings.meeting_date, ) But I can't get the parent table of a smart group to sort the same way: grid = SQLFORM.smartgrid(db.meetings, linked_tables=['meeting_docs'],

[web2py] Starting web2py on shell generates - Temporarily down for maintenance

Hi All, Im pretty embarrassed to ask this question but im stuck for half a day on this. Starting web2py with: /home/www-data/web2py/web2py.py -a -i -p 80 It starts up alright with no error, and getting the familiar message. But when I browse: http:// The browser displays: "Temporarily down

Re: [web2py] Re: Starting web2py on shell generates - Temporarily down for maintenance

On Fri, Jul 26, 2013 at 7:42 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Login into http:///admin > You will find that the app you are trying to access (/ can be "welcome" or > "init") is disabled. An app can be enabled or disabled from the web > interface. When it is disabled

[web2py] A good py Logger Lib that works with web2Py (like Log4J)

Hi Guys, I develop using vi & notepad++ and find it very difficult to debug with these limited tools. I debug by runtime output / stdout & doing a lot of print. Is there a good Py logging library (like log4j in java) that also works with web2py? Appreciate any recommendeations. Rgds, -- --

Re: [web2py] Re: A good py Logger Lib that works with web2Py (like Log4J)

Thanks All! Will try to both pdb and errormator and see what works for me. On Tue, Jul 30, 2013 at 3:50 AM, Derek wrote: > Take a look at errormator. I use it in some of my non-web2py apps simple > enough. > > > On Sunday, July 28, 2013 5:51:28 PM UTC-7, Jake Angulo wrote: &

[web2py] Re: Book register example - how to redirect to other URL

On Thu, Aug 1, 2013 at 3:50 PM, Jake Angulo wrote: > > Where and how should i modify the code? > > So basically, I want to use the built-in Auth register() function - but I want to modify its behavior: Auth.register() checks if the new user is successfully registered & log

Re: [web2py] Re: Book register example - how to redirect to other URL

On Thu, Aug 1, 2013 at 5:13 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > You do not need to modify the registration for this. Instead you do the > following: > > Hi Massimo, Thank you for pointing that out, I will explore it as an alternative logic. Regarding: "redirect('http://p

Re: [web2py] Re: Book register example - how to redirect to other URL

t; I am not sure whether you want line #1 there, you may have a different > workflow. > > On Thursday, 1 August 2013 01:58:45 UTC-5, Jake Angulo wrote: > >> On Thu, Aug 1, 2013 at 3:50 PM, Jake Angulo wrote: >> >>> >>> Where and how should i modify the

[web2py] How to set Session Variable in Models

ing "" or "None" Can you pls point out how to properly do this? I'd appreciate your help! Jake -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emai

Re: [web2py] Re: How to set Session Variable in Models

On Tue, Aug 6, 2013 at 1:55 PM, Anthony wrote: > session.emailvariable = request.vars.email > > Because the above is in a model file, it runs on every request. After the > form has been submitted, on subsequent requests, the value of > request.vars.email will be None, so you are simply overwritin

Re: [web2py] Online classes

Invaluable learning resource... thinking of downloading to my tablet. Thanks maestro :) On Tue, Dec 3, 2013 at 5:34 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Hello everybody, > > As you know I teach a certification program about web development with > Python and I use web2py.

Re: [web2py] Happy New Year everybody!

Prospero ano y felicidad! A prosperous and happy New Year to everyone! On Thu, Jan 2, 2014 at 9:06 AM, Massimo DiPierro wrote: > Happy new year everybody, > > some good news: > 1) python is growing popularity > > https://sites.google.com/site/pydatalog/pypl/python-blog/pythonisthelanguageofth

Re: [web2py] Re: smartgrid orderby descending

ed web2py in a while since I moved on to flask. Sorry I'm not more help. J On Fri, Mar 7, 2014 at 6:41 PM, Dan Kozlowski wrote: > Jake, > > Did you ever get this to work ? Reason being I think I have the same > problem. > > > On Sunday, April 21, 2013 9:47:59 AM UTC-