HELP!! dynamic querystring, dynamic input fields

[pingsheng]

Dear all,

I have a form with dynamically created input fields. These fields go to next page for submitting into SQL database. The thing is all fields are the same but 4 fields. So each record must be submitted with a unique key, while everything is the same, these 4 fields must be different....

Idealy, these are the codes. please teach me how to do it.

 
objConn.Open(sConnection) 
 
sRowNum = request.querystring("row_num")
 
While sRowNum > 0 
 
sDefectCode = request.querystring("defect_code[sRowNum]")
sDefect_descr = request.querystring("defect_descr[sRowNum]")
sPart_num = request.querystring("part_num[sRowNum]")
sPart_qty = request.querystring("part_qty[sRowNum]")
 
 
strInsertSql = "insert into table1"
strInsertSql = strInsertSql& "(the_key, org_num,dealer_name,dealer_phone,reg_date,submit_name,cus_firstname,cus_lastname,cus_phone,cus_street_address,cus_post_code,cus_city,cus_country,cus_person_num,which_machine,which_model,vin_num,machine_reg_num,purchase_date,defect_code,part_num,part_qty,descr,comm,mileage,labor_hr,claim_date) values("
strInsertSql = strInsertSql& "'"& request.querystring("the_key")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("org_num")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("dealer_name")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("dealer_phone")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("reg_date")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("submit_name")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("cus_firstname")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("cus_lastname")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("cus_phone")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("cus_street_address")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("cus_post_code")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("cus_city")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("cus_country")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("cus_person_num")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("which_machine")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("which_model")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("vin_num")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("reg_num")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("purchase_date")&"',"
strInsertSql = strInsertSql& "'sDefectCode',"
strInsertSql = strInsertSql& "'sPart_num',"
strInsertSql = strInsertSql& "'sPart_qty',"
strInsertSql = strInsertSql& "'sDefect_descr',"
strInsertSql = strInsertSql& "'"& request.querystring("comm")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("mileage")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("labor_hr")&"',"
strInsertSql = strInsertSql& "'"& request.querystring("claim_date")&"'"
strInsertSql = strInsertSql&")"
 
objConn.Execute(strInsertSql)
 
sThe_key = sThe_Key + 1
sRowNum = sRowNum - 1
 
wend
 

[omerbutt]

sorry but ciould not get you what youwant the record you are inserting here is insilde a while loop and of course they will have a unique key but after they are inserted and sql will do it automatically if you have the primary key in it
sorry if i got you wrong ....then
and yes your these lines

strInsertSql = "insert into table1"
strInsertSql = strInsertSql& "(the_key, 
 

that "the_key" i think that is the primary key i was talking about you donot need to assign it any value it will be givn automatically by the databases if and only if you have made that PRIMARYKEY ;)
regards ,
Omer Aslam

[jhardman]

I often do something like this when I make the dynamic inputs:

for x = 0 to 4 %>
   <input type="text" name="dynamicTextInput<%=x%>">
<%
next

then when I pull it up on the form handler:

for x = 0 to 4
   if request.form("dynamicTextInput"&x) <> "" then
      'insert record into the db
   end if
next

Let me know if this helps.

Jared

[pingsheng]

Jared,

You are awesome!! Thanks! worked like a charm.

Ken

I often do something like this when I make the dynamic inputs:

for x = 0 to 4 %>
   <input type="text" name="dynamicTextInput<%=x%>">
<%
next

then when I pull it up on the form handler:

for x = 0 to 4
   if request.form("dynamicTextInput"&x) <> "" then
      'insert record into the db
   end if
next

Let me know if this helps.

Jared