Multiple Update Form not working
Hi
I'm using DataAssist 2.0.5. and have created a multiple update form following all the instructions in the help file and the online tutorial.
However, nothing appears, except:
No records match your request.
No records match your request.
No records match your request.
No records match your request.
No records match your request.
The correct number of lines are showing as I have 5 records to display, but I can't work out why the WA code is not displaying the fields properly.
Also, is there any reason why there are two While loops inserted by WA ?
--------------------------------------------------------------------------
The code is:
<%
While ((Repeat1__numRows <> 0) AND (NOT WADAMannequins.EOF))
%>
<tr align="left" valign="top">
<%
' RepeatSelectionCounter_1 Begin Loop
RepeatSelectionCounter_1_IterationsRemaining = RepeatSelectionCounter_1_Iterations
While(RepeatSelectionCounter_1_IterationsRemaining)
RepeatSelectionCounter_1_IterationsRemaining = RepeatSelectionCounter_1_IterationsRemaining-1
If(RepeatSelectionCounterBasedLooping_1 OR (Not WADAMannequins.EOF AND ((WADAMannequins_first+Repeat1__index) <= WADAMannequins_last)) ) Then
%>
<td class="WADADataTableCell"><input type="text" name="COLLECTION_<%=RepeatSelectionCounter_1%>" class="text_box_thin_white" id="COLLECTION_<%=RepeatSelectionCounter_1%>" value="<%=Replace((WADAMannequins.Fields.Item("COLLECTION").Value)&"", """", """)%>" size="32"></td>
<td class="WADADataTableCell"><input type="hidden" name="WADA_RepeatID_ID_<%=RepeatSelectionCounter_1%>" id="WADA_RepeatID_ID_<%=RepeatSelectionCounter_1%>" value="<%=(WADAMannequins.Fields.Item("ID").Value)%>" />
<input name="CODE_<%=RepeatSelectionCounter_1%>" type="text" class="text_box_thin_white" id="CODE_<%=RepeatSelectionCounter_1%>" value="<%=Replace((WADAMannequins.Fields.Item("CODE").Value)&"", """", """)%>" size="12" maxlength="32" /></td>
<td class="WADADataTableCell"><input name="NAME_<%=RepeatSelectionCounter_1%>" type="text" class="text_box_thin_white" id="NAME_<%=RepeatSelectionCounter_1%>" value="<%=Replace((WADAMannequins.Fields.Item("NAME").Value)&"", """", """)%>" size="32" /></td>
<td class="WADADataTableCell"><input name="PRIMARY_CODE_<%=RepeatSelectionCounter_1%>" type="text" class="text_box_thin_white" id="PRIMARY_CODE_<%=RepeatSelectionCounter_1%>" value="<%=Replace((WADAMannequins.Fields.Item("PRIMARY_CODE").Value)&"", """", """)%>" size="32" /></td>
<td class="WADADataTableCell"><textarea name="ADDITIONAL_INFO_<%=RepeatSelectionCounter_1%>" cols="32" rows="2" class="text_box_thin_white" id="ADDITIONAL_INFO_<%=RepeatSelectionCounter_1%>"><%=Replace((WADAMannequins.Fields.Item("ADDITIONAL_INFO").Value)&"", """", """)%></textarea></td>
<td class="WADADataTableCell"><input name="SIZES_<%=RepeatSelectionCounter_1%>" type="text" class="text_box_thin_white" id="SIZES_<%=RepeatSelectionCounter_1%>" value="<%=Replace((WADAMannequins.Fields.Item("SIZES").Value)&"", """", """)%>" size="32" /></td>
<td class="WADADataTableCell"><input <%If (CStr((WADAMannequins.Fields.Item("stylised").Value)) = CStr("True")) Then Response.Write("checked=""checked""") : Response.Write("")%> type="checkbox" name="stylised_<%=RepeatSelectionCounter_1%>" id="stylised_<%=RepeatSelectionCounter_1%>" value="1" /></td>
<td class="WADADataTableCell"><input <%If (CStr((WADAMannequins.Fields.Item("realistic").Value)) = CStr("True")) Then Response.Write("checked=""checked""") : Response.Write("")%> type="checkbox" name="realistic_<%=RepeatSelectionCounter_1%>" id="realistic_<%=RepeatSelectionCounter_1%>" value="1" /></td>
<td class="WADADataTableCell"><input <%If (CStr((WADAMannequins.Fields.Item("male").Value)) = CStr("True")) Then Response.Write("checked=""checked""") : Response.Write("")%> type="checkbox" name="male_<%=RepeatSelectionCounter_1%>" id="male_<%=RepeatSelectionCounter_1%>" value="1" /></td>
<td class="WADADataTableCell"><input <%If (CStr((WADAMannequins.Fields.Item("female").Value)) = CStr("True")) Then Response.Write("checked=""checked""") : Response.Write("")%> type="checkbox" name="female_<%=RepeatSelectionCounter_1%>" id="female_<%=RepeatSelectionCounter_1%>" value="1" /></td>
<td class="WADADataTableCell"><input <%If (CStr((WADAMannequins.Fields.Item("child").Value)) = CStr("True")) Then Response.Write("checked=""checked""") : Response.Write("")%> type="checkbox" name="child_<%=RepeatSelectionCounter_1%>" id="child_<%=RepeatSelectionCounter_1%>" value="1" /></td>
<td class="WADADataTableCell"><input <%If (CStr((WADAMannequins.Fields.Item("child").Value)) = CStr("True")) Then Response.Write("checked=""checked""") : Response.Write("")%> type="checkbox" name="ACCESSORIES_<%=RepeatSelectionCounter_1%>" id="ACCESSORIES_<%=RepeatSelectionCounter_1%>" value="1" /></td>
<td class="WADADataTableCell"><input <%If (CStr((WADAMannequins.Fields.Item("RECLINING").Value)) = CStr("True")) Then Response.Write("checked=""checked""") : Response.Write("")%> type="checkbox" name="RECLINING_<%=RepeatSelectionCounter_1%>" id="RECLINING_<%=RepeatSelectionCounter_1%>" value="1" /></td>
<td class="WADADataTableCell"><input <%If (CStr((WADAMannequins.Fields.Item("SEATED").Value)) = CStr("True")) Then Response.Write("checked=""checked""") : Response.Write("")%> type="checkbox" name="SEATED_<%=RepeatSelectionCounter_1%>" id="SEATED_<%=RepeatSelectionCounter_1%>" value="1" /></td>
<td class="WADADataTableCell"><input <%If (CStr((WADAMannequins.Fields.Item("SUSPENDED").Value)) = CStr("True")) Then Response.Write("checked=""checked""") : Response.Write("")%> type="checkbox" name="SUSPENDED_<%=RepeatSelectionCounter_1%>" id="SUSPENDED_<%=RepeatSelectionCounter_1%>" value="1" /></td>
<td class="WADADataTableCell"><input <%If (CStr((WADAMannequins.Fields.Item("NO_HEAD").Value)) = CStr("True")) Then Response.Write("checked=""checked""") : Response.Write("")%> type="checkbox" name="NO_HEAD_<%=RepeatSelectionCounter_1%>" id="NO_HEAD_<%=RepeatSelectionCounter_1%>" value="1" /></td>
<td class="WADADataTableCell"><input <%If (CStr((WADAMannequins.Fields.Item("LEANING").Value)) = CStr("True")) Then Response.Write("checked=""checked""") : Response.Write("")%> type="checkbox" name="LEANING_<%=RepeatSelectionCounter_1%>" id="LEANING_<%=RepeatSelectionCounter_1%>" value="1" /></td>
<td class="WADADataTableCell"><input <%If (CStr((WADAMannequins.Fields.Item("HIRE").Value)) = CStr("True")) Then Response.Write("checked=""checked""") : Response.Write("")%> type="checkbox" name="HIRE_<%=RepeatSelectionCounter_1%>" id="HIRE_<%=RepeatSelectionCounter_1%>" value="1" /></td>
<%
' RepeatSelectionCounter_1 Begin Alternate Content
Else
%>
<td>No records match your request.</td>
<%
' RepeatSelectionCounter_1 End Alternate Content
End If
If(Not RepeatSelectionCounterBasedLooping_1 AND RepeatSelectionCounter_1_IterationsRemaining <> 0 ) Then
If(Not WADAMannequins.EOF AND ((WADAMannequins_first+Repeat1__index) < WADAMannequins_last OR CInt(RepeatSelectionCounter_1_Iterations) = -1) ) Then WADAMannequins.MoveNext
If(WADAMannequins.EOF AND CInt(RepeatSelectionCounter_1_Iterations) = -1) THEN RepeatSelectionCounter_1_IterationsRemaining = 0
If(true) Then Repeat1__index = Repeat1__index+1
End If
RepeatSelectionCounter_1 = RepeatSelectionCounter_1+1
Wend ' RepeatSelectionCounter_1 End Loop
%>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
WADAMannequins.MoveNext()
Wend
%>