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.
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 search608 entries
T-SQL concatenate an incremental row number
This is a quick article on how to use a counter added to the end of a field column of data. Eh. What? Assume the following two tables exist:
Trim in T-SQL and SSIS
Some methods of removing trailing spaces, tabs, carriage returns and line feeds (new lines). How? First in Transact-SQL:
T-SQL Conversion failed when converting the varchar to data type int
A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How?
Things to Check if Joomla Password Reminder email not being sent
A quick article on a frequent question I get asked. This refers to an issue within the Joomla CMS (version 2.5.x) where it fails to email users who reset their password. How? A few things to check:
Improve Default Joomla Search
So I can't stand the way the default "Search" component in Joomla works. The default is to sort the results by popularity (hits) or by most recently added (depending on your version) which I have never seen in any other system. I've googled and binged but could not find anything that documents how to bring it into line...
SSIS Skip Blank Rows in Flat File Source
This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation failed. Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "MyDerivedColumns" (4228)" failed because...
MS Excel - Sort pivottable column headings by date
This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top.
Change the default Joomla Error template
This is a quick article on what I change the error page for Joomla websites to. I like a clean error page, for a demo visit http://www.joellipman.com/my_error_page. Applies to Joomla 1.6.x, 1.7.x, 2.5.x How? Backup the file \templates\system\error.php Create a replacement file called error.php including the below code...
Loading more notes...
No more notes to load.