<% Plink="http://" & Request.ServerVariables("SERVER_NAME") & Request.ServerVariables("URL") & "?" & Request.Querystring metadesc="" set rst=Server.CreateObject("ADODB.Recordset") sql=" SELECT * FROM M_TBL_ITENARY " & _ " WHERE ITN_CODE=" & trim(request.querystring("itncode")) rst.open sql,con,1,2 do until rst.eof metadesc=metadesc & trim(rst("ITN_METADESC")) rst.movenext loop set rst=nothing set rst=Server.CreateObject("ADODB.Recordset") sql=" SELECT * FROM M_TBL_ITENARY " & _ " WHERE ITN_CODE=" & trim(request.querystring("itncode")) rst.open sql,con,1,2 %> " /> " /> "/> <%response.write(trim(rst("ITN_TITLE")))%> "> "> <% set rst=nothing%>
<% set rst=Server.CreateObject("ADODB.Recordset") sql=" SELECT * FROM M_TBL_ITENARY " & _ " WHERE ITN_CODE=" & trim(request.querystring("itncode")) rst.open sql,con,1,2 %>

<%response.write(trim(rst("ITN_LOC")))%>

(<%response.write(trim(rst("ITN_NIGHT"))&"N/"&trim(rst("ITN_DAY"))&"D")%>) - CODE ( <%response.write(trim(rst("ITN_CODE")))%> )



<% set rst=Server.CreateObject("ADODB.Recordset") sql=" SELECT ITN_CODE, ITN_DAY, ITN_LOC " & _ " FROM M_TBL_ITENARYDETAILS " & _ " WHERE ITN_CODE=" & trim(request.querystring("itncode")) & _ " GROUP BY ITN_CODE, ITN_DAY, ITN_LOC " & _ " ORDER BY ITN_DAY " rst.open sql,con,1,2 if not rst.bof or not rst.eof then do until rst.eof %>

Day - <%response.write(trim(rst("ITN_DAY")))%> : <%response.write(trim(rst("ITN_LOC")))%>

<% set rst2=Server.CreateObject("ADODB.Recordset") sql=" SELECT * FROM M_TBL_ITENARYDETAILS " & _ " WHERE ITN_CODE=" & trim(request.querystring("itncode")) & _ " AND ITN_DAY=" & trim(rst("ITN_DAY")) & _ " ORDER BY ITN_DAY, ITN_SLNO " rst2.open sql,con,1,2 if not rst2.bof or not rst2.eof then irow=1 do until rst2.eof if clng(irow)>1 then response.write("

"&trim(rst2("ITN_DESC"))) else response.write(trim(rst2("ITN_DESC"))) end if rst2.movenext irow=irow+1 loop end if set rst2=nothing %>

<% rst.movenext loop end if %> " class="btn btn-danger btn-lg btn-block btn-huge" role="button">Send Your Request