Changeset 25199 for trunk/ippTools/share/pstamptool_pendingreq.sql

Timestamp:

Aug 25, 2009, 3:30:28 PM (17 years ago)

Author:

bills

Message:

Modernize reverting of errors.
If pstampRequest.state = 'new' previous try at parsing was incomplete so delete any existing jobs
Only revert requests if the state is not 'stop'.
Only revert jobs if request and job state is 'run'

File:

• trunk/ippTools/share/pstamptool_pendingreq.sql (modified) (1 diff)

trunk/ippTools/share/pstamptool_pendingreq.sql

@@ -7 +7 @@
     USING(ds_id)
  WHERE pstampRequest.state = 'new'
+    AND pstampRequest.fault = 0