Subscribe to andrewsw's Blog        RSS Feed
* * * * *

Progressive Testing

Icon 5 Comments
We very often have peope post a wall of code with no idea why it isn't working. There are important concerns here about knowing how to test and debug code, and decipher error messages. However, it is even more important for people to understand that they should be running and testing their code at the earliest opportunity, and frequently...
- - - - -

Basic SQL Knowledge

Icon 1 Comments
It surprises me how often we encounter people who do not know how to join two tables together in a single query. People seem to find just enough information to create a table, to define a primary key, and to write a simple SELECT query based on the table. They do not read beyond this basic knowledge.

I suppose we could blame the internet to an...
- - - - -

Find JavaScript Errors in Google Chrome

Icon Leave Comment
In Google Chrome right-click an element (or anything on the page) and choose Inspect Element to access GC's developer tools.

Image reduced in size

You can apparently use Ctrl-Shift-I to do this as well, although I find pressing F12...
- - - - -

VB.NET Get SQL Server INCREMENT Value

Icon Leave Comment
This isn't a tutorial, just a lump of code that I wanted to make available that demonstrates retrieving INCREMENT values for newly inserted SQL Server (Express) records, and displaying them on a WinForm. (There are some links in the code to articles on this subject.)

Of course, you should question whether you need to retrieve, or even...
- - - - -

Post-It Notes in localStorage

Icon Leave Comment
I started to explore this earlier today, a web page to create post-it notes, and then save, and retrieve, them from localStorage. I was going to entitle this blog "..work in progress" but I actually found that I managed to complete everything that I intended to include. (Note: I use jQuery.)

You can press the plus sign to create a new...
- - - - -

Multi-line replace in Sublime Text

Icon Leave Comment
I recently needed to find and replace blocks of code across multiple files. For example, to replace the footer of every HTML page. (Normally I would use PHP includes so that there is only a single footer, in a single file, but I wasn't allowed to do this for this site.)

It took a bit of digging to achieve this in Sublime Text. (Maybe it is...
- - - - -

Excel with Andy: Dynamic Drop-Down

Icon 1 Comments
Using Defined Names (formerly called Range Names) and Data Validation we can create a drop-down list where the list of choices changes according to the value chosen in an adjacent cell. In the screenshot the list of items in the drop-down changes according to whether Fruit or Veg is chosen in the adjacent cell in column A.

Image reduced in size...
- - - - -

Excel with Andy: More Functions

Icon Leave Comment
Most people are familar with Excel's basic statistical functions: SUM, AVERAGE, MAX, MIN, COUNT and possibly COUNTA. I will demonstrate the use of some more functions:

INDIRECT, ADDRESS, ROW, MATCH, OFFSET, COUNTA

Image reduced in size...
- - - - -

RSS Feed in WPF

Icon 1 Comments
I found this cool page to display RSS feed items in WPF:

Build an RSS reader in 5 minutes

It works great. I thought I would see how it behaves with dream.in.code's feed:

http://feeds.feedbur...ured?format=xml

Image reduced in size

Unfortunately it, for me, produces a Script Error dialog several times. My settings in IE are already set to not...
- - - - -

Dipping Into F#

Icon 2 Comments
If you don't have access to a full version of Visual Studio it is now easier to dip your toe into the F# waters, and functional programming, by downloading the free Visual Studio Community 2013 edition...

  • (4 Pages)
  • +
  • 1
  • 2
  • 3
  • Last »

September 2015

S M T W T F S
  1 2 345
6789101112
13141516171819
20212223242526
27282930   

Tags

    Recent Entries

    Recent Comments

    Search My Blog

    1 user(s) viewing

    1 Guests
    0 member(s)
    0 anonymous member(s)

    Categories