Sorry to be a pest lately! Finishing touches on program and strange things. I have a form with a button that calls a series of stored procedures (mysql). It used to be one large SP, but I divided it into pieces to avoid timing out. The list looks like:
//REMOVE BLANK NAME/ADDRESS RECS
$sql=(“call KILLBLANK(’$newtab’)”);
sc_exec_sql($sql);
//TDATE FIX
$sql=(“call processtdateraw($formattable, ‘$newtab’,’$adateformat’)”);
sc_exec_sql($sql);
and on. There are 7 in total. I have it inserting progress checks in a table in every one of them. For some reason, it randomly repeats a stored procedure! If I move the order, it repeats different ones. Do I need to close out the SP call in some way? I’ve never had this one happen before.
|29|6000|bizzynames|FINISHED BIZFLAGS |
|30|7000|PROCESSMMYRAW|TYPE FIX|
|31|7001|PROCESSMMYRAW|ODOM FIXED|
|32|7002|PROCESSMMYRAW|VIN and SQUISH DONE|
|33|6000|bizzynames|FINISHED BIZFLAGS |
It is not just the statement repeating itself. It actually repeats the entire stored procedure.