<%@ 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 %> Juwel Fish Tanks - 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
 
   
   
   
 

Juwel Fish Tanks & Stands

  
 

   Home

   Filtration

   Heating

   Lighting

   Water Quality

   Food

   Tanks

   Decoration

   Outdoor

   Accessories

  

Page 1 of 2 - Total Number Available 18

1  |  2

  

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

 
       
       
       
           
      Description       Indicative Price      
    Juwel Rio 125 Aquarium and Cabinet Black     £279.95     
     

Moving to Marines & Inverts?

This articles explains how to convert a

 Juwel Aquarium.

  
       
       
     

Juwel Rio 125 Aquarium and Cabinet Beech

     £279.95     
       
 

   Aqua Medic

   Aqua One

   Hagen

   Juwel

   Mirabello

   Reef One

   Rena

   Hoods

   Stands

      
       
    Juwel Rio 180 Aquarium and Cabinet Black     £299.95    
       
       
       
    Juwel Rio 180 Aquarium and Cabinet Beech     £299.95     
       
           
           
      Juwel Rio 240 Aquarium and Cabinet Black     £359.95    
       

   Help

   Site Map

   Managing Orders

   Delivery/Couriers

   Returns/Refunds

   Customer Promise

   Contact Us

   Feedback

  
         
         
      Juwel Rio 240 Aquarium and Cabinet Beech     £359.95    
         
         
         
      Juwel Rio 300 Aquarium and Cabinet Black     £439.95    
           
           
           
      Juwel Rio 300 Aquarium and Cabinet Beech     £439.95      
           
           
           
      Juwel Rio 400 Aquarium and Cabinet Black     £549.95      
           
           
           
      Juwel Rio 400 Aquarium and Cabinet Beech     £549.95      
           
           
           
      Juwel Vision 180 Aquarium and Cabinet Black     £349.95      
           
           
           
           
             
     

Page 1 of 2 - Total Number Available 18

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