I am running it locally and it works fine with using: SELECT TOP 1 ..blah blah..
But on another server it errors out For reserved word. Why the difference? Both are Windows based OS as well as identical code. Same setup, same directory structure. -----Original Message----- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Monday, October 03, 2005 11:10 AM To: CF-Talk Subject: CFMX 7 Reserve Words? Does anyone know where I can find a list of Reserved Words for CFMX 7? is TOP 1 an issue for CFMX 7? I am getting the error that a reserved word was used in my select statement Thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219884 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
