[web2py] Re: SQLFORM.grid, how to edit non-visible field in the onvalidate function?

2014-02-07 Thread LightDot
Hello Marty, On Saturday, February 8, 2014 6:55:26 AM UTC+1, A36_Marty wrote: > > I've given up on trying hide a field in the grid yet still be able to see > and modify it in the onvalidation route. > > I tried for a few hours to achieve the same via custom forms by using > hidden={'fieldname':v

[web2py] Re: SQLFORM.grid, how to edit non-visible field in the onvalidate function?

2014-02-07 Thread A36_Marty
I've given up on trying hide a field in the grid yet still be able to see and modify it in the onvalidation route. I tried for a few hours to achieve the same via custom forms by using hidden={'fieldname':value}. I could see the hidden field in the validation function of the custom form, but c

[web2py] Re: how to keep request when redirecting

2014-02-07 Thread NeoToren
Maybe capturing what you need in session.chkbox1, session.radio2, etc ? It should work while you move between views... On Sunday, February 2, 2014 12:21:44 PM UTC-5, aapaap wrote: > > hello, > > I've a form with checkboxes and radiobuttons. > All the checkboxes and radioboxes are auto-commit, i

[web2py] Re: Did anyone submit a web2py app on Google Play or iTunes ?

2014-02-07 Thread 黄祥
> > I wonder if there are any Web2Py apps on Google Play or Apple iTunes > stores? > web2py slices is available on google play store : https://play.google.com/store/apps/details?id=com.webpyslices best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation)

[web2py] Did anyone submit a web2py app on Google Play or iTunes ?

2014-02-07 Thread NeoToren
I wonder if there are any Web2Py apps on Google Play or Apple iTunes stores? The reason I am asking is that it may not be as trivial as it seems... The process of submitting an app to Amazon appstore is pretty straight forward, the only pain is parking their 'manifest' file on the correct spot at

[web2py] Re: How to reset authentication?

2014-02-07 Thread LightDot
Looks like web2py thinks that your main database structure is different than it really is. With other words, database migrations are broken for your app. That's why auth works if you start with a fresh database and doesn't if you use the existing one. Since you've been replacing one database wi

[web2py] represent on grid that link to another grid

2014-02-07 Thread 黄祥
hi, is it possible to have represent on grid that link to another grid? e.g. table.supplier.represent = lambda supplier, field: \ A(supplier.name, _title=T("View Supplier"), _target="_blank", _href=URL('report','report_supplier', args = ['supplier', 'view', 'supplier', field.supplier]) ) i've t

[web2py] Re: MySQL not showing tables when using python web2py.py -S appname -M

2014-02-07 Thread Dave S
On Wednesday, February 5, 2014 11:53:40 AM UTC-8, Anthony wrote: > > When you do "for x in db", that will iterate of the Table objects attached > to db. The Table objects are just models defined in your model files -- > they do not necessarily have to correspond to actual tables in your > datab

[web2py] Re: How to reset authentication?

2014-02-07 Thread Austin Taylor
Now I just tried to reset password and I get 1054, "Unknown column 'auth_membership.is_active' in 'field list' On Friday, February 7, 2014 4:07:15 PM UTC-5, Austin Taylor wrote: > > Thanks, Massimo. Whenever I click register I get some new unknown column > 'modified_by' in the field list (error

[web2py] Re: HTML Input (POST) field

2014-02-07 Thread Austin Taylor
Anthony/All, I'd like to return the results through an AJAX button. Right now I have everything being appended to a dictionary. How could I have the dictionary displayed on the same page after they click the button? On Wednesday, February 5, 2014 4:12:19 PM UTC-5, Anthony wrote: > > On Wednesda

[web2py] Re: Autopostback and Bulk Insert with one Form

