Here is what I'm after in the nutshell...
<form name="selectDbase" method="post"
action=""> <select size="1" name="type">
<option selected>Select a database</option>
<option value="client">client</option>
<option value="client_test">client_test</option>
</select>
And from this first selection (which is hard coded and doesn't need to come from a query) I then want the second select box populated from either the client or client_test table, depending on the option above chosen.
<select size="1" name="town">
<option selected>Select a database</option>
<cfoutput query="dbase_name"> <!-- where dbase name is the name of the first select dropdown - either client or client_test --->
<option value="#town#">#town#</option>
</cfoutput>
</select>
<input type="submit" name="emailUsers" value="email users"
class="button" />
</form>
Either way, I only query the town field of either database. I know the form is going to probably have to submit to itself to populate the second select field, I'm just not sure how to achieve this.
I'm aware of a couple of custom tags, but these all use a single query to populate the select boxes and thats the very thing I need changing.
Any ideas or possible solutions?
Regards
Mark H
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
