I'd like to know if I'm going about doing this in the right way.
Basically I have an xml document I want to post to the internet, capture and submit to a database.
I have an xml document in simple flat format, eg:
<Jobs>
<Job>
<DeliveryDate>01/10/01</DeliveryDate>
<DeliveryTime>18:00</DeliveryTime>
<DeliveryAddress>London</DeliveryAddress>
<CollectionDate>29/09/01</CollectionDate>
<CollectionTime>17:00</CollectionTime>
<CollectionAddress>Newcastle</CollectionAddress>
</Job>
<Job>
<DeliveryDate>01/10/01</DeliveryDate>
AND SO ON.......
</Job>
</Jobs>
I can post it to the internet and populate a dynamic asp form with the contents of the xml document. The form is validated with a dtd to check for validity. If I add more jobs to the xml document the form adds more fields to take up the extra info, although all of the fields in the form are named the same, Ie if there are two 'Jobs' in the document I have two DeliveryAddress fields, tow DeliveryTime fields, etc.
Here is where I get stuck. I know I can't submit all of the info to the data base at once, I'd have to post the first job then loop back around and post the second job.
How on earth do you go about doing this?
If anyone can point me in the right direction I'd be very grateful.
Regards,
Kevin Marshall.
I want to submit this info to a database
Basically I have an xml document I want to post to the internet, capture and submit to a database.
I have an xml document in simple flat format, eg:
<Jobs>
<Job>
<DeliveryDate>01/10/01</DeliveryDate>
<DeliveryTime>18:00</DeliveryTime>
<DeliveryAddress>London</DeliveryAddress>
<CollectionDate>29/09/01</CollectionDate>
<CollectionTime>17:00</CollectionTime>
<CollectionAddress>Newcastle</CollectionAddress>
</Job>
<Job>
<DeliveryDate>01/10/01</DeliveryDate>
AND SO ON.......
</Job>
</Jobs>
I can post it to the internet and populate a dynamic asp form with the contents of the xml document. The form is validated with a dtd to check for validity. If I add more jobs to the xml document the form adds more fields to take up the extra info, although all of the fields in the form are named the same, Ie if there are two 'Jobs' in the document I have two DeliveryAddress fields, tow DeliveryTime fields, etc.
Here is where I get stuck. I know I can't submit all of the info to the data base at once, I'd have to post the first job then loop back around and post the second job.
How on earth do you go about doing this?
If anyone can point me in the right direction I'd be very grateful.
Regards,
Kevin Marshall.
I want to submit this info to a database