<!---<cfquery name="Grsample" datasource="#Application.DataSrc#">
select Diagnosis.Diagnosis_ID,Diagnosis.ICD,Diagnosis.Diagnosis,Diagnosis.Dx_Order
from Diagnosis where Diagnosis.Assessment_ID='#session.cs.AssessmentId#'
</cfquery>

<!---<cfif IsDefined("form.gridEntered") is True>
    <cfgridupdate grid = "FirstGrid" dataSource = "#Application.DataSrc#" Keyonly="true"
        tableName = "Diagnosis">
 </cfif>--->


<cfform>
<cfgrid name = "FirstGrid" width = "450" format="flash"
    query = "Grsample" 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>--->


<!--- Query the database to fill up the grid. --->
<cfquery name = "GetCourses" dataSource = "#Application.DataSrc#">
select Diagnosis.Diagnosis_ID,Diagnosis.ICD,Diagnosis.Diagnosis,Diagnosis.Dx_Order
from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID='#session.cs.AssessmentId#'
</cfquery>

<h3>cfgrid Example</h3>
<i>Currently available courses</i>
<!--- cfgrid must be inside a cfform tag. --->
<cfform>
    <cfgrid name = "FirstGrid" format="Flash"
        height="300" width="480"
        font="Tahoma" fontsize="12" delete="yes" selectmode="edit"
        query = "GetCourses">
    </cfgrid>
</cfform>