Here is some code to do a full outer join on three tables. In the example, the three full outer joins are done on two columns , but it works just the same if you only have a single join column. CREATE TABLE ZA (T CHAR(1), O CHAR(1)) CREATE TABLE ZB (T CHAR(1), O CHAR(1)) […]

Here is an OLD article I had about data caching in classic asp using the application object. When it comes to application performance on your web servers, ever little bit counts. Howto build a database caching system Introduction In this tutorial I will teach you how to build a simple database caching system to improve […]

MYSQL Statements and clauses ALTER DATABASE ALTER TABLE ALTER VIEW ANALYZE TABLE BACKUP TABLE CACHE INDEX CHANGE MASTER TO CHECK TABLE CHECKSUM TABLE COMMIT CREATE DATABASE CREATE INDEX CREATE TABLE CREATE VIEW DELETE DESCRIBE DO DROP DATABASE DROP INDEX DROP TABLE DROP USER DROP VIEW EXPLAIN FLUSH GRANT HANDLER INSERT JOIN KILL LOAD DATA FROM […]

These are some MySql commands (most run at the command line in linux) that I’ve been collecting since getting a few sites set up on linode. The “#” indicates that it is to be run from the unix shell. When you see “mysql>” the command is to be run from the MySQL command prompt after […]

Well, my website was hacked with iframe injections pointing to ageegle dot ru -ageegle.ru- last week (not this site). The hacker added malicious code to my index or default web files that included iframe tags pointing to a site called ageegle dot ru (do not visit that site) on port 80. This page, when visited, […]

If you are looking for a Cross Browser Compatible CSS Opacity code, you need look no further. The following provides 100% opacity (which is the same as 0% transparency.) 1 2 3 4 5 6 7 8 9 10 Body {   …your body css…   -moz-opacity: 1.0 !important; -webkit-opacity: 1.0!important; -ms-filter:"progid:DXImageTransform.Microsoft.Alpha(Opacity=100)" !important; filter: alpha(opacity=100) !important; opacity: […]

I needed a quick vbscript to terminate a specific windows process that seemed to hang. This is the script that will do it. It uses SQL to lookup the process name from the win32_process list, then uses the terminate function to close it. NOTE: this vbs to terminate a windows process was only tested on […]

Here is a simple credit card expiration date regular expression. I wrote my own regexp for the expiration date since one was not easily found on the net. This one validates for allowing the year 2009 to 2029, but could be easily changed…I built this for an ASP.NET programming project for a course I’m taking. […]

Here is a snippet of vbscript I use in ASP and/or VBS applications where I need a select case statement for a range of values for each case. There isn’t too much documentation online about this, and it’s a bit of a hack, but this will do the trick. 1 2 3 4 5 6 […]

Robar's Pages Halifax Where is the Fairview Overpass? Saint Mary's University (SMU) Switches from WebCT to BlackBoard for Online Course Tools Halifax Nova Scotia Campground With Wireless Internet Access Wi-Fi Internet Ripoff Alert – Domain Registry of Canada Scam Improving Adsense CTR in Forum Pages Adsense Ads Allowed on Search on 404 Pages TOS? Adsense […]