Pet Peeves - Driving

• People who think stop all way is the same as a stop sign and start crawling out slowly.
• People who double park next to a car with empty space in front and behind the parked car.
• People who drive left to make a right turn even though they're not driving a truck.
• People who buy sports cars and then drive 5 below speed limit.
• People who social distance when parking. Your car doesn't need to be 6' away from other cars, it's not going to catch covid.

Upgrading to ColdFusion 2021

 If you're thinking of upgrading to CF21 and you use cfspreadsheet in your code, don't.

Cfspreadsheet, when doing read, randomly locks files anywhere from minutes to hours. The only way to get rid of the lock if you want to move or delete the file is to restart the main instance even if the file was locked by another instance.

On July 22nd, Adobe said that the issue is fixed in Update 2, but gave no eta from when Update 2 will be released.

https://tracker.adobe.com/#/view/CF-4212149

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.

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.

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

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:]]'"}});

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.

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?

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),''))

Shall not be infringed

1689 English Bill of Rights
7. That the subjects which are Protestants may have arms for their defence suitable to their conditions and as allowed by law

State Constitutions

1776 Pennsylvania Constitution
XIII. That the people have a right to bear arms for the defence of themselves and the state; and as standing armies in the time of peace are dangerous to liberty, they ought not to be kept up; and that the military should be kept under strict subordination to, and governed by, the civil power.

1777 Vermont Constitution
XV. That the people have a right to bear arms for the defence of themselves and the State; and, as standing armies, in the time of peace, are dangerous to liberty, they ought not to be kept up; and that the military should be kept under strict subordination to, and governed by, the civil power.
Constitutional Debates

1787 Pennsylvania Minority
7. That the people have a right to bear arms for the defence of themselves and their own state, or the United States, or for the purpose of killing game; and no law shall be passed for disarming the people or any of them, unless for crimes committed, or real danger of public injury from individuals; and as standing armies in the time of peace are dangerous to liberty, they ought not to be kept up: and that the military shall be kept under strict subordination to and be governed by the civil powers.

1788 Massachusetts Convention
And that the said Constitution be never construed to authorize Congress to infringe the just liberty of the press, or the rights of conscience; or to prevent the people of the United States, who are peaceable citizens, from keeping their own arms.

1788 New Hampshire Convention
Congress shall never disarm any citizen, unless such as are or have been in actual rebellion.

1788 Virginia Convention
17^th. That the people have a right to keep and bear to arms; that a well-regulated militia, composed of the body of the people trained to arms, is the proper, natural and safe defence of a free state; that standing armies, in time of peace, are dangerous to liberty, and therefore ought to be avoided, as far as the circumstances and protection of the community will admit; and that, in all cases, the military should be under strict subordination to, and governed by, the civil power.

1788 New York Convention
That the people have the right to keep and bear arms; that a well-regulated militia, including the body of the people capable of bearing arms, is the proper, natural, and safe defence of a free state.

1790 Rhode Island Convention
XVII. That the people have a right to keep and bear arms; that a well-regulated militia, including the body of the people capable of bearing arms, is the proper, natural, and safe defence of a free state.

Founding Fathers

1776 Thomas Jefferson
No Free man shall ever be debarred the use of arms.

1778 Zachariah Johnson
The people are not to be disarmed of their weapons. They are left in full possession of them.

1787 Noah Webster
Before a standing army can rule, the people must be disarmed; as they are in almost every kingdom in Europe. The supreme power in America cannot enforce unjust laws by the sword; because the whole body of the people are armed, and constitute a force superior to any band of regular troops that can be, on any pretense, raised in the United States. A military force, at the command of Congress, can execute no laws, but such as the people perceive to be just and constitutional; for they will possess the power, and jealousy will instantly inspire the inclination, to resist the execution of a law which appears to them unjust and oppressive.

1787 John Adams
To suppose arms in the hands of citizens, to be used at individual discretion, except in private self-defense, or by partial orders of towns, countries or districts of a state, is to demolish every constitution, and lay the laws prostrate, so that liberty can be enjoyed by no man; it is a dissolution of the government. The fundamental law of the militia is, that it be created, directed and commanded by the laws, and ever for the support of the laws.

