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.
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.
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
Post a Comment