December 6th, 2011 |
by admin |
published in
Programming, Web Development
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)) […]
December 2nd, 2011 |
by admin |
published in
Web Development
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 […]
July 25th, 2010 |
by admin |
published in
Programming, technology, Web Development
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 […]
July 25th, 2010 |
by admin |
published in
Programming, technology, Web Development
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 […]
September 27th, 2009 |
by admin |
published in
Web Development, Web Hosting
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, […]
May 3rd, 2009 |
by admin |
published in
technology, Web Development
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: […]
April 10th, 2009 |
by admin |
published in
Programming, technology, Web Development
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 […]
April 10th, 2009 |
by admin |
published in
technology, Web Development
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. […]
December 23rd, 2008 |
by admin |
published in
Web Development
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 […]
September 30th, 2000 |
by admin |
published in
Halifax, Internet, Internet Marketing, Programming, SEO, sitemap, Skateboarding, technology, travel, Web Development, Web Hosting, wedding
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 […]