No announcement yet.

Iterate stored procedure

  • Filter
  • Time
  • Show
Clear All
new posts

  • Iterate stored procedure

    I have a stored procedure that updates a table. In that procedure I'm using mysql interval. I have the interval amount as a variable which is a field in the table. I have due_date and recurr_days in the table. I can get SC to use the number defined in the recurr_days column as the interval amount and it adds that many days to the due_date. Problem is I can only get this to work on one record. I need it to go to each record and use the value in the corresponding recurr_days field as the variable in the interval. I've tried foreach and do-while loops but I really have no idea what I'm doing code-wise. Any suggestions?