[web2py] Re: SQLFORM.grid change form vars

2017-06-01 Thread icodk
Thanks I am a bit slow but I think I got it. On Friday, June 2, 2017 at 4:41:39 AM UTC+2, Anthony wrote: > > On Thursday, June 1, 2017 at 5:52:08 PM UTC-4, icodk wrote: >> >> Thanks, That explain why it didn't work in smartgrid (because I haven't >> specify the table name) >> I still do not unde

[web2py] Re: SQLFORM.grid change form vars

2017-06-01 Thread icodk
Dave S. I appreciate your responsiveness and alertness and the ever willingness to help others. Thanks On Friday, June 2, 2017 at 6:37:03 AM UTC+2, Dave S wrote: > > > > On Thursday, June 1, 2017 at 6:19:02 PM UTC-7, Dave S wrote: >> >> >> >> On Thursday, June 1, 2017 at 2:52:08 PM UTC-7, icodk

[web2py] Re: grid add/edit form label

2017-06-01 Thread T.R.Rajkumar
You've got it backwards -- the top-level keys of the editargs and createargs parameters should be the table names, with the nested dictionaries holding the actual SQLFORM arguments. I am not familiar with the syntax. Can you pl. elaborate with some actual code. Thanks Anthony. -- Resources: -

[web2py] Re: Login(auth) from Oracle db

2017-06-01 Thread Dave S
On Thursday, June 1, 2017 at 7:44:48 PM UTC-7, Вячеслав Анатольевич wrote: > > Hi! > Can anybody help me? I am only starting on web2py. > So, i have db oracle with alredy having data, and i want to make login > only, without reg/change pass and other. > I have a table in db for example, user_psw

[web2py] Re: SQLFORM.grid change form vars

2017-06-01 Thread Dave S
On Thursday, June 1, 2017 at 6:19:02 PM UTC-7, Dave S wrote: > > > > On Thursday, June 1, 2017 at 2:52:08 PM UTC-7, icodk wrote: >> >> Thanks, That explain why it didn't work in smartgrid (because I haven't >> specify the table name) >> I still do not understand how my arguments will effect the

[web2py] Re: postgres 8, psycopg2, text datatype limit of 32k.

2017-06-01 Thread lucas
yes, thank you, it all connects now. 1073741824 = 2**30 = 1GB. thank you again, lucas -- 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

[web2py] 'validate_and_insert' throws error each time on latest version where it was fine before on prev version

2017-06-01 Thread Jordan Ladora
Hello, I just belatedly upgraded from 8/9/15 (v2.12.2-stable) -> 5/10/16 (v2.14.6-stable) and have about 100 instances of 'validate_and_insert' in my application. My app was previously (with 8/9/15 version) running these instances of 'validate_and_insert' A-OK but now, basically every instance of

[web2py] strange error: Field update_record does not belong to the table

2017-06-01 Thread Jochen Naumann
Hi, I am an experienced web programmer but new to web2py, so I hope to find some help here :-) I have an application running perfectly on my local server (macbook air, web2py 2.14) but the same application on a linux web server (web2py 2.9) throws this strange exception inside web2pys function f

[web2py] Login(auth) from Oracle db

2017-06-01 Thread Вячеслав Анатольевич
Hi! Can anybody help me? I am only starting on web2py. So, i have db oracle with alredy having data, and i want to make login only, without reg/change pass and other. I have a table in db for example, user_psw, where i have "name" and "pwd" - (username & password). How i can tell web2py watch use

Re: [web2py] Re: Any ideas on how to prepare web2py apps for GDPR

2017-06-01 Thread Anthony
On Thursday, June 1, 2017 at 1:06:20 PM UTC-4, Ramos wrote: > > One of the requisites is encryption on all user specific data > Do you have a link to any detailed specifications? Is encrypting the server storage adequate? I suspect these are not necessarily going to be in scope for a web framewo

[web2py] Re: SQLFORM.grid change form vars

2017-06-01 Thread Anthony
On Thursday, June 1, 2017 at 5:52:08 PM UTC-4, icodk wrote: > > Thanks, That explain why it didn't work in smartgrid (because I haven't > specify the table name) > I still do not understand how my arguments will effect the auto generated > SQLFORM or what kind of argument will effect the form and

[web2py] Re: SQLFORM.grid change form vars

2017-06-01 Thread Dave S
On Thursday, June 1, 2017 at 2:52:08 PM UTC-7, icodk wrote: > > Thanks, That explain why it didn't work in smartgrid (because I haven't > specify the table name) > I still do not understand how my arguments will effect the auto generated > SQLFORM or what kind of argument will effect the form a

[web2py] Re: SQLFORM.grid change form vars

2017-06-01 Thread icodk
Thanks, That explain why it didn't work in smartgrid (because I haven't specify the table name) I still do not understand how my arguments will effect the auto generated SQLFORM or what kind of argument will effect the form and in what way. Is Niphlod's example is the only thing you can do with

Re: [web2py] Re: Any ideas on how to prepare web2py apps for GDPR

2017-06-01 Thread Dave S
On Thursday, June 1, 2017 at 10:06:20 AM UTC-7, Ramos wrote: > > One of the requisites is encryption on all user specific data > Isn't that better handled by the database engine? /dps > > 2017-06-01 18:01 GMT+01:00 Anthony >: > >> What specific functionality do you think web2py could offer a

