Empty Return Set: RS from: Server=solstice;Database=expd;UID=everyone;PWD=guest; for: SELECT DateDiff(ss, '01/01/70', rovCtdDtg) AS esecs, pres, depth, temper, salin, oxyg, light, presflag, depthflag, temperflag, salinflag, oxygflag, lightflag FROM RovCtd WHERE rovCtdDtg BETWEEN '9/8/2011 3:08:57 PM' AND '9/8/2011 3:40:07 PM' AND vehicle = 'vnta' at bin\geopdvc.pl line 366 Running bin\geopdvc.pl at Sun Nov 6 03:00:05 2011 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 3639 bin\geopdvc.pl: Getting Expedition object for diveno = 3639 and rname = vnta set_expd(): rov = vnta, diveno = 3639 set_expd(): $self->{EndDDD} = 251 set_expd(): $self->{StartEsecs} = 1315493337 set_expd(): $self->{EndEsecs} = 1315497607 set_expd(): $self->{EndDtg} = 9/8/2011 3:40:07 PM _readLogr(): Reading videologr data from 2011251datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1315493337 & 1315497607 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1315497610, self->{EndEsecs} = 1315497607 _readLogr(): #LOGHOST_SYSTEM_UTC = 426 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1315493339 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1315497600 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1315493339 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1315497600 refineStartAndEndEsecs(): setting StartEsecs to 1315493337 refineStartAndEndEsecs(): setting EndEsecs to 1315494119 refineStartAndEndEsecs(): numMinBack = 8.96666666666667, numMinForward = 7.05 refineStartAndEndEsecs(): Refined StartEsecs = 1315493999, Refined EndEsecs = 1315496830 _readLogr(): Reading videologr data from 2011251datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1315493999 & 1315496830 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1315496840, self->{EndEsecs} = 1315496830 _readLogr(): #LOGHOST_SYSTEM_UTC = 282 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1315494009 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1315496830 bin\geopdvc.pl: expdid = 4554 bin\geopdvc.pl: Calling rovNavCTDO to get raw nav data... rovnavCTDO(): calcUTM = 0 rovnavCTDO(): getRaw = 1 rovNav(): 1, calcUTM = 0 rovNav(): 2, getRaw = 1 rovNav(): calcUTM = 0 rovNav(): DDD = 251 (looping to 251) Does file exist?: \\tornado\TempNav\2011\vnta\nav2011251vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\tornado\TempNav\2011\vnta\nav2011251vnta.txt esecs, east, north, lat, lon, head, pres 1315494694, 0, 0, 36.751697, -121.845430, 290.6, 2.83 1315495448, 0, 0, 36.751528, -121.844810, 70.5, 40.57 1315495949, 0, 0, 36.752047, -121.844145, 332.3, 41.23 1315496449, 0, 0, 36.751548, -121.844908, 266.3, 2.62 rovNav(): 251: 2233 in tList after reading from \\tornado\TempNav\2011\vnta\nav2011251vnta.txt 2233 in tList 2233 in {self->{rovT}} 2233 in {self->{rovH}}