SQL – How to format decimal to space delimited currency $ 1 234 567.89
The following SQL statement shows how to take a decimal value, e.g. 1234567.89 and convert it to a space delimited currency - that is, instead of using commas to separate…
Trim
SQL – How to remove spaces before and after database values
The following SQL can be used to remove leading and trailing spaces from a columns values. Ideally the system that is feeding the data into the database should be doing…
WordPress – How to serve resources without http or https (protocol relative url)
By default WordPress will use a full absolute URL for resources such as images, scripts and style sheets. If the resource is loaded correctly WordPress will automatically use the scheme…
Gravity Forms – How to count characters without spaces
Gravity Forms uses a jQuery character count plugin called 'jQuery Textarea Characters Counter Plugin v 2.0' to handle the character counting and associated functions for form fields. The plugin lives…
jQuery – How to automatically create heading anchors for links
The following jQuery can be used to automatically create anchor tags for each of the headings on a web page. This will allow you to create links directly to each…
Free Barcode Labels for Ultrium LTO Backup Libraries
The following website can be used to generate barcode tape labels for Ultrium LTO backup libraries. It supports various media types, such as LTO3, LTO4, and LTO5 and can be…
Trim 7 – Enable Outlook Integration
The following steps can be followed to enable the Trim 7 options inside of Outlook 2010. It requires you to have Trim 7 already installed and configured to connect to…
Using ASP to connect to an Access Database
The following ASP script was used to pull information out of an Access database and publish it to a web page. IIS 7.0 was used as the web server application.…