We have a coldfusion page which receives a remote call from a shopping cart. The cart returns data and the page should update the database for the item purchased. Our database has fields used as search variables in the site. The site pulls in the user for the user who owns that variable (zip code for instance). The db needs to be update for all zip codes that a user reserves. We have it properly updating for one item but there are two issues that need to be addressed: 1. multiple orders from one user need to make multiple updates (inserting the user's returned id into the item purchased) for as many items as are purchased. 2. multiple users having purchases made on their behalf. meaning if an admin user reserves items on behalf of 3 different users with multiples for each user all db items need to be updated accordingly. We are recieving the data from the remote call, i believe we just have some looping type needs. We will provide a jump start on the coding by providing our current page. We can also provide a sample code page from the shopping cart tool to assist.
## Deliverables
Fully functioning coldfusion page tested on our server as follows: Database must update userid field properly when receiving remote calls for: 3 item types Multiple userID's Multiple items per userID and per order
## Platform
All browsers