Ryan Chapin's Website

If you have ever wanted to use a SWF generated in Captivate in another Flash application, here is a good article on how to get Captivate to talk to a hosting Flash app.→ Continue reading “Captivate to Flash Communication”

Let’s say you have a table and you want to know how many rows have the same e-mail adress.

SELECT count(*), email FROM email_list GROUP BY email HAVING count(*)>1 ORDER BY count(*) DESC;→ Continue reading “Searching for and counting duplicate entries in MySQL”

This assumes that you are creating the repo on your local drive.

First, create the directory in which you’ll store your repo.

Then, use svnadmin to create the repository in that directory:

svnadmin create /path/to/directory/

The typical convention is to set up an initial directory structure as follows:

/trunk

/branches

/tags

To do so, do the following:

mkdir svntemp

cd svntemp

mkdir trunk branches tags

svn import -m ‘Import of initial directory structure’ file:///path/to/repo

Now cd to whatever working directory → Continue reading “Quick HowTo Create a Subversion Repository”

This online utility will let you convert a set of vcards file into either a .csv, or an LDIF file that youcan use to import into Thunderbird or other mail programs.

http://labs.brotherli.ch/vcfconvert/→ Continue reading “Converting a .VCF file to .CSV”

Here are a few links to some guides to writing HTMLemail newsletters.

http://www.sitepoint.com/article/code-html-email-newsletters/

http://www.anandgraves.com/html-email-guide→ Continue reading “Writing HTML E-mail”

Anyone who has used it knows that the default styling for the HTML <sup> tag leaves a lot to be desired.  The biggest is that it modifies the line-height of the line on which it it rendered.

Here is some CSS that fixes that behavior:

sup
    {
    height: 0;
    line-height: 1px;
    position: relative;
    top: -0.6em;
    vertical-align: baseline !important;
    vertical-align: bottom;
    }→ Continue reading “CSS Styling for the HTML Superscript Tag”

If you have ever wanted to recursively search through all of the files in a directory for a specific string, here is the bash command to do it:

find . | xargs grep ‘string’ -sl→ Continue reading “How to search for a string in a group of text files from the Linux command line”

Here is a link to a great article that explains how to set your SVN repository to ignore a file, or collection of files.

Below is the mirrored content should the page no longer be available.

# ---------------------------------------------------------------------
#      Ignore all the .txt files in the /trunk/Blah/ directory
# ---------------------------------------------------------------------

# Go to the directory
cd trunk/Blah/              # The directory with the files

# Start editing the properties for the current directory
svn propedit svn:ignore .   # Opens an editor 

→ Continue reading “How to ignore a file for inclusion in an SVN repository”