Router <> TCP/IP over electrical mains <> Wifi in the distant office.
posted to Ask Metafilter by orthogonality at 8:13 PM on September 4, 2008

"You know, [attacked person] might just believe what you said is true, and that would be hurtful."

Or, more softly, "I know you didn't mean to be so harsh, but I'm worried (attacked person) may take what you said to heart."
posted to Ask Metafilter by orthogonality at 7:06 AM on September 4, 2008

notsnot writes "Now, she (hopefully) touches and allows your nasty bits in her nasty bits and mouth, so what, exactly, makes her ok with the cooties then and not at other times, is the question."

1. Her vagina is highly acidic, to kill bacteria. This is no perfect defense, so wash your cock before inserting it.
2. Her mouth is full of lots of bacteria adapted to it, which will out-compete foreign bacteria. This is no perfect... [more]
posted to Ask Metafilter by orthogonality at 12:23 PM on September 3, 2008

You're (probably) not running into a row limits, you've probably got data that contains whatever column separator you're using.

As your test showed (good thinking), the bad data's somewhere after line 50.

Export the data as CSV making sure you specify that the data be quoted, and re-import.

Then run the following queries:

select count(*) from table_a;

select count(*) from... [more]
posted to Ask Metafilter by orthogonality at 4:17 PM on September 2, 2008

You mean a 14 inch neck? What sleeve length? What "blends" are acceptable? (My opinion: cotton or linen or silk; synthetics are bad in shirts.)
posted to Ask Metafilter by orthogonality at 4:07 PM on September 2, 2008

"By the end of the function, there will be a decent amount of overlapping data, which is unacceptable."

Your function is throwing the data into a temp table, and you wish to create a view over the temp table? If the temp table's destroyed when the function exists, the data won't be in the view, you understand?

But the basic answer to your question is that you create the view the same way you issue dynamic SQL... [more]
posted to Ask Metafilter by orthogonality at 5:00 AM on September 2, 2008

Do what b1tr0t suggests, but more cheaply by comparing the obvious suspects first.

For each thumbnail, compute the 75x75 center area (your default), and compare it to the actual thumbnail. If that matches, you're done. If not, flag it as unfound. In either case, move on to the next picture.

Now that you've eliminated all the easy cases, see how many pictures are left to do, a visually try to see hw those thumbnails were made. Maybe many of those... [more]
posted to Ask Metafilter by orthogonality at 6:03 PM on September 1, 2008 marked best answer

hal_c_on writes "YOUR job is to figure out what atheists might be thinking if they REALLY fear for their lives, and how you can prevent them from freezing up and not doing what they are supposed to so others don't die."

In that case, Marcus Aurelius's Meditations. He was, reluctantly and out of duty a soldier, and if not technically atheist, not a believer in personal God or Savior. His Meditations... [more]
posted to Ask Metafilter by orthogonality at 11:30 AM on September 1, 2008

Heat, rest, anti-inflammatory.
posted to Ask Metafilter by orthogonality at 5:17 PM on August 30, 2008

Forfeits party: everyone dresses a theme, has to remove anything shown to be inconsistant with the theme.
posted to Ask Metafilter by orthogonality at 12:48 AM on August 30, 2008

A PalmPilot or Zaurus with suitable encryption.
posted to Ask Metafilter by orthogonality at 6:26 AM on August 29, 2008

Whatever you put in is going to use up battery power, even when off. So if you don't have a clear need, leave it empty.
posted to Ask Metafilter by orthogonality at 8:25 PM on August 28, 2008

He's a perfectionist, huh?

He's only going to obsess about his own work responsibilities. So if he's "stuck" in a perfectionist loop, you take responsibility: "I think this is as fine as we're going to get this, I think it's great work, I'll take responsibility for signing off on it."

It's the perfect out for him, and will probably be a relief to him, especially if you... [more]
posted to Ask Metafilter by orthogonality at 8:14 AM on August 28, 2008