1788 Richard Henry Lee
To preserve liberty, it is essential that the whole body of people always possess arms, and be taught alike, especially when young, how to use them

1788 Samuel Adams
And that the said Constitution be never construed to authorize Congress to infringe the just liberty of the press, or the rights of conscience; or to prevent the people of the United States, who are peaceable citizens, from keeping their own arms; or to raise standing armies, unless necessary for the defense of the United States, or of some one or more of them; or to prevent the people from petitioning, in a peaceable and orderly manner, the federal legislature, for a redress of grievances; or to subject the people to unreasonable searches and seizures of their persons, papers or possessions.

1788 Patrick Henry
Are we at last brought to such humiliating and debasing degradation, that we cannot be trusted with arms for our defense? Where is the difference between having our arms in possession and under our direction, and having them under the management of Congress? If our defense be the real object of having those arms, in whose hands can they be trusted with more propriety, or equal safety to us, as in our own hands?

1789 Tench Coxe
As civil rulers, not having their duty to the people before them, may attempt to tyrannize, and as the military forces which must be occasionally raised to defend our country, might pervert their power to the injury of their fellow citizens, the people are confirmed by the article in their right to keep and bear their private arms.

1805 Patrick Henry
The great object is, that every man be armed ... Every one who is able may have a gun.

1829 William Rawle
The prohibition is general. No clause in the Constitution could by any rule of construction be conceived to give to Congress a power to disarm the people. Such a flagitious attempt could only be made under some general pretense by a state legislature. But if in any blind pursuit of inordinate power, either should attempt it, this amendment may be appealed to as a restraint on both.

Federalist Papers 46
Besides the advantage of being armed, which the Americans possess over the people of almost every other nation, the existence of subordinate governments, to which the people are attached, and by which the militia officers are appointed, forms a barrier against the enterprises of ambition, more insurmountable than any which a simple government of any form can admit of.

Star Wars Galaxy of Heroes - 7 Star Yoda

There are forum posts about getting 7* Yoda by using Barriss' health drop exploit. Tried it several times and it didn't help at all. Maybe works for whales with a better Jedi team, but didn't work for me with my free one.

Here's what worked. Yoda was with Jedi Consular and Jedi Knight Guardian. My team was Barriss leading Qui-Gon Jinn, Luminara, Jedi Consular, and Eeth Koth. JKG would use Saber Throw and gain Defense Up. I would then use QGJ's Humbling Blow to give everyone Offense Up.

First, take out JC to prevent healing and because he's easiest to kill and not needed. Next, start attacking Yoda, and leave JKG for last as you want to use her for free buffs. May work with other Yoda companions, but JKG is the slowest Jedi.

Divided we fall

In New York City, a city of over 8 million people, all of 2.5 million vote in presidential elections.

In 2013, a little over 1 million showed up. The rest didn't bother. We ended up with DeBlasio.

In 2014, less than 1 million showed up. Cuomo got re-elected and NYC got blamed by the upstate Republicans for the re-election. Even though most of them didn't bother voting, it was the fault of NYC where, incidentally, even less people showed up to vote.

Many excuses have been used. The candidate is not perfect, doesn't represent a voter's specific issue, said something stupid, didn't say something, etc. And then there are the "my vote doesn't count". When less than 50% of regular voters show up; your vote counts. When less than 50% bother to vote at all, or even register to vote; your vote counts.

The general election is coming up and all I see is petty bickering. Name calling between candidates, name calling between voters, and that's within the same party. Vote for whomever you want in the primaries. In November, whether your candidate lost or didn't exist, and even if you have to vote for a RINO; vote. You may be showing your displeasure by not voting, but guess what, nobody cares and nobody will notice. It's great to have principles, and you may post all about them on social networks and praise and curse the GOP and the available candidates. However, if we don't stand united when it counts, it won't be the Democrats' fault that we lost.

