Line 1: Incorrect syntax near '='.

[dc]

has come across this error??

Code: Select all

Line 1: Incorrect syntax near '='. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near '='.

Source Error: 


Line 190:                sqlCmd.Connection = empConn
Line 191:                sqlCmd.CommandText = query
Line 192:                reader = sqlCmd.ExecuteReader()
Line 193:                If reader.Read Then
Line 194:                    caption = reader("roleAbbreviation")
 

Source File: c:\inetpub\wwwroot\TestEnviron\Default.aspx.vb    Line: 192 

Stack Trace: 


[SqlException: Line 1: Incorrect syntax near '='.]
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
   System.Data.SqlClient.SqlCommand.ExecuteReader() +42
   DropDownList.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\TestEnviron\Default.aspx.vb:192
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +750

[Smokie]

Try this:

Code: Select all

While reader.Read() 
 caption = reader("roleAbbreviation")
End While