Thanks Chuck! That was the problem ;-) thanks a million! It pays to read the manual I guess.
Bob -----Original Message----- From: Chuck [mailto:[email protected]] Sent: Friday, September 11, 2009 5:58 PM To: cf-newbie Subject: RE: query woes Bob, The column When might be causing the problem. 'When' is a reserved word in MySQL. I would suggest escaping the column name with `. Like so... `When`. HTH Chuck ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4806 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
