[web2py] Re: Exception in "belongs" query on GAE and list:reference

2011-01-14 Thread Roman Imankulov
I've tried trunk and it's really working as expected, thank you.

[web2py] Re: Storing the Original Filename in the official web2py book

2011-01-14 Thread cjrh
bump

[web2py] is there a way to rename a database ?

2011-01-14 Thread Stef Mientki
hello, I would like to rename a database, is that possible ? thanks, Stef Mientki

[web2py] Re: Why the need of return dict() in controller?

2011-01-14 Thread Bob
I see no downsides and seems that Massimo confirmed that. I already tried using return locals() and it works without issues. On 14 Ян, 07:37, pbreit wrote: > Wait, so are you saying that instead of return dict(items=items, blah=blah, > etc) we can just use return locals() on most or all controlle

[web2py] Re: Storing the Original Filename in the official web2py book

2011-01-14 Thread selecta
no need to store the original filename record = db(db.mytable.id==1).select().first() filename, file = db.mytable.uploadfield.retrieve(record.uploadfield) A('%s'%filename, _href = URL(request.application, 'default', 'download', args = [record.uploadfield])) On Jan 14, 9:29 am, cjrh wrote: > bump

Re: [web2py] country / state / city of the current visitor?

2011-01-14 Thread Alexandre Andrade
I really wanted it! Valeu Bruno! Atenciosamente Alexandre Andrade Hipercenter.com Classificados Gratuitos e Inteligentes 2011/1/14 Bruno Rocha > > I fund this useful script: http://eternal-todo.com/var/scripts/geoloc > > Bruno Rocha > http://about.me/rochacbruno/bio > --

Re: [web2py] Re: Why the need of return dict() in controller?

2011-01-14 Thread Alexandre Andrade
It's interesting, while I usually don't use so many variables in each controller. 2011/1/14 Bob > I see no downsides and seems that Massimo confirmed that. I already > tried using return locals() and it works without issues. > > On 14 Ян, 07:37, pbreit wrote: > > Wait, so are you saying that

Re: [web2py] Re: Interview with Massimo published

2011-01-14 Thread Martín Mulone
"My main hobby is web2py but my doctor thinks I should get into jogging." :) 2011/1/14 VP > I am very suspicious that this interview is translated by something > like GoogleTranslate from (maybe) Italian. It reads very rough. May > not be a good thing. > > > On Jan 13, 7:36 pm, Bruno Rocha w

Re: [web2py] Re: Interview with Massimo published

2011-01-14 Thread contatogilson...@gmail.com
Sorry if the translation was not very good. I'm studying English right? Help are welcome:) _ *Gilson Filho* *Web Developer Blog:* gilson-filho.blogspot.com *Twitter:* twitter.com/gilsonfilho 2011/1/14 Martín Mulone > "My main hobby is web2py but my d

Re: [web2py] About bugreports

2011-01-14 Thread Kenneth Lundström
> RE bug reports: there is also google code to post bug reports to: http://code.google.com/p/web2py/issues/list i know that at times things get backed up, and occasionally a bug gets missed, which is why we have been encouraged to start using the google code bug tracking. I´d rather post it

Re: [web2py] Re: Why the need of return dict() in controller?

2011-01-14 Thread Kenneth Lundström
Only thing that comes to my mind is that you can´t rename a variable. With dict() method you can "rename" them. I don´t know if people do that. Traditional way, if you want to rename variable: total_exposure_at_day_light_time = 365 return dict(teadlt = total_exposure_at_day_light_time) new way:

[web2py] IMAP as authentication

2011-01-14 Thread Kenneth Lundström
Hi, has anybody used IMAP to authenticate users? I removed that there was an module to Drupal to authenticate users with IMAP. At login you give your email address and password to that emailaccount. The system tries to login to that account via IMAP. If successful you are authenticated. One

Re: [web2py] is there a way to rename a database ?

2011-01-14 Thread Alexandre Andrade
How to do it: 1. backup it, exporting to csv - you can use appadmin for it 2. rename 3. restore the csv backup, using appadmin Atenciosamente Alexandre Andrade Hipercenter.com Classificados Gratuitos e Inteligentes 2011/1/14 Stef Mientki > hello, > > I would like to rename a database, is t

