Discussion Locked

asp question.

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

hello,
i am doing a designing a website and an online transaction for a granite company & i am using asp, java script, html,oracle 8. i have a doubt in asp which is threatening the completion of my project.

the problem goes like this. the userhas an option of selecting 36 different granite slabs from the website and placing the order for the company. the thumbnail pics of the 36 stones is displayed on a page. the user has to just tick the checkboxes of the the stones he wants to order and then after doing it he gets the details of his order in an order form and then he has to enter some details like quantity and size.

the problem starts now. say the customer has selected 3 stones for eg.

slno stonename size price quantity total

1 hassangreen 10mm 100 10 1000
2
3

the order form looks something like the above. the data has to be sent to the oracle table. now how to insert all the 3 rows of data into the table. the submit button used to send the dataworks for only one row and the fields are refreshed.

how to send the 3 rows (for eg.) of data using activer server pages (ASP) at one instance or at the click of the submit button once.

thank you.

3 replies

by anthony.biondo

why not setup an SQL statement doing the insert then execute for example:

setup connection

first row insert statement
execute

second row insert statement
execute

third row insert statement
execute

close connection

use the sameinstance of teh object so you dont re create it ;o)

This discussion is closed to new replies.