cyberholic
Member
Good day everyone,
i have a list and form with the title "products". I created a second form so that i create a Module
out of it to use it as Search module (just like in a shop where you can filter or pre-search for products).
Everything is working fine - on whatever page i am, when i use the Module, the page with the whole
List comes up depending on the options i set via the module.
The options to search for are:
Title, type of fruit, origin, word in discription
My Problem:
Type and Origin are DropDown elements. So it does not matter what i enter in Title or discription,
the result page ALWAYS sets the TYPE OF FRUIT element and ORIGIN to the first value.
In SQL theory the result is like
SELECT * FROM groceries WHERE title ="" AND type_of_fruit ="Apple" AND origin = "From Belgium" AND
discription = ""
What i want is to change is that there is no pre-defined value from the dropdown. In the example: Apple and From Belgium should be empty too.
I hope you understand what i mean and thanks for your time!
Carlos
i have a list and form with the title "products". I created a second form so that i create a Module
out of it to use it as Search module (just like in a shop where you can filter or pre-search for products).
Everything is working fine - on whatever page i am, when i use the Module, the page with the whole
List comes up depending on the options i set via the module.
The options to search for are:
Title, type of fruit, origin, word in discription
My Problem:
Type and Origin are DropDown elements. So it does not matter what i enter in Title or discription,
the result page ALWAYS sets the TYPE OF FRUIT element and ORIGIN to the first value.
In SQL theory the result is like
SELECT * FROM groceries WHERE title ="" AND type_of_fruit ="Apple" AND origin = "From Belgium" AND
discription = ""
What i want is to change is that there is no pre-defined value from the dropdown. In the example: Apple and From Belgium should be empty too.
I hope you understand what i mean and thanks for your time!
Carlos