INTRODUCTION

v INTRODUCTION

The Emergence of the Internet as a worldwide standard for communication information has opened up a huge number of new business opportunities. One of these opportunities is the area known as electronic commerce. Essentially, the Internet is able to take the place of a traditional bricks-and-mortar store – playing the role of the vendor (or the retailer who sits between buyer and vendor). For very little overhead, people are now able to sell their products electronically. The Internet has enabled buyer and the seller to be brought together in a virtual (rather than a physical) manner.

Before you can select the right setup for your e-business, you must determine exactly what you need to be competitive online.

Most likely, you'll need some software to help you manage your products, your promotions, your customers, and their orders. You may also need some additional programs to handle the tax, shipping, and payment processing of your orders.

A number of popular off-the-shelf solutions have evolved over the past few years that give you these core features and allow you to plug-in other software modules to handle the complexities of taxation, the varieties of shipping options, and many of the popular forms of payment. Each option offers its own set of pros and cons.

Solutions like Intershop's ePages, iCat's Lemonade Stand, or Yahoo's Stores provide storefronts that are ready to go. Just pick a design and pop in your products: You are ready for business.

Other applications, such as Intershop 3.0 and iCat Professional, allow you to change standard templates that come with the packaged software so that you can customize the way your storefront will look and feel. These solutions also let you extend the standard features and behaviors contained in the templates - assuming you can "speak" their application languages.

And then there are solutions that act more like e-commerce application platforms. These include Microsoft's Site Server Enterprise, which relies on Microsoft's ASP (active server page) technology; Allaire's ColdFusion application engine and its popular CFML (ColdFusion markup language); IBM's Net.Commerce solution; and Pandesic's new 3.0 product release, which provides robust backend e-business processes that can be accessed through a standardized application interface.

Many of the above solutions rely on other e-commerce software from CyberCash or OpenMarket for payment processing, Taxware for tax calculations, and Tandata for up-to-date shipping information.

Let’s consider a simple example of ecommerce where retail store sells all computer systems, peripherals, accessories and parts. Internet buyers buys online through website, pays with the credit card through secure transctions having 40bit SSL encryption.By placing the entire system on the Internet, the upstream and downstream communications are accomplished using a single medium – a web browser.

E - COMMERCE APPLICATION

INTERNET SHOPPING

v STRAGIES OF ECOMMERCE APPLICATION

It's hard to know which technology solution is right, until a detailed list of requirements against which we can compare the solutions. Therefore, before you can choose an e-commerce platform, you have to decide what kind of experience you want to deliver to your online customers. As you do this, think about where your company is going to be in one, two, five, or 10 years. If you set up your solution correctly now, when your company grows and expands, you can add on to the original foundation without tossing out your prior efforts.

Or, as many companies do, you can go for the quick fix today. This strategy may get you to market faster at a lower cost, but it will cost quite a bit more in the long run, since you'll have to rebuild from the ground up when your site grows (which at the rate things change online, could be as soon as a year from now). Either way, you still need a plan.

As you build your plan, the first thing you should do is generate a Requirements Document. At this stage, it's a good idea to get all the corporate departments involved. That way you can get everyone's input at the beginning, as opposed to later, when it's too late. You'll also have people who really know how long things take helping you come up with realistic scheduling and budgetary expectations. The other benefit of this summit approach is that it gets ideas and potential conflicts out on the table early. The last thing you want is Frank from Fulfillment telling you a week before launch that the product numbers you're sending him are three characters too long. Gotcha!

To avoid this kind of scenario, get everyone that's involved in a room for a "Day of Discovery." The information you need to gather can be modeled as a circle that represents your entire sales and marketing cycle. Each stage of the cycle can be a basis of discussion for your summit meeting.

Marketing Cycle Illustration

v Sales and Marketing Cycle

Customer: Who are your target customers and what do they need?
Awareness and advertising: How will you get customers to the store the first time? How will you get them to come back?
Merchandising: What products will you offer and how will you position and display them to your customers?
Sales service: How will you answer customers' questions and solve their problems?
Promotions: How will you promote merchandise and services to give customers incentives to make purchases?
Transaction processing: How will you handle orders, tax, shipping, and payment processing?
Fulfillment: How will you pass orders to the fulfillment center?
Post-sales service: How will you provide customer service and answers to order-status questions after the sale?
Marketing data and analysis: What information about sales, customer, and advertising trends will you gather? How will you use it to make decisions?
Brand: How will you communicate with customers during each of these interactions in a way that reinforces your unique company image?

v Business Rules

Here's a list of e-commerce-related issues that you should think about before you begin developing an e-commerce site. You have probably come up with some answers and formed attitudes to many of these issues already. But if this list brings to mind even a few things you haven't considered, you'll probably save some big bucks and a lot of headaches in later development cycles.

Use this list to generate your own Requirements Document. Or if you are planning to outsource the development, these questions can be used to put together a thorough Request for Proposal (RFP).

v Presenting Your Product/Service Offers

Remember to put yourself in the customers' shoes when you define these business rules. The more you can think like them, the more likely you'll create a solution that effectively caters to them.

Product Mix
What is the range of products that you plan to offer? Are all of your products hard goods? Or do you offer intangible products such as warranties, service agreements, and guarantees? Do you sell software products that you want to make available for download through the Internet? How many unique products to you plan to offer? How often does this product data and product mix change?

Pricing
Is all pricing the same, regardless of who is making the purchase? Do different groups of customers see different pricing on the same items? Do you ever offer promotional or temporary pricing or price reductions? What is your pricing strategy for other channels?

Incentives Purchases
Do you use coupons or club memberships? Do you support manufacturers' rebates? Do you up-sell, cross-sell, or bundle items to create purchase incentives? Are quantity discounts offered?

Compatible Accessories, Substitutions
Do you let users know what accessory items are compatible with a purchase about to be made? Do you recommend a substitution if an item is not in stock?

Categories, Subcategories, and More Subcategories
Will you want to help customers locate items by navigating through your product categories and subcategories? What categories and subcategories do you envision? What are the words your customers use to categorize your products?

Searching
Do you want to let users search for keywords? Or do your users want to search for simple product attributes such as brand, model, and price range? Do your customers need tools to help them look for products with specific features?

Configuration Views
Can you build custom orders? Do you want to let customers specify the components of the products they want to purchase? For example, what if they want a CPU tower with a 4-GB hard drive, 256 MB of RAM, plus a 12x CD-ROM?

v Providing Sales Service

Solution Views
Do you recommend products based upon a profile of the customer's needs? For example, you may sell a home office solution or a corporate cubicle solution.

Comparison Views
How much information do you want to provide to your customers to facilitate their comparison of products? Is brand, model, price, and description enough? Or does your customer prefer a table with a full comparison of features by type of feature? Would providing comparisons help or hinder the sale? Too much information may cause a customer to leave confused.

Dialog with the Customer
Do you plan to allow your customers to ask product questions? How will you handle the incoming email with the expertise your customers will expect? If you offer complex products that have many variations, how will you guide your customer through the decision-making process toward the right solution for him or her?

v Transaction Management and Processing

If you plan to let customers purchase more than one item at a time, then you will need to implement an online shopping cart, shopping basket, procurement list, or whatever metaphor is appropriate to your brand.

Building an Order
Do you envision enabling customers to collect a number of items in their carts before checking out? How many unique items typically comprise an order? One to 10? Hundreds?

Reordering
Do your customers typically purchase the same items again and again to replenish their stock? Do you want to enable registered users or groups to save a permanent shopping list from which they can reorder items they've ordered in the past?

Tax and Shipping
Some online stores precalculate tax and shipping expenses. Others ask that you trust them to add regional tax and reasonable shipping expenses to the total that appears on the screen. Should taxes and shipping be automatically added to the total cost for a customer to accept prior to placing an order? If you will be preauthorizing payments, you must calculate tax and shipping in advance.

Tax Nexus
In what states is tax applicable to your sales? Are all items taxable or only certain items?

Shipping
What shipping options do you want to offer? FedEx? UPS? USPS?

Payment Types
What types of payments do you need to support for your customers? Credit cards? Cybercash? Debit cards? Procurement cards? Purchase orders? Corporate credit accounts? Private label cards?

Authentication, Validation, and Transaction Clearing
How much authentication do you want to force upon the user? Extensive authentication lowers your risk but decreases the ease with which customers can conduct transactions, possibly leading to lost sales. What will be your policy? What level of risk from potential fraud are you comfortable with? Will you want to check card numbers against card algorithms? Do you want to authorize cards and transaction amounts with a bank, and then reserve funds, before issuing order numbers?

v Integrating with Inventory and Fulfillment

Product Availability

Do you want to offer for sale only items that are in your immediate inventory? Or do you want to offer items for sale even if they are not immediately on hand?

Out-of-Stock Notice
When should customers be notified that the items they selected are either out of stock, not available for immediate delivery, or can be back-ordered?

Back Orders
When do you want to notify the user of a back order? When they are checking out? After they have placed the order? Do you want to recommend a substitution if one is available?

Controls
When do you stop offering items for sale? When inventory count is at a minimum or when there are none left in inventory? Is this policy consistent for all products? Or is it different for each product?

Processing Orders
How often should orders be sent to order entry? In real-time? Every hour? Once a day? How do you want to handle the order you take at 4:55 p.m. with a request for next-day delivery, while the FedEx truck is pulling out of your dock right now? What does the customer expect? What can you deliver?

v Providing Customer Service

Updating Orders
How will your fulfillment center let the system know that an order has shipped? Do you need to let the system know? Is there a shipping number that needs to get attached to the order? Does shipping status need to be updated more than once, if at all?

Order Status Look-Up
Do you want to enable customers to look up the shipping status of their order online? Do you want to provide UPS, FedEx, or USPS tracking numbers?

Order Status Notification
Would you prefer to be proactive and email changes in the order status to the recipient? Do you want to send messages upon acceptance of the orders? Should you send another when inventory is confirmed or a back order needs to be authorized? Do you need another when it leaves your dock and enters the shipper's vehicle?

Technical Support
Do you plan to provide online support materials for the products you sell? Is technical support a product or service in and of itself? Does it need to be processed as an order?

Localization
Do you need to support multiple languages? Multiple currencies? Regional pricing structures?

Legal
What types of policies and disclaimers do you need to make available to your customers? What are the terms and conditions of a sale? What is your return policy? Do you offer a guarantee or a limited warranty on purchases? What should customers do if they need to return items? Are there any locations where you cannot legally sell your products and services?

Managing Customer Expectations
What expectations do you want to set for your customers regarding fulfillment? Will you ship same-day for delivery the next day? Will you charge a premium for such services? What is the cut-off time?

v Gathering Metrics and Data

Site Metrics
What metrics will you use to manage the site? What reports will you want to see regarding your customers, orders, online merchandise, site traffic analysis, etc.? You can get access to hits and visits, but how will this information answer what you really want to know?: "What did I do that generated the most sales last month? And why?" Do you want to measure response rates to advertisements and direct marketing tactics? Do you need to evaluate conversion rates on your standard and promotional offers? Do you need to measure and manage your customer acquisition costs?

Customer Profiles
What demographic data do you want to capture as part of the registration or checkout process? What incentives can you offer to encourage anonymous buyers to tell you more about themselves?

v Refining Your Marketing Tactics

Data Mining
What do you know about your customers? How can you mine that data in order to become a more effective marketer? Do you plan to target future offers to customers based upon their past purchasing histories or browsing habits with your business? Do you plan to automate these marketing features? Or do you envision managing them manually?

Demographics
Who are your customers? Do you have more than one type? How educated are they about your product? How much assistance do they need to make a purchasing decision? Are they individuals or companies or both? How savvy are they about your products? How frequently do your customers shop?

Customers and Customer Groups
Do you plan to offer the same set of products to all your customers? Will you sell to anyone or only to people and groups you know? Do you segment your inventory for certain customers and groups of customers?

Psychographics
How much do your customers know about your products? How many are power users and have model numbers memorized? How many are new customers, who are unfamiliar with your products and need your assistance to make purchasing decisions?

v Attracting the Customer

Getting the Word Out
How will you get the word out that your store is open for business? Register with the search engines and portals? Buy and manage online advertising? Target potential customers with direct marketing tactics? Get exposure through public relations or news group postings? Or include your URL in marketing and promotional materials?

Value Proposition
Why will people shop at your online store? Price? Selection? Service? Speed? Availability? What do you offer customers that makes you competitive?

Branding
How do you want to be understood by your customer base? As the fastest way to shop? The smart way to shop? The easy way to shop? What makes your service unique in the marketplace? How are you different from your competitors? How can you communicate these attributes of your business to your customers?

After all the raw information you need, it's time to prioritize. It is not likely that you'll be able to implement all the things you want in the first release of the store because of constraints in budget or time or because you're the only person working on this project and you haven't slept for three days. Rank each of the features you want with a one for "must have," a two for "nice to have," and a three for "pipe dream." With your priorities in line, you can create your Requirements Document.

PROGRAMMING LANGUAGE AND DATABASE

INTRODUCTION TO PROGRAMMING LANGUAGE AND DATABASE

The Programming language used to built the website is ACTIVE SERVER PAGES 3.0 in short ASP and Database connecting to it is PERVASIVE SQL 2000.

v ACTIVE SERVER PAGES

The introduction of ASP was a milestone in the development of dynamic, interactive and scalable web applications and it has matured a great deal since its inception. ASP is now considered an integral part of working with Windows on the Internet.

ASP is potentially one of the most important innovations to emerge on the web – for developers and users of the Internet and intranets alike. ASP Code is Browser Independent.

In order to write web pages in ASP, I used Dream Weaver 3.0 as Editor. In order to debug ASP code we need a web server that supports Active Server Pages. Microsoft is distributing Windows 2000 with its own web server software, Internet Information Server 5.0 (IIS 5.0), which supports ASP 3.0 .

v HTML

Hypertext Markup Language (HTML) is the text markup language currently used on the World Wide Web. HTML specifies only the layout and structure of a document. However, HTML is unlike programming in that it does not specify logic. Because of spacing rules and the fact that a browser interprets HTML markup similary to the way in which a compiler reads source code. It is a markup language that combines phsical and logical structuring ideas. The rules of HTML are fairly simple but are not fully enforced. Browsers are the final arbiters of page layout.

v JAVASCRIPT

Javascript is a scripting language developed by Netscape. Javascript is simply text that has to be type into Web Page much as HTML tags. In order for JavaScript to work, the Web pages it is in must be viewed with a browser that understands the JavaScript language. Javascript is also a powerful means of controlling events in browser. Javascript code is being used to perform form validation by checking the contents of a form before it is sent to a server-side program.

v PERVASIVE SQL 2000

Pervasive has long set the standard in embedded database engines by providing a complete set of features that need in an embedded database environment.

Maintenance-Free Operations Pervasive.SQL provides true "set it and forget it" functionality. Once configured, Pervasive.SQL runs worry-free behind the application.
Low Total Cost of Ownership (TCO) Pervasive.SQL is designed with goal of lowering the costs associated with database deployments. Low cost per-set licensing coupled with a low demand on IT resources for configuration and maintenance, make Pervasive.SQL a leader in lowering TCO.
Scalable Pervasive.SQL is designed specifically to support application upgrades from the Workstation, to the Workgroup, to the Server without modifying data files or a single line of code.
Extensive standard support Pervasive Software's commitment to open standards is evidenced throughout the Pervasive.SQL family, ensuring application portability and interoperability.

Language/Syntax: ANSI SQL '89/'92, SAG CLI
Connectivity: ODBC 2.5, OLE DB 2.0, JDBC 1.0 - Type 3
Components: ActiveX controls, Java Beans, Java Class libraries

Automatic caching of each step of a transaction protects each database operation.
Automatic reversion to last completed transaction upon restart provides protection in the event of computer failure.
Dynamic file expansion eliminates file over-runs by making space for files as they grow.
Real-time features such as continuous operation allow back-ups while the database is running.
Archival logging with roll-forward ensures each data entry is securely logged to disk.
Multi-user concurrency and locking management (Pervasive.SQL Server) guards against errors even when hundreds of users are accessing a file at one time.

· Transactional & Relational: The Best of Both Worlds

With Pervasive.SQL 2000, developers can choose the access method that makes the most sense for a particular application or task.

Pervasive.SQL transactional access allows users to take the fastest, most direct path to the access they need, using a 32-bit, multi-threaded, transactional-database engine.
Pervasive.SQL relational access delivers optimum performance for complex query and data manipulation operations, to meet the needs of the most demanding applications.

· Maintenance-Free Operations

Every version of Pervasive.SQL is designed for plug-and-play, low-maintenance database functionality. This embedded-database design eliminates many of the routine tasks associated with other database engines. Pervasive.SQL helps lower your overall total cost of ownership with maintenance-reducing features such as:

Continuous operation
Archival logging
Automatic server recovery
Instantaneous file space allocation
Index balancing for automatic optimal performance
Distributed Tuning Interface

· Scalable

Tight integration between all configurations ensures that applications can scale easily, delivering features and flexibility as needs change and grow. Scalability from the Workstation to Workgroup to Server environments is achieved without changes to the application or data file structures - You write once, and deploy across platforms. Built based on a "set-it and forget-it" philosophy, Pervasive.SQL offers the lowest Total Cost of Ownership solution on the market.

WEBSITE DESIGN

Ecommerce Application Internet Shopping through website will be build in stages. Each stage will build on the previous stages, and will add a new piece of functionality to the application.

Steps Involved in building this application will be as follows: -

Ø DEFINING GLOBAL VARIABLE IN GLOBAL.ASA

Ø DATABASE CONNECTION

Ø HOME PAGE CONSTRUCTION

Ø USER REGISTRATION AND LOGIN

Ø BROWSING DIFFERENT ITEMS AND SEARCHING ITEMS

Ø ADDING ITEMS TO SHOPPING CART

Ø GETTING CUSTOMER INFORMATION

Ø CALCULATING SHIPPPING CHARGES ACCORDING ZIP CODE AND WEIGHT OF ITEM

Ø GETTING CREDIT CARD INFORMATION THROUGH SECURE SOCKET LAYER CONNECTION

Ø PROCESSING THE ORDER.

Ø SENDING E-MAIL CONFIRMATION TO CUSTOMER.

Ø CHECKOUT PAGE

After Order Process in the warehouse….

Ø ORDER TRACKING

If Customer wants to return the items there is provision for sending back the item…

Ø RETURN MERCHANDISE AUTHORIZATION (RMA)

Customer wants to contact, then he/she can contact through website by sending a email through website…

Ø CONTACT US

Customer satisfies with the website he can refer his friends through the website only….

Ø REFER A FRIEND

This was the general idea of the whole application, now in the following chapters you can see the detail description of each of the topics listed above.

v LAYOUT OF WEB-SITE AND SHOPPING CART

HOME PAGE

MAIN.HTM

PRODUCT PAGE

PRODUCTS.HTM

ONLINE SHOPPING

ONLINE.HTM

CONTACT.HTM

TELL A FRIEND

REFER.HTM

SUPPORT

SUPPORT.HTM

CATEGORIES -- SEARCH

CATEGORIES.ASP – SEARCH.ASP

CENTRAL LINK BETWEEN

INVENTORY AND SHOPPING CART

PRODUCTS.ASP

SHOPPING CART

ADDPROD.ASP

TO ADD ITEMS TO SHOPPING CART IT GOES BACK TO PRODUCT PAGE OTHERWISE IT GOES FURTHER TO CUSTOMER INFORMATION

CUSTOMER INFORMATION

i.e. Shipping Address & Billing Address

CUSTOMER.ASP

CALCULATION OF TAX & SHIPPING

BY ZIP CODE, ITEM WEIGHT

PROSFREIGHT.ASP

DISPLAYING ORDER DETAILS

WITH SHIPPING CHARGES & TAKING CREDIT CARD AND ALSO VALIDATION PROCESS TAKES HERE

CUSTINFO.ASP

INSERTING SHOPPING CART ITEM INTO DATABASE

INSCPORDHDR.ASP & INSCPORDLIN.ASP

SENDING ORDER CONFIRMATION THROUGH E-MAIL

PROCESS.ASP

GETTING ORDER CONFIRMATION ON SCREEN

CHECKOUT.ASP

v STARTUP OF WEBAPPLICATION – INTERNET SHOPPING

As you know I am using ASP as programming language to build the web application.

In ASP to start any web application you need GLOBAL.ASA file. It is used to startup and the shutdown of web applications. The file can also be used to handle events fired by the startup and shutdown of user sessions within a specific web application. The file is placed in the virtual directory’s root.

In GLOBAL.ASA, you can include event handler scripts and declare objects that will have Session or Application scope. The file has no display component, as it is not displayed to users. This is the file that allows the developer to create global variables using ASP’s Session Object. The GLOBAL.ASA file is kind of like CONFIG.SYS and AUTOEXEC.BAT a file when loading DOS.

In GLOBAL.ASA we have to use the <SCRIPT> tag at the top of the page. There are no <% … %> blocks in the file, because in the GLOBAL.ASA file all of the Asp script needs to be enclosed in the <SCRIPT> block. Since these scripts will be running on the server rather than on the client’s machine, we have to make sure that the RUNAT directive is included inside of the script element, otherwise GLOBAL.ASA won’t work correctly.

GLOBAL.ASA

Sub Application_OnStart

End Sub

Sub Application_OnEnd

End Sub

Sub Session_OnStart

'Shopping cart array

Const cartAttributes = 5

Const maxCartItems = 5

ReDim arrcart (cartAttributes, maxCartItems)

Session ("MyCart") = arrcart ‘Holds the Item-no of Cart

Session ("cartItem") = 0 ‘Holds no of Items in the Cart

End Sub

Sub Session_OnEnd

End Sub

</Script>

Here Two variables are defined cartAttributes & maxCartItems which shows how many and which Items to be placed in the array. The array arrcart is a Multi-Dimensional dynamic array whose may value is set to 5 x 5.

Two Global Session variables are defined which stores values of array arrcart.

DB.INC

Another Important File in defining shopping cart is DB.INC. In this files we are using the GLOBAL.ASA’s Session_OnStart event to create some of those global variables. INC files are great because ASP will stick the code from that file right into ASP page for creating some constants (like VB) that assign to the Session's global variables.

DB.INC

<! -- #INCLUDE FILE="adovbs.inc" -->

Const maxCartItems = 5

Const cartAttributes = 5

'---Shopping cart attributes ----

Const cProductid = 1

Const cProductname1 = 2

Const cProductname2 = 3

Const cQuantity = 4

Const cUnitPrice = 5

‘DSN Connection

Dim connect

Set connect = Server.CreateObject ("ADODB.Connection")

connect. Open "MACWEB"

‘DSN Less Connection

‘Set connect = Server.CreateObject ("ADODB.Connection")

‘connect. Provider = "MSDASQL"

‘connect. ConnectionString = "Data Source= “MACWEB"

‘connect. Open

ReDim arrcart (cartAttributes, maxCartItems)

Session ("MyCart") = arrcart ‘Holds the Item-no of Cart

Session ("cartItem") = 0 ‘Holds no of Items in the Cart

The elements of the array are defined by the constants in the DB.INC file above. Understanding the array here is the key to understanding how to make a shopping cart.

Here we don't see anything about the SessionID in the code because ASP does that for you automatically!

v The Array!

OK, this is two-dimensional array INC file. To understand 2X arrays think about Microsoft Excel - it's exactly like a table! This is the array just created- right now all the cells are empty because we haven't put anything in there yet:

Attributes>>>	cProductid	cProductName1	CProductName2	cQuantity	cUnitPrice
Item1
Item2
Item3
Item4
Item5

There is space for five Items because the array/table only have slots for five items. Most shopping cart programs will resize the maxCartItems variable as they add more items to the table but there's no sense in taking up a lot of memory space if it's not necessary. Remember, variables are nothing more than spaces in memory for you to stick information. If I made 1,000 slots for items in this array it would just slow things down unnecessarily.

Now, all we have to do is fill those cells with information. A shopping cart allows a user to pick items from a database of products/items. Naturally, our database will have 5 attributes for each product/item, just like the array, and as the user selects these items for their order, they will get added to this array. Eventually this array is written to our database.

Remember that this array is "alive" only while the user is visiting the site because it's bound to the user's SessionID. If the user ends the session, the cookie and the global variables are destroyed.

Session ("MyCart") should hold the individual cProductid information (The first part of the array).
Session ("cartItem") will hold the number of items currently in the array (The second part of the array). Hey, but you said that maxCartItems was the other part of the array! Well, yeah I did, but that array is the table that actually holds the information you're sticking into the array- the cProductid(s) and the total number of products currently in the cart. It's kind of like an array within an array.

*Note: Sessions are usually assigned a 20-minute timeout by the server administrator. So if we add items to the global array and leave your browser open while go to lunch, after 20 minutes of inactivity ASP will automatically destroy session cookie.

v DATABASE CONNECTION

