Dynamic DropDown with DataAssist Search

Hi,

I have a setup for a search where the Country drop down is tied to the regions of that country. So if France is selected from Country, then the Region (Area) lists the correct regions.

That works, but when the search button is clicked it goes to the results page and does not display the results. I think I am missing something on the results page to correctly pull the data.

I have attached the two pages.

thx
Eric

to help debug, add the following code on the results page just before the closing </body> tag:

<?php echo($query_rsProp); ?>

and send a link to your search page.

Thanks Jason.

It looks like Area is not carrying over to the query?

Here is the results:
SELECT InternationProps.intpropID, InternationProps.DateAdded, InternationProps.SearchType, InternationProps.PropertyTYPE, InternationProps.PROPERTYREFERENCE, InternationProps.Title, InternationProps.Country, InternationProps.Description, InternationProps.Area, PropTypeInternation.IntPropTypeID, PropTypeInternation.TypeName, InternationProps.Area, InternationProps.Kitchen, InternationProps.Bedrooms, InternationProps.Bathrooms, InternationProps.Office, InternationProps.Gararge, InternationProps.Rooms, InternationProps.Shower, InternationProps.LivingSpace, InternationProps.Price, InternationProps.RentalPrice, InternationProps.LivingArea, InternationProps.OtherRooms, InternationProps.KitchenEquipment, InternationProps.ElectricalEquipment, InternationProps.OtherEquipment, InternationProps.Windows, InternationProps.Flooring, InternationProps.Walls, InternationProps.Services, InternationProps.OtherServices, InternationProps.LanguageSopken, InternationProps.Ceiling, InternationProps.AgentContact, InternationProps.DisplayOnSite, InternationProps.OrderLabel, InternationProps.GoogleMap, InternationProps.MainPhoto FROM InternationProps INNER JOIN PropTypeInternation ON InternationProps.PropertyTYPE = PropTypeInternation.IntPropTypeID WHERE DisplayOnSite = '1' AND (Country = 'France') AND (SearchType = 'Rental') AND (Area = 0) ORDER BY OrderLabel DESC

area is numeric column, it looks like you are trying to pass a text value to it.

Okay - changed the numeric to text and the result is
ON InternationProps.PropertyTYPE = PropTypeInternation.IntPropTypeID WHERE DisplayOnSite = '1' AND (Country = 'France') AND (SearchType = 'Sale') AND (Area = 'France') ORDER BY OrderLabel DESC

Now area is France instead of the region name or the region number.

thx
e

is it working like that?

No, I need to be passing the numeric value of the region IareaID into Area. The drop down on the search page is setup to pass the id number (or apparently not) but I don't see the issue.

thx
e

in the create dynamic array behavior, you have set the Child Value to sue the Country column not the areaID column

I just saw that :)

THANKS!! It is working now!!

Have a great weekend!