This is a new post

See, you can make a post.

Looking into hosting a 5k race

This begins my exploration into race promotion.

Promotion? You can promote a race online with the Runner’s World Race Finder, as well as a ton of other places, I’m sure. There’s an eHow article about this.

Registration? If the race isn’t free, then it will probably cost you a registration fee. I see some people are using www.active.com. Some people use mail-in forms.

What should be on your website? Runner’s World had a decent little list.

SQL Update with WHERE EXISTS

This is for when you need to update multiple records based on values in another table.

I got my info here.

Example:

UPDATE suppliers
SET supplier_name =	( SELECT customers.nameFROM customers WHERE customers.customer_id = suppliers.supplier_id)
	WHERE EXISTS ( SELECT customers.name FROM customers WHERE customers.customer_id = suppliers.supplier_id);

Stored Procedure – Resource List

Coderecipes.net – Stored Procedures Tutorial – I found this useful. It’s just basic information about the stored procedures and their anatomy.

Return Values: Getting Something Back from Your SQL Server Stored Procedures – Getting the return value

Fix the stinking ‘EXECUTE permission was denied on the object’ error

So you’re building stored procedures? Sweet. You have to set the stored procedure permissions though. I kept forgetting how to do this when I started implementing stored procedures. This is for SQL Server Management Studio Express 2005. It’s probably a little different on other version.

1. Open SQL Server Management Studio Express 2005

2. Expand your database > expand Programability > right click and select Properties

3. Select Permissions

4. Add desired user to ‘Users or roles list’

5. Select Grant on the Execute row of the ‘Explicit permissions’ menu.

I wish I had a brain…

Unix… Shit.

I just started learning how to use unix.  I just don’t know how to talk to it yet.

So far, the best resource I found was this:  UNIX / Linux Tutorial for Beginners

Xampp: Develop Websites on Your Local Machine

I just got started using Xampp last month and I’ve found it really useful.  So far, I’ve just used it to develop WordPress and Drupal sites.

It’s a nice little local variety of Apache, MySQL, FileZilla and Mercury. I’ve only delved into the Apache and MySQL applications so far. PHPmyAdmin is included as well.

Installation wasn’t bad.