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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists