<%@ 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 %> Powerheads - 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
 
                               
                               
External Internal Air Powered Powerheads & Pumps UV Sterilisers Marine Filtration Filter Media  

 

  
 

Powerheads and Pumps

  
 

   Home

   Filtration

     External

     Internal

     Air Powered

     Powerheads

      - MaxiJet Powerheads

      - MaxiJet Pumps

      - Aquaclear

      - Seio Superflow

      - Hydor Koralia

      - Eheim Hobby

      - Eheim Compact

      - NewJet Pumps

     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

     Frozen Foods

     Marine Foods

     Hikari

     Tropical

     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

   Reptiles

  

Page  of 3 - Total Number Available 32

1  |  2  |  3

  

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

 
       
       
       
           
      Description   RRP Our Price        
   

Eheim Compact 600 Pump

 £XX.XX £17.99

   
     

Seio Superflow Controller

  
       
       
   

Eheim Compact 2000 Pump

 £XX.XX £45.99

   
       
       
       
   

Eheim Compact 3000 Pump

 £XX.XX £59.99

   
       
       
       
   

Eheim Compact 5000 Pump

 £XX.XX £95.99

   
       
         
         
    NewJet NJ1200 £34.99 £24.99

   
     

   Help

   Site Map

   Managing Orders

   Delivery/Couriers

   Returns/Refunds

   Customer Promise

   Contact Us

   Feedback

  
       
       
   

NewJet NJ1700

 £49.99 £34.99

   
       
       
       
   

NewJet NJ2300

 £64.99 £49.99

   
         
         
         
   

NewJet NJ3000

 £74.99 £52.99

     
         
         
         
                     
         
         
         
                     
         
         
         
                     
         
         
         
                     
         
         
         
         
           
   

Page  of 3 - Total Number Available 32

1  |  2  |  3

      
           
           
           
           
           
           
           
           
             
             

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