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.

Reply via email to