Paging ASP code for SQL DB error in strSQL
Posted on 2001-09-09
I am trying to implement a paging code into my search results page and I keep getting this error when I click on the link to go to the next results page.
I can't figure out what's wrong with this statement. I would appreciate feedback. Thank you for your help.
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Incorrect syntax near the keyword 'ORDER'.
/idx/scripts/property_type.asp, line 39
This is my strSQL below:
strSQL = "SELECT TOP 50 * FROM detail_p0 WHERE STATUS LIKE 'A' AND PROP_TYPE = " & Request.Form("prop_type") & "ORDER BY PRICE_CURRENT ASC, AREA ASC"