jimmy cortes
|
Posted: 04/19/2001, 2:00 PM |
|
I have been testing the bookstore example. This example works just with
register members. I have created a
temporal session("userID") wich just exists until the user logs in. this
way, everybody can choose a product without registering. Those products are
stored into the table orders in the same way it was performed before, but
they donīt belong to any registered member until he/she logs in. So, please,
how can I automatically update the temporal member_id into the
table orders to the register member when he/she logs in...?
I have tested the following idea, but there is another problem:
UPDATE orders SET orders.member_id = session("userID")
WHERE (((orders.member_id)=session(uniqueID)));
I know I canīt do this..!!! SQL doesnīt accept this variables.
How can I mix this kind of variables in the same procedure and update them
automatically after a registered member logs in ?
I have no idea.. thanks,
Note:
session("UserID") has got a new value after login(It is done)
session("uniqueID") is a session variable for the products he/she has bought
in this unique session. (It is done)
I had to remove the integrity of the Database to get it.
thanks for your wonderful support....
jimmy
|
|
|
|