If you don't vote and/or not planning on voting, what right do you have to complain?

ColdFusion email validation regex timeout

Once upon a time, before ColdFusion 9 introduced isvalid(), I made my own function using regex I found online for validating emails.

([A-Za-z0-9]|.|_|\-)+@([A-Za-z0-9]|_|\-)+[.]{1}([A-Za-z]|.|_|\-)+

Validation worked fine. Sometimes the form was slow, for seemingly no reason with there being no queries or anything which would slow things down. As it was occasional and seemingly unreplicatable, I ignored it.
Yesterday, a particular form, which was prepopped with a new member's email, stopped working. After submit, and a few minutes waiting, there was a timeout error with error pointing at cfmail. Commenting out cfmail just moved the line reported to a cfoutput tag. After some collaborative troubleshooting, we figured out that the issue was the long email.
I replace my custom function with isvalid(), which fixed the problem. However, the timeout still made no sense, so I took a close look at the regex I was using. The issue was that the + was outside the parenthesis, instead of inside. The longer the email, the longer ColdFusion would spend capturing all the possible matches. Adding ?: did not help. Moving the + inside, did. This is the correct regex to use if not using isvalid().

([A-Za-z0-9\._\-]+)@([A-Za-z0-9_\-]+)[.]{1}([A-Za-z\._\-]+)

An unintentional missile

"The others found their chairs and slid neatly into them. Except - inevitably - for Carson Clinkscales, who managed to trip over what appeared to be his own feet. The ensign fell to his right, and his left arm, windmilling for balance, took Lieutenant Commander McGinley's GSN cap off her head. The heavy peaked cap catapulted across the conference table, hit the polished surface, slid past Andreas Venizelos' reaching hand with demonic precision, and struck a carafe of ice water dead center. The unintentional missile had just enough kinetic energy to knock the carefe over, and water exploded from it as the top some steward had neglected to fasten properly popped clear. Three different people clutched for the carafe, bot none reached it, and Captain Greentree gasped as the container rolled off the table and an ice-cold fountain inundated his lap."

Weber, D. In Enemy Hands 169.

New York State 2014 Elections

New York State Board of Elections is still not showing all districts to have reported in, 15,018 out of 15,056. However, at this point, it's unlikely they'll update the count so the numbers used are the ones listed there currently.

With all the opposition to the SAFE Act and Common Core, why did Cuomo win?

As per NYS Board of Elections, there are currently 10,827,434 registered voters, out of a population of 19,651,127 (2013 estimate by US Census Bureau). In the 2012 presidential election, 6,976,373 people voted, 2,490,496 being Republican. In the 2008 presidential election, 7,557,716 voted, 2,752,771 being Republican. In the 2004 presidential election, 7,276,847 voted, 2,962,567 being Republican. In all presidential elections since 1960, other than 1996 when 1,933,492 people voted Republican, Republican vote has been an average of 2 to 3 million.

Cuomo won with 1,951,247 votes. If in the last 4 presidential elections, the Republican presidential candidate received more votes than that, what happened?

The answer is very simple; nobody voted. In this election, there was a total of only 3,717,366 votes, a little over 50% of the average votes cast in presidential elections. Not only that, but in New York City, the voter turn out this year, 976,467, was even worse than last year's mayoral election where only 1,087,710 people voted out of an average of 2.5 million who vote in presidential election.

While many people online commented that at their poll site upstate there was a massive voter turnout, when all is said and done, only half of the regular voters voted. In a city of 19.6M people, out of 10.8M registered voters, out of an average of 7M active voters, only 3.7M people voted.

Why did Cuomo win? Because, whether because of "My vote doesn't count" or "The Republican candidate is not perfect" or complacency or just plain laziness, people didn't vote.

The saddest part is that NYC Republicans, after last year's elections where less than 50% of regular voters bothered to vote, haven't learned their lesson and even less people showed up to vote this year.

The question you should ask yourself is, if all Republicans would register and vote, is NY really a blue state, or is it a red state after all.

The Great Kosher Restaurant Magazine Scavenger Hunt is On!

