Fog Creek Software
Discussion Board




vss_fbupdate.wsf hangs if new files linked to bug

If a file is added to vss, then changed and checked in with a comment linking to Fogbugz the script picks up the new revision, but cannot find any more 'checked in' records so it
leaves sPrevVersion as 'yes'.

This is then set to null at       
If sPrevVersion = "yes" Then
            sPrevVersion = ""
        End If

Which results in: INSERT INTO CVS (ixBug, sFile, sPrev, sNew) VALUES(1234,'\\server\ss\databases\Project:$//FogBugz/VSS/vss_fbupdate_r1.wsf',,2)

SQL objects to the null input for sPrev and the script running as a scheduled task hangs for lack of response to the dialog box giving the error.

To clean this up make the following change

        If sPrevVersion = "yes" Then
            sPrevVersion = "1"
        End If

or perhaps handle the errors to remove any GUI activity.

Chris Johnson
Thursday, February 13, 2003

There is a bit missing to the above post so I've broken the line up a bit to preserve it

INSERT INTO CVS (ixBug, sFile, sPrev, sNew) VALUES
(1234,
'\\server\SS\databases\Safemarine:$//Utilities/FogBugz/VSS/vss_fbupdate_r1.wsf'
,,2)

Chris Johnson
Thursday, February 13, 2003

Thanks Chris.  I added it.

Michael H. Pryor
Thursday, February 13, 2003

*  Recent Topics

*  Fog Creek Home