Sale Flyer (page 6)

<% ' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit. On Error Resume Next Session("FP_OldCodePage") = Session.CodePage Session("FP_OldLCID") = Session.LCID Session.CodePage = 1252 Session.LCID = 1033 Err.Clear strErrorUrl = "" If Request.ServerVariables("REQUEST_METHOD") = "POST" Then If Request.Form("VTI-GROUP") = "0" Then Err.Clear Set fp_conn = Server.CreateObject("ADODB.Connection") FP_DumpError strErrorUrl, "Cannot create connection" Set fp_rs = Server.CreateObject("ADODB.Recordset") FP_DumpError strErrorUrl, "Cannot create record set" fp_conn.Open Application("_ConnectionString") FP_DumpError strErrorUrl, "Cannot open database" fp_rs.Open "", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable FP_DumpError strErrorUrl, "Cannot open record set" fp_rs.AddNew FP_DumpError strErrorUrl, "Cannot add new record set to the database" Dim arFormFields0(0) Dim arFormDBFields0(0) Dim arFormValues0(0) FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0 fp_rs.Update FP_DumpError strErrorUrl, "Cannot update the database" fp_rs.Close fp_conn.Close FP_FormConfirmation "text/html; charset=windows-1252",_ "Form Confirmation",_ "Thank you for submitting the following information:",_ "sale_flyer_6.htm",_ "Return to the form." End If End If Session.CodePage = Session("FP_OldCodePage") Session.LCID = Session("FP_OldLCID") %> <%@ LANGUAGE="VBScript.Encode" %> <% order = Session("orderid") 'READ STUFF From Database Dim objSimpleAdo, rstRS, SQLStmt SQLStmt = "SELECT * From item " SQLStmt = SQLStmt & "WHERE [Orderid] =" & Order & "; " Set SimpleAdo = New CSimpleAdo SimpleAdo.setConnectionString = Session("ConnectionString") Set RS = SimpleAdo.getRecordSet(SQLStmt) 'Do stuff with the record set 'Initialize variables for this application thedate = Cstr(Date) 'get the date thetime = Cstr(Time) 'get the time subtotal = 0 'the subtotal for a row of items subweight = 0 'the subweight for a row of items subsize = 0 'the subsize for a row of items subquantity = 0 'the subquantity for a row of items CurrentRecord = 0 Do While CheckRS(RS) 'Calculate the individual totals for a row subweight = subweight + (RS("Quantity") * RS("Weight")) subsize = subsize + (RS("Quantity") * RS("Size")) subtotal = (RS("Quantity") * RS("Price")) subquantity = subquantity + RS("Quantity") total = FormatCurrency (CCur(subtotal)) grandtotal = grandtotal + subtotal RS.MoveNext Loop Set SimpleAdo = Nothing Set RS = Nothing %> Sale Flyer (page 6)

330 North Tuscarawas Ave. P. O. Box 465 Dover, OH 44622

Orders / Customer Service: 1-800-743-2723 1-330-364-8878

Fax Number: 1-330-343-8009

Fax orders may be sent 24 hours a day 7 days a week or phone in your order:

Free Shipping on orders over $100.00 in continental USA Only!

Orders under $100.00 add $9.00.

Eastern Time Monday - Friday (9:00-5:00) Saturday (9:00-3:00) Sunday (Closed)

E-Mail Address: boleks@tusco.net

For Product Information or General Craft Questions Contact: rachel@bolekscrafts.com

Customer Service:

Click Here

Home

Ordering & Shipping

Order Form

Search

We Accept:

Shipping Methods:

Bolek's

Craft Supplys

Sale Starts January 4, 2010

Sale Ends April 12, 2010

Mini Snowman Ornament

Very cute, easy to make! 1" Tall. Add a pin back or ear wires and wear it. Glue a magnet to the back. Attach a hanger and hang on your tree.

Kit makes 12 Snowmen

#JF560..........$4.00

Glycerine Soap Bars

Transparent. 100% natural vegetable based glycerine soap. Hypo-allergenic, Biodegradable. Great for everyday use.

Scented with Fragrance Oils.

4 oz. bath bars.....$1.20 Each

1 1/3 oz. facial bars.....$ .70 Each

#SB07 - Jasmine/Transparent Teal	#SB11 - Sea Breeze/Transparent Blue
#SB08 - Vanilla/Clear	#SB12 - Baby Powder/Clear
#SB09 - Strawberry/Transparent Red	#SB13 - Cucumber Melon/Transparent Green
#SB10 - Peach/Transparent Peach

Pearl Angel Kit

2 1/4" Tall. Easy to make. Made with tear drop pearl, pearl head, gold beads and gold wings.

Kit makes 6 Angels

#JF498..........$8.55

*Sale $8.05

Tear Drop Pearl

18mm x 34mm. White Pearlescent Drops. Hole goes through the bead from top to bottom. Used in the Pearl Angel Kit and Pearlie Spider.

#4353.....2 Per Pack..........$1.10

Lighted

Teddy

Bear

Each Kit makes 1 Teddy Bear

Beaded Lighted Lighthouse

Made with Opaque Black, Christmas Red, Crystal and Opaque White Beads. Safety Pins and Beading wire are gold. Comes complete with instructions and a brass candle lamp for lighting.

Approximately 12" Tall x 3 1/2" Base

Makes one Lighthouse

#JF580.....$18.65 *Sale $17.65

Lighted Uncle Sam Kit

6 1/2" Beaded Sun Catcher Kit

10" Beaded Large Sun Catcher Kit

14" Giant Lighted Snowman

Our giant lighted snowman s a larger version of our popular 7" snowman. Made with Crystal Clear Beads and Silver Safety Pins. This is our own original design. Comes complete with all materials needed including lights and hat.

Kit makes 1 Snowman

#JF541..........$26.95 *Sale $25.95

Black Felt Top Hats