Hey all,
First time using CFGRID here. Everything displays great, but when I click
the submit button to update the database I get the error:
"The table 'KSSE.RPT_DEPT_GROUPS' contained no columns in the grid
'ksse_dev'"
Here is my code. Any Ideas? I should point out that the data for the grids
is coming from a DIFFERENT table than the table I want to update. Thanks in
advance!
Page with the 2 separate CFGRIDS (inside one form)
---------------------------------------------------
<!---Here are the queries--->
<cfquery name="cost_centers" datasource="KSSE_dev">
SELECT DISTINCT Kostenstelle
from ksse.ksse_personal
</cfquery>
<cfquery name="projects" datasource="KSSE_dev">
SELECT DISTINCT auftragsnummer AS "Project Numbers"
from ksse.AUFTRAEGE
</cfquery>
<cfform name="form1" method="post" action="kssegroups_action.cfm">
<tr><td>
<cfgrid name="cost_centers"
query="cost_centers"
selectmode="edit"
height="400"
INSERT="Yes"
DELETE="Yes"
PICTUREBAR="No"
rowheaders="no">
<cfgridcolumn name="KOSTENSTELLE" headerbold="yes" headerfontsize="16">
</cfgrid>
<cfgrid name="PROJECTS"
query="projects"
height="400"
selectmode="edit"
INSERT="Yes"
DELETE="Yes"
PICTUREBAR="no"
rowheaders="no">
<cfgridcolumn name="Project Numbers" headerbold="yes" headerfontsize="16">
</cfgrid>
</td></tr>
<tr><td colspan="2" align="right"><input type="submit" value="Save
Changes" name="submit"></td></tr>
</cfform>
ACTION PAGE
-----------------------------------------------------
<cfgridupdate grid="cost_centers"
datasource="ksse_dev"
tablename="KSSE.RPT_DEPT_GROUPS"
keyonly="Yes">
<CFGRIDUPDATE GRID="projects"
DATASOURCE="ksse_dev"
TABLENAME="KSSE.RPT_PROJECT_GROUPS"
KEYONLY="yes">
-----------------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
