I am hand-coding (no FrontPage or Dreamweaver) an ASP, VBScript, JavaScript, MS Access 2000 dynamic web site.
Here are some code excerpts:
form1.asp
<label>Please enter name:
<input name = "deliName" type = "text">
</label>
Please select all sandwiches that you make:
<select name = "sandTypes" multiple size = "1">
<option>Reuben</option>
<option>PBJ</option>
<option>Grilled Cheese</option>
<option>BLT</option>
</select>
//End form1.asp
submitform.asp (Assume DB connection and rest of page works)
<%
Dim shopName, sandwichTypes
shopName = Request.Form("deliName"
sandwichTypes = ?????????????????
SQL = "INSERT INTO DeliTable (name) VALUES('" & shopName & "')"
SQLTWO = "INSERT INTO SandTable (?????) VALUES (??????)"
'End submitform.asp
%>
I just need to know how to GET ALL selected items from form1.asp, PUT them into an array, TEST against database field headers and finally send a YES or NO indicator to each sandwich field (Hopefully NO can be set as default).
I could use checkboxes, but my application is much larger and the user would get annoyed at having to check as opposed to highlighted selected items.
Database tables:
DeliTable:
deliID | deliName | etc....
SandTable:
deliID | Reuben | PBJ | Grilled Cheese | BLT |
1 yes no yes yes
2 no yes yes no
Thanks
(I hope the format of my tables comes thru enuf to see goal.
Here are some code excerpts:
form1.asp
<label>Please enter name:
<input name = "deliName" type = "text">
</label>
Please select all sandwiches that you make:
<select name = "sandTypes" multiple size = "1">
<option>Reuben</option>
<option>PBJ</option>
<option>Grilled Cheese</option>
<option>BLT</option>
</select>
//End form1.asp
submitform.asp (Assume DB connection and rest of page works)
<%
Dim shopName, sandwichTypes
shopName = Request.Form("deliName"
sandwichTypes = ?????????????????
SQL = "INSERT INTO DeliTable (name) VALUES('" & shopName & "')"
SQLTWO = "INSERT INTO SandTable (?????) VALUES (??????)"
'End submitform.asp
%>
I just need to know how to GET ALL selected items from form1.asp, PUT them into an array, TEST against database field headers and finally send a YES or NO indicator to each sandwich field (Hopefully NO can be set as default).
I could use checkboxes, but my application is much larger and the user would get annoyed at having to check as opposed to highlighted selected items.
Database tables:
DeliTable:
deliID | deliName | etc....
SandTable:
deliID | Reuben | PBJ | Grilled Cheese | BLT |
1 yes no yes yes
2 no yes yes no
Thanks
(I hope the format of my tables comes thru enuf to see goal.