var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Updating multiple records
I have created a (update) form.
I gathered the data from the database (access) using a loop so the form fields are filled in with the data.
What i want is updating all the fields in the database like a batch update. I can do it with one record but there are a lot of values so the record become very long.
do while not rs.eof
<td width="163" colspan="3">
<div align="right"><%=rs("KEY")%></font> </div>
<input type="text" name="<%=rs("ID")%>" value="<%=rs("VALUE")%>" size="30"></font></td>
set rs = nothing
Does anybody have an idea?
SET [FieldName] = [Value]
There have been many posts made throughout the world.
This was one of them.