Friday, January 29, 2021

Upgrading to MySQL 8: rank

 Rank is a reserved keyword in MySQL 8. Before upgrading, make sure it's not a table name, column, or alias used in a query.

Monday, October 19, 2020

Toyota Microphone Not Working

Do you have a recent model Toyota with Entune? Did your microphone and/or wifi suddenly stop working? The wifi app doesn't work. You can make and receive calls and can hear the other party but they can't hear you. Voice commands don't work anymore.

The issue is likely the DCM. You can verify it by looking at the display and seeing the DCM greyed out even when bluetooth is connected. Also, the SOS in the ceiling doesn't have a green light.

The fix is simple. Open the hood. Open the fuse box on the right. Pull out and put back the DCM fuse.



Sunday, May 26, 2019

Facebook Community Standards

Things which violate Facebook Community Standards:
  • Calling MS-13 untermenschen
  • Calling BDS supports white trash
Things which don't violate Facebook Community Standards:
  • Saying that Israeli agents planted bombs in Twin Towers
  • Comparing IDF to Nazis
  • Saying that pedophilia is part of Ashkenazi Jews' culture
  • Calling all Jews murderers
  • Saying that Jews control the media, courts, banks, wars, cancer industry, etc.
  • Claim that Jews murder children for blood
  • Calls for Muslims to unite and murder Jews

Thursday, December 27, 2018

ColdFusion - using a colon in sql with queryexecute

queryexecute doesn't seem to allow escaping colons in sql.
Using MySQL regexp character classes will throw an error if entered in the sql directly.
A workaround is to add the regex expression as a queryparam.

The following will throw an error:
queryexecute("SELECT [column] REGEXP '[[:character-class:]]'...");

Here's the workaround:
queryexecute("SELECT [column] REGEXP :regex...",{regex:{value:"'[[:character-class:]]'"}});

Monday, August 7, 2017

Child unfriendly

The Metropolitan Museum of Art
"Water in plastic bottles may be brought into the Museum. Other food or drink is not allowed and may not be checked at the coat checks."

National Museum of the American Indian
"There are no facilities for eating in the museum. Food may not be consumed in the museum."
Entry and re-entry involves x-ray and search of bags and backpacks, going through a metal detector, and removal anything metal, including belts.

Thursday, May 11, 2017

Say what?!

Some people have bad grammar and some people can't spell and some people put random words together and call it a sentence.
Considering the people I deal with, this will be an ever growing list.
  • The members only Navigation Bar is the have a link Members only login screen
  • Ok what is the best way to have a "modom" I need something that works
  • Also is out site open 2 links
  • Is their a way to stop people from tapping us
  • also I need to add up where you adding up a payment how add it up because sometimes a different person add the $ and different person add up the job
  • NEW!!!
    Come books: 1-st time translate to Russian the classical Musar book
    "Madrigat adam" (mans level) of Saba miSlobodka.
    "Even Shlema" (Whole stoun) of Vilna Goen (with detailing biography of Goen).
    Lectures of Rav Haim Burshteyn, chief Rabi of Lita, to Sefer Daniel ant to Sefer Irmiyagu.
  • My Outlook storage is full. Can you clear my cache and archive my ##### folder somewhere I can still access them?

Thursday, February 23, 2017

Converting from 1 column name to first / middle / last.

First name: SUBSTRING_INDEX(name,' ',1)
Last name: SUBSTRING_INDEX(name,' ',-1)
Middle Name: TRIM(REPLACE(REPLACE(name,SUBSTRING_INDEX(name,' ',1),''),SUBSTRING_INDEX(name,' ',-1),''))