Re: [web2py] SQLFORM question

2013-01-10 Thread Anthony
Looks like you copied the code incorrectly. It should be auth.user.id or auth.user_id, not db.auth_user.id. Anthony On Thursday, January 10, 2013 2:02:47 AM UTC-5, b00m_chef wrote: I found why it wasn't working. It is because the db was set to migrate=False. However, the code doesn't

Re: [web2py] Re: cpdb errors

2013-01-10 Thread Simon Ashley
*Final conclusion:* memory leak confined to pg8000. psycopg2 works fine in Windows and Linux. --

[web2py] automatic email when registration_requires_approval =True

2013-01-10 Thread António Ramos
hello i have this auth.settings.registration_requires_verification = True auth.settings.registration_requires_approval = True is it possible to send and email to admin after user verifies the link received by email? And after another email should be sent to the user telling him that his

Re: [web2py] Update and Delete row issue

2013-01-10 Thread Wonton
Hello, I've checked that from a fresh installation all inserts, updates and deletes of the database work perfectly without db.commit(). Besides this, I have 6 tables in which I do inserts, updates and deletes in all of them without db.commit() and they work perfectly, except for a specific

[web2py] InfoWorld's 2012 Technology of the Year Award winners

2013-01-10 Thread António Ramos
Do we have the result for 2013 Year Award winners Last year the the announcement was in January right? --

[web2py] Unique not working?

2013-01-10 Thread António Ramos
hello i have Field('empresa',db.auth_user,unique=True,requires=IS_IN_DB(db, 'auth_user.id ','auth_user.empresa',error_message=e_m['not_in_db'])), This is not preventing me to add another record with the same 'empresa' field as one already in the table What am i doing wrong? Thank you --

[web2py] Re: InfoWorld's 2012 Technology of the Year Award winners

2013-01-10 Thread Nico Zanferrari
Here http://www.infoworld.com/slideshow/80986 it is. Although web2py this year is not mentioned, you can find some of its underlying technologies ... Nico Il giorno giovedì 10 gennaio 2013 14:45:15 UTC+1, Ramos ha scritto: Do we have the result for 2013 Year Award winners Last year the

[web2py] Re: Unique not working?

