[web2py] Some help with computed field in a query

2016-04-03 Thread Henk huisman
Could anyone show me how to build a query with a computed field that consists of a constant and a value of the ID of the records. The constant is an URL and the value is the ID of the row. I tried this (among several other attempts). rowsb=db.executesql("SELECT 'dikke bmw' as caption, startdate

Re: [web2py] Re: OFF Topic - Cycle.js

2016-04-03 Thread António Ramos
I bought this course and it looks amazing.. https://pragmaticstudio.com/elm Now my head is sooo confused. 2016-04-04 0:03 GMT+01:00 Leonel Câmara : > I think elm looks pretty good actually. I'm wait and see on it because I > have some resistance to learning yet another

[web2py] Re: OFF Topic - Cycle.js

2016-04-03 Thread Leonel Câmara
I think elm looks pretty good actually. I'm wait and see on it because I have some resistance to learning yet another language. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

Re: [web2py] Re: OFF Topic - Cycle.js

2016-04-03 Thread António Ramos
There goes react. i hate it by the way.. have you also tried elm??? Its also a functional reactive programing language http://elm-lang.org/examples 2016-04-02 18:45 GMT+01:00 Massimo Di Pierro : > I like it a lot better than React. I still prefer ractive.js and

[web2py] No module named __builtin__

2016-04-03 Thread icodk
I get No module named __builtin__ when I copy application perfectly running on Windows from web2py 2.12.3 to 2.14.3. Did the same with another application without a problem. Any idea ? Version web2py™ Version 2.14.3-stable+timestamp.2016.03.26.23.02.02 Python Python 2.7.9:

[web2py] list field and form.elements

2016-04-03 Thread Pierre
Hi, I try to manipulate a SQLFORM based on a list:integer field with form.elements but it doesn't work. If I add input fields via the + and - butttons they aren't reflected in the form object. whatever the number of present in the form len( form.elements('li')) is always 1 ? --

[web2py] Re: What's this and how do I correct this?

2016-04-03 Thread Leonel Câmara
It's normal that you can't open appadmin if you have this problem, no one told you to open it anyway. Go to the databases folder, deleter files with .table extension, launch web2py with your app configured to do a fake migration. Read the book section I linked. -- Resources: -

[web2py] Re: What's this and how do I correct this?

2016-04-03 Thread Emmanuel Dsouza
I can't even open the appadmin now. They show eror tokens. Even edit option wasn;t there but managed to open it by editing the url of another app. On Sunday, April 3, 2016 at 3:54:24 PM UTC+5:30, Leonel Câmara wrote: > > Erase your .table files in the databases folder and then do a fake >

[web2py] As I use web2py from source with some modules from my pc,will those module work on pythonanywhere?

2016-04-03 Thread Stephen Duisberg
For example, my app uses unirest which is working because I have installed unirest on my pc. Do I have to install it in the app module too or pythonanywhere has all sorts of python modules inbuilt? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: @Anthony, can you please check what's wrong with the unirest module?

2016-04-03 Thread Stephen Duisberg
Thank you, it worked! On Sunday, April 3, 2016 at 3:48:51 PM UTC+5:30, Leonel Câmara wrote: > > You are shadowing web2py's response in your code with a response from a > unirest call. Call it something else. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: What's this and how do I correct this?

2016-04-03 Thread Leonel Câmara
Erase your .table files in the databases folder and then do a fake migration to generate them again. See http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Fixing-broken-migrations -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: @Anthony, can you please check what's wrong with the unirest module?

2016-04-03 Thread Stephen Duisberg
Hi Leonel. Thanks, I didn't get you though . How is this wrong? What am I missing here? response = unirest.post("https://voicerss-text-to-speech.p.mashape.com/?key=secret1;, headers={ "X-Mashape-Key": "secret2", "Content-Type": "application/x-www-form-urlencoded" }, params={

[web2py] Re: Why unirest doesn't work? What kind of error is this?

2016-04-03 Thread Leonel Câmara
Instead of response = unirest.post ... Call it something other than just "response", for instance response_post = unirest.post... -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] What's this and how do I correct this?