We have reached an important juncture of the project. The dream affects of ASP becomes true – because use of OLE-DB in ASP, via a set of programming interfaces known as the ActiveX Data Objects, or ADO. Through the www, intranets and other browser-based applications, the humble Web Browser is becoming one of the most widely- used interfaces between data and end-user.

ODBC

Open Database Connectivity or ODBC is a standard for accessing data. It was designed to allow the programmer to use a common set of routines to access the data stored in database, regardless of the type of database in which the data was stored.

OLE-DB

OLE-DB is the next in the evolution of the anonymous data store. As well as being more generic than ODBC. Each OLE-DB data provider is a unit of code, written in a language such as C++ or Java, which uses OLE-DB objects to provide the instructions required to communicate and pass data between the data store and the data consumer. ADO is an interface that allows ASP pages to talk to OLE-DB. So, when we use ASP to talk to a data store, we’re actually using ASP to talk to ADO, which in turn talks to OLE-DB, which in turn gets information from our data store.

‘DSN Connection

Dim connect

Set connect = Server.CreateObject ("ADODB.Connection")

connect. Open "MACWEB"

‘DSN Less Connection

‘Set connect = Server.CreateObject ("ADODB.Connection")

‘connect. Provider = "MSDASQL"

‘connect. ConnectionString = "Data Source= “MACWEB"

‘connect. Open

CONNECTION OBJECT

The Connection Object is what ADO uses to store information about the data store connection. It represents a unique Session with the data store.

Dim connect

Set connect = Server.CreateObject ("ADODB.Connection")

This uses the CreateObject method of the Server object to create an instance of the Connection object. The programmatic identifier (or ProgID) for the ADO Connection Object is ADODB.Connection. So that we can use the object within our code, here connect is used as instance of Connection object.

In order to actually establish the connection we use the Open method of the connect Connection object.

connect. Open "MACWEB"

Here MACWEB is the name of DSN (Data Source name). DSN are prepared in through ODBC Data Source Administrator. And be sure that DSN should be System DSN. Because ASP always uses System DSN to talk to the database store.

Also there is another syntax to Open the Connection Object.

Following syntax is used to open the Microsoft Access database: -

connect.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _

"Data Source=C:\datastores\Movie2000.mdb;" & _

"Persist Security Info=False"

Following syntax is used to open the SQL Server database: -

objConn.Open "Provider=SQLOLEDB;Persist Security Info=False;" & _

"User ID=sa;Initial Catalog=Movie;" & _

"Initial File Name=C:\MSSQL7\Data\Movie2000.mdf"

HOME PAGE CONSTRUCTION

The Home page of the application is responsible for welcoming the user to the application, providing some information about what the application is for, and displaying the top-level menu selections for the user. We’ll call it Default.asp – this means that the user can simply type in the URL of a virtual directory on our web server, and they’ll automatically be directed to this page.

The application’s home page will simply display a welcome message, plus some links to other pages that will enable the user to:

The following display picture shows the snap shot of the Home page of the Company for which I prepared this project.

The source code of the page is shown below: with all HTML and ASP code together. In this application is called this file main.htm

This file is prepared in the frameset. There three frames in file main.htm.

MAIN.HTM OR DEFAULT.ASP

<! DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Final//EN">

<html>

<head>

<title>COMPUTERS WHOLESALER LIQUIDATORS</title>

</head>

</frameset>

</body></noframes>

</html>

The main file of the above frameset is in the mainFrame i.e. frontmain.asp. The source code of the above file is as follows: -

FRONTMAIN.ASP

<%Option Explicit%>

‘With this during debugging ASP code server catches typographical errors in the code.

‘Here db.inc is a single central file that contains connection details. So we can include this into each ASP ‘page that uses such a connection, by writing the following line into each ASP page:

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">

<html>

<head>

<title>WHOLESALE COMPUTER LIQUIDATOR</title>

printers, drives, software, cpu's memory, modems, mice, and more.">

systems,monitors">

var Message="Welcome to Consumer Depot. We hope you enjoy shopping with us for some of the best computer products available.";

var place=1;

