Wednesday, April 4, 2012

Error on SharePoint list: Invalid number value...


Got the following error while working on a list with BDC data columns:
Invalid number value.  A number field contains invalid data. Please check the value and try again.
Cause: On the database where the BDC is pulling data from, one of the columns was changed from type of Int32 to a String.  Even though the xml definition file was updated accordingly, this error comes when you try to save the list item after picking a BDC item.

Resolution:  Go to the list settings, click on the BDC column, uncheck the 'problem' column (i.e. the column that changed type), go back and the problem is gone.  You can re-add the column back by checking it.  Refresh.  All the data will be refreshed and no more errors.

Monday, March 19, 2012

Expand the multiselect box in SharePoint

To make the multselect boxes larger, put the following code in a 'content editor web part' and set it to hidden.  Adjust to your own needs.


//**********************************************************************
<script src="http://code.jquery.com/jquery-latest.js"></script>
<script type="text/javascript">
            $(document).ready(function() {                
                        $('.ms-long select').parent('div').css('width', '320');
                        $('.ms-long select').css('font-size', 'xx-small');
                        $('.ms-long select').css('width', '100%');
            });        
</script>
//**********************************************************************