dereference a scalar variable ?

I have Dynamic Drop downs working but am having a hard time to capture the values selected for further processing in CF.
I get the following ColdFusion error:

"You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members."


Summary of issue

- Two drop down lists connect to a MS-SQL database, making the second drop down dynamic list based on the choices in the first drop down.. This works just fine...

- But Im having trouble at the processing page to reuse the selected values for further processing. Below is a snippet of my code for the form and the processing page.
I want to reuse the values parent.rb and child as from the drop down lists.

=== Form ===
<tr>
<td><div class="contentheader">District*</div></td>
<td><label>
<select name="parent" size="1" id="parent" onChange="WA_FilterAndPopulateSubList(child_WAJA,MM_findObj('parent'),MM_findObj('child'),0,0,false,': ')">
<option value="value">- Select One -</option>
<cfoutput query="parent">
<option value="#parent.rb#">#parent.district#</option>
</cfoutput>
</select>
</label></td>
</tr>
<tr>
<td><div class="contentheader">Web Site*</div></td>
<td><label>
<select name="child" size="1" id="child">
<option>- Select One -</option>
</select>
</label></td>
</tr>

--- Processing page

<cfquery name="districtinfo" datasource="dbxyz (commented out)" dbtype="ODBC">
Select rb, district from districts
where district = #parent.rb#
</cfquery>
<CFOutput query="districtinfo">
<CFSet districtout = #district#>
</CFOutput>

I believe the where clause should be referencing the parent form elemtn instead of the parent.rb recordset column:

where district = #Form.parent#

Thanks for the suggestion.

I've made some progress on manipulating the variables.
Now tweaking my code and trying to get variables from the second dynamic drop down list for further processing (output to email).

you just need to output the form value in the email:
#Form.child#

After further tinkering, I got my solution to work. I had to go back into server behaviors and adjust the value I wanted to extract / compare against in the database and then adjust the variables I wanted to work with for output.

On top of that, I had to develop locally on my workstation, and then load my files on to my server since DW / we dont have a direct connection to the MS-SQL database... So it took some additional tinkering to figure out - lets hope that a battery of tests verifies that its working as expected.

Thanks for your help so far!

Excellent, glad to hear it is working.