Larry, I am not trying to criticize the institution or the client or to reiterate the rhetoric that Access just simply is a troubled solution.
As for the reserved word usage, that just needs to be changed to avoid the exact issue you are having. It is a reserved word on purpose. With Access, I believe you can have aliased columns in cfqueries. It would not be hard to grep or wingrep which template or queries use the wrong columns names and replace them with just a slight variation. SQL Server does this nicely by putting square brackets around reserved word columns. I am not sure that is Access compatible. e.i. [year] If cost is the concern, MySQL and other reliable solutions are perfectly available and offer greater performance. Teddy On 1/8/07, Stephens, Larry V <[EMAIL PROTECTED]> wrote: > > 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:265956 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
