如何使用CFGRID信息更新数据库？

Question

我正在使用cfgrid，但我不知道如何让它在有人编辑条目中的数据时保存。

<cfform>
<cfgrid
name = "degrees"
query = "getDegrees"
insert = "yes"
delete = "yes"
width = "500"
height = "150"
insertButton = "New Degree"
deleteButton = "Delete Degree"
colHeaderBold = "Yes"
selectColor = "##006633"
selectMode = "edit"
>
<cfgridcolumn name = "Terminal"
values = "Yes, No" >

<cfgridcolumn name = "Degree"
values = "B, M, D"
valuesDisplay = "Bachelors, Masters, Doctorate">
<cfgridcolumn name = "Name">

<cfgridcolumn name = "Specialization">
<cfgridcolumn name = "Year">
<cfgridcolumn name = "Institution">
<cfgridcolumn name = "Transcript"
values = "Yes, No" >

</cfgrid>
</cfform>

我知道有cfgridupdate标签，但我不确定该把它放在哪里。它是否像常规表单一样提交？

我知道这是一个简单的问题，但我找不到一个不使用网络绑定的答案。(我不能use...binding那个)

使用Coldfusion 8. :) (注意:由于IT部门的原因，绑定不起作用-_- )

Answer 1

您可能会这样(从CF live文档).If gridEntered表单域存在，表单已提交。执行gridupdate。

<cfif IsDefined("form.gridEntered") is True>
    <cfgridupdate grid = "FirstGrid" dataSource = "cfdocexamples" Keyonly="true"
        tableName = "CourseList">
 </cfif>


<cfform>
<cfgrid name = "FirstGrid" width = "450" 
    query = "GetCourses" insert = "Yes" delete = "Yes"
    font = "Tahoma" rowHeaders = "No" 
    colHeaderBold = "Yes" 
    selectMode = "EDIT"
    insertButton = "Insert a Row" deleteButton = "Delete selected row" >
</cfgrid><br>
<cfinput type="submit" name="gridEntered">
</cfform>

来源：http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Part_3_CFML_Ref_1.html

示例代码应该清理一下:在IsDefined("form.gridEntered")上使用StructKeyExists(Form，"gridEntered")