Category: Quick Tips

Simplified SWITCH Statement

Just a quick one today that might help you clean up some code somewhere. I have a process where we are importing some glossary terms for 5 different languages. All of the logic is identical except for the LanguageID. So I have a simple FOR loop that runs 5 times, the problem is that the … Continue reading Simplified SWITCH Statement →

Multiple Return Values from a Function

One of the new features of v19 is the ability to return multiple values from a procedure. That came in real handy for me this week! While working on the JQuery Slider date selection control that some of you have seen, I needed to be able to find the begin and end dates for a … Continue reading Multiple Return Values from a Function →

Structured Array Short Hand

I used structured arrays a lot! No I mean A LOT! In fact, I generally have a class called FixedLookups that contains several Hardcoded Structured Arrays for things that are necessarily user configurable, but still easier for me to code a combo box using a structured array instead of hardcoding into control properties via the … Continue reading Structured Array Short Hand →

Validate Credit Card Number

Uncle Pete's Freebie of the day..... I need to validate the credit card number a user enters, so after some Googleing I came up with this function. It accepts the credit card number as a string then strips any spaces or dashes off. It then performs a few test to determine the card type, and … Continue reading Validate Credit Card Number →

HF SQL Doesn’t support complex Update Statements

As many of you know I have been slowly become more of a convert to HyperFileSQL and WX Queries. And generally use HF for my projects while they are in the R&D stage, only moving them to PostgreSQL if they are going to involve very large/complex data sets. Or if the client requires some other … Continue reading HF SQL Doesn’t support complex Update Statements →

Bug when translating strings in the Code Editor

Using the Google Translate Button when Translating Strings in Code does not Save Changes When you right click on a string in the Code editor and chose translate from the popup menu, then just use the Google Translate button to do the translations, the changes do not get saved. It shows them on the screen … Continue reading Bug when translating strings in the Code Editor →

WebDev Publishing Parameter File

When multiple people work on a WebDev project, sometimes more than one person needs to be able to publish an update to the site. If you have ever published a site you know there are quite a few parameters and passwords that you have to get correct. Instead of having to share all of that … Continue reading WebDev Publishing Parameter File →

Handling a Large PostgreSQL Installation Article by Instagram

Just so you don't think Uncle Pete has forsaken PostgreSQL Instagram has one of the largest PostgreSQL installations in the world, and they just recently posted an article on their blog with 5 tips for handling large PostgreSQL installations. http://instagram-engineering.tumblr.com/post/40781627982/handling-growth-with-postgres-5-tips-from-instagram The first two are of the most interest to us developer types, their use … Continue reading Handling a Large PostgreSQL Installation Article by Instagram →

FileZilla FTP Server on Amazon AWS

Wolfgang was having some issues following my articles to setup his WebDev server on Amazon. We discovered that the difference is in the way Amazon does their elastic IP assignments. I am not an Amazon expert, but my understanding is you have a public IP and a private IP. The issue is with the way passive mode of FileZilla … Continue reading FileZilla FTP Server on Amazon AWS →

Web Design Resources

With the recent WebDev Article I have posted, folks have asked about the resource's I use for web development, this isn't an exhaustive list but a good place to start. Google Do I really need to say anymore? Where do you think we found all of these resources? Color Schemer Online A handy tool to … Continue reading Web Design Resources →