2013-01-10 Thread Niphlod
probably you're using sqlite that doesn't have support for unique columns added afterwards in the model. PS: all the this is not preventing me etc if you want the error to show upon form submission, your requires is wrong. should be IS_IN_DB(db, 'auth_user.id', 'auth_user.empresa',

Re: [web2py] Update and Delete row issue

2013-01-10 Thread Wonton
I found it, it was my fault of course. The problem was that, in the method where I make the delete, several lines after the deletion (in a code not related with the database) I use a global variable not defined so the method fails, don't return anything and I guess some automatic db.commit is

[web2py] Re: raspberry pi

2013-01-10 Thread VP
Which OS runs on Raspberry Pi? Is there instructions to install Linux, for example, somewhere? Thanks. --

[web2py] custom authentication

2013-01-10 Thread Vijeenrosh PW Vijeen
Hello, greetings I am new to django , and on a migration from django to web2py . And I have been doing so by selectivly studying features I would like to know how could we login a user as in case of django ie, I would like to authenticate user like following def UserLogin(): if

[web2py] Re: custom authentication

2013-01-10 Thread Anthony
http://web2py.com/books/default/chapter/29/09#Manual-Authentication On Thursday, January 10, 2013 10:59:12 AM UTC-5, Vijeenrosh PW Vijeen wrote: Hello, greetings I am new to django , and on a migration from django to web2py . And I have been doing so by selectivly studying features I would

[web2py] Re: raspberry pi

2013-01-10 Thread Niphlod
http://www.raspberrypi.org/downloads Il giorno giovedì 10 gennaio 2013 16:55:30 UTC+1, VP ha scritto: Which OS runs on Raspberry Pi? Is there instructions to install Linux, for example, somewhere? Thanks. --

[web2py] cosm.com

2013-01-10 Thread Massimo Di Pierro
A colleague suggested this: https://cosm.com/ has anybody here used it? Looks interesting. --

[web2py] Re: automatic email when registration_requires_approval =True

2013-01-10 Thread Massimo Di Pierro
auth.settings.verify_email_onaccept = lambda form: mail.send(to='administra...@example.com',subject='something',message=repr(form.vars)) On Thursday, 10 January 2013 06:40:19 UTC-6, Ramos wrote: hello i have this auth.settings.registration_requires_verification = True

[web2py] FilePicker.io instead of upload button for files?

2013-01-10 Thread António Ramos
hello does anybody uses filepicker.io? Its allows you to save files in the cloud. I have a need to capture the image directly from a webcam and filepicker has the option to grab image from webcam. It return an url of the image stored in filepicker. I dont know how to use it do replace the

[web2py] Report bug to app admin

2013-01-10 Thread António Ramos
Hello, me again. A web2py default app has many default features. Can i suggest to add one that enables any user to report a bug to app admin? Thank you António --

Re: [web2py] Report bug to app admin

2013-01-10 Thread Bruno Rocha
Are you suggesting have a form for end users submit tickets for app developer or inside /admin have a form for app developer submit a ticket to web2py developers ? --

Re: [web2py] Report bug to app admin

2013-01-10 Thread António Ramos
I was refering to the first one . But the second is also interesting. It be a more detailed form so web2py developers could manage it better. 2013/1/10 Bruno Rocha rochacbr...@gmail.com Are you suggesting have a form for end users submit tickets for app developer or inside /admin have a

[web2py] List items not loading in profile form

2013-01-10 Thread Lamps902
Hi, group. My user_auth model includes list fields such as the user's home country and home state, which are declared thus: Field http://127.0.0.1:8000/examples/global/vars/Field('home_state',type=list:string,length=2, label=T http://127.0.0.1:8000/examples/global/vars/T('Home State'),

[web2py] I don't get routes.py

2013-01-10 Thread Andrew W
Hi all, Did we prune some content out of the book on this ? I'm sure there was more before. This is a line out of the Services chapter, talking about exactly what I need to know: yet this is a matter of test and we have already discussed it at length in chapter 4. But we haven't discussed

[web2py] request.args always empty...

2013-01-10 Thread Kic
Dear community, I have a strange problem reading in request.args . I was trying to implement the mechanism from the web2py book, chapter 29, SQLFORM.grid where it says: def manage(): table = request.args(0) if not table in db.tables(): redirect(URL('error')) grid =

[web2py] writing build scripts for web2py

2013-01-10 Thread Hector Magnanao
How do I write a build script for web2py ? --

Re: [web2py] I don't get routes.py

2013-01-10 Thread Jonathan Lundell
On 10 Jan 2013, at 11:04 AM, Andrew W awillima...@gmail.com wrote: Anyway, for my auth.wiki app, I don't want people to see this: http://www.myweb2pywebsite.com/init/default/index/my_wiki_page I want them to see: http://www.myweb2pywebsite.com/my_wiki_page, or maybe with the index in

Re: [web2py] cosm.com

2013-01-10 Thread Sarados Saradopoulos
http://openremote.org 2013/1/10 Massimo Di Pierro massimo.dipie...@gmail.com A colleague suggested this: https://cosm.com/ has anybody here used it? Looks interesting. -- --

Re: [web2py] I don't get routes.py

2013-01-10 Thread Andrew W
Thankyou very much ! On Friday, January 11, 2013 8:18:11 AM UTC+13, Jonathan Lundell wrote: On 10 Jan 2013, at 11:04 AM, Andrew W awill...@gmail.com javascript: wrote: Anyway, for my auth.wiki app, I don't want people to see this:

Re: [web2py] request.args always empty...

2013-01-10 Thread Jonathan Lundell
On 10 Jan 2013, at 10:34 AM, Kic lis...@lavalite.de wrote: Dear community, I have a strange problem reading in request.args . I was trying to implement the mechanism from the web2py book, chapter 29, SQLFORM.grid where it says: def manage(): table = request.args(0) if not table

[web2py] Re: writing build scripts for web2py

2013-01-10 Thread Niphlod
what do you want to do with a build script ? On Thursday, January 10, 2013 7:28:45 PM UTC+1, Hector Magnanao wrote: How do I write a build script for web2py ? --

[web2py] SoapClient method times out when called with a variable

2013-01-10 Thread Nick Vargish
Hi folks, Weird situation here... I am supposed to make a call to a SOAP service to indicate to another system that there is data that needs to be processed: client = SoapClient(wsdl='http://some.internal.server:/ws/sriks.postgresql:cartonTest?WSDL') result =

[web2py] Re: I don't get routes.py

2013-01-10 Thread Anthony
I don't think anything regarding URL rewrite was removed from the book, though the parameter-based system in particular has never been thoroughly documented there. Instead, the penultimate line of this sectionhttp://web2py.com/books/default/chapter/29/04#Parameter-based-systemsimply refers you

[web2py] Advice on working with CSV data

2013-01-10 Thread Andrew Evans
Hello everyone and Happy New Year! I was hoping to ask a few questions on working with existing databases in CSV format that do not come from web2py. So here goes. How can I work with the existing information, How would I make changes/additions to the data using web2py. The imported CSV data

[web2py] Re: 2.0.9 control-f firefox/chrome on mac doesn't work

2013-01-10 Thread Djinn Stone
I don't know if this will help anyone, but I figured this on my own. It might only solve a particular find issue. (My CTRL+F works on any Google Chrome website/page, just not on PDFs opened in Chrome, but I got it to work.) So! SOLUTION FOR PDFs OPENED W/IN G-CHROME... 1) WHILST IN THE

[web2py] Re: I don't get routes.py

2013-01-10 Thread Andrew W
Yes, I think you're correct. I must have glossed over this in my book searching. Thanks. On Friday, January 11, 2013 10:56:01 AM UTC+13, Anthony wrote: I don't think anything regarding URL rewrite was removed from the book, though the parameter-based system in particular has never been

[web2py] auth.navbar() and nofollow links

2013-01-10 Thread javierobcn
Hello, this is my first message, thanks to all members of this comunity for the great work made in web2py. I'm having problems trying to optimize my app to SEO. Basically i think that my problem is the function web2py auth.navbar() in gluon/tools.py, seems that this function are returning

[web2py] How to call a function from a web page

2013-01-10 Thread Alex Glaros
Hi, I'm looking at the beginner's examples. The examples work fine but I don't understand how they function. %%% *How would I type a clickable link to mytable_manage in the middle of the index page? In other words, how do I call a

Re: [web2py] How to call a function from a web page

2013-01-10 Thread Bruno Rocha
On Thu, Jan 10, 2013 at 10:30 PM, Alex Glaros alexgla...@gmail.com wrote: *views/default/mytable_manage.html* look in controllers/default.py inside this file there is a function called mytable_manage --

Re: [web2py] How to call a function from a web page

2013-01-10 Thread Alex Glaros
The index.html page doesn't have much in it...so web2py just automatically goes to all of these default .py files and runs them? If yes, when people write a large app, do they avoid using default files and implicitly specify where to go instead? thanks, Alex On Thursday, January 10, 2013

Re: [web2py] Re: error in mysql ?

2013-01-10 Thread samuel bonilla
but : what can i do about it ? 2013/1/9 samuel bonilla pythonn...@gmail.com thanks bruno. you're a genius El jueves, 3 de enero de 2013 20:30:53 UTC-5, samuel bonilla escribió: this is the error class '_mysql_exceptions.**IntegrityError' (1452, 'Cannot add or update a child row: a

Re: [web2py] Re: File generation using web2py

2013-01-10 Thread Andrew W
Hello Brian, Thanks very much for sharing your script. It works a treat and saved me a lot of time and confusion. Andrew On Wednesday, May 2, 2012 11:18:25 PM UTC+12, RAHUL PRIYADARSI wrote: Dear Mr.Brian, Thank you very much for you reply. If you're worried about text alignment and

Re: [web2py] How to call a function from a web page

2013-01-10 Thread Bruno Rocha
Please read the chapter 3 and 4 (overview and the core) those things will be very clear after you read few lines. http://web2py.com/books/default/chapter/29/03#Overview On Thu, Jan 10, 2013 at 10:50 PM, Alex Glaros alexgla...@gmail.com wrote: The index.html page doesn't have much in it...so

Re: [web2py] Re: error in mysql ?

2013-01-10 Thread samuel bonilla
the solucion is in datamodel article.category: error: Field(parent_id, reference article_category, default=44), solucion: Field(parent_id, reference article_category), thanks bruno 2013/1/10 samuel bonilla pythonn...@gmail.com but : what can i do about it ? 2013/1/9 samuel bonilla

Re: [web2py] Re: File generation using web2py

2013-01-10 Thread Brian M
Happy to help! On Thursday, January 10, 2013 6:54:06 PM UTC-6, Andrew W wrote: Hello Brian, Thanks very much for sharing your script. It works a treat and saved me a lot of time and confusion. Andrew On Wednesday, May 2, 2012 11:18:25 PM UTC+12, RAHUL PRIYADARSI wrote: Dear

[web2py] Re: I don't get routes.py

2013-01-10 Thread Andrew W
One more question if I may (I still don't get it): I am also replacing an existing website with a new web2py site. I've found links on other websites that still need to work with the new website. If someone clicks on an old link such as mydomain.com/aboutus.html, I would like it to redirect

[web2py] restful DELETE not getting vars

2013-01-10 Thread weheh
Using latest release 1.3.x. @request.restful() def rest(): response.view = 'generic.json' def GET(*args, **vars): ... def POST(*args, **vars): ... def PUT(*args, **vars): ... def DELETE(*args, **vars): if 'delete' in args[0]: return

[web2py] Re: I don't get routes.py

2013-01-10 Thread Andrew W
Don't bother, I should have looked in routes_example.py too. Thanks. On Friday, January 11, 2013 4:13:39 PM UTC+13, Andrew W wrote: One more question if I may (I still don't get it): I am also replacing an existing website with a new web2py site. I've found links on other websites

[web2py] Re: auth.navbar() and nofollow links

2013-01-10 Thread Massimo Di Pierro
Excellent idea, in trunk. Please check it. On Thursday, 10 January 2013 16:24:56 UTC-6, javierobcn wrote: Hello, this is my first message, thanks to all members of this comunity for the great work made in web2py. I'm having problems trying to optimize my app to SEO. Basically i think