Line 1: Incorrect syntax near '='.

dc · September 7th, 2005, 09:21 AM

has come across this error??

Code:

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 · September 8th, 2005, 08:10 AM

Try this:

Code:

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