Missing semicolon (;) at end of SQL statement

[jawmusic]

I'm getting this error on a form in which I'm trying to upload multiple files as well as populate a database with information about them all in one query. In addition, not every file field will be used every time the form is submitted, so I have some <cfif> tags to prevent errors in the event the fields are empty. I was able to get the form to work with only two file fields (leaving the second one blank to check that there would be no errors with blank fields), but when I expanded it to the full 15 (and all I did is copy and paste the code and update the field numbers), I get this error:

Error Executing Database Query.

Missing semicolon (;) at end of SQL statement.

The error occurred in C:\ColdFusion9\wwwroot\CrimsonTideBand\admin\upload.cfm: line 477

Called from C:\ColdFusion9\wwwroot\CrimsonTideBand\admin\upload.cfm: line 14

Called from C:\ColdFusion9\wwwroot\CrimsonTideBand\admin\upload.cfm: line 1

Called from C:\ColdFusion9\wwwroot\CrimsonTideBand\admin\upload.cfm: line 477

Called from C:\ColdFusion9\wwwroot\CrimsonTideBand\admin\upload.cfm: line 14

Called from C:\ColdFusion9\wwwroot\CrimsonTideBand\admin\upload.cfm: line 1

475:  </cfif>)

476:  </cfif>

477:  <cfif IsDefined("FORM.File15") AND #FORM.File15# NEQ "">,

478:  (<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

479:  <cfqueryparam value="#FORM.Ensemble# cfsqltype="cf_sql_clob" maxlength="255">

Here is my full SQL for this query. Any help would be greatly appreciated. Also, if there's a more streamlined way to handle this sort of situation, that would be great as well. (Sorry, it's pretty long, but most of it is repetitive):

<cfset CurrentPage=GetFileFromPath(GetBaseTemplatePath())>

