Classic ASP Discussion - Searching and Paging with ASP and Access 2000

Print Page | Close Window

Searching and Paging with ASP and Access 2000

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=23136
Printed Date: 28 March 2026 at 11:23pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Searching and Paging with ASP and Access 2000

Posted By: mkbutler
Subject: Searching and Paging with ASP and Access 2000
Date Posted: 17 April 2007 at 8:39pm

lLet's try another one 'cuz you guys are gooood!

I have SearchForm.asp with the following

Drop down called TypeSearch which selects the field from the database
Text box called SearchBox which allows the user to type in what they are looking for

This is a POST with name = "SearchForm"

The on SearchResults.asp

I am wanting to display the matching records with paging. My Sql is built into an If Then Else statement:

If Request.Form("TypeSearch") = "txtYear" Then
   strYear = Request.Form("txtYear")
   Sql = "Select Title From Titles Where Titles.[Year Published] = " & strYear
Else
   ... alot more If statements like the one above for all of the other fields
Else
   'what would I put here to have it set equal to the value of the previous queryString which may or may not be a YEAR query
End If

I don't fully understand QueryString(whatever)

Thanks for all of your help!