$alttit=$_SESSION[`PM_AltTitle`];

echo `<h3 style=~-moz-border-radius: 15px;-webkit-border-radius: 15px; border-radius: 15px; border: 1px solid blue;padding: 12px;width:400px; BACKGROUND-COLOR: #DFFFFF;~ class=tdbluetanV ><ol><li>Select a vacation from the list below to see the detail for the vacation and explore other options or
<br><br>
<li>Click on <font color=red>New Vacation</font> to add a new vacation to your possibilities.</ol></h3><br>`;

ExecuteSQL(~create temporary table a as (select CaseID, rInstance from Responses where qID=`CaseType` and rValue=`M` and isDeleted=0) ~);

ExecuteSQL(~create temporary table b as (select CaseID, rValue as Description from Responses where qID=`CaseFirstName` and isDeleted=0) ~);

echo `<div style=~height:250; overflow: ~>`;

ShowQueryResult(~select distinct concat(`<input type=button value=`,char(34),Description,char(34),` $alttit=`,char(34),`Click to access vacation detail`,char(34),` onclick=javascript:window.parent.SetInstanceCaseForm(`,char(39),a.rInstance,char(39),`,`,char(39),a.CaseID,char(39),`,`,char(39),`MV_Options`,char(39),`,`,char(39),`&Ftmp=&Ctmp=qrh&HFtmp=OK&Borders=1`,char(39),`);>`) as Vacation, concat(` <input type=image onclick=`,char(34),`javascript:  return DelCase(`,char(39),a.CaseId,char(39),`,`,char(39),Description,char(39),`); `,char(34),`  src=../images/delete2.gif $alttit =`,char(34),`Delete vacation: `,char(39),Description,char(39),char(34),` height=20 width=18>`) as Del from a,b where b.CaseID=a.CaseID order by Description DESC~);

echo ~</div>~;

echo `<p><br>`;
