Geeks With Blogs
Doug.Instance Improving the world one post at a time February 2011 Entries
Sub-Select to Delimited List in T-SQL
The following transact-SQL statement can be used with Microsoft SQL Server to create a delimited list from a sub-query. In this case the delimiter is a comma. SELECT Left(item,LEN(item)-1)as delimited_list FROM ( select CAST ( ( select original_item + ',' from TABLE where condition_field = 'value' for xml path ('') ) as varchar(max) ) as item ) as temp ......

Posted On Wednesday, February 9, 2011 1:06 PM

jQuery "Auto Post-back" Select/Drop-Down List
I have one common piece of jQuery code which I use to submit a form any time the selection changes on a drop-down list (HTML select tag). This is similar to setting AutoPostBack = true in ASP.Net. I use a single CSS class (autoSubmit) to annotate that I want the drop-down to force the form to submit on change so the HTML looks something like this: <select id="myAutoSubmitDropDown" name="myAutoSubmitDropDown" class="autoSubmit"> <option value="1">Option 1</option> <option value="2">Option ......

Posted On Monday, February 7, 2011 5:15 PM

Copyright © Doug Lampe | Powered by: