Thanks very much, that helps me a lot. It has shown me how to manage and interface this.

I do have some issues to address which really confuse me. Let me just ask, because maybe you can provide some insight. Here is the same link, after the change was made, as you recommended,

www.effords.ca/SimX2/index.php/simsearch/demo-search

All I did was to change the WHERE in the SQL as follows, from,

WHERE
LocCountry LIKE "Canada"
AND
EngMaker LIKE "GE"
AND
RegApprovals LIKE "%Level D%"

to become, based on your last post,

WHERE
LocCountry LIKE "Canada"
AND
({$REQUEST:form:fEngineMaker|empty:""} = '' OR EngMaker = {$REQUEST:form:fEngineMaker|empty:""})
AND
RegApprovals LIKE "%Level D%"

The issue is the new line in the ARI DataTables table with an "RR" under EngMaker (the 8th row down). This should not be pulled and was not pulled when the SQL WHERE was hard coded to EngMaker LIKE "GE". Any ideas why?

I scoured the database looking for any data errors but found none. The EngMaker field in the "Simulators" database table simply has "RR" for this entry, nothing else. There is another field in this same record with a GE string but that is in another field altogether. I tested whether it still might cause by removing the GE string, but with no effect. The RR record was still pulled. I am at a loss as to why.

Ken

Could you provide a temporary access to your J! backend by email so we can investigate the problem? For example the following link works fine:


www.effords.ca/SimX2/index.php/simsearch/demo-search?form[fEngineMaker]=GE


Regards,
ARI Soft

I am sure the issue relates to how my site is currently setup. I think that because the form data is not posted the REQUEST variables are not set. There just happens to be only one record in CANADA that is not GE, so it looks like it is pulling this incorrectly. I am sure the fEngineMaker variable is not set.

What is the purpose of the first part, $REQUEST:form:fEngineMaker|empty:"", of your call? What does this part do? The second part I get, this is where the database entry is compared.

Ken

This problem with behaviour of used form. After submit, it redirect to the same page, but without submitted parameters. You can contact RSForm developers to get more details about it.

When the page is opened first time, request variables are not set and {$REQUEST:form:fEngineMaker} variable doesn't exist. "empty" function is used to specify default value if the variable is not defined.

Regards,
ARI Soft

Thanks again for your help. I suspected this was the root cause and I will address through the form extension I am using.

Ken