[/b]<CFQUERY NAME="qupdate" DATASOURCE="#request.dsn#">
    SELECT *
    FROM BROCHURE, BROCHURESIZE
    where BROCHURE_ItemID = #url.brochure#
</CFQUERY>


<form method="post" action = "results.cfm">
<cfif isdefined("url.brochure")>
<input type="hidden" name="BROCHURE_ItemID" value="#url.brochure#">
<input type="hidden" name="BROCHURESIZE_Key" value="#url.brochure#">

</cfif>

<cfif isdefined("form.BROCHURE_ItemID")>
<!--- this is an update --->
<cfquery name="qupdate" datasource="#request.dsn#">
update BROCHURE, BROCHURESIZE
set DIVISIONS_Key = #form.DIVISIONS_Key#,
BROCHURESIZE_Key = '#form.BROCHURESIZE_Key#',
BROCHURE_Title = '#form.BROCHURE_Title#',
BROCHURE_Detail = '#form.BROCHURE_Detail#'
BROCHURESIZE_Name = '#form.BROCHURESIZE_Name#'
where BROCHURE_ItemID = #form.BROCHURE_ItemID#
</cfquery>
<cfelse>
<!--- this is an insert --->
<cfquery name="qupdate" datasource="#request.dsn#">
insert into BROCHURE, BROCHURESIZE
(DIVISIONS_Key,BROCHURE_Size,BROCHURE_Title,BROCHURE_Detail,)
values
(#form.DIVISIONS_Key#,'#form.BROCHURE_Title#','#form.BROCHURE_Detail#','#form.BROCHURESIZE_Name#')
</cfquery>
</cfif>
<cflocation url="index.cfm"> [b]