[web2py] Unsupported query SQLFORM.grid

Dear All. I am trying the following query: fields=[db.llamados.id,db.accountcode.ani,db.llamados.destino,db.rutas.nombre,db.llamados.answeredtime,db.llamados.inicio,db.llamados.valor,db.l lamados.billing] left = ([db.accountcode.on(db.llamados.id_accountcode==db.accountcode.id),db.rutaprov

Re: [web2py] Re: SQLForm.grid : is it possible to delete multiple rows at once ?

sabsto You can use selectable, for example: selectable = lambda ids: delete(ids) form=SQLFORM.grid(query,selectable=selectable) def delete(ids): to_delete=db(db.tabla.id.belongs(ids)) to_delete.delete() On Fri, Mar 23, 2012 at 9:46 PM, Derek wrote: > Or you could avoid javascript,

Re: [web2py] Re: sqlite on production

> > Well, to each their own. If you want to use it, go ahead. I think that > since postgresql and mysql are both free, you would want to choose the one > that's the best fit. Sqlite is built in and makes it easy to do the sample > code and such, and it can be used in some cases, but if you have

[web2py] Re: Chrome extension to auto-open error tickets

On Friday, March 23, 2012 9:03:17 PM UTC-4, Alexander Garden wrote: > > Sure. Where do I do that? > http://code.google.com/p/web2py/issues/list

[web2py] Re: can web2py have a place in an 'html5 app' environment?

> > In that case, it still depends on a server. You know what I meant. The > original topic is about using a web framework for a client-only app. Really, I didn't know what you meant, as you said Pyjamas requires Python to be installed. It doesn't depend on a server either, other than to deli

[web2py] Re: missing FROM-clause entry

An interesting suggestion...I can see how I could use it for some sort of workaround. What it would me is that I would have to use two separate selects, when I was hoping you only do one. Still it seems to me that my initial approach is the correct one, and that the DAL should be consistent in th

[web2py] Re: missing FROM-clause entry

On Friday, March 23, 2012 10:09:07 PM UTC-4, Limedrop wrote: > > Thanks for the information. Unfortunately, in my case I really do > need to store the raw query in the session...and then convert it back > to a Query so I can then add a few more filters before the final > select(). Has anyone ma

[web2py] Re: missing FROM-clause entry

On Friday, March 23, 2012 6:09:30 PM UTC-4, Anthony wrote: > > There is also an .as_list() method, which converts to a list of > dictionaries rather than a dictionary of dictionaries. You can also just > store Rows objects directly in the session or cache -- the DAL defines a > reduction functi

[web2py] Re: DAL / connection pool leaking objects?

Probably a bug in DAL (at least for standalone use, but I suspect also when used in web2py). A test case that easily reproduces this behavior can be found in Issue 731 : Standalone DAL is leaking memory+resources (don't know whether or not i

[web2py] Re: missing FROM-clause entry

Thanks for the information. Unfortunately, in my case I really do need to store the raw query in the session...and then convert it back to a Query so I can then add a few more filters before the final select(). Has anyone managed to store a representation of a query in the session? On Mar 24, 11:

[web2py] Re: Chrome extension to auto-open error tickets

Sure. Where do I do that? On Friday, March 23, 2012 7:49:54 PM UTC-4, Massimo Di Pierro wrote: > > Can you please open ticket about this. It will help me keep track and I > will add a link in the docs. > > On Friday, 23 March 2012 10:20:26 UTC-5, Alexander Garden wrote: >> >> Hi, >> >> I am worki

[web2py] Re: SQLForm.grid : is it possible to delete multiple rows at once ?

Or you could avoid javascript, store the IDs of the "deleted" items in the session and do your own calls to the DAL to delete items. On Friday, March 23, 2012 7:33:42 AM UTC-7, Anthony wrote: > > Is it possible to select and delete multiple rows with one button click >> using SQLFORM.grid ? (in

Re: [web2py] Re: Getting started in Web2py

Same here. It works just fine in Chrome. I fullscreen and start coding. Sure, I don't get autocomplete, but I rarely use that anyway. It does have issues managing files, but I found it was easy enough to put the files in the folders. (I'm not used to that coming from Zope). On Friday, March 23,

[web2py] Re: can web2py have a place in an 'html5 app' environment?

In that case, it still depends on a server. You know what I meant. The original topic is about using a web framework for a client-only app. On Friday, March 23, 2012 4:59:33 PM UTC-7, Anthony wrote: > > On Friday, March 23, 2012 7:21:08 PM UTC-4, Derek wrote: >> >> No, Pyjamas actually requires p

Re: [web2py] Re: sqlite on production

Well, to each their own. If you want to use it, go ahead. I think that since postgresql and mysql are both free, you would want to choose the one that's the best fit. Sqlite is built in and makes it easy to do the sample code and such, and it can be used in some cases, but if you have postgresql

[web2py] Re: can web2py have a place in an 'html5 app' environment?

On Friday, March 23, 2012 7:21:08 PM UTC-4, Derek wrote: > > No, Pyjamas actually requires python installed everywhere it runs, even on > desktops. > Not sure what you mean. Pyjamas compiles your Python code to Javascript. The Javascript is then sent to the browser as part of the web app. The m

[web2py] Re: bug in auth -- reset_password_onaccept doesn't exist ...

Added to trunk. On Friday, 23 March 2012 09:36:11 UTC-5, Anthony wrote: > > Congratulations, it appears you are the first person to need a reset > password callback. :-) > > On Friday, March 23, 2012 2:11:13 AM UTC-4, weheh wrote: >> >> I'm doing some more of this modal stuff for my login/passwor

[web2py] Re: DAL and schema

I am not sure if this can be done or not. If not supported, we can add support. Can you open a ticket and post an example of how to do it in SQL? On Friday, 2 March 2012 05:58:35 UTC-6, Wuwei wrote: > > Hello, > I'm trying to use DAL with a MSSQL db. > I need to work with tables from 2 different

[web2py] Re: Chrome extension to auto-open error tickets

Can you please open ticket about this. It will help me keep track and I will add a link in the docs. On Friday, 23 March 2012 10:20:26 UTC-5, Alexander Garden wrote: > > Hi, > > I am working on a project using web2py and found clicking on trouble > tickets rather a nuisance. So I wrote a Chrome

[web2py] Re: Chrome extension to auto-open error tickets

+1 On Friday, 23 March 2012 10:20:26 UTC-5, Alexander Garden wrote: > > Hi, > > I am working on a project using web2py and found clicking on trouble > tickets rather a nuisance. So I wrote a Chrome extension that watches for > web2py error pages and, when it finds one, opens the trouble ticket i

[web2py] Re: Markmin - could we use instead of ?

Agreed. should be not . On Friday, 23 March 2012 10:05:48 UTC-5, villas wrote: > > I see bold is , so why is em rendered as - it is > inconsistent. Also inconsistent with Markdown. And isn't even styled > in the current web2py.js (unless I'm missing something). Anyhow, if it > wouldn't

Re: [web2py] Re: sqlite on production

+1 If you have only one server sqlite is great. If you have many servers behind load balancer than you need to a client-server database like mysql or postgresql. On Thursday, 22 March 2012 21:59:26 UTC-5, Vasile Ermicioi wrote: > > developers themselves say 'dont use it for sites that have 100

[web2py] Re: Auto Login on Google App engine

> > Thanks. > I have a user object in the memory, may be I can use it to store the data > in session. Let me try this out. > In the meantime, can you explain what does the line no: 1959 (as below) > does ?? > > 1959 user = > Storage

[web2py] Re: can web2py have a place in an 'html5 app' environment?

No, Pyjamas actually requires python installed everywhere it runs, even on desktops. On Friday, March 23, 2012 4:14:42 PM UTC-7, Anthony wrote: > > If I code an html5 app for win8 or for Mozilla's app store I would like >> the business logic to be in python if that turns out to be a possibility.

Re: [web2py] Re: Cookbook Chapter 2 - Reddit clone Ajax problem

Alan, Thanks. Good idea. I will try the support files. Sent from my Verizon Wireless BlackBerry -Original Message- From: Alan Etkin Sender: web2py@googlegroups.com Date: Fri, 23 Mar 2012 15:22:25 To: web2py-users Reply-To: web2py@googlegroups.com Subject: [web2py] Re: Cookbook Chapter

[web2py] Re: can web2py have a place in an 'html5 app' environment?

> > If I code an html5 app for win8 or for Mozilla's app store I would like > the business logic to be in python if that turns out to be a possibility. > So could web2py provide a framework for that, and if so how much work would > it take to implement/adapt. After all, web2py already includes

[web2py] Re: Auto Login on Google App engine

Thanks. I have a user object in the memory, may be I can use it to store the data in session. Let me try this out. In the meantime, can you explain what does the line no: 1959 (as below) does ?? 1959 user = Storage (t

[web2py] Re: Auto Login on Google App engine

can you disable auto-login, and then in your wrapping controller (or perhaps there is an onaccept handler) manually add the user data to the session? "login" really just means 'verify that the user exists in the db with the right credentials and then copy some stuff to the session' so you have

[web2py] Re: can web2py have a place in an 'html5 app' environment?

DAL is not going to help any client side storage, it's for server storage. DAL isn't going to help with any storage client-side. Only your views would help here. Python won't run client side, not unless you have Pyjamas, but then you don't have an HTML5 WebApp, you have a Pyjamas webapp. That ma

[web2py] Re: breakpoints + Eclipse + Web2Py

I believe you must delete all .pyc files before running it with breakpoints. On Mar 23, 1:18 pm, web2py_tn wrote: > Hi guys- I sat up my Aptana Studio and loaded a web2py project that has > breakpoints in it. I ran web2py.py in a debug more and for some reason, it > doesn't stop at the breakpoint

[web2py] Re: can web2py have a place in an 'html5 app' environment?

Right. For something as simple as an RSS reader I see your point. But for more complex applications (I'm working on a web-based educational game for language instruction) I think the gluon libraries offer more than this. The DAL greatly simplifies the process of working with a db, and to the ext

[web2py] Re: Cookbook Chapter 2 - Reddit clone Ajax problem

I tested the example app with the book support files and it worked (with Firefox 10 and web2py trunk). Maybe there is a bug fixed in the app code that was not updated in the book's text. On 23 mar, 18:11, Omi Chiba wrote: > I was following cookbook and having a problem for the ajax part. I can >

[web2py] Re: can web2py have a place in an 'html5 app' environment?

It's a server-client framework only. Your question does not make sense because html5+js+local storage = client. This is a server application. If you want to integrate localstorage, you're developing a client app, and thus there is no need for a server framework such as web2py. You could do all

[web2py] Re: missing FROM-clause entry

On Friday, March 23, 2012 5:36:28 PM UTC-4, monotasker wrote: > > I may be off target but I just recently noticed the .as_dict() method for > rows objects. This converts the rows object to a regular dict (instead of a > gluon storage object) which can be stored in session or cache (i.e., it's >

[web2py] can web2py have a place in an 'html5 app' environment?

I've been struck by the huge push lately for 'html5 apps' as a (partly) cross-platform approach to mobile and desktop development. Now win8 is integrating html5+js heafily into the desktop and the Mozilla app project is pushing in a similar direction. In many ways I think it makes sense (I find

[web2py] Re: missing FROM-clause entry

I may be off target but I just recently noticed the .as_dict() method for rows objects. This converts the rows object to a regular dict (instead of a gluon storage object) which can be stored in session or cache (i.e., it's picklable). If you need the query (not the resulting rows object) to be

[web2py] Re: Getting started in Web2py

I think I understand a bit what you mean about not feeling like you understand the "guts" of web2py at first. The book wants to walk you through app-building before introducing you to much of the core, even conceptually. I think this is actually a good pedagogical move for lots of people, but f

[web2py] Cookbook Chapter 2 - Reddit clone Ajax problem

I was following cookbook and having a problem for the ajax part. I can click plus or minus to change the value for the first time, but it doesn't update the value next time it's clicked. Also, I don't get any flash message like 'you voted already' or 'vote recorded'. What am I missing ? Contr

[web2py] Re: missing FROM-clause entry

Thanks for your suggestion...it pointed me in the right direction. It turns out the issue is not with the query construction, but that DAL handles string input differently to objects. What I am trying to do is take a Query and then convert it to a string so it can be saved in the session. The st

[web2py] Re: SQLFORM.grid many2many name of referenced table instead of id

> > I would expect the default view of this grid would also show the > names, instead of the id's - taken from the model (requires > IS_IN_DB). The IS_IN_DB validator will result in the "name" field being showing in select widgets, but it won't affect the field representation in tables/gr

Re: [web2py] Getting started in Web2py

This is a nice resource as well... http://killer-web-development.com/ -Jim On 3/22/2012 11:15 PM, SeamusJP wrote: Hi, I am developing a new project, new to python. Project is mainly for CRUD, display data on website, and easy management of back end. I started Djangobook and finished it,

[web2py] breakpoints + Eclipse + Web2Py

Hi guys- I sat up my Aptana Studio and loaded a web2py project that has breakpoints in it. I ran web2py.py in a debug more and for some reason, it doesn't stop at the breakpoints. If I create a new python project with breakpoints, it works perfectly fine. can you guys help?

Re: [web2py] DAL / connection pool leaking objects?

On Friday, March 23, 2012 10:21:07 AM UTC-4, Richard wrote: > > Why are you doing that? > > Richard > A legacy system, which has stand-alone appservers+databases in geographically distributed locations, with intermittent and low bandwidth connections (think mobile GPRS modems for the kind and q

[web2py] SQLFORM.grid many2many name of referenced table instead of id

Is it possible to show the referenced name field, instead of the id when showing a grid of a many2many table? my model: tsmadm.define_table('report_contact', Field ('report_id', db.reports, requires=IS_IN_DB(db, db.reports.id,'%(name)s') ), Field ('contact_id', db.contact

Re: [web2py] mistake by not using db.commit ()?

if home is None: home_id = db.home.insert(user=id_user) home = db.home(user=id_user) else: home_id = home.id I google translator flip the code :S El viernes 23 de marzo de 2012 13:31:13 UTC-4:30, www.diazluis.com escribió: > > sr. antonio has every reason > after

Re: [web2py] mistake by not using db.commit ()?

sr. antonio has every reason after analyzing its response, the reasons are obvious DAL designed. the end the error of my logic (I apologize) missing return to the query of the data, after creating the record, I mean: if home is None: db.home.insert home_id = (user = id_user) db.home home

[web2py] Re: opinion -- modal login not what it could/should be

> > If I redirect to a > URL('default','index'), and that contains a response.js='ajax(blah > blah);', will the response.js get executed or will I need to do the > HTTP(200) trick again? > Yes, if you redirect to a particular URL, once the URL is requested by the browser, everything should wo

Re: [web2py] Re: Spatial / GIS support in DAL

On Wednesday, 21 March 2012 21:35:32 UTC, Manuele wrote: > > For inserting geometries in database using new DAL features > you need WKT format and not WKB... every library I found support > exporting WKB (osgeo.ogr, Shapely, ppygis) but none seams to export WKT > format. > Shapely can export WK

[web2py] Re: opinion -- modal login not what it could/should be

Hmm, I wasn't aware of auth.login_bare(). Will have to check it out. As far as decorators are concerned, I have already begun tinkering with a method like you mention, so we are on the same wavelength about where to do it. I just have to figure out how. If I redirect to a URL('default','index'), an

[web2py] Re: bug in auth -- reset_password_onaccept doesn't exist ...

It does look that way ... doesn't it!? I expect to run into the same issue with some of the other auth routines. I'm going to put them all into modals and see how well it works. So given the structure of auth, they are all going to need callbacks. On Mar 23, 10:36 pm, Anthony wrote: > Congratulat

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

Re: [web2py] Re: Getting started in Web2py

Don't use the web admin. It's for kids :P Copy welcome or example app and > change the files directly. > > may be... but I rarely code outside of it :)

Re: [web2py] mistake by not using db.commit ()?

In web2py, each request is wrapped in a single database transaction -- that way if an error occurs somewhere in the processing of the request, any database changes can be rolled back automatically. It would not be desirable to immediately commit each change (i.e., each insert, update, delete, e

Re: [web2py] mistake by not using db.commit ()?

Greetings sr. Thanks for your time. your explanation makes sense but ... but I find it annoying to have to be running explicitly "db.commit ()" something as simple as what you showed you Waste time having to revise the code to see where failure to use "db.commit ()" and so and keep it from boun

[web2py] Re: Getting started in Web2py

Don't use the web admin. It's for kids :P Copy welcome or example app and change the files directly. For me the selling point of web2py was the simplicity of the syntax. See this comparison: http://www.web2py.com/examples/static/web2py_vs_others.pdf

[web2py] Re: missing FROM-clause entry

Just a blind guess but does this work any better? query = (comment.id > 0) & (webpage.title == 'FAQ') & (comment.page_id == webpage.id) & (comment.id == comment_tags.comment_id) & (tag.id == comment_tags.tag_id) & (tag.label == 'Agree') db(query).select()

Re: [web2py] DAL and schema

I agree, I can't find a way to use 2 differents schemas in mssql with DAL. 2 connections are not a solution because it seems there is no way to explain to DAL wich schema you want to connect to per each connection, you can only specify database. How do you handle this? Schemas, like in postgres,

[web2py] Chrome extension to auto-open error tickets

Hi, I am working on a project using web2py and found clicking on trouble tickets rather a nuisance. So I wrote a Chrome extension that watches for web2py error pages and, when it finds one, opens the trouble ticket in an iframe, thus saving me a couple clicks and a bunch of time. It's on githu

[web2py] Markmin - could we use instead of ?

I see bold is , so why is em rendered as - it is inconsistent. Also inconsistent with Markdown. And isn't even styled in the current web2py.js (unless I'm missing something). Anyhow, if it wouldn't cause a problem, could we please change it. Thanks.

Re: [web2py] Invalid syntax

Yep that was that the encoding thanks all i did a replace with this regexp : /[^\x00-\x7F]/ But it was hard to understand ... Thanks Bussiere Le vendredi 23 mars 2012 15:14:02 UTC+1, Jonathan Lundell a écrit : > > On Mar 23, 2012, at 2:40 AM, bussiere adrien wrote: > > # -*- coding: utf-8 -*-

[web2py] Re: auth.login() from inside a component in a dialog

raise HTTP(200) works great and is cleaner. Thanks.

[web2py] Re: bug in auth -- reset_password_onaccept doesn't exist ...

Congratulations, it appears you are the first person to need a reset password callback. :-) On Friday, March 23, 2012 2:11:13 AM UTC-4, weheh wrote: > > I'm doing some more of this modal stuff for my login/password routines > and ran into this problem. Probably an oversight in the code (lots of

[web2py] Re: SQLForm.grid : is it possible to delete multiple rows at once ?

> > Is it possible to select and delete multiple rows with one button click > using SQLFORM.grid ? (instead of clicking delete on each row) > I tried the "selectable" property but this doesn't help to delete. > I searched the archive of this group / mailing-list without success > Not out of the

[web2py] Re: auth.login() from inside a component in a dialog

On Friday, March 23, 2012 12:54:00 AM UTC-4, weheh wrote: > > Anthony, I tried your > raise HTTP(200, response.render()) > vs. my > raise HTTP(200, SCRIPT(response.js)) > > I ran into a ticket complaining about my form not being defined, so > I'm back to my SCRIPT(). > Well, by defaul

Re: [web2py] DAL / connection pool leaking objects?

Why are you doing that? Richard On Fri, Mar 23, 2012 at 2:26 AM, nick name wrote: > In one of my management scripts (which runs continuously, after setting up > a web2py environment), I copy a complete sqlite database directory from > another server (copied_db.sqlite, and *.table), open them wit

Re: [web2py] Invalid syntax

On Mar 23, 2012, at 2:40 AM, bussiere adrien wrote: > # -*- coding: utf-8 -*- > def ensurefirstuser(firstname,lastname,email,password)​: > users = db(db.auth_user.email==email).​select() > if users: > user_id = users[0].id > created = False > if settings.debug_ensure

[web2py] Re: auth.login() from inside a component in a dialog

I mentioned this in another thread (https://groups.google.com/d/msg/web2py/XaHiLQHQ9X0/N8J1PqUxK6YJ), but an entirely different approach is to skip auth.login() altogether, write all the login logic yourself, and use auth.login_bare() just to check the submitted credentials (in addition to retu

[web2py] Re: opinion -- modal login not what it could/should be

> > After much tinkering with modal login, I'm formulating the following > opinions: > - modal login is a powerful and useful capability > - modal login is not well supported by web2py and not at all a > functionality that newbies would be able to implement easily. Sorry, I keep forgetting a

Re: [web2py] mistake by not using db.commit ()?

Most of the time in web2py you don't need to commit, but in particular scenario you maybe need to commit before an other operation because you need the database to be up to date before the and of your function. http://web2py.com/books/default/chapter/29/6?search=db.commit%28%29 Hope it helps On

[web2py] mistake by not using db.commit ()?

The following code gives me error if not explicitly use db.commit () can someone explain why I now need to use db.commit () to something so simple? models/home.py ## id_user = (auth.user and auth.user.id) or None db.define_table('home', Field('titulo', 'string', length=64, defaul

[web2py] Auto Login on Google App engine

Hi, As per the source code of the auth.register(), if auto-login is enabled, another DAL query is executed to get the user from auth_user table. 1958 user = self.db(table_user[username] == form.vars[username]).select

[web2py] Re: auth.login() from inside a component in a dialog

Thanks ! On Friday, March 23, 2012 12:57:10 PM UTC+1, weheh wrote: > > Sorry, last message got mangled somehow. Here goes again. > > Sebastian, here's what I'm using: > > >

[web2py] Re: auth.login() from inside a component in a dialog

Sorry, last message got mangled somehow. Here goes again. Sebastian, here's what I'm using: # model auth = Auth(db) ... def complete_login(form): from gluon import HTTP # do some stuff with form as necessary response.flash = 'You are now logged in' response.js = 'ajax("%s",[],":ev

[web2py] Re: auth.login() from inside a component in a dialog

Here's what I'm using: # controller def login(): On Mar 23, 7:30 pm, Sebastien Stormacq wrote: > Hello Anthony, > > Could you share your code for modal login ? > I am beginning with web2py and would love to learn from that example. > > Thanks > > Seb > > > > > > > > On Friday, March 23, 2012 4:

[web2py] Re: auth.login() from inside a component in a dialog

Hello Anthony, Could you share your code for modal login ? I am beginning with web2py and would love to learn from that example. Thanks Seb On Friday, March 23, 2012 4:08:51 AM UTC+1, Anthony wrote: > > @anthony: actually, on closer inspection, the doc does go into some >> details: >> http://

[web2py] SQLForm.grid : is it possible to delete multiple rows at once ?

Hello, Is it possible to select and delete multiple rows with one button click using SQLFORM.grid ? (instead of clicking delete on each row) I tried the "selectable" property but this doesn't help to delete. I searched the archive of this group / mailing-list without success Thanks for your hel

Re: [web2py] Invalid syntax

Il 23/03/2012 10:40, bussiere adrien ha scritto: # -*- coding: utf-8 -*- def ensurefirstuser(firstname,lastname,email,password)​: users = db(db.auth_user.email==email).​select() if users: user_id = users[0].id created = False if settings.debug_ensure_first_​user ==

[web2py] Invalid syntax

# -*- coding: utf-8 -*- def ensurefirstuser(firstname,lastname,email,password)​: users = db(db.auth_user.email==email).​select() if users: user_id = users[0].id created = False if settings.debug_ensure_first_​user == True: print ('found user_id so created

[web2py] Re: infinite loop with form.process().accepted

> > Thanks a lot. > It was obvious for me that it was an int. Thanks again Bussiere

[web2py] Re: Getting started in Web2py

Your mileage may vary, but for me glancing through the examples got me started in no time: http://www.web2py.com/examples/default/examples

[web2py] opinion -- modal login not what it could/should be

After much tinkering with modal login, I'm formulating the following opinions: - modal login is a powerful and useful capability - modal login is not well supported by web2py and not at all a functionality that newbies would be able to implement easily. As per pbreit in http://groups.google.com/gr