function scrollIn() {

window.status=Message.substring(0, place);

if (place >= Message.length) {

place=1;

window.setTimeout("scrollOut()",100);

} else {

place++;

window.setTimeout("scrollIn()",50);

}

function scrollOut() {

window.status=Message.substring(place, Message.length);

if (place >= Message.length) {

place=1;

window.setTimeout("scrollIn()", 100);

} else {

place++;

window.setTimeout("scrollOut()", 50);

}

</SCRIPT>

Above is the Java Script which displays the message in the status bar

</head>

<%Dim FPrice(10), PART(10), Price(10)

Dim UDC(10), rsCat2, Desc(10), DESC2(10)

Dim rsCat, TW, x, PIC(10), LOGO(10), USERDEF, UDCD(10)

x = 0

TW = 20

‘Defining the variables and Array which are used in the following asp code.

Set rsCat = connect.Execute("SELECT * FROM IMITMFIL WHERE ITEM_MAT_TYPE = 'F' ORDER BY ITEM_NO")

‘Here Connection object’s Execute method is used. This method execute the SQL which goes to the database MACWEB, selects all the field from IMITMFIL table that is Itemmaster table in which whole inventory is stored. It selects some special items from the list where ITEM_MAT_TYPE = ‘F’ and When it gets displayed it orders by ITEM_NO.

On Error Resume Next

‘To Ensure that the ASP script is not terminated when an error occurs, we need to use the On Error statement. This is similar to one that used in Visual basic but has less flexibility. Here Resume Next is used to continue processing at the next statement.

do until rsCat.EOF

‘As command Set rsCat = connect.Execute is one that selects and returns records, we can use a variant to refer to the returned recordset and thus use the recordset elsewhere in the code.

x = x + 1

PART(x) = rsCat("ITEM_NO")

Price(x) = rsCat("ITEM_PRICE")

DESC(x) = rsCat("ITEM_DESC1")

DESC2(x) = rsCat("ITEM_DESC2")

PIC(x) = RTRIM(rsCat("ITEM_NO")) + ".GIF"

UDC(x) = rsCat("ITEM_USER_DEF_CD")

FPrice(x) = FormatCurrency(Price(x))

LOGO(x)= UDC(x) + ".GIF"

rsCat.MoveNext

loop

rsCat.Close

connect.Close

Set rsCat = Nothing

Set connect = Nothing

‘Once we have finished with a connection, we should Close is, in order to free associated system resources: connect.Close This doesn’t actually remove the object from memory; so we can Open it again.

‘Alternatively, if we have finished with the object you can remove it from memory, by setting the name of the object to Nothing: Set connect = Nothing

Dim ObjCounterFile, ReadCounterFile, WriteCounterFile

Dim CounterFile

Dim CounterHits

Dim FixedDigitCount

Dim DigitCount

Dim DigitCountLength

Dim DigitZerosToAdd

Dim DigitZeroCount

Dim ShowDigits

Dim DigitPath

FixedDigitCount = 6

DigitPath = "digits/images1"

On Error Resume Next

Set ObjCounterFile = Server.CreateObject("Scripting.FileSystemObject")

CounterFile = Server.MapPath ("counter.txt")

Set ReadCounterFile= ObjCounterFile.OpenTextFile (CounterFile, 1, True)

If Not ReadCounterFile.AtEndOfStream Then

CounterHits = Trim(ReadCounterFile.ReadLine)

If CounterHits = "" Then CounterHits = 0

Else

CounterHits = 0

End If

ReadCounterFile.Close

Set ReadCounterFile = Nothing

CounterHits = CounterHits + 1

Set WriteCounterFile= ObjCounterFile.CreateTextFile (CounterFile, True)

WriteCounterFile.WriteLine(CounterHits)

WriteCounterFile.Close

Set WriteCounterFile = Nothing

Set ObjCounterFile = Nothing

DigitCountLength = Len(CounterHits)

If DigitCountLength < FixedDigitCount Then

DigitZerosToAdd= FixedDigitCount - DigitCountLength

DigitZeroCount = 1

For DigitZeroCount = DigitZeroCount to DigitZerosToAdd

ShowDigits = ShowDigits & "<img src=""" & DigitPath & "/0.gif"" Alt =""" & CounterHits & " Visitors"" >"

End If

DigitCount = 1

For DigitCount = DigitCount to DigitCountLength

ShowDigits = ShowDigits & "<img src=""" & DigitPath & "/" & Mid(CounterHits,DigitCount,1) & ".gif"" Alt =""" & CounterHits & " Visitors"">"

<td width=121 height="110" valign="top"> <img src="images/<%=LOGO(1)%>" width="100" height="35"><br>

‘Here Image, Description and Item No are Linked with another web page Products.Asp It also takes with it QueryString id which is used in net page for going into the database and pulling out the value pertaining to that id and displaying the content of that page.

<div align="center"> <img src="images/<%=PIC(1)%>" width="75" height="75" border="0"><BR>

<%=DESC2(1)%><BR>

Item:#<BR>

</a>

</td>

<div align="center"><img src="images/<%=LOGO(2)%>" width="100" height="35"><br>

<a style="TEXT-DECORATION: none" href="products.asp?id=<%= PART(2) %>"><img src="images/<%=PIC(2)%>" width="75" height="75" border="0"><BR>

<%=DESC2(2)%><BR>

</FONT></a><a style="TEXT-DECORATION: none" href="products.asp?id=<%= PART(2) %>"><font face='ARIAL,HELVETICA' size='1'>Item:#</font></a><a style="TEXT-DECORATION: none" href="products.asp?id=<%= PART(2) %>"><FONT FACE='ARIAL,HELVETICA' SIZE='1'><BR>

<BR>

</td>

<td width=120 height="110" valign="top"> <img src="images/<%=LOGO(3)%>" width="100" height="35"><br>

<div align="center"> <img src="images/<%=PIC(3)%>" width="75" height="75" border="0"><BR>

<%=DESC2(3)%><BR>

<BR>

</a>

</td>

<td width=121 height="110" valign="top"> <img src="images/<%=LOGO(4)%>" width="100" height="35"><br>

<div align="center"> <img src="images/<%=PIC(4)%>" width="75" height="75" border="0"><BR>

<%=DESC2(4)%><BR>

<BR>

</a>

</td>

<td width=124 height="110" align="center" valign="top"> <img src="images/<%=LOGO(5)%>" width="100" height="35"><br>

<div align="center"> <img src="images/<%=PIC(5)%>" border="0" width="75" height="75"><BR>

<%=DESC2(5)%><BR>

<BR>

</a>

</td>

</tr>

<tr >

<div align="center"><img src="images/<%=LOGO(6)%>" width="100" height="35"><br>

</div>

<div align="center"> <img src="images/<%=PIC(6)%>" width="75" height="75" border=0><BR>

<%=DESC2(6)%><BR>

<BR>

</td>

<div align="center"><img src="images/<%=LOGO(7)%>" width="100" height="35"><br>

</a></div>

<div align="center"> <img src="images/<%=PIC(7)%>" width="75" height="75" border="0"><BR>

<%=DESC2(7)%><BR>

<BR>

</a>

</td>

<div align="center"><img src="images/<%=LOGO(8)%>" width="100" height="35"><br>

</a></div>

<div align="center"> <img src="images/<%=PIC(8)%>" width="75" height="75" border="0"><BR>

<%=DESC2(8)%><BR>

<BR>

</a>

</td>

<div align="center"><img src="images/<%=LOGO(9)%>" width="100" height="40"><br>

</a></div>

<div align="center"> <img src="images/<%=PIC(9)%>" border="0" width="75" height="75"><BR>

<%=DESC2(9)%><BR>

<BR>

</a>

</td>

<div align="center"><img src="images/<%=LOGO(10)%>" width="100" height="35"><br>

</a></div>

<div align="center"> <img src="images/<%=PIC(10)%>" border="0" width="75" height="75"><BR>

<%=DESC2(10)%><BR>

<BR>

</a>

</td>

</tr>

</table>

<p align="left"><font face="Arial, Helvetica, sans-serif" size="2" color="#3333FF">                    <a href="products.htm" target="_top">Products</a>

|<a href="online.htm" target="_top"> Shopping Online </a>| <a href="refer.htm" target="_top">Refer

a Friend </a>| <a href="support.htm" target="_top">Customer Support </a>| <a href="dealer.htm" target="_top">Dealers

Special Section</a></font><br>

            <a href="contact.htm" target="_top">Contact

Us </a>|<a href="about.htm" target="_top"> About Us </a>| <a href="addprod.asp" target="mainFrame">View

Cart</a></font><BR><br>

</p>

</SPAN>

</body>

</html>

PRODUCT PAGE

v PRODUCTS.HTM

This is another Page where It displays all Categories computer parts. This is also a frame set page.The source code of Products.Htm looks similar to the Main.Htm page

PRODUCTS.HTM

<html>

<head>

<title>Consumer Depot Products</title>

printers, drives, software, cpu's memory, modems, mice, and more.">

systems,monitors,computer systems, AMD, K6, Intel, Pentium, IBM, Cyrix, M2, MMX,

PC, PC's, motherboard, cpu, memory, ram, edo, sdram, nonparity, processor, hard drive,

video card, cdrom, modem, 56K, sound card, speakers, mouse, keyboard,

case, atx case, at case, mid tower case, full tower case, Microsoft, chipset,

floppy, component, pc component, EIDE, IDE, storage, surge protection, ups,

monitor, PCI, AGP, printers, ink, copiers, fax, laser, back-ups, apc,

scanners, digital, imaging, cdr, cdrw, media, multimedia, hardware, software, accessories,

peripherals, dvd, USR, USB, v.90, faxmodem, networking, network">

</head>

</frameset>

</body></noframes>

</html>

The Main file of above frame set is PRODMAIN1.ASP whose picture is displayed as following:

In the top frame, of this page it displays different Categories where different computers parts are divided. It is a pull down menu. So If you move your mouse on one of the categories, it pulls menu down with sub-categories of the main categories. This thing is done under Java Script. All source code are shown in the below file:-

PRODMAIN1.ASP

<%Option Explicit%>

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">

<%Dim FPrice(12), PART(12), Price(12)

Dim UDC(12), rsCat2, Desc(12), DESC2(12)

Dim rsCat, TW, x, PIC(12), LOGO(12), USERDEF, UDCD(12)

x = 0

TW = 20

Set rsCat = connect.Execute("SELECT * FROM IMITMFIL WHERE ITEM_MAT_TYPE = 'S' ORDER BY ITEM_NO")

On Error Resume Next

do until rsCat.EOF

x = x + 1

PART(x) = rsCat("ITEM_NO")

Price(x) = rsCat("ITEM_PRICE")

DESC(x) = rsCat("ITEM_DESC1")

DESC2(x) = rsCat("ITEM_DESC2")

PIC(x) = RTRIM(rsCat("ITEM_NO")) + ".GIF"

UDC(x) = rsCat("ITEM_USER_DEF_CD")

FPrice(x) = FormatCurrency(Price(x))

LOGO(x)= UDC(x) + ".GIF"

rsCat.MoveNext

loop

rsCat.Close

connect.Close

Set rsCat = Nothing

Set connect = Nothing %>

<html>

<head>

<title>Consumer Depot Specials</title>

printers, drives, software, cpu's memory, modems, mice, and more.">

systems,monitors">

{text-decoration: none;}

.title

{position: absolute;

width: 100px;

height: 20px;

left: 10px;

z-index: 10;

font-family: verdana, helvetica, sans-serif;

font-weight: bold;

font-size: 12px;}

.submenu

{position: absolute;

left: 25px;

width: 120px;

border: 0px solid black;

background-color: none;

layer-background-color: none;

font-family: verdana, helvetica, sans-serif;

font-size: 10px;

visibility: hidden;}

</style>

‘Here some of the Style Sheet command are used which pull menu down

<!-- Begin

‘Java Script for Pull Down Menu

var nummenus = 6; // Number of menus

var titlearray = new Array(); // An array for the title objects

var submenuarray = new Array(); // An array for the submenu objects

if (document.layers) { // Set visibility for NN and IE

visible = 'show';

hidden = 'hide';

}

else

if (document.all) {

visible = 'visible';

hidden = 'hidden';

}

// Fills the arrays with title and submenu objects

for (var i = 0; i < nummenus; i++) {

titlearray[i] = ('title' + i);

submenuarray[i] = ('submenu' +i);

}

function toggle(n,move) {

menu = ('submenu' + n);

if (document.layers) {

submenu = document.layers[menu];

}

else if (document.all) {

submenu = document.all(menu).style;

}

// Changes image when category is clicked

function picopen(n) {

title = ('title' + n);

pic = ('pic' + n);

if (document.layers) {

document.layers[title].document.images[pic].src = "images/opened.gif";

}

else if (document.all) {

document.all(pic).src = "images/opened.gif";

}

function picclose(n) {

title = ('title' + n);

pic = ('pic' + n);

if (document.layers) {

document.layers[title].document.images[pic].src = "images/closed.gif";

}

else if (document.all) {

document.all(pic).src = "images/closed.gif";

}

if (submenu.visibility == visible) {

submenu.visibility = hidden;

picclose(n);

for (var i = (n+1); i < nummenus; i++) {

if (document.layers) {

document.layers[titlearray[i]].top -= move;

document.layers[submenuarray[i]].top -= move;

}

else

if (document.all) {

document.all(titlearray[i]).style.pixelTop -= move;

document.all(submenuarray[i]).style.pixelTop -= move;

}

else {

submenu.visibility = visible;

picopen(n);

for (var i = (n+1); i < nummenus; i++) {

if (document.layers) {

document.layers[titlearray[i]].top += move;

document.layers[submenuarray[i]].top += move;

}

if (document.all) {

document.all(titlearray[i]).style.pixelTop += move;

document.all(submenuarray[i]).style.pixelTop += move;

}

lastmenu = submenu;

}

//end of menu script

//-->

</script>

</head>

<table>

<tr>

</div>

‘Here Class SubMenu is called with id submenu0. This is linked to another page Categories.Asp with QueryString id.

</div></td>

</div>

</div></td>

<img name="pic2" src="images/closed.gif" border="0" width="1" height="1"><img

name="Image65" border="0" src="images/CAT31.gif" width="110" height="25"></a>

</div>

</div></td>

</div>

</div></td>

</div>

</div></td>

<td>

</div>

</div></td></tr></table>

<td width=110 height="110" valign="top"> <img src="images/<%=LOGO(1)%>" width="100" height="35"><br>

<div align="center"> <img src="images/<%=PIC(1)%>" width="75" height="75" border="0"><br>

<%=DESC2(1)%><br>

Item:#<br>

<br>

</a> </td>

<td width=110 height="110" valign="top"> <img src="images/<%=LOGO(2)%>" width="100" height="35"><br>

<div align="center"> <img src="images/<%=PIC(2)%>" width="75" height="75" border="0"><br>

<%=DESC2(2)%><br>

Item:#<br>

<br>

</a> </td>

<td width=110 height="110" valign="top"> <img src="images/<%=LOGO(3)%>" width="100" height="35"><br>

<div align="center"> <img src="images/<%=PIC(3)%>" width="75" height="75" border="0"><br>

<%=DESC2(3)%><br>

<br>

</a> </td>

<td width=110 height="110" valign="top"> <img src="images/<%=LOGO(4)%>" width="100" height="35"><br>

<div align="center"> <img src="images/<%=PIC(4)%>" width="75" height="75" border="0"><br>

<%=DESC2(4)%><br>

<br>

</a> </td>

<td width=110 height="110" valign="top"> <img src="images/<%=LOGO(5)%>" width="100" height="35"><br>

<div align="center"> <img src="images/<%=PIC(5)%>" border="0" width="75" height="75"><br>

<%=DESC2(5)%><br>

<br>

</a> </td>

<td width=110 height="110" valign="top"> <img src="images/<%=LOGO(6)%>" width="100" height="35"><br>

<div align="center"> <img src="images/<%=PIC(6)%>" border="0" width="75" height="75"><br>

<%=DESC2(6)%><br>

<br>

</a> </td>

</tr><tr >

<div align="center"><img src="images/<%=LOGO(7)%>" width="100" height="35"><br>

</div>

<div align="center"> <img src="images/<%=PIC(7)%>" width="75" height="75" border="0"><br>

<%=DESC2(7)%></font><br>

<br>

</a> </td>

<td width=110 height="110" valign="top"> <img src="images/<%=LOGO(8)%>" width="100" height="35"><br>

<div align="center"> <img src="images/<%=PIC(8)%>" width="75" height="75" border="0"><br>

<%=DESC2(8)%><br>

Item:#<br>

<br>

</a> </td>

<div align="center"><img src="images/<%=LOGO(9)%>" width="100" height="35"><br>

</div>

<div align="center"> <img src="images/<%=PIC(9)%>" border="0" width="75" height="75"><br>

<%=DESC2(9)%><br>

<br>

</a> </td>

<div align="center"><img src="images/<%=LOGO(10)%>" width="99" height="35"><br>

</div>

<div align="center"> <img src="images/<%=PIC(10)%>" border="0" width="75" height="75"><br>

<br>

<br>

</a> </td>

<div align="center"><img src="images/<%=LOGO(11)%>" width="100" height="35"><br>

</div>

<div align="center"> <img src="images/<%=PIC(11)%>" width="75" height="75" border="0"><br>

<%=DESC2(11)%><br>

<br>

</a> </td>

<div align="center"><img src="images/<%=LOGO(12)%>" width="100" height="35"><br>

</div>

<div align="center"> <img src="images/<%=PIC(12)%>" width="75" height="75" border="0"><br>

<%=DESC2(12)%><br>

<br>

</a> </td>

</tr>

</table>

</body>

</html>

v BROWSING CATEGORIES

The Inventory is Divided in to Different Categories and Each Categoreis is divided in their Sub-Categories. This way whole Inventory is displayed in whole Web site.

There are all together 6 Main Categories. And Six Main Categories are then divided in to 42 Sub Categories, Organize such a way that all Sub-Categories is related to its Main Categories.

The Six Main Categories and 42 Sub-Categories are as follows :-

1. COMPUTERS

· Computer PC’s

· NoteBooks PC’s

· Servers

2. PERIPHERALS

· Card Contoller’s

· Battery Products

· Apple Product’s

· MotherBoards

· Misc.Hardware

· Multi-Media

· Modem

· Networking

· Video Cards

3. DRIVES

· Hard Drives

· DVD Drives

· Floppy Drives

4. ACCESSORIES

· Cables & Adapters

· NoteBooks Options

· Media Supplies

· KeyBoard/Mice

· Case & Power Supply

· Chips & Memory

· Notebooks Memory

· Processors

· Software

5. PRINTERS

· Printers

· Printer Options

· Scanners

· Tonner & Ribbons

6. HOME/OFFICE

· Fax Machines

· Furniture

· Office Supplies

· Consumer Electric

This is a Frameset file which contains three frames top,side and Main Frame. When from the Product Page any one click on any particular categories. It will hit the Categories.Asp through unique id , which then on stores name of categories into it. Simultaneously it will also hit the other pages of frameset which also has same id So they will also gets a unique categories. There on with unique id It will go the Database and open the Item Master file and find all the record which matches that id and displays on the screen.

CATEGORIES.ASP

<% Dim strcat,ship

strcat = Request.QueryString("id")

Select Case strcat

Case "BB"

ship = "Power/Battery"

Case "BU"

ship = "Tape Backups"

Case "CA"

ship = "Cables"

Case "CD"

ship = "Card / Controllers"

Case "CDR"

ship = "CD Rom Drives"

Case "CE"

ship = "Consumer Electric"

Case "CN"

ship = "Laptops/Notebooks"

Case "CP"

ship = "Computers / PC's"

Case "CPA"

ship = "Apple / Macs Items"

Case "CS"

ship = "Case & Power Supply"

Case "CSV"

ship = "Servers"

Case "DR"

ship = "Hard Drives"

Case "DVD"

ship = "DVD Drives"

Case "FD"

ship = "Floppy Drives"

Case "FU"

ship = "Furniture"

Case "FX"

ship = "Fax / Copier"

Case "HO"

ship = "Home & Office"

Case "IC"

ship = "Chips & Memory"

Case "ICN"

ship = "Memory UpGrades"

Case "ICP"

ship = "CPU's"

Case "KB"

ship = "Keyboard / Mice"

Case "LA"

ship = "Labor"

Case "MB"

ship = "Motherboards"

Case "ME"

ship = "Media & Supplies"

Case "MH"

ship = "Misc. Hardware"

Case "MM"

ship = "Multi-Media"

Case "MN"

ship = "Monitors"

Case "MO"

ship = "Modems"

Case "NA"

ship = "Notebooks Options"

Case "NC"

ship = "Networking"

Case "OS"

ship = "Office Supply"

Case "PA"

ship = "Technical Parts"

Case "PO"

ship = "Printer Options"

Case "PR"

ship = "Printers"

Case "SCA"

ship = "Scanners"

Case "SUP"

ship = "Supplies"

Case "SVR"

ship = "Servers"

Case "SW"

ship = "Software"

Case "TO"

ship = "Toner / Ribbons"

Case "VC"

ship = "Video Cards"

End Select %>