Snipplr - lance http://snipplr.com/users/lance Recent snippets posted on Snipplr.com en-us Wed, 22 May 2013 20:04:50 GMT (C#) Change person's name to upper and lower http://snipplr.com/view/66234/change-persons-name-to-upper-and-lower/ Makes first letter upper and the rest lower except for names like Mcsomething

]]> Fri, 20 Jul 2012 05:28:04 GMT http://snipplr.com/view/66234/change-persons-name-to-upper-and-lower/ (Regular Expression) Regular expression for smalldatetime in SQL http://snipplr.com/view/64819/regular-expression-for-smalldatetime-in-sql/ This only constraint here for smalldatetime is the year which allows 1900-2079. This does allow normal months and days so you could go outside the smalldatetime since that allows only 1/1/1900-6/6/2079.

]]> Tue, 08 May 2012 23:05:30 GMT http://snipplr.com/view/64819/regular-expression-for-smalldatetime-in-sql/ (jQuery) JQuery autocomplete with custom display and fill form http://snipplr.com/view/60229/jquery-autocomplete-with-custom-display-and-fill-form/ Only display the name in the search box but get the ID of the record and place it in a hidden field. When select is fired then fill form fields including the hidden field.

]]> Thu, 27 Oct 2011 03:57:07 GMT http://snipplr.com/view/60229/jquery-autocomplete-with-custom-display-and-fill-form/ (JavaScript) Fill 4 digit year from 2 digits http://snipplr.com/view/49477/fill-4-digit-year-from-2-digits/ Add either 19 or 20 depending on the current year + 10

]]> Wed, 23 Feb 2011 08:18:41 GMT http://snipplr.com/view/49477/fill-4-digit-year-from-2-digits/ (C#) Encrypt connectionstrings in app.config http://snipplr.com/view/48363/encrypt-connectionstrings-in-appconfig/

]]> Fri, 04 Feb 2011 03:12:24 GMT http://snipplr.com/view/48363/encrypt-connectionstrings-in-appconfig/ (C#) Get logged in user from Active Directory and then get some of their AD attributes http://snipplr.com/view/48324/get-logged-in-user-from-active-directory-and-then-get-some-of-their-ad-attributes/

]]> Thu, 03 Feb 2011 10:00:49 GMT http://snipplr.com/view/48324/get-logged-in-user-from-active-directory-and-then-get-some-of-their-ad-attributes/ (C#) Screen scrape to get HTML page from client and send to database as binary-return again http://snipplr.com/view/48323/screen-scrape-to-get-html-page-from-client-and-send-to-database-as-binaryreturn-again/

]]> Thu, 03 Feb 2011 09:46:21 GMT http://snipplr.com/view/48323/screen-scrape-to-get-html-page-from-client-and-send-to-database-as-binaryreturn-again/ (JavaScript) TinyMCE configuration for rich textbox http://snipplr.com/view/48322/tinymce-configuration-for-rich-textbox/

]]> Thu, 03 Feb 2011 09:37:41 GMT http://snipplr.com/view/48322/tinymce-configuration-for-rich-textbox/ (Visual Basic) LDAP query to find all users without an entry in the webpage field in Active Directory http://snipplr.com/view/48318/ldap-query-to-find-all-users-without-an-entry-in-the-webpage-field-in-active-directory/

]]> Thu, 03 Feb 2011 06:55:47 GMT http://snipplr.com/view/48318/ldap-query-to-find-all-users-without-an-entry-in-the-webpage-field-in-active-directory/ (C#) Gridview Edit http://snipplr.com/view/43065/gridview-edit/

]]> Thu, 28 Oct 2010 00:41:00 GMT http://snipplr.com/view/43065/gridview-edit/ (SQL) Fix broken username after database attach http://snipplr.com/view/38496/fix-broken-username-after-database-attach/ Sometimes the first set of parameters don't work so then use the second

]]> Thu, 05 Aug 2010 05:52:28 GMT http://snipplr.com/view/38496/fix-broken-username-after-database-attach/ (SQL) Create audit fields in table and create triggers to insert and update them http://snipplr.com/view/38495/create-audit-fields-in-table-and-create-triggers-to-insert-and-update-them/

]]> Thu, 05 Aug 2010 05:50:27 GMT http://snipplr.com/view/38495/create-audit-fields-in-table-and-create-triggers-to-insert-and-update-them/ (SQL) Update one table from another using join http://snipplr.com/view/38494/update-one-table-from-another-using-join/

]]> Thu, 05 Aug 2010 05:43:36 GMT http://snipplr.com/view/38494/update-one-table-from-another-using-join/ (SQL) Find duplicate records in table http://snipplr.com/view/38493/find-duplicate-records-in-table/

]]> Thu, 05 Aug 2010 05:39:08 GMT http://snipplr.com/view/38493/find-duplicate-records-in-table/ (SQL) Find tables in database with specified text in name http://snipplr.com/view/38492/find-tables-in-database-with-specified-text-in-name/

]]> Thu, 05 Aug 2010 05:36:16 GMT http://snipplr.com/view/38492/find-tables-in-database-with-specified-text-in-name/ (SQL) List all tables and fields in database http://snipplr.com/view/38491/list-all-tables-and-fields-in-database/

]]> Thu, 05 Aug 2010 05:34:50 GMT http://snipplr.com/view/38491/list-all-tables-and-fields-in-database/ (SQL) Find Stored Procedures with specified name or contains specified text http://snipplr.com/view/38489/find-stored-procedures-with-specified-name-or-contains-specified-text/

]]> Thu, 05 Aug 2010 05:31:48 GMT http://snipplr.com/view/38489/find-stored-procedures-with-specified-name-or-contains-specified-text/ (JavaScript) Remember div scroll position using javascript and ASP.Net http://snipplr.com/view/38463/remember-div-scroll-position-using-javascript-and-aspnet/

]]> Thu, 05 Aug 2010 00:57:00 GMT http://snipplr.com/view/38463/remember-div-scroll-position-using-javascript-and-aspnet/