[web2py] Re: Web2py - How to update a table field appending a string to an existing field value

2016-09-18 Thread Meinolf
Excellent, the None value was indeed the problem, so i just gave a default string value in the table definition as *Field('search_term', 'string', default='')* and now it works. Thanks a lot. On Monday, September 19, 2016 at 4:59:00 AM UTC+2, Massimo Di Pierro wrote: > > This works for me, I

[web2py] Re: Translation best practice

2016-09-18 Thread pbreit
The English strings get added to the files in the "Languages" directory and so you should just be able to give your translator the appropriate file from that directory. Spanish, for example: 'Clear RAM': 'Limpiar RAM', 'Click on the link %(link)s to reset your password': 'Pulse en el enlace

[web2py] Re: Fetching rows with st_asgeojson()

2016-09-18 Thread Massimo Di Pierro
How about this? features = [] for event in events: link = A(event[db.events.title], _href=URL('default', 'event_page', vars=dict(event_id=event[db.events.id]))).xml() item = { "type": "Feature", "popupContent": link, "track_quotation":

[web2py] Re: Web2py Solr UI

2016-09-18 Thread Massimo Di Pierro
The build_query is not efficient. It uses the LIKE operator therefore it does not uses proper full text search. Full text search builds an index of keywords and can efficiently search them inside text. Whoosh, Solr, and other libraries to that. Haystack is a wrapper named after the equivalent

[web2py] Re: Web2py - How to update a table field appending a string to an existing field value

2016-09-18 Thread Massimo Di Pierro
This works for me, I just tried: >>> db.define_table('rated_items', Field('search_term','string'), ) >>> k = db.rated_items.insert(search_term='a') >>> db(db.rated_items.id==k).update(search_term=db.rated_items.search_term+ 'b') >>> print db.rated_items[k] you probably have None

[web2py] pysqlite2.dbapi2.OperationalError'> near "<": syntax error

2016-09-18 Thread Peter
I got the error above while trying to rewrite and tidy up some code that I had working but didn't do everything I wanted. This is a lot neater but it doesn't work yet I think I am close! I have a person table and a task table where task.person is type 'references person' This is the code

[web2py] Translation best practice

2016-09-18 Thread icodk
I have a web2py application, where all text is in/are: T("text in English") Now I need to translat it to another language, even found a person willing to do it. What will be the best way to give him language file so he can translate it without giving him access to the administration of the

[web2py] Re: web2py on android

2016-09-18 Thread eric cuver
you can use local storage for example : var objet = { propriete1 : "valeur1", propriete2 : "valeur2" }; var monobjet_json = window.JSON.stringify(monobjet); window.localStorage .setItem("objet",monobjet_json); Le dimanche 18 septembre 2016 01:39:01 UTC+2, JorgeH a écrit : > > what if I need to

[web2py] Re: Form forget selected file

2016-09-18 Thread Anthony
In order to re-fill the file selection, you would have to know the file path on the user's machine, but the browser does not send this information due to security concerns, so you cannot maintain file selections across page reloads. You would either have to submit (or at least validate) the

[web2py] Form forget selected file

2016-09-18 Thread Gael Princivalle
Hello all. When a form is submitted with errors, if the user have choose first a file in this form, this choice is not reminded for the next submission attempt. Is there's a way to remind this choice? Thanks. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: booking/event calendar

2016-09-18 Thread icodk
Thank you both Looks great On Saturday, September 17, 2016 at 12:30:54 AM UTC+2, icodk wrote: > > Looking for a front end event/booking calendar to be used in web2py > application. > I actually found 49 on github (searching for javascript event calendar). > Just before I try them all, would be

Re: [web2py] booking/event calendar

2016-09-18 Thread António Ramos
+1 FullCalendar... 2016-09-18 7:10 GMT+01:00 Niphlod : > Go for fullcalendar > > -- > 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: Migrating Postgres to MySql

2016-09-18 Thread Joe Barnhart
When I first started using MySql awhile ago (after having used Postgres longer) I was screaming mad all the time. I absolutely hated MySql and the crap it put me through. That was a few years back, and I can't quite remember what made me so mad. Other than performance, of course. I feel

[web2py] booking/event calendar

2016-09-18 Thread Niphlod
Go for fullcalendar -- 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] scheduler and long tasks

2016-09-18 Thread Niphlod
You can have a task that selects and groups and queues for each group the task that processes the atom. -- 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) ---