After finally upgrading my web2py apps to version 2.22.3 (from a very old
2016 version) I've discovered a change in how the DAL is dealing with empty
data fields. Previously empty fields displayed as blank in table views.
Now, they still appear blank, EXCEPT in NEW or UPDATED records, in which
all blank fields now display "None" in table views. This is true of my
views as well as appadmin.html.
When viewing the record in forms, the empty fields are still blank, so I
assume this is just an issue of how DAL retrieves data. I have scoured the
forum and the book, but have not found a specific reference to what needs
to be fixed, and where--in the db definition, default.py defs, or in views?
For further clarification, my db is SQLITE and my fields are defined with
only name and type (string) attributes, so all other attributes have
default settings. I have tried messing with adding attributes such as
"required=False" or "default=''' ", both in db.define_table and in db.table.
field.extra = {}, to no avail. I am definitely over my head here.
This is an expanded version of a post I made yesterday that never appeared,
so if there is post-vetting purgatory or something I apologize for the
repost.
Thanks in advance for any suggestions.
Rick
--
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/2e37428f-2010-4141-8866-7be70d087a8en%40googlegroups.com.
