ColdFusion 500错误：复杂对象无法转换为简单值求助

我定义了如下formSections数组：

<cfset formSections = [
    {
        title: "Client Information",
        fields: [
            {label: "Name - First and Last (both)", type: "text", name: "FullName", maxlength: 150},
            {label: "Email Address", type: "text", name: "Email", maxlength: 150},
            {label: "Home Address", type: "textarea", name: "Address1", rows: 4, cols: 50}
        ]
    }
]>

以及formData结构体：

<cfset formData = {"Email" : "imhans@gmail.com", "Fullname" : "Hans M"}>

尝试通过循环生成HTML表单：

<cfloop array="#formSections#" index="section">

    <table class="formTable">
        <tr>
            <td height="35" colspan="2" align="left" valign="middle" bgcolor="##CCCCFF">
                <span style="font-weight: bold">#section.title#</span>
            </td>
        </tr>
        <cfloop array="#section.fields#" index="field">
            <cfif StructKeyExists(formData, field.name)>
                <tr>
                    <td class="name">#field.label#</td>
                    <td>
                        <cfif field.type IS "text">
                            <input type="#field.type#" name="#field.name#" maxlength="#field.maxlength#"
                                value="#EncodeForHTML(formData[field.name])#">
                        </cfif>
                    </td>
                </tr>
            <cfelse>
                <!-- If the item.name does not exist in formData, output the form element without a value -->
                <cfif field.type IS "text">
                    <label for="#field.name#">#field.name#:</label>
                    <input type="#field.type#" name="#field.name#" id="#field.name#" value="" /><br/>
                </cfif>
            </cfif>
        </cfloop>
    </table>
    <br/>

</cfloop>

但出现错误：

500 Complex object types cannot be converted to simple values.

错误发生在value="#EncodeForHTML(formData[field.name])#"处。

补充信息：formData通过如下方式生成：

<cfset keys1 = ["fullname", "address1", "address2", "email", "phone", "username", "password"]>

<cfset keys2 = ["cpdKeys", "cpdLockBox", "cpdRouter", "cpdHomeWarranty"]>
<cfset formData = structNew()>
<cfif StructKeyExists(form, "UserID")>
    <cfset formData['userid'] = form.UserID>

    <cfset userDetailsById = getUserDetails(datasource="#application.dsn#", UserID=form.UserID)>
    <cfset userProfileDetailsById = getClientProfileData(datasource="#application.dsn#", UserID=form.UserID)>

    <cfloop array="#keys1#" index="key">
        <cfset formData[key] = StructKeyExists(userDetailsById, key) ? userDetailsById[key] : "">
    </cfloop>
    <cfloop array="#keys2#" index="key">
        <cfset formData[key] = StructKeyExists(userProfileDetailsById, key) ? userProfileDetailsById[key] : "">
    </cfloop>
<cfelse>
    <cfloop array="#keys1#" index="key">
        <cfset formData[key] = "">
    </cfloop>
    <cfloop array="#keys2#" index="key">
        <cfset formData[key] = "">
    </cfloop>
</cfif>

请问该如何解决这个错误？

错误原因 #

• 键名大小写不匹配：formSections中的字段名是FullName、Email（首字母大写），但生成formData时使用的键是fullname、email（全小写）。ColdFusion结构体键名默认大小写敏感，导致StructKeyExists判断失效，后续取值时可能返回复杂对象（如查询列）。
• 查询对象取值错误：如果getUserDetails或getClientProfileData返回的是查询对象，直接通过userDetailsById[key]获取的是整个查询列（复杂对象），而非单行字段值，这会触发"无法将复杂对象转换为简单值"的错误。

修复步骤 #

1. 统一键名大小写
   两种可选方案：

   • 直接修改formSections中的字段名为小写，与formData的键保持一致：

     <cfset formSections = [
         {
             title: "Client Information",
             fields: [
                 {label: "Name - First and Last (both)", type: "text", name: "fullname", maxlength: 150},
                 {label: "Email Address", type: "text", name: "email", maxlength: 150},
                 {label: "Home Address", type: "textarea", name: "address1", rows: 4, cols: 50}
             ]
         }
     ]>
     

   • 或者在判断和取值时统一转换大小写：

     <cfif StructKeyExists(formData, LCase(field.name))>
         <!-- 后续取值用 formData[LCase(field.name)] -->
     </cfif>
     

2. 正确获取查询对象的单行值
   如果getUserDetails和getClientProfileData返回单行查询，需通过[1]获取第一行的字段值：

   <cfloop array="#keys1#" index="key">
       <cfset formData[key] = StructKeyExists(userDetailsById, key) ? userDetailsById[key][1] : "">
   </cfloop>
   <cfloop array="#keys2#" index="key">
       <cfset formData[key] = StructKeyExists(userProfileDetailsById, key) ? userProfileDetailsById[key][1] : "">
   </cfloop>
   

   若不确定查询行数，可增加非空判断：

   <cfset formData[key] = (StructKeyExists(userDetailsById, key) AND userDetailsById.recordCount > 0) ? userDetailsById[key][1] : "">
   

3. 增加简单类型检查
   在调用EncodeForHTML前，确保传入的是简单值，避免复杂对象：

   <cfif field.type IS "text">
       <cfset fieldValue = formData[field.name]>
       <input type="#field.type#" name="#field.name#" maxlength="#field.maxlength#" 
           value="#IsSimpleValue(fieldValue) ? EncodeForHTML(fieldValue) : ''#">
   </cfif>
   

内容的提问来源于stack exchange，提问作者imhans4305