[SqlException: Line 1: Incorrect syntax near '.'.]

  • Thread starter Thread starter Roger R. Smith
  • Start date Start date
R

Roger R. Smith

I see this error in my ASP .NET code:

[SqlException: Line 1: Incorrect syntax near '.'.]

I am trying to execute the following:
private const string SQL_SELECT_USER = "SELECT User.Email, User.FirstName,
User.LastName, User.Status, User.Phone, User.Privs FROM User INNER JOIN
Login ON User.UserId = Login.UserId WHERE Login.UserId = @UserId AND
Login.Password = @Password";



Any ideas here?

Thanks

Rog
 
"User" is a reserved keyword on SQLServer

Use Brackets "[]" like [User] instead of User.

hth
Uwe
 
Thank you very much Uwe. That was it!
thank you for taking the time to help me.
Rog


Uwe Hafner said:
"User" is a reserved keyword on SQLServer

Use Brackets "[]" like [User] instead of User.

hth
Uwe


Roger R. Smith said:
I see this error in my ASP .NET code:

[SqlException: Line 1: Incorrect syntax near '.'.]

I am trying to execute the following:
private const string SQL_SELECT_USER = "SELECT User.Email, User.FirstName,
User.LastName, User.Status, User.Phone, User.Privs FROM User INNER JOIN
Login ON User.UserId = Login.UserId WHERE Login.UserId = @UserId AND
Login.Password = @Password";



Any ideas here?

Thanks

Rog
Click to expand...
Click to expand...
 
Back
Top