I need to insert a set of records for each new project that is entered.. These are the same for each "New" main record.. There is more code to this that will help link it correctly, but I am wondering if this is the best way to insert the individual records.... Is it good to have all those individual INSERT INTO statements, or is there a way to make this more efficient.
<cfquery name="insertActions" datasource="#Datatables#">
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PDG#', '#x.lastID#', 'Chair Recruited' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PDG#', '#x.lastID#', 'Faculty Recruited' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PDG#', '#x.lastID#', 'Application Submitted' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PDG#', '#x.lastID#', 'Application Approval' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PDG#', '#x.lastID#', 'Faculty Slides' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PDG#', '#x.lastID#', 'Accreditor Review of Slides' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PMG#', '#x.lastID#', 'Venue Secured' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PMG#', '#x.lastID#', 'Academic Partner Informed of Logistics' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PSG#', '#x.lastID#', 'Post Coming Soon' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PSG#', '#x.lastID#', 'Obtain Mailing List' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PSG#', '#x.lastID#', 'Email Blast to Our List' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PSG#', '#x.lastID#', 'Accreditor Review of Invite' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PSG#', '#x.lastID#', 'Registration Site Up/Check for Updated Program Info' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PSG#', '#x.lastID#', 'Invite Mailing ##1' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PSG#', '#x.lastID#', 'Invite Mailing ##2' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PSG#', '#x.lastID#', 'Fax Blast' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PSG#', '#x.lastID#', 'Accreditor Review of Notebook, Posters, etc.' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PSG#', '#x.lastID#', 'Posters with Pockets' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PM#', '#x.lastID#', 'Process Honoraria' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PM#', '#x.lastID#', 'Post Final PD Files on Server' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PM#', '#x.lastID#', 'Post Final Production Files on Server' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PM#', '#x.lastID#', 'Provide ARS Results to Production' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PM#', '#x.lastID#', 'Evaluation Summary to Sales' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PM#', '#x.lastID#', 'Send 4 Week Post OMA' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PM#', '#x.lastID#', 'Provide OMA to Faculty (w/accreditor cc&##39;d)' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PM#', '#x.lastID#', 'Provide Evaluation to Faculty (w/accreditor cc&##39;d)' );
INSERT INTO Actions
( ActionGroupID, ActionProgramID, ActionName) VALUES ( '#PM#', '#x.lastID#', 'Provide OMA Slides to Sales' );
</cfquery>
Start Free Trial
