Sorting my search result= gives back all my records

[Beat]

I have a search function which lists the records that match the the search.

Then I have a listbox that gives the user an option to sort the results.

But, when I sort the results it refreshes the page with all the records sorted. It seems to forget my search variable.

Where is the problem?

Thanks!

 

[Cheech]

Maybe try passing your SQL to a variable & then adding to the string with the ORDER BY added to the end as your new statement I dont want to go to Chelsea!!!

 

[jisoo22]

Hello!

I kind of have the same problem, I have a search page that has three different parameters...recordID, LastName, FirstName. The problem is that no matter what combination I try the results page shows ALL records, not just the one(s) that match the search parameters. Heres' my SQL statement on the results page recordset:


SELECT *
FROM Main_Table
WHERE Record_ID LIKE 'varRecordID' OR LastName LIKE 'varLastName' OR FirstName LIKE 'varFirstName'


Each variable has been set up like this:

Name Default Value Run-Time Value

varLastName % Request.QueryString("LN&quot
varFirstName % Request.QueryString("FN&quot
varRecordID % Request.QueryString("ID&quot

Does anyone know how to get the results page to work properly? I need it to find specific records whether it's one variable or two or three.

Thanks,
Jisoo22

 

[Cheech]

Maybe use AND instead of OR? I dont want to go to Chelsea!!!

 

[jisoo22]

Tried AND, got the same kind of messed up result. Any ideas? I'm open to anything!

Jisoo22

 

[Cheech]

Response.Write the SQL to the screen, it looks like your variables are not picking up a value and therefore are using "%" so are pulling everything out of the database. Live long and make your kids suffer..