Using a drop down to populate another drop down using dynamic data

[Newsgroup_User]

I know this question probably has been posed a million times...

I want to make 2 drop down lists. The first is static and have 3 options.

<select name="type" id="type">
<option value="1">Dogs</option>
<option value="2">Cats</option>
<option value="3">Rabbits</option>
<option value="4">Small & Furry</option>
</select>

When selected, the type needs to be passed to a sql statement:

<cfquery name="GetABreeds" datasource="request.dsn">
Select breed, name
From pets
where type = #form.type#
</cfquery>

And the results (GetABreeds) get used to populate the 2nd drop down.
<select name="type" id="type">
<option value="#dombreed#">#name#</option>
</select>

Anyone know where I can find how this is done. I found some, but they all
deal with static arrays.

[Newsgroup_User]

Anyone know where I can find how this is done. I found some, but they
all deal with static arrays.

Because when you are on the server static arrays is all you have access
to without sending a new request and refreshing the page, without using
other technologies.

Now, this kind of problem is exactly why technologies such as Ajax and
Flex have come about. You could use these to allow for the requesting
and receiving of data without refreshing the interface.

[c_wigginton]

I have a writeup on this on my blog

Linked HTML Form Selects using AJAX
http://www.intersuite.com/client/index.cfm/2007/2/25/Linked-HTML-Form-Selects-using-AJAX

[Newsgroup_User]

Thats great, but you make reference to a cf_LinkSelect tag that I cannot
locate anywhere.

[Newsgroup_User]

Ahh, nevermind, I found it on the page. Sharp download area.