hwg-languages archives | Sep 2000 | new search | results | previous | next |
ASP Database Queryingby "Valerie L. Criswell" <valerie(at)suresource.net> |
|
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