Display the result of a search from a textfield 1

[Beat]

I have read heaps of tutorials and tips in this matter, but I can't get it to work!!!

I have a textfield where the user enter something to search for, and on another page the result is supposed to be listed.

When I try the SQL statement in the advanced Recordset dialogbox, by entering different "Default Values" it works just fine, but when I try entering a search in the textfield it lists all my records!!!???

I have the textfield in a form with method POST. I have also tried GET.

I have another page where the result should be listed. As "Run-Time Value" I'm using Request. I've also tried Request.QueryString.

Does it makes sense? Can you understand my problem?

Please answer with questions if you don't really understand but think you may have a solution.

Ta!

 

[EugenePaliev]

Hello Beat!

You may use Post or Get methods - it doesn't change anything in your case.

Let's try to understand where the problem is.
1) does your search work in any way or it crashes? As I understand it works but not in the way you want it to work.
2) if it works and the only problem is that it lists all records:
a) may be all your records have search word?
b) if not, there is probably mistake in SQL statement.

Hope you'll answer and we'll try to fix it.

Good Luck!

 

[Beat]

Ta Eugene, for taking the time!

I've sorted it out now. I went back and did it all again, and all of a sudden it worked just fine!!

So my experience here is, that it is pretty hard to debug when you have worked with somethin for a while. It saves you time to just do it again.

Thanks anyway, Eugene!

 

[jisoo22]

Hello Beat,

Have you had any luck with multiple textfields? I have the same problem, all the records show up no matter what I put into the text fields.

Jisoo22

 

[Beat]

To jisoo22!!

I had just one textfield but i searched in several columns.

What was wrong when I posted this question, I dont know, because I just started on a new page and did it all again from scratch, and it worked!!!???

So, my advice is, do the page again!!

Good Luck!!