<%@ 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 %> Reef One - AquariumSuperstore - The UK's Largest On-line Aquatic Retailer

 

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

  
   
   
   
 

 

  

Home  |   Filtration  |   Heating  |   Lighting  |   Water Quality  |   Food  |   Tanks  |   Decoration  |   Outdoor  |   Accessories
 
                                   
                                   
Aqua Medic Aqua One Hagen Juwel Mirabello Reef One Rena Stands Hoods
 
   
   
   
 

Reef One BiOrb and BiUbe

  
 

   Home

   Filtration

   Heating

   Lighting

   Water Quality

   Food

   Tanks

   Decoration

   Outdoor

   Accessories

  

Page 1 of 2 - Total Number Available 16

1  |  2

  

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

 
       
       
       
           
      Description   Our Price Stock        
    Biorb in silver, 30 litre with light BiOrb 30 Silver Coldwater 2028 Pro II Canister Filter (Eheim) £58.95        
     

 

  
       
       
      Biorb in silver, 30 litre with light BiOrb 30 Silver Tropical 2028 Pro II Canister Filter (Eheim) £75.95        
       
 

   Aqua Medic

   Aqua One

   Hagen

   Juwel

   Mirabello

   Reef One

   Rena

   Hoods

   Stands

      
       
    Biorb in silver, 30 litre with light BiOrb 30 Silver Coldwater with Halogen Light 2028 Pro II Canister Filter (Eheim) £78.95        
       
       
       
    Biorb in silver, 30 litre with light BiOrb 30 Silver Tropical with Halogen Light 2028 Pro II Canister Filter (Eheim) £94.95        
       
           
           
      Biorb in silver, 30 litre with light BiOrb 30 Silver Coldwater & LED 2028 Pro II Canister Filter (Eheim) £98.95        
       

   Help

   Site Map

   Managing Orders

   Delivery/Couriers

   Returns/Refunds

   Customer Promise

   Contact Us

   Feedback

  
         
         
      Biorb in silver, 30 litre with light BiOrb 30 Silver Tropical & LED 2028 Pro II Canister Filter (Eheim) £114.95        
         
         
         
      Biorb in silver, 30 litre with light BiOrb 60 Silver Coldwater 2028 Pro II Canister Filter (Eheim) £104.95        
           
           
           
      Biorb in silver, 30 litre with light BiOrb 60 Silver Tropical 2028 Pro II Canister Filter (Eheim) £129.95          
           
           
           
      Biorb in silver, 30 litre with light BiOrb 60 Silver Coldwater with Halogen Light 2028 Pro II Canister Filter (Eheim) £124.95          
           
           
           
      Biorb in silver, 30 litre with light BiOrb 60 Silver Tropical with Halogen Light 2028 Pro II Canister Filter (Eheim) £135.95          
           
           
           
      Biorb in silver, 30 litre with light BiOrb 60 Silver Coldwater with LED Light 2028 Pro II Canister Filter (Eheim) £154.95          
           
           
           
      Biorb in silver, 30 litre with light BiOrb 60 Silver Tropical with LED Light 2028 Pro II Canister Filter (Eheim) £168.95          
           
           
           
           
     

= In Stock

 = On Order = Special Order
     
     

Page 1 of 2 - Total Number Available 16

1  |  2

      
           
           
           
           
           
           
           
           
             
             

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