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.
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 […]
Since we went through and geocoded all of the Australian postcodes and suburbs we have found ourselves finding all sorts of uses for it, and have been madly going through projects and using this data. We have the data in our master code database, and in order to make use of it in a clients […]
I have all of my photos over on Flickr and wanted a small blogCFC pod on the right side to display the most recent uploads. Here is how I did it. First create a new pod within blogcfc, this is easily done by going to the /tags/layout.cfm and adding a line in amongst the other […]
