<%@Language=VBScript %> <%Response.Buffer =true%> <%server.ScriptTimeout=90000%> BFC-Consignment Numbers Record Report <%mcnote=trim(request("cnoteno")) set con=server.CreateObject("Adodb.connection") set rs_rpt=server.CreateObject("Adodb.recordset") rs_rpt.CursorLocation = adUseClient rs_rpt.CursorType = adOpenStatic rs_rpt.PageSize =3 con.open "Provider=sqloledb;Data Source=202.71.130.7;Initial Catalog=managehr;User Id=riddles;Password=hsnmandb;" qry="select * from bfccnotefirsttable where in_from<=" & mcnote &" and in_to>=" & mcnote & " or out_from<=" & mcnote & " and out_to>=" & mcnote &"" rs_rpt.Open qry,con mtable="first" ' indicate that query is running on first table mrs_rptrecordcount=rs_rpt.recordcount rs_rpt.close con.close %>
BFC - Consignment Number Report

 

 


 
This site is the property of BlazeFlash Couriers Pvt. Ltd.
report bug at OrangeIS