In our work we migrate from version of Web2py from 1.96.4 to 1.99.7, but we
have the following problem: SQLFORM not print the ID values less and
equal than zero, the referenced table (ex. table "a"). any security reason for
this change?
# controller: debug.py
def index():
db.define_table('a',
Field('namea'),
format='%(namea)s'
)
db.define_table('b',
Field('nameb'),
Field('a_id',db.a)
)
form = SQLFORM(db.b)
return dict(form=form)
#table "a" contains
ALTER SEQUENCE a_id_seq MINVALUE 0; # we need zero in the table, and we
need to show in the form. its run in w2p 1.96, but not in 1.99
INSERT INTO a (id, namea) VALUES (0, 'a_0');
INSERT INTO a (id, namea) VALUES (1, 'a_1');
INSERT INTO a (id, namea) VALUES (2, 'a_2');
INSERT INTO a (id, namea) VALUES (3, 'a_3');
INSERT INTO a (id, namea) VALUES (4, 'a_4');
INSERT INTO a (id, namea) VALUES (5, 'a_5');
#The SELECT VIEW no print a_0 option, and if torce it, the validator print
the error VALUE NO IN DATABASE
select id="b_a_id" class="generic-widget" name="a_id">
<option value=""></option>
<option value="1">a_1</option>
<option value="2">a_2</option>
<option value="3">a_3</option>
<option value="4">a_4</option>
<option value="5">a_5</option>
</select>