Hello all
I am facing an error message next to those sql statement , so can you please help me by writing it in a correct way that can be work! an errors message is: Incorrect syntax near the keyword 'AND'.
@"SELECT JobNum, Dept, PubDate, EndDate, Employer,VacCountry, VacState,
VacCity, Jobtitle, CompLogo, Wtag, SUBSTRING(jobdesc,1,40) as jobdesc FROM jobs WHERE VacCountry = @Location and CHARINDEX(@Wtags, Wtag)>0 ORDER BY PubDate DESC;
string query = @"SELECT UID, Country, State, City, Wtag,Logo, Website, UsrType, BizCateg, BizSubCateg, Twitter, GooglePlus,Facebook, CompNme,SUBSTRING([CompDesc],1,40) as CompDesc From UserInfo where Country = @Location and UsrType = 'Business' and CHARINDEX(@Wtag, Wtag)>0 ORDER BY [RegDate] DESC";