Al, Thanks! That gets me off on that part.
Next question: I need to pull the values out so I have an 'update' form. You'll see that I'm listing the variables to see if the right values are being pulled from the db. Only the first one is pulled. Do I have to loop through the list_org query somehow too? I'm really very confused. This is what I've got: <cfif IsDefined('form.action')> <cfif IsDefined("form.org") AND ListLen(form.org) GT 0> <cfloop list="#form.org#" index="i"> <cfquery name="addorg" datasource="#DSN#"> INSERT INTO org_admin ( users_id, org_id ) VALUES ( #form.users_id#, '#i#' ) </cfquery> </cfloop> </cfif> </cfif> <!--- GENERIC QUERIES AND VARIABLE SETTING ---> <cfquery name="list" datasource="#DSN#"> SELECT * FROM organizations ORDER BY org_abbr </cfquery> <cfquery name="list_org" datasource="#DSN#"> SELECT org_admin.id AS org_id, * FROM org_admin </cfquery> <!--- END GENERIC QUERIES AND VARIABLE SETTING ---> <cfform action="" method="post"> <table border="0" cellpadding="0" cellspacing="0"> <tr> <td width="25%"> </td> <td colspan="3"> <table cellpadding="2" cellspacing="0" width="100%"> <tr> <td>Please select the Lung Associations that this user is responsible for:</td> </tr> <tr> <td> <CF_Columns Cols="3" Records="#list.RecordCount#"> <table border="0" cellpadding="2" cellspacing="0" width="100%"> <tr> <!--- Loop through the number of columns desired. ---> <cfloop index="LoopCount" from="1" to="3"> <!--- Access the start and end variables created by the custom tag. ---> <cfset #start# = ("start" & #LoopCount#)> <cfset #end# = ("end" & #LoopCount#)> <td valign="top"> <cfoutput query="list" startrow="#Evaluate(start)#" maxrows="#Evaluate(end)#"> #list.id# #list_org.org_id# <cfif list_org.org_id EQ list.id> <cfset checked = "Yes"> <cfelse> <cfset checked = "No"> </cfif> <cfinput type="checkbox" value="#list.id#" name="org" checked=#checked# /> #org_abbr#<br> </cfoutput> </td> </cfloop> </tr> </table> </td> </tr> </table> <br /> </td> </tr> <tr> <td width="25%"> </td> <td colspan="3"> <cfoutput><input type="hidden" name="users_id" value="#url.id#"></cfoutput> <input type="hidden" name="action" value="add"> <input type="submit" name="Submit"> </td> </tr> </table> </cfform> </body> </html> > -----Original Message----- > From: Everett, Al [mailto:[EMAIL PROTECTED] > Sent: February 26, 2003 9:04 AM > To: CF-Talk > Subject: RE: Dynamic Insert > > > Change: > > <cfinput type="checkbox" value="1" name="org" />#org_abbr#<br> <input type="hidden" > name="org_id" value="#list.id#"> > > To: > > <cfinput type="checkbox" value="#list.id#" name="org_id" > />#org_abbr#<br> > > > Then on your action page your Form.org_id field will be a > comma-delimited list of org_id's. > > > Then you can just do this: > > <cfif IsDefined('form.action')> > <cfif IsDefined("Form.org_id") AND ListLen(Form.org_id) GT 0> > <cfloop list="#Form.org_id#" index="i"> > <cfquery name="addorg" datasource="#DSN#"> > INSERT INTO org_admin > ( > users_id, > org_id > ) > VALUES > ( > #form.users_id#, > '#i#' > ) > </cfquery> > </cfloop> > </cfif> > </cfif> > > > > > -----Original Message----- > > From: Jillian Carroll [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, February 26, 2003 9:53 AM > > To: CF-Talk > > Subject: Dynamic Insert > > > > > > I've been working on this for a while and I've created a test page > > before I move this over to my full form. > > > > How can I create a loop that will allow my insert to work? > > > > This is what I have: > > > > <cfif IsDefined('form.action')> > > <cfquery name="addorg" datasource="#DSN#"> > > INSERT INTO org_admin (users_id, org_id) > > VALUES (#form.users_id#,'#form.org_id#') > > </cfquery> > > </cfif> > > > > <!--- GENERIC QUERIES AND VARIABLE SETTING ---> > > > > <cfquery name="list" datasource="#DSN#"> > > SELECT * FROM organizations ORDER BY org_abbr > > </cfquery> > > > > <!--- END GENERIC QUERIES AND VARIABLE SETTING ---> > > > > <cfform action="" method="post"> > > <table border="0" cellpadding="0" cellspacing="0"> > > <tr> > > <td colspan="3"> > > <table cellpadding="2" cellspacing="0" width="100%"> > > <tr> > > <td>Please select the Lung Associations that this user is > > responsible for:</td> > > </tr> > > <tr> > > <td> > > <CF_Columns Cols="3" Records="#list.RecordCount#"> > > > > <table border="0" cellpadding="2" cellspacing="0" > > width="100%"> > > <tr> > > <!--- Loop through the number of columns desired. ---> > > <cfloop index="LoopCount" from="1" to="3"> > > <!--- Access the start and end variables created by > the custom > > tag. ---> > > <cfset #start# = ("start" & #LoopCount#)> > > <cfset #end# = ("end" & #LoopCount#)> > > <td valign="top"> > > <cfoutput query="list" startrow="#Evaluate(start)#" > > maxrows="#Evaluate(end)#"> > > <cfinput type="checkbox" value="1" name="org" /> > > #org_abbr#<br> > > <input type="hidden" name="org_id" > value="#list.id#"> > > </cfoutput> > > </td> > > </cfloop> > > </tr> > > </table> > > </td> > > </tr> > > </table> > > <br /> > > </td> > > </tr> > > <tr> > > <td width="25%"> </td> > > <td colspan="3"> > > <cfoutput><input type="hidden" name="users_id" > > value="#url.id#"></cfoutput> > > <input type="hidden" name="action" value="add"> > > <input type="submit" name="Submit"> > > </td> > > </tr> > > </table> > > </cfform> > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4