select change address

Hi,

<cfquery 1> get state </cfquery


<form>

<select name=getlocal>
show states..
</select


in another part on the page; base on the state that was selected in the
getlocal i want to show the full address for that location.

----
<cfquery name="getaddr">
get address from xxx where state = state
</cfquery>

<cfoutput query="getaddr">
Adobe
101 Mockingbird lane
Wilson, CT 01222
</cfoutput>
----

</form>

How do i get the address to change automatically when the user change the
state selection. Right shows the first selection and when i choose another
state, it doesn't change.

thanks in advance.