By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,836 Members | 2,018 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,836 IT Pros & Developers. It's quick & easy.

display multiple input boxes based on results

P: n/a
Say a customer inserts into a sql database field (NUMINSERTS) the number
6.

On the following page, I want to build a table that displays 6 input
boxes, since the customer said they wanted 6 text boxes.

I will then insert the data from the 6 text boxes back into another sql
database table.

For example:
Page 1: Ask client how many items they want to insert. Client types in
6.
Page 2: Table is displayed with input boxes for title of item 1 and
price of item 1. Then title for item2 and price for item 2, and on and
on until 6 are diaplyed.

How do I get the correct number of text boxes to be displayed? AND then,
how do I insert them into another table (ITEMINFO)
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi Joey,

Try something like this.

<%
''user submitted number already, i.e. 6
iNumberOfTextBoxes = Request.Form("txtNumberOfTextboxesDesired")
''code to make sure there was no
''nonsense input, like a letter, or empty, etc.
%>

<form method="post" action="process.asp">
<% For i = 1 To iNumberOfTextBoxes %>

<input name="txtTitle<%=i%>" type="text">
<input name="txtPrice<%=i%>" type="text">
<% Next %>

<input type="hidden" name="count" value="<%=iNumberOfTextBoxes%>">
<input type="submit">
</form>
process.asp:

<%
iCount = Request.Form("count")
'''open ado connection, oADO
For i = 1 To iCount
sTitle = Request.Form("txtTitle" & i)
sPrice = Request.Form("txtPrice" & i)

'''validate the input here

sSQL = "INSERT INTO someTable (Title,Price) VALUES ('" & sTitle & "'," &
sPrice & ")"
oADO.Execute sSQL,,129
Next
'''close and kill ADO connection
%>

That would be a basic layout of what would happen. You'd generate the form
on the fly with input boxes named:

txtTitle1,txtPrice1
txtTitle2,txtPrice2
txtTitle3,txtPrice3
txtTitle4,txtPrice4
....

Then you'd write the number to a hidden input.

Then when the form is submitted, you'd take the value from the hidden input
and use that to rebuild the input element names.

You'd want to make sure you add validation code all over.

Ray at work


"Joey" <no****@infosmiths.net> wrote in message
news:uA**************@TK2MSFTNGP09.phx.gbl...
Say a customer inserts into a sql database field (NUMINSERTS) the number
6.

On the following page, I want to build a table that displays 6 input
boxes, since the customer said they wanted 6 text boxes.

I will then insert the data from the 6 text boxes back into another sql
database table.

For example:
Page 1: Ask client how many items they want to insert. Client types in
6.
Page 2: Table is displayed with input boxes for title of item 1 and
price of item 1. Then title for item2 and price for item 2, and on and
on until 6 are diaplyed.

How do I get the correct number of text boxes to be displayed? AND then,
how do I insert them into another table (ITEMINFO)
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 19 '05 #2

P: n/a
Ray, thanks for your help. That's what I needed!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.