SQL Tutorial: Easily Update Rows Based on Complex Joins
There are a lot of times I’d like to update hundreds of rows in a database based on a complex set of conditions. In doing a traditional update SQL statement there is no way...
Headlines Blog
MySQL FIX: connect to server at ‘localhost’ failed error: ‘Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
In short the error means that mysql isn’t running. So the next reason is, why? Recently I upgraded from php4 to php5 on one of my servers. Ever since then any time mysql does...
MSSQL Tutorial: Search code inside of stored proceedures
DECLARE @SEARCHSTRING VARCHAR(255), @notcontain Varchar(255) SELECT @SEARCHSTRING = ‘expiration_date =’, @notcontain = ” SELECT DISTINCT sysobjects.name AS [Object Name] , case when sysobjects.xtype = ‘P’ then ‘Stored Proc’ when sysobjects.xtype = ‘TF’ then ‘Function’...
Ten Reasons Not To Use ASP!
10. I have to write my own isNull function? 9. No double equals = retarded language 8. You can’t response.write across multiple lines unless you _ & fix them. Can’t concatenate across multiple lines...
Horsetastic!
Introducing a brand new comic on White Oak Stables. Horsetastic is the tale of four friends and the quirks of their day to day lives. The comic is currently on trial basis, and if...
Error FIX: Crystal Report Won’t Stop Loading
Problem: I noticed if you have really large strings in the crystal report, instead of having them as type text (aka memo in Crystal) the report won’t ever stop loading. For instance, a field...
Recent Activity
This week White Oak Stables has had a lot happening. There’s a new help wiki that all members can use to create, edit and modify the game help files. This is a huge improvement...
Dynamic Horse Images
New images are under way for White Oak Stables. These images will be generated dynamically, which means breedings will result in new coat and marking colors. If you have an picture URL up for...
MSSQL Tutorial: Select All Tables & Fields
select table_name, column_name, data_type, character_maximum_length, is_nullable from information_schema.columns where table_name in (select name from sysobjects where xtype=’U’) order by table_name
