Skip to main content
J
jawmusic
Inspiring
June 3, 2012
Question

Missing semicolon (;) at end of SQL statement

  • June 3, 2012
  • 1 reply
  • 8920 views

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>

    This topic has been closed for replies.

    1 reply

    D
    Dan_Bracuk
    Inspiring
    June 3, 2012

    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?

    J
    jawmusicAuthor
    Inspiring
    June 3, 2012

    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

    D
    Dan_Bracuk
    Inspiring
    June 3, 2012

    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

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices