[ic] Orders not matching up with users in the UI

[marty]

On Sun, 2003-01-19 at 18:20, Cameron wrote:
[snip]
> 
> v 4.8.6
> Transaction:
>        101010   101010  HAesHaq9  U00008  worldwide (Worldwide Delivery 7-10
> days US$ 35.00)  1  283  35    318  first  last   address   suburb  state
> zip  US  phone    email        AL   US   20030119 19:10:18  20030119  7
> pending     0  0  0
> 
> 
> Orderline:         101010-1  1904  Item Name 283  1  283
> 
> 
> 
> looks right to me :/

Hmm, it's hard to tell because you did not put the headers for the
fields listed however, one glaring error is the lack of an order_number
in the orderline table.  Your first column listed "101010-1" is the line
item and unique code for that row.  Each successive item in that order
will increment the code by 1, ie: 101010-2, 101010-3 etc..  Interchange
will look at the order_number field to determine which order it is
associated with. (a one-to-many relationship) That order number should
be 101010.  Without a proper order number in the field, nothing will
match up.

What's 1904?

-- 
marty <marty@sediva.com>