[transfer-dev] Re: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near '.'

2009-01-20 Thread Jorge Loyo
> Could it be that "user" is a reserved word in SQL?  Try changing the > alias of your table to something else. You are right sir... This fixed it. Thank you! --~--~-~--~~~---~--~~ Before posting questions to the group please read: http://groups.google.com/group/

[transfer-dev] Re: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near '.'

2009-01-20 Thread Bob Silverberg
Could it be that "user" is a reserved word in SQL? Try changing the alias of your table to something else. Bob On Tue, Jan 20, 2009 at 11:38 AM, Jorge Loyo wrote: > > I got version 1.1 > > This is the SQL generated: > > select user.userId, user.first_name, user.last_name, user.email, > user.pa