Ask MetaFilter posts by jpoulos

SQL Server Find and Replace Script

jpoulos — Mon, 17 Sep 2007 07:20:02 -0800

SQL SERVER - I'm not a SQL script guy, but I've got a SQL script problem. I'm trying to do a simply find-and-replace of a url wherever it may be in the db. The script I was given doesn't work, and the guy who wrote the script is gone.

You can see the script here: http://number9media.com/scripts/FindAndReplace-qlinks.sql

When I run it, I get no errors, but it doesn't make any changes. Someone pointed to the PATindex in line 22 as a potential problem, if that helps.

Hi-res Bush Photos

jpoulos — Wed, 08 Aug 2007 08:28:07 -0800

Where can I find hi-res images of George W Bush--especially candid pics? I've checked all the usual places (google images, whitehouse.gov, etc). I'd even pay a few bucks if necessary.

Terminal illness and credit card debt

jpoulos — Mon, 17 Jul 2006 09:33:43 -0800

Suppose you have a terminal illness, and only have a few months to live. What's to keep you from running up huge credit card bills. Can the creditors make the next of kin pay up?

Which Russian film poster?

jpoulos — Thu, 27 Apr 2006 09:08:49 -0800

While searching the usual poster sites to fill my bare walls, I came across this striking image, which is identified only as "Russian Film Poster". Can anyone identify the film? I'd like to see the movie before I go slapping its poster up on my wall.

Name the eight-pointed star

jpoulos — Wed, 27 Jul 2005 08:15:57 -0800

Is there a name for the eight-pointed star pictured here?

browsing to a directory, not a file

jpoulos — Wed, 20 Jul 2005 08:13:42 -0800

HTML's <input type="file"> allows you browse to a directory and select a file. Suppose I want to capture the directory path, not a file contained therein? Is it possible to browse to C:\Documents\Workstuff and capture *not* a file in that directory, but the directory path itself? Know what I mean?

floating an image in dynamic content

jpoulos — Tue, 28 Jun 2005 11:28:09 -0800

CSS with dynamic content. I'm trying to create a web page using CSS and text pulled from a database, so that it looks like this: http://www.blogfucker.com/junk/css_help.gif. "Image 2" is simply floated left. Very simple to do with static content. But this is for a client who will only be able to edit the text, which will be entered as a single block of text. How do I throw a floated image in there so it shows up roughly in the middle of the page? I've considered writing a script to count the number of paragraphs (or even characters) and dividing by two, and throwing it in that way. But I feel there must be a simpler way.

I'm developing a form Adobe Acrobat which, when

jpoulos — Thu, 06 Jan 2005 12:25:41 -0800

I'm developing a form Adobe Acrobat which, when submitting, calls a php script, which performs an INSERT into a MySQL database, then comes back with a "Thank you" web page. The script is called just fine and the INSERT works, but the browser hangs on the Thank You page. [more inside]

I've got a twelve-year-old boy in my life whom I'd

jpoulos — Tue, 07 Dec 2004 11:34:20 -0800

I've got a twelve-year-old boy in my life whom I'd love to coax into a new hobby. He currently only enjoys video games and collecting Hot Wheels cars. I've considered things like r/c aircraft or rocket building, but either my budget or his mother won't allow it. I want him to learn to use his hands, and maybe get outside a little bit. Any suggestions?

I just watched Olivier's version of Richard III twice and I still can't figure out why, during the Battle of Bosworth Field, while Richard and Richmond's forces are engaged in hand-to-hand combat, they suddenly stop fighting, let out a cheer, and embrace each other. I can't seem to google anything about it. What's the dilly-o?