[web2py] Strange behaviour of SQL query on accented characters

2017-05-30 Thread Karoly Kantor
Please help: I have this: print "DEBUG: query = " + str(query) result = mydb(query).select(*column_names) print db._lastsql This will print this into the log: DEBUG: query = record.application = 3) AND (record.entity = 24)) AND (record.is_deleted = 'F'))

[web2py] Re: Future of web2py

2017-05-30 Thread Karoly Kantor
Hello Massimo, May I have two questions on this? 1. You say current web2py interprets code on every request. What does this mean on Google App Engine? (Every time I deploy, GAE seems to compile...) 2. Overall, what do your plans exactly mean for people with an existing app on web2py? Is this a

[web2py] Re: grid edit

2017-05-30 Thread isi_jca
T.R.Rajkumar Try setting this value: *field_id* must be the field of the table to be used as ID, for example db.mytable.id. This is useful when the grid query is a join of several tables. Any action button on the grid(add record, view, edit, delete) will work over db.mytable. Regards. -- R

[web2py] Re: not web2py related but this is free now

2017-05-30 Thread isi_jca
Thanks a lot and best regards -- 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: the ajax callback action return a list [URGENT]

2017-05-30 Thread sunda . amran
In my controller, i have a list which i called tools which containes values. I would like to return this list like you said. In my view i would like to retrieve the value and to put the values inside variable( with loop i think) But when i put eval and i call the function javascription from th

[web2py] left join in grid is throwing unsupported operand types for += 'dict and 'dict'

2017-05-30 Thread Tim Richardson
I'm trying a left outer join in a sqlform.grid Traceback Traceback (most recent call last): File "C:\Users\tim\web2py_dev\gluon\restricted.py", line 216, in restricted exec(ccode, environment) File "C:\Users\tim\web2py_dev\applications\patient_form\controllers/patient_appointments.py:p

[web2py] Re: the ajax callback action return a list [URGENT]

2017-05-30 Thread Paco Bernal
mmm... maybe you are looking for ASSIGNJS(js_var=python_list) It depends on the way you want to do whatever you wanna do :) if you get the name of the list is because you *return dict(your_list=your_list)* and in the view you have* {{=your_list}} *you need to *return ASSIGNJS(my_js_var=you

[web2py] Re: the ajax callback action return a list [URGENT]

2017-05-30 Thread Paco Bernal
Here you have an example about what I told you without using ':eval' It's easier to user alert('{{=client_details.name}}'); of course, it's only to show you ASSIGNJS and that you always can do things in many several ways :) El martes, 30 de mayo de 2017, 14:46:08 (UTC+2), sunda...@gmail.com

[web2py] Re: Strange behaviour of SQL query on accented characters

2017-05-30 Thread tim . nyborg
Looks like the issue is: str(query) The query is a unicode object by default, and á can't be converted to a string, since it's outside the ascii character set. Try this instead: print u"DEBUG: query = " + query On Tuesday, 30 May 2017 11:07:30 UTC+1, Karoly Kantor wrote: > > Please help: > > I

[web2py] Re: not web2py related but this is free now

2017-05-30 Thread JorgeH
It looks like a pretty good job. Very complete. Thanks for sharing On Monday, May 29, 2017 at 6:32:51 PM UTC-5, Massimo Di Pierro wrote: > > ... and I thought some may be interested: > > > https://raw.githubusercontent.com/mdipierro/nlib/master/docs/book_numerical.pdf > https://github.com/mdipie

[web2py] Re: grid edit

2017-05-30 Thread Anthony
The "id" field is not writable in SQLFORMs, so the grid/SQLFORM do not include that field in update SQL queries. Does the "id" field actually appear as writable in your forms? What happens if you just do SQLFORM.grid(db.amc_master) without specifying the fields list or setting any of the readab

[web2py] Webservices en Python con SUDS

2017-05-30 Thread Alberto Arzuaga
este es mi código: from suds import client url = " http://commonservices.min1.dtc/SearchPersonService/SearchPersonWCFService.svc?wsdl

[web2py] Re: How to use Let's Encrypt with Web2Py on Apache

2017-05-30 Thread Raymond Smith
Please tell me how you did this!! :) IT would be really helpful :) On Saturday, March 5, 2016 at 12:30:35 PM UTC+13, Jacinto Parga wrote: > > How can routes.py be configured to return the requested file? > > The page requested is something like this: > > > http://example.com/.well-known/acme-chal

[web2py] Re: Future of web2py

2017-05-30 Thread Marlysson Silva
Could you put this thoughts about web2py's future in some place to community? In issues , documentation , topic discussion .. So the community would know what have to do and could suggest more enhancements .. Because the people stay waiting by some programmers to develop some features of frame

[web2py] Re: web2py support

2017-05-30 Thread Marlysson Silva
I think that it will take a little .. I suggest start with web2py .. After the core developers will see the backward compatibility Em terça-feira, 30 de maio de 2017 03:41:38 UTC-3, T.R.Rajkumar escreveu: > > I am now porting a jsp application to web2py. Should I stay with web2py or > wait for w

[web2py] Re: left join in grid is throwing unsupported operand types for += 'dict and 'dict'

2017-05-30 Thread Dave S
On Tuesday, May 30, 2017 at 6:12:53 AM UTC-7, Tim Richardson wrote: > > I'm trying a left outer join in a sqlform.grid > > > Traceback > > Traceback (most recent call last): > File "C:\Users\tim\web2py_dev\gluon\restricted.py", line 216, in > restricted > exec(ccode, environment) > File

[web2py] Re: Webservices en Python con SUDS

2017-05-30 Thread Dave S
On Tuesday, May 30, 2017 at 8:50:42 AM UTC-7, Alberto Arzuaga wrote: > > este es mi código: > > from suds import client > url = " > http://commonservices.min1.dtc/SearchPersonService/SearchPersonWCFService.svc?wsdl > >

[web2py] Re: How to use Let's Encrypt with Web2Py on Apache

2017-05-30 Thread Dave S
On Tuesday, May 30, 2017 at 8:50:50 AM UTC-7, Raymond Smith wrote: > > Please tell me how you did this!! :) IT would be really helpful :) > > I can't answer for the Apache case (or even for the preferred NginX case), but I found using CertBot in manual mode was easy (on AWS Linux). Rocket was

[web2py] Re: How to use Let's Encrypt with Web2Py on Apache

2017-05-30 Thread Dave S
On Tuesday, May 30, 2017 at 12:05:01 PM UTC-7, Dave S wrote: > > > > On Tuesday, May 30, 2017 at 8:50:50 AM UTC-7, Raymond Smith wrote: >> >> Please tell me how you did this!! :) IT would be really helpful :) >> >> > I can't answer for the Apache case (or even for the preferred NginX case), > b

[web2py] Re: web2py support

2017-05-30 Thread icodk
Could be interesting to hear what are the arguments for the porting On Tuesday, May 30, 2017 at 8:41:38 AM UTC+2, T.R.Rajkumar wrote: > > I am now porting a jsp application to web2py. Should I stay with web2py or > wait for web3py? Will there be web2py group support like now after web3py. > Pl

[web2py] Re: redirect an upload

2017-05-30 Thread Marlysson Silva
The request.requires_https() is written on top of models file once time.. And to respect of redirect .. Could you use the absolute URL .. Create completly The doc of URL() have this.. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

Re: [web2py] Re: Field('upload') : problem with file name

2017-05-30 Thread Wabba Jak
Hi Dave, Yes it helps... :) Putting the web2py directory near the Drive path.. (T_T) Also i will try your suggestion editing the filename before the upload process in the Form Thanks it greatly helps.. On Fri, May 26, 2017 at 3:28 AM, Dave S wrote: > > > On Wednesday, May 24, 2017 at 9:37:17

[web2py] different default application based on the host header - Python anywhere - Go daddy

2017-05-30 Thread Ron Chatterjee
How do I set up routes.py for multiple domain? Currently I have one domain in go daddy that I tied to python anywhere with routes.py as shown below and it works fine. When I go to www.domain1.com it gets routed to my_app in pythonanywhere. routers = dict( BASE = dict(default_application='my

[web2py] Re: Future of web2py

2017-05-30 Thread Ron Chatterjee
Massimo, Do you see its better to do incremental changes to web2py that leads us to web3py at some point than to a completely new framework which may be lot of work and it will take monumental effort to fix all the bugs it may have.Just some thoughts... On Tuesday, May 30, 2017 at 12:40:45 PM

[web2py] Re: different default application based on the host header - Python anywhere - Go daddy

2017-05-30 Thread Dave S
On Tuesday, May 30, 2017 at 5:09:18 PM UTC-7, Ron Chatterjee wrote: > > How do I set up routes.py for multiple domain? > > Currently I have one domain in go daddy that I tied to python anywhere > with routes.py as shown below and it works fine. > What do you mean "one domain in go daddy that I

[web2py] Re: Future of web2py

2017-05-30 Thread Dave S
On Tuesday, May 30, 2017 at 5:11:49 PM UTC-7, Ron Chatterjee wrote: > > Massimo, Do you see its better to do incremental changes to web2py that > leads us to web3py at some point than to a completely new framework which > may be lot of work and it will take monumental effort to fix all the bugs

[web2py] Re: web2py support

2017-05-30 Thread Dave S
On Tuesday, May 30, 2017 at 2:54:28 PM UTC-7, icodk wrote: > > Could be interesting to hear what are the arguments for the porting > The porting for what? Porting web2py to Python3? Porting web2py to web3py? Porting web2py apps to web3py? Problems with compatibility [and eventually, Py2 EO

[web2py] Re: different default application based on the host header - Python anywhere - Go daddy

2017-05-30 Thread Dave S
On Tuesday, May 30, 2017 at 6:05:11 PM UTC-7, Dave S wrote: > > > > On Tuesday, May 30, 2017 at 5:09:18 PM UTC-7, Ron Chatterjee wrote: >> >> How do I set up routes.py for multiple domain? >> >> Currently I have one domain in go daddy that I tied to python anywhere >> with routes.py as shown bel

Re: [web2py] now web2py related but this is free now ...

2017-05-30 Thread R. Strusberg
Thank you Massimo. Ricardo Strusberg Simón Bolívar University. @strusberg @campusb Enviado desde un dispositivo movil El 29/05/2017 19:31, "Massimo Di Pierro" escribió: and I thought some may be interested: https://raw.githubusercontent.com/mdipierro/nlib/master/ docs/book_numerical.pdf https

[web2py] Re: redirect an upload

2017-05-30 Thread Dave S
On Tuesday, May 30, 2017 at 2:59:58 PM UTC-7, Marlysson Silva wrote: > > The request.requires_https() is written on top of models file once time.. > > And to respect of redirect .. Could you use the absolute URL .. Create > completly > > The doc of URL() have this.. > I went back to the model