Dynamic data filters

Report · May 17, 2006

Hi all. Small problem from a beginner.

I have several lists on a page populated by recordsets from a db server. All hunky-dorey with static filters. What I want to do is to filter the records for recordset #2 based on the user's selection from list # 1. For example "choose a country" and then "choose a region" where the region list / recordset is filtered by the country choice.

The SQL is no problem but I cannot find a way to have a variable for the query for recordset # 2 refer back to the current value in list # 1. Have reached the conclusion that a session variable may be the answer but don't know how to initialise it with the value from list # 1. Or perhaps I'm miles off!!

Any thoughts?

Thanks

Charles

Report · May 17, 2006

Here you go:
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19117

"Lindy's Husband" <webforumsuser@macromedia.com> wrote in message
news:e4fo2a$o7s$1@forums.macromedia.com...
> Hi all. Small problem from a beginner.
>
> I have several lists on a page populated by recordsets from a db server.
> All
> hunky-dorey with static filters. What I want to do is to filter the
> records for
> recordset #2 based on the user's selection from list # 1. For example
> "choose
> a country" and then "choose a region" where the region list / recordset is
> filtered by the country choice.
>
> The SQL is no problem but I cannot find a way to have a variable for the
> query
> for recordset # 2 refer back to the current value in list # 1. Have
> reached the
> conclusion that a session variable may be the answer but don't know how to
> initialise it with the value from list # 1. Or perhaps I'm miles off!!
>
> Any thoughts?
>
> Thanks
>
> Charles
>