Re: [web2py] is there a way to rename a database ?

2011-01-14 Thread Alexandre Andrade
Sorry, it is to migrate a table. To migrate/rename a database, do what is here: http://alexandremas.blogspot.com/2009/11/short-tutorial-to-migrate-web2py.html Atenciosamente Alexandre Andrade Hipercenter.com Classificados Gratuitos e Inteligentes 2011/1/14 Alexandre Andrade > How to do

Re: [web2py] is there a way to rename a database ?

2011-01-14 Thread Kenneth Lundström
On 14.1.2011 13:41, Alexandre Andrade wrote: How to do it: 1. backup it, exporting to csv - you can use appadmin for it 2. rename Here you have to remember to modify your model file where you define db variable. db = DAL('mysql://old_database_name:password@localhost/') to db = DAL('mysql://n

Re: [web2py] Re: Why the need of return dict() in controller?

2011-01-14 Thread rochacbruno
In this case will be a good pratice to use _ and __ to name that variables which you dont want to be used in views. I see that if you have too many local vars the dict send to the view will be bigger. What is the better aproach in a matter of memory usage. A bigger dict available to the view

[web2py] Re: ajax append target

2011-01-14 Thread Francisco Costa
I use prepend, since i want the new results to appear on top. The this is that prepend (or append) they don't past the

[web2py] Re: Error using setup-web2py-ubuntu.sh on Linode

2011-01-14 Thread Chase Lee
cat /etc/hosts 127.0.0.1 localhost 173.255.235.47 viasco cat /etc/hostname viasco That was one of the problems I had before, you're right. It's not the problem now it would seem since I still get the error. Thanks. On Jan 14, 12:05 am, Christopher Steel wrote: > On Jan 13, 11:15 am, Chase Le

Re: [web2py] Re: Why the need of return dict() in controller?

2011-01-14 Thread Bruno Rocha
> response._vars: this variable is accessible only in a view, not in the > action. It contains the value returned by the action to the view. I made a simple test here: <*controller*> def myfunc(): _counter = 0 #I also tried with __counter for i in range(101): _counter += 1 re

[web2py] Re: About bugreports

2011-01-14 Thread Massimo Di Pierro
Hi Kenneth, I apologize. A couple of them I bookmarked and I am working ont them. Yet I cannot find 3-4. Please open tickets on googlecode so I can keep track of them more easily. Thanks for your help. Massimo On Jan 13, 2:24 am, Kenneth Lundström wrote: > Hello everybody, > > for the past mont

[web2py] Re: IMAP as authentication

2011-01-14 Thread Massimo Di Pierro
No but we have gluon/contrib/login_methods/email_auth.py with uses smtp. If you have an imap server probably you have smtp with the same login/password. Massimo On Jan 14, 5:34 am, Kenneth Lundström wrote: > Hi, > > has anybody used IMAP to authenticate users? > > I removed that there was an m

[web2py] newby question

2011-01-14 Thread kkirsanov
I`m creating a complicated application. It will deal with users, their tickets, and for example, sms-messages and other stuff (30-40 tables) 1) How I can extend standard `auth` table to store more fields (phone, money, etc,). Should I create new table with all that data and link it to original aut

[web2py] Web2py Most Wanted

2011-01-14 Thread António Ramos
hello, to help web2py in the best possible way and in the least amount of time , why dont Maximo suggest the plugins or areas where ther is a lack of a plugin or code. This way we, discipules of py, dont loose time with details and get a real chalenge from the Master ? I suggest one: Workflow fra

[web2py] Buttons in forms

2011-01-14 Thread annet
I have a form containing two buttons, one to update data and one to close the window: {{=INPUT(_type='button',_value='Update data',_onclick=URL(r=request,f='update_form',args=[company[0].id]))}} {{=INPUT(_type='button',_value='Close window',_onclick='closeWin()')}} The second button works, the fi

Re: [web2py] Re: Why the need of return dict() in controller?

2011-01-14 Thread Jonathan Lundell
On Jan 14, 2011, at 1:06 AM, Bob wrote: > > I see no downsides and seems that Massimo confirmed that. I already > tried using return locals() and it works without issues. > > On 14 Ян, 07:37, pbreit wrote: >> Wait, so are you saying that instead of return dict(items=items, blah=blah, >> etc) we

[web2py] Re: newby question

2011-01-14 Thread annet
> 1) How I can extend standard `auth` table to store more fields (phone, > money, etc,). Should I create new table with all that data and link it > to original auth table or alter auth class to store all that data. Here's the link to the section on customizing auth in the web2py book: http://www.

Re: [web2py] country / state / city of the current visitor?

2011-01-14 Thread Jonathan Lundell
On Jan 13, 2011, at 6:23 PM, Bruno Rocha wrote: > I fund this useful script: http://eternal-todo.com/var/scripts/geoloc > As long as you don't attach to much significance to the result. I use two ISPs; depending on which one I go through, I'm shown in Fresno CA (200 miles away) or simply in the

[web2py] Re: Buttons in forms

2011-01-14 Thread Mathew Grabau
Try using a submit instead: {{=INPUT(_type="submit", _value="Update data", _action="URL(r=request, f="update_form", args=company[0].id))}} On Jan 14, 9:41 am, annet wrote: > I have a form containing two buttons, one to update data and one to > close the window: > > {{=INPUT(_type='button',_value

[web2py] Re: Buttons in forms

2011-01-14 Thread DenesL
Hi Annet, "The input type button specifies a push button for use with client- side scripting. The VALUE attribute gives the text label of the button. The ONCLICK attribute is typically used to define the action taken when the button is activated." So no submit as pointed out by Mathew. Also, doc

Re: [web2py] Buttons in forms

2011-01-14 Thread Jonathan Lundell
On Jan 14, 2011, at 7:41 AM, annet wrote: > > I have a form containing two buttons, one to update data and one to > close the window: > > {{=INPUT(_type='button',_value='Update > data',_onclick=URL(r=request,f='update_form',args=[company[0].id]))}} > {{=INPUT(_type='button',_value='Close window',

[web2py] Urgent Need@@@@@@QA Tester

2011-01-14 Thread sangeetha
Hi Friends, Hope you are doing Good!!! If anyone interested please send updated resumes to* **h...@ksolinc.net* My Name is Sangeetha and i am working from Ksolinc.We have an urgent requirement with our Direct client. Below is the job description. *Position : QA Tester Location:

[web2py] Re: Need Help Using CRUD with Self-Referencing Tables

2011-01-14 Thread Savio Sabino
Hi, the follow model is rigth to crud: db.define_table('category',iObj, Field('parent','reference category'), Field('name'), format='%(name)s') db.category.parent.requires = IS_EMPTY_OR(IS_IN_DB(db, db.category.id, '%(name)s')) db.category.name.requires = IS_NOT_IN_DB(db, db.category.

[web2py] Re: Web2py Most Wanted

2011-01-14 Thread cjrh
On Jan 14, 5:21 pm, António Ramos wrote: > hello, to help web2py in the best possible way and in the least amount of > time , why dont Maximo suggest the plugins or areas where ther is a lack of > a plugin or code. There is always a need for testing, as trunk is quite active, and there is always

[web2py] Re: Web2py Most Wanted

2011-01-14 Thread Massimo Di Pierro
+1 On Jan 14, 11:37 am, cjrh wrote: > On Jan 14, 5:21 pm, António Ramos wrote: > > > hello, to help web2py in the best possible way and in the least amount of > > time , why dont Maximo suggest the plugins or areas where ther is a lack of > > a plugin or code. > > There is always a need for test

[web2py] Re: Interview with Massimo published

2011-01-14 Thread johntynan
Wonderful! What an excellent profile of Massimo. I also like that there was credit for inspiration for parts of web2py from other frameworks and tools. It's interesting to think of web2py as a "proof of concept"... I might say it's safe to call web2py a proven, but evolving concept. I am grate

[web2py] Re: Should I work for free? Funny

2011-01-14 Thread mattgorecki
I like that it was all done with CSS. No images in sight.

Re: [web2py] Re: Interview with Massimo published

2011-01-14 Thread contatogilson...@gmail.com
Of course, very good! :) _ *Gilson Filho* *Web Developer Blog:* blog.gilsondev.com *Twitter:* twitter.com/gilsonfilho 2011/1/14 johntynan > Wonderful! What an excellent profile of Massimo. I also like that > there was credit for inspiration for par

[web2py] Possible Bug in Recaptcha in web2py version 1.91.6

2011-01-14 Thread Andrew Evans
hello I have just updated my web2py to the latest version. I have not changed any code in my website referencing my form def contact(): use_recaptcha = True recaptcha_public = "6LeER8ASAI_koQRPAr3YBuk9v76YOOrEANx-" recaptcha_private = "6LeER8ASAGc0VonegXpSzo1R1-THzKqyerfb"

[web2py] Re: Web2py Most Wanted

2011-01-14 Thread David Marko
Interesting, we are also using Lotus Notes now for more than 14 years. Have you succesfully moved any LN apps to web2py? Any experience? How do you evaluate web2py comparing to Lotus Notes? I have always appreciated the easy of LN development but cant say the same about latest xPages (for web d

[web2py] Re: Possible Bug in Recaptcha in web2py version 1.91.6

2011-01-14 Thread Andrew Evans
nvm I just found the fix to my issue *cheers append self.options = options to the init function right after line 614 in gluon/tools.py anyway *cheers On Fri, Jan 14, 2011 at 11:06 AM, Andrew Evans wrote: > hello I have just updated my web2py to the latest version. I have not > changed any

Re: [web2py] Re: Web2py Most Wanted

2011-01-14 Thread Jonathan Lundell
On Jan 14, 2011, at 10:19 AM, Massimo Di Pierro wrote: > > +1 One good practice that would help out a lot. When possible, whenever you find or fix a bug in gluon, write a unit test that shows the bug, and *then* fix the bug. > > On Jan 14, 11:37 am, cjrh wrote: >> On Jan 14, 5:21 pm, António

Re: [web2py] Re: About bugreports

2011-01-14 Thread Kenneth Lundström
https://groups.google.com/group/web2py/browse_thread/thread/9e3e43b49743c54f?hl=fi I´m not sure this is a bug. https://groups.google.com/group/web2py/browse_thread/thread/2300767db7b2c4c8?hl=fi https://groups.google.com/group/web2py/browse_thread/thread/226113dea2e5b6e1?hl=fi https://groups.goo

[web2py] Fwd: PyCon early-bird deadline: MONDAY Jan. 17 [don't miss the web2py tutorial]

2011-01-14 Thread Anthony
For those interested... Note, the web2py tutorial to be taught by Massimo ("web2py Secrets") is scheduled for Wed, Mar 9, 9am - noon: http://us.pycon.org/2011/schedule/sessions/26/ Costs increase after Monday, and again after Mar 1, so act fast. Anthony -- Forwarded message -- Da

[web2py] Integrating web2py and a CMS

2011-01-14 Thread Kenneth Lundström
Hi again, I´ve been asked to build a website with a CMS (Drupal or ModXCMS are those that I know little) and a intranet for the organization. The intranet will be built with web2py. The intranet will contain a members database. Is there a way for a CMS to use web2py for authoriztion? So if t

[web2py] Re: Interview with Massimo published

2011-01-14 Thread VP
Sorry if my post was seen as a criticism. it was meant as a feedback, but probably didn't come out right. On Jan 14, 5:15 am, "contatogilson...@gmail.com" wrote: > Sorry if the translation was not very good. I'm studying English right? > Help are welcome:) > ___

Re: [web2py] Re: Interview with Massimo published

2011-01-14 Thread contatogilson...@gmail.com
No, I understood yes. I did not feel offended not. Quite the contrary, I thank the tip. So much so that we could do for the same country. The staff of Brazil could encourage the use of the tool as the others in their places of origin, for example. At first it would be great. ___

[web2py] Re: Number of records

2011-01-14 Thread Rick
Thanks for the suggestion! The 'id' field looks like a smart solution. But there seem to be a problem -- This line creates an error when I add the 'id' field and 'migrate=False' to the day table: records = db().select(db.day.ALL, orderby=db.day.thedate) Any ideas? On Jan 4, 4:03 am, Fabiano wrot

[web2py] Re: 1.79.2 -> 1.91.6 migration error (SQL Server BIT field seems to break)

2011-01-14 Thread Nico de Groot
I can confirm that the fix works for mssql. Discovered the problem today, didn't read this discussion until now, so I thought I could provide the fix for the line in dal.py: # near line 1087 in 1.91.6 + r = self.represent_exceptions(obj,fieldtype) - r = BaseAdapter.represent_exceptions(self,ob

[web2py] Re: Using mysqldb instead of pymysql

2011-01-14 Thread Luther Goh Lu Feng
To test if the issue is with pymysql, you could edit the dal file to use mysqldb http://code.google.com/p/web2py/source/diff?spec=svnfc75444ca55590835b4d0dc0e6c06a85e3f282a8&r=fc75444ca55590835b4d0dc0e6c06a85e3f282a8&format=side&path=/gluon/dal.py On Jan 13, 11:31 am, drayco wrote: > I need that

[web2py] Output of sum(), simplifying the JSON

2011-01-14 Thread Lorin Rivers
Controller: export_optimizer_records = dbset(db.table.FreezeTime,db.table.StringID,db.table.Po_avg.sum(),groupby=..FreezeTime|..StringID).as_list() View: var optimizerdata = {{response.write(json(export_optimizer_records), escape=False)}}; The JSON looks like this: [{ "panel_1hrs": {

Re: [web2py] Output of sum(), simplifying the JSON

2011-01-14 Thread Bruno Rocha
May be VirtualFields http://www.web2py.com/book/default/chapter/06#Virtual-Fields Bruno Rocha http://about.me/rochacbruno/bio 2011/1/14 Lorin Rivers > Controller: > export_optimizer_records = > dbset(db.table.FreezeTime,db.table.St

Re: [web2py] Re: (OT) Choosing a javascript mvc framework

2011-01-14 Thread David Bain
Angularjs looks interesting. On Tue, Jan 11, 2011 at 11:49 PM, Luther Goh Lu Feng wrote: > Tks for the suggestions. I should be going with angularjs > > > http://misko.hevery.com/2010/07/29/a-radically-different-way-of-building-ajax-apps/ > http://angularjs.org/ > > > On Jan 12, 2:12 am, pbreit

[web2py] access an uploaded but not stored file?

2011-01-14 Thread $p00ky
Dear community, I have a form with an upload field that I use to upload a text file, parse information from this file and store this information into the database, but not the file itself. The form is for example defined by: form = FORM(INPUT(_name='file_field', _type = 'file', requires = IS_NOT_

[web2py] Re: non-string (type list) error in appadmin on GAE

2011-01-14 Thread johntynan
Thanks Jonathan! I just tested this, and yes, you are right. This has been fixed in trunk. On Jan 14, 7:01 am, Jonathan Lundell wrote: > On Jan 13, 2011, at 9:45 PM, johntynan wrote: > > > > > I recently updated my web2py app to version 1.91.6 (along with > > updating GAE to version 1.4.1) and

[web2py] Re: Integrating web2py and a CMS

2011-01-14 Thread ron_m
This kind of information is often stored in a corporate directory using something called LDAP. I am not sure of the size of your company but it sounds like it is large enough to consider this solution. There is OpenLDAP on Linux or Active Directory on Microsoft which perform this task as concre

Re: [web2py] Interview with Massimo published

2011-01-14 Thread Jason Brower
I enjoyed the read. Thanks. Best Regards, Jason On 01/14/2011 03:36 AM, Bruno Rocha wrote: http://blog.gilsondev.com/2011/01/13/interview-creator-of-web2py/

Re: [web2py] Re: Number of records

2011-01-14 Thread Kenneth Lundström
Could you shows us the relevant part of your models file, where the table is defined and then also the error ticket. Kenneth Thanks for the suggestion! The 'id' field looks like a smart solution. But there seem to be a problem -- This line creates an error when I add the 'id' field and 'migra