Why am I getting the following error using CFGRID and CFGRIDUPDATE?
ODBC Error Code = S0002 (Base table not found)
[Oracle][ODBC][Ora]ORA-00942: table or view does not exist
Data Source = "mom"
SQL = "UPDATE "dmdr_drop_schedule" SET "MAILPIECES" = ? WHERE "ROWID" = ? "
The error occurred while processing an element with a general identifier of
(CFGRIDUPDATE), occupying document position (3:2) to (6:28) in the template
file C:\Inetpub\wwwroot\dmdr\act_dmdr_update.cfm.
Here's my Grid and Update.
<CFGRID NAME="Drop_Schedule"
HEIGHT="850"
WIDTH="300"
QUERY="GetDMDRDrop"
INSERT="No"
DELETE="No"
SORT="No"
BOLD="No"
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"
SELECTMODE="EDIT"
PICTUREBAR="No">
<CFGRIDCOLUMN NAME="rowid"
SELECT="Yes" DISPLAY="No">
<CFGRIDCOLUMN NAME="id_cluster"
SELECT="Yes" DISPLAY="No">
<CFGRIDCOLUMN NAME="cluster_name" HEADER="Cluster Name"
HEADERALIGN="Left" DATAALIGN="LEFT"
BOLD="No" ITALIC="No"
SELECT="No" DISPLAY="Yes"
HEADERBOLD="Yes" HEADERITALIC="No">
<CFGRIDCOLUMN NAME="id_market"
DISPLAY="No">
<CFGRIDCOLUMN NAME="market_name" HEADER="Market Name"
HEADERALIGN="LEFT" DATAALIGN="LEFT"
BOLD="No" ITALIC="No"
SELECT="No" DISPLAY="Yes"
HEADERBOLD="Yes" HEADERITALIC="No">
<CFGRIDCOLUMN NAME="mailpieces" HEADER="Mailpieces"
HEADERALIGN="LEFT" DATAALIGN="LEFT"
BOLD="No" ITALIC="No"
SELECT="Yes" DISPLAY="Yes"
HEADERBOLD="Yes" HEADERITALIC="No">
</CFGRID>
<CFGRIDUPDATE GRID="Drop_Schedule"
DATASOURCE="MyDSN"
TABLENAME="dmdr_drop_schedule"
KEYONLY="Yes">
If you have any questions or concerns, please feel free to call me at
407-514-5021.
Thank you,
> Issac Rosa
>
> IT - National Sales & Marketing
> OLAP Specialist Team Leader
> Ofc: 407-514-5021
> Cell: 407-342-0644
> Fax: 407-514-5988
> [EMAIL PROTECTED]
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
