Multiple Update of SOME records

Hi

Update Multiple Records behavoir.

I'm trying to create a page that will update SOME (but not all) of the records for products listed as part of an order in the OrderDetails table.

I've already created a page that will "multiple update" ALL of the products in a given order and it works well.

(Each product has its own status: Allotted, Backorder, Shipped, etc.)

So if, for instance, I have an order with 5 products with two having Allotted status and three having Backorder status, I might want to "Multiple Update" the two Allotted status products to Shipped status and leave the Backorder status products unchanged.

The trouble is, I've created a page with a recordset and repeating region that lists only the two Allotted status items but when I run the Multiple Update, it updates the status of all five records to Shipped status, including the three Backorder products not shown on the page.

Any idea what I am doing wrong or what I need to do?

Using ASP VB and the latest Data Assist.

Send a copy of the page so I can examine the code.

Here is the code from the Insert Multiple Records behavior.

Let me know if you need the whole page as I'll need to remove some sensitve info from it first.

Thanks

Craig

<%
' WA DataAssist Multiple Updates
if (cStr(Request.Form("btnUpdate")) <> "") then
WA_loopedIDField = Array("WADA_RepeatID_DetailOrderID")
WA_connection = MM_conn_dmw_orders_STRING
WA_table = "OrderDetails"
WA_redirectURL = "babyback2.asp"
WA_keepQueryString = false
WA_indexField = "DetailOrderID"
WA_fieldNamesStr = "DetailStatus"
WA_columnTypesStr = "',none,''"
WA_fieldNames = Split(WA_fieldNamesStr,"|")
WA_columns = Split(WA_columnTypesStr,"|")
WA_multipleUpdateCounter = 0
while (WA_AB_checkLoopedFieldsNotBlank(WA_loopedIDField, WA_multipleUpdateCounter))
WA_fieldValuesStr = "" & cStr( Request.Form("SomeStatusNeue") ) & ""
WA_fieldValues = Split(WA_fieldValuesStr,"|")
WA_where_fieldValuesStr = WA_AB_getLoopedFieldValue(cStr(WA_loopedIDField(0)), WA_multipleUpdateCounter)
WA_where_columnTypesStr = "none,none,NULL"
WA_where_comparisonStr = "="
WA_where_fieldNames = Split(WA_indexField,"|")
WA_where_fieldValues = Split(WA_where_fieldValuesStr,"|")
WA_where_columns = Split(WA_where_columnTypesStr,"|")
WA_where_comparisions = Split(WA_where_comparisonStr, "|")
updateParamsObj = WA_AB_generateInsertParams(WA_fieldNames, WA_columns, WA_fieldValues, -1)
WhereObj = WA_AB_generateWhereClause(WA_where_fieldNames, WA_where_columns, WA_where_fieldValues, WA_where_comparisions)
set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = WA_connection
MM_editCmd.CommandText = "UPDATE " & WA_table & " SET " & updateParamsObj(3) & " WHERE " & WhereObj & ""
MM_editCmd.Execute()
MM_editCmd.ActiveConnection.Close()
WA_multipleUpdateCounter = WA_multipleUpdateCounter + 1
wend
if (WA_redirectURL <> "") then
if (WA_keepQueryString AND Request.QueryString <> "" AND Request.QueryString.Count > 0) then
if (inStr(WA_redirectURL,"?") > 0) then
WA_redirectURL = WA_redirectURL & "&"
else
WA_redirectURL = WA_redirectURL & "?"
end if
WA_redirectURL = WA_redirectURL & Request.QueryString
end if
Response.Redirect(WA_redirectURL)
end if
end if
%>

the records to be updated will be taken from the WADA_RepeatID_DetailOrderID hidden form element

You will need to edit the ID column in the multiple Update server behavior to use the status column, Then edit the WADA_RepeatID_DetailOrderID hidden form elements value to the status you wish to update.

Originally Said By: Jason Byrnes

  the records to be updated will be taken from the WADA_RepeatID_DetailOrderID hidden form element

You will need to edit the ID column in the multiple Update server behavior to use the status column, Then edit the WADA_RepeatID_DetailOrderID hidden form elements value to the status you wish to update.  

But won't changing the value of WADA_RepeatID_DetailOrderID to the value of the status I wish to update change EVERY record in the status column with that particular status?

It seems that if the records to be updated will be taken from the WADA_RepeatID_DetailOrderID hidden form element, then it really is an all or nothing thing; that one can only update ALL of the records with the same DetailOrderID and just SOME of the records with the same DetailOrderID.

Yes, that is one issue with multiple updates, you need a way to uniquely identify the records you want to update.

with a multiple update procedure, that can become difficult if you use a unique identifier that is also included in records you dont wish to update.

the multiplle update procedure uses the WADA_RepeatID_DetailOrderID hidden form element and the ID column you specify to create the WHERE clause of the update statement to determine which records to update.

You could set the WADA_RepeatID_DetailOrderID hidden form element to Use the DetailID column from the recordset as the value and set the ID column in the multiple update procedure to use the DetailID column as the ID column.