I'll venture a gues...
put this in your GRIDUPDATE tag:
KEYONLY="Yes"
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
-----Original Message-----
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 1:30 PM
To: CF-Talk
Subject: CFGRID Not updating
And on with my CFGRID Saga.
*sigh*
Now I have the grids displaying, I have them formatted and lloking all
pretty..
But now they are not updating any tables. Would you believe this utter
rubbish!!??
I can't update or insert data into several tables. When I go to the
action page, the values I enter into the CFGRID are not being displayed
in the DEBUG form field section.
It is most frustrating!
Does anyone have any ideas?
Here is the debug listing:
Parameters
Form Fields:
__CFGRID__GRIDFORM__THEGRID=__CFGRID__EDIT__=5EXPENSE_TYPEYC
ATEGORY_T
YPEYEXPENSE_CDYACCOUNT_NBRYACCOUNT_NBR_DESCY0
FIELDNAMES=FORMSUBMITTED,__CFGRID__GRIDFORM__THEGRID
FORMSUBMITTED=TrueTHEGRID.ACCOUNT_NBR[=THEGRID.ACCOUNT_NBR_DESC[=THEGRID.CAT
EGORY_TYPE[=THEGRID.EXPENSE_CD[=THEGRID.EXPENSE_TYPE[=THEGRID.ORIGINAL.ACCOU
NT_NBR[=THEGRID.ORIGINAL.ACCOUNT_NBR_DESC[=THEGRID.ORIGINAL.CATEGORY_TYPE[=T
HEGRID.ORIGINAL.EXPENSE_CD[=THEGRID.ORIGINAL.EXPENSE_TYPE[=THEGRID.ROWSTATUS
ACTION[=
And I changed a value..but there is nothing showing up in the Form
Fields.The program IS running the CFGRIDUPDATE statement, however, since
I see the WHEEE text at the top of the form after I submit.
Yes I copied over the new .jar file for the CFGRID.
Here is the code. This is all basic, straightforward stuff for the
CFGRID> I have NEVER had this much trouble using the CFGRID in Server
4.5, I just don't understand what the hell I'm doing wrong.
--------------------------------------------
<CFIF IsDefined("FormSubmitted") Is True>
The Form Was Submitted WHEEE!
<cfgridupdate
datasource="RELORA"
tablename= "COMPANY_TBL"
grid = "thegrid"
keyonly="NO">
</CFIF>
<CFQUERY name="qrygrid" datasource="relora" dbtype="Oracle80">
Select * FROM COMPANY_TBL
</CFQUERY>
<html>
<head>
<title>Admin-Users </title>
</head>
<body>
<CFSET formsubmitted = 'FALSE'>
<CFFORM name="GridForm" ACTION="admin_companytbl.cfm"
METHOD="Post">
<cfgrid name="thegrid"
height="500"
width="900"
query="qrygrid"
insert="Yes"
delete="Yes"
sort="Yes"
font="Verdana"
fontsize="10"
bold="No"
italic="No"
appendkey="No"
highlighthref="No"
griddataalign="LEFT"
gridlines="Yes"
rowheaders="No"
rowheaderalign="LEFT"
rowheaderitalic="No"
rowheaderbold="No"
colheaders="Yes"
colheaderalign="LEFT"
colheaderfont="Verdana"
colheaderfontsize="12"
colheadertextcolor="##cc0000"
colheaderitalic="No"
colheaderbold="Yes"
bgcolor="##00FFFF"
selectcolor="##00FFF8"
textcolor="##000000"
selectmode="EDIT"
picturebar="No">
<cfgridcolumn name="COMPANY_CD"
header="Company Code"
headeralign="CENTER"
dataalign="LEFT"
width="200"
font="Verdana"
fontsize="12"
bold="No"
italic="No"
select="Yes"
display="Yes"
headerbold="No"
headeritalic="No">
<cfgridcolumn name="COMPANY_DESC"
header="Company Description"
headeralign="CENTER"
dataalign="LEFT"
width="500"
font="Verdana"
fontsize="12"
bold="No"
italic="No"
select="Yes"
display="Yes"
headerbold="No"
headeritalic="No">
</CFGRID>
<center>
<input type="submit" value="Update Table Contents">
<input type="hidden" name="FormSubmitted" value="True">
</center>
</CFFORM>
---------------------------------------
-Gel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