ejaned8 writes "If that's not possible, request a written log of his concerns/progress. It may help him to see where he's getting stuck. It also makes it easier to hand-it off to someone else."

He's a perfectionist. What do you expect he'll do with that written log? (Hint: no one else will see it until it's perfect, or he'll be additionally stressed he had to give it to someone else in an imperfect state.)... [more]
posted to Ask Metafilter by orthogonality at 8:17 AM on August 28, 2008

Convert the blank line to some dummy value, like "xxx---xxxx---xxx".

Convert every line ending* character to double-quote comma double-quote

Convert the dummy value to a line ending character*

* on MS-Windows the line ending character is really two characters. I don't recall how word represents it, but you'll figure it out.
posted to Ask Metafilter by orthogonality at 8:54 AM on August 27, 2008

Oh. If you have any real double quotes in your data, escape them first.
posted to Ask Metafilter by orthogonality at 8:56 AM on August 27, 2008

I had this problem with my bank. Calling customer service didn't help, so I called Investor Relations (I own stock in the bank). That worked.
posted to Ask Metafilter by orthogonality at 7:33 PM on August 26, 2008

Don't try so hard.

Plenty of guys like smart girls. But no one likes desperation.

(I like smart girls; this girl knew that; she spent an evening "convincing" me she was "smart", mentioning her two MAs, etc. This was a turn off, because she was working it too hard.)

Relax, let things flow. Working too hard to seem smart, informed, sarcastic, ironic, whatever, makes people wonder what you're trying so... [more]
posted to Ask Metafilter by orthogonality at 8:02 AM on August 25, 2008

This happens to me on occasion. I find catharsis works to purge it. Try watching a cheesy tear-jerker movie ("patriotic" ones, or underdog wins against great odds, work for me), have a good cry, and see if that "dries you out". Or read some poetry aloud -- Henry V's St. Crispian Day speech, or just about any Kipling. Or Beethoven's 9th Symphony.

In other words, embrace it, have a cathartic moment, and soldier on.
posted to Ask Metafilter by orthogonality at 2:54 AM on August 24, 2008

Some Jesus fish jewelry?
posted to Ask Metafilter by orthogonality at 8:45 AM on August 22, 2008

Also, http://www.metafilter.com/65390/Where-there-is-no-doctor.
posted to Ask Metafilter by orthogonality at 6:43 AM on August 22, 2008 marked best answer

"all entries in table"

This means an outer join. People tend to do outer joins as left outer joins, because that's what most databases support, because people tend to do left outer joins, because.... So we'll do left outer joins, to table2 and to table3. I'll give the tables correlation names or aliases of "a", "b", and "c" to minimize my typing.... [more]
posted to Ask Metafilter by orthogonality at 10:28 PM on August 21, 2008

Oh. Either table2 or table3? That's a full join. Use that if your database supports it. If not, use a union (over table1) of the two joins I showed you.

select a.* from
table1 a left outer join table2 b on (a.some_col = b.some_col)
union
select a.* from
table1 left outer join table3 c on (a.some_other_col = c.some_other_col);

-- yes, I can legally reuse the correlation name "a", as the... [more]
posted to Ask Metafilter by orthogonality at 10:35 PM on August 21, 2008

Er, and I should re-read my last comment; in my second comment, take off the "left outer", to get this:

select a.* from
table1 a join table2 b on (a.some_col = b.some_col)
union
select a.* from
table1 join table3 c on (a.some_other_col = c.some_other_col);

