An organization I work with recently hired a firm to redo their website. This includes both HTML and CF.
A problem cropped up on a portion of the work. I looked at their code and found they were using reserved words for field names, e.g. Year. The query worked when I pulled it out and plugged it into MS Access (2003) but choked when ran through CF7 running on a new webserver running Windows 2003. I changed the field name to an unreserved word (and futzed through their code making corrections) and we hopped right past the previous chokepoint until it hit another reserved word they had used. In going back to them they continually ignore us about using reserved words and keep looking for other solutions. They asked us to change the CF administrator from Access with unicode to just plain Access and now it seems to work (although there are other problems cropping up). My question: isn't their approach just applying a bandaid to the wound? My recommendation is to make them toe the line and redo the code (and tables) so reserved words are not improperly used. Larry V. Stephens Indiana University Office of Risk Management [EMAIL PROTECTED] 812-855-9758 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265955 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