Re: [web2py] Re: Any ideas on how to prepare web2py apps for GDPR

2017-06-01 Thread António Ramos
One of the requisites is encryption on all user specific data 2017-06-01 18:01 GMT+01:00 Anthony : > What specific functionality do you think web2py could offer at the > framework level? > > > On Thursday, June 1, 2017 at 6:40:15 AM UTC-4, Ramos wrote: >> >> I have 3 apps where i need to address

[web2py] Re: SQLFORM.grid change form vars

2017-06-01 Thread Anthony
On Wednesday, May 31, 2017 at 6:37:53 PM UTC-4, icodk wrote: > > Antony > could you elaborate or give an example of how to use formargs,editargs > etc. ? > When viewing/creating/updating individual records, the grid creates a SQLFORM. You can use formargs, etc. to pass arguments directly to the

[web2py] Re: Any ideas on how to prepare web2py apps for GDPR

2017-06-01 Thread Anthony
What specific functionality do you think web2py could offer at the framework level? On Thursday, June 1, 2017 at 6:40:15 AM UTC-4, Ramos wrote: > > I have 3 apps where i need to address this issue... > > > > http://www.computerweekly.com/news/450419960/Top-UK-firms-websites-violate-key-GDPR-princ

[web2py] Re: grid add/edit form label

2017-06-01 Thread Anthony
On Thursday, June 1, 2017 at 5:35:14 AM UTC-4, T.R.Rajkumar wrote: > > For a smartgrid I am doing this. > form = SQLFORM.smartgrid(db.amc_master, > linked_tables=['amc_details'], > user_signature=False, > fields=

[web2py] Re: How to speed up query processing in web2py's sqlite?

2017-06-01 Thread Leonel Câmara
Creating an index on the field you're searching will help. You should probably also cache the results of the queries if at all possible. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/i

[web2py] Re: postgres 8, psycopg2, text datatype limit of 32k.

2017-06-01 Thread Leonel Câmara
Yes, that's the default value for length of text type fields see here: https://github.com/web2py/pydal/blob/master/pydal/objects.py#L40 The value is set to 2**15 which is 32768 Then you don't have a requires so web2py puts one for you in https://github.com/web2py/web2py/blob/master/gluon/dal.py#

Re: [web2py] Migration fails when dropping a column on Postgresql

2017-06-01 Thread Richard Vézina
Thanks Doug, I was understanding that, it much clearer now though. Your use case for rname seems exactly what rname is for. Good luck Richard On Wed, May 31, 2017 at 6:15 PM, Doug Taylor wrote: > Hi Richard - > > Thanks for response. I am running web2py version: > Version 2.14.6-stable+timest

[web2py] Re: grid add/edit form label

2017-06-01 Thread Jim S
Set the 'label' attribute on the individual fields that will be displayed before your call to SQLFORM.smartgrid() Ex: db.customer.first_name.label = 'First Name' -Jim On Thursday, June 1, 2017 at 4:35:14 AM UTC-5, T.R.Rajkumar wrote: > > For a smartgrid I am doing this. > form = SQLFORM.smartg

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

2017-06-01 Thread Paco Bernal
In server side when rendering the view you use python vars with {{=my_python_var}} If you are asking how to use a python var in client side with javascript you can use ASSIGNJS(js_var=python_var) Take a look at the files I uploaded before. def mycontroller(): . return ASSIGNJS(js_v

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

2017-06-01 Thread sunda . amran
I totally agree with that but then how do you use that list in the view as a python variable ??? Le jeudi 1 juin 2017 09:09:15 UTC+2, Junior Phanter a écrit : > > > var list_sunda = ""; > ajax("your_echo_url", [], ':eval'); > > > def echo_url(): > list_sunda=[1,2,3,4,5] > return "list_

[web2py] Any ideas on how to prepare web2py apps for GDPR

2017-06-01 Thread António Ramos
I have 3 apps where i need to address this issue... http://www.computerweekly.com/news/450419960/Top-UK-firms-websites-violate-key-GDPR-principle?utm_medium=EM&asrc=EM_EDA_77932701&utm_campaign=20170601_Top%20UK%20firms%E2%80%99%20websites%20violate%20key%20GDPR%20principle&utm_source=EDA Regard

[web2py] Re: grid add/edit form label

2017-06-01 Thread T.R.Rajkumar
For a smartgrid I am doing this. form = SQLFORM.smartgrid(db.amc_master, linked_tables=['amc_details'], user_signature=False, fields=dict(amc_master=list_of_fields), formstyle='table3

[web2py] How to speed up query processing in web2py's sqlite?

2017-06-01 Thread Mike Stephenson
I see that with a million of rows, the search takes almost 15-20 seconds. How do I speed it up? -- 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 recei

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

2017-06-01 Thread Paco Bernal
But what are you returning in the controller?? El jueves, 1 de junio de 2017, 8:49:46 (UTC+2), sunda...@gmail.com escribió: > > Hey paco, > > the problem is that i am using script, so the the action in the controller > is a callback, it means that it dont have his html page. > > -- Resourc

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

2017-06-01 Thread Junior Phanter
var list_sunda = ""; ajax("your_echo_url", [], ':eval'); def echo_url(): list_sunda=[1,2,3,4,5] return "list_sunda=%s;" %list_sunda 2017-06-01 3:49 GMT-03:00 : > Hey paco, > > the problem is that i am using script, so the the action in the controller > is a callback, it means that it d