Tuesday, November 27, 2007

projectId != projectid

Any ActionScript, JavaScript, Java, etc. programmer knows about case-sensitivity. The languages are very picky, thus projectId is not the same as projectid. However, ColdFusion and T-SQL aren't picky. SELECT is the same as select -- is the same as . After moving a demo from my local development environment to a staging server I discovered the hard way that Flex treats returned column names as case sensitive variables. When I created the view on the staging server, I made the mistake of not properly camel casing projectId. Hopefully, this is a mistake that I will not make often.

No comments: