Why I lose certain values from array?

Posted by blankon91 on Programmers See other posts from Programmers or by blankon91
Published on 2012-06-07T04:54:34Z Indexed on 2012/06/07 10:48 UTC
Read the original article Hit count: 194

Filed under:
|
|

I've the code to input the values dynamically, when I use it to add the values for the first time, it's fine, but when I want to edit it, the old values didn't inserted on sql query but the new values inserted

Here is the example: http://i.stack.imgur.com/dwugS.jpg

here is the code:

============the function=================

sub ShowItemfgEdit(query,selItemName,defValue,num,cdisable)
        response.write "<select " & cdisable & " num=""" & num & """ id=""itemCombo"" name=""" & selItemName & """ class=""label"" onchange=""varUsage.ChangeSatuanDt(this)"">"
        if NOT query.BOF then
            query.moveFirst
            WHILE NOT query.EOF
                tulis = ""
                if trim(defValue) = trim(query("ckdbarang")) then
                    tulis = "selected"
                end if
                response.write "<option value=""" & trim(query("ckdbarang")) & """" & tulis & ">" & trim(query("ckdbarang")) & " - " & trim(query("vnamabarang"))
                query.moveNext
            WEND
        end if
        response.write "</select>"
    end sub 

============calling the function================

<td class="rb" align="left"><% call ShowItemfgEdit(qGetItemfgGrp,"fitem",qGetUsageDt("ckdfg"),countLine,readonlyfg) %></td>

==============post the value======================

<input type="hidden" name="fitem" value="">

================get the value===================

for i = 1 to request.form("hdnOrderNum")
        if request.form("selOrdItem_" & i) <> "" then

            'bla...blaa...blaa...

            ckdfg = trim(request.form("fitem_" & i)) '<==here is the problem


            objCommand.commandText = "INSERT INTO IcTrPakaiDt " &_
                                        "(id, id_h, ckdunitkey, cnopakai, dtglpakai, ckdbarang, ckdgudang, nqty1, nqty2, csatuan1, csatuan2, nqtypakai, csatuanpakai, vketerangan, cJnsPakai, ckdprodkey, ckdfg, ncountstart, ncountstop, ncounttotal) " &_
                                        " VALUES " &_
                                        " (" & idDt & ",'" & idHd & "','" & selLoc & "','" & nopakai & "','" & cDate(request.form("hdnUsageDate")) & "','" & trim(ckdbarang) & "','" & trim(ckdgudang) & "'," & nqty1 & "," & nqty2 & ",'" & trim(csatuan1) & "','" & trim(csatuan2) & "'," & nqtypakai & ",'" & csatuanpakai & "','" & trim(keteranganItem) & "','" & trim(cjnspakai) & "','" & ckdprodkey & "','" &ckdfg& "'," & cnt1 & "," & cnt2 & "," & totalcnt & ")"
            set qInsertPakaiDt = objCommand.Execute

        end if
    next

problem: old value of ckdfg didn't inserted to query, but the new value inserted. How to fix this bug?

© Programmers or respective owner

Related posts about ASP.NET

Related posts about array