Search/Results pages

I have 2 pages.
Search page with single dropdown menu searching Categories, and a Result page that displays Special offers within that category. My result page either shows all records or none. In Data assist search, under Default WHERE clause I played with 0=0 or 0=1 and these are the results I get. Am I missing something?

send a copy of your pages please and a link where I can see the problem.

Here is the link to the page.
http://www.palmbeachgrapevinedirectory.com/SOcatONLY.php
Enclosed are the files

the trigger for the data assist search behavior is set to use any form post, but the search form uses the get method.

on the bindings panel, click the plus button and select URL Variable. name the new URL binding "WADbSearch1"


In the Data Assist Search behavior, click the lightning bolt next to trigger and select the WADbSearch1 URL variable.

Thank you!!! It worked!

Hi Jason,

I've followed the recommendation of this thread, however, I have a problem - I have a Search page that searches by 3 different criteria. When I search by the price or keyword - the search works fine, however, when I search by the Service Name (using one or two words) - it returns all results in database.

I've tried different combinations of the DataAssist Search behavior (AND, OR, Value, Edit, Keyword), nothing solves the problem.

Please find the attached search and results pages.

Please advise.

Thank you so much in advance.

Best regards.

P.S. Also, please see the PM for the link to these pages.

[/quote]however, when I search by the Service Name (using one or two words) - it returns all results in database.[/quote]

I'm not able to reproduce this, i entered:
test

in the Service Name field and no results where returned.

Dear Jason,

Thank you so much for your reply.

If you will enter "CADx" (no quotes) into the Title field on the search page, all products will be shown even though the word "CADx" is present only in the first two products.

Thank you.

still not able to reproduce.

I entered CADx in the keywords text filed, and that directed me to the following URL;

http://www.telebirads.com/products_results.php?ProductName=&ProductPrice=&ProductMetaKeywords=CADx&Search=Search


with no results.

Please enter the CADx into the first field (Title)...

Because if you enter "350" into the "Price Field" or "teleradiology" into the Keywords field - it finds the correct services....

But nevertheless, it should show two products in the results and not the "no results"...

Any idea why?

Thank you so much