<% DIM objConn Set objConn = Server.CreateObject("ADODB.Connection") objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ Server.MapPath ("/carpets.mdb") & ";" objConn.Open %> High Quality carpets - Low tog high quality
Telephone: 0800 781 3908
Allbrite Group - All Stone Allbrite
* Photo Gallery
* Wood / Engineered Board
 
 
<% DIM mySQL, objRS mySQL = "SELECT * FROM cats" Set objRS = Server.CreateObject("ADODB.Recordset") objRS.Open mySQL, objConn DIM recCount IF Not objRS.EOF THEN Response.Write "" recCount = 0 Do UNTIL objRS.EOF IF recCount Mod 3 = 0 THEN IF recCount <> 0 THEN Response.Write "" Response.Write "" ELSE Response.Write "" END IF recCount = recCount + 1 objRS.MoveNext Loop Response.Write"
"&objRS("name")&""&objRS("name")&"
" ELSE Response.Write "Sorry, there are no records in our database." END IF %>