error reasing database file

[John]

can somebody tell me what's wrong wth this code ?

IF Request.QueryString("YEAR") <> "" THEN
SELECT * FROM tblMatches ORDER BY Year DESC,
END IF

I'm getting an error message: "Server error: Unable to retrieve schema
information from the query:"

I'm working on a Web site that reads a simple database file created in
Access.

The Web site has an asp page called results.asp and I used Frontpage to
design it. Part of the asp page is a table (comes standard with Frontpage)
and this table gets filled with the data from the database file based on a
custom query

There are 3 scenarios:

1. I need to display all the data from the database file and the URL and
custome query look like this:

http://localhost/data/result.asp

SELECT * FROM tblData ORDER BY Year DESC,

2. I need to display all the data that match certain year

http://localhost/data/result.asp?Year=2006

SELECT * FROM tblData WHERE (Year = ::Year:
ORDER BY Year DESC


3. I need to display all the data that match certain name

http://localhost/data/result.asp?Name=Smith

SELECT * FROM tblData WHERE (Name = ::Name:
ORDER BY Year DESC

My question is how do I combine all 3 above SQL statements into one.

TIA

 

[Evertjan.]

John wrote on 01 jan 2007 in microsoft.public.inetserver.asp.general:

can somebody tell me what's wrong wth this code ?

IF Request.QueryString("YEAR") <> "" THEN
SELECT * FROM tblMatches ORDER BY Year DESC,
END IF

IF Request.QueryString("YEAR") <> "" THEN
sql =" SELECT * FROM tblMatches ORDER BY Year DESC"
END IF

You cannot mix sql ans vbscript at [pseudo]random