Hi:
I made a grid with cfgrid then I made an action page with cfgridupdate. It
works when I change one cell but doesn't work when I change more than one
cell! Here is the code:
The page that contains grid : cfgridtets.cfm
<!--- the start of the first page --->
<cfquery name="UsersGrid" datasource="#Request.DSN#">
SELECT UserID, UserName, UserPassword, FistName, LastName, City, UserActive
FROM Tbl_Users</cfquery>
<cfquery name="rstest" datasource="#Request.DSN#">
SELECT *
FROM Tbl_City
</cfquery>
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Grid Page</title>
</head>
<body>
<cfform action="../cfgridtestaction.cfm"
method="Post"
name="GridForm">
<cfgrid name="MYGRID"
format="html"
insert="yes"
query="UsersGrid"
COLHEADERBOLD="Yes"
COLHEADERFONT="Tahoma"
SELECTMODE="EDIT"
width="400"
height="200"
DELETE="Yes"
DELETEBUTTON="Del?">
<cfgridcolumn name="UserID"
display="No">
<cfgridcolumn SELECT="Yes"
name="UserName"
header="User Name">
<cfgridcolumn SELECT="Yes"
name="UserPassword"
header="User Password">
<cfgridcolumn name="FistName"
select="Yes"
header="Fist Name"
headerAlign="RIGHT">
<!--- here I use another query to make a combo box to list city names --->
<cfgridcolumn name="City"
values="#ValueList(rstest.CityName)#"
select="Yes"
header="City"
headerAlign="RIGHT">
<cfgridcolumn name="UserActive"
select="Yes"
header="User Active"
headerAlign="RIGHT">
</cfgrid>
<P><input type="Submit" value="Save">
</cfform>
</body>
</html>
<!--- end of the first page --->
This is the page I use as an action page to cfgridupdate works:
cfgridtestaction.cfm
<!--- start of the page two --->
<html xmlns="http://www.w3.org/1999/xhtml";>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Action Page</title>
</head>
<body>
<!--- here is the cfgridupdate page... but when I change more than one cell
in the grid it doesn't work --->
<cfgridupdate datasource="#Request.DSN#"
tableName="Tbl_Users"
grid="MYGRID">
</body>
</html>
<!--- end of the second page--->
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301894
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
