Category Archives: Technology

Scanning QR Codes on Android without an App

Posted on August 8, 2020 by thomas

My Samsung smartphone won’t scan a QR Code straight from the camera. I found the following instructions and they seem to work:

Posted in Technology | Tagged , | Leave a comment

Dumping a SQL query into a CSV file in MySQL

Posted on August 1, 2018 by thomas

Yet another note to myself… SELECT order_id,product_name,qty FROM orders INTO OUTFILE ‘/tmp/orders.csv’ FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’ Credit to http://www.tech-recipes.com/rx/1475/save-mysql-query-results-into-a-text-or-csv-file/ (Since this apparently doesn’t work with one of the versions of MySQL I use, … Continue reading →

Posted in Technology | Tagged | Leave a comment

MS Office 2010 – Grammar Check Fail

Posted on November 8, 2011 by thomas

Upgraded to Microsoft Office 2010 over the weekend at work. Unfortunately, it seems to have trouble telling the difference between “it is” and “it belongs to.” Update: One day later and we’re still having troubles – this time in MS … Continue reading →

Posted in Technology | Tagged , , | Leave a comment

MS Windows Batch Files – Doing Something to Each File in a Directory

Posted on May 13, 2011 by thomas

Again, a note primarily for my reference… To process each file in a directory using a batch file, the syntax would be for %%f in (*.txt) do type %%f From the command line it would be for %f in (*.txt) … Continue reading →

Posted in Technology | Tagged , | Leave a comment

Moving to a Different Cell in an Excel Macro, Relatively Speaking

Posted on April 14, 2011 by thomas

Primarily a note to myself, but… … in Microsoft Excel, the Macro Recorder defaults to storing an absolute cell address when recording a macro.  I seem to typically want a relative address, such as “three cells to the left.”  I … Continue reading →

Posted in Technology | Tagged , , | Leave a comment