HTML to show program code in a post.

HTML code to add a table to post to show a code example.

HTML Example

< table border="1" width="500" height="220">
< tbody>
< tr>
< th > Program Example < /th>
< /tr>
< tr>
< td>
< div style="height: 150px; overflow: auto;" >
< code>
# code goes here
< /code>
< /div>
< /td>
< /tr>
< /tbody>
< /table>
Posted in Snippets | Leave a comment

House Siding Project

Well 3 or 4 years later, getting around to finishing the addition. On 2 sides the sun (UV) really broke down the house wrap. Then the wind tore it off.

 

 

 

 

 

 

I think it was needed and I replaced it, there was some discussion about putting it back on, the main point was if you can’t wrap it into the rough openings it really doesn’t provide a vapor barrier.  Well I had it already, and then I also had the peel and stick window flashing, so the house wrap still added a vapor barrier.

 

 

 

 

 

 

Next was the foam insulation, First we tried to get it on a whole row at a time, for some reason it seemed to pucker too much, we did it in 10 foot sections so it was more manageable. And the because of that we taped the open joints with the same tape we used on the house wrap.

 

 

 

 

 

 

And now one side ready for siding on to the next side.

 

 

 

 

 

 

Started again this last weekend, go the housewrap and insulation on the second side, and then started the siding.









 

 

 

 

 

 

 

 
 

 

 

 

 

 

 

 
 

 

 

 

 

 

 

 
 

 

 

 

 

 

 

 
 

 

 

 

 

 

 

 

A side and a half done, but more ready that I can do by myself, hopefully have the second side done by next weekend.

Well another weekend, finished the back side and started to prep the last side.

Dodging raindrops all weekend, but the siding is done..

Posted in Building Projects | Leave a comment

Foxpro to MySQL data conversion

This was part of a project I did a couple of years back. The project was to rewrite a intraweb application that was written in OdbicScript and used Foxpro tables for data storage. The goal was to make it more industry standard by moving it to a “Lamp” platform. The portion of this project that this article discusses was the method to get the existing data from the Foxpro tables into a MySql database.

There are commercial programs to do this, but this was a well defined one time use, so this solution actually worked well and only took a day to put together.

The program takes advantage of the way MySql does a back and restore. The backup file from MySql is in clear text, so by getting the attributes of the Foxpro tables it was pretty easy to emulate the backup file, and then use that to move the data into a MySql database.

To describe the MySql backup file, the beginning will drop a table if it exists, then create the columns in the table, and then finally insert each line of data into the MySql Table.

To actually restore that file I used the command line form, on the target box (probably a linux/unix variant but hey I’m not judging) as a MySql administrator run the command “mysql -u username -p database < file.sql”. Substitute username with a valid username, the p will cause it to ask for a password, substitute database with the target database, and redirect the backup file as standard input (which is the < filename at the end of the command).

I know this is sketchy, I will flesh out the steps and elaborate more on what the programs do, but I wanted to get this out, to get past the deer in the headlight syndrome, which is exacerbated by a almost blank website.

download programs

 

Posted in Snippets | Leave a comment

I can’t wait until spring!

Planting Corn

These are my grandsons from about 2 years ago, so intent on what they are doing. They really enjoyed helping, putting the seeds so far apart, and then covering them up. What do they have extra, or what do we have missing that they could have fun doing that, where we as adults would be put out, or bored if we had to do the same job.

 

Posted in Uncategorized | Leave a comment

Hello world!

Well, starting another project. Pitched the “home grown” content driven website, and decided to give a packaged product a try.

Even though I lose the “made it myself”, this should be much more capable and give a more polished look.

Another hurdle will be wanting to have it close to the way I will ultimately want it before I do anything, but I’ll try to get past that and just throw things here for a while as I learn how to make it look the way I want.

So here we go, keep coming back, I’ll try to keep it interesting. Please if you have suggestions I would appreciate them.

Posted in Uncategorized | Leave a comment