<%if request.querystring("txt_flg")="" then call Show_Form call Show_Details(0) elseif request.querystring("txt_flg")="1" then call Show_Form call Show_Details(1) end if %> <%public function Show_Form%>
<%end function%> <%public function Show_Details(flg) %>
For Custom Package Click on this to Send your requirement
<% set rst=Server.CreateObject("ADODB.Recordset") if flg=0 then sql=" SELECT * FROM M_TBL_ITENARY " & _ " ORDER BY ITN_DESC DESC, ITN_LOC, ITN_NIGHT " elseif flg=1 then sql=" SELECT * FROM M_TBL_ITENARY " & _ " WHERE ITN_DESC LIKE '" & trim(request.querystring("Cmb_Place"))&"'" & _ " AND ITN_NIGHT LIKE '"& trim(request.querystring("Cmb_Night")) &"'"& _ " ORDER BY ITN_DESC DESC, ITN_LOC, ITN_NIGHT " end if rst.open sql,con,1,2 if not rst.bof or not rst.eof then irow=1 do until rst.eof %> <% rst.movenext irow=irow+1 loop end if %>
Slno State Places Covered View
<%response.write(irow)%> <%response.write(trim(rst("ITN_DESC")))%> <%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")))%> ) " class="btn btn-danger" role="button">View
<%end function%>