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

Monday, February 13, 2017

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
17th. 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.
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.

1836 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?

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.

Sunday, May 22, 2016

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.

Tuesday, March 15, 2016

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?

Tuesday, July 21, 2015

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\._\-]+)

Sunday, July 12, 2015

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.