[web2py] Re: Problems with mail.send()

2015-01-03 Thread Gael Princivalle
Hello I think I have a similar problem. With an ssl smtp server on port 587 email are going out. With a tls smtp server on port 25 web2py don't give me an error but mails are not sent. In model: mail = auth.settings.mailer mail.settings.server = 'zimbra.mydomain.com:25' mail.settings.sender =

Re: [web2py] SQLite, or some other database?

2015-01-03 Thread Paolo Valleri
The boolean issue (1==1) is due to this https://github.com/web2py/web2py/blob/master/gluon/dal/adapters/base.py#L912 We can block it raising a syntax error but it will brake existing apps otherwise I propose this https://github.com/web2py/web2py/pull/580/files Paolo On Saturday, January 3,

Re: [web2py] SQLite, or some other database?

2015-01-03 Thread Massimo Di Pierro
These are not valid DAL expressions: db((db.mytable.field1'C') 1).select() db((db.mytable.field1'C') (1==1)).select() db((db.mytable.field1'C') 'True').select() db((db.mytable.field1'C') 'TRUE').select() the argument of db() must be a query or a logical expression comprised of queries.

Re: [web2py] SQLite, or some other database?

2015-01-03 Thread Marin Pranjić
The latter one works only with postgres: https://groups.google.com/forum/#!topic/web2py/1_DHUrrg6O8 What's the error message? On Sat, Jan 3, 2015 at 5:30 AM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: On Friday, 2 January 2015 16:03:16 UTC-6, mweissen wrote: I have tried to

[web2py] how to: tumblr login for web2py

2015-01-03 Thread Falko Delarue
This is how you login to your web2py app with Tubmblr Register a Tubmblr app (you will of course need a Tubmblr account) https://www.tumblr.com/oauth/register and configure later at https://www.tumblr.com/settings/apps get the consumer key and secret install the oauth2 lib (instructions

[web2py] response.js leads to error

2015-01-03 Thread ArtDijk
LS I have an index page with a table wit 2 columns and 3 rows. (form1, graph1, form2, graph2, form3, graph3) In the top left cell I select some data (type, month etc) In the top right a graph is shown (bokeh Bar chart) In the left middle cell I select a values from the index from the graph.

[web2py] How to display columns of data without abbreviation in the database aministrative interface?

2015-01-03 Thread Przemysław Loesch
Hallo! Is there a way to see the content of each column with data from a table without abbreviation? Currently I use administrative interface to put same initial data for my project (like entity types) which definitely won't change in the future so there is no need of creating better interface

Re: [web2py] New Powered by site - advertise your work

2015-01-03 Thread Ovidio Marinho
Very Good! Ovidio Marinho Falcao Neto ITJP.NET.BR ovidio...@gmail.com itjp.net...@gmail.com Brasil 2015-01-02 10:44 GMT-03:00 Massimo Di Pierro massimo.dipie...@gmail.com: We have a new powered by web site.

Re: [web2py] SQLite, or some other database?

2015-01-03 Thread Martin Weissenboeck
Hi Massimo, thank you very much for this detailed explanation. *About the boolean query:* You are right (of course :-)), that a query like (db.mytable.field'C') b with b as a boolean expression is not mentioned in the manual. But I think it is not forbidden in SQL and it coulld be useful. What

Re: [web2py] SQLite, or some other database?

2015-01-03 Thread Massimo DiPierro
Hello Martin, I agree this is allowed in SQL. If an expression is allowed in SQL you can wrap it in Expression (from gluon.dal import Expression) and pass it in place of any parameter. Yet if you chose to do it you introduce a dependency on the specific SQL dialect. The problem with passing

[web2py] Re: response.js leads to error

2015-01-03 Thread Anthony
What does this have to do with response.js? On Saturday, January 3, 2015 8:02:06 AM UTC-5, ArtDijk wrote: LS I have an index page with a table wit 2 columns and 3 rows. (form1, graph1, form2, graph2, form3, graph3) In the top left cell I select some data (type, month etc) In the top

[web2py] Re: Web2Py on AWS EC2

