type mismatch expression when querying 2 tables

[gavray]

hi,

If you look at the code below, what I'm trying to do is display info from both tables
The jobtable has the companies id for each job, but the strID relates to the actual job id.

I'm getting an error 80004005

type mismatch in expression, can anyoen help


sSQL="SELECT JobTable.*, CompanyTable.* FROM JobTable, CompanyTable"
sSQL=sSQL & " WHERE CompanyTable.ID = JobTable.CompanyID"
sSQL=sSQL & " AND JobTable.ID= " & strID & ""
sSQL=sSQL & " ORDER BY JobTable.Salary;"

Gavin

 

[swilliams]

Try not putting the & "" at the end of the third line.

Simon

 

[gavray]

On both suggestions it produced the same problem.):

 

[palbano]

Gavin,

Try writing the value of sSQL variable out to the browser and then copy and past the sql statement into your database environment and execute it in there. The error you are getting is from your DB not from ASP.

-pete