you are missing several items, look at this example attached from a working
site
note the select mode, grid colum for each column and action page
-------
<CFFORM ACTION="update_user_action.cfm"
METHOD="POST"
ENABLECAB="No"
ENCTYPE="multipart/form-data">
<CFGRID NAME="LoginAdmin"
HEIGHT="250"
WIDTH="450"
ALIGN="MIDDLE"
QUERY="user_logins"
INSERT="Yes"
DELETE="Yes"
SORT="Yes"
FONT="Verdana"
FONTSIZE="12"
BOLD="Yes"
ITALIC="No"
APPENDKEY="No"
HIGHLIGHTHREF="No"
GRIDDATAALIGN="LEFT"
GRIDLINES="Yes"
ROWHEADERS="No"
ROWHEADERALIGN="LEFT"
ROWHEADERITALIC="No"
ROWHEADERBOLD="No"
COLHEADERS="Yes"
COLHEADERALIGN="LEFT"
COLHEADERITALIC="No"
COLHEADERBOLD="No"
BGCOLOR="Yellow"
SELECTMODE="EDIT"
PICTUREBAR="No"
SORTASCENDINGBUTTON="Sort Asc"
SORTDESCENDINGBUTTON="Sort Desc">
<CFGRIDCOLUMN NAME="ID" HEADERALIGN="LEFT" DATAALIGN="LEFT"
BOLD="No" ITALIC="No" SELECT="Yes" DISPLAY="No" HEADERBOLD="No"
HEADERITALIC="No">
<CFGRIDCOLUMN NAME="Name" HEADERALIGN="LEFT"
DATAALIGN="LEFT" BOLD="No" ITALIC="No" SELECT="Yes" DISPLAY="Yes"
HEADERBOLD="No" HEADERITALIC="No">
<CFGRIDCOLUMN NAME="Pass" HEADERALIGN="LEFT"
DATAALIGN="LEFT" BOLD="No" ITALIC="No" SELECT="Yes" DISPLAY="Yes"
HEADERBOLD="No" HEADERITALIC="No">
<CFGRIDCOLUMN NAME="CompanyName" HEADERALIGN="LEFT"
DATAALIGN="LEFT" BOLD="No" ITALIC="No" SELECT="Yes" DISPLAY="Yes"
HEADERBOLD="No" HEADERITALIC="No">
<CFGRIDCOLUMN NAME="UserName" HEADERALIGN="LEFT"
DATAALIGN="LEFT" BOLD="No" ITALIC="No" SELECT="Yes" DISPLAY="Yes"
HEADERBOLD="No" HEADERITALIC="No">
</cfgrid>
that's the input form, now for the action form
---------------
<CFGRIDUPDATE GRID="LoginAdmin"
DATASOURCE="rsa_horizons"
TABLENAME="user_login"
DBTYPE="ODBC"
KEYONLY="yes">
<CFQUERY NAME="user_updated" DATASOURCE="rsa_horizons">
SELECT *
FROM user_login
</CFQUERY>
<BR>
<BR>
<BR>
<BR>
<BR>
<CFFORM ACTION="login_admin.cfm"
METHOD="POST"
ENABLECAB="Yes">
<CFOUTPUT>
<CFGRID NAME="cc"
HEIGHT="150"
WIDTH="450"
QUERY="user_updated"
INSERT="No"
DELETE="No"
SORT="Yes"
BOLD="No"
ITALIC="No"
APPENDKEY="No"
HIGHLIGHTHREF="No"
GRIDDATAALIGN="LEFT"
GRIDLINES="Yes"
ROWHEADERS="No"
ROWHEADERALIGN="LEFT"
ROWHEADERITALIC="No"
ROWHEADERBOLD="No"
COLHEADERS="Yes"
COLHEADERALIGN="CENTER"
COLHEADERITALIC="No"
COLHEADERBOLD="Yes"
BGCOLOR="Yellow"
SELECTMODE="BROWSE"
PICTUREBAR="No"
SORTASCENDINGBUTTON="Sort ASC"
SORTDESCENDINGBUTTON="Sort Desc">
<CFGRIDCOLUMN NAME="ID" HEADERALIGN="LEFT"
DATAALIGN="LEFT" BOLD="No" ITALIC="No" SELECT="No" DISPLAY="Yes"
HEADERBOLD="No" HEADERITALIC="No">
<CFGRIDCOLUMN NAME="Name" HEADERALIGN="LEFT"
DATAALIGN="LEFT" BOLD="No" ITALIC="No" SELECT="No" DISPLAY="Yes"
HEADERBOLD="No" HEADERITALIC="No">
<CFGRIDCOLUMN NAME="Pass" HEADERALIGN="LEFT"
DATAALIGN="LEFT" BOLD="No" ITALIC="No" SELECT="No" DISPLAY="Yes"
HEADERBOLD="No" HEADERITALIC="No">
<CFGRIDCOLUMN NAME="CompanyName" HEADERALIGN="LEFT"
DATAALIGN="LEFT" BOLD="No" ITALIC="No" SELECT="No" DISPLAY="Yes"
HEADERBOLD="No" HEADERITALIC="No">
<CFGRIDCOLUMN NAME="UserName" HEADERALIGN="LEFT"
DATAALIGN="LEFT" BOLD="No" ITALIC="No" SELECT="Yes" DISPLAY="Yes"
HEADERBOLD="No" HEADERITALIC="No">
</cfgrid>
</CFOUTPUT>
<BR>
<BR>
<INPUT TYPE="Submit"
NAME="Submit"
VALUE=" Return ">
</CFFORM>
Good luck
Richard Kern
-----Original Message-----
From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 02, 2000 11:59 AM
To: CF-Talk
Subject: Editing data with CFGRID
Hi!
I created a spreadsheet style grid with CFGRID
(my first time) and I don't seem to be able to edit
the information in the table. What am I doing wrong?
<CFFORM method="POST" action="secteurs_submit.cfm">
<CFGRID
name="Secteurs"
query="Secteurs"
SELECTMODE="SINGLE"
width="100%"
height="100%">
</cfgrid>
<br><input type="Submit" value="Envoie">
</cfform>
Thanks!
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
