I've written following code which while running in SQL Query Analyzer gives no error...but as soon as I try using it in my asp file...it shows me following error--

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Line 1: Incorrect syntax near 'M'.


The code that I've written is--

If not(order_string="")then
  strSQL="SELECT * FROM MASTER M,Reference_company R"
  strSQL=strSQL & "WHERE M.CompanyRefKey = R.ReferenceKey"
  strSQL=strSQL & "ORDER BY "& order_string &""
Else
  strSQL="SELECT * FROM MASTER"
End if


Can anyone help?? Wats the error?? Why is it showing me error??

I think it is because you need two spaces in your query. On the where and order by lines there was no space.

strSQL="SELECT * FROM MASTER M,Reference_company R"
strSQL=strSQL & " WHERE M.CompanyRefKey = R.ReferenceKey"
strSQL=strSQL & " ORDER BY "& order_string

http://mynameissteve.com

thanx...u caught the correct error!! Thanx!