A for loop within a for loop in MS-DOS
A quick note for myself as I'd forgotten how to do this (we're talking technology belonging to the 90s - MS-DOS v6.22). The example wants to loop through a directory and then loop through the line it finds.
Knowledge base / Since 1999
Scripts, systems & field notes.
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
Advanced search638 entries
Compare two databases using T-SQL
A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without having to download any third-party products.
MySQL: Find all non-alphanumeric rows
Quick note on how to do this. I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? -- return all records that contain non-alphanumeric characters SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9]+$'...
htaccess Rewrites SEF URL and submits to PHP
A quick note on a htaccess rewrite rule I'm liking. What does it do? What I type: http://www.mywebsite.com/blog/videos.html Sends this to server: http://www.mywebsite.com/index.php?myFolder=blog&myFiles=videos How?
Split a row into multiple rows based on a column value
This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table.
SQL: Use CASE for Relevance column
So this is a quick note to myself as I was playing with the relevance heuristics of a query. This example adds a column of relevance and sorts the rows accordingly. How? This has to be a real quick one for a dropdown search field which has to find relevant terms to autofill/autocomplete a search form: -- where @ThisSea...
Modifying columns in a table
This is an article to remind me how to modify a column in a database table the old fashioned way (as in stop making me use GUI interfaces so poorly programmed when even I've made better DBMS tools). All SQL -- Add a column to an existing table (giving it datatype char(2) and allowing NULL) ALTER TABLE myTable ADD myCol...
Reorder Columns in a Table
Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns Method: phpMyAdmin So in the phpMyAdmin interface, apparently, you can d...
Autohotkey Count Number of Files/Folders in a Directory
So this is an article to list methods of retrieving the number of files in a folder/directory.
Loading more notes...
No more notes to load.