[web2py] Re: No-dropdown widget?

2017-12-03 Thread Dave S
On Sunday, December 3, 2017 at 9:32:36 AM UTC-8, Massimo Di Pierro wrote: > > instead of (the default) > > requires=IS_IN_DB(db, table) > > do > > requires=[IS_IN_DB(db, table)] > > Thank you, that works nicely (once I got rid of my typos =8-9=0 ). /dps > On Sunday, 3 December

[web2py] UnicodeDecodeError with mssql3 in nvarchar field

2017-12-03 Thread Tim Richardson
I have a unicode string retrieved via a query from a different database on the same Windows Server (MS SQL 2008) . It is a name with an accent. At the time I process it, it is an intermediate variable with type unicode. When I try to save it to an nvarchar column, I get an error File

[web2py] Re: Virtual field error :'FieldVirtual' object has no attribute 'listable' in 2.16.1

2017-12-03 Thread domezzzz
Dear Massimo reference to this same problem: https://github.com/web2py/web2py/issues/1815 I replaced gluon source with tester version. Give the same error Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Virtual field error :'FieldVirtual' object has no attribute 'listable' in 2.16.1

2017-12-03 Thread icodk
Still get the same error (only replaced the objects.py file) As before the error shows up if I list the virtual field in the fields parameter. If fields=None then no error, but all fields are shown. Another isue (might be related) is if you have a compute field, and edit a record you can't

[web2py] Help with icons

2017-12-03 Thread Massimo Di Pierro
In the old days of BS2 we used "icon icon-{name}" for icons. then to support BS3 we also added "glyphicon glyphicon-{name}". now we use BS4 and there are no more icons we have to use Font Awesome so we should add "fa fa-{name}". I can easily add this to sqlhtml.py and we will all be fine but

[web2py] Re: No-dropdown widget?

2017-12-03 Thread Massimo Di Pierro
instead of (the default) requires=IS_IN_DB(db, table) do requires=[IS_IN_DB(db, table)] On Sunday, 3 December 2017 03:53:41 UTC-6, Dave S wrote: > > I defined a new table, where a field is a list reference to another > table. Going into admin to populate the table's first few

[web2py] Re: Virtual field error :'FieldVirtual' object has no attribute 'listable' in 2.16.1

2017-12-03 Thread Massimo Di Pierro
I just fixed this in the master branch of pydal. Can you please confirm it is fixed for you? On Saturday, 2 December 2017 18:26:12 UTC-6, icodk wrote: > > Virtual field definition generate error in > 2.16.1-stable+timestamp.2017.11.14.05.54.25 > Works fine in 2.14.06 > my field definition is:

[web2py] Re: menu li > a padding in case of button

2017-12-03 Thread Paolo Caruccio
To remove it, you could try following css rules in an external css file loaded after bootstrap css files .web2py-menu span.btn{padding:0;} Il giorno sabato 2 dicembre 2017 18:47:55 UTC+1, Annet ha scritto: > > I have the following menu: > > response.application_menu = [ >

[web2py] Re: cool tool to browse sqlite database

2017-12-03 Thread Gerd
I prefer https://dbeaver.jkiss.org/download/ best regards Gerd Am Sonntag, 3. Dezember 2017 12:10:28 UTC+1 schrieb Pbop: > > http://sqlitebrowser.org/ > > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] DAL write permission error

2017-12-03 Thread Pbop
On windows in command prompt, running latest version of web2py When on any directory other than web2py\applications\\databases, this works fine: db = gluon.DAL('sqlite://storage.sqlite') and creates a new database or connects to an existing database. When I go db =

[web2py] cool tool to browse sqlite database

2017-12-03 Thread Pbop
http://sqlitebrowser.org/ -- 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] No-dropdown widget?

2017-12-03 Thread Dave S
I defined a new table, where a field is a list reference to another table. Going into admin to populate the table's first few entries, the field with the references has a huge dropdown (thousands!) What widget should I specify to not get a dropdown in admin; I probably also don't want a