Quiznos Subs: Leavenworth, Kansas

Quiznos™ Menu

(last updated September 2, 2007)

Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Etiam tortor. Sed mauris quam, elementum eget, rutrum et, tincidunt ac, elit. Nullam neque ipsum, interdum cursus, tincidunt vel, euismod a, felis. Morbi aliquet. Praesent tempus, nisl id dictum auctor, enim neque gravida turpis, et pharetra tellus elit sed sem. Ut ut nisl eu lacus vestibulum accumsan. Vestibulum id sapien. Maecenas in mauris. Donec dapibus, libero non pretium convallis, urna tortor molestie leo, mollis dignissim enim tellus id dolor. Sed mattis convallis ipsum. Sed sollicitudin scelerisque diam. Duis varius euismod tellus. Mauris vestibulum leo sit amet est. Morbi vel justo. Nullam quis enim quis elit luctus cursus. Curabitur et tortor et leo varius posuere. Proin pulvinar urna ac mauris.

<% //set variables var DBCon; DBCon = Server.CreateObject("ADODB.Connection"); var MenuRS; MenuRS = Server.CreateObject("ADODB.Recordset"); MenuRS.CursorType = 2; MenuRS.LockType = 4; var DBQuery = "SELECT menu.* FROM menu;"; //open db //entries should have name,pic_url,category,description,price_sm,price,price_lg DBCon.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" + Server.MapPath("lolz.mdb")); MenuRS.Open(DBQuery, DBCon); if(!MenuRS.BOF){MenuRS.MoveFirst();} if(MenuRS.RecordCount > 0)//then display subs per-category { //classics while(!MenuRS.EOF) { if(MenuRS("categ").Value=="Classic") { Response.Write("\n\t\t\t\t

Classics

"); MenuRS.MoveFirst(); while(!MenuRS.EOF) { if(MenuRS("categ").Value=="Classic") { //write it's info (name, pic, description, price(s)) //use newsline format } MenuRS.MoveNext(); } MenuRS.MoveLast(); } else{MenuRS.MoveNext();} } //chicken //premium //real-deal //LTOs //salads //soups //cup soup //bowl soup //bread bowl //sides //chips //cookies //side salad //drinks //bottle drinks //combos } //close db MenuRS.Close(); DBCon.Close(); //clear vars MenuRS = 0; DBCon= 0; NewsCounter=0; DBQuery= ""; %>