String within sql statement
Posted on 2006-03-27
hi, nice easy one for first thing mornday morning :)
I need to add "JDC" as an exception in my Where section, what am I doing wrong?
cmd.Connection = conn
cmd.CommandType = CommandType.Text
cmd.CommandText = "SELECT Surname, FirstName, EmployeeSkills.EmployeeId, SkillsName, SkillLevel, " & _
"Convert(varchar(10), ExpiryDate, 103) as ExpiryDateOnly, CardColour, AccDescription FROM EmployeeSkills " & _
"LEFT JOIN SkillLevel ON (SkillLevel.SkillLevelId = EmployeeSkills.SkillLevelId) " & _
"LEFT JOIN SkillsType ON (SkillsType.SkillId = EmployeeSkills.SkillId) " & _
"LEFT JOIN Employees ON (Employees.Employeeid = EmployeeSkills.EmployeeId) " & _
"LEFT JOIN AccRoute ON (AccRoute.AccRouteId = EmployeeSkills.AccRouteId) " & _
"Where EmployeeSkills.EmployeeId = EmployeeSkills.EmployeeId and EmployeeSkills.SkillId = EmployeeSkills.SkillId and trainingtypeName <> " JDC "