RetainSameConnection interferes with expressions on connection managers

I have ran into this issue a few times and was planning to document it for others but John Welch summed it up nicely.

"If you have RetainSameConnection set to TRUE, and you are also trying to update the connection string through an expression, be aware the connection will not change to reflect the new connection string. Basically, the connection will retain the original value (as RetainSameConnection would indicate)."

http://agilebi.com/jwelch/2008/03/28/retainsameconnection-and-expressions/

http://connect.microsoft.com/SQLServer/feedback/details/334933/retainsameconnection-interfers-with-expressions-on-connection-managers

jQuery remove disabled attribute

I recently upgraded from jQuery 1.5.1 to 1.6.2. This upgrade affected code I have been using to enable or disable an element (such as a button).

Original Code

// disable

$("#btnSubmit").attr('disabled', 'disabled');

// enable

$("#btnSubmit").attr('disabled', '');

The above code worked in all major browsers until I upgraded to jQuery 1.6.2; however, after upgrading the element would not re-enable again by simply setting the disabled attribute to an empty string.

Solution

// disable

$("#btnSubmit").attr('disabled', 'disabled');

// enable

$("#btnSubmit").removeAttr('disabled');

Alternate Solution

// disable

$("#btnSubmit").attr('disabled', true);

// enable

$("#btnSubmit").attr('disabled', false);

I chose to go with the removeAttr solution since that seems more likely to eliminate differences from one browser to the next.

jQuery Drop Down Menu

I started using a jQuery menu recently from Apycom.

Features

• Full cross-browser compatibility
• Fully accessible even when javascript is turned off, as a pure css menu
• Search engines optimized
• Clear unordered list (LI and UL HTML tags) structure
• Easy to setup and update
• Fantastic animation and transition effects
• Multiple pre-desinded color schemes
• Completely customizable styling with CSS
• Powered by jQuery
• Extremely small - 3kb uncompressed

http://apycom.com/

jQuery Dropdown Check List

I came across the jQuery Dropdown Check List plugin today when I was looking for an easy way to transform a select list into a dropdown checkbox list.

For me it was the best option because it's easy to setup, contains several customizations, cross browser compatible and powered by jQuery.

http://code.google.com/p/dropdown-check-list/