Pass values to stored procedure parameters from form where input values has changed

NarendraB · #1 (**permalink**) February 13th, 2019, 03:54 AM

I am working on a Classic ASP project where I am updating multiple records in a table with single Submit button. Each row has select box and text box and user can update all the rows. While sending parameters to stored procedure , I want to pass only those values where input values ( select box or text box ) have been changed. I can't figure how should I do that. sCycleTime(Id) and sComment(id) contains values of Select Box and Textbox of all the rows. sProfile(id) and sProcess_Step_Sequence(Id) are two id's binded in each Select box and Textbox. Eg: DrpDwn_1_4 and Txtbox_1_4 and so on...

Code:

 sQry = ""
    For Id = 0 to 22
    response.Write ("this is " & l_comments)
        If Trim(sProcess_Step_Sequence (Id)) <> "" Then
            If Trim(sQry) = "" Then
                sQry = sProfile(id) & "~" & sCycleTime(Id) & "`" & sProcess_Step_Sequence(Id) & "^" & sComment(id)
            Else
                sQry = sQry & "!" & sProfile(id) & "~" & sCycleTime(Id) & "`" & sProcess_Step_Sequence(Id)& "^" & sComment(id)
            End If

        End If
    Next

    objCommand.CommandText = "EXEC usp_UPDATE_Dual_Code_Cycle_Times_and_Comments '" & sQry & "' ; "

firstrankseoservices · #2 (**permalink**) Yesterday, 05:57 AM

We specialize in offering affordable SEO services for small business in very reasonable prices. We offer advance SEO services matching with your business needs and demands. We follow Google guidelines to improve and maintain website’s rankings. Our SEO professionals have rich experience and depth knowledge to bring your website’s rankings on the first page of Google and promise you to provide positive results. Our SEO services are very affordable but result oriented to generate more business leads. Our SEO Packages are completely unique, suitable in your budget and give you more chances to generate more business leads.

Need to download code?

Navigation