baxleys.org » nate

Code that will search Triggers, Stored Procs, and Functions in MS SQL Server

A good way to look for particular arguments passed on the command line to a PHP script.

I get really frustrated with Moodle for using int fields to store dates. They store it in the Unix (Epoch) format. Here's how to make it more readable.

How to call the constructor of a parent class in the child.

When you are returning longer text, like from a varchar(MAX) or such you get weird characters at the end.

This article gives instructions on what to look for and how to determine which pages are vulnerable

Some quick notes on handling checkboxes (and probably radio buttons, but I haven't tested that).

Search and replace all occurances of a string in all tables in a database. From http://vyaskn.tripod.com/ --To replace all occurences of 'America' with 'USA': EXEC SearchAndReplace 'America', 'USA' GO

Search all text fields across all tables in a database.  Taken from http://vyaskn.tripod.com/ --To search all columns of all tables in Pubs database for the keyword "Computer" EXEC SearchAllTables 'Computer' GO

It may be simple, but this SQL will order items numerically (1,2,3,10,20) instead of alpha (1,10,2,20,3).