Search results for query: *

Sorry to keep posting, but I am at a standstill. The problem lies within the " before ORDER BY. It is reading this as an end statement. If I change this at all I get the "Internal Server Error" message.

Sorry, My post didn't show correct "unexpected end of statement" location. The error was: + " ORDER BY " + Replace(rsResults__sql_orderby,"'", "''") The error arrow was on "BY" at + " ORDER BY "

I'm getting this error message: Microsoft VBScript compilation error '800a0401' Expected end of statement /busdirectory/search_results.asp, line 71 rsResults.Source = "SELECT * FROM businesses WHERE approved = 'Yes' AND Address_1 like '%" + Replace(rsResults__varKeywords...

Example of search and results: Searched between 50000 and 100000. Results of 50000, 150000, 350000, 450000. Basically and entry which includes 50000.

I've shortened the statement a bit. The statement is running, but not correctly. When searched price range of 50000 to 100000, I'm getting results of any DB entry that includes the 50000 integer only. The 100000 does not seem to be acknowledged. I'm sure its the "like" operator but no...

I have written this to the best of my knowledge but can't get it to run with the (Request.QueryString("menuPrice_range") & Request.QueryString("menuPrice_range1")is utilized. This is my results page for a MS Access database query. For some of you guys this will probably be a...

How do I write a range search query (such as a price range or date search) in .asp with a database written in Access 2000. Thanks for your time!