Hello I trying to solve this by my self but I can't.

I need to insert an order in the DB I have two tables, Order & OrderDetails, the second could have many items.

I have all the data in hidden text fields and the names with square brackets []; The server connect action works when the form is post.

This is what I made in server actions



But I'm Lost, hope you can help me.

Thanks

Hello Andres,
From your post it is not really clear what exactly do you want to insert and how. Also it is not clear what exactly the issue is.
Please explain a little more detailed what exactly are you doing on your page.

Hi Teodor,

It's a shopping cart and what I need to do is a multiple insert of the items in the cart into the details orders table.

Thanks

Please send a link to your page so i can see what you have on the page already ... it is hard to tell how to do this without seeing your page.

Ok,

Temporal Site:



The last step is the step 4 and the last action, by now, is clear the cart.

So these should be inserted as separate records, in the details table?

Yes, that's correct, the items in the cart.

Well, then in server connect you need:

1. Database query, which returns the items added to the cart
2. Repeat step (repeat the query)
3. Inside the repeat add the insert step and insert in your table - using the query values ... no need of fields for the insert.

No need of [] in the names.. remove them, and re-import post vars in your action file.

Great Now Works, Thank you!