Does anybody know why <cfgridupdate> is not working for me to update dates
entered into a <cfgrid> in ColdFusion server 4.5?
I used <cfgrid> in <cfform>. One of the <cfgridcolumn> is a DATETIME data
type in MS SQL server 7.0. I then use <cfgridupdate> to update the database.
It works when I update text field, but not the date field. When I type in
a date such as '1/2/2003', I got the following error
<H3>Error Occurred While Processing Request</H3>
<P>
<TABLE border=1>
<TBODY>
<TR>
<TD>
<H4>Error Diagnostic Information</H4>
<P>Grid PriGrid not found.
<P>
<P>The Grid PriGrid must be a control on the submitted form.
<P>
<P>
<P>The error occurred while processing an element with a general
identifier of (CFGRIDUPDATE), occupying document position (17:2) to
(17:86) in the template file
E:\Inetpub\wwwroot\whowhere\TBH\TBHPowerEditAction.cfm.</P>
<P>
<P>Date/Time: 01/23/02 13:59:48<BR>Browser: Mozilla/4.0 (compatible;
MSIE
5.5; Windows NT 5.0)<BR>Remote Address: 10.68.5.157
<P></P></TD></TR></TBODY></TABLE>
...
Here is how I use a CFGRID control
I am using a CFGRID control:
-----------------------------
<cfform name="PGRank" action = "TBHPowerEditAction.cfm" method = "Post">
<cfgrid name="PriGrid" width="1000" query="TBHs" selectmode = "Edit" >
<cfgridcolumn name="ID" select="No" header="ID" width = "80">
<cfgridcolumn name="DPRank" header="DP Rank" width = "80">
<cfgridcolumn name="DPDate" header="DP Date" width = "80">
<cfgridcolumn name="Justification" select="Yes" header="Justification"
width = "200">
</cfgrid>
<br><br>
<input type="Submit" value="Submit">
Here is how I do the update in file 'TBHPowerEditAction.cfm'
------------------------------------------------------------
<cfgridupdate grid="PriGrid"
datasource="#application.datasource#"
tablename="TBHs">
Please let me know if you know what I did wrong.
Thank you in advance!!
Richard
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Richard Li Openwave System, Inc.
E-mail: [EMAIL PROTECTED] http://www.openwave.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
______________________________________________________________________
Why Share?
Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
