Sprinkfab® - - Fire Protection Fabrication

<% connectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=webuser;Password=webuser;Initial Catalog=CustomQuote;Data Source=nts00sqldev;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=NTW00HLUCKY;Use Encryption for Data=False;Tag with column collation when possible=False" set cnConnection = server.CreateObject("ADODB.Connection") set rsNews = server.CreateObject("ADODB.Recordset") cnConnection.Open ConnectionString strSQL = "select * from WebSprinkfabInformation where WebType = 'SPECIALS' and webstatus = 'ACTIVE' order by WebDate DESC " set rsNews = cnConnection.execute(strSQL) %>

History

•	Cost Savings

•	Product Offers

•	Special Deals

Get information about cost saving specials and unique product offers. Its Sprinkfab^®'s way of saying thanks for doing business with us.

<% if not (rsNews.BOF and rsNews.EOF) then %> <% do while not rsNews.EOF %> <% if i mod 2 = 0 then %> <%else %> <% end if %> <% i = i + 1 rsNews.MoveNext loop %> <% else %> <% end if %>

Special Offer	Date
<%=rsNews("WebTitle")%>	<%=rsNews("WebDescription")%>	<%=rsNews("WebDate")%>
*** no news items found.