In reviewing my site logs, I had stumbled on this Cool Google Search.
Author: ldnDeveloper
Andrew Pallant (@LdnDeveloper) has been a web, database and desktop developer for over 16 years. Andrew has worked on projects that ranged from factory automation to writing business applications. Most recently he has been heavily involved in various forms for ecommerce projects.
Over the years Andrew has worn many hats:
Project Manager, IT Manager, Lead Developer, Supervisor of Developers and many more - See more at: http://www.unlatched.com/#sthash.8DiTkpKy.dpuf
HTML Will not fix the Lawn Mower
HTML will not fix the lawn mower. No matter how much I can write code, what I know will not fix my lawn mower. I checked the oil. I checked the gas. I pulled the cord of the single pull lawn mower until I had blisters and skin missing from one poor finger. Last thing to check…
Continue reading HTML Will not fix the Lawn Mower
BBQ Sauce
Recently I went to barbecue some riblets and found that I had no BBQ sauce. Since I am a little lazy, I went to the fridge to see what I can find rather than running to the store. I figured it cannot be rocket science to make BBQ sauce that would taste good. I came up with the following quick recipe and the family loved it;
Continue reading BBQ Sauce
Do You Hear What I Hear
Do you hear what I hear? Probably not! During meetings and conversations people are saying a lot and often times we are itching to talk. Many of us over speak the other person. I had a boss a few years back mention this to me as something I had to grow on and that is exactly what I did. Continue reading Do You Hear What I Hear
All The Small Things
All the small things are often forgotten. In software development we are taught to take a large problem and break it down to its smallest component. Often as software developer we can make a daunting task less complicated by following the smallest component rule. This is the same in life. Did you know life can be broken down to its smallest component? Continue reading All The Small Things
jQuery Image Gallery
I was asked to create a simple jQuery routine that could replace a current flash control. The challenge was not actually the jQuery portion but creating the HTML dynamically. The current code create a XML file that was passed to a flash object. Once the HTML was dynamically created, the jQuery was pretty easy.
Here is a sample of what I created:
<html>
<!--
Author: Andrew Pallant
Date: July 2013
Image Gallery jQuery Code - Created for a client to replace a flash solution.
Code has been dumbed down for sample purposes. Actually HTML code is more dynamic, but the jQuery code is the same no mater what.
-->
<head>
<script type="text/javascript">
jQuery(document).ready(function () {
// Initialize Controls
jQuery("[id^=imgBig]").hide();
// Set Mouse Over Events
jQuery("[id^=thumb]").mouseover(function () { jQuery(this).fadeTo(0, 0.6); });
jQuery("[id^=thumb]").mouseout(function () { jQuery(this).fadeTo(0, 1); });
// Set Thumb Indexed Values
for (var x = 0; x < 7; x++) {
jQuery("#thumb" + x).attr('indexedVal', x);
}
// Thumb Click Events
jQuery("[id^=thumb]").click(function () {
jQuery("[id^=imgBig]").hide();
jQuery("#imgBig" + jQuery(this).attr('indexedVal')).fadeIn("Slow");
});
// Set Initial Image
jQuery("#imgBig0").show();
});
</script>
</head>
<body>
<div class="imgGallery">
<div class="BigImageContainer">
<img id='imgBig0' src='image1.jpg' />
<img id='imgBig1' src='image2.jpg' />
<img id='imgBig2' src='image3.jpg' />
<img id='imgBig3' src='image4.jpg' />
</div>
<div class="thumbCtrl">
<ul>
<li class="thumb">
<a href="#" onclick="return false;"><img id='thumb0' src='image1.jpg' /></a>
</li>
<li class="thumb">
<a href="#" onclick="return false;"><img id='thumb1' src='image2.jpg' /></a>
</li>
<li class="thumb">
<a href="#" onclick="return false;"><img id='thumb2' src='image3.jpg' /></a>
</li>
<li class="thumb">
<a href="#" onclick="return false;"><img id='thumb3' src='image4.jpg' /></a>
</li>
</ul>
</div>
</div>
</body>
</html>
Image of Finished Product
How to use SQL to Extract a Number from a String
Recently I had a need to extract the number from a string in the database. The string would be something like ‘Monitor 16″‘ or “16 inch Monitor”. I would need to get the size for various reasons including fees and reports, but no real good way of doing it. I have come up with the following Scalar SQL Function to do this very job.
Continue reading How to use SQL to Extract a Number from a String
Letter of Gratitude and Kudos to People Who Helped Me
Kevin Douglas, Wayne Thayer and Jas Romain all assisted me with designing the Breaking the ICE Conference website. This conference is about empowering
by breaking down the communication barriers and is a very good cause. I give kudos to these gentleman as they helped me with the design and the ideas. I have attached the letter of gratitude for all to read.
Continue reading Letter of Gratitude and Kudos to People Who Helped Me
SQL Function – Find a Value in a String of Values
In a table I have a field that you can use comma delimited value (example 1,2,3,22). When I tried to filtering use a “LIKE” statement on the value 2, I was being returned 2 and 22. ARG!
So what do you do? You create a simple function the returns a 1 or 0. 1 being successfully found and a 0 meaning failed to find. Seems simple enough? Well it was and the function can be easily tweaked to match the solution you need! Here is the function as I used it:
Continue reading SQL Function – Find a Value in a String of Values
MaxMind GEOIP Look-up for Microsoft SQL
Recently I implemented a GEOIP solution on a client site; however, the site was built on a Microsoft SQL database engine and I could not find a solution for looking up the country name easily. Through some quick Google searches I had tripped on the site for which I started at ( http://dev.maxmind.com/geoip/csv ). The site maxmind.com gave me the MySQL solution and the mathematical solution for creating the integer. Based on this information, I created my own function in MS SQL to retrieve me the calculated IP integer for easier use.