asked on
<--Here is the coldfusion code from the update record form-->
<cfset CurrentPage=GetFileFromPath(GetBaseTemplatePath())>
<cfif IsDefined("FORM.MM_UpdateRecord") AND FORM.MM_UpdateRecord EQ "form1">
<cfquery datasource="CatalogInfo">
UPDATE tblproducts
SET RecordComplete=<cfif IsDefined("FORM.RecordComplete")>
1
<cfelse>
0
</cfif>
, Description_Short=<cfif IsDefined("FORM.Description_Short") AND #FORM.Description_Short# NEQ "">
<cfqueryparam value="#FORM.Description_Short#" cfsqltype="cf_sql_clob" maxlength="255">
<cfelse>
''
</cfif>
, Description_Long=<cfif IsDefined("FORM.Description_Long") AND #FORM.Description_Long# NEQ "">
<cfqueryparam value="#FORM.Description_Long#" cfsqltype="cf_sql_clob" maxlength="65535">
<cfelse>
''
</cfif>
, Crossover_No1=<cfif IsDefined("FORM.Crossover_No1") AND #FORM.Crossover_No1# NEQ "">
<cfqueryparam value="#FORM.Crossover_No1#" cfsqltype="cf_sql_clob" maxlength="50">
<cfelse>
''
</cfif>
, Crossover_No2=<cfif IsDefined("FORM.Crossover_No2") AND #FORM.Crossover_No2# NEQ "">
<cfqueryparam value="#FORM.Crossover_No2#" cfsqltype="cf_sql_clob" maxlength="50">
<cfelse>
''
</cfif>
, IndustrialNumber=<cfif IsDefined("FORM.IndustrialNumber") AND #FORM.IndustrialNumber# NEQ "">
<cfqueryparam value="#FORM.IndustrialNumber#" cfsqltype="cf_sql_numeric">
<cfelse>
NULL
</cfif>
, TBDisc=<cfif IsDefined("FORM.TBDisc")>
1
<cfelse>
0
</cfif>
, Program=<cfif IsDefined("FORM.Program") AND #FORM.Program# NEQ "">
<cfqueryparam value="#FORM.Program#" cfsqltype="cf_sql_clob" maxlength="50">
<cfelse>
''
</cfif>
, Category=<cfif IsDefined("FORM.Category") AND #FORM.Category# NEQ "">
<cfqueryparam value="#FORM.Category#" cfsqltype="cf_sql_clob" maxlength="50">
<cfelse>
''
</cfif>
, SubCat1=<cfif IsDefined("FORM.SubCat1") AND #FORM.SubCat1# NEQ "">
<cfqueryparam value="#FORM.SubCat1#" cfsqltype="cf_sql_clob" maxlength="50">
<cfelse>
''
</cfif>
, SubCat2=<cfif IsDefined("FORM.SubCat2") AND #FORM.SubCat2# NEQ "">
<cfqueryparam value="#FORM.SubCat2#" cfsqltype="cf_sql_clob" maxlength="50">
<cfelse>
''
</cfif>
, SubCat3=<cfif IsDefined("FORM.SubCat3") AND #FORM.SubCat3# NEQ "">
<cfqueryparam value="#FORM.SubCat3#" cfsqltype="cf_sql_clob" maxlength="50">
<cfelse>
''
</cfif>
, IncludeInCatalog=<cfif IsDefined("FORM.IncludeInCatalog")>
1
<cfelse>
0
</cfif>
, Picture=<cfif IsDefined("FORM.Picture") AND #FORM.Picture# NEQ "">
<cfqueryparam value="#FORM.Picture#" cfsqltype="cf_sql_clob" maxlength="65535">
<cfelse>
''
</cfif>
, LgSlide=<cfif IsDefined("FORM.LgSlide") AND #FORM.LgSlide# NEQ "">
<cfqueryparam value="#FORM.LgSlide#" cfsqltype="cf_sql_clob" maxlength="65535">
<cfelse>
''
</cfif>
, Thumb=<cfif IsDefined("FORM.Thumb") AND #FORM.Thumb# NEQ "">
<cfqueryparam value="#FORM.Thumb#" cfsqltype="cf_sql_clob" maxlength="65535">
<cfelse>
''
</cfif>
, MedSlide=<cfif IsDefined("FORM.MedSlide") AND #FORM.MedSlide# NEQ "">
<cfqueryparam value="#FORM.MedSlide#" cfsqltype="cf_sql_clob" maxlength="65535">
<cfelse>
''
</cfif>
, HiResTIFF=<cfif IsDefined("FORM.HiResTIFF") AND #FORM.HiResTIFF# NEQ "">
<cfqueryparam value="#FORM.HiResTIFF#" cfsqltype="cf_sql_clob" maxlength="65535">
<cfelse>
''
</cfif>
, zippedTif=<cfif IsDefined("FORM.zippedTif") AND #FORM.zippedTif# NEQ "">
<cfqueryparam value="#FORM.zippedTif#" cfsqltype="cf_sql_clob" maxlength="65535">
<cfelse>
''
</cfif>
, IMGApproved=<cfif IsDefined("FORM.IMGApproved")>
1
<cfelse>
0
</cfif>
, GrpImage=<cfif IsDefined("FORM.GrpImage")>
1
<cfelse>
0
</cfif>
, GrpImageName=<cfif IsDefined("FORM.GrpImageName") AND #FORM.GrpImageName# NEQ "">
<cfqueryparam value="#FORM.GrpImageName#" cfsqltype="cf_sql_clob" maxlength="50">
<cfelse>
''
</cfif>
, NoPicNeeded=<cfif IsDefined("FORM.NoPicNeeded")>
1
<cfelse>
0
</cfif>
, MSDS=<cfif IsDefined("FORM.MSDS") AND #FORM.MSDS# NEQ "">
<cfqueryparam value="#FORM.MSDS#" cfsqltype="cf_sql_clob" maxlength="50">
<cfelse>
''
</cfif>
, Comments=<cfif IsDefined("FORM.Comments") AND #FORM.Comments# NEQ "">
<cfqueryparam value="#FORM.Comments#" cfsqltype="cf_sql_clob" maxlength="65535">
<cfelse>
''
</cfif>
, MNumber=<cfif IsDefined("FORM.MNumber") AND #FORM.MNumber# NEQ "">
<cfqueryparam value="#FORM.MNumber#" cfsqltype="cf_sql_clob" maxlength="50">
<cfelse>
''
</cfif>
, CatLocation=<cfif IsDefined("FORM.CatLocation") AND #FORM.CatLocation# NEQ "">
<cfqueryparam value="#FORM.CatLocation#" cfsqltype="cf_sql_clob" maxlength="50">
<cfelse>
''
</cfif>
, VID=<cfif IsDefined("FORM.VID") AND #FORM.VID# NEQ "">
<cfqueryparam value="#FORM.VID#" cfsqltype="cf_sql_numeric">
<cfelse>
NULL
</cfif>
, DateEntered=<cfif IsDefined("FORM.DateEntered") AND #FORM.DateEntered# NEQ "">
<cfqueryparam value="#FORM.DateEntered#" cfsqltype="cf_sql_timestamp">
<cfelse>
NULL
</cfif>
WHERE ProductID=<cfqueryparam value="#FORM.ProductID#" cfsqltype="cf_sql_numeric">
</cfquery>
<cfparam name="PageNum_UpdateRecordList" default="1">
<cflocation url="Update-List.cfm?PageNum_UpdateRecordList=2">
</cfif>
<cfquery name="GetRecordtoUpdate" datasource="CatalogInfo">
SELECT *
FROM tblproducts
WHERE tblProducts.ProductID = '#URL.ProductID#'
ORDER BY ProductID ASC
</cfquery>