Website Designers and Webmasters

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

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

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…

I just installed WP Events Calendar (6.6-beta) for the first time and installed the large calendar on a page.

For some reason, the Month of the Calendar was an

and I couldn’t find the “Previous Month” and “Next Month” buttons. That is because there is an <H2> before the table that houses the months…

You can edit the HTML of that section aroun line 400 of “events-calendar/ec_calendar.class.php” Here’s what I did.

Before:

<h2 style="text-align:center;">
<table id="CalendarLarge-Header" cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td width="25%"><div align="left"><span id="EC_previousMonthLarge"></span></div></td>
<td width="50%"><div id="EC_current-month" align="center"><div id="EC_ajaxLoader"><img src="$ajax_loader" /></div>$titMonth $year</div></td>
<td width="25%" align="right"><span id="EC_nextMonthLarge"></span></td>
</tr>
</table>
</h2>


After:

<table id="CalendarLarge-Header" cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td width="25%"><div align="left"><span id="EC_previousMonthLarge"></span></div></td>
<td width="50%"><div id="EC_current-month" align="center"><div id="EC_ajaxLoader"><img src="$ajax_loader" /></div><h3>$titMonth $year</h3></div></td>
<td width="25%" align="right"><span id="EC_nextMonthLarge"></span></td>
</tr>
</table>

I just took out the <h2> and added an <h3> around the $titMonth $year. You can edit it as you wish.

Enjoy,
Ashton Sanders

Well, I’m very excited today because my shirts finally arrived today. I purchased 11 shirts from 6 Dollar Shirts.com, and they finally arrived. With shipping, the total price came to less than $7 for each shirt!

They came in a surprisingly small box:

I laid them all out and took some pictures:

Click Here for larger picture.

I hope they last a very long time. I’ll post again later with an official review of how they last, but I’m sure they’re well worth the $7.

Here’s one pic of me sporting the “Old School” shirt:

Enjoy,
Ashton Sanders