MySQL doesn't do full joins, even if you're clever and try to do it like flunkie did by filtering a cross-join. (Yes, that... [more]
posted to Ask Metafilter by orthogonality at 10:43 PM on August 21, 2008

Flunkie writes "Which one, and what about it?"

My mistake; it's late and I'm tired.
posted to Ask Metafilter by orthogonality at 10:47 PM on August 21, 2008

Flunkie writes "Could you please explicitly say what you believe is wrong with my answer?"

It's correct SQL but won't work under MySQL, because MySQL won't do full outer joins even "disguised" as filtered cross-joins.
posted to Ask Metafilter by orthogonality at 10:49 PM on August 21, 2008

Bichons get these because (despite being prized for being hypo-allergenic; that is, they don't provoke allergic reations in humans) they tend to be allergic to many things.
posted to Ask Metafilter by orthogonality at 5:47 PM on August 21, 2008

His most obvious skill is his prison experience.

His target clients are wealthy white collar criminals who have been convicted but not yet sentenced, and who are afraid of being beaten and raped "on the inside".

Your friend charges them $500/hr for advice, training, role-playing encounters they will have in prison. Two grand and up for the course. Extra if he contacts associates on the inside asking them to make prison life easier for a... [more]
posted to Ask Metafilter by orthogonality at 5:21 PM on August 21, 2008

PS. His annoying, asocial attitude will serve to convince clients he's the real deal.
posted to Ask Metafilter by orthogonality at 5:23 PM on August 21, 2008

Oh, his other clients are affluent parents of upper middle-class kids sentenced on drug charges. Coach little Johnny weekend weed seller on etiquette and comportment and how not to be invited to "dance" in the Big House.

Have your friend offer to subcontract to, or consult for, local defense lawyers who serve the wealthy. That's a deniable kickback for the lawyers.
posted to Ask Metafilter by orthogonality at 5:30 PM on August 21, 2008

FileMaker Pro doesn't really support SQL, so while it's a database, it's not what most people think of as a database. So you'll have a smaller population of people who can support it

MySQL supports most SQL (if not conspicuously well); anybody with a knowledge of SQL would be able to access the back-end, if you needed help with that.

The front-ends, in both cases are proprietary, and probably have a small population of people knowledgeable in... [more]
posted to Ask Metafilter by orthogonality at 7:37 AM on August 19, 2008

spakto writes "We need a database to keep track of author information, blurbs, printing schedules, prices, sales, etc. so that everyone can access it and update fields when necessary. This should do away with various inner-office memos and save a lot of time hunting down figures or schedule dates. For example, if an author moves we can update the address in one place and everyone will have the updated info."

Sounds like you could just use... [more]
posted to Ask Metafilter by orthogonality at 8:14 AM on August 19, 2008

grapefruitmoon writes "Find a new place. Get your friends to help you over a weekend. Tell him on Friday. It will seem sudden and shocking and heartless, but it will be better for EVERYONE in the long run. Do not offer to talk about it. "

That advice seems selfish, and even gratuitously cruel. And counter-productive: after four years together, he'll need closure, he'll need to go through the stages of grief, and simply pulling a... [more]
posted to Ask Metafilter by orthogonality at 2:01 AM on August 19, 2008

Could be the Firefox fsync problem. If it's FF, try turning off checking for forged sites.
posted to Ask Metafilter by orthogonality at 10:04 PM on August 15, 2008

"he's tired and doesn't want visitors, that just hearing from me on the phone is enough, and that he is stressed out knowing I'm coming."

He's being straightforward with you. Visitors are great, but they're also taxing, especially if the patient is preparing for surgery or other procedures.
posted to Ask Metafilter by orthogonality at 5:26 PM on August 15, 2008

"Is there anything to be gained by being honest with him about how the dicey and chaotic financial situation is affecting me, or should I wait until I find another job, and then break the news? "

He knows it's chaotic and is affecting you. There's no news to break, unless you want a recommendation from him. He also apparently knows the ship is sinking, which is why he's made you no promises ("as soon as we weather this storm...")... [more]
posted to Ask Metafilter by orthogonality at 10:55 PM on August 14, 2008

The note explaining the stuff was free implies "free to any taker", which implies the stuff isn't being left specifically for you.

The leaver thinks that the area in front of your home is some sort of communal area. Are you sure it's not municipal property of some sort? If it's not, can make it less open, e.g. by putting some container plants or garden statuary there?
posted to Ask Metafilter by orthogonality at 9:02 PM on August 14, 2008

Have you traveled outside the US, or been around foreigners in the US? You may want to see a tropical disease expert.
posted to Ask Metafilter by orthogonality at 2:59 PM on August 12, 2008

Maybe, maybe not. Could well be, but could be other issues.

The important point is, have sex if what you want is to have sex. Just as a guy shouldn't use "I bought you dinner (which I didn't enjoy for itself, but just as a pre-payment for sex)" just as a token he can turn in for sex, you should enjoy sex for itself or forego it. You shouldn't see sex (implicitly and by itself) as a promise of a future relationship.
posted to Ask Metafilter by orthogonality at 8:18 PM on August 11, 2008

Ky writes "Another option is to configure your network (firewall thingie) to block all ports besides the ones you actually use in the business environment (HTTP = 80). This will avoid the whole cat-and-mouse chase."

Don't use a hand grenade when a scalpel will do the job.

Besides, plenty of businesses use FTP (which just grabs up ports), SSL (port 443), email (ports 25 & 110), and telnet (port 23).... [more]
posted to Ask Metafilter by orthogonality at 8:02 PM on August 11, 2008

How about just posting the links?
posted to Ask Metafilter by orthogonality at 7:58 PM on August 11, 2008

Disabling the tochpad when you type is considered a "feature". Go in to Control Panel | Mouse, and look through the tabs until you find a "Touchpad" tab, and untick "disable touchpad when keyboard used".

If your Mouse control panel offers no such option, see if you can install the Dell Mouse coontrol for your particular computer, and see if it has that option.
posted to Ask Metafilter by orthogonality at 1:14 PM on August 11, 2008

Dude, he's gonna spit in your pizza. Not justifying it, it's disgusting, but that's what he's gonna do. At best.
posted to Ask Metafilter by orthogonality at 5:48 PM on August 8, 2008

F = ma.

If the ends are tucked up between the IUD and you, they're not going to move far when the pushed by Mr. Penis, and the push will be against the whole IUD, spreading out the force.

Mr. Penis, on the other hand, is moving farther and faster, and all of the force of his movement will impact on the tiny area of the sharp end of the string.

It's the same principle that allows a single nail to puncture you if you flop... [more]
posted to Ask Metafilter by orthogonality at 11:04 AM on August 8, 2008

I hear oral thrush in an ostensibly otherwise healthy adult, and I think opportunistic infection incidental to HIV/AIDS. Why didn't the military doctor order up a Western Blot?
posted to Ask Metafilter by orthogonality at 11:06 PM on August 7, 2008

I doubt it. But in several weeks, you can get two blood tests, one specific for HSV-1, the other specific for HSV-2, and then maybe you can get Valtrex.

Valtrex isn't a cure, it just suppresses outbreaks.
posted to Ask Metafilter by orthogonality at 7:27 PM on August 7, 2008

There are plenty of ways (which I won't enumerate here) for him to be dominant even if he's lying on his back.
posted to Ask Metafilter by orthogonality at 6:37 PM on August 7, 2008

Do: Provide a contact number that reaches a real person.
posted to Ask Metafilter by orthogonality at 3:00 PM on August 7, 2008

In America, if you say you have a personal preference, people will figure their business's policy trumps that.

So one technique I use is to explain that my business's policy requires me to do something, such as go with the lowest rate (or not install their connectivity software, or not give my credit card or social security numbers).

Often it seems customer service types understand more readily "it's the policy" than they understand... [more]
posted to Ask Metafilter by orthogonality at 1:12 PM on August 7, 2008

"We're in Louisiana, "

You're in Louisiana, where the "holy trinity" of cuisine is celery, bell peppers, and onions.
posted to Ask Metafilter by orthogonality at 8:03 AM on August 7, 2008