[web2py] Re: missing field in search tab, using smartgrid

2017-02-23 Thread Pierre
Solved Thank you Antony, that was exactly right :) The amazing thing is that i had imported all the database content (from access to sqlite), and all the code was working, making some math on that field without any problem. Changed it to 'double', and it's now showing on the drop down list.

Re: [web2py] Emberjs web2py

2017-02-23 Thread António Ramos
just import it like any other js file from static folder.beware of web2py delimiters... 2017-02-22 17:11 GMT+00:00 PK : > If i wanna use emberjs build dist folder with web2py how should i start. > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://gith

Re: [web2py] Re: Delete a row from one table when two tables are joined

2017-02-23 Thread Mat Miles
Actually that solution was not quite correct. The one below is. if form.process(formname='form').accepted: rows = db(db.auth_user.location_id == auth.user.location_id).select(db.auth_user.id) db(db.shift_availability.created_by.belongs(rows)).delete() On Thu, Feb 23, 2017 at 12:57 PM, M

Re: [web2py] Re: Delete a row from one table when two tables are joined

2017-02-23 Thread Mat Miles
Thanks that worked. I have a shift_availability table and the auth_user table. The auth_user table contains a location. I want to clear all the rows in the shift_availability table but by location. Below is the solution: if form.process(formname='form').accepted: rows = db((db.shift_availabili

[web2py] Fullcalendar scheduler and menu

2017-02-23 Thread Andrea Fae'
When I use fullcalendar scheduler and call controller from menu. After calling the controller and see the view menu item changing. It disappear the arrow to click and it's not usable. This is the menu response.menu = [ ('Sede Pordenone', False, None, [ (T('Scheduler'), URL(

Re: [web2py] Re: javascript prompt and modal dialog

2017-02-23 Thread Andrea Fae'
Can you givem me examples about using this beautiful addon? Il giorno giovedì 23 febbraio 2017 20:09:08 UTC+1, Andrea Fae' ha scritto: > > When I click function select I want that appears a modal dialog using > jquery, asking some fields, and using this fields passing to controller > > Il giorno

Re: [web2py] Re: javascript prompt and modal dialog

2017-02-23 Thread Andrea Fae'
When I click function select I want that appears a modal dialog using jquery, asking some fields, and using this fields passing to controller Il giorno mercoledì 22 febbraio 2017 17:23:51 UTC+1, Ramos ha scritto: > > i like this one > https://limonte.github.io/sweetalert2/ > and im using it with

[web2py] SQLFORM.factory edit existing record(s) in multiple tables

2017-02-23 Thread lucas
hello one and all, ok, so I have the basic code: btn = [INPUT(_type='submit', _name='submit', _value='Add 1-Step')] btn.append(INPUT(_type='submit', _name='summary', _value='Add 1-Step then Summary')) frm = SQLFORM.factory(db.case, db.sheet, buttons=btn) which is great for merging f

[web2py] text field input control

2017-02-23 Thread Pierre
Hi everyone, is it useful to clean a form textarea prior to db.insert ? I am asking this because of *bleach* : https://bleach.readthedocs.io/en/latest/clean.html I have read a recent post which says it's secure enough not to use the XML helper when displaying text content... can't figure

Re: [web2py] web2py ldap integration. ldap bind

2017-02-23 Thread Richard Vézina
I would say it is case sensitive, would you mean case insensitive like AD? If so, I am not sure, I think the issue (if we can call it an issue) is coming from the fact that username field is case sensitive, and don't think of a simple way to change that except manipulating cases of input username

[web2py] Re: class for required fields

2017-02-23 Thread rif
Thank you, Leonel. I will try to do that. I am just thinking that maybe a class should be added by the default formstyles and left to the users whether to use it or not. joi, 23 februarie 2017, 18:31:55 UTC+2, Leonel Câmara a scris: > > Just make your own formstyle which adds the required class

[web2py] Re: class for required fields

2017-02-23 Thread Leonel Câmara
Just make your own formstyle which adds the required class to inputs from fields which requires is not None. -- 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] class for required fields

2017-02-23 Thread rif
Hi guys, Was there any conclusion for this thread: https://groups.google.com/d/topic/web2py/lwKcjC-j__A/discussion ? Is there a standard/recommended way to add a class to the required form fields? Thanks, -rif -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http:

[web2py] Re: missing field in search tab, using smartgrid

2017-02-23 Thread Anthony
"float" is not a valid field type -- it should be "double". See http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Field-types. Anthony On Thursday, February 23, 2017 at 8:27:36 AM UTC-5, Pierre wrote: > > Any hint on why only one field is missing in the search drop dow

[web2py] missing field in search tab, using smartgrid

2017-02-23 Thread Pierre
Any hint on why only one field is missing in the search drop down smartgrid ? Is there a way to find a "special" attribute about a field that would prevent it to be visible in the drop down list ? ps: I can search on this field (writing the query manualy ) What I've tried so farwithout results