them. Users will fill in a number in the text box next to
each class and then hit submit.
I'm trying to loop through the results and INSERT a
class_id, section number, enrollment number, and date for
each class.
I use the following code to loop through checkboxes on
another page, so I'm not sure why this gives me an error.
("Syntax error in INSERT INTO statement.")
<!-- create lists for values --->
<cfset class_id_list="#form.class_id#">
<cfset section_no_list="#form.section_no#">
<cfset class_enrollment_list="#form.class_enrollment#">
<!--- loop through and set enrollment for each class --->
<cfloop index="i" from="1" to="#ListLen(class_id_list)#">
<cfquery name="q_approve_class"
datasource="#application.db#">
INSERT INTO tbl_class_enrollment (class_id,
class_enrollment, section_no, date)
VALUES (#ListGetAt(class_id_list, i)#,
'#ListGetAt(class_enrollment_list, i)#',
'#ListGetAt(section_no_list, i)#', '#enrollment_date#');
</cfquery>
</cfloop>
This is the outputted SQL:
INSERT INTO tbl_class_enrollment (class_id,
class_enrollment, section_no, date) VALUES (841, '2',
'03280', '4/20/2004');
Any ideas?
--
Austin
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
