Bill MacKenty

 
 
 
 

MYSQL: changing a field type to longtext

Posted in HOWTO general computing Personal on 03 - December 2010 at 11:33 AM (12 years ago) 11 views.

Note to self: To change a mysql filedtype from mediumtext to longtext simply type: ALTER TABLE exp_templates CHANGE template_data template_data longtext; This will change the field "template_data" in the table "exp_templates" to longtext. Hope this helps someone.


HOWTO: reset lamp hours for a 600i series 2 unfi 45

Posted in Blogging HOWTO general computing on 23 - September 2009 at 06:11 PM (13 years ago) 13 views.

To reset the lamp timer on a UNFI 45 (source here). 1. Press the power button on the ECP or remote twice to put the projector back into Standby mode. The power button light on the ECP turns solid amber when the projector is in Standby. 2. Press and hold the up button on the remote control for approximately 10 seconds. When the projector beeps, press and hold the down button on the remote control for approximately 10 seconds. The lamp timer clears after another beep. 3. Press the power button on the ECP or remote to start up the system. The power button light on the ECP turns solid green when the system starts. 4. To confirm that the lamp timer has been reset, press the MENU button on the remote control. Scroll to the Status Display menu heading, and then confirm that 0 h appears in the Lamp timer field. Your lamp reset count has increased by one. 5. Wait five minutes for the projector lamp to warm up. 6. After confirming that the lamp timer has been reset, put the system in Standby mode by pressing the power button twice on the ECP or remote. The power button light on the ECP turns solid amber when the system is in Standby. 7. Wait for the system to enter Standby mode, turn off the projector’s master power switch to shut off the system, and then turn on the projector’s master power switch. 8. When you are ready to use the system, press the power button on the ECP to start up the system. 9. get out bottle of something strong 10. Drink until pain goes away.


HOWTO: turn a normal name into a username with excel

Posted in HOWTO general computing office on 03 - September 2009 at 12:01 AM (13 years ago) 15 views.

How do I take a list of first names and last names and turn it into a username? The answer is here: HOWTO_turn_a_normal_name_into_a_username_with_Excel.pdf


Office: how to password protect an office document

Posted in HOWTO general computing office on 16 - August 2007 at 06:00 PM (15 years ago) 13 views.

How_to_protect_your_office_documents.pdf


Windows HOWTO: Using Acrobat Reader for new users

Posted in HOWTO general computing on 19 - July 2006 at 09:09 PM (16 years ago) 11 views.

This small pdf is a guide for new users to use acrobat reader. It covers zooming and selecting text.


Windows HOWTO: Creating filters in Eudora

Posted in HOWTO general computing on 06 - July 2006 at 07:59 PM (16 years ago) 12 views.

This pdf is a short guide for new users to create a filter in Eudora. There is also a short section to help newer users set out of office messages (vaction messages). Enjoy!


Windows HOWTO: introduction to Windows

Posted in HOWTO general computing on 21 - June 2006 at 09:34 PM (16 years ago) 11 views.

This small PDF is an extraordinarily simple guide for getting started with Windows. It is targeted for novice users with little to no experience using Windows.