Today we were trying to join 2 fields from different tables with a left outer join. This means that if there is nothing in the joining table the rows are returned as null. By default SQL wont give you a result in the joining request. Lets have an example. You want to get categories and […]
DeveloperCircuit.com is a new job site that is looking to put a spin on the way developers look for jobs. Seek and CareerOne in Australia are the big players, and when you post a job advert on there, you get all sort of people applying, some who dont even have the skills you require. The […]
I read with great interest this morning that Mark Drew has released a plugin for CFEclipse that helps you out if you work with ModelGlue, Fusebox, or Mach-II. Other frameworks can be added too, like Transfer ORM, because the whole system is XML driven. This is HUGE! It looks like some features are: Automagically determining […]
I have been looking for an elegant solution for this for a while, one that doesnt have limitations like forcing you to have fixed width divs because thats the size of the background image. Of course in the old days we did this with an extra table row but that was just painful. I am […]
Here is a discovery that I came across recently while working on a clients mass mail system. I upgraded to Outlook 2007, and being the first to do so in the office have been discovering some of the cool new features. And it was all very cool until close to the clients deadline and I […]
Scary stuff. However its easy to fix. For example if we are using databaseuser01 to access this database simply run this has something to do with SQL enforcing a password policy on the user, however I don’t know the details.
Recently I set up a SubVersion server for my company, and with all good things comes some pain. Authentication, compatibility of components, backup, training, hardware are some of the things you have to take in to account. Its not an easy thing to do, setting up I find takes a few days and maintenance is […]
Are you thinking about starting to use Source control such as SVN or CVS for your company or work? Your first decision is SVN or CVS – let me help, SubVersion. Plenty of other people discuss why, so go find their articles. But should you do it yourself? Or should you go find someone to […]
I have seen many different ways of doing this, but to my knowledge this is the most accurate way. Using SQL you can have your database return the distance between 2 sets of Lat and Long points, and using some math functions also take into account the curvature of the earth. Admittedly if you are […]
