Well the client is using MS Access. So I setup my local for the same thing. Mine works, his does not.
-----Original Message----- From: Dave Ashworth [mailto:[EMAIL PROTECTED] Sent: Monday, October 03, 2005 11:28 AM To: CF-Talk Subject: RE: CFMX 7 Reserve Words? Could it be SQL Server (assuming this is what you're using) as I had a similar problem in that on one server code worked fine but on another it didn't (when using a stored proc to update a text field) and the reason was that one had SQL Server SP4 and the other didn't -----Original Message----- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: 03 October 2005 16:22 To: CF-Talk Subject: RE: CFMX 7 Reserve Words? 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:219887 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54