How to do looping with array..

choohean · Apr 29, 2002

I've tried to do something like below so that I can do the insert procedure to save a few sets of data into the database from a multirow table... Can anyone here please help to have a look what's wrong it it?!

dim number, counter

counter = 0

number=Request.Form("count&quot

Do until counter = number
counter = counter + 1

yr = Request.Form("yr_"&counter&"&quot

Response.Write(yr)

Loop

Jonax · Apr 29, 2002

Try this:

Code:

dim number, counter

counter = 0

number=Request.Form(&quot;count&quot;)

Do until counter = number
  counter = counter + 1
      
    yr = Request.Form(&quot;yr_&quot;&counter)
    
    Response.Write(yr)

Loop

This is not a bug - it's an undocumented feature...
;-)

choohean · Apr 29, 2002

I've tried but come out with an error...

Active Server Pages, ASP 0113 (0x80004005)
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.

Jonax · Apr 29, 2002

Sounds like an infinite loop...
What exactly are you trying to accomplish?

Do you have a form calling this?! This is not a bug - it's an undocumented feature...
;-)

choohean · Apr 29, 2002

Ya... I got a form to call this function...Can you help me to have a look on the form....

this is my form!

<head>
<script LANGUAGE="javascript">
<!--

var totalTableRow = 1; // NUMBER OF DE TABLE ROWS

function addTableRow(tableName)
{
totalTableRow = totalTableRow + 1
var newRow;
var newCell;
var currentRow;

currentRow = totalTableRow

newRow = tableName.insertRow();

newCell = newRow.insertCell();
newCell.innerHTML = "<SELECT id=yr_" + currentRow + " name=yr_" + currentRow + "><OPTION value=2002>2002</OPTION><OPTION value=2003>2003</OPTION><OPTION value=2004>2004</OPTION></SELECT>"

newCell = newRow.insertCell();
newCell.innerHTML = "<INPUT type='text' id=fm_" + currentRow + " name=fm_" + currentRow + ">";

newCell = newRow.insertCell();
newCell.innerHTML = "<INPUT type='text' id=sq_" + currentRow + " name=sq_" + currentRow + ">";

document.form1.count.value = currentRow

}

</script>

</head>
<body>

<form name="form1" method="post" action="try6.asp">
<p> </P>
<table id="deTable" name="teTable" border="1" width="100%">
<tr>
<td>Year</TD>
<td>Make</TD>
<td>Model</TD></TR>
<tr>
<td>
<select id="yr_1" name="yr_1">
<option value="2002" selected>2002</OPTION>
<option value="2003">2003</OPTION>
<option value="2004">2004</OPTION></SELECT> </TD>
<td><input id="mk_1" name="mk_1"></TD>
<td><input id="dl_1" name="dl_1"></TD></TR></TABLE>
<hr>
Total Entry(ies):
<INPUT id="count" name="count" value="1" style="HEIGHT: 22px; WIDTH: 40px"><br>
<input type="button" value="Add Row" id="badd" name="badd" onclick="addTableRow(deTable);">

<input type="submit" value="Submit" id="submit1" name="submit1">
</FORM>

</body>
</html>

Jonax · Apr 29, 2002

Your problem is in these two lines of code:

Code:

number=Request.Form(&quot;count&quot;)

Do until counter = number

counter and number never get equal, as the one is a integer and the other a string...

try this instead:

Code:

number=CInt(Request.Form(&quot;count&quot;))

Do until counter = number

This is not a bug - it's an undocumented feature...
;-)

choohean · Apr 29, 2002

Thanks...It work....
Really thanks a lot for helping me...
You are so kind...

regards, eddy

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

How to do looping with array..

choohean

Technical User

Jonax

Programmer

choohean

Technical User

Jonax

Programmer

choohean

Technical User

Jonax

Programmer

choohean

Technical User

Similar threads

Part and Inventory Search

Sponsor