I’m currently working on a project where we are importing data transactions on a daily basis and need to compare the imported file with the current file. One of my favorite SQL clauses is the NOT IN clause, which I have used many times to do comparison type queries. Quite often, this powerful clause will […]
Archive | May, 2007
Don’t Make Any Assumptions
Many of you will have implemented systems within your organisations. You may have found that even things that seem relatively simple at first thougth, turn out to be more complex and challenging. But this surely is a fact of life, not just systems or web implementations? I’ve always set and worked towards goals, both personally […]
Goodbye Blog Comment Spam
If you’ve been blogging for a while you will have noticed how the spam community (if I may call it that) arbitrarily posts its sticking crud to your blog as comments. Lord knows why they bother. But a pain in the butt they are to boot! I’ve been manually dealing with this for a while, […]
PayPal Payments Pro 4.2
I’ve just upgraded a clients payment system to use the Paypal API. One new feature that I like is the API signature option for verification. Previously you had to download and install a server side certificate to verify payments through the API. This was quite easy to do but you have quite a number of […]
