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!