<%@LANGUAGE="VBSCRIPT"%> <% set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = "dsn=LCIBidding;" Recordset1.Source = "SELECT * FROM JOBSBID ORDER BY BIDDATE DESC" Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 3 Recordset1.Open Recordset1_numRows = 0 %><% Dim Repeat1__numRows Repeat1__numRows = 50 Dim Repeat1__index Repeat1__index = 0 Recordset1_numRows = Recordset1_numRows + Repeat1__numRows %> Low Country Insulation Bid List

 

 

 

 

Below are the last 50 bids sorted by date, descending.


Bid Date Job Name Location Cowboy Estimator
<% While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %> <%If (Repeat1__numRows Mod 2) Then%> <%Else%> <%End If%> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 Recordset1.MoveNext() Wend %>
<%=(Recordset1.Fields.Item("BIDDATE").Value)%> <%=(Recordset1.Fields.Item("JOBNAME").Value)%> <%=(Recordset1.Fields.Item("LOCATION").Value)%> <%=(Recordset1.Fields.Item("ESTIMATOR").Value)%>