<%@ 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 %> Aquascaper Artificial Plants - AquariumSuperstore - The UK's Leading Online Aquatic Retailer

 

■  Help  ■  Site Map  ■  A-Z of Products  ■  Contact Us

  
   
   
   
 

 

  

Home  |   Filtration  |   Heating  |   Lighting  |   Water Quality  |   Food  |   Tanks  |   Decoration  |   Outdoor  |   Accessories
 
                     
                   
Aquascaper Artificial Coral Planting Seagarden Freshwater Water Wonders

 

  
 

Aquascaper Plastic Plants

  
 

   Home

   Filtration

     External

     Internal

     Air Powered

     Powerheads

     UV Sterilisers

     Marine Filtration

     Filter Media

   Temperature

     Visitherm

     Hagen Tronic

     TetraTec

     Hydor

     Heating Cables

     Chillers

     Thermometers

   Lighting

     T8 Controllers

     T8 Tubes

     T5 High Intensity

     Luminaires

     Metal Halide

     Reflectors

   Water Quality

     Medications

     Adjusters

     Additives

     Purifiers

     Test Kits

     Dechlorinators

     Marine Salt

   Food

     Aquarian

     Tropical

     Marine Foods

     Tetra

   Decoration

     Aquascaper

     Artificial Coral

     Planting

     Seagarden Freshwater

     Tetra Water Wonders

   Outdoor

     Pumps

     Filters

     Lighting

     Food

     Water Quality

     Accessories

   Accessories

     Auto Feeders

     Maintenance

     Marine

     Nets

  

Page 1 of 1 - Total Number Available 12

  

    Number Items: <%= subquantity%>
    SubTotal: <%= FormatCurrency(grandtotal)%>

 
       
       
       
           
      Description   RRP Our Price        
    Aquascaper Ambulia 8" £2.99 £2.49

   
     

Eheim Professional Filters

  
       
       
    Aquascaper Ambulia 12" £4.99 £3.99

   
       
       
       
    Aquascaper Ambulia 15" £6.49 £5.99

   
       
       
       
    Aquascaper Foxtail 8" £2.99 £2.49

   
       
         
         
    Aquascaper Foxtail 12" £4.99 £3.99

   
     

   Help

   Site Map

   Managing Orders

   Delivery/Couriers

   Returns/Refunds

   Customer Promise

   Contact Us

   Feedback

  
       
       
    Aquascaper Hygrophilia 8" £2.99 £2.49

   
       
       
       
    Aquascaper Hygrophilia 12" £4.99 £3.99

   
         
         
         
    Aquascaper Hygrophilia 15" £6.49 £5.99

     
         
         
         
    Aquascaper Red Lugwigia 5" £2.29 £1.99

     
         
         
         
    Aquascaper Red Lugwigia 8" £2.99 £2.49

     
         
         
         
    Aquascaper Red Lugwigia 12" £4.99 £3.99

     
         
         
         
    Aquascaper Red Lugwigia 15" £6.49 £5.99

     
         
         
         
         
           
   

Page 1 of 1 - Total Number Available 12

      
           
           
           
           
           
           
           
           
             
             

Home  |   Filtration  |   Temperature  |   Lighting  |   Water Quality  |   Food  |   Tanks  |   Decoration  |   Outdoor  |   Accessories

Copyright 2008 – AquariumSuperstore – All Rights Reserved -Unauthorised use of any images, thumbnails, illustrations, descriptions

 and article content is strictly prohibited under copyright law.

AquariumSuperstore HTML Catalogue - AquariumSuperstore PHP Catalogue