Dear Rosa,
Try copying the CFIDE folder in your WEB SERVER root to the root of your
individual web site in which you have the CFM files with CFGRID tags in
them. Because CFIDE has a classes folder with the java apps that are
required to display the CFGRID elements.
Hope that helps, because I had the same problem a few days ago.
Regards,
Pardeep.
Deep thought for the day:
He was good from far
But far from good.
----- Original Message -----
From: "Rosa, Issac" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 11, 2000 8:48 PM
Subject: CFGRID Error
> 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
