ECS A785GM-M

Author: dp | 04 June 2010 | View Comments
Categories: Computers

FYI, The ECS A785GM-M 1.0 does *not* have a speaker connector. Makes it difficult to have a system beep without the built-in speaker.

Databases and backups

Author: dp | 06 May 2010 | View Comments
Categories: Servers

Yesterday, I managed to delete the primary

How to fix strange characters in MySQL database – Vinh Pham

Author: dp | 26 January 2010 | View Comments
Categories: Servers

I admit, I borrowed this from 

Cleaning up bad data in an SQL database

Author: dp | 02 June 2009 | View Comments
Categories: Uncategorized

Recently, I needed to find all of the data in a table that was being used for HTML output, that had non-printable characters. The following SQL statement should do that for you: select id, name from table_name where name not regexp ‘^[a-zA-Z0-9_ ,&;\/<>(²):%*#?$|!+.\"\'-]+$; This code is MySQL specific, but should be applicable anywhere, really.

XFN/FOAF

Author: dp | 26 May 2009 | View Comments
Categories: Uncategorized

I’ve been working on getting all of the sites on which I have public profiles compiled together into a list. Currently, the fruits of that effort can be seen in the sidebar of this site. All of those urls should have a rel=”me” attribute on them, so that the social graph is correct, and all [...]

Recent Comments