Wrox Programmer Forums
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 1st, 2005, 05:21 PM
Registered User
Join Date: Mar 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts

hi everyone...im very new in asp n ive got a project to submit in few dayz..ive got some questions related to asp.
i have a company website in making. now first of all i have to connect everywebpage with the company's database. so that customers can register, track orders and search through the company's database.
We have a customer login form in our web site so customers who wish to brows items on our site must first sign up with us so we have a record. jus like e-bay and stuff. Now the fields in the customer table are zaxtly da same as fields in the registration form so the information can directly be entered in da data base and the customer ID would b used as the customer login name.
now ive made the connection to the database..but im not sure if it's right..its as follows

Dim adoCon 'Holds the Database Connection Object
Dim rsInventory_Control2 'Holds the recordset for the records in the database
Dim strSQL 'Holds the SQL query to query the database
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Inventory_Control2.mdb")
Set rsInventory_Control2 = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT tblCustomers.CustomerID, tblCustomers.EMAilAddress FROM tblCustomers;"
rsInventory_Control2.Open strSQL, adoCon
Do While not rsInventory_Control2.EOF

     Response.Write ("<br>")
     Response.Write (rsInventory_Control2("Customer ID"))
     Response.Write ("<br>")
     Response.Write (rsInventory_Control2("Email Address"))
     Response.Write ("<br>")



Set rsInventory_Control2 = Nothing
Set adoCon = Nothing

now first things first...how do i make the information written in registration form be part of the database(i.e add to database) and save it for future reference...plz give the codes if possible...i think we have to use some sort of SQL query....initialize a variable and assign a value to it

Old March 3rd, 2005, 06:43 AM
Friend of Wrox
Join Date: Oct 2003
Posts: 479
Thanks: 0
Thanked 3 Times in 3 Posts
Send a message via MSN to surendran Send a message via Yahoo to surendran

hi angelfiire,
find the following link
i think it will help you

(Anything is Possible)

Similar Threads
Thread Thread Starter Forum Replies Last Post
URGENT_PLZ HELP angelfiire Classic ASP Databases 1 March 2nd, 2005 03:13 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.