Hey guys and gals.
I got this error when doing a simple CFGRID/CFGRIDUPDATE page:
===================================================
Oracle Error Code = 957
ORA-00957: duplicate column name
Data Source = "RELORA"
SQL = "UPDATE "VEHICLE_TBL" SET "COST_CENTER_CD" = :1 , "COST_CENTER_CD"
= :2 WHERE "VEHICLE_NBR" = :3 AND "VEHICLE_NBR" = :4 "
The error occurred while processing an element with a general identifier
of (CFGRIDUPDATE), occupying document position (12:2) to (16:28) in the
template file C:\sites\Reliant Energy\current\admin_vehicletable.cfm.
========================================================
I've never seen this error with a CFGRID before, so I'm a bit confused.
The columns are NOT listed twice in the CFGRID tag.
I tried updating just one value in the Grid.
Any ideas as to what could be the problem?
-Gel
------------------------------------------------------------------------
-------------------------------------------------
Here's the code for the page:
The update statement :
<cfgridupdate grid="vehiclestuff"
datasource="RELORA"
tablename="VEHICLE_TBL"
dbtype="Oracle80"
keyonly="Yes">
The CFGRID statement:
<cfgrid name="vehiclestuff"
height="500"
width="720"
query="GetVehicles"
insert="Yes"
delete="Yes"
sort="Yes"
font="Verdana"
fontsize="10"
bold="No"
italic="No"
appendkey="Yes"
highlighthref="No"
griddataalign="CENTER"
gridlines="Yes"
rowheaders="No"
rowheaderalign="LEFT"
rowheaderitalic="No"
rowheaderbold="No"
colheaders="Yes"
colheaderalign="LEFT"
colheaderfont="Arial"
colheaderfontsize="12"
colheadertextcolor="##000000"
colheaderitalic="No"
colheaderbold="Yes"
bgcolor="##FFFF80"
selectcolor="##00FF00"
textcolor="##FF0000"
selectmode="EDIT"
picturebar="No">
<cfgridcolumn name="COMPANY"
header="Company"
headeralign="LEFT"
dataalign="LEFT"
width="100"
font="Verdana"
fontsize="10"
bold="No"
italic="No"
select="No"
display="Yes"
headerbold="No"
headeritalic="No">
<cfgridcolumn name="LOCATION"
header="Location"
headeralign="LEFT"
dataalign="LEFT"
width="100"
font="Verdana"
fontsize="10"
bold="No"
italic="No"
select="No"
display="Yes"
headerbold="No"
headeritalic="No">
<cfgridcolumn name="VEHICLE_NBR"
header="Vehicle No."
headeralign="LEFT"
dataalign="LEFT"
width = "80"
font="Verdana"
fontsize="10"
bold="No"
italic="No"
select="No"
display="Yes"
headerbold="No"
headeritalic="No">
<cfgridcolumn name="VEHICLE_TYPE"
header="Vehicle Type"
headeralign="LEFT"
dataalign="LEFT"
width="100"
font="Verdana"
fontsize="10"
bold="No"
italic="No"
select="No"
display="Yes"
headerbold="No"
headeritalic="No">
<cfgridcolumn name="COST_CENTER_CD"
header="Cost Center Code"
headeralign="LEFT"
dataalign="LEFT"
width="300"
font="Verdana"
fontsize="10"
bold="No"
italic="No"
select="Yes"
display="Yes"
headerbold="No"
headeritalic="No"
values="#CodeList#"
valuesdisplay="#CodeDescription#"
valuesdelimiter=",">
</CFGRID>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
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
