November 2005

MySQL String Functions

by damonp on November 21, 2005

in Snippets

MySQL String Functions allow for easy in situ data manipulation.

For example:

update products set products_image = replace(products_image, ‘products/’, ”);

Will update all products_image fields from:

products/product_image

to:

product_image

Stop writing PHP code to loop through the whole dataset to make changes.

Popularity: 1%

{ 0 comments }

Mighty Mouse Trackball Woes

by damonp on November 15, 2005

in Apple / Mac

I started playing with the new Mighty Mouse a couple of weeks ago and really like it. Having a right-click button again is so much easier than the whole CMD-click. I was lost without it the first month I got my PowerBook. I’ve seen some complaining about the mouse not having actual buttons and some users not always getting the intended click. If you must look at the mouse to pick which button to push, you have other issues besides a mouse.

Only slightly less important on the functionality scale is the scroll ball. I am a command line geek, but occasionally I llike to take a break and step away from the keyboard, put my feet up and surf or read long passages. With the scroll ball, this is once again possible.

One problem… after a few weeks of heavy usage, the scroll ball has stopped working in one direction or another, The first time I fixed it with a little low tech banging of the mouse on the desk. Last night, this just was not doing it. Having just moved into a new place and not having time to put everything in its place, my desk is littered with tech miscellanea. An old bottle of compressed air for dusting out PC cases was nearby. Duh! Needless to say, a few quick squirts of air through the ball opening solved the problem.

I found other complaints on this same issue this morning. Several people had received replacement mice from Apple to fix the problem. One user was even on his third replacement. Hopefully Apple will take a clue and reengineer the scroll button to be a little more resistent to dust (or perhaps crumbs).

Popularity: 1%

{ 1 comment }

Inimitable

9 November 2005

adj. Defying imitation; matchless.

Read the full article →

Mighty Mouse Horizontal Scrolling and Firefox

8 November 2005

Firefox can sometimes interpret horizontal scrolling with the Mighty Mouse trackball as a forward / back request. To disable: In the Firefox address bar, type about:config Change the setting mousewheel.horizscroll.withnokey.action to 0

Read the full article →

New Linux Web Services Worm – Linux.Plupii

8 November 2005

An article on eWeek gives the following synopsis of what the worm does: When Plupii is successful in infecting a server, it then sends a notification message to an attacker at a remote IP address via UDP port 7222 or 7111. Which port it attacks appears to be hard-wired into the worm and thus represents [...]

Read the full article →

Qmail Qregex Patch for Qmailrocks Distribution

4 November 2005

Qmailrocks is a soup-to-nuts mailserver distribution that includes Qmail, Vpopmail, Spamassassin and Courier IMAP. It provides compatible versions of each of the server daemons and step-by-step instructions for installing all of them. Qregex is a patch for Qmail that allows an admin to configure Qmail to automatically bounce messages based on regular expression matching in [...]

Read the full article →