Urgent Help! Please!

ASP Free Forums Sponsor:

March 31st, 2005, 11:38 AM

squishington

Registered User

Join Date: Mar 2005

Posts: 7

Time spent in forums: 1 h 7 m 6 sec
Reputation Power: 0

Urgent Help! Please!

Hi, im a college student currently working on a web based project. I was wondering if anyone could help me out with a small problem that I have encountered.

The project is an ordering system, which allows users to order multiple products by entering in the product quantities in a text box. The technologies I am using are Macromedia Dreamweaver MX, ASP VBscripting, and a MS Access database to hold all the products.

Could anyone please tell me how do I create and order list that allows me to specify multiple products at the one time and also to allow me to enter in the quantity of each product? The next page should then show a list of the products ordered. After this is confirmed the product numbers and quantities need to be stored in an order details Table within the database.

Any help would be very appreciated!

March 31st, 2005, 01:35 PM

Phoenix

Web-Standards Evangelist

ASP Free Intermediate (1500 - 1999 posts)

Join Date: Nov 2003

Posts: 1,522

Time spent in forums: 4 Days 23 h 48 m 4 sec
Reputation Power: 8

I'd go into detail... but long story short: I have to use non-offensive and politically correct bullet points to convey educational messages

Don't use Dreamweaver MX
"Dreamweaver MX" isn't a technology, its a software product
Create a recordset (By yourself, never use Dreamweaver's "Server Behaviours" mmm'key?)
Output the recordset (again, by yourself) and put a textbox in each repeated area
Add a form handler
You're done

Ciao
-WebStandardsMan

March 31st, 2005, 01:54 PM

lewy

Alter Ego Wizard

Join Date: Jun 2004

Location: Edinburg Tx

Posts: 4,376

Folding Points: 1009 Folding Title: Novice Folder

Time spent in forums: 1 Month 1 Week 1 Day 21 h 21 m 31 sec
Reputation Power: 1391

Once you decide to rid yourself of DreamWeaver, you can begin learning good asp+db interaction tutorials at W3Schools

__________________
................... ASCII and ye shall receive ..................
Knowledge is the only resource on earth that multiplies when shared

Support the Shemzilla Project
Powered by C#

March 31st, 2005, 02:40 PM

Phoenix

Web-Standards Evangelist

Join Date: Nov 2003

Posts: 1,522

Time spent in forums: 4 Days 23 h 48 m 4 sec
Reputation Power: 8

Quote:

Originally Posted by squishington

im afraid we have to use dreamweaver...

That's no excuse... code manually in "Code View". The "Design View" is just for 14 yearolds who got a cracked copy of Photoshop and want to make "1337 art sites". The result is bloated sites... be a purist, its quicker for me to code manually than it is to use WYSIWYG tools... plus you get full control.

When you get the change, get Microsoft's VisualStudio, you can get it on a student license for only £80.

Anyway, use this recordset code:

Code:

    Dim Rs
    Set Rs = Server.CreateObject("ADODB.Recordset")
    Rs.ActiveConnection = "CONNECTION STRING GOES HERE"
    Rs.Source = "SQL STATEMENT GOES HERE"
    Rs.CursorType = 3
    Rs.Open()

This one is very simple and doesn't require any "ADODB.Connection" objects... its all integrated into the single class.

As for repeating, use:

Code:

    <form id="frmOne" action="FORM HANDLER URI GOES HERE" method="post">
    <% Do While Not Rs.EOF or Rs.BOF %>
    
    <%= Rs.Fields.Item("FieldOne").Value %>
    
    <%= Rs.Fields.Item("FieldTwo").Value %>
    
    <%= Rs.Fields.Item("FieldThree").Value %>
    
    <input type="text" size="3" maxlength="4" name="Quanity-<%= Rs.Fields.Item("FieldFour").Value %>" />
    <% Rs.Movenext
    Loop %>
    </form>

You should be able to reverse engineer that to your own uses.

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: