[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
This is the second page of a multiple stage form, the first page passes the experiment and nogroups arguments, which nogroups is an integer.
This is the coded loop section in which i am generating database entries from A to whatever character is the last group needed based on the integer passed from the first form. This is to create groups in the database based off each experiment and have a different database entry with no primary key for each time the loop executes.
I have a feeling that there is a better way to insert a new line of data into the database other than the way I am doing in this code, which is why i am getting the syntax error that I am getting in trying to set variables to the formfields.
<strong>Experiment:</strong> <cfoutput>#form.experiment#<input type="hidden" name="experiment" value="#experiment#"></cfoutput>
Created groups named:<br><input type="text" name="nogroups"><br><br>
<cfset numgrp = (65+#form.nogroups#)>
<cfset expername = '#form.experiment#'>
<cfoutput>#form.experiment#_#chr(character)#<cfset group = '#chr(character)#'></cfoutput><br>
<cfinsert datasource="animal" tablename="expergroup" formfields="expername,group">
><cfset group = '#chr(character)#'>
<cfset form.group = '#chr(character)#'>