Direct to Web, Refresh change_stamp column
Direct to Web, Refresh change_stamp column
- Subject: Direct to Web, Refresh change_stamp column
- From: Justin Tocci <email@hidden>
- Date: Fri, 20 Aug 2004 13:45:22 -0500
Hi all. I've got a many-to-many table relationship in postgres working
with several Direct to Web generated pages that I'm going to put into
an application. My problem is that I have a change_stamp column in all
my tables that is updated by a TRIGGER in postgresl.
So if anyone changes any data in a given record, the change_stamp
column in that record gets a new date and time automatically.
Problem is my model isn't aware of this. I make a change, it commits
the change (but doesn't realize the change_stamp column has changed)
and when I go to make another change to the same record I get:
Could not save your changes:
updateValuesInRowDescribedByQualifier --
com.webobjects.jdbcadaptor.JDBCChannel method failed to update row in
database
Which wouldn't be the end of the world except it still doesn't do a
refresh and there is no refresh button in the Direct to Web pages that
I am aware of.
Am I missing a checkbox or setting somewhere that will fix this? I've
got non-WebObjects applications that change data and that will likely
cause the same problem, so I need it to re-fetch the data after every
commit, and whenever the above error occurs.
Any hints greatly appreciated.
justin tocci
fort wayne, in
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.