From: David JL Rieger (drieger@socrates.berkeley.edu)
Date: Fri Nov 02 2001 - 09:03:59 PST
Hello Folks,
Seeing CAL does not have a CF list I thought I'd put this question out to
you all (I apologize for any repeated postings you receive). I'm a having a
bug in an application that I have found the problem but don't understand
why it's happening.
The real short description:
When a button is clicked to post a line item from an order the lineItemNum
doesn't change from the last successful line-item post even though when I
"view source" the source indicates each lineItemNum is different on each
GUI button.
Somehow there is a disconnect between the first page (display and
interaction) and the action page (SQL update page).
The Set-up:
Here's the scenario. I have a purchasing application where people enter
purchase orders. The application is designed to capture financial
information for each line item to allow for granular expense tracking. With
vendors there is a complication that sometimes when you order something
they split ship it or are on back order or substitute something for
something else.
When this happens you can edit the purchase order to create more line items
(this is done for freight as well because usually the purchasing agent
doesn't know how much the freight will be).
On the backend there is an Orders Table, and Order Line-items
table. Orders captures the basic "header" information from the order and
the items tracks all the stuff from each line item. When a person adds a
line the line-item table and it's primary key are incremented.
Later when the invoice is sent to us we "post" the order to the system and
the user adds in the invoice number, date, price each and if that item is
taxable or not. In my GUI I have a "POST" button that once the information
for the line item is entered that information updates the database table
and refreshes the current view so that the user sees the information has
been recorded in the db.
The user can continue to post each line item for stuff that has been received.
The Problem.
The GUI button "POST" contains the orderNum and lineItemNum and the CF
variables are past to the action page with it.
On one order I added three lines, Freight, and two line items. The Freight
posted fine. The problem is when the user clicks on "POST" the lineNumID
remains the one for the Freight even though when I view source on the first
page.
The code indicates each line item has separate lineItemNum's. Would anyone
know how there is a disconnect here (beyond my inability to solve this?).
Regards,
david rieger
**********************************************
David JL Rieger
University of California, Berkeley
PH: 510.643.9666
FX: 510.643.9929
eMail: drieger@socrates.berkeley.edu
"The generation of random numbers is too important to be left to chance."
Robert Coveyou
**********************************************
------------------------------------------------------------------------
The following was automatically added to this message by the list server:
For information about Micronet, its meetings and events, and its
mailing list, including information on subscribing and unsubscribing,
see the Micronet Web site at <http://wss.berkeley.edu/micronet/>.
This archive was generated by hypermail 2b29 : Fri Nov 02 2001 - 09:06:37 PST