<!--- isnull.cfm --->
<cfscript>
function isNull(myvar){
if(isdefined(myvar))
return evaluate(myvar);
else
return "NULL";
}
</cfscript>
<!--- end isnull.cfm --->
<!--- insert.cfm --->
<cfinclude template="isnull.cfm">
<cfquery name="addLine" datasource="absappa_costmod">
INSERT INTO tblOEOrderDetails
(orderID, styleNumber, sizeScaleID, color, unitPrice, lineTotal
,size1qty,size2qty,size3qty,size4qty,size5qty,size6qty)
VALUES (
#FORM.orderID#, #FORM.styleNumber#, #FORM.sizeScaleID#, #FORM.color#, #FORM.unitPrice#, #FORM.lineTotal#
,#isNull("form.size1qty")#
,#isNull("form.size2qty")#
,#isNull("form.size3qty")#
,#isNull("form.size4qty")#
,#isNull("form.size5qty")#
,#isNull("form.size6qty")#
)
</cfquery>
> Hi again everyone,
>
> 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]
