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.