2015-01-03 Thread Niphlod
AWS EC2 is nothing more of a linux server . to start executables listening on port 80 superuser permissions are needed, only high ports are allowed at normal user powers (that's why on production one usually deploys web2py BEHIND a real webserver). Enough of that said, starting with python

[web2py] Re: response.js leads to error

2015-01-03 Thread ArtDijk
Don't know. Rephrased the title. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google

[web2py] Re: response.js leads to error

2015-01-03 Thread Anthony
Your code doesn't show any use of response.js. In any case, what leads you to believe response.js is related to the problem? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] How can I from a celery task post a message in websocket_messaging.py?

2015-01-03 Thread Tito Garrido
Hey Folks, I am studying websockets and I am wondering how could I post a message from a script that is running outside of web2py, like a celery task. Anybody has an small example? Thanks in advance! Tito -- Linux User #387870 . _/_õ|__| ..º[ .-.___.-._| . . . . .__( o)__(

Re: [web2py] Re: Rocket // HTTP 400 Bad Request - Body is incomplete

2015-01-03 Thread Louis Amon
I've tested the native error handler (working fine) versus my custom error handler (generating HTTP 400 error + web2py stuck) : The main difference between the two is that the native error handler doesn't generate an additional request while routes_onerror seems to generate an additional

[web2py] Struggling with multi user

2015-01-03 Thread Gary Cowell
Hello Sorry for the probably obvious questions, but I do search for answers honest :) Anyway, what I want is for my table rows to be user specific. Such that when each user registers, the database looks empty to them, until they start creating rows in their forms. I have added these

[web2py] Re: pagination issue redirecting to the current page

2015-01-03 Thread Joe
Hi Michele, thanks so much for looking at this problem. I appreciate it very much. I tried the code but after selecting, the user is still sent back to page 1 each time, not staying on the same page. On Friday, January 2, 2015 10:18:44 PM UTC+8, Michele Comitini wrote: in the view links add

[web2py] web2py sqlform.grid join problem

2015-01-03 Thread Roman Rakus
Hi, I have folloving tables. db.define_table('tbl1', Field('code', 'string')) db.define_table('tbl2', Field('field1', 'integer', 'reference tbl1'), Field('field2', 'integer', 'reference tbl1')) Now I need render values from tbl2 in sqlform.grid. How I can join tbl2.field1 and tbl2.field2 on

[web2py] Re: Web2Py on AWS EC2

2015-01-03 Thread NeoToren
My apologies Niphlod, 1. I didn't mention that the result of the command ... python web2py.py -a mypwd ... is actually : *web2py Web Framework* *Created by Massimo Di Pierro, Copyright 2007-2015* *Version 2.9.11-stable+timestamp.2014.09.15.23.35.11* *Database drivers available:

[web2py] sqlform.grid with double join

2015-01-03 Thread Roman Rakus
Hi, I have folloving tables. db.define_table('tbl1', Field('code', 'string')) db.define_table('tbl2', Field('field1', 'integer', 'reference tbl1'), Field('field2', 'integer', 'reference tbl1')) Now I need render values from tbl2 in sqlform.grid. How I can join tbl2.field1 and tbl2.field2 on

[web2py] web2py and sublime test

2015-01-03 Thread Massimo Di Pierro
I came across this: https://github.com/cassiobotaro/my_environment Useful! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message

[web2py] Re: Struggling with multi user

2015-01-03 Thread Massimo Di Pierro
I would do: db.define_table( 'shoe', Field('model',db.model), Field('purchased','date'), Field('price','integer'), auth.signature, # include created_by and created_on format=lambda r: '%s %s %s' % (r.model.manufacturer.name ,r.model.model,r.purchased)) along with a

[web2py] Re: How to display columns of data without abbreviation in the database aministrative interface?

2015-01-03 Thread Dave S
On Saturday, January 3, 2015 1:39:57 AM UTC-8, Przemysław wrote: Hallo! Is there a way to see the content of each column with data from a table without abbreviation? Currently I use administrative interface to put same initial data for my project (like entity types) which definitely won't

[web2py] Re: How to display columns of data without abbreviation in the database aministrative interface?

2015-01-03 Thread Dave S
On Saturday, January 3, 2015 9:48:23 PM UTC-8, Dave S wrote: On Saturday, January 3, 2015 1:39:57 AM UTC-8, Przemysław wrote: Hallo! Is there a way to see the content of each column with data from a table without abbreviation? Currently I use administrative interface to put same

[web2py] Re: How to display columns of data without abbreviation in the database aministrative interface?

2015-01-03 Thread Dave S
On Saturday, January 3, 2015 9:50:05 PM UTC-8, Dave S got the view in. Trying yet again to post the controller . My controller is about 6 lines of code (and 25 lines of commented out code from earlier experiments); 2 def func(): 3 query = 'db.logtable.id 0' 4 maxId =

[web2py] Re: sqlform.grid with double join

2015-01-03 Thread Dave S
On Saturday, January 3, 2015 10:20:55 AM UTC-8, Roman Rakus wrote: Hi, I have folloving tables. db.define_table('tbl1', Field('code', 'string')) db.define_table('tbl2', Field('field1', 'integer', 'reference tbl1'), Field('field2', 'integer', 'reference tbl1')) Now I need render values