I'm connecting a Flex 4.6 form to SQL Server 2008 using Coldfusion. When my form submits to the DB, I'm finding my variables are crossing and I can't seem to see the problem causing it:
Flex Remote Object Call:
private function RegisterNewEmployee():void{
//remote object and method instantiated
roCreateNewUser.createNewEmployeeProfile(fm_userName.text,
fm_password.text, fm_accessLevel.selectedItem, fm_emailAddress.text,
fm_domainField.selectedItem );
}
Flex Components
<mx:FormItem label="Access Level:" width="182" color="#FFFFFF" required="false">
<s:DropDownList width="60" color="#FFFFFF" id="fm_accessLevel">
<s:dataProvider>
<mx:ArrayList id="accessLevelList">
<fx:String>9</fx:String>
<fx:String>44</fx:String>
</mx:ArrayList>
</s:dataProvider>
</s:DropDownList>
</mx:FormItem>
<mx:FormItem label="Email: " fontSize="12" width="173" horizontalAlign="left" color="#FFFFFF" required="false"><s:TextInput color="#000000" id="fm_emailAddress" text="{fm_userName.text}" />
</mx:FormItem><s:Label text="@


" fontSize="14" width="15" height="21" color="#FEFEFE" />
<s:ComboBox color="#FFFFFF" id="fm_domainField" height="22" enabled="true">
<s:dataProvider>
<mx:ArrayList id="domainList">
<fx:String>aaa.com</fx:String>
<fx:String>bbb.com</fx:String>
<fx:String>ccc.com</fx:String>
</mx:ArrayList>
</s:dataProvider>
</s:ComboBox>
Coldfusion Code:
<cfargument name="fm_accessLevel" type="any" default="1">
<cfargument name="fm_emailAddress" type="any" default="user01">
<cfargument name="fm_domainField" type="any" default="aaa.com">
Problem begins here:
<!--- Concatenate email and domain --->
<cfset emailString = #arguments.fm_emailAddress# & "@" & #arguments.fm_domainField# >
Somehow, the outcome of the concatenation returns the equivalent of
<cfset emailString = #arguments.accessLevel# & "@" & #arguments.emailAddress# >
or **44@MyUserName** in plain text output
Any noticeable issues in the code to cause this? It previously worked without issue. Cache and browser history cleared, issue persists.