Website Designers and Webmasters

Dedicated to all the tasks Webmasters, Website Developers and Website Designers find themselves facing.

By: Ashton Sanders

Free FLV Editor – Not Trial Software!

Nov 12 2009

I have looked through the interwebs for many an FLV video editor. There are many to select from on CNET and for any search on Google. I have downloaded and tried many of these. Even with them being trial software, I was not impressed. In a sentence, I’ve had horrible luck trying to find a good FLV editor.

I’m not totally surprised since most people don’t do a lot of FLV editing. Most people who work with videos create and edit videos in another format (MPEG, AVI, etc.) and then use a FLV converter to turn the file into a Flash Video. If an edit needed to be done to the video, it would be done in the original format and re-exported into Flash Video.

This brings me to my point: I have found a pretty cool FLV editor that is not trial software. You can clip the timeline very easily and edit the MetaData for the Flash Videos that you edit. It is built in Adobe Air.

Here’s the link to the FLV editor build by RichApps.

Thanks!
Ashton Sanders

By: Ashton Sanders

SQL – Delete Similar or Identical Records

Oct 20 2009

Filed under: SQL,Webmaster

Deleting similar or identical records in SQL is a lifesaver. I found Brian Cryer’s “SQL How To…” about deleting similar or identical records in SQL. It’s got a lot of information, including the code for MS-Access SQL.

Here’s a quick explanation of what the following code does:

It searches MyTable for and deletes all rows where the dupField is the same except for the row with the lowest uniqueField.

Delete Similar Records

To delete similar records, i.e. where the records are not the same but one field is the same and only one copy needs to be preserved, try the following SQL:

DELETE T1
FROMÂ MyTable T1, MyTable T2
WHEREÂ T1.dupField = T2.dupField
AND T1.uniqueField > T2.uniqueField

To break this down even further, this code would delete all rows in MyTable that had the same value in dupField.

DELETET1
FROM MyTable T1, MyTable T2
WHERE T1.dupField = T2.dupField

This last line restricts the deleting to only rows that are also greater than another row with the same dupField

AND T1.uniqueField > T2.uniqueField

Obviously, you would replace the field and table names to work for your table.

Talk soon,
Ashton Sanders

By: Ashton Sanders

XO Hosting Review

Sep 23 2009

I’ve been fortunate to work with John Klein and some of the ladies over at KMP Advertising to help them create their new website. They created a beautiful website that I was proud to develop for them.

I built the website with a simple php include template and basic htaccess rewrite for the client pages.

XO Hosting meets Ashton Sanders

We had been planning on switching hosting accounts to my server, but when XO Hosting (there previous hosting provider) promised that it would destroy the email setup, we decided to keep it there. No problem. How bad could it be? If nothing else I will get to write a lengthy XO Hosting Review…

Last night, I started transferring the new website files to the XO Hosting server. I went to test one of the simplest pages on the site, and got an error that said:Â “CGI Scripting not allowed on this server.” Well that stinks. I waited till this morning so I could contact their technical support.

Thankfully, turning CGI Scripting (and PHP) was easy enough to do. Unfortunately, I hadn’t even gotten started on the problems with XO Hosting. Continue Reading…

By: Ashton Sanders

JQuery ThickBox Gallery Images Not Working

Jul 23 2009

Filed under: Javascript,Webmaster

Today was my first time using Thickbox, and I’m pretty satisfied. It’s got all the features I was looking for, namely “pop-in” images, iframes and galleries.

I didn’t really like how you had to add a querystring for the Thickbox iframes (I would prefer to use the rel attribute), but it still works fine.

Gallery Images Not Working

I’ve been banging my head against the keyboard for hours trying to fix this one little bug with Thickbox. For some reason, when I used the Thickbox Image Gallery, I couldn’t get the image to appear at all! Continue Reading…

By: Ashton Sanders

Free Vector RSS Icon – Fireworks PhotoShop Adobe Illustrator

May 21 2009

I recreated the normal RSS icon as a vector image, and thought I’d make it available for free (and store it for the next time I need it). Having the vector images make it so much easier to tweak colors and size.

Download Free RSS Icons
Here are three file types of a large RSS vector Image I created.

These RSS images were created as vectors in Fireworks and then exported as layered vector images to PhotoShop (.PSD) and Adobe Illustrator (.AI). I don’t have Adobe illustrator to test, but the other two seem to work fine.

You can see where I added this RSS icon to the top of my sidebar on this blog as well as the blue RSS icon I made for CSS Videos.com. Although the RSS is supposed to be orange, I wanted to go as different as possible while still being useful with CSS Videos.com.

Enjoy,
Ashton Sanders

« Newer PostsOlder Posts »
RSS

Where Am I?

You have found the semi-coherent ramblings of Ashton Sanders: a website designer, developer and webmaster. This is primarily Ashton's place to save notes about techniques and things that he learns in his never-ending conquest of the internet. Hopefully it's coherent enough to be useful to you too.

Subscribe:

Enter your email to get automatic emails whenever Ashton posts on the blog.

Email:

Advertisers:

Email Marketing $19/Month! OIOpublisher Learn how to make Money from Blogging Hillarious, High-Quality Shirts for $6/each Great Book Keeping and Invoicing Software Advertiser Here

Tags and Categories

Links

Blog Roll