I have been working on this insert query and can not seem to find my error. I am trying to build the insert statement from a form input where some fields may not always exist due to being disabled in the form. Here is my code for the query and the building of the string.
<!--- Test for newLine field --->
<cfif isDefined("newLine")>
<!--- set base value list for insert query --->
<cfset sql_str_val = "#FORM.orderID#, #FORM.styleNumber#, #FORM.sizeScaleID#, #FORM.color#, #FORM.unitPrice#, #FORM.lineTotal#">
<!--- Set base field list for insert query --->
<cfset sql_str = "orderID, styleNumber, sizeScaleID, color, unitPrice, lineTotal">
<!-- start testing to see if field is defined and add to sql string --->
<cfif isDefined("FORM.size1qty")>
<cfset sql_str_val = sql_str_val & ", #FORM.size1qty#">
<cfset sql_str = sql_str & ", size1qty">
</cfif>
<cfif isDefined("FORM.size2qty")>
<cfset sql_str_val = sql_str_val & ", #FORM.size2qty#">
<cfset sql_str = sql_str & ", size2qty">
</cfif>
<cfif isDefined("FORM.size3qty")>
<cfset sql_str_val = sql_str_val & ", #FORM.size3qty#">
<cfset sql_str = sql_str & ", size3qty">
</cfif>
<cfif isDefined("FORM.size4qty")>
<cfset sql_str_val = sql_str_val & ", #FORM.size4qty#">
<cfset sql_str = sql_str & ", size4qty">
</cfif>
<cfif isDefined("FORM.size5qty")>
<cfset sql_str_val = sql_str_val & ", #FORM.size5qty#">
<cfset sql_str = sql_str & ", size5qty">
</cfif>
<cfif isDefined("FORM.size6qty")>
<cfset sql_str_val = sql_str_val & ", #FORM.size6qty#">
<cfset sql_str = sql_str & ", size6qty">
</cfif>
<!--- execute insert query --->
<cfquery name="addLine" datasource="absappa_costmod">
INSERT INTO tblOEOrderDetails (#sql_str#)
VALUES(#sql_str_val#)
</cfquery>
This is the error that the debugger spits out:
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
