Classification: UNCLASSIFIED Caveats: NONE This is a very simple thing to check. Is the list order different on the two servers for what I think is a selection field. If this is a selection field, the search is on the zero based value rather than the actual words. If the order is reversed, then Active could be 0 and Inactive could be 1 or vice versa. If they are reversed, then you will get the opposite results.
Just a thought! Gordon M. Frank DISA\Verizon FNS -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Tuesday, November 06, 2007 12:08 PM To: [email protected] Subject: Push Field not happening Hello Everyone, We have employee records stored in a "PAY:Employee" form. The Status is either "Active" or "Inactive". The employees each have a unique "Employee e-ID" field. The problem is that some of our employees are, alas, no longer with us, so we want to mark their Statuses as "Inactive? So we have a control panel with a table that displays all the "Active" records. The "Employee e-ID" value is listed in an "Employee e-ID col" column. The user hi-lites the rows he wants to make inactive, and clicks a "De-Activate" button. This calls an active link that calls a guide that loops the table. For each hi-lited record an "inner" active link pushes the value "Inactive" to the record where 'Employee e-ID' = $EmployeeEid col$. The main active link then refreshes the table, and the hi-lited records disappear. If you display them they have indeed been changed to "Inactive". At least that is the way it worked in our test system. We have now brot everything over to the live system, and all the active links fire, and the log shows the link pushing the "Inactive" value to the desired records. BUT the records don't get updated. They do not disappear from the table and when you display them their Status is still "Active." I ran a filter log just in case some other workflow was setting the Status back again, but it wasn't. Besides, the "Last Modified Date" is not getting set. I inserted a message into the "inner" active link to print out the "Employee e-ID col" and it is correct. But the Push Fields is simply not happening. I am running as Administrator, so it can't be a permissions issue. Any ideas? (ARS 7.1, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" Classification: UNCLASSIFIED Caveats: NONE _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
