Arrays and Recordsets in Classic ASP

Arrays and Recordsets in Classic ASP

Classic ASP would appear to be a relic of the bygone past but there are still some of us out there who support websites built on this technology. For those three or four of you left, I thought I would share some AJAX and JSON functionality. But before I get into that,...
A short JSON Primer

A short JSON Primer

One of the things that newcomers to JSON ask is, when do I use hard brackets and when do I use curly braces? Curly braces, “{” and “}”, encapsulate one or more unique key value pairs. Keys are paired to corresponding values with a colon and...
Virtual Credit Cards – A Rebuttal

Virtual Credit Cards – A Rebuttal

I recently read an article explaining why virtual card numbers “aren’t worth it.” The internet is full of awful advice. One of my favorites I came across was from a young lady who stated that you should simplify your life by using the same password...
Case Statement Foiled By Null

Case Statement Foiled By Null

This article applies to Microsoft SQL server. The concept of null can be confusing to programmers and non-coders alike. For databases, the normal understanding as defined by ANSI is null means anything or nothing. It’s literally an undefined value. As such,...
T-SQL Divide-By-Zero

T-SQL Divide-By-Zero

Divide-by-zero errors are one of the first errors new programmers come across. A reasonable fix is to check the denominator and, if it equals zero, provide some useful result as an alternative to running the division operation. In a table you must think in sets of...