Guest post by Bracha Komarov

Whether you’re a kosher restaurant “foodie” or you just like to go out to eat once in a while, The Great Kosher Restaurant Magazine Scavenger hunt has fun for everyone. The magazine advertises over 200 top kosher restaurants worldwide, their menus and other pertinent information. Elan Kornblum, also known as “The Restaurant Guy,” first published the magazine in 2004. To celebrate its 10th anniversary, a scavenger hunt has been going on which gives teams of family and friends chances to try new dishes while advertising on Facebook about the great restaurants in the magazine. Now in its third and final week of the hunt, each week there are 30-40 “challenges” that teams must try to accomplish. Some of the challenges were as simple as taking a selfie in front of a GKRM restaurant, while others were taking a picture of video trying dishes in certain restaurants. Some challenges took lots of guts – singing menu items in opera voice, singing happy birthday with a store manager, and even asking a non-GKRM restaurant own why he isn’t in the magazine. With 30+ teams competing, there’s a lot of competition going on. You can check out the website to see what it’s all about and you can still join a team or create your own for the last few, fun days. Visit https://www.facebook.com/gkrmscavengerhunt for more about the hunt and http://www.greatkosherrestaurants.com/ for more about the magazine and to order your must-have copy!

The Great Kosher Restaurants Scavenger Hunt

Cuomo vs Astorino debate AKA will you please stick to the question asked

Watched the debate. That was entertaining.

McDermott a Libertarian? Since when do Libertarians oppose charter schools? And as a Libertarian, no vocal opposition of unSAFE act? And what's with the "people, people, people"? Let the people, have the people, in people's hands. And how exactly does he envision that? In the beginning, he sounded like he was high and in the end, I thought he was going to cry.

Hawkins seemed to be seeing ghosts everywhere, look at the damn camera. Communism mixed with actual Libertarianism? That was different. The only guy to actual answer questions and not sound high. Still a Green though, so no vote for you.

Astorino, considering his dependence on upstate NY, should've spent more time on unSAFE, while deviating from questions, and less mudslinging about, repeatedly, the same thing. Surprised he didn't even mention, and neither did the panelists, Cuomo's misuse of state resources to promote Cuomo's failed book. Bad move on his answer about drugs too.

Cuomo's gotta go. Lying, lying, and more lying. Commie Core is not his? Other governors ensured that it won't be in their states, he didn't. No Common Core grading for 5 years? How about actually keeping it out of the state. And how about Obama lunches. Charter Schools are the way to go to oppose both. And his comment, he didn't say it, well he said it, but he didn't mean it, and it's all Astorino's fault!

Buffalo News fielding a stupid question about a stadium, and obviously ignoring all the questions about unSAFE? Not cool, not cool at all.

The Libertarian should spend some time learning how to be a Libertarian instead of a right leaning Democrat. Astorino needs to focus more on the issues. Cuomo's gotta go. The Green guy's gotta go to Germany or some other Green European country because he'll be very miserable here. And the panelists, how about focusing on questions relevant to the entire state and not just your county.

Innocent lampshades

"Those of you who wish to practice with the parasol may take one from the cupboard, but work outside, please. A sufficient number of innocent lampshades have already been sacrificed."

Sebold, G. Shanghai Sparrow 103.

Prepper Bug Out Bag

Are you a prepper? Do you have a bug out bag for when SHTF? Natural disasters, government collapse, zombie apocalypse. Here are some ideas of what to have in your bug out bag.

Mylar blankets, water purification system, water treatment tablets, solar / hand crank radio, solar charger, fire starter, pocket stove, fishing kit, pocket saw, and more.

New York's Gun Grabbers

• Brian Kavanagh - Manhattan
  Introduced bill which would allow friends, family, doctors, cops or neighbors have a person's gun to be confiscated without due process.
  Introduced bill for mandatory 10 day waiting period. NYC currently already has 90 day waiting period.
  Introduced bill to ban and confiscated .50 rifles.
  Introduced bill to ban more than 1 gun purchase within 30 day period.