update multiple records, debugging

slightly frustrated, i have been trying to update multiple records using the solution recipe pdf.
(i have used the insert new records server behavior successfully in the past)

After a couple of attempts, the wizard runs ok, but nothing is being updated.

(i also noticed the form doesn't redirect on submission).

i have tried in vain to debug, but can't find the fault.

I have the same problem every time I use any of the multiple inserts, updates, delete....

I found that DA doesn't line up the code correctly.

If you look at the code on your other (past ones that worked).
You will see how the code lined up properly.

php do should be first...
Then the repeat section multiple counter loop...then the form fields...(without the submit button) alternative content loops..
Then...<?php } while ($row_rswhateverhere = mysql_fetch_assoc($rswhateverhere)); ?>
Then your button (without ANYTHING added to it...just the button name.

I run the wizard then cut and paste the code where it belongs.

Sure wish this issue would get fixed...:(

I made a post about this a while ago with multiple deletes....

Hope this helps you out. :)

Thanks for the reply.

I moved the submit button as it was in the loop for some reason.

the form now at least posts successfully, but the recordset isn't (yet) updated

I see in your code, the repeat is above your <? php do {?>
You need to move that.... to below <? php do {?>

Also you need to move your:
<?php } while ($row_rswhateverrecordset= mysql_fetch_assoc($rswhateverrecordset)); ?>

Also, make sure your submit button doesn't have any extra values added to it.
It should be just the name of the buttom.
DA has been adding code to the submit button....when the wizard runs...when it wraps the whole table...
That is the reason for repositioning the code. !


Here is a working example of where the code should be located....
I found it applys to all multiple, insert, update delete.


<?php do { ?>
<?php
// RepeatSelectionCounter_1 Begin Loop
$RepeatSelectionCounter_1_IterationsRemaining = $RepeatSelectionCounter_1_Iterations;
while($RepeatSelectionCounter_1_IterationsRemaining--){
if($RepeatSelectionCounterBasedLooping_1 || $row_rsmessages){
?>
<tr>
<td colspan="2"><div align="center"><?php echo $row_rsmessages['fromUserName']; ?></div>
</td>
<td><div align="center"><a href="message.php?messageID=<?php echo $row_rsmessages['messageID']; ?>"><?php echo $row_rsmessages['subject']; ?></a></div></td>
<td><div align="center">
<input type="hidden" name="WADA_RepeatID_messageID_<?php echo $RepeatSelectionCounter_1; ?>" id="WADA_RepeatID_messageID_<?php echo $RepeatSelectionCounter_1; ?>" value="<?php echo $row_rsmessages["messageID"]; ?>" />
<input type="checkbox" name="checkboxDelMess_<?php echo $RepeatSelectionCounter_1; ?>" id="checkboxDelMess_<?php echo $RepeatSelectionCounter_1; ?>" value='<?php echo $row_rsmessages["messageID"]; ?>'/>
</div></td>
</tr>
<?php
} // RepeatSelectionCounter_1 Begin Alternate Content
else{
?>
<td width="18%">No Messages</td>
<?php } // RepeatSelectionCounter_1 End Alternate Content
if(!$RepeatSelectionCounterBasedLooping_1 && $RepeatSelectionCounter_1_IterationsRemaining != 0){
if(!$row_rsmessages && $RepeatSelectionCounter_1_Iterations == -1){$RepeatSelectionCounter_1_IterationsRemaining = 0;}
$row_rsmessages = mysql_fetch_assoc($rsmessages);
}
$RepeatSelectionCounter_1++;
} // RepeatSelectionCounter_1 End Loop
?>
<?php } while ($row_rsmessages = mysql_fetch_assoc($rsmessages)); ?>
<tr>
<td colspan="3">&nbsp;</td>
<td><div align="center">
<input type="submit" name="DelMessBtn" id="DelMessBtn" value="Delete" />
</div></td>
</tr>
</table>
</form>

thanks again sallly.

it took me a little while, as i had two do..while loops on my page (i am updating from a dynamic list), but after some thought, i got it working.

the server behavior is great, (on a separate project, i managed to get the insert working directly from the wizard one time), but it seems to go wrong quite easily.

A few debugging pointers would help WA ! ;)

having resolved the problem with multiple update, i managed to (successfully) create a multiple insert.

the multiple delete wizard also went smoothly, though when it works at all, only one row is deleted.

i trawled through the order of events, and they SEEM ok.

I have attached the partially working page

Once this works, i am going to keep the code and copy and paste it if i need it again!!

I have done some testing of the multiple update server behavior and the pdf that shows how to apply it. In my testing if I follow along with the pdf the code is written correctly and the records are updated just as they should. After going through the steps I do not have to do anything to the code to get it working.

I would like some info from one of both of you about the circumstances that you are experiencing these errors in. Please post back and include as much detail as you can about your setup and OS, DW, and DataAssist versions that you are using. If there is a problem with the multiple update or any of the other server behaviors I would like to know about it as soon as possible so that we can get bugs properly logged if needed. I'm including a copy of the page that I did my test with for reference.

thanks eric.

i will start afresh tomorrow, providing a detail breakdown of my database table structure and page as it is built.

regards

I am working in winxp, have supersuite, CS3. DA 2 2.7, DFP2, I have bought the programs, and don't partake in your subscription program.
All sites are built with PHP..

My experiences with any of the multiples, insert, update and especially delete.

99% of the time....DA wraps itself around my complete table.

I have figured the work around it, (but not happy that I have to).

A couple of months ago, I posted and got some help with it.

But bottom line, I usually have to readjust where the code should go.

As you can see where I posted an example for Craig, that is the work I did...with rearranging the code supplied by the wizard. It works for me.

*Note*
If I create a multiple (anything) on a blank page...
It will usually create the code in the proper place.
But when inserted into a page with other coding going on I usually have to rearrange the code.

You can see other multiple delete problems I have had with a previous posts I've submitted here in this forum...."irratic behavior multiple deletes".
showthread.php?t=12458

Just worked with this the other day,...multiple deletes.
And the same "wrap around everything" occured.

Instead of coming in here again, complaining, I just rearranged the code.

I am not currently working with this...
But wish this bug would get fixed.

I just tried to help out Craig.... :)

Where I had the most problems...is when I have multiple insert, update and delete on the same page....
I would suggest that you craft a page and try putting 3 or more of any of the above multiple behaviors on a page...to get the drift...;)

Originally Said By: CraigR

  having resolved the problem with multiple update, i managed to (successfully) create a multiple insert.

the multiple delete wizard also went smoothly, though when it works at all, only one row is deleted.

i trawled through the order of events, and they SEEM ok.

I have attached the partially working page

Once this works, i am going to keep the code and copy and paste it if i need it again!!  

I seen the errors, where the code isn't placed properly...

Humor me and give this a try...

I moved the code for ya...:)