gsr
12/25/2023, 12:14 AM<cfform>
<cfgrid name="myGrid" format="html" width="100%" query="queryData" insert="true" update="true" delete="true">
<cfgridcolumn name="USER_ID" header="USER_ID" width="100">
<cfgridcolumn name="USERNAME" header="USERNAME" width="100">
<cfgridcolumn name="FIRSTNAME" header="FIRSTNAME" width="100">
<cfgridcolumn name="LASTNAME" header="LASTNAME" width="100">
<cfgridcolumn name="HASHED_PASSWORD" header="HASHED_PASSWORD" width="100">
<cfgridcolumn name="EMAIL" header="EMAIL" width="100">
<cfgridcolumn name="CREATED_TMSTP" header="CREATED_TMSTP" width="100">
<cfgridcolumn name="MODIFIED_TMSTP" header="MODIFIED_TMSTP" width="100">
<cfgridcolumn name="CREATED_BY" header="CREATED_BY" width="100">
<cfgridcolumn name="MODIFIED_BY" header="MODIFIED_BY" width="100">
<cfgridcolumn name="DELETE_TMSTP" header="DELETE_TMSTP" width="100">
<cfgridcolumn name="DELETED_BY" header="DELETED_BY" width="100">
</cfgrid>
</cfform>jakobward
12/25/2023, 12:20 AMgsr
12/25/2023, 12:33 AMgsr
12/25/2023, 12:33 AMAdam Cameron
gsr
12/25/2023, 2:22 PMAdam Cameron
gsr
12/25/2023, 2:36 PMAdam Cameron
bkbk
01/01/2024, 12:59 PMcfgrid tag. Also, I think that cfgrid's width attribute should be in number of pixels, rather than percent.
When I ran the following code, I obtained a grid as expected:
<cfscript>
queryData = queryNew("USER_ID,USERNAME,FIRSTNAME,LASTNAME,HASHED_PASSWORD,EMAIL,CREATED_TMSTP,MODIFIED_TMSTP,CREATED_BY,MODIFIED_BY,DELETE_TMSTP,DELETED_BY", "integer,varchar,varchar,varchar,varchar,varchar,varchar,varchar,integer,integer,varchar,integer");
queryAddRow(queryData,2);
querySetCell(queryData, "USER_ID", 101,1);
querySetCell(queryData, "USERNAME", "jsmith", 1);
querySetCell(queryData, "FIRSTNAME", "John", 1);
querySetCell(queryData, "LASTNAME", "Smith", 1);
querySetCell(queryData, "HASHED_PASSWORD", "jsmith123", 1);
querySetCell(queryData, "EMAIL", "<mailto:jsmith@domain.com|jsmith@domain.com>", 1);
querySetCell(queryData, "CREATED_TMSTP", "01/11/2023", 1);
querySetCell(queryData, "MODIFIED_TMSTP", "02/11/2023", 1);
querySetCell(queryData, "CREATED_BY", "1001", 1);
querySetCell(queryData, "MODIFIED_BY", "1002", 1);
querySetCell(queryData, "DELETE_TMSTP", "03/11/2023", 1);
querySetCell(queryData, "DELETED_BY", "1003", 1);
querySetCell(queryData, "USER_ID", 102,2);
querySetCell(queryData, "USERNAME", "jDoe", 2);
querySetCell(queryData, "FIRSTNAME", "Jane", 2);
querySetCell(queryData, "LASTNAME", "Doe", 2);
querySetCell(queryData, "HASHED_PASSWORD", "jDoe123", 2);
querySetCell(queryData, "EMAIL", "<mailto:jDoe@domain.com|jDoe@domain.com>", 2);
querySetCell(queryData, "CREATED_TMSTP", "01/12/2023", 2);
querySetCell(queryData, "MODIFIED_TMSTP", "02/12/2023", 2);
querySetCell(queryData, "CREATED_BY", "2001", 2);
querySetCell(queryData, "MODIFIED_BY", "2002", 2);
querySetCell(queryData, "DELETE_TMSTP", "03/12/2023", 2);
querySetCell(queryData, "DELETED_BY", "2003", 2);
//writeDump(queryData);
</cfscript>
<cfform>
<cfgrid name="myGrid" format="html"query="queryData" insert="true" delete="true">
<cfgridcolumn name="USER_ID" header="USER_ID" width="100">
<cfgridcolumn name="USERNAME" header="USERNAME" width="100">
<cfgridcolumn name="FIRSTNAME" header="FIRSTNAME" width="100">
<cfgridcolumn name="LASTNAME" header="LASTNAME" width="100">
<cfgridcolumn name="HASHED_PASSWORD" header="HASHED_PASSWORD" width="100">
<cfgridcolumn name="EMAIL" header="EMAIL" width="100">
<cfgridcolumn name="CREATED_TMSTP" header="CREATED_TMSTP" width="100">
<cfgridcolumn name="MODIFIED_TMSTP" header="MODIFIED_TMSTP" width="100">
<cfgridcolumn name="CREATED_BY" header="CREATED_BY" width="100">
<cfgridcolumn name="MODIFIED_BY" header="MODIFIED_BY" width="100">
<cfgridcolumn name="DELETE_TMSTP" header="DELETE_TMSTP" width="100">
<cfgridcolumn name="DELETED_BY" header="DELETED_BY" width="100">
</cfgrid>
</cfform>