I can't use this tag for two reasons.

1. There will be 0-length strings and null values and
2. One of the fields already uses commas and I can't make the delimiter
parameter in the tag work.

So, does anyone else have an alternative to updating a whole bunch of
records in a form with one submit button?

Here's some code from my form page:

<cfquery name="gettasks" datasource="personnel">
 SELECT *
 FROM planning_track, contact_List
 WHERE person=employeeid
 ORDER BY WEEK, last_name
</cfquery>

<html>
<head>
 <title>Untitled</title>
</head>

<body>
<cfform action="Update.cfm" method="POST" enablecab="Yes">

 <table>
  <cfoutput query="gettasks" group="week">
  <tr bgcolor="Black">
   <td colspan="2"><font color="white">#gettasks.week#</font></td>
  </tr>
  <cfoutput>
  <TR bgcolor="#IIf(CurrentRow Mod 2, DE('ffffff'), DE('ffffcf'))#">
   <TD>#last_name#</td>
   <TD><input type="text" name="task" value="#Task#" size="40"></td>
   <TD><input type="hidden" name="id" value="#Id#">#id#</td>
  </tr>
  </cfoutput>
  </cfoutput>
  <TR>
   <TD><input type="submit" value="Update"></td>
  </tr>
 </table>
</cfform>

</body>
</html>

Much appreciated,

Erika Foster
engineering-environmental Management
Applications Developer
(505) 866-1654
[EMAIL PROTECTED]

------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to