DMXzone Database Updater ASP Support Product Page
Answered
Is it possible to insert two records from one form?
Asked 01 Apr 2015 22:17:09
1
has this question
01 Apr 2015 22:17:09 Steve Skinner posted:
I am working on a site that deals with recording flight data. Among the rest of the form fields, two of them are for pilots. There will always been one pilot of course, but many times there is a co-pilot. So... this form has select fields for both. However, both pilots cannot be recorded on the same record - this is a federal guideline. When the form is submitted, it needs to perform two inserts - one for each pilot. All the rest of the fields are the same.Is it possible to perform two inserts as described with the Database Updater, any of your other extensions?
Replies
Replied 02 Apr 2015 10:25:01
02 Apr 2015 10:25:01 Teodor Kuduschiev replied:
Hi Steve,
Please check the following tutorial: www.dmxzone.com/go/22215/retrieve-and-use-the-identity-id-of-an-inserted-record-and-run-multiple-database
Please check the following tutorial: www.dmxzone.com/go/22215/retrieve-and-use-the-identity-id-of-an-inserted-record-and-run-multiple-database