[web2py] JSON getting the series data into view

2016-09-12 Thread Aydin
The methods to get the data in the view of web2py does not seem working. I used the method mentioned in http://web2py.com/books/default/chapter/29/10/services which is

[web2py] Re: Web2py sqlite select database records using wildcards

2016-09-12 Thread Meinolf
yes an example would do especially to use a string variable name instead of 'value', i.e db.mytable.myfield.like(variablename).select() for example. But thanks for the response, so far at least i've got an idea.. On Monday, September 12, 2016 at 10:08:16 PM UTC+2, Dave S wrote: > > > > On Monday

[web2py] Re: Turbolinks?

2016-09-12 Thread Dave S
On Monday, September 12, 2016 at 1:21:20 PM UTC-7, pbreit wrote: > > Does Python or Web2py have anything like Turbolinks? Has anyone used > anything like https://github.com/Easyfood/pageAccelerator or > http://instantclick.io with web2py with any success? Good idea? > Links to excerpts from a

[web2py] Turbolinks?

2016-09-12 Thread pbreit
Does Python or Web2py have anything like Turbolinks? Has anyone used anything like https://github.com/Easyfood/pageAccelerator or http://instantclick.io with web2py with any success? Good idea? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py

[web2py] Re: Web2py sqlite select database records using wildcards

2016-09-12 Thread Dave S
On Monday, September 12, 2016 at 12:39:17 PM UTC-7, Meinolf wrote: > > Anyone knows the web2py's sqlite syntax to select database records using > wildcards such as %like% or contains instead of query = db.mytable.myfield > == 'value'? > > According to the book, it's db(db.log.event.like('string

[web2py] Re: Web2Py Navigating table records one at a time

2016-09-12 Thread Meinolf
resolved, i completely changed the approach to 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) --- You received this message because you are s

[web2py] Web2py sqlite select database records using wildcards

2016-09-12 Thread Meinolf
Anyone knows the web2py's sqlite syntax to select database records using wildcards such as %like% or contains instead of query = db.mytable.myfield == 'value'? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://co

[web2py] Re: How to increase the number of open forms that can be submitted (from 10) ?

2016-09-12 Thread Robert Pates
Thanks for the comment, Massimo -- Can you point me to any coded examples of this technique? On Saturday, June 18, 2016 at 8:57:23 AM UTC-4, Massimo Di Pierro wrote: > > As suggested it is critical that multiple forms on the same name have > different formname(s) and this is true even if the for

[web2py] Re: web2py resources

2016-09-12 Thread Alfonso Serra
Another tool for Firefox that may help to develop your applications. This AutoHotKey script reloads your browser and removes the repost Confirmation dialog whenever you press Ctrl + S. So if you save your code in any editor Firefox will show the changes. Havent tested for Chrome but it may work

[web2py] Need help to understand (and reproduce) this error

2016-09-12 Thread Lisandro
Hi there! I have a simple view with a form (with GET method), in order to allow my visitors to do some search. The controller/function that processes the get is this: def search(): session.forget(response) query = "tsv @@ plainto_tsquery('%s')" % request.vars.q total = db.executesql(

Re: [web2py] change the default applicaton of web2py

2016-09-12 Thread Anthony
On Monday, September 12, 2016 at 5:35:52 AM UTC-4, Massimiliano wrote: > > In routes.py > > set: > > default_application = "myapp" > > > That will translate http://mysite.com/ to http://mysite.com/myapp/default/index, but it will not translate http://mysite.com/mycontroller/myfunction to http:

[web2py] Re: why request.vars are added an additional key “records” with null value when I used the sqlform.grid?

2016-09-12 Thread Anthony
Answered here: http://stackoverflow.com/a/39450123/440323 On Monday, September 12, 2016 at 2:37:13 AM UTC-4, Yibing Liu wrote: > > > My web2py version is 2.14.6. > > I define a form in myview.html > >` > > > > > ` > > In my default controler function 'inde

[web2py] Re: as_list AttributeError: 'dict' object has no attribute 'myLabel'

2016-09-12 Thread Anthony
Or if you ultimately do need a list of dictionaries, call .as_list() after first creating labelList. On Monday, September 12, 2016 at 7:32:03 AM UTC-4, Niphlod wrote: > > as list returns a proper dictionary, not a list of Row objects. At this > point, as_list() in your code is superflous. But if

[web2py] Re: as_list AttributeError: 'dict' object has no attribute 'myLabel'

2016-09-12 Thread Niphlod
as list returns a proper dictionary, not a list of Row objects. At this point, as_list() in your code is superflous. But if you want to use it, you then have to access "myLabel" as row['myLabel'] On Monday, September 12, 2016 at 10:11:46 AM UTC+2, Annet wrote: > > I have the following query: > >

[web2py] Re: why request.vars are added an additional key “records” with null value when I used the sqlform.grid?

2016-09-12 Thread Yibing Liu
Thank you very much. Your answer is very clear. 在 2016年9月12日星期一 UTC+8下午5:31:55,Niphlod写道: > > it's to hold selected lines, I think. Anyway, you should use > request.get_vars to get your data (since your method is "get"). Also, > please note that the grid is coded in such a way that the grid is t

Re: [web2py] change the default applicaton of web2py

2016-09-12 Thread Massimiliano
In routes.py set: default_application = "myapp" http://www.web2py.com/books/default/chapter/29/04/the-core?search=init#Application-init On Mon, Sep 12, 2016 at 8:36 AM, Alessio Varalta < alessio.vara...@ethicalsoftware.it> wrote: > Hi, I call my application with base_url+ name_application. >

[web2py] Re: why request.vars are added an additional key “records” with null value when I used the sqlform.grid?

2016-09-12 Thread Niphlod
it's to hold selected lines, I think. Anyway, you should use request.get_vars to get your data (since your method is "get"). Also, please note that the grid is coded in such a way that the grid is the sole "manager" of the request/response cycle, so fiddling in the same page with your own piece

[web2py] as_list AttributeError: 'dict' object has no attribute 'myLabel'

2016-09-12 Thread 'Annet' via web2py-users
I have the following query: rows = db(db.ntw_edge_label_set.vertexID==vertexID).select(db.ntw_edge_label_set.myLabel).as_list() which returns: [{'myLabel': 'NASM Personal Trainers'}, {'myLabel': 'Traineeship'}] when I try: labelList = [row.myLabel for row in rows] I get the following error: