Code

Changes between Initial Version and Version 1 of Ticket #10114


Ignore:
Timestamp:
01/23/09 17:01:40 (5 years ago)
Author:
ramiro
Comment:

(reformatted description)

Do these values stored in the database really contain space(s)? How many of them? Or are they empty strings?

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #10114

    • Property Patch needs improvement unset
    • Property Needs tests unset
    • Property Needs documentation unset
  • Ticket #10114 – Description

    initial v1  
    11I have a model in which several fields are specified as follows: 
    22 
     3{{{ 
    34    lat_dec = models.FloatField(blank=True, null=True) 
    45    lon_dec = models.FloatField(blank=True, null=True) 
    56    lat_dms = models.CharField(max_length=9, blank=True, null=True) 
    67    lon_dms = models.CharField(max_length=10, blank=True, null=True) 
     8}}} 
    79 
    810In case of the CharFields, spaces are inserted into the database (PostgreSQL) when in the admin form the entry-fields are left blank. I found that out because I made some trigger procedures which update lat_dec and lon_dec when lat_dms and lon_dms (see model) are specified and vice versa. Now I made a workaround by adjusting the trigger procedure so it sets the fields to NULL when containing only spaces.