Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Transaction Patterns » Delete2 deletes the wrong records... where's my error?
Re: Delete2 deletes the wrong records... where's my error? [message #1215 is a reply to message #1214] Wed, 09 January 2008 20:05 Go to previous messageGo to previous message
ikatz is currently offline  ikatz
Messages: 40
Registered: December 2007
Location: Durham, NH
Member
aha! this is exactly what my error was. i had assumed that the page was providing the order_id, and did not bother to include it in my inner select.

thanks! i can hardly thank you enough... i spent so much time scratching my head on this.

...just for curiosity's sake, why did this error in my code only delete one record (and not all records with the given product_id)? also, why hadn't it produced an SQL error?
 
Read Message icon5.gif
Read Message
Read Message icon9.gif
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: POPUP transaction probelm
Next Topic: can't get _cm_popupReturn to execute
Goto Forum:
  


Current Time: Thu May 09 19:00:32 EDT 2024

Total time taken to generate the page: 0.01058 seconds