I need help finishing this asp page. The problem is I am on a time constraint. Here's what needs to happen. Right now the code creates a list value from a sql query based on the user logged on and the state selected. These values are passed to the [url removed, login to view] The values are listed with a checkboxes to the left of them and quantities to the right. The user clicks the checkbox of the items they want to order and then selects the quantity from a drop down. They then click submit. What I can't figure out is: When the user clicks submit how do I: a.) Create a record in the order table with header information, eg. [OrderID] [int] IDENTITY (2000, 1) NOT NULL , [AgentID] [int] NOT NULL , [OrderDt] [datetime] NOT NULL , [CreateDt] [datetime] NULL , [CrtdByID] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [StatCd] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [LastModID] [int] NULL , [LastModDt] [datetime] NOT NULL , [CancelledDt] [datetime] NULL , [SelectedState] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL; then b.) Update the orderitems table to create the child records to this header which will update with the items that are checked and have a quantity assigned to them by the user. eg. [OrderID] [int] NOT NULL from the above header record [ItemID] [int] NOT NULL from the selected item(s) [RqstdQty] [int] NOT NULL from the quantity.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
4) Finished and working asp page, pages.
asp page needs to run in a browser environment preferrably IE