hi,
i have the following form in pageAAA.asp which submit to sqlupdate.asp:
<form action="sqlupdate.asp" method="post" name="sqlupdateForm" id="sqlupdateForm" style="margin:0">
<table width="640" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="640" border="0" cellspacing="0" cellpadding="0">
<tr>
<th> </th>
<th><div align="left">Name</div></t
<th><div align="left">Account Type </div></th>
<th><div align="left">Account Number </div></th>
<th>Delivery</th>
<th>Changed</th>
</tr>
<tr>
<td colspan="6"><hr size="5"></td>
</tr>
<tr>
<td> </td>
<td><b>GoldAVA1</b> <
<td>Gold </td>
<td>963852 </td>
<td align="center">
<input name="mailprint_1" type="radio" value="Y" checked>By Mail
<input name="mailprint_1" type="radio" value="N">Online
<input name="number" id="number" type="hidden" value="963852" />
<input name="numbertype" id="numbertype" type="hidden" value="9" />
<input name="numberdesc" id="numberdesc" type="hidden" value="Gold" />
</td>
<td align="center">Customer</t
</tr>
<tr>
<td> </td>
<td><b>NormalAVA2</b> 
<td>Normal</td>
<td>654321 </td>
<td align="center">
<input name="mailprint_2" type="radio" value="Y" checked>By Mail
<input name="mailprint_2" type="radio" value="N">Online
<input name="number" id="number" type="hidden" value="654321" />
<input name="numbertype" id="numbertype" type="hidden" value="3" />
<input name="numberdesc" id="numberdesc" type="hidden" value="Normal" />
</td>
<td align="center">Customer</t
</tr>
<tr>
<td> </td>
<td><b>PersonalAVA3</b>&nb
<td>Personal </td>
<td>789987</td>
<td align="center">
<input name="mailprint_3" type="radio" value="Y" checked>By Mail
<input name="mailprint_3" type="radio" value="N">Online
<input name="number" id="number" type="hidden" value="789987" />
<input name="numbertype" id="numbertype" type="hidden" value="1" />
<input name="numberdesc" id="numberdesc" type="hidden" value="Personal" />
</td>
<td align="center">Company</td
</tr>
<tr>
<td> </td>
<td><b>BasicAVA4</b>
<td>Basic </td>
<td>123456</td>
<td align="center">
<input name="mailprint_4" type="radio" value="Y" checked>By Mail
<input name="mailprint_4" type="radio" value="N">Online
<input name="number" id="number" type="hidden" value="123456" />
<input name="numbertype" id="numbertype" type="hidden" value="1" />
<input name="numberdesc" id="numberdesc" type="hidden" value="Basic" />
</td>
<td align="center">Company</td
</tr>
</table></td>
</tr>
<tr>
<td>
<br>
<br>
<input name="client_id" id="client_id" type="hidden" value="alibaba" />
<input name="client_location" id="client_location" type="hidden" value="0202" />
<table width="640" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="right" style="padding-right:4px">
<td style="padding-left:4px"><
</tr>
</table>
<br>
<br>
</td>
</tr>
</table>
</form>
in sqlupdate.asp i need to run a update query for each of the submitted account data block of the form
form data block 1 example:
<input name="mailprint_1" type="radio" value="Y" checked>By Mail
<input name="mailprint_1" type="radio" value="N">Online
<input name="number" id="anb" type="hidden" value="963852" />
<input name="numbertype" id="atp" type="hidden" value="9" />
<input name="numberdesc" id="atp" type="hidden" value="Gold" />
form data block 2 example:
<input name="mailprint_2" type="radio" value="Y" checked>By Mail
<input name="mailprint_2" type="radio" value="N">Online
<input name="number" id="number" type="hidden" value="963852" />
<input name="numbertype" id="numbertype" type="hidden" value="9" />
<input name="numberdesc" id="numberdesc" type="hidden" value="Gold" />
my problem is:
how must my form be submitted and/or how must my asp code in sqlupdate.asp be in order to run the update query "update datatable set mailprint= mailprintdata(1,2,3,4), number = numberdata, numbertype=numbertypedata,
for each of the data block submitted?
how must the loop in the sqlupdate.asp be to run the query each data block
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I don't think that ASP will automatically create arrays even if the names of the form fields look like them. PHP does, ASP does not.
Anyway, it is a matter of giving unique names to the formfields. The alternative is guessing that the order of the fields in the form equals the order in which the browser passes them to the server. That is not reliable enough.
ok if i submit the form like
<input name="sup[1][acct_1]" type="radio" value="Y" checked>By Mail
<input name="sup[1][acct_1]" type="radio" value="N">Online
<input name="sup[1][number]" id="anb" type="hidden" value="963852" />
<input name="sup[1][numbertype]" id="atp" type="hidden" value="9" />
<input name="sup[1][numberdesc]" id="atp" type="hidden" value="Gold" />
<input name="sup[2][acct_2]" type="radio" value="Y" checked>By Mail
<input name="sup[2][acct_2]" type="radio" value="N">Online
<input name="sup[2][number]" id="anb" type="hidden" value="654321" />
<input name="sup[2][numbertype]" id="atp" type="hidden" value="3" />
<input name="sup[2][numberdesc]" id="atp" type="hidden" value="Normal" />
how must i read it in the asp code and display it
i found a code that seems to read the array but, i don't know exactly how modify it to read in the data of my form
here the asp array code i found:
Dim arrCars(2,4)
arrCars(0,0) = "BMW"
arrCars(1,0) = "2004"
arrCars(2,0) = "45.000"
arrCars(0,1) = "Mercedes"
arrCars(1,1) = "2003"
arrCars(2,1) = "57.000"
arrCars(0,2) = "Audi"
arrCars(1,2) = "2000"
arrCars(2,2) = "26.000"
arrCars(0,3) = "Bentley"
arrCars(1,3) = "2005"
arrCars(2,3) = "100.00"
arrCars(0,4) = "Mini"
arrCars(1,4) = "2004"
arrCars(2,4) = "19.00"
response.Write(" <TABLE border=1>")
response.Write("<TR><TD>Row</TD
response.Write("<TD>Year</TD><T
For i = 0 to UBound(arrCars, 2)
response.Write("<TR><TD>#" & i & "</TD>")
response.Write("<TD>" & arrCars(0,i) & "</TD>")
response.Write("<TD>" & arrCars(1,i) & "</TD>")
response.Write("<TD>" & arrCars(2,i) & "</TD></TR>")
Next
response.Write("</TABLE>")
hi,
if i do the following
ReDim arrFormValues(1, Request.Form.Count - 1)
Dim i : i = 0
For Each Item In Request.Form
arrFormValues(0, i) = Item 'Form Field Names
arrFormValues(1, i) = Request.Form(Item) 'Form Field Values
i = i + 1
Next : Item = Null : i = Null
'To write it all out:
'Check to make sure there is an array first
If IsArray(arrFormValues) Then
'We want to loop through the second index
For i = 0 To UBound(arrFormValues, 2)
'Write out the Filed Name= Field Value
Response.Write(arrFormValu
Next : i = Null
End If
i get as output
sup[1][acct_1]= Y
sup[2][number]= 654321
sup[2][numbertype]= 3
sup[2][numberdesc]= Normal
sup[1][number]= 963852
sup[1][numbertype]= 9
sup[1][numberdesc]= Gold
sup[2][acct_2]= Y
sup[3][number]= 789987
sup[3][numbertype]= 1
sup[3][numberdesc]= Personal
sup[3][acct_3]= Y
sup[4][number]= 123456
sup[4][numbertype]= 1
sup[4][numberdesc]= Basic
sup[4][acct_4]= N
client_id= alibaba
client_location= 0202
Submit= Submit
which is ok but,
how must i modify above code in order to run the sql code for each sup[1] data, sup[2] data etc...... separately. i must run the sql like:
update datatable set mailprint= "sup[4][acct_4] data", number = "sup[4][number] data", numbertype="sup[4][numbert
hi,
is asp able to do this (read the array and use the array data):
foreach($_REQUEST['sup'] as $id => $sup) {
$sql = "INSERT INTO 'datatable' ('mailprint','number','num
echo "$sql<br/>";
}
how will is this code be translated in asp?
There is no simple way to do this as you are trying to do it. The code or method you are looking at is for PHP. ASP doesn't do the same thing. The expert Sybe was right.
There are some ways to maybe reuse some code but you basically have to look at each group and then get each field manually. There won't be an automatic array made by the server or ASP. You just have the Request.Form Collection which will contain ALL the fields and no way to "group" them. The naming scheme you seemed to have at first would appear as good, if not better, than what you have now. You could use a counter to go through each group (i.e. a number since you know how many groups and the number is part of the name). Also, if one field would be required for the "group" then you could look for it first in the Form collection to know if the other values would be there (for that group).
Sorry it won't be simple. If you must keep it basic then see if your server supports PHP. It could be used instead and has some great abiliities.
bol
Business Accounts
Answer for Membership
by: ArasianPosted on 2009-10-19 at 16:51:44ID: 25609948
You can name your form elements with arrays.
mailprint[1]
mailprint[2]
Even multi-dimensionally
mailprint[1][name]
mailprint[1][address]
Then simply (pseudocode)
for i=0; i < size_of(mailprint); i++ :
do_something(mailprint[i])