(The following appends 2 previous posts that are still under review:)
So here's additional info on the empty-field issue I'm having after
updating my web2py apps to version 2.22.3. The problem first noticed was
that records containing empty fields,* in NEW or UPDATED records only*,
display "None" in the empty fields, when displayed in my views or in
appadmin.html. Previously empty fields appeared blank, as is preferred.
Existing records still display empty fields as blank.
After examining the data in an SQLite DB browser, I now see that new or
edited records have inserted "NULL" in the empty fields, while old records
still have blanks. I think I read somewhere that this may be related to
Python behavior; my apps are still running on Python 2.7.12.
Another strange behavior I've discovered is that a field containing
"NULL" (and displaying as "None") does not evaluate properly in an
expression such as:
sppa = db(db.specimen.type_status<>('Test')).select(orderby=db.specimen.id)
return dict(sppa=sppa)
In the above example, since a type_status field containing "NULL" is not
equal to "Test", the row should appear in the displayed table---but it does
not appear.
Unfortunately, I am stuck and cannot add or edit any records in my apps
until I get this sorted. Any help would be greatly appreciated.
For context, see the default app at https://specimens.mantodearesearch.com/
Thanks,
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/e4f46a19-fffa-4680-8562-e3a676a1a69cn%40googlegroups.com.
