<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: arial,helvetica,sans-serif; font-size: 12pt; color: #000000'>Brian,<div>This has been resolved.</div><div><br></div><div>FIX: A variable, "SN", was not correct in our trav_vars table. It should have been WINWSN.</div><div>Once that was corrected <span style="font-size: 12pt;">your query worked fine.</span></div><div><br></div><div>Valerie</div><div><br><br><div><span name="x"></span><font color="#663366"><i><font size="2">Valerie Bookwalter<br>Staff Computer Scientist III<br>SRF Operations<br>IT Manager: Pansophy Team<br>Thomas Jefferson National Accelerator Facility<br>757-269-5802<br>bookwalt@jlab.org</font></i></font><br><span name="x"></span><br></div><hr id="zwchr"><div style="color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>From: </b>"Brian Carpenter" <carpente@jlab.org><br><b>To: </b>"pansophy" <pansophy@jlab.org><br><b>Sent: </b>Wednesday, June 11, 2014 1:23:12 PM<br><b>Subject: </b>[Pansophy] pansohy search error<br><br>I was doing a s/n query. thx<br><br>Brian<br>_______________________________________________<br>Pansophy mailing list<br>Pansophy@jlab.org<br>https://mailman.jlab.org/mailman/listinfo/pansophy<br></div><br></div></div></body></html>