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

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 : > We have a new "powered by" web site. > > http://web2py.com/pow

[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 onl

[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 = 's

[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. Th

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 qu

[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 f

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, 2015

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. Wh

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 “t

[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 t

[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 Groups

[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)__( 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 reques

[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 definiti

[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 tbl1

[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: SQLite(sqlite3),

[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 tbl1

[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 be

[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 common

[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 w

[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 s

[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 = db(db.log

[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 val