2014-02-07 Thread samuel bonill
Mira este ejmplo, cuando seleccionas una opcion nueva llama a un controlador via ajax e inserta la respuesta en un div : dos funciones en el controlador para este ejemplo : *def index():form = SQLFORM.factory(Field('opciones', \ requires=IS_IN_SET(['opcion1', 'opcion2'

[web2py] jQuery Noob question: usage of this

2014-02-07 Thread Dominique
Answer: I should have put: onclick="jQuery(this).dosomething()"/> In the input. Dom -- 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 mes

[web2py] Re: How to reset authentication?

2014-02-07 Thread Austin Taylor
Thanks, Massimo. Whenever I click register I get some new unknown column 'modified_by' in the field list (error 1054). I have tried manually adding each field whenever I get new errors, but I'm tired of it and just want to start over. I restored the views and controller to the default, but stil

Re: [web2py] Acces to row object with widget (widget=lambda field, value, row: ...)

2014-02-07 Thread Richard Vézina
Nice trick!! Many thanks for that, I read read too fast your preceding post... I will see what I can do with that, it should solve my issue... Richard On Fri, Feb 7, 2014 at 1:51 PM, Anthony wrote: > So, is : >> >> widget=lambda field, value, row: ... >> >> Working out of the box in last web2

[web2py] Autopostback and Bulk Insert with one Form

2014-02-07 Thread Leandro E . Colombo Viña
Hi guys! I'm on my way to learning web2py and I need some help. I'm trying to build a form to populate or modify a table with several rows at the same time. The idea is this: I have a table which stores dates, more precisely, annual dates (like holidays, for example). And I want to create a form t

[web2py] Re: Restricting certian access based on Active Directory groups

2014-02-07 Thread Niphlod
although manage_group=True seems to create/update/maintain at login-time the groups a user is in. This apparently works out: - fetching ldap groups user is in - inserting them in auth_groups - inserting/deleting the correct auth_membership infos every time a user logs in. So, each time a user lo

[web2py] Re: adding table column/field pro grammatically to existing table under controler

2014-02-07 Thread Andrey K
Thanks Anthony. Based on your anser I can say that my problem comes from my design of the db. As the requirements have just changed and I have to provide ability to each user to add columns - so it would need to be adopted for regular basis. In addition I have checked limit of most db in max ta

[web2py] Re: SQLFORM.grid, how to edit non-visible field in the onvalidate function?

2014-02-07 Thread Massimo Di Pierro
What makes it hidden in the first place? I do not see a difference in the fields except for the names. On Friday, 7 February 2014 08:43:19 UTC-6, A36_Marty wrote: > > I'm stumped. Have tried this with the grid, custom forms, etc. > > Could someone advise how to achieve the questions highlight

[web2py] Re: Redis caching

2014-02-07 Thread Jufsa Lagom
Hello Arnon. I just made a quick search of your posts on the other groups on groups.google.com.. On many (almost all) groups that you have made posts, you run into arguments with longtime members/contributors that have put down huge amount of time in the projects. You say yourself in many pos

[web2py] Re: Import from MySQL

2014-02-07 Thread Massimo Di Pierro
Is it possible the table you are querying does not have an id field? Can you show the model? On Thursday, 6 February 2014 12:37:51 UTC-6, Garry Smith wrote: > > HI > > I have just started using web2py, but have used MVC in other programming > languages, the problem I have gaot is importing a db

[web2py] Re: Restricting certian access based on Active Directory groups

2014-02-07 Thread Massimo Di Pierro
It does not work this way. One think are web2py groups which you check with @auth.has_membership(role='group-name') and another things are Active Directory groups. There is no login in web2py that maps one into the other. ldap_auth(...allowed_groups = ['UnixAdmin'],...) if it works (I have not

Re: [web2py] Acces to row object with widget (widget=lambda field, value, row: ...)

2014-02-07 Thread Anthony
> > So, is : > > widget=lambda field, value, row: ... > > Working out of the box in last web2py stable? > No, web2py will not pass a row to a widget -- it only passes a field and value. That's why I said to do: lambda field, value, row=row: ... In that case, you are specifying the "row" argume

[web2py] Re: How to reset authentication?

2014-02-07 Thread Massimo Di Pierro
Hard to help you without seeing the cod or the error tickets. There should be no difference between auth in sqlite or mysql. You should not save auth info a different database else you lose the ability to join the auth_user table with other tables and that is often an important requirement. On

[web2py] Re: adding table column/field pro grammatically to existing table under controler

2014-02-07 Thread Anthony
> > db = DAL('sqlite://se2.sqlite',check_reserved=['postgres', > 'postgres_nonreserved'],pool_size=10,lazy_tables=False, migrate=True, > fake_migrate=False) > now I got right results: > >>> db.ta._fields >

[web2py] Re: adding table column/field pro grammatically to existing table under controler

2014-02-07 Thread Andrey K
I guess I found answer for my new issue of not updated db.table. It is sqlite problem - no ability to drop or add column. See here: http://web2py.com/books/default/chapter/29/6#Fixing-broken-migrations On Friday, February 7, 2014 8:17:08 PM UTC+3, Andrey K wrote: > > Thanks Anthony. > Yahaaa. N

Re: [web2py] Re: Strange artifact

2014-02-07 Thread José Ricardo Borba
+1 I REALLY ignore IE for development purposes. If something works on IE, its a plus. ;-) Regards, 2014-02-07 12:57 GMT-02:00 Willoughby : > IE has been out for 18 years and since day one has exhibited differing > behavior to that of other browsers that have come along the way. > (And I say thi

[web2py] Re: adding table column/field pro grammatically to existing table under controler

2014-02-07 Thread Andrey K
Thanks Anthony. Yahaaa. Now it works. As u suggested I have successfully changed settings of lazy_tables to False and it works: db = DAL('sqlite://se2.sqlite',check_reserved=['postgres', 'postgres_nonreserved'],pool_size=10,lazy_tables=False, migrate=True, fake_migrate=False) now I got right r

[web2py] Re: adding table column/field pro grammatically to existing table under controler

2014-02-07 Thread Andrey K
Cliff, No worries - I understand where are you coming from. From the beginning I had 3 options of table structure for my app. I have decided consciously that I am going to use one table as a storage for program parameters. Where each new program brings 1 to N new columns/fields to the existing

Re: [web2py] Acces to row object with widget (widget=lambda field, value, row: ...)

2014-02-07 Thread Richard Vézina
Notting, it just don't work... Notice, I am using web2py 2.4.7... So passing row not seems an option... Also, the lazy_option plugin is bizz, I don't fully understand how it get to know the value, and field already is used for something else and not seems to be used as it normal in the custom widg

Re: [web2py] Acces to row object with widget (widget=lambda field, value, row: ...)

2014-02-07 Thread Anthony
Then what's wrong with just doing: widget=lambda field, value, row=row: lazy_options_widget(field=field, on_key='no_table_master_field__selected', off_key='master_field__unse

[web2py] Re: adding table column/field pro grammatically to existing table under controler

2014-02-07 Thread Anthony
Looks like it's an issue with lazy_tables. I'll look into it, but for now, give it a try by turning off lazy_tables. Anthony On Friday, February 7, 2014 8:45:46 AM UTC-5, Anthony wrote: > > Hmm, works for me. What version of web2py are you using? > > On Friday, February 7, 2014 8:07:10 AM UTC-5,

[web2py] Re: Strange artifact

2014-02-07 Thread Willoughby
IE has been out for 18 years and since day one has exhibited differing behavior to that of other browsers that have come along the way. (And I say this as someone who likes IE) As a web developer, you quickly learn that and either code around it for your IE users or ignore the 'quirks' that IE p

[web2py] Re: Strange artifact

2014-02-07 Thread Paolo Caruccio
Please pack a post a w2p app with the only code for grid. I will test it in IE10. I can't install IE11 on windows8. Maybe the issue is related to css rules applied to that DOM element but without code I'm not able to help you. Il giorno venerdì 7 febbraio 2014 05:16:10 UTC+1, horridohobbyist ha

[web2py] SQLFORM.grid, how to edit non-visible field in the onvalidate function?

2014-02-07 Thread A36_Marty
I'm stumped. Have tried this with the grid, custom forms, etc. Could someone advise how to achieve the questions highlighted below - or - if it can't be done with a grid, how to achieve it? db.define_table('table', Field('field_hidden', 'string'), Field('field_n

Re: [web2py] Acces to row object with widget (widget=lambda field, value, row: ...)

2014-02-07 Thread Richard Vézina
Kind of... Richard On Thu, Feb 6, 2014 at 6:14 PM, Anthony wrote: > Don't have time to process all this, but are you saying you have a row > object and just need to know how to pass it to a custom widget? > > > On Thursday, February 6, 2014 4:14:26 PM UTC-5, Richard wrote: >> >> Hello, >> >> I

Re: [web2py] Re: How to handle (add?) hidden fields with a grid after submission / setting in onvalidation?

2014-02-07 Thread Richard Vézina
Ok!! Wy not use this plugin : http://www.web2pyslices.com/slice/show/1616/widget-select-or-add-option-ng This slice is a derivatives of this original slice : http://www.web2pyslices.com/slice/show/1446/widget-select-or-add-option I had use the original successfully, I even modified it to allo

[web2py] Re: adding table column/field pro grammatically to existing table under controler

2014-02-07 Thread Anthony
Hmm, works for me. What version of web2py are you using? On Friday, February 7, 2014 8:07:10 AM UTC-5, Andrey K wrote: > > Thanks Anthony for your concise answer! > I have tried it in the app code - it did not work, giving me no error. I > have tried your code in the terminal and it looks the co

[web2py] Re: adding table column/field pro grammatically to existing table under controler

2014-02-07 Thread Cliff Kachinske
Andrey, Not to be negative, but why do you want to do this? On Friday, February 7, 2014 8:07:10 AM UTC-5, Andrey K wrote: > > Thanks Anthony for your concise answer! > I have tried it in the app code - it did not work, giving me no error. I > have tried your code in the terminal and it looks th

[web2py] Re: adding table column/field pro grammatically to existing table under controler

2014-02-07 Thread Andrey K
Thanks Antony for your concise answer! I have tried it in the app code - it did not work, giving me no error. I have tried your code in the terminal and it looks the code does not create new table field. Any idea why it does not work? Maybe its my db settings? I use sqlite db. Your help would v

Re: [web2py] heads up if you localized your app and upgrade to version 2.8.2+

2014-02-07 Thread Anthony
I'm thinking of the various flash messages shown with forms and Auth as well as validator error messages. What gluon messages are you talking about? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.co

[web2py] Re: Dreamhost deployment

2014-02-07 Thread LightDot
What kind of access do you have, is it a VPS or a shared hosting, etc.? Did you try their user support? Regards On Friday, February 7, 2014 2:37:08 AM UTC+1, sasogeek wrote: > > how do I install python 2.7 and web2py on dreamhost with a windows > environment? I looked at the dreamhost wiki but

[web2py] Re: strange behavior of ajax() function if there are request,args

2014-02-07 Thread Mirek Zvolský
Yes, really ! Means that if there is not full URL(), web2py creates the url for ajax request from current page url and if request.args are in use, web2py will make bad address. There is one points to make it more clear: - why web2py creates as bad address just the address of the whole page (not

[web2py] Re: Search operators

2014-02-07 Thread Niphlod
"in" and "not in" map to "belongs" and "~belongs". Values are splitted by a comma. So, *table.field in "a,b" * maps to *db(db.table.field.belongs(['a','b']))* On Friday, February 7, 2014 5:50:04 AM UTC+1, horridohobbyist wrote: > > In SQLFORM.grid, you have a Search operation in the form. Th