Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CFGridUpdate error

Status
Not open for further replies.

dfwalton

Programmer
Jul 24, 2002
143
I am working on a timesheet app. I have start and stop times for each worker for a given event, and am using CFGRID to be able to process all of them at once.

To get the date/times properly formatted in the grid, I have used the following construct:
<CFGrid.....
<CFGridColumns....

<cfloop query = &quot;EmpInEvent&quot;>

<cfset StartFormatted = &quot;#timeFormat(Starttime, &quot;HH:mm&quot;)#&quot;>

<CFGRIDROW data = &quot;#REGION#, #EmpNum# ... #StartFormatted#....

</cfloop>
</cfgrid>
</cfform>

Grid displays beautifully. Problem occurs when I attempt to save the data. Here is what I get:

&quot;Error casting an object of type java.sql.Timestamp to an incompatible type. This usually indicates a programming error in java, although it could also mean you have tried to us a foreign object in a different way than it was designed.&quot;

Anyone know any workarounds to this, or any reasonable alternatives to CFGRID?

Thanks in advance
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top