looping thru an array and inserting the data with JS 1

bikebanditcom · Aug 4, 2003

the following post was made to a question of mine, however i can't get the code to work and have yet to hear back from that post, can anyone help me with the final part of this bit of code, what i need is to know how to write the sql statement and declare which fields to insert into in the database.

there are three declared below in the array, partNumber, qty, and dealer, all of those go into tblPartInfo, and all go into fields of the same name. anyone have any clue as to how to do this? here is his post

"The way you're form data and table are mean that you'll need the 2-dimensional array....

dim fieldArr()
redim fieldArr(9,0) 'assuming 10 total fields for each record'

'if you have fields that do not fit the name_## format, you may need to alter this to handle them'

for each item in request.form
underscorePos = inStr(item, "_&quot

recordNum = mid(request.form(item), underscorePos + 1)
if recordNum > uBound(fieldArr,2) then
redim preserve(fieldArr(9,cInt(recNum)))
end if
select case left(item,underscorePos - 1)
case "partNumber"
arrPos = 0
case "qty"
arrPos = 1
case "dealer"
arrPos = 2
'complete for all items

end select
fieldArr(arrPos, cInt(recNum)) = request.form(item)
next

'now just write you sql for each record'
for x = 1 to uBound(fieldArr,2)
sql = "INSERT myTable VALUES("&_
"'" & fieldArr(0,x) & "'," &_
"'" & fieldArr(1,x) & "'," &_
"'" & fieldArr(2,x) & "'," &_
'continue for all records and add a closing &quot

"
cn.execute (sql)
next "

Veep · Aug 4, 2003

Put this at the top of your page and post the result here so I (we) can see what we're dealing with:

<%
for each objItem in request.form()
response.write(objItem & " = " & request.form(objItem) & "<br>&quot

Next
response.end()
%>

bikebanditcom · Aug 4, 2003

here are the results:

empID = DH
orderID =
qty =
dealer = SelectOne
UnreturnableToSupp = No
bAmount =
reason = SelectOne
crdtToBeIssd = Yes
RANempID = Select One
bDate =
custName =
exNumber =
california = No
complete = Yes
rcvd15Day = Yes
hdnRecordCount = 0
addRtrnShipping =
email =
Rfault = Select One
Rshipping = Select One
partNumber =
addOrigShipping =
mercValue =
shipped = Yes
custRestockingFee = Yes
ReturnsSubmit = Submit

the following is the script i'm using to generate the dynamic form elements, giving you an idea of the results i need to loop thru:
<script language="JavaScript">
<!--
var recordCount = 0;
//start AddRow function block
function AddRow(){

var elemTbody, elemRow;
var elemCols = new Array(10);
var elempartNumber, elemQty, elemDealer, elemPrice, elemReason, elemExPartNumber, elemShipped, elemRcvd15Day, elemCrdtToBeIssd, elemCustRestockingFee, elemUnreturnableToSupp;

//create a reference to the tbody element in our table
elemTbody = document.getElementById("ResultTable&quot

.getElementsByTagName("tbody&quot

[0];

//create the tr and td objects
elemRow = document.createElement("tr&quot

;
elemCols[0] = document.createElement("td&quot

;
elemCols[1] = document.createElement("td&quot

;
elemCols[2] = document.createElement("td&quot

;
elemCols[3] = document.createElement("td&quot

;
elemCols[4] = document.createElement("td&quot

;
elemCols[5] = document.createElement("td&quot

;
elemCols[6] = document.createElement("td&quot

;
elemCols[7] = document.createElement("td&quot

;
elemCols[8] = document.createElement("td&quot

;
elemCols[9] = document.createElement("td&quot

;
elemCols[10] = document.createElement("td&quot

;

//create our text inputs and our select dropdown
elemPartNumber = document.createElement("input&quot

;
elemQty = document.createElement("input&quot

;
elemDealer = document.createElement("select&quot

;
elemMercValue = document.createElement("input&quot

;
elemReason = document.createElement("select&quot

;
elemExNumber = document.createElement("input&quot

;
elemShipped = document.createElement("select&quot

;
elemRcvd15Day = document.createElement("select&quot

;
elemCrdtToBeIssd = document.createElement("select&quot

;
elemCustRestockingFee = document.createElement("select&quot

;
elemUnreturnableToSupp = document.createElement("select&quot

;

var elemOption;
var elemOption2;

//do the text boxes first
elemPartNumber.name = "partNumber_" + recordCount;
elemPartNumber.type = "text";

elemQty.name = "qty_" + recordCount;
elemQty.type = "text";
elemQty.size = "4"

elemMercValue.name = "mercValue_" + recordCount;
elemMercValue.type = "text";
elemMercValue.size = "8"

elemExNumber.name = "exPartNumber_" + recordCount;
elemExNumber.type = "text";

//do the select box next
elemDealer.name = "dealer_" + recordCount;
elemDealer.size = "1";

elemReason.name = "reason_" + recordCount;
elemReason.size = "1";

elemShipped.name = "shipped_" + recordCount;
elemShipped.size = "1";

elemRcvd15Day.name = "Rcvd15Day_" + recordCount;
elemRcvd15Day.size = "1";

elemCrdtToBeIssd.name = "CrdtToBeIssd_" + recordCount;
elemCrdtToBeIssd.size = "1";

elemCustRestockingFee.name = "CustRestockingFee_" + recordCount;
elemCustRestockingFee.size = "1";

elemUnreturnableToSupp.name = "UnreturnableToSupp_" + recordCount;
elemUnreturnableToSupp.size = "1";

//add the options
var optCtr;
// creating a new option: text, value

//add the option
elemOption = new Option("Select One","Select One&quot

;
elemDealer.add(elemOption);
elemOption = new Option("HOUSE","HOUSE&quot

;
elemDealer.add(elemOption);
elemOption = new Option("PARTS","PARTS&quot

;
elemDealer.add(elemOption);
elemOption = new Option("TR","TR&quot

;
elemDealer.add(elemOption);
elemOption = new Option("VLE","VLE&quot

;
elemDealer.add(elemOption);
elemOption = new Option("SOUTH","SOUTH&quot

;
elemDealer.add(elemOption);

elemOption2 = new Option("Select One","Select One&quot

;
elemReason.add(elemOption2);
elemOption2 = new Option("Customer Return","Customer Return&quot

;
elemReason.add(elemOption2);
elemOption2 = new Option("Incorrect or Damaged","Incorrect or Damaged&quot

;
elemReason.add(elemOption2);
elemOption2 = new Option("Exchange","Exchange&quot

;
elemReason.add(elemOption2);
elemOption2 = new Option("BB - No Fee","BB - No Fee&quot

;
elemReason.add(elemOption2);
elemOption2 = new Option("BB - Pay Fee","BB - Pay Fee&quot

;
elemReason.add(elemOption2);

elemOption3 = new Option("Yes","Yes&quot

;
elemShipped.add(elemOption3);
elemOption3 = new Option("No","No&quot

;
elemShipped.add(elemOption3);

elemOption4 = new Option("Yes","Yes&quot

;
elemRcvd15Day.add(elemOption4);
elemOption4 = new Option("No","No&quot

;
elemRcvd15Day.add(elemOption4);

elemOption5 = new Option("Yes","Yes&quot

;
elemCrdtToBeIssd.add(elemOption5);
elemOption5 = new Option("No","No&quot

;
elemCrdtToBeIssd.add(elemOption5);

elemOption6 = new Option("Yes","Yes&quot

;
elemCustRestockingFee.add(elemOption6);
elemOption6 = new Option("No","No&quot

;
elemCustRestockingFee.add(elemOption6);

elemOption7 = new Option("No","No&quot

;
elemUnreturnableToSupp.add(elemOption7);
elemOption7 = new Option("Yes","Yes&quot

;
elemUnreturnableToSupp.add(elemOption7);

//add the inputs to the appropriate cells
elemCols[0].appendChild(elemPartNumber);
elemCols[1].appendChild(elemQty);
elemCols[2].appendChild(elemDealer);
elemCols[3].appendChild(elemMercValue);
elemCols[4].appendChild(elemReason);
elemCols[5].appendChild(elemShipped);
elemCols[6].appendChild(elemRcvd15Day);
elemCols[7].appendChild(elemCrdtToBeIssd);
elemCols[8].appendChild(elemCustRestockingFee);
elemCols[9].appendChild(elemUnreturnableToSupp);
elemCols[10].appendChild(elemExNumber);

//add the cols to the row
elemRow.appendChild(elemCols[0]);
elemRow.appendChild(elemCols[1]);
elemRow.appendChild(elemCols[2]);
elemRow.appendChild(elemCols[3]);
elemRow.appendChild(elemCols[4]);
elemRow.appendChild(elemCols[5]);
elemRow.appendChild(elemCols[6]);
elemRow.appendChild(elemCols[7]);
elemRow.appendChild(elemCols[8]);
elemRow.appendChild(elemCols[9]);
elemRow.appendChild(elemCols[10]);

//add the row to the tbody tag
elemTbody.appendChild(elemRow);

//increment recordCount and update hdnRecordCount input
recordCount++;
document.getElementById("recCount&quot

.value = recordCount;

}
// end of AddRow function block

//-->
</script>

bikebanditcom · Aug 4, 2003