You are correct, I left off the Request.Querystring in the posting
here because that I assumeb we all know had to be included.
One More Question
I have two pages
Page One Has a Link
which looks like
when it is passed through the browser
So LET is defined as 'A%'
Page Two Requests the querystring
LET = Request.QueryString("LET")
sSQL = "SELECT * FROM Bands Where BandName Like " & LET
I just want the page alph.asp to display records that start
with A if I click A on Page One or records that start with
B when I click B on Page One
Is my url written wrong?
Is the Select line wrong?
I did this same think with the BID and it worked fine
Then again I was looking for one record and not a
bunch that start with one letter.
I tested this with
sSQL = "SELECT * FROM Bands Where BandName Like 'A%' "
So how do I tell the second page what letter to put 'HERE%'
And allow the second page to accept it?