2016-04-03 Thread Emmanuel Dsouza
Yesterday my app was working fine. I didnt even insert anything to it. What is this error? What do I do now? Not even appadmin is opening! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: @Anthony, can you please check what's wrong with the unirest module?

2016-04-03 Thread Leonel Câmara
You are shadowing web2py's response in your code with a response from a unirest call. Call it something else. -- 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)

[web2py] Re: bug? menu v2.14.3

2016-04-03 Thread lucas
what could be their reason to get rid of a good function or feature? -- 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

[web2py] @Anthony, can you please check what's wrong with the unirest module?

2016-04-03 Thread Stephen Duisberg
each time I use it for any purpose I get the same error as: Traceback (most recent call last): File "C:\web2py\gluon\main.py", line 450, in wsgibase serve_controller(request, response, session) File "C:\web2py\gluon\main.py", line 192, in serve_controller

[web2py] Re: deploying web2py on IIS

2016-04-03 Thread Dmitri Ermolaev
*wfastcgi.py for IIS and web2py* воскресенье, 3 апреля 2016 г., 7:56:03 UTC+3 пользователь Dmitri Ermolaev написал: > > I do it! Its work: > http://web2py.com/books/default/chapter/29/13/deployment-recipes#IIS > > IIS much quicker than Apache - Apache load a processor at 100% for AJAX >

[web2py] Re: In the dropdown here how to remove Profile?

2016-04-03 Thread Stephen Duisberg
Is it possible to add extra stuffs into the table as I asked earlier? On Tuesday, March 29, 2016 at 6:27:45 AM UTC+5:30, 黄祥 wrote: > > pardon, not sure what do you mean with 'add extra fields to the dropdown > table' > > best regards, > stifan > -- Resources: - http://web2py.com -

[web2py] Re: Why unirest doesn't work? What kind of error is this?

2016-04-03 Thread Stephen Duisberg
Why does unirest doesn't work? On Sunday, April 3, 2016 at 10:13:10 AM UTC+5:30, Stephen Duisberg wrote: > > my code: > > import unirest > > def index(): > response = > unirest.post("https://voicerss-text-to-speech.p.mashape.com/?key= >

[web2py] Re: Scheduler always QUEUED and no record in scheduler_worker and scheduler_run data table

2016-04-03 Thread narges Rezaei
hi Pengfei Yu , is your code true? Is it working well? i want use it. On Monday, September 29, 2014 at 6:07:53 PM UTC+3:30, Pengfei Yu wrote: > > Hi, > > I have a web application hosted on AWS EC2 with Apache2. I plan to use > web2py scheduler for some heavy tasks with user input files. Now I

[web2py] Link to create new entry in grid create/update view

2016-04-03 Thread Lionel Roubeyrie
Hi, Says a table db.define_table('book', Field('title'), Field('author', 'reference author') ) Inside the create/update view of the grid based on this table, is it possible to have a create button right after the dropdown widget representing the author ? Subsidiary question : if it's

[web2py] Re: SQLFORM.grid: search in a list:reference field does not work

2016-04-03 Thread Lionel Roubeyrie
Hi all, I just start with this great framework and I have a similar issue. In a table there's two 'list:reference' Fields but none is searchable in the grid view. Is there some special things to do before? Le dimanche 8 novembre 2015 10:53:35 UTC+1, mweissen a écrit : > > I have a table like >

[web2py] Re: Join on 2 Different Databases

2016-04-03 Thread Massimo Di Pierro
All web2py does is generate SQL for you. This is not possible. you can manually merge results from two queries on different databases in Python and get a Row object but it would not be efficient. On Saturday, 2 April 2016 12:56:31 UTC-5, m...@greenlots.com wrote: > > I have two database