54 Posts
10 years ago
1
Topic
I've created a text field called field_length where users input numerals.
The data is stored in its own field_length column in #__cck_store_item_users.
Then I've set up a dynamic select list in the search form to retrieve values from that column-
I would like the select list to display options by range, instead of absolute values, that is to say:
-1 to 20
-21 to 40
.> 41
Think you get the idea.
How would the full SQL statement look like to make this possible?
The data is stored in its own field_length column in #__cck_store_item_users.
Then I've set up a dynamic select list in the search form to retrieve values from that column-
I would like the select list to display options by range, instead of absolute values, that is to say:
-1 to 20
-21 to 40
.> 41
Think you get the idea.
How would the full SQL statement look like to make this possible?
54 Posts
10 years ago
0
Level 1
The Numeric select list would be perfect if it could draw values from a specified table.
It pretty much does what I have in mind, except that it won't query columns other than the one where it stores values, meaning that the input must be a range too, instead of a single value store from an input text field.
It pretty much does what I have in mind, except that it won't query columns other than the one where it stores values, meaning that the input must be a range too, instead of a single value store from an input text field.