Displaying Results chosen from a range.


hi, have webpage i'm trying display name of people within age range. way i'm trying set have group of links example,
18-25
26-35
36-45
and when 1 of age range selected display name of people in database fall age range. need know how tell coldfusion select names ages within selected range.

proper way:
add ranges table db , cross-table link persons particular range. list of ranges have corresponding rangeid ranges table, pass on , make selection of names display based on same range id being assigned name in cross-table.

improper way:
treat selected range's value list "-" delimiter. have min age , max age. select names whos age gte min , lte max. need pass 2 params query/next page: min age , max age.


More discussions in ColdFusion


adobe

Comments

Popular posts from this blog

opencv3, tbb and rasp pi 2 - Raspberry Pi Forums

small ethernet problem - Raspberry Pi Forums

Multithumb configuration params not working? - Joomla! Forum - community, help and support