<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "upload">

  <cfquery datasource="ctband">

    INSERT INTO Files (Ensemble, Category, Selection, Part, File_Name, Uploaded_By)

    VALUES (<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

    <cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

    <cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

    <cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Part1") AND #FORM.Part1# NEQ "">

    <cfqueryparam value="#FORM.Part1#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.File1") AND #FORM.File_Name1# NEQ "">

    <cfqueryparam value="#FORM.File_Name1#" cfsqltype="cf_sql_clob" maxlength="255">

    <cffile action="upload" filefield="File1" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

    <cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>)

    <cfif IsDefined("FORM.File2") AND #FORM.File2# NEQ "">,

    (<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

    <cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

    <cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

    <cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Part2") AND #FORM.Part2# NEQ "">

    <cfqueryparam value="#FORM.Part2#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.File2") AND #FORM.File_Name2# NEQ "">

    <cfqueryparam value="#FORM.File_Name2#" cfsqltype="cf_sql_clob" maxlength="255">

    <cffile action="upload" filefield="File2" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

    <cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>)

    </cfif>

    <cfif IsDefined("FORM.File3") AND #FORM.File3# NEQ "">,

    (<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

    <cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

    <cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

    <cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Part3") AND #FORM.Part3# NEQ "">

    <cfqueryparam value="#FORM.Part3#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.File3") AND #FORM.File_Name3# NEQ "">

    <cfqueryparam value="#FORM.File_Name3#" cfsqltype="cf_sql_clob" maxlength="255">

    <cffile action="upload" filefield="File3" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

    <cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>)

    </cfif>

    <cfif IsDefined("FORM.File4") AND #FORM.File4# NEQ "">,

    (<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

    <cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

    <cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

    <cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Part4") AND #FORM.Part4# NEQ "">

    <cfqueryparam value="#FORM.Part4#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.File4") AND #FORM.File_Name4# NEQ "">

    <cfqueryparam value="#FORM.File_Name4#" cfsqltype="cf_sql_clob" maxlength="255">

    <cffile action="upload" filefield="File4" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

    <cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>)

    </cfif>

    <cfif IsDefined("FORM.File5") AND #FORM.File5# NEQ "">,

    (<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

    <cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

    <cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

    <cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Part5") AND #FORM.Part5# NEQ "">

    <cfqueryparam value="#FORM.Part5#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.File5") AND #FORM.File_Name5# NEQ "">

    <cfqueryparam value="#FORM.File_Name5#" cfsqltype="cf_sql_clob" maxlength="255">

    <cffile action="upload" filefield="File5" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

    <cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>)

    </cfif>

    <cfif IsDefined("FORM.File6") AND #FORM.File6# NEQ "">,

    (<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

    <cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

    <cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

    <cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Part6") AND #FORM.Part6# NEQ "">

    <cfqueryparam value="#FORM.Part6#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.File6") AND #FORM.File_Name6# NEQ "">

    <cfqueryparam value="#FORM.File_Name6#" cfsqltype="cf_sql_clob" maxlength="255">

    <cffile action="upload" filefield="File6" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

    <cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>)

    </cfif>

    <cfif IsDefined("FORM.File7") AND #FORM.File7# NEQ "">,

    (<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

    <cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

    <cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

    <cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Part7") AND #FORM.Part7# NEQ "">

    <cfqueryparam value="#FORM.Part7#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.File7") AND #FORM.File_Name7# NEQ "">

    <cfqueryparam value="#FORM.File_Name7#" cfsqltype="cf_sql_clob" maxlength="255">

    <cffile action="upload" filefield="File7" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

    <cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>)

    </cfif>

    <cfif IsDefined("FORM.File8") AND #FORM.File8# NEQ "">,

    (<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

    <cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

    <cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

    <cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Part8") AND #FORM.Part8# NEQ "">

    <cfqueryparam value="#FORM.Part8#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.File8") AND #FORM.File_Name8# NEQ "">

    <cfqueryparam value="#FORM.File_Name8#" cfsqltype="cf_sql_clob" maxlength="255">

    <cffile action="upload" filefield="File8" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

    <cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>)

    </cfif>

    <cfif IsDefined("FORM.File9") AND #FORM.File9# NEQ "">,

    (<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

    <cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

    <cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

    <cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Part9") AND #FORM.Part9# NEQ "">

    <cfqueryparam value="#FORM.Part9#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.File9") AND #FORM.File_Name9# NEQ "">

    <cfqueryparam value="#FORM.File_Name9#" cfsqltype="cf_sql_clob" maxlength="255">

    <cffile action="upload" filefield="File9" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

    <cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>)

    </cfif>

    <cfif IsDefined("FORM.File10") AND #FORM.File10# NEQ "">,

    (<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

    <cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

    <cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

    <cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Part10") AND #FORM.Part10# NEQ "">

    <cfqueryparam value="#FORM.Part10#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.File10") AND #FORM.File_Name10# NEQ "">

    <cfqueryparam value="#FORM.File_Name10#" cfsqltype="cf_sql_clob" maxlength="255">

    <cffile action="upload" filefield="File10" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

    <cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>)

    </cfif>

    <cfif IsDefined("FORM.File11") AND #FORM.File11# NEQ "">,

    (<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

    <cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

    <cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

    <cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Part11") AND #FORM.Part11# NEQ "">

    <cfqueryparam value="#FORM.Part11#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.File11") AND #FORM.File_Name11# NEQ "">

    <cfqueryparam value="#FORM.File_Name11#" cfsqltype="cf_sql_clob" maxlength="255">

    <cffile action="upload" filefield="File11" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

    <cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>)

    </cfif>

    <cfif IsDefined("FORM.File12") AND #FORM.File12# NEQ "">,

    (<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

    <cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

    <cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

    <cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Part12") AND #FORM.Part12# NEQ "">

    <cfqueryparam value="#FORM.Part12#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.File12") AND #FORM.File_Name12# NEQ "">

    <cfqueryparam value="#FORM.File_Name12#" cfsqltype="cf_sql_clob" maxlength="255">

    <cffile action="upload" filefield="File12" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

    <cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>)

    </cfif>

    <cfif IsDefined("FORM.File13") AND #FORM.File13# NEQ "">,

    (<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

    <cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

    <cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

    <cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Part13") AND #FORM.Part13# NEQ "">

    <cfqueryparam value="#FORM.Part13#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.File13") AND #FORM.File_Name13# NEQ "">

    <cfqueryparam value="#FORM.File_Name13#" cfsqltype="cf_sql_clob" maxlength="255">

    <cffile action="upload" filefield="File13" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

    <cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>)

    </cfif>

    <cfif IsDefined("FORM.File14") AND #FORM.File14# NEQ "">,

    (<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

    <cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

    <cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

    <cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Part14") AND #FORM.Part14# NEQ "">

    <cfqueryparam value="#FORM.Part14#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.File14") AND #FORM.File_Name14# NEQ "">

    <cfqueryparam value="#FORM.File_Name14#" cfsqltype="cf_sql_clob" maxlength="255">

    <cffile action="upload" filefield="File14" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

    <cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>)

    </cfif>

    <cfif IsDefined("FORM.File15") AND #FORM.File15# NEQ "">,

    (<cfif IsDefined("FORM.Ensemble") AND #FORM.Ensemble# NEQ "">

    <cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">

    <cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Selection") AND #FORM.Selection# NEQ "">

    <cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.Part15") AND #FORM.Part15# NEQ "">

    <cfqueryparam value="#FORM.Part15#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("FORM.File15") AND #FORM.File_Name15# NEQ "">

    <cfqueryparam value="#FORM.File_Name15#" cfsqltype="cf_sql_clob" maxlength="255">

    <cffile action="upload" filefield="File15" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

    <cfelse>

    ''

    </cfif>

    , <cfif IsDefined("SESSION.MM_Username") AND #SESSION.MM_Username# NEQ "">

    <cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_clob" maxlength="255">

    <cfelse>

    ''

    </cfif>)

    </cfif>

  </cfquery>

  <cflocation url="/admin/upload_confirm.cfm">

