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

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...
- - - - -

Grand Unified Snippet

Icon 1 Comments
When I first encountered Sublime Text, a few years ago now, I was first attracted to the look of it, then by multi-line editing, but mainly by the possibility of using it as a vehicle to extend my knowledge of Python. Python is the main language behind its plug-in architecture. On further investigation I noticed that regex...

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