?
Solved

MM_INSERT

Posted on 2004-08-19
1
Medium Priority
?
502 Views
Last Modified: 2010-05-18
I have an ASP page that i want to create 2 separate insert fuction on.

Is this possible?

the forms inserts will not in anyway be retated to each other.

I am using DWMX if i upgraded to DMMX04 is the function i want to achive able to be done ?



Willa
0
Comment
Question by:willa666
1 Comment
 
LVL 8

Accepted Solution

by:
alexhogan earned 2000 total points
ID: 11842930
In a word.., yes its possible.

You will have to do some hand coding to accomplish this effectively.

What you would want to do is have two forms that submitted to the insert queries.

You would have the two seperate insert queries in a branching statement that is looking for a value from a hidden field in each of your forms.

Create your insert queries as you will and then hard code the values into the hidden fields on your form to match with the branching on your insert page.

Or,

If you wanted to only have one submittal then you would have to have a hidden field that would act as a seperator between the two series of inserted values.  You will need to insure that the names of the fields that you are gathering data from match the names of the fileds in your database. (I will explain in a minute)

You would want to work from the POST values directly so you can parse them at the hidden field value to seperate the two arrays.  Since you have named the fields collecting the data from your page the same as the field names in the database you will have a key=>value structure that you can use with a blanket query structure.

From there you can send the values from the two seperate arrays to the insert query along with the table value and just call this query twice.  Once for the first insert and once for the second.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses
Course of the Month14 days, 16 hours left to enroll

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question