473,326 Members | 2,255 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Passing database info to page allow user input then pass into another database

Hi I really am going crazy!
I'm using VBScript, ASP, and SQL
My page reminds me of a shopping cart but looking at shopping cart
examples has not helped!
What I have is a page that brings in products ordered by a certain
company. Along with those values, I'm creating a text box at the end
of each record that a user may or may not enter in an estimated
delivery date. If the user does enter in a date I want that row of
data submitted to a table with that date. First of all I need to check
to see if the user has entered anything in the text boxes. I was
trying to go through them with a for next loop using
document.form.elements.length as my ending count but that did not seem
to work. Also another problem I am facing is making sure all the
records on the page are being looked at. I wanted to put my if
request.form("submitTop") <> "" underneath where my recordset is open,
but this too does not work.
So what I need to happen when the submit button is hit is:
A way to check and see if something is entered in a text box, if it is
then add that line of data pulled from my first table and the user
input estimated delivery date value into a new table. I need to make
sure I go to each record in my list to check to see if anything has
been entered in the text box.
Thank you very much. Any help on any little bit of my problem would be
greatly appreciated!
Renie83
Jul 19 '05 #1
2 2805
May I suggest splitting up your questions into individual posts that focus
on one particular task? I kinda got lost. Also, maybe some code or a
layout of your form would help.

Ray at work

"Renie83" <re*****@lycos.com> wrote in message
news:8e**************************@posting.google.c om...
Hi I really am going crazy!
I'm using VBScript, ASP, and SQL
My page reminds me of a shopping cart but looking at shopping cart
examples has not helped!
What I have is a page that brings in products ordered by a certain
company. Along with those values, I'm creating a text box at the end
of each record that a user may or may not enter in an estimated
delivery date. If the user does enter in a date I want that row of
data submitted to a table with that date. First of all I need to check
to see if the user has entered anything in the text boxes. I was
trying to go through them with a for next loop using
document.form.elements.length as my ending count but that did not seem
to work. Also another problem I am facing is making sure all the
records on the page are being looked at. I wanted to put my if
request.form("submitTop") <> "" underneath where my recordset is open,
but this too does not work.
So what I need to happen when the submit button is hit is:
A way to check and see if something is entered in a text box, if it is
then add that line of data pulled from my first table and the user
input estimated delivery date value into a new table. I need to make
sure I go to each record in my list to check to see if anything has
been entered in the text box.
Thank you very much. Any help on any little bit of my problem would be
greatly appreciated!
Renie83

Jul 19 '05 #2
MDW
Well, there are a couple of ways to go about doing this.
Few questions, first:

Do all the text boxes in question have the same name?

Are we working with a dynamic number of records, where one
time we could be looking at 2 products, another time we're
looking at 50?

The page w/ the textboxes, I assume it's getting posted or
something to another page. Are all the records being
posted at once, or is there a seperate "Submit" button for
each product?
-----Original Message-----
Hi I really am going crazy!
I'm using VBScript, ASP, and SQL
My page reminds me of a shopping cart but looking at shopping cartexamples has not helped!
What I have is a page that brings in products ordered by a certaincompany. Along with those values, I'm creating a text box at the endof each record that a user may or may not enter in an estimateddelivery date. If the user does enter in a date I want that row ofdata submitted to a table with that date. First of all I need to checkto see if the user has entered anything in the text boxes. I wastrying to go through them with a for next loop using
document.form.elements.length as my ending count but that did not seemto work. Also another problem I am facing is making sure all therecords on the page are being looked at. I wanted to put my ifrequest.form("submitTop") <> "" underneath where my recordset is open,but this too does not work.
So what I need to happen when the submit button is hit is:
A way to check and see if something is entered in a text box, if it isthen add that line of data pulled from my first table and the userinput estimated delivery date value into a new table. I need to makesure I go to each record in my list to check to see if anything hasbeen entered in the text box.
Thank you very much. Any help on any little bit of my problem would begreatly appreciated!
Renie83
.

Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Joe | last post by:
I am trying to write a Perlscript to be used with some HTML pages. Here is how it works: 1.. The first HTML page has a form which requests for user input. Then it passes the QUERY_STRING...
6
by: Rob Meade | last post by:
Hi all, At work we have 2 servers in a cluster for our web apps. One problem we have experienced (along with many others!) - is that if a user is logged into one of the applications on server...
12
by: Kevin Lyons | last post by:
Hello, I am trying to get my select options (courses) passed correctly from the following URL: http://www.dslextreme.com/users/kevinlyons/selectBoxes.html I am having difficulty getting the...
10
by: Noozer | last post by:
Below is some ASP, HTML and javascript. It is part of a page used to maintain a small database. This code did work at one time, but has since stopped. For some reason the data on my form is not...
0
by: Omar K | last post by:
Hi, I am quite new to frontpage and SQL but I have a Stock Control access database / frontpage to set up. My last problem deals with the automatic updating of the total quantity of stock with parts...
2
by: Filippo Pandiani | last post by:
Hi there, I am looking for a clean solution that will allow me to share critical info (like username and password) values between separate DLL application. Here is my scenario: contains the...
1
by: Irfan Akram | last post by:
Hi People, Just wondering how we can pass info from one page to another when we enter Response.Redirect("CertainPage.aspx",false), so that we can observe this information and display...
2
by: lacombpcs | last post by:
I have a web app that searches a database and returns a datagrid table. the user inputs the search terms into a textbox. The user selects the info he wants and it sends him to a 2nd page, after...
3
by: delram | last post by:
I'm trying to get user selections (using checkboxes) on one JSP page(A.jsp) and pass them on to another page. So I have one page with a list of dynamically populated items like this 1 2 ...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.