SP1 Checkboxes

[Derek Martin]

Hi there - I have a form that has some check boxes that when saved (or
submitted), the form goes to a SharePoint folder. Sparing the details, all
of the fields must have a value when saved (or submitted). In SP1, there is
an option in the checkbox properties to set Values When Checked and Values
When Cleared. I have those set to 'yes' and 'no' respectively. However,
when sending the form up, the value 'no' isn't being given to unchecked
checkboxes, their value is NULL.

Help!
Thanks,

Derek

 

[Brian Teutsch [MSFT]]

Derek,

It's possible the forms that you're sending don't have that value in the XML
at all. If you think you have a form template that outputs XML without the
"No" value, feel free to post it up and we'll take a look.

Thanks,
Brian

 

[Derek Martin]

Hi Brian, my post in this NG today with Subject Using Code to Avoid DB.NULL
is the same issue. I discovered that when the form loads, the checkbox
states are intermediate, which if posted without at least clicking once on
them send NULL up to sharepoint. Dunno if that is a bug or a feature
Any ideas how to code behind it to eliminate the db.null?

Thanks!

Derek

 

[Brian Teutsch [MSFT]]

Generically speaking, your checkboxes really should always have a value. I'm
surprised that you had a situation where you ended up with an XML file that
had the element, but without any content. The likely cause for that is that
you added the XML Node after the fact, and the XML didn't get added to old
files.

Brian