I am inserting data into my trusty mysql db using SQLFORM. One of the form
elements is a drop-down list of states. The behavior I wish to happen is to
either insert a |normal|list|of|states| or, if nothing is selected, NULL.
However, when nothing is selected, it is inserting ||, and I can't seem to
do anything to change that. How can I get the NULL behavior I want?
Here's the relevant field definition:
Field('states_active', 'list:string', length=150, default='',
required=False, notnull=False, label='Active States',
requires=IS_IN_SET([('AL', 'Alabama'), ('AK', 'Alaska'), ('AZ',
'Arizona'), ('AR', 'Arkansas'), ('CA', 'California'), ('CO', 'Colorado'),
('CT', 'Connecticut'), ('DE', 'Delaware'), ('FL', 'Florida'), ('GA',
'Georgia'), ('HI', 'Hawaii'), ('ID', 'Idaho'), ('IL', 'Illinois'), ('IN',
'Indiana'), ('IA', 'Iowa'), ('KS', 'Kansas'), ('KY', 'Kentucky'), ('LA',
'Louisiana'), ('ME', 'Maine'), ('MD', 'Maryland'), ('MA', 'Massachusetts'),
('MI', 'Michigan'), ('MN', 'Minnesota'), ('MS', 'Mississippi'), ('MO',
'Missouri'), ('MT', 'Montana'), ('NE', 'Nebraska'), ('NV', 'Nevada'),
('NH', 'New Hampshire'), ('NJ', 'New Jersey'), ('NM', 'New Mexico'), ('NY',
'New York'), ('NC', 'North Carolina'), ('ND', 'North Dakota'), ('OH',
'Ohio'), ('OK', 'Oklahoma'), ('OR', 'Oregon'), ('PA', 'Pennsylvania'),
('RI', 'Rhode Island'), ('SC', 'South Carolina'), ('SD', 'South Dakota'),
('TN', 'Tennessee'), ('TX', 'Texas'), ('UT', 'Utah'), ('VT', 'Vermont'),
('VA', 'Virginia'), ('WA', 'Washington'), ('WV', 'West Virginia'), ('WI',
'Wisconsin'), ('WY', 'Wyoming'), ('DC', 'Washington DC')], multiple=True,
zero='SELECT ACTIVE STATES')
),
>From reading a somewhat-related post on NULL and SQLFORM, I thought I could
get what I want with the advised default='', but it behaves just as it did
when I had set default=None. I tried wrapping the IS_IN_SET() within
IS_EMPTY_OR() and that made no difference also.
1oo space dollars for an answer to preserve the remainder of my hair!!
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
