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 Chriss Miller 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
Joined
Jul 24, 2002
Messages
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