Multiple Records Update Issue

[Hawkes, Keith A CIV]

>Date: Tue, 22 Oct 2002 11:31:57 +0100
>From: Adrian Lynch <[EMAIL PROTECTED]>
>Subject: RE: Newbie Question on Looping
>Message-ID:
<[EMAIL PROTECTED]>
>
>Your code, we neeeeeeeed ya code

My apologies, I thought that might have been presumptuous - there I go
thinking again!

Here it is:

<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfif IsDefined("FORM.MM_UpdateRecord") AND FORM.MM_UpdateRecord EQ "form2">
  <cfquery datasource="Muster_Test">
  UPDATE dbo.muster SET
  Onboard=
  <cfif IsDefined("FORM.Onboard")>
    1
    <cfelse>
    NULL
  </cfif>
  , DayOff=
  <cfif IsDefined("FORM.DayOff")>
    1
    <cfelse>
    NULL
  </cfif>
  , Liberty=
  <cfif IsDefined("FORM.Liberty")>
    1
    <cfelse>
    NULL
  </cfif>
  , Leave=
  <cfif IsDefined("FORM.Leave")>
    1
    <cfelse>
    NULL
  </cfif>
  , TAD=
  <cfif IsDefined("FORM.TAD")>
    1
    <cfelse>
    NULL
  </cfif>
  , SIQ=
  <cfif IsDefined("FORM.SIQ")>
    1
    <cfelse>
    NULL
  </cfif>
  WHERE EmpID_Muster=#FORM.EmpID_Muster# 
  </cfquery>
</cfif>
<cfquery name="Recordset1" datasource="Muster_Test">
SELECT dbo.muster.EmpID_Muster, dbo.muster.LNAME, dbo.muster.FNAME,
dbo.muster.RANK, 
dbo.muster.Onboard, dbo.muster.DayOff, dbo.muster.Liberty, dbo.muster.Leave,
dbo.muster.TAD, 
dbo.muster.SIQ FROM dbo.muster where date_today > getdate()-1 and dept_name
like 'a%'

</cfquery>
 
<form name="form1" method="post" action="">
</form>
<form method="post" name="form2"
action="<cfoutput>#CurrentPage#</cfoutput>">
  <table width="852" height="85" border="1" align="center" cellpadding="1">
    <cfoutput query="Recordset1"> 
      <tr valign="baseline"> 
        <td height="20" colspan="2" align="right" nowrap> 
          <div align="right"><font color="##000000"
size="2">#Recordset1.RANK# #Recordset1.FNAME#
#Recordset1.LNAME#___________________ Onboard:_ 
            <input type="checkbox" name="Onboard" value=""  <cfif
(#Recordset1.Onboard# EQ "")>unchecked</cfif>>
            DayOff:_ 
            <input type="checkbox" name="DayOff" value=""  <cfif
(#Recordset1.DayOff# EQ "")>unchecked</cfif>>
            Liberty:_ 
            <input type="checkbox" name="Liberty" value=""  <cfif
(#Recordset1.Liberty# EQ "")>unchecked</cfif>>
            Leave:_ 
            <input type="checkbox" name="Leave" value=""  <cfif
(#Recordset1.Leave# EQ "")>unchecked</cfif>>
            TAD:_ 
            <input type="checkbox" name="TAD" value=""  <cfif
(#Recordset1.TAD# EQ "")>unchecked</cfif>>
            SIQ:_ 
            <input type="checkbox" name="SIQ" value=""  <cfif
(#Recordset1.SIQ# EQ "")>unchecked</cfif>>
            </font> </div></td>
      </tr>
    </cfoutput> 
    <tr valign="baseline"> 
      <td height="20" colspan="2" align="right" nowrap> 
        <div align="center"> 
          <input name="submit" type="submit" value="Update Record">
        </div></td>
    </tr>
  </table>
  <input type="hidden" name="MM_UpdateRecord" value="form2">
  <input type="hidden" name="EmpID_Muster"
value="<cfoutput>#Recordset1.EmpID_Muster#</cfoutput>">
</form>
<p>&nbsp; </p>