Dick Henderson

Designer ~ Philosopher ~ Poet

Category: Programming (page 1 of 2)

Datepicker

One of my favorite widgets is the Datepicker in JQuery UI.

Simple Syntax and you have a pop calendar to keep your users out of trouble:


  $( function() {
    $( "#CapCase_ClosureDate" ).datepicker();
  });

And there are many other useful widgets in JQuery UI

From Wikipedia, the free encyclopedia

“jQuery UI is a collection of GUI widgets, animated visual effects, and themes implemented with jQuery (a JavaScript library), Cascading Style Sheets, and HTML.[5] According to JavaScript analytics service, Libscore, jQuery UI is used on over 197,000 of the top one million websites, making it the second most popular JavaScript library.”

Soundex

From United States Census Bureau

“The Soundex is a coded surname index (using the first letter of the last name and three digits) based on the way a name sounds rather than the way it’s spelled. Surnames that sound the same but are spelled differently – such as Smith and Smyth – have the same code and are filed together. This system was developed to make it easier to find a particular name even though it may have been spelled (or misspelled, as was more often the case) a variety of ways.”

“The decennial census Soundex system began as a project of the Franklin D. Roosevelt Administration’s Works Progress Administration (WPA). Because many states did not have uniform systems for registering births, the Soundex indexes were originally prepared to assist the Census Bureau in finding records for people who needed official proof of age.”

SQL Server has two Soundex related functions.

  • SOUNDEX(String)  returns a four character soundex string
  • DIFFERENCE (StringA, StringB) returns a ranking  0 to 4 with 4 being a perfect soundex match.

Here is an excellent post on this subject:

Do You Know Soundex Functions

Life is Guid

“Each GUID is like a beautiful snowflake: every one a unique item waiting to be born.”

Those are the most beautiful words I have ever know anyone to write about a data type.  I bet no has ever had that passion for an Integer.

The words come from an excellent post on CodingHorror.com

Primary Keys: IDs versus GUIDs

and by the way . . .

A DotNet Framework GUID is a sql  UNIQUEIDENTIFIER.  

Thanks again Microsoft.

 

 

Data Type Mapping

SQL Server and the .NET Framework are based on different type systems.”

I am still thinking about that dime I lost using sql REAL data type.

Sql REAL is equivalent to a DotNet Frame work single.

Sql FLOAT is equivalent to a DotNet Frame work double.

Why did they do this?

Here is a complete list:

SQL Server Data Type  Mappings

 

Modern Jackass

Modern Jackass is a term coined on the radio show This American Life.  It’s worth a listen.

“The thing about Modern Jackass is, it’s usually not something about which you know nothing. It’s something about which you know a little bit, enough to sort of get yourself into trouble.”

As a web developer working in the Microsoft stack, I  design SQL schema, write stored procedures in T-SQL, design web sites in ASP.Net and ASP.Net MVC using Visual Basic and C#.  I need to be proficient in HTML, JavaScript,  VBScript, JQuery, JQuery UI an CSS.  I design reports with Crystal Reports and SSRS.

Confession Time

I have not mastered any of the technologies listed above.  I know a little bit about them all.

I am a Modern Jackass Certified Developer.

Older posts

© 2019 Dick Henderson

Theme by Anders NorenUp ↑