Solved

MM_INSERT

Posted on 2004-08-19
1
489 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 500 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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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 …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

708 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now