Selection change query

[James168]

Hi,
I have problems that passing a JavaScript variable back to CF in a JavaScript
item change event. For example, a user selects a state in one dropdown list,
all the cities in the state should appear in another dropdown list.

Try One method:
<cfset STvar = ''CA'> -- Works if is set to constant value
<cfset STvar = ''{stselect.text}'> -- Not Work if try to read a field
<cfquery name="city" datasource="xxx".
SELECT CITY FROM WEB."CITY" WHERE (STCODE = '#STvar#' )
</cfquery>

Try method 2:
<cfset STsel = 'AL' > Works if is set to constant
<cfset STsel = "{stselect.selectedItem.data}" > No Work - - after the
<cfquery>, it returns me the correct SQL syntax, but not the result of the
query.
<cfset strSQL= "SELECT City FROM WEB.""STATE"" WHERE (STCODE = '" &
variables.STsel & "' )">
<cfquery name="city" datasource="xxx">
#Evaluate('strSQL')#
</cfquery>

In the last method, how can I get the query result of the #Evaluate('strSQL')#
if it returns the correct SQL statement. How can I read a selection text
field into a CfSet varialbe before I click the POST Submit button.

Thanks,
James:confused;

[adonis1976]

James,

I didnt understand your code, but try this thing

have this in your cfm file

<cfif isDefined(form.statename)>
<cfquery name="qGetcity" datasource="datasourcename">
SELECT city from web
where stcode = '#form.statename#'
</cfif>

<form>
<select name="statename" onChange=form.submit()>
<option value="AZ">Arizona</option>