</cfif>

[Dan_Bracuk]

In an insert query, the number of fields has to equal the number of values.  In your case, since you are referring to some form fields more than once, it doesn't.

Also, why are you using clob datatypes?

[jawmusic]

Thanks for the help, Dan. the clob datatypes are a remnant from older forms that I made with Dreamweaver. I still use Dreamweaver, but I write most everything myself, I just use it for the code hinting to sort of speed up the process. I didn't really know the difference for that and it worked on my other forms, so I just left it. Text should probably be varchar, I assume?

As for referencing fields more than once, is there another way to do that so I don't have to re-enter those values for all 15 records?

Thanks again!

Jeremy

[Dan_Bracuk]

As for referencing fields more than once, is there another way to do that so I don't have to re-enter those values for all 15 records?

loops

[jawmusic]

Okay, I've rewritten the page and sql using loops. The problem I have is that if I don't use all the file fields, I get the error message:

The form field File2 did not contain a file.

(substitute whatever file field is the first empty one).

What I tried to do was insert <cfif> tags to overlook the blank entries. Here's my new SQL:

<cfif IsDefined ("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "upload">

  <cfloop from="1" to="15" index="counter">

    <cfset CurrentPart="FORM.Part#counter#">

    <cfif #CurrentPart# NEQ "">

      <cffile action="upload" filefield="File#counter#" destination="C:\Coldfusion9\wwwroot\CrimsonTideBand\#FORM.Ensemble#\member_files" nameconflict="overwrite">

      <cfquery datasource="ctband">

        INSERT INTO Files (Ensemble, Category, Selection, File_Name, Part, Uploaded_By)

        VALUES (<cfqueryparam value="#FORM.Ensemble#" cfsqltype="cf_sql_varchar">,

                <cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_varchar">,

                <cfqueryparam value="#FORM.Selection#" cfsqltype="cf_sql_varchar">,

                "#CFFILE.serverFile#",

                <cfqueryparam value="#CurrentPart#" cfsqltype="cf_sql_varchar">,

                <cfqueryparam value="#SESSION.MM_Username#" cfsqltype="cf_sql_varchar">)

      </cfquery>

    </cfif>

  </cfloop>

</cfif>

Any thoughts on how to get it to overlook the unused file fields, or stop the loop at the last populated field?

Thanks for your help!

[Dan_Bracuk]

How many form fields do you have?

[jawmusic]

5. Ensemble, Category, and Selection apply to all entries, and then the file

upload and Part fields are specific to each file being uploaded. Trying to

be able to upload up to 15 files at a time.

Connected by DROID on Verizon Wireless

[jawmusic]

Got it working! Thanks for your help!

Connected by DROID on Verizon Wireless