ASP error happened
| Technical information | |
| Error number | -2147217900 |
| Error description | [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '[jobs.ID]='. |
| URL | /jobbank3/jobs_view.asp |
| SQL query | select [Title], iif(isnull(City),'',City) + ', ' + iif(isnull(state),'',state)+' '+iif(isnull(Zip),'',Zip) as Location, jobtype.Type as Category From [jobs] left join jobtype on jobtype.ID=jobs.TypeID where [jobs.ID]= |
| Solution | |
