ASP Database Querying

by "Valerie L. Criswell" <valerie(at)suresource.net>

 Date:  Wed, 13 Sep 2000 20:46:23 -0400
 To:  <hwg-languages(at)hwg.org>
  todo: View Thread, Original
In my ASP noviceness, I seem to be unable to get the syntax right for
passing a QueryString value into my Select statement.  Can any of you tell
me how to properly write the QueryString into my Select statement?  I've
tried all the various syntaxes I could find in my books and online
tutorials.  I feel so frustrated.  *sigh*

Fact:  The database is Access 2000
Fact:  The goal is to query the GameDate field of the database and report
the matching records in an HTML table.
Fact:  The QueryString and the field it must match are of Date type
Fact:  My ASP code works perfectly when the date is hardcoded into the
Select statement
Fact: I have tried changing the QueryString into a variable before putting
it into the Select, but I thought perhaps that was interferring with the
necessary date type.  If this is part of the answer, please still show me
how to plant the variable into the Select.

The QueryString is sent from test.htm as follows:
http://www.schighschoolsports.com/scores/football/test.asp"?date=#8/25/2000#
>
and is located at:
http://www.schighschoolsports.com/scores/football/test.asp

Currently, the Select statement looks like this, although it has morphed
many times today!

Sql = "SELECT GameScore.GameDate, GameScore.HomeTeam,
GameScore.HomeTeamScore, GameScore.AwayTeam, GameScore.AwayTeamScore  FROM
GameScore  WHERE GameScore.GameDate =  Request.QueryString("date") "

Thanks in advance to those who take the time to help.  I'm indebted to those
who participate in the HWG lists.

~Val

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA