Does anyone have any suggestions on how to set up Bob Swift's Run & SQL plugins so that you can insert multiple lines into a MySQL DB, rather than running the plugin several times?
What I would like to do is set up a Run form where users can select multiple choices, each choice would represent 1 entry into the DB.
Example: A user needs to request an enhancement, which has multiple impacts to a business area. The form would have sections like so:
Each entry into the DB represents 1 impact, so if the use selects more than one impact (3 in the case above), then there will be multiple entries into the DB.
With MySQL, I know I can write multiple Insert qeries, each seperated with a ";".
INSERT into Tbl_enhancements
(reqNBR, reqDESC, busAREA, IMPACT)
VALUES
($req, $desc, $busarea, $impact);
How can I set up the SQL Plugin so it knows to use the INSERT query as many times as there are impacts?
Since the impact is represented by $impact in the Run Plugin, how do I differentiate between each entry?
Has anyone done this before?
Does anyone have some examples that they could share?
There are a few ways to solve this. You need some sort of logic.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.