On Sun, 3 Oct 2004 12:59:01 +0100, Des Quinn
Hi,
Is it intentional that if you have an existing user with tickets that if you change the cstomer id that they appear to have no tickets associated with them the next time they log in.
Yes, this will happen If you change the customers id in the database where customer id is drawn from (because all tickets have a customer id associated as well to be able to match up customer with ticket). Scenario. Customer with id 1 creates a ticket. Ticket also has customer id value of 1. Customer ------------ cust id = 1 A Match! Ticket ------------ cust id = 1 If you change the Customer's cust id to 2, then you have: Customer ------------ cust id = 2 No Match! Ticket ------- cust id = 1
if you change the customer id back to its original value then the tickets reappear. I am guessing that this is relating to the customer_id value in the ticket table.
Yep, exactly. See above.
If I wish to change the customer ids in use can I just ho thru the ticket table and change the customer_id to the new values and the tickets should retain their association with the user?
Exactly. If you change the customer's id, you also have to change the cust id of all the tickets. Hth, Tyler Hepworth