Clever software solutions to everyday challenges
I have a database with tables in it which have over 300 fields each. I wanted to create a new table like the others but I didn’t have the table structure saved in a file. Due to the number of fields it was impractical to copy the screen after executing a “show create table tablename” …
Continue reading “How to Export One Table Structure in Mysql and Infobright”
Last week I told a client he could send me a file in excel and I could import that into the mysql database directly. When I got the file I learned that it wasn’t quite that easy. I had planned to just save it as tab delimited text or CSV, but there was a “description” …
Continue reading “How to Convert Excel Spreadsheets to SQL Statements”
This is my first post since splitting off my technical posts into a new blog focused in that area. Part of the process was setting up a new wordpress blog, and of course I wanted to try a new theme, the Twenty Eleven theme. After I began importing a few posts I realized that there …
Continue reading “How to Add the Sidebar to WordPress Twenty Eleven Theme Single Posts”
originally posted at http://www.goodfeelingplace.com/how-to-add-special-shipping-by-product-in-zen-cart I am in the process of migrating a static site (peacemonger.org) to a database driven site “powered by” zen cart. One of the features requested was the ability to add special shipping charges for odd shaped items, like posters. After doing some research I discovered a page with instructions at http://tutorials.zen-cart.com/index.php?article=190, …
Continue reading “How to add special shipping by product in Zen Cart”
originally posted at http://www.goodfeelingplace.com/the-essence-of-ajax-how-i-learned-it-in-an-hour I was a bit resistant to learning ajax for a couple years because I didn’t see a need for it in the programs I was developing. However, one day I learned it without knowing it. I was working with code written by someone else which called a javascript function that invoked …
Continue reading “The Essence of AJAX